APPS.MSC_REL_PLAN_PUB dependencies on MSC_WIP_JOB_SCHEDULE_INTERFACE

Line 1960: /* DELETE msc_wip_job_schedule_interface

1956:
1957: END IF; */
1958:
1959:
1960: /* DELETE msc_wip_job_schedule_interface
1961: WHERE sr_instance_id= arg_org_instance;
1962:
1963: DELETE MSC_WIP_JOB_DTLS_INTERFACE
1964: WHERE sr_instance_id= arg_org_instance;

Line 2131: DELETE msc_wip_job_schedule_interface

2127: WHERE batch_id = g_batch_id
2128: and sr_instance_id = arg_org_instance;
2129: END IF; -- lv_wf
2130:
2131: DELETE msc_wip_job_schedule_interface
2132: WHERE sr_instance_id= arg_org_instance
2133: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2134:
2135: DELETE MSC_WIP_JOB_DTLS_INTERFACE

Line 2153: DELETE msc_wip_job_schedule_interface

2149:
2150: EXCEPTION WHEN OTHERS THEN
2151: rollback; /* Rollback whatever was released */
2152:
2153: DELETE msc_wip_job_schedule_interface
2154: WHERE sr_instance_id= arg_org_instance
2155: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2156:
2157: DELETE MSC_WIP_JOB_DTLS_INTERFACE

Line 3960: INSERT INTO msc_wip_job_schedule_interface

3956:
3957:
3958:
3959: FORALL j IN 1..lv_job_count
3960: INSERT INTO msc_wip_job_schedule_interface
3961: (last_update_date,
3962: cfm_routing_flag,
3963: last_updated_by,
3964: last_update_login,

Line 4882: INSERT INTO msc_wip_job_schedule_interface

4878: -- ------------------------------------------------------------------------
4879: -- Perform the lot based job reschedule
4880: -- ------------------------------------------------------------------------
4881: FORALL j in 1..lv_resched_jobs
4882: INSERT INTO msc_wip_job_schedule_interface
4883: (last_update_date,
4884: last_updated_by,
4885: cfm_routing_flag,
4886: last_update_login,

Line 5957: INSERT INTO msc_wip_job_schedule_interface

5953: End Loop;
5954:
5955:
5956: FORALL j IN 1..lv_job_count
5957: INSERT INTO msc_wip_job_schedule_interface
5958: (last_update_date,
5959: last_updated_by,
5960: last_update_login,
5961: creation_date,

Line 7399: INSERT INTO msc_wip_job_schedule_interface

7395:
7396: End Loop;
7397:
7398: FORALL j IN 1..lv_job_count
7399: INSERT INTO msc_wip_job_schedule_interface
7400: (last_update_date,
7401: last_updated_by,
7402: last_update_login,
7403: creation_date,

Line 8504: l_sql_stmt := ' INSERT INTO msc_wip_job_schedule_interface

8500:
8501: -- ------------------------------------------------------------------------
8502: -- Perform the wip repetitive schedule mass load
8503: -- ------------------------------------------------------------------------
8504: l_sql_stmt := ' INSERT INTO msc_wip_job_schedule_interface
8505: (last_update_date,
8506: last_updated_by,
8507: last_update_login,
8508: creation_date,

Line 8638: and transaction_id in (select source_line_id from msc_wip_job_schedule_interface

8634: update msc_supplies
8635: set releasable = RELEASE_ATTEMPTED
8636: ,batch_id = nvl(batch_id,g_batch_id)
8637: where plan_id = arg_plan_id
8638: and transaction_id in (select source_line_id from msc_wip_job_schedule_interface
8639: where group_id = arg_wip_group_id);
8640: END IF;
8641:
8642: RETURN lv_loaded_scheds;