APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 310: FROM gme_batch_step_resources

306: WHERE doc_id = x_batch_header_rec.batch_id
307: AND doc_type = l_doc_type
308: AND line_id IN (
309: SELECT batchstep_resource_id
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

Line 323: FROM gme_batch_step_resources

319: WHERE doc_id = x_batch_header_rec.batch_id
320: AND doc_type = l_doc_type
321: AND line_id IN (
322: SELECT batchstep_resource_id
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

Line 1228: UPDATE gme_batch_step_resources

1224: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1225: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1226:
1227: -- update batch resources start date
1228: UPDATE gme_batch_step_resources
1229: SET plan_start_date = p_batch_header_rec.plan_start_date
1230: ,last_updated_by = gme_common_pvt.g_user_ident
1231: ,last_update_date = gme_common_pvt.g_timestamp
1232: ,last_update_login = gme_common_pvt.g_login_id

Line 1238: UPDATE gme_batch_step_resources

1234: AND plan_start_date < p_batch_header_rec.plan_start_date
1235: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1236:
1237: -- update batch resources end date
1238: UPDATE gme_batch_step_resources
1239: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1240: ,last_updated_by = gme_common_pvt.g_user_ident
1241: ,last_update_date = gme_common_pvt.g_timestamp
1242: ,last_update_login = gme_common_pvt.g_login_id

Line 1359: UPDATE gme_batch_step_resources

1355: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1356: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1357:
1358: -- update batch resources start date
1359: UPDATE gme_batch_step_resources
1360: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1361: ,last_updated_by = gme_common_pvt.g_user_ident
1362: ,last_update_date = gme_common_pvt.g_timestamp
1363: ,last_update_login = gme_common_pvt.g_login_id

Line 1369: UPDATE gme_batch_step_resources

1365: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1366: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1367:
1368: -- update batch resources end date
1369: UPDATE gme_batch_step_resources
1370: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1371: ,last_updated_by = gme_common_pvt.g_user_ident
1372: ,last_update_date = gme_common_pvt.g_timestamp
1373: ,last_update_login = gme_common_pvt.g_login_id