APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_PO_RESCHEDULE_INTERFACE

Line 718: /* DELETE MSC_PO_RESCHEDULE_INTERFACE

714:
715: EXECUTE IMMEDIATE lv_sql_stmt
716: USING OUT arg_req_resched_id;
717:
718: /* DELETE MSC_PO_RESCHEDULE_INTERFACE
719: WHERE sr_instance_id= arg_org_instance;
720: */
721: END IF;
722:

Line 794: select source_line_id from msc_po_reschedule_interface

790: UNION ALL
791: select source_line_id from msc_po_requisitions_interface
792: where sr_instance_id = arg_org_instance
793: UNION ALL
794: select source_line_id from msc_po_reschedule_interface
795: where sr_instance_id = arg_org_instance
796: )
797: AND load_type BETWEEN WIP_DIS_MASS_LOAD AND PO_MASS_RESCHEDULE;
798:

Line 818: DELETE MSC_PO_RESCHEDULE_INTERFACE

814: DELETE MSC_PO_REQUISITIONS_INTERFACE
815: WHERE sr_instance_id= arg_org_instance
816: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
817:
818: DELETE MSC_PO_RESCHEDULE_INTERFACE
819: WHERE sr_instance_id= arg_org_instance;
820: END IF;
821:
822:

Line 842: DELETE MSC_PO_RESCHEDULE_INTERFACE

838: WHERE sr_instance_id= arg_org_instance
839: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
840:
841:
842: DELETE MSC_PO_RESCHEDULE_INTERFACE
843: WHERE sr_instance_id= arg_org_instance;
844: commit;
845: raise;
846: