APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_WIP_JOB_SCHEDULE_INTERFACE

Line 645: /* DELETE msc_wip_job_schedule_interface

641: USING OUT arg_osfm_req_id;
642:
643:
644: END IF;
645: /* DELETE msc_wip_job_schedule_interface
646: WHERE sr_instance_id= arg_org_instance;
647:
648: DELETE MSC_WIP_JOB_DTLS_INTERFACE
649: WHERE sr_instance_id= arg_org_instance;

Line 769: (select header_id from msc_wip_job_schedule_interface

765: AND plan_id = arg_plan_id
766: AND release_status = 1
767: AND release_errors IS NULL
768: AND transaction_id in
769: (select header_id from msc_wip_job_schedule_interface
770: where sr_instance_id = arg_org_instance
771: UNION ALL
772: select source_line_id from msc_po_requisitions_interface
773: where sr_instance_id = arg_org_instance

Line 780: DELETE msc_wip_job_schedule_interface

776: where sr_instance_id = arg_org_instance
777: )
778: AND load_type BETWEEN WIP_DIS_MASS_LOAD AND PO_MASS_RESCHEDULE;
779:
780: DELETE msc_wip_job_schedule_interface
781: WHERE sr_instance_id= arg_org_instance
782: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
783:
784: DELETE MSC_WIP_JOB_DTLS_INTERFACE

Line 803: DELETE msc_wip_job_schedule_interface

799:
800: EXCEPTION WHEN OTHERS THEN
801: rollback; /* Rollback whatever was released */
802:
803: DELETE msc_wip_job_schedule_interface
804: WHERE sr_instance_id= arg_org_instance
805: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
806:
807: DELETE MSC_WIP_JOB_DTLS_INTERFACE

Line 965: INSERT INTO msc_wip_job_schedule_interface

961:
962:
963:
964: FORALL j IN 1..lv_job_count
965: INSERT INTO msc_wip_job_schedule_interface
966: (last_update_date,
967: cfm_routing_flag,
968: last_updated_by,
969: last_update_login,

Line 1821: INSERT INTO msc_wip_job_schedule_interface

1817: -- ------------------------------------------------------------------------
1818: -- Perform the lot based job reschedule
1819: -- ------------------------------------------------------------------------
1820: FORALL j in 1..lv_resched_jobs
1821: INSERT INTO msc_wip_job_schedule_interface
1822: (last_update_date,
1823: last_updated_by,
1824: cfm_routing_flag,
1825: last_update_login,

Line 2760: INSERT INTO msc_wip_job_schedule_interface

2756:
2757:
2758:
2759: FORALL j IN 1..lv_job_count
2760: INSERT INTO msc_wip_job_schedule_interface
2761: (last_update_date,
2762: last_updated_by,
2763: last_update_login,
2764: creation_date,

Line 3852: INSERT INTO msc_wip_job_schedule_interface

3848:
3849:
3850:
3851: FORALL j IN 1..lv_job_count
3852: INSERT INTO msc_wip_job_schedule_interface
3853: (last_update_date,
3854: last_updated_by,
3855: last_update_login,
3856: creation_date,