APPS.MRP_FORECAST_INTERFACE_PK dependencies on MRP_FORECAST_ITEMS

Line 546: FROM mrp_forecast_items

542:
543: BEGIN
544:
545: SELECT 1 INTO record_exists
546: FROM mrp_forecast_items
547: WHERE organization_id = forecast_interface(counter).organization_id
548: AND inventory_item_id = forecast_interface(counter).inventory_item_id
549: AND forecast_designator = forecast_interface(counter).forecast_designator;
550:

Line 553: INSERT INTO mrp_forecast_items

549: AND forecast_designator = forecast_interface(counter).forecast_designator;
550:
551: EXCEPTION
552: WHEN no_data_found THEN
553: INSERT INTO mrp_forecast_items
554: (
555: inventory_item_id,
556: organization_id,
557: forecast_designator,

Line 640: delete from mrp_forecast_items

636:
637: BEGIN
638:
639: IF tab_forecast_designator(counter).inventory_item_id IS NULL THEN
640: delete from mrp_forecast_items
641: where forecast_designator =
642: tab_forecast_designator(counter).forecast_designator
643: and organization_id =
644: tab_forecast_designator(counter).organization_id;

Line 646: delete from mrp_forecast_items

642: tab_forecast_designator(counter).forecast_designator
643: and organization_id =
644: tab_forecast_designator(counter).organization_id;
645: ELSE
646: delete from mrp_forecast_items
647: where forecast_designator =
648: tab_forecast_designator(counter).forecast_designator
649: and organization_id =
650: tab_forecast_designator(counter).organization_id

Line 660: -- ' has no rows in mrp_forecast_items');

656: -- IF mrdebug = TRUE THEN
657: -- dbms_output.put_line('Forecast designator/Org '||
658: -- tab_forecast_designator(counter).forecast_designator||'/'||
659: -- to_char(tab_forecast_designator(counter).organization_id) ||
660: -- ' has no rows in mrp_forecast_items');
661: -- END IF;
662: -- END IF;
663: END;
664: