[Home] [Help]
660: EXECUTE IMMEDIATE lv_sql_stmt
661: USING OUT lv_resched_cmro_req_id;
662: END IF;*/
663:
664: /* DELETE msc_wip_job_schedule_interface
665: WHERE sr_instance_id= arg_org_instance;
666:
667: DELETE MSC_WIP_JOB_DTLS_INTERFACE
668: WHERE sr_instance_id= arg_org_instance;
784: AND plan_id = arg_plan_id
785: AND release_status = 1
786: AND release_errors IS NULL
787: AND transaction_id in
788: (select header_id from msc_wip_job_schedule_interface
789: where sr_instance_id = arg_org_instance
790: UNION ALL
791: select source_line_id from msc_po_requisitions_interface
792: where sr_instance_id = arg_org_instance
802: * set to YES
803: */
804:
805: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
806: DELETE msc_wip_job_schedule_interface
807: WHERE sr_instance_id= arg_org_instance
808: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
809:
810: DELETE MSC_WIP_JOB_DTLS_INTERFACE
825:
826: EXCEPTION WHEN OTHERS THEN
827: rollback; /* Rollback whatever was released */
828:
829: DELETE msc_wip_job_schedule_interface
830: WHERE sr_instance_id= arg_org_instance
831: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
832:
833: DELETE MSC_WIP_JOB_DTLS_INTERFACE
987:
988:
989:
990: FORALL j IN 1..lv_job_count
991: INSERT INTO msc_wip_job_schedule_interface
992: (last_update_date,
993: cfm_routing_flag,
994: last_updated_by,
995: last_update_login,
1844: -- ------------------------------------------------------------------------
1845: -- Perform the lot based job reschedule
1846: -- ------------------------------------------------------------------------
1847: FORALL j in 1..lv_resched_jobs
1848: INSERT INTO msc_wip_job_schedule_interface
1849: (last_update_date,
1850: last_updated_by,
1851: cfm_routing_flag,
1852: last_update_login,
2783:
2784:
2785:
2786: FORALL j IN 1..lv_job_count
2787: INSERT INTO msc_wip_job_schedule_interface
2788: (last_update_date,
2789: last_updated_by,
2790: last_update_login,
2791: creation_date,
3874: -- -----------------------------------------------------------------------
3875: -- Substitute component for reschedule order at the header level at WJSI
3876: -- -----------------------------------------------------------------------
3877: FORALL j IN 1..lv_job_count
3878: INSERT INTO msc_wip_job_schedule_interface
3879: (last_update_date,
3880: last_updated_by,
3881: last_update_login,
3882: creation_date,
4016: -- -----------------------------------------------------------------------
4017: -- Reschedule orders for WJSI CMRO Orders without altenate component at Header level
4018: -- -----------------------------------------------------------------------
4019: FORALL j IN 1..lv_job_count
4020: INSERT INTO msc_wip_job_schedule_interface
4021: (last_update_date,
4022: last_updated_by,
4023: last_update_login,
4024: creation_date,
4153: -- -----------------------------------------------------------------------
4154: -- Reschedule orders for WJSI EAM/Discrete
4155: -- -----------------------------------------------------------------------
4156: FORALL j IN 1..lv_job_count
4157: INSERT INTO msc_wip_job_schedule_interface
4158: (last_update_date,
4159: last_updated_by,
4160: last_update_login,
4161: creation_date,