[Home] [Help]
10808: IF api_mode
10809: THEN
10810: BEGIN
10811: statement_demands_api :=
10812: ' INSERT INTO gmp_demands_api ( '
10813: ||' organization_id, schedule_id, inventory_item_id, demand_date, '
10814: ||' demand_quantity, origination_type, doc_id, selling_price ) '
10815: ||' VALUES '
10816: ||' ( :p1, :p2, :p3, :p4, '
10827: pnet_price;
10828:
10829: EXCEPTION
10830: WHEN OTHERS THEN
10831: log_message('Failure occured during the insert into gmp_demands_api');
10832: log_message(sqlerrm);
10833: RAISE;
10834: END;
10835: ELSE
11906: * This version is set up with the proper parameters to be called as from the
11907: * concurrent manager. In addition, the main difference is the table into
11908: * which demands are inserted. The standard procedure inserts into
11909: * msc_st_demands.
11910: * This new procedure inserts into gmp_demands_api. The difference between
11911: * the two tables is the addition of a schedule_id column in
11912: * gmp_demands_api. Also, this version of sales_forecast begins by
11913: * truncating gmp_demands_api and leaves it populated after
11914: * it completes. By contrast, msc_st_demands (which is an APS staging table)
11908: * which demands are inserted. The standard procedure inserts into
11909: * msc_st_demands.
11910: * This new procedure inserts into gmp_demands_api. The difference between
11911: * the two tables is the addition of a schedule_id column in
11912: * gmp_demands_api. Also, this version of sales_forecast begins by
11913: * truncating gmp_demands_api and leaves it populated after
11914: * it completes. By contrast, msc_st_demands (which is an APS staging table)
11915: * is immediately truncated after APS reads its data. This difference allows
11916: * gmp_demands_api to be a general purpose version of msc_st_demands.
11909: * msc_st_demands.
11910: * This new procedure inserts into gmp_demands_api. The difference between
11911: * the two tables is the addition of a schedule_id column in
11912: * gmp_demands_api. Also, this version of sales_forecast begins by
11913: * truncating gmp_demands_api and leaves it populated after
11914: * it completes. By contrast, msc_st_demands (which is an APS staging table)
11915: * is immediately truncated after APS reads its data. This difference allows
11916: * gmp_demands_api to be a general purpose version of msc_st_demands.
11917: *
11912: * gmp_demands_api. Also, this version of sales_forecast begins by
11913: * truncating gmp_demands_api and leaves it populated after
11914: * it completes. By contrast, msc_st_demands (which is an APS staging table)
11915: * is immediately truncated after APS reads its data. This difference allows
11916: * gmp_demands_api to be a general purpose version of msc_st_demands.
11917: *
11918: * HISTORY
11919: * P. Dong
11920: * 09/14/01 - Created
11936: instance => NULL,
11937: run_date => p_run_date,
11938: return_status => lv_cp_enabled );
11939:
11940: DELETE FROM gmp_demands_api;
11941:
11942: lv_cp_enabled := p_cp_enabled;
11943:
11944: sales_forecast(
13891: IF sapi_mode
13892: THEN
13893: BEGIN
13894: statement_demands_api :=
13895: ' INSERT INTO gmp_demands_api ( '
13896: ||' organization_id, schedule_id, inventory_item_id, demand_date, '
13897: ||' demand_quantity, origination_type, doc_id, selling_price ) '
13898: ||' VALUES '
13899: ||' ( :p1, :p2, :p3, :p4, '
13914: gso_cnt := pcounter + 1 ;
13915:
13916: EXCEPTION
13917: WHEN OTHERS THEN
13918: log_message('Failure occured during the insert into gmp_demands_api');
13919: log_message(sqlerrm);
13920: RAISE;
13921: END;
13922: ELSE
13996: IF fapi_mode
13997: THEN
13998: BEGIN
13999: statement_demands_api :=
14000: ' INSERT INTO gmp_demands_api ( '
14001: ||' organization_id, schedule_id, inventory_item_id, demand_date, '
14002: ||' demand_quantity, origination_type, doc_id, selling_price ) '
14003: ||' VALUES '
14004: ||' ( :p1, :p2, :p3, :p4, '
14019: gfcst_cnt := pcounter + 1 ;
14020:
14021: EXCEPTION
14022: WHEN OTHERS THEN
14023: log_message('Failure occured during the insert into gmp_demands_api');
14024: log_message(sqlerrm);
14025: RAISE;
14026: END;
14027: ELSE