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 443: INSERT INTO mrp_forecast_dates

439: -- forecast_interface(counter).forecast_designator);
440:
441: /* 1336039 - SVAIDYAN: Insert attribute_category also. */
442:
443: INSERT INTO mrp_forecast_dates
444: (
445: transaction_id,
446: last_update_date,
447: last_updated_by,

Line 491: mrp_forecast_dates_s.nextval),

487: attribute_category)
488: VALUES
489: (
490: NVL(forecast_interface(counter).transaction_id,
491: mrp_forecast_dates_s.nextval),
492: SYSDATE,
493: NVL(forecast_interface(counter).last_updated_by, -1),
494: SYSDATE,
495: NVL(forecast_interface(counter).created_by, -1),

Line 606: delete from mrp_forecast_dates

602: LOOP
603: BEGIN
604:
605: IF tab_forecast_designator(counter).inventory_item_id IS NULL THEN
606: delete from mrp_forecast_dates
607: where forecast_designator =
608: tab_forecast_designator(counter).forecast_designator
609: and organization_id =
610: tab_forecast_designator(counter).organization_id;

Line 613: delete from mrp_forecast_dates

609: and organization_id =
610: tab_forecast_designator(counter).organization_id;
611:
612: ELSE
613: delete from mrp_forecast_dates
614: where forecast_designator =
615: tab_forecast_designator(counter).forecast_designator
616: and organization_id =
617: tab_forecast_designator(counter).organization_id

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

623: -- IF mrdebug = TRUE THEN
624: -- dbms_output.put_line('Forecast designator/Org '||
625: -- tab_forecast_designator(counter).forecast_designator||'/'||
626: -- to_char(tab_forecast_designator(counter).organization_id) ||
627: -- ' has no rows in mrp_forecast_dates');
628: -- END IF;
629: -- END IF;
630: END;
631: