[Home] [Help]
504: gmp_debug_message(' Updating attribute9 with batchstep resource id' );
505:
506: UPDATE GMP_APS_OUTPUT_DTL gad
507: SET attribute9 = ( SELECT gbr.batchstep_resource_id
508: FROM GME_BATCH_HEADER gbh,
509: GME_BATCH_STEPS gbs,
510: GME_BATCH_STEP_ACTIVITIES gba,
511: GME_BATCH_STEP_RESOURCES gbr,
512: CR_RSRC_DTL crd
1683: return_status := 0;
1684: /* B5470072, Resource Transaction should have doc_type of FPO */
1685: BEGIN
1686: SELECT DECODE(nvl(batch_type,0),0,'PROD',10,'FPO') into l_doc_type
1687: FROM gme_batch_header where batch_id = pbatch_id ;
1688: EXCEPTION
1689: WHEN NO_DATA_FOUND THEN
1690: l_doc_type := 'PROD' ;
1691: END ;
2183: IF v_batch_status = 1 THEN
2184: -- pending
2185: -- Only Update the new batch with due_date informnation,
2186: -- otherwise take the same date what GME have, basically reschedule batch
2187: UPDATE gme_batch_header
2188: SET
2189: plan_start_date = pstart_date,
2190: plan_cmplt_date = pend_date,
2191: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2187: UPDATE gme_batch_header
2188: SET
2189: plan_start_date = pstart_date,
2190: plan_cmplt_date = pend_date,
2191: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2192: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2193: firmed_ind = pfirm_flag, -- B5897392
2194: last_update_date = SYSDATE,
2195: last_updated_by = puser_id,
2188: SET
2189: plan_start_date = pstart_date,
2190: plan_cmplt_date = pend_date,
2191: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2192: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2193: firmed_ind = pfirm_flag, -- B5897392
2194: last_update_date = SYSDATE,
2195: last_updated_by = puser_id,
2196: last_update_login = plogin_id
2198: WHERE batch_id = pbatch_id;
2199: ELSE
2200: -- In Wip status
2201: -- No changes for WIP batch for due_date informnation
2202: UPDATE gme_batch_header
2203: SET
2204: plan_cmplt_date = pend_date,
2205: -- Vpedarla Bug: 8348883 added the below line to enable update of due date for batches in WIP status.
2206: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2202: UPDATE gme_batch_header
2203: SET
2204: plan_cmplt_date = pend_date,
2205: -- Vpedarla Bug: 8348883 added the below line to enable update of due date for batches in WIP status.
2206: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2207: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2208: firmed_ind = pfirm_flag, -- B5897392
2209: last_update_date = SYSDATE,
2210: last_updated_by = puser_id,
2203: SET
2204: plan_cmplt_date = pend_date,
2205: -- Vpedarla Bug: 8348883 added the below line to enable update of due date for batches in WIP status.
2206: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2207: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2208: firmed_ind = pfirm_flag, -- B5897392
2209: last_update_date = SYSDATE,
2210: last_updated_by = puser_id,
2211: last_update_login = plogin_id
2253: CURSOR lock_batch_header IS
2254: SELECT
2255: batch_id, batch_status, last_update_date
2256: FROM
2257: gme_batch_header
2258: WHERE
2259: batch_id = v_batch_id
2260: FOR UPDATE NOWAIT;
2261:
2881: BEGIN
2882:
2883: v_batch_sql := NULL;
2884:
2885: v_batch_sql := ' SELECT batch_id FROM gme_batch_header '
2886: || ' WHERE delete_mark = 0 AND batch_status IN (1,2) ';
2887:
2888: OPEN c_batch_id_cur FOR v_batch_sql ;
2889: LOOP