APPS.GME_BATCH_STEP_CHG_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 275: ,gme_batch_step_resources gsr

271: FROM gme_batch_header gbh
272: ,gmd_recipe_validity_rules gvr
273: ,gme_batch_steps gbs
274: ,gme_batch_step_activities gsa
275: ,gme_batch_step_resources gsr
276: ,cr_rsrc_dtl crd
277: ,ic_item_mst iim
278: ,gmp_sequence_types gst
279: WHERE gbh.batch_id = v_batch_id

Line 298: ,gme_batch_step_resources gsr2

294: FROM gme_batch_header gbh2
295: ,gmd_recipe_validity_rules gvr2
296: ,gme_batch_steps gbs2
297: ,gme_batch_step_activities gsa2
298: ,gme_batch_step_resources gsr2
299: ,cr_rsrc_dtl crd2
300: ,gmp_sequence_types gst2
301: ,ic_item_mst iim2
302: WHERE gbh2.batch_id = v_batch_id

Line 360: UPDATE gme_batch_step_resources

356: || 'batchstep resource id = '
357: || v_batchstep_resource_id);
358: END IF;
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

Line 680: ,p_resources IN gme_batch_step_resources.resources%TYPE

676: Created.
677: =============================================================================================*/
678: PROCEDURE calc_activity_sequence_number (
679: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
680: ,p_resources IN gme_batch_step_resources.resources%TYPE
681: ,x_act_seq_num OUT NOCOPY NUMBER
682: ,x_return_status OUT NOCOPY VARCHAR2)
683: IS
684: CURSOR cur_get_seq_dep_ind (

Line 685: v_resources gme_batch_step_resources.resources%TYPE

681: ,x_act_seq_num OUT NOCOPY NUMBER
682: ,x_return_status OUT NOCOPY VARCHAR2)
683: IS
684: CURSOR cur_get_seq_dep_ind (
685: v_resources gme_batch_step_resources.resources%TYPE
686: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
687: IS
688: SELECT MIN (a.sequence_dependent_ind)
689: FROM gme_batch_step_activities a, gme_batch_step_resources r

Line 689: FROM gme_batch_step_activities a, gme_batch_step_resources r

685: v_resources gme_batch_step_resources.resources%TYPE
686: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
687: IS
688: SELECT MIN (a.sequence_dependent_ind)
689: FROM gme_batch_step_activities a, gme_batch_step_resources r
690: WHERE r.resources = v_resources
691: AND r.batchstep_activity_id = a.batchstep_activity_id
692: AND a.batchstep_id = v_batchstep_id
693: AND r.batchstep_id = v_batchstep_id