APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 313: FROM gme_batch_step_resources

309: WHERE doc_id = x_batch_header_rec.batch_id
310: AND doc_type = l_doc_type
311: AND line_id IN (
312: SELECT batchstep_resource_id
313: FROM gme_batch_step_resources
314: WHERE batch_id = x_batch_header_rec.batch_id
315: AND batchstep_id IN (
316: SELECT batchstep_id
317: FROM gme_batch_steps

Line 326: FROM gme_batch_step_resources

322: WHERE doc_id = x_batch_header_rec.batch_id
323: AND doc_type = l_doc_type
324: AND line_id IN (
325: SELECT batchstep_resource_id
326: FROM gme_batch_step_resources
327: WHERE batch_id = x_batch_header_rec.batch_id
328: AND batchstep_id IN (
329: SELECT batchstep_id
330: FROM gme_batch_steps

Line 1251: UPDATE gme_batch_step_resources

1247: AND plan_cmplt_date < p_batch_header_rec.plan_start_date
1248: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1249:
1250: -- update batch resources start date
1251: UPDATE gme_batch_step_resources
1252: SET plan_start_date = p_batch_header_rec.plan_start_date
1253: ,last_updated_by = gme_common_pvt.g_user_ident
1254: ,last_update_date = gme_common_pvt.g_timestamp
1255: ,last_update_login = gme_common_pvt.g_login_id

Line 1261: UPDATE gme_batch_step_resources

1257: AND plan_start_date < p_batch_header_rec.plan_start_date
1258: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1259:
1260: -- update batch resources end date
1261: UPDATE gme_batch_step_resources
1262: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1263: ,last_updated_by = gme_common_pvt.g_user_ident
1264: ,last_update_date = gme_common_pvt.g_timestamp
1265: ,last_update_login = gme_common_pvt.g_login_id

Line 1382: UPDATE gme_batch_step_resources

1378: AND plan_cmplt_date > p_batch_header_rec.plan_cmplt_date
1379: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1380:
1381: -- update batch resources start date
1382: UPDATE gme_batch_step_resources
1383: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1384: ,last_updated_by = gme_common_pvt.g_user_ident
1385: ,last_update_date = gme_common_pvt.g_timestamp
1386: ,last_update_login = gme_common_pvt.g_login_id

Line 1392: UPDATE gme_batch_step_resources

1388: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1389: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1390:
1391: -- update batch resources end date
1392: UPDATE gme_batch_step_resources
1393: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1394: ,last_updated_by = gme_common_pvt.g_user_ident
1395: ,last_update_date = gme_common_pvt.g_timestamp
1396: ,last_update_login = gme_common_pvt.g_login_id