APPS.MRP_FORECAST_INTERFACE_PK dependencies on MRP_FORECAST_DATES

Line 66: SELECT mrp_forecast_dates_s.nextval

62: p_result varchar2(1);
63: errcode VARCHAR2(240);
64: record_exists NUMBER;
65: BEGIN
66: SELECT mrp_forecast_dates_s.nextval
67: INTO var_max_trx_id
68: FROM dual;
69:
70: var_low_index := forecast_interface.first;

Line 192: DELETE FROM mrp_Forecast_dates

188: /* change for Bug 1849709 */
189: IF forecast_interface(counter).action = 'U' OR
190: forecast_interface(counter).action = 'D' THEN
191: IF forecast_interface(counter).transaction_id IS NOT NULL THEN
192: DELETE FROM mrp_Forecast_dates
193: WHERE transaction_id = forecast_interface(counter).transaction_id
194: and organization_id =
195: forecast_interface(counter).organization_id
196: and forecast_designator =

Line 448: INSERT INTO mrp_forecast_dates

444: -- forecast_interface(counter).forecast_designator);
445:
446: /* 1336039 - SVAIDYAN: Insert attribute_category also. */
447:
448: INSERT INTO mrp_forecast_dates
449: (
450: transaction_id,
451: last_update_date,
452: last_updated_by,

Line 496: mrp_forecast_dates_s.nextval),

492: attribute_category)
493: VALUES
494: (
495: NVL(forecast_interface(counter).transaction_id,
496: mrp_forecast_dates_s.nextval),
497: SYSDATE,
498: NVL(forecast_interface(counter).last_updated_by, -1),
499: SYSDATE,
500: NVL(forecast_interface(counter).created_by, -1),

Line 611: delete from mrp_forecast_dates

607: LOOP
608: BEGIN
609:
610: IF tab_forecast_designator(counter).inventory_item_id IS NULL THEN
611: delete from mrp_forecast_dates
612: where forecast_designator =
613: tab_forecast_designator(counter).forecast_designator
614: and organization_id =
615: tab_forecast_designator(counter).organization_id;

Line 618: delete from mrp_forecast_dates

614: and organization_id =
615: tab_forecast_designator(counter).organization_id;
616:
617: ELSE
618: delete from mrp_forecast_dates
619: where forecast_designator =
620: tab_forecast_designator(counter).forecast_designator
621: and organization_id =
622: tab_forecast_designator(counter).organization_id

Line 632: -- ' has no rows in mrp_forecast_dates');

628: -- IF mrdebug = TRUE THEN
629: -- dbms_output.put_line('Forecast designator/Org '||
630: -- tab_forecast_designator(counter).forecast_designator||'/'||
631: -- to_char(tab_forecast_designator(counter).organization_id) ||
632: -- ' has no rows in mrp_forecast_dates');
633: -- END IF;
634: -- END IF;
635: END;
636: