[Home] [Help]
2406:
2407: END IF; */
2408:
2409: /* IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2410: DELETE msc_wip_job_schedule_interface
2411: WHERE sr_instance_id= arg_org_instance;
2412:
2413: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2414: WHERE sr_instance_id= arg_org_instance;
2659: and sr_instance_id = arg_org_instance;
2660: END IF; -- lv_wf
2661:
2662: IF fnd_profile.value('MSC_RETAIN_RELEASED_DATA') ='N' THEN
2663: DELETE msc_wip_job_schedule_interface
2664: WHERE sr_instance_id= arg_org_instance
2665: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2666:
2667: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2682:
2683: EXCEPTION WHEN OTHERS THEN
2684: rollback; /* Rollback whatever was released */
2685:
2686: DELETE msc_wip_job_schedule_interface
2687: WHERE sr_instance_id= arg_org_instance
2688: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2689:
2690: DELETE MSC_WIP_JOB_DTLS_INTERFACE
4505:
4506:
4507:
4508: FORALL j IN 1..lv_job_count
4509: INSERT INTO msc_wip_job_schedule_interface
4510: (last_update_date,
4511: cfm_routing_flag,
4512: last_updated_by,
4513: last_update_login,
5434: -- ------------------------------------------------------------------------
5435: -- Perform the lot based job reschedule
5436: -- ------------------------------------------------------------------------
5437: FORALL j in 1..lv_resched_jobs
5438: INSERT INTO msc_wip_job_schedule_interface
5439: (last_update_date,
5440: last_updated_by,
5441: cfm_routing_flag,
5442: last_update_login,
6585: End Loop;
6586:
6587:
6588: FORALL j IN 1..lv_job_count
6589: INSERT INTO msc_wip_job_schedule_interface
6590: (last_update_date,
6591: last_updated_by,
6592: last_update_login,
6593: creation_date,
8158:
8159: End Loop;
8160:
8161: FORALL j IN 1..lv_job_count
8162: INSERT INTO msc_wip_job_schedule_interface
8163: (last_update_date,
8164: last_updated_by,
8165: last_update_login,
8166: creation_date,
9343:
9344: -- ------------------------------------------------------------------------
9345: -- Perform the wip repetitive schedule mass load
9346: -- ------------------------------------------------------------------------
9347: l_sql_stmt := ' INSERT INTO msc_wip_job_schedule_interface
9348: (last_update_date,
9349: last_updated_by,
9350: last_update_login,
9351: creation_date,
9477: update msc_supplies
9478: set releasable = RELEASE_ATTEMPTED
9479: ,batch_id = nvl(batch_id,g_batch_id)
9480: where plan_id = arg_plan_id
9481: and transaction_id in (select source_line_id from msc_wip_job_schedule_interface
9482: where group_id = arg_wip_group_id);
9483: END IF;
9484:
9485: RETURN lv_loaded_scheds;
10384: orig_net_qty NUMBER;
10385: CURSOR c_count(p_arg_wip_group_id number ) is
10386: select count(*) loaded_jobs
10387: ,maintenance_object_source
10388: from msc_wip_job_schedule_interface
10389: where group_id = p_arg_wip_group_id*-1
10390: and load_type = CMRO_EAM_MASS_LOAD
10391: group by maintenance_object_source;
10392:
10410: IF(gv_auto_release = 1) THEN
10411: -- Auto release, we need to delete the records in the
10412: -- source table AHL_REQ_SUPPLY_SCHEDULE for the items
10413: -- planned in the plan. Hence, we are inserting a record
10414: -- into msc_wip_job_schedule_interface for all items in the
10415: -- plan with a start_quantity of -23453.
10416:
10417:
10418: INSERT INTO MSC_WIP_JOB_SCHEDULE_INTERFACE
10414: -- into msc_wip_job_schedule_interface for all items in the
10415: -- plan with a start_quantity of -23453.
10416:
10417:
10418: INSERT INTO MSC_WIP_JOB_SCHEDULE_INTERFACE
10419: (
10420: last_update_date,
10421: last_updated_by,
10422: creation_date,
10555: -- -----------------------------------------------------------------------
10556:
10557:
10558: FORALL j IN 1..lv_job_count
10559: INSERT INTO msc_wip_job_schedule_interface
10560: (last_update_date,
10561: last_updated_by,
10562: last_update_login,
10563: creation_date,
10953:
10954: End Loop;
10955:
10956: FORALL j IN 1..lv_job_count
10957: INSERT INTO msc_wip_job_schedule_interface
10958: (last_update_date,
10959: last_updated_by,
10960: last_update_login,
10961: creation_date,
12282:
12283: End Loop;
12284:
12285: FORALL j IN 1..lv_job_count
12286: INSERT INTO msc_wip_job_schedule_interface
12287: (last_update_date,
12288: last_updated_by,
12289: last_update_login,
12290: creation_date,
13488: BEGIN
13489: -- First Update the header records;
13490: begin
13491:
13492: UPDATE MSC_WIP_JOB_SCHEDULE_INTERFACE
13493: SET
13494: first_unit_start_date =
13495: trunc(first_unit_start_date) + v_rp_time,
13496: last_unit_completion_date =