APPS.GME_BATCH_STEP_CHG_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 276: ,gme_batch_step_resources gsr

272: FROM gme_batch_header gbh
273: ,gmd_recipe_validity_rules gvr
274: ,gme_batch_steps gbs
275: ,gme_batch_step_activities gsa
276: ,gme_batch_step_resources gsr
277: ,cr_rsrc_dtl crd
278: ,mtl_system_items iim -- 8708957 - Change this from ic_item_mst to mtl_system_items
279: ,gmp_sequence_types gst
280: -- 8708957 - two more tables added

Line 308: ,gme_batch_step_resources gsr2

304: FROM gme_batch_header gbh2
305: ,gmd_recipe_validity_rules gvr2
306: ,gme_batch_steps gbs2
307: ,gme_batch_step_activities gsa2
308: ,gme_batch_step_resources gsr2
309: ,cr_rsrc_dtl crd2
310: ,gmp_sequence_types gst2
311: ,mtl_system_items iim2 -- 8708957 - Change this from ic_item_mst to mtl_system_items
312: -- 8708957 - two more tables added

Line 345: ,gme_batch_step_resources gsr

341: FROM gme_batch_header gbh
342: ,gmd_recipe_validity_rules gvr
343: ,gme_batch_steps gbs
344: ,gme_batch_step_activities gsa
345: ,gme_batch_step_resources gsr
346: ,cr_rsrc_dtl crd
347: ,ic_item_mst iim
348: ,gmp_sequence_types gst
349: WHERE gbh.batch_id = v_batch_id

Line 368: ,gme_batch_step_resources gsr2

364: FROM gme_batch_header gbh2
365: ,gmd_recipe_validity_rules gvr2
366: ,gme_batch_steps gbs2
367: ,gme_batch_step_activities gsa2
368: ,gme_batch_step_resources gsr2
369: ,cr_rsrc_dtl crd2
370: ,gmp_sequence_types gst2
371: ,ic_item_mst iim2
372: WHERE gbh2.batch_id = v_batch_id

Line 430: UPDATE gme_batch_step_resources

426: || 'batchstep resource id = '
427: || v_batchstep_resource_id);
428: END IF;
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

Line 750: ,p_resources IN gme_batch_step_resources.resources%TYPE

746: Created.
747: =============================================================================================*/
748: PROCEDURE calc_activity_sequence_number (
749: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
750: ,p_resources IN gme_batch_step_resources.resources%TYPE
751: ,x_act_seq_num OUT NOCOPY NUMBER
752: ,x_return_status OUT NOCOPY VARCHAR2)
753: IS
754: CURSOR cur_get_seq_dep_ind (

Line 755: v_resources gme_batch_step_resources.resources%TYPE

751: ,x_act_seq_num OUT NOCOPY NUMBER
752: ,x_return_status OUT NOCOPY VARCHAR2)
753: IS
754: CURSOR cur_get_seq_dep_ind (
755: v_resources gme_batch_step_resources.resources%TYPE
756: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
757: IS
758: SELECT MIN (a.sequence_dependent_ind)
759: FROM gme_batch_step_activities a, gme_batch_step_resources r

Line 759: FROM gme_batch_step_activities a, gme_batch_step_resources r

755: v_resources gme_batch_step_resources.resources%TYPE
756: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
757: IS
758: SELECT MIN (a.sequence_dependent_ind)
759: FROM gme_batch_step_activities a, gme_batch_step_resources r
760: WHERE r.resources = v_resources
761: AND r.batchstep_activity_id = a.batchstep_activity_id
762: AND a.batchstep_id = v_batchstep_id
763: AND r.batchstep_id = v_batchstep_id