APPS.GMO_CBR_GRP dependencies on GME_BATCH_STEPS

Line 790: FROM GME_BATCH_STEPS

786: l_batchstep_id := l_event_key;
787: l_message_prod := 'GME';
788: l_message_token:= 'GME_PSIG_BATCH_STEP_LABEL';
789: SELECT batch_id,PLAN_START_DATE into l_batch_id,l_plan_start_date
790: FROM GME_BATCH_STEPS
791: WHERE batchstep_id = l_batchstep_id;
792: ELSIF l_event_name in ('oracle.apps.gme.batchstep.added'
793: ,'oracle.apps.gme.batchstep.removed'
794: ,'oracle.apps.gme.batchstep.update') THEN

Line 804: FROM GME_BATCH_STEPS

800: l_message_prod := 'GME';
801: l_message_token:= 'GME_PSIG_BATCH_STEP_LABEL';
802: IF l_event_name in ('oracle.apps.gme.batchstep.added') THEN
803: SELECT PLAN_START_DATE into l_plan_start_date
804: FROM GME_BATCH_STEPS
805: WHERE batch_id = l_batch_id
806: AND batchstep_id = l_batchstep_id;
807: END IF;
808: ELSIF l_event_name in ('oracle.apps.gme.batchmtl.added'

Line 1006: FROM gme_batch_steps_v

1002: FROM GME_BATCH_HEADER_VW
1003: WHERE batch_id = P_BATCH_ID;
1004: CURSOR GET_STEP_DETAILS IS
1005: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_NO,OPERATION_NO,PLAN_START_DATE,PLAN_CMPLT_DATE
1006: FROM gme_batch_steps_v
1007: WHERE BATCH_ID = P_BATCH_ID;
1008: BATCH_DETAILS_REC Get_BATCH_DETAILS%ROWTYPE;
1009: STEP_DETAILS_REC GET_STEP_DETAILS%ROWTYPE;
1010: BEGIN

Line 1497: FROM GME_BATCH_STEPS

1493: l_batch_prog_rec.CURR_NODE_KEY := 'INSTRUCTION_SET_ID';
1494: l_batch_prog_rec.CURR_KEY_VAL := p_event_key;
1495: ELSIF(p_instr_type = 'PROCESS' and p_entity_name ='OPERATION') THEN
1496: SELECT batch_id into l_batch_id
1497: FROM GME_BATCH_STEPS
1498: WHERE batchstep_id = p_entity_key;
1499: l_message_token := 'GMO_ENTITY_OPERATION';
1500: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1501: l_batch_prog_rec.PROGRESSION_ID := NULL;