DBA Data[Home] [Help]

APPS.GME_RESCHEDULE_BATCH_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1208: UPDATE gme_batch_step_activities

1204: AND due_date < p_batch_header_rec.plan_start_date
1205: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1206:
1207: -- update batch activity start date
1208: UPDATE gme_batch_step_activities
1209: SET plan_start_date = p_batch_header_rec.plan_start_date
1210: ,last_updated_by = gme_common_pvt.g_user_ident
1211: ,last_update_date = gme_common_pvt.g_timestamp
1212: ,last_update_login = gme_common_pvt.g_login_id

Line 1218: UPDATE gme_batch_step_activities

1214: AND plan_start_date < p_batch_header_rec.plan_start_date
1215: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1216:
1217: -- update batch activity end date
1218: UPDATE gme_batch_step_activities
1219: SET plan_cmplt_date = p_batch_header_rec.plan_start_date
1220: ,last_updated_by = gme_common_pvt.g_user_ident
1221: ,last_update_date = gme_common_pvt.g_timestamp
1222: ,last_update_login = gme_common_pvt.g_login_id

Line 1339: UPDATE gme_batch_step_activities

1335: AND due_date > p_batch_header_rec.plan_cmplt_date
1336: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1337:
1338: -- update batch activity start date
1339: UPDATE gme_batch_step_activities
1340: SET plan_start_date = p_batch_header_rec.plan_cmplt_date
1341: ,last_updated_by = gme_common_pvt.g_user_ident
1342: ,last_update_date = gme_common_pvt.g_timestamp
1343: ,last_update_login = gme_common_pvt.g_login_id

Line 1349: UPDATE gme_batch_step_activities

1345: AND plan_start_date > p_batch_header_rec.plan_cmplt_date
1346: AND (p_batchstep_id IS NULL OR batchstep_id = p_batchstep_id);
1347:
1348: -- update batch activity end date
1349: UPDATE gme_batch_step_activities
1350: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1351: ,last_updated_by = gme_common_pvt.g_user_ident
1352: ,last_update_date = gme_common_pvt.g_timestamp
1353: ,last_update_login = gme_common_pvt.g_login_id