DBA Data[Home] [Help]

APPS.GMP_WPS_WRITER dependencies on GME_BATCH_HEADER

Line 40: gme_batch_header gbh

36: SELECT
37: gbh.batch_status,
38: gbh.last_update_date
39: FROM
40: gme_batch_header gbh
41: WHERE
42: batch_id = v_batch_id;
43:
44: v_batch_status NUMBER;

Line 70: gme_batch_header

66: return_status := 0;
67: ELSE
68: IF v_batch_status = 1 THEN
69: UPDATE
70: gme_batch_header
71: SET
72: plan_start_date = v_start_date,
73: plan_cmplt_date = v_end_date,
74: finite_scheduled_ind = 1,

Line 82: gme_batch_header

78: WHERE
79: batch_id = v_batch_id;
80: ELSE
81: UPDATE
82: gme_batch_header
83: SET
84: plan_cmplt_date = v_end_date,
85: finite_scheduled_ind = 1,
86: last_update_date = SYSDATE,

Line 933: gme_batch_header gbh

929: gbh.ORGANIZATION_ID
930: FROM
931: cr_rsrc_dtl crd,
932: gme_batch_step_resources gsr,
933: gme_batch_header gbh
934: WHERE
935: crd.resource_id = v_resource_id
936: AND crd.delete_mark = 0
937: AND gsr.batchstep_resource_id = v_act_resource_id

Line 1072: gme_batch_header

1068: CURSOR lock_batch_header IS
1069: SELECT
1070: batch_id
1071: FROM
1072: gme_batch_header
1073: WHERE
1074: batch_id = v_batch_id
1075: FOR UPDATE NOWAIT;
1076: