APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1231: UPDATE gme_batch_step_activities

1227: AND due_date < p_batch_header_rec.plan_start_date
1228: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1229:
1230: -- update batch activity start date
1231: UPDATE gme_batch_step_activities
1232: SET plan_start_date = p_batch_header_rec.plan_start_date
1233: ,last_updated_by = gme_common_pvt.g_user_ident
1234: ,last_update_date = gme_common_pvt.g_timestamp
1235: ,last_update_login = gme_common_pvt.g_login_id

Line 1241: UPDATE gme_batch_step_activities

1237: AND plan_start_date < p_batch_header_rec.plan_start_date
1238: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1239:
1240: -- update batch activity end date
1241: UPDATE gme_batch_step_activities
1242: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1243: ,last_updated_by = gme_common_pvt.g_user_ident
1244: ,last_update_date = gme_common_pvt.g_timestamp
1245: ,last_update_login = gme_common_pvt.g_login_id

Line 1362: UPDATE gme_batch_step_activities

1358: AND due_date > p_batch_header_rec.plan_cmplt_date
1359: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1360:
1361: -- update batch activity start date
1362: UPDATE gme_batch_step_activities
1363: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1364: ,last_updated_by = gme_common_pvt.g_user_ident
1365: ,last_update_date = gme_common_pvt.g_timestamp
1366: ,last_update_login = gme_common_pvt.g_login_id

Line 1372: UPDATE gme_batch_step_activities

1368: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1369: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1370:
1371: -- update batch activity end date
1372: UPDATE gme_batch_step_activities
1373: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1374: ,last_updated_by = gme_common_pvt.g_user_ident
1375: ,last_update_date = gme_common_pvt.g_timestamp
1376: ,last_update_login = gme_common_pvt.g_login_id