APPS.GME_BATCH_STEP_CHG_PVT dependencies on GME_COMMON_PVT

Line 115: ,last_updated_by = gme_common_pvt.g_user_ident

111:
112: UPDATE gme_batch_step_activities
113: SET sequence_dependent_ind = act_tab (i).seq_dep_ind
114: ,last_update_date = SYSDATE
115: ,last_updated_by = gme_common_pvt.g_user_ident
116: ,last_update_login = gme_common_pvt.g_login_id
117: WHERE batchstep_activity_id =
118: act_tab (i).batchstep_activity_id;
119:

Line 116: ,last_update_login = gme_common_pvt.g_login_id

112: UPDATE gme_batch_step_activities
113: SET sequence_dependent_ind = act_tab (i).seq_dep_ind
114: ,last_update_date = SYSDATE
115: ,last_updated_by = gme_common_pvt.g_user_ident
116: ,last_update_login = gme_common_pvt.g_login_id
117: WHERE batchstep_activity_id =
118: act_tab (i).batchstep_activity_id;
119:
120: IF SQL%NOTFOUND THEN

Line 195: ,last_updated_by = gme_common_pvt.g_user_ident

191:
192: UPDATE gme_batch_step_activities
193: SET sequence_dependent_ind = act_tab (i).seq_dep_ind
194: ,last_update_date = SYSDATE
195: ,last_updated_by = gme_common_pvt.g_user_ident
196: ,last_update_login =
197: gme_common_pvt.g_login_id
198: ----- Punit Kumar
199: WHERE batchstep_activity_id =

Line 197: gme_common_pvt.g_login_id

193: SET sequence_dependent_ind = act_tab (i).seq_dep_ind
194: ,last_update_date = SYSDATE
195: ,last_updated_by = gme_common_pvt.g_user_ident
196: ,last_update_login =
197: gme_common_pvt.g_login_id
198: ----- Punit Kumar
199: WHERE batchstep_activity_id =
200: act_tab (i).batchstep_activity_id;
201:

Line 433: ,last_updated_by = gme_common_pvt.g_user_ident

429:
430: UPDATE gme_batch_step_resources
431: SET sequence_dependent_id = v_seq_dep_id
432: ,last_update_date = SYSDATE
433: ,last_updated_by = gme_common_pvt.g_user_ident
434: ,last_update_login = gme_common_pvt.g_login_id --- Punit
435: WHERE batchstep_resource_id = v_batchstep_resource_id;
436: END IF;
437: END LOOP;

Line 434: ,last_update_login = gme_common_pvt.g_login_id --- Punit

430: UPDATE gme_batch_step_resources
431: SET sequence_dependent_id = v_seq_dep_id
432: ,last_update_date = SYSDATE
433: ,last_updated_by = gme_common_pvt.g_user_ident
434: ,last_update_login = gme_common_pvt.g_login_id --- Punit
435: WHERE batchstep_resource_id = v_batchstep_resource_id;
436: END IF;
437: END LOOP;
438:

Line 545: ,last_update_date = gme_common_pvt.g_timestamp

541:
542: UPDATE gme_batch_step_charges
543: SET plan_start_date = NULL
544: ,plan_cmplt_date = NULL
545: ,last_update_date = gme_common_pvt.g_timestamp
546: ,last_updated_by = gme_common_pvt.g_user_ident
547: ,last_update_login = gme_common_pvt.g_login_id --- Punit
548: WHERE batch_id = p_batch_id AND batchstep_id = p_batchstep_id;
549: ELSE

Line 546: ,last_updated_by = gme_common_pvt.g_user_ident

542: UPDATE gme_batch_step_charges
543: SET plan_start_date = NULL
544: ,plan_cmplt_date = NULL
545: ,last_update_date = gme_common_pvt.g_timestamp
546: ,last_updated_by = gme_common_pvt.g_user_ident
547: ,last_update_login = gme_common_pvt.g_login_id --- Punit
548: WHERE batch_id = p_batch_id AND batchstep_id = p_batchstep_id;
549: ELSE
550: CLOSE cur_is_charge_associated;

Line 547: ,last_update_login = gme_common_pvt.g_login_id --- Punit

543: SET plan_start_date = NULL
544: ,plan_cmplt_date = NULL
545: ,last_update_date = gme_common_pvt.g_timestamp
546: ,last_updated_by = gme_common_pvt.g_user_ident
547: ,last_update_login = gme_common_pvt.g_login_id --- Punit
548: WHERE batch_id = p_batch_id AND batchstep_id = p_batchstep_id;
549: ELSE
550: CLOSE cur_is_charge_associated;
551: END IF;

Line 582: ,last_update_date = gme_common_pvt.g_timestamp

578:
579: UPDATE gme_batch_step_charges
580: SET plan_start_date = NULL
581: ,plan_cmplt_date = NULL
582: ,last_update_date = gme_common_pvt.g_timestamp
583: ,last_updated_by = gme_common_pvt.g_user_ident
584: ,last_update_login = gme_common_pvt.g_login_id --- Punit
585: WHERE batch_id = p_batch_id
586: AND batchstep_id = l_gme_batchstep_ids_tab (i);

Line 583: ,last_updated_by = gme_common_pvt.g_user_ident

579: UPDATE gme_batch_step_charges
580: SET plan_start_date = NULL
581: ,plan_cmplt_date = NULL
582: ,last_update_date = gme_common_pvt.g_timestamp
583: ,last_updated_by = gme_common_pvt.g_user_ident
584: ,last_update_login = gme_common_pvt.g_login_id --- Punit
585: WHERE batch_id = p_batch_id
586: AND batchstep_id = l_gme_batchstep_ids_tab (i);
587: ELSE

Line 584: ,last_update_login = gme_common_pvt.g_login_id --- Punit

580: SET plan_start_date = NULL
581: ,plan_cmplt_date = NULL
582: ,last_update_date = gme_common_pvt.g_timestamp
583: ,last_updated_by = gme_common_pvt.g_user_ident
584: ,last_update_login = gme_common_pvt.g_login_id --- Punit
585: WHERE batch_id = p_batch_id
586: AND batchstep_id = l_gme_batchstep_ids_tab (i);
587: ELSE
588: CLOSE cur_is_charge_associated;