[Home] [Help]
188: l_stmt_num := 20;
189:
190: IF p_job_option = 1 THEN
191:
192: UPDATE wip_discrete_jobs wdj -- job_option 1
193: SET wdj.estimation_status = l_estimation_group_id,
194: wdj.last_update_date = SYSDATE,
195: wdj.last_updated_by = l_user_id,
196: wdj.request_id = l_request_id
207: )RETURNING wdj.wip_entity_id BULK COLLECT INTO l_entity_id_tab;
208:
209: ELSIF p_job_option = 2 THEN
210:
211: UPDATE wip_discrete_jobs wdj -- job_option 2
212: SET wdj.estimation_status = l_estimation_group_id,
213: wdj.last_update_date = SYSDATE,
214: wdj.last_updated_by = l_user_id,
215: wdj.request_id = l_request_id
222: RETURNING wdj.wip_entity_id BULK COLLECT INTO l_entity_id_tab;
223:
224: ELSIF p_job_option = 3 AND p_entity_type=1 THEN
225:
226: UPDATE wip_discrete_jobs wdj -- option 3 entity_type 1, primary_item_id
227: SET wdj.estimation_status = l_estimation_group_id,
228: wdj.last_update_date = SYSDATE,
229: wdj.last_updated_by = l_user_id,
230: wdj.request_id = l_request_id
243: RETURNING wdj.wip_entity_id BULK COLLECT INTO l_entity_id_tab;
244:
245: ELSIF p_job_option = 3 AND p_entity_type=6 THEN
246:
247: UPDATE wip_discrete_jobs wdj -- job_option 3 entity_type 6
248: SET wdj.estimation_status = l_estimation_group_id,
249: wdj.last_update_date = SYSDATE,
250: wdj.last_updated_by = l_user_id,
251: wdj.request_id = l_request_id
265: RETURNING wdj.wip_entity_id BULK COLLECT INTO l_entity_id_tab;
266:
267: ELSIF p_job_option = 4 THEN
268:
269: UPDATE wip_discrete_jobs wdj -- option 4
270: SET wdj.estimation_status = l_estimation_group_id,
271: wdj.last_update_date = SYSDATE,
272: wdj.last_updated_by = l_user_id,
273: wdj.request_id = l_request_id
451: /* the following statement sets the status to re estimate if the status of the
452: job is 9(re estimate and runnin, otherwise the status is set to 7(complete) */
453:
454:
455: UPDATE wip_discrete_jobs wdj
456: SET estimation_status = decode(estimation_status,9,8,7),
457: last_estimation_date = SYSDATE,
458: last_estimation_req_id = l_request_id,
459: last_update_date = SYSDATE
463: WHEN PROCESS_ERROR THEN
464:
465: ROLLBACK TO CSTPECEP_INT_PUB;
466:
467: UPDATE wip_discrete_jobs
468: SET estimation_status = 3,
469: last_update_date = SYSDATE,
470: last_estimation_date = SYSDATE,
471: last_estimation_req_id = l_request_id
497: -- of having this main Savepoint. This is done only in some unexpected exception
498: ROLLBACK TO CSTPECEP_MAIN_PUB;
499:
500: FORALL l_index IN l_entity_id_tab.FIRST..l_entity_id_tab.LAST
501: UPDATE wip_discrete_jobs
502: SET estimation_status = 1,
503: last_update_date = SYSDATE,
504: last_estimation_date = SYSDATE,
505: last_estimation_req_id = l_request_id
735: /* the following statement sets the status to re estimate if the status of the
736: job is 9(re estimate and runnin, otherwise the status is set to 7(complete) */
737:
738:
739: UPDATE wip_discrete_jobs wdj
740: SET estimation_status = decode(estimation_status,9,8,7),
741: last_estimation_date = SYSDATE,
742: last_estimation_req_id = l_request_id,
743: last_update_date = SYSDATE
756: EXCEPTION
757: WHEN fnd_api.g_exc_error THEN
758: ROLLBACK TO Estimate_WorkOrder_GRP;
759:
760: UPDATE wip_discrete_jobs
761: SET estimation_status = 3,
762: last_update_date = SYSDATE,
763: last_estimation_date = SYSDATE,
764: last_estimation_req_id = l_request_id
779: --
780: WHEN fnd_api.g_exc_unexpected_error THEN
781: ROLLBACK TO Estimate_WorkOrder_GRP;
782:
783: UPDATE wip_discrete_jobs
784: SET estimation_status = 3,
785: last_update_date = SYSDATE,
786: last_estimation_date = SYSDATE,
787: last_estimation_req_id = l_request_id
804: WHEN OTHERS THEN
805: ROLLBACK TO Estimate_WorkOrder_GRP;
806:
807:
808: UPDATE wip_discrete_jobs
809: SET estimation_status = 3,
810: last_update_date = SYSDATE,
811: last_estimation_date = SYSDATE,
812: last_estimation_req_id = l_request_id