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 363: ,last_updated_by = gme_common_pvt.g_user_ident

359:
360: UPDATE gme_batch_step_resources
361: SET sequence_dependent_id = v_seq_dep_id
362: ,last_update_date = SYSDATE
363: ,last_updated_by = gme_common_pvt.g_user_ident
364: ,last_update_login = gme_common_pvt.g_login_id --- Punit
365: WHERE batchstep_resource_id = v_batchstep_resource_id;
366: END IF;
367: END LOOP;

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

360: UPDATE gme_batch_step_resources
361: SET sequence_dependent_id = v_seq_dep_id
362: ,last_update_date = SYSDATE
363: ,last_updated_by = gme_common_pvt.g_user_ident
364: ,last_update_login = gme_common_pvt.g_login_id --- Punit
365: WHERE batchstep_resource_id = v_batchstep_resource_id;
366: END IF;
367: END LOOP;
368:

Line 475: ,last_update_date = gme_common_pvt.g_timestamp

471:
472: UPDATE gme_batch_step_charges
473: SET plan_start_date = NULL
474: ,plan_cmplt_date = NULL
475: ,last_update_date = gme_common_pvt.g_timestamp
476: ,last_updated_by = gme_common_pvt.g_user_ident
477: ,last_update_login = gme_common_pvt.g_login_id --- Punit
478: WHERE batch_id = p_batch_id AND batchstep_id = p_batchstep_id;
479: ELSE

Line 476: ,last_updated_by = gme_common_pvt.g_user_ident

472: UPDATE gme_batch_step_charges
473: SET plan_start_date = NULL
474: ,plan_cmplt_date = NULL
475: ,last_update_date = gme_common_pvt.g_timestamp
476: ,last_updated_by = gme_common_pvt.g_user_ident
477: ,last_update_login = gme_common_pvt.g_login_id --- Punit
478: WHERE batch_id = p_batch_id AND batchstep_id = p_batchstep_id;
479: ELSE
480: CLOSE cur_is_charge_associated;

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

473: SET plan_start_date = NULL
474: ,plan_cmplt_date = NULL
475: ,last_update_date = gme_common_pvt.g_timestamp
476: ,last_updated_by = gme_common_pvt.g_user_ident
477: ,last_update_login = gme_common_pvt.g_login_id --- Punit
478: WHERE batch_id = p_batch_id AND batchstep_id = p_batchstep_id;
479: ELSE
480: CLOSE cur_is_charge_associated;
481: END IF;

Line 512: ,last_update_date = gme_common_pvt.g_timestamp

508:
509: UPDATE gme_batch_step_charges
510: SET plan_start_date = NULL
511: ,plan_cmplt_date = NULL
512: ,last_update_date = gme_common_pvt.g_timestamp
513: ,last_updated_by = gme_common_pvt.g_user_ident
514: ,last_update_login = gme_common_pvt.g_login_id --- Punit
515: WHERE batch_id = p_batch_id
516: AND batchstep_id = l_gme_batchstep_ids_tab (i);

Line 513: ,last_updated_by = gme_common_pvt.g_user_ident

509: UPDATE gme_batch_step_charges
510: SET plan_start_date = NULL
511: ,plan_cmplt_date = NULL
512: ,last_update_date = gme_common_pvt.g_timestamp
513: ,last_updated_by = gme_common_pvt.g_user_ident
514: ,last_update_login = gme_common_pvt.g_login_id --- Punit
515: WHERE batch_id = p_batch_id
516: AND batchstep_id = l_gme_batchstep_ids_tab (i);
517: ELSE

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

510: SET plan_start_date = NULL
511: ,plan_cmplt_date = NULL
512: ,last_update_date = gme_common_pvt.g_timestamp
513: ,last_updated_by = gme_common_pvt.g_user_ident
514: ,last_update_login = gme_common_pvt.g_login_id --- Punit
515: WHERE batch_id = p_batch_id
516: AND batchstep_id = l_gme_batchstep_ids_tab (i);
517: ELSE
518: CLOSE cur_is_charge_associated;