APPS.MRP_FORECAST_INTERFACE_PK dependencies on MRP_FORECAST_ITEMS

Line 541: FROM mrp_forecast_items

537:
538: BEGIN
539:
540: SELECT 1 INTO record_exists
541: FROM mrp_forecast_items
542: WHERE organization_id = forecast_interface(counter).organization_id
543: AND inventory_item_id = forecast_interface(counter).inventory_item_id
544: AND forecast_designator = forecast_interface(counter).forecast_designator;
545:

Line 548: INSERT INTO mrp_forecast_items

544: AND forecast_designator = forecast_interface(counter).forecast_designator;
545:
546: EXCEPTION
547: WHEN no_data_found THEN
548: INSERT INTO mrp_forecast_items
549: (
550: inventory_item_id,
551: organization_id,
552: forecast_designator,

Line 635: delete from mrp_forecast_items

631:
632: BEGIN
633:
634: IF tab_forecast_designator(counter).inventory_item_id IS NULL THEN
635: delete from mrp_forecast_items
636: where forecast_designator =
637: tab_forecast_designator(counter).forecast_designator
638: and organization_id =
639: tab_forecast_designator(counter).organization_id;

Line 641: delete from mrp_forecast_items

637: tab_forecast_designator(counter).forecast_designator
638: and organization_id =
639: tab_forecast_designator(counter).organization_id;
640: ELSE
641: delete from mrp_forecast_items
642: where forecast_designator =
643: tab_forecast_designator(counter).forecast_designator
644: and organization_id =
645: tab_forecast_designator(counter).organization_id

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

651: -- IF mrdebug = TRUE THEN
652: -- dbms_output.put_line('Forecast designator/Org '||
653: -- tab_forecast_designator(counter).forecast_designator||'/'||
654: -- to_char(tab_forecast_designator(counter).organization_id) ||
655: -- ' has no rows in mrp_forecast_items');
656: -- END IF;
657: -- END IF;
658: END;
659: