[Home] [Help]
1086: WHERE wip_entity_id = p_wip_entity_id;
1087:
1088: end if; --End of check on p_new_job before deleting the copy tables
1089:
1090: DELETE WSM_LOT_BASED_JOBS
1091: WHERE wip_entity_id = p_wip_entity_id
1092: RETURNING current_job_op_seq_num,current_rtg_op_seq_num,first_serial_txn_id
1093: INTO l_curr_job_op_seq_num,l_curr_rtg_op_seq_num,l_first_serial_txn_id;
1094: -- ST : Added first_serial_txn_id in the above statement for bug fix 5171286
1439: x_err_buf := 'l_count is'||to_char(l_start_op_seq_id);
1440: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1441: x_err_code := -1; -- Warning
1442: --Bug 4264364:Added exception handling
1443: INSERT into WSM_LOT_BASED_JOBS
1444: (WIP_ENTITY_ID,
1445: ORGANIZATION_ID,
1446: ON_REC_PATH,
1447: INTERNAL_COPY_TYPE,
1492: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1493: x_err_code := -1; -- Warning
1494:
1495: --Bug 4264364:Added exception handling
1496: INSERT into WSM_LOT_BASED_JOBS
1497: (WIP_ENTITY_ID,
1498: ORGANIZATION_ID,
1499: ON_REC_PATH,
1500: INTERNAL_COPY_TYPE,
3550: <
3551:
3552: l_stmt_num := 300;
3553:
3554: -- ***** Create a record in wsm_lot_based_jobs ***** --
3555: Get_Job_Curr_Op_Info(p_wip_entity_id => p_wip_entity_id,
3556: p_op_seq_num => l_curr_op_seq_num,
3557: p_op_seq_id => l_curr_op_seq_id,
3558: p_std_op_id => l_curr_op_std_op_id,
3646: from wsm_parameters
3647: where ORGANIZATION_ID = p_org_id;
3648: END IF;
3649:
3650: INSERT into WSM_LOT_BASED_JOBS
3651: (WIP_ENTITY_ID,
3652: ORGANIZATION_ID,
3653: ON_REC_PATH,
3654: INTERNAL_COPY_TYPE,
3694: l_first_serial_txn_id -- ST : Added first_serial_txn_id in the above statement for bug fix 5171286
3695: );
3696:
3697: IF (SQL%ROWCOUNT = 0) THEN
3698: -- No record created in WSM_LOT_BASED_JOBS
3699: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3700: x_err_buf := fnd_message.get;
3701: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3702: x_err_code := -2; -- Error
3942:
3943: DELETE WSM_COPY_REQUIREMENT_OPS
3944: WHERE wip_entity_id = p_new_wip_entity_id;
3945: */
3946: DELETE WSM_LOT_BASED_JOBS
3947: WHERE wip_entity_id = p_new_wip_entity_id;
3948:
3949: -- ***** Make a copy of the Network for the job ***** --
3950: l_stmt_num := 20;
4608: -- Hence, copying the resource usages from the Rep Job would be incorrect.
4609:
4610: l_stmt_num := 60;
4611:
4612: -- ***** Create a record in wsm_lot_based_jobs ***** --
4613: INSERT into WSM_LOT_BASED_JOBS
4614: (WIP_ENTITY_ID,
4615: ORGANIZATION_ID,
4616: ON_REC_PATH,
4609:
4610: l_stmt_num := 60;
4611:
4612: -- ***** Create a record in wsm_lot_based_jobs ***** --
4613: INSERT into WSM_LOT_BASED_JOBS
4614: (WIP_ENTITY_ID,
4615: ORGANIZATION_ID,
4616: ON_REC_PATH,
4617: INTERNAL_COPY_TYPE,
4652: SERIALIZATION_START_OP,
4653: FIRST_SERIAL_TXN_ID, --To avoid joining with the parent job
4654: CURRENT_JOB_OP_SEQ_NUM,
4655: CURRENT_RTG_OP_SEQ_NUM
4656: FROM WSM_LOT_BASED_JOBS
4657: WHERE wip_entity_id = p_rep_wip_entity_id;
4658:
4659:
4660:
4669: SELECT ON_REC_PATH,
4670: organization_id
4671: INTO l_on_rec_path,
4672: l_org_id
4673: FROM WSM_LOT_BASED_JOBS
4674: WHERE wip_entity_id = p_new_wip_entity_id;
4675:
4676: l_stmt_num := 80;
4677:
4866: AND wdj.organization_id = we.organization_id
4867: AND wdj.wip_entity_id = we.wip_entity_id
4868: AND wdj.status_type IN (1, 3, 4, 6) --Unreleased, Released, Complete, OnHold
4869: AND NOT EXISTS (select 1 -- To make sure same set of jobs is not picked up again
4870: from wsm_lot_based_jobs wlbj
4871: where wlbj.wip_entity_id = wdj.wip_entity_id
4872: )
4873: ORDER BY we.wip_entity_id -- Slows down the SQL prepare
4874: ;
5083:
5084: DELETE WSM_COPY_REQUIREMENT_OPS
5085: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5086:
5087: DELETE WSM_LOT_BASED_JOBS
5088: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5089:
5090: l_stmt_num := 100;
5091:
5088: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5089:
5090: l_stmt_num := 100;
5091:
5092: INSERT into WSM_LOT_BASED_JOBS
5093: (WIP_ENTITY_ID,
5094: ORGANIZATION_ID,
5095: ON_REC_PATH,
5096: INTERNAL_COPY_TYPE,