APPS.GMP_APS_WRITER dependencies on GME_BATCH_HEADER

Line 495: FROM GME_BATCH_HEADER gbh,

491: BEGIN
492:
493: UPDATE GMP_APS_OUTPUT_DTL gad
494: SET attribute9 = ( SELECT gbr.batchstep_resource_id
495: FROM GME_BATCH_HEADER gbh,
496: GME_BATCH_STEPS gbs,
497: GME_BATCH_STEP_ACTIVITIES gba,
498: GME_BATCH_STEP_RESOURCES gbr,
499: CR_RSRC_DTL crd

Line 1582: FROM gme_batch_header where batch_id = pbatch_id ;

1578: return_status := 0;
1579: /* B5470072, Resource Transaction should have doc_type of FPO */
1580: BEGIN
1581: SELECT DECODE(nvl(batch_type,0),0,'PROD',10,'FPO') into l_doc_type
1582: FROM gme_batch_header where batch_id = pbatch_id ;
1583: EXCEPTION
1584: WHEN NO_DATA_FOUND THEN
1585: l_doc_type := 'PROD' ;
1586: END ;

Line 2095: UPDATE gme_batch_header

2091: IF v_batch_status = 1 THEN
2092: -- pending
2093: -- Only Update the new batch with due_date informnation,
2094: -- otherwise take the same date what GME have, basically reschedule batch
2095: UPDATE gme_batch_header
2096: SET
2097: plan_start_date = pstart_date,
2098: plan_cmplt_date = pend_date,
2099: due_date = NVL(preq_completion_date,gme_batch_header.due_date),

Line 2099: due_date = NVL(preq_completion_date,gme_batch_header.due_date),

2095: UPDATE gme_batch_header
2096: SET
2097: plan_start_date = pstart_date,
2098: plan_cmplt_date = pend_date,
2099: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2100: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2101: firmed_ind = pfirm_flag, -- B5897392
2102: last_update_date = SYSDATE,
2103: last_updated_by = puser_id,

Line 2100: order_priority = NVL(pord_priority,gme_batch_header.order_priority),

2096: SET
2097: plan_start_date = pstart_date,
2098: plan_cmplt_date = pend_date,
2099: due_date = NVL(preq_completion_date,gme_batch_header.due_date),
2100: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2101: firmed_ind = pfirm_flag, -- B5897392
2102: last_update_date = SYSDATE,
2103: last_updated_by = puser_id,
2104: last_update_login = plogin_id

Line 2110: UPDATE gme_batch_header

2106: WHERE batch_id = pbatch_id;
2107: ELSE
2108: -- In Wip status
2109: -- No changes for WIP batch for due_date informnation
2110: UPDATE gme_batch_header
2111: SET
2112: plan_cmplt_date = pend_date,
2113: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2114: firmed_ind = pfirm_flag, -- B5897392

Line 2113: order_priority = NVL(pord_priority,gme_batch_header.order_priority),

2109: -- No changes for WIP batch for due_date informnation
2110: UPDATE gme_batch_header
2111: SET
2112: plan_cmplt_date = pend_date,
2113: order_priority = NVL(pord_priority,gme_batch_header.order_priority),
2114: firmed_ind = pfirm_flag, -- B5897392
2115: last_update_date = SYSDATE,
2116: last_updated_by = puser_id,
2117: last_update_login = plogin_id

Line 2163: gme_batch_header

2159: CURSOR lock_batch_header IS
2160: SELECT
2161: batch_id, batch_status, last_update_date
2162: FROM
2163: gme_batch_header
2164: WHERE
2165: batch_id = v_batch_id
2166: FOR UPDATE NOWAIT;
2167:

Line 2782: v_batch_sql := ' SELECT batch_id FROM gme_batch_header '

2778: BEGIN
2779:
2780: v_batch_sql := NULL;
2781:
2782: v_batch_sql := ' SELECT batch_id FROM gme_batch_header '
2783: || ' WHERE delete_mark = 0 AND batch_status IN (1,2) ';
2784:
2785: OPEN c_batch_id_cur FOR v_batch_sql ;
2786: LOOP