1  Declare
 2       t_forecast_interface_tab    MRP_FORECAST_INTERFACE_PK.t_forecast_interface;
 3       t_forecast_designator_tab   MRP_FORECAST_INTERFACE_PK.t_forecast_designator;
 4       var_bool                    BOOLEAN;
 5  begin
 6  fnd_global.apps_initialize(679569,20454,704);
 7       t_forecast_interface_tab(1).inventory_item_id :=20004;
 8       t_forecast_interface_tab(1).forecast_designator := 'MER_FG_FCS';
 9       t_forecast_interface_tab(1).organization_id := 114;
10       t_forecast_interface_tab(1).forecast_date := sysdate;
11       t_forecast_interface_tab(1).bucket_type := 3;
12       t_forecast_interface_tab(1).quantity := 100;
13       t_forecast_interface_tab(1).process_status := 2;
14       t_forecast_interface_tab(1).confidence_percentage := 100;
15       t_forecast_designator_tab(1).organization_id := 114;
16       t_forecast_designator_tab(1).forecast_designator := 'MER_FG_FCS';
17       var_bool := MRP_FORECAST_INTERFACE_PK.MRP_FORECAST_INTERFACE (t_forecast_interface_tab);
18       dbms_output.put_line('Return Status = '||t_forecast_interface_tab(1).process_status);
19       dbms_output.put_line('Error Message = '||t_forecast_interface_tab(1).error_message);
20       commit;
21* end;
QL> /
eturn Status = 4
rror Message = You have entered an invalid organization value: 114

L/SQL procedure successfully completed.