[Home] [Help]
1087: WHERE wip_entity_id = p_wip_entity_id;
1088:
1089: end if; --End of check on p_new_job before deleting the copy tables
1090:
1091: DELETE WSM_LOT_BASED_JOBS
1092: WHERE wip_entity_id = p_wip_entity_id
1093: RETURNING current_job_op_seq_num,current_rtg_op_seq_num,first_serial_txn_id
1094: INTO l_curr_job_op_seq_num,l_curr_rtg_op_seq_num,l_first_serial_txn_id;
1095: -- ST : Added first_serial_txn_id in the above statement for bug fix 5171286
1440: x_err_buf := 'l_count is'||to_char(l_start_op_seq_id);
1441: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
1442: x_err_code := -1; -- Warning
1443: --Bug 4264364:Added exception handling
1444: INSERT into WSM_LOT_BASED_JOBS
1445: (WIP_ENTITY_ID,
1446: ORGANIZATION_ID,
1447: ON_REC_PATH,
1448: INTERNAL_COPY_TYPE,
1493: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.process_job_op_nw('||l_stmt_num||'): '||x_err_buf);
1494: x_err_code := -1; -- Warning
1495:
1496: --Bug 4264364:Added exception handling
1497: INSERT into WSM_LOT_BASED_JOBS
1498: (WIP_ENTITY_ID,
1499: ORGANIZATION_ID,
1500: ON_REC_PATH,
1501: INTERNAL_COPY_TYPE,
3781: <
3782:
3783: l_stmt_num := 300;
3784:
3785: -- ***** Create a record in wsm_lot_based_jobs ***** --
3786: Get_Job_Curr_Op_Info(p_wip_entity_id => p_wip_entity_id,
3787: p_op_seq_num => l_curr_op_seq_num,
3788: p_op_seq_id => l_curr_op_seq_id,
3789: p_std_op_id => l_curr_op_std_op_id,
3877: from wsm_parameters
3878: where ORGANIZATION_ID = p_org_id;
3879: END IF;
3880:
3881: INSERT into WSM_LOT_BASED_JOBS
3882: (WIP_ENTITY_ID,
3883: ORGANIZATION_ID,
3884: ON_REC_PATH,
3885: INTERNAL_COPY_TYPE,
3925: l_first_serial_txn_id -- ST : Added first_serial_txn_id in the above statement for bug fix 5171286
3926: );
3927:
3928: IF (SQL%ROWCOUNT = 0) THEN
3929: -- No record created in WSM_LOT_BASED_JOBS
3930: fnd_message.set_name('WSM', 'WSM_NO_WLBJ_REC');
3931: x_err_buf := fnd_message.get;
3932: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||'): '||x_err_buf);
3933: x_err_code := -2; -- Error
4173:
4174: DELETE WSM_COPY_REQUIREMENT_OPS
4175: WHERE wip_entity_id = p_new_wip_entity_id;
4176: */
4177: DELETE WSM_LOT_BASED_JOBS
4178: WHERE wip_entity_id = p_new_wip_entity_id;
4179:
4180: -- ***** Make a copy of the Network for the job ***** --
4181: l_stmt_num := 20;
4839: -- Hence, copying the resource usages from the Rep Job would be incorrect.
4840:
4841: l_stmt_num := 60;
4842:
4843: -- ***** Create a record in wsm_lot_based_jobs ***** --
4844: INSERT into WSM_LOT_BASED_JOBS
4845: (WIP_ENTITY_ID,
4846: ORGANIZATION_ID,
4847: ON_REC_PATH,
4840:
4841: l_stmt_num := 60;
4842:
4843: -- ***** Create a record in wsm_lot_based_jobs ***** --
4844: INSERT into WSM_LOT_BASED_JOBS
4845: (WIP_ENTITY_ID,
4846: ORGANIZATION_ID,
4847: ON_REC_PATH,
4848: INTERNAL_COPY_TYPE,
4883: SERIALIZATION_START_OP,
4884: FIRST_SERIAL_TXN_ID, --To avoid joining with the parent job
4885: CURRENT_JOB_OP_SEQ_NUM,
4886: CURRENT_RTG_OP_SEQ_NUM
4887: FROM WSM_LOT_BASED_JOBS
4888: WHERE wip_entity_id = p_rep_wip_entity_id;
4889:
4890:
4891:
4900: SELECT ON_REC_PATH,
4901: organization_id
4902: INTO l_on_rec_path,
4903: l_org_id
4904: FROM WSM_LOT_BASED_JOBS
4905: WHERE wip_entity_id = p_new_wip_entity_id;
4906:
4907: l_stmt_num := 80;
4908:
5097: AND wdj.organization_id = we.organization_id
5098: AND wdj.wip_entity_id = we.wip_entity_id
5099: AND wdj.status_type IN (1, 3, 4, 6) --Unreleased, Released, Complete, OnHold
5100: AND NOT EXISTS (select 1 -- To make sure same set of jobs is not picked up again
5101: from wsm_lot_based_jobs wlbj
5102: where wlbj.wip_entity_id = wdj.wip_entity_id
5103: )
5104: ORDER BY we.wip_entity_id -- Slows down the SQL prepare
5105: ;
5314:
5315: DELETE WSM_COPY_REQUIREMENT_OPS
5316: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5317:
5318: DELETE WSM_LOT_BASED_JOBS
5319: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5320:
5321: l_stmt_num := 100;
5322:
5319: WHERE wip_entity_id = v_job_wip_entity_id(l_counter);
5320:
5321: l_stmt_num := 100;
5322:
5323: INSERT into WSM_LOT_BASED_JOBS
5324: (WIP_ENTITY_ID,
5325: ORGANIZATION_ID,
5326: ON_REC_PATH,
5327: INTERNAL_COPY_TYPE,