APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_PO_RESCHEDULE_INTERFACE

Line 699: /* DELETE MSC_PO_RESCHEDULE_INTERFACE

695:
696: EXECUTE IMMEDIATE lv_sql_stmt
697: USING OUT arg_req_resched_id;
698:
699: /* DELETE MSC_PO_RESCHEDULE_INTERFACE
700: WHERE sr_instance_id= arg_org_instance;
701: */
702: END IF;
703:

Line 775: select source_line_id from msc_po_reschedule_interface

771: UNION ALL
772: select source_line_id from msc_po_requisitions_interface
773: where sr_instance_id = arg_org_instance
774: UNION ALL
775: select source_line_id from msc_po_reschedule_interface
776: where sr_instance_id = arg_org_instance
777: )
778: AND load_type BETWEEN WIP_DIS_MASS_LOAD AND PO_MASS_RESCHEDULE;
779:

Line 792: DELETE MSC_PO_RESCHEDULE_INTERFACE

788: DELETE MSC_PO_REQUISITIONS_INTERFACE
789: WHERE sr_instance_id= arg_org_instance
790: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
791:
792: DELETE MSC_PO_RESCHEDULE_INTERFACE
793: WHERE sr_instance_id= arg_org_instance;
794:
795:
796:

Line 816: DELETE MSC_PO_RESCHEDULE_INTERFACE

812: WHERE sr_instance_id= arg_org_instance
813: AND NVL(BATCH_ID, -1) = NVL(arg_po_batch_number, -1);
814:
815:
816: DELETE MSC_PO_RESCHEDULE_INTERFACE
817: WHERE sr_instance_id= arg_org_instance;
818: commit;
819: raise;
820: