eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 110: FROM gme_batch_steps

106:
107: CURSOR cur_get_step_date (v_batch_id NUMBER, v_batchstep_id NUMBER)
108: IS
109: SELECT plan_start_date
110: FROM gme_batch_steps
111: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id;
112:
113: CURSOR cur_batch_step (
114: v_batch_id NUMBER

Line 119: FROM gme_batch_steps

115: ,v_plan_cmplt_date DATE
116: ,l_diff NUMBER)
117: IS
118: SELECT batchstep_no, plan_cmplt_date
119: FROM gme_batch_steps
120: WHERE batch_id = v_batch_id
121: AND (plan_cmplt_date + l_diff) > v_plan_cmplt_date;
122:
123: CURSOR recipe_validity_rule_cursor (

Line 314: FROM gme_batch_steps

310: FROM gme_batch_step_resources
311: WHERE batch_id = x_batch_header_rec.batch_id
312: AND batchstep_id IN (
313: SELECT batchstep_id
314: FROM gme_batch_steps
315: WHERE batch_id =
316: x_batch_header_rec.batch_id
317: AND step_status = 1) );
318: DELETE FROM gme_resource_txns_gtmp

Line 327: FROM gme_batch_steps

323: FROM gme_batch_step_resources
324: WHERE batch_id = x_batch_header_rec.batch_id
325: AND batchstep_id IN (
326: SELECT batchstep_id
327: FROM gme_batch_steps
328: WHERE batch_id =
329: x_batch_header_rec.batch_id
330: AND step_status = 1) );
331: END IF;

Line 700: FROM gme_batch_steps

696: the check so that this code works fine for the migrated batches from old gme code */
697: IF x_batch_header_rec.poc_ind = 'Y' THEN
698: SELECT MIN (plan_start_date)
699: INTO min_start_date
700: FROM gme_batch_steps
701: WHERE batch_id = p_batch_header_rec.batch_id;
702: ELSE
703: min_start_date := x_batch_header_rec.plan_start_date;
704: END IF;

Line 727: FROM gme_batch_steps

723:
724: IF x_batch_header_rec.poc_ind = 'Y' THEN
725: SELECT MAX (plan_cmplt_date)
726: INTO max_cmplt_date
727: FROM gme_batch_steps
728: WHERE batch_id = p_batch_header_rec.batch_id;
729: ELSE
730: max_cmplt_date := x_batch_header_rec.plan_cmplt_date;
731: END IF;

Line 904: FROM gme_batch_steps

900: AND l_rel_type IN (1, 2))
901: ) THEN
902: SELECT plan_start_date, plan_cmplt_date
903: INTO l_start_date, l_cmplt_date
904: FROM gme_batch_steps
905: WHERE batch_id = x_batch_header_rec.batch_id
906: AND batchstep_id = (SELECT batchstep_id
907: FROM gme_batch_step_items
908: WHERE batch_id = x_batch_header_rec.batch_id

Line 1121: ,p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE

1117: ***********************************************************************************/
1118: PROCEDURE truncate_date (
1119: p_batch_header_rec IN gme_batch_header%ROWTYPE
1120: ,p_date IN NUMBER
1121: ,p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
1122: DEFAULT NULL
1123: ,x_return_status OUT NOCOPY VARCHAR2)
1124: IS
1125: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TRANSACTION';

Line 1178: UPDATE gme_batch_steps

1174: AND due_date < p_batch_header_rec.plan_start_date;
1175: END IF;
1176:
1177: -- update batch steps start date
1178: UPDATE gme_batch_steps
1179: SET plan_start_date = p_batch_header_rec.plan_start_date
1180: ,last_updated_by = gme_common_pvt.g_user_ident
1181: ,last_update_date = gme_common_pvt.g_timestamp
1182: ,last_update_login = gme_common_pvt.g_login_id

Line 1188: UPDATE gme_batch_steps

1184: AND plan_start_date < p_batch_header_rec.plan_start_date
1185: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1186:
1187: -- update batch steps end date
1188: UPDATE gme_batch_steps
1189: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1190: ,last_updated_by = gme_common_pvt.g_user_ident
1191: ,last_update_date = gme_common_pvt.g_timestamp
1192: ,last_update_login = gme_common_pvt.g_login_id

Line 1198: UPDATE gme_batch_steps

1194: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1195: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1196:
1197: -- update batch steps due date
1198: UPDATE gme_batch_steps
1199: SET due_date = p_batch_header_rec.plan_start_date
1200: ,last_updated_by = gme_common_pvt.g_user_ident
1201: ,last_update_date = gme_common_pvt.g_timestamp
1202: ,last_update_login = gme_common_pvt.g_login_id

Line 1309: UPDATE gme_batch_steps

1305: AND due_date > p_batch_header_rec.plan_cmplt_date;
1306: END IF;
1307:
1308: -- update batch steps start date
1309: UPDATE gme_batch_steps
1310: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1311: ,last_updated_by = gme_common_pvt.g_user_ident
1312: ,last_update_date = gme_common_pvt.g_timestamp
1313: ,last_update_login = gme_common_pvt.g_login_id

Line 1319: UPDATE gme_batch_steps

1315: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1316: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1317:
1318: -- update batch steps end date
1319: UPDATE gme_batch_steps
1320: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1321: ,last_updated_by = gme_common_pvt.g_user_ident
1322: ,last_update_date = gme_common_pvt.g_timestamp
1323: ,last_update_login = gme_common_pvt.g_login_id

Line 1329: UPDATE gme_batch_steps

1325: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1326: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1327:
1328: -- update batch steps due date
1329: UPDATE gme_batch_steps
1330: SET due_date = p_batch_header_rec.plan_cmplt_date
1331: ,last_updated_by = gme_common_pvt.g_user_ident
1332: ,last_update_date = gme_common_pvt.g_timestamp
1333: ,last_update_login = gme_common_pvt.g_login_id