[Home] [Help]
812: l_batchstep_id := l_event_key;
813: l_message_prod := 'GME';
814: l_message_token:= 'GME_PSIG_BATCH_STEP_LABEL';
815: SELECT batch_id,PLAN_START_DATE into l_batch_id,l_plan_start_date
816: FROM GME_BATCH_STEPS
817: WHERE batchstep_id = l_batchstep_id;
818: ELSIF l_event_name in ('oracle.apps.gme.batchstep.added'
819: ,'oracle.apps.gme.batchstep.removed'
820: ,'oracle.apps.gme.batchstep.update') THEN
826: l_message_prod := 'GME';
827: l_message_token:= 'GME_PSIG_BATCH_STEP_LABEL';
828: IF l_event_name in ('oracle.apps.gme.batchstep.added') THEN
829: SELECT PLAN_START_DATE into l_plan_start_date
830: FROM GME_BATCH_STEPS
831: WHERE batch_id = l_batch_id
832: AND batchstep_id = l_batchstep_id;
833: END IF;
834: ELSIF l_event_name in ('oracle.apps.gme.batchmtl.added'
1066: FROM GME_BATCH_HEADER_VW
1067: WHERE batch_id = P_BATCH_ID;
1068: CURSOR GET_STEP_DETAILS IS
1069: SELECT BATCH_ID,BATCHSTEP_ID,BATCHSTEP_NO,OPERATION_NO,PLAN_START_DATE,PLAN_CMPLT_DATE
1070: FROM gme_batch_steps_v
1071: WHERE BATCH_ID = P_BATCH_ID;
1072: BATCH_DETAILS_REC Get_BATCH_DETAILS%ROWTYPE;
1073: STEP_DETAILS_REC GET_STEP_DETAILS%ROWTYPE;
1074: BEGIN
1557: l_batch_prog_rec.CURR_NODE_KEY := 'INSTRUCTION_SET_ID';
1558: l_batch_prog_rec.CURR_KEY_VAL := p_event_key;
1559: ELSIF(p_instr_type = 'PROCESS' and p_entity_name ='OPERATION') THEN
1560: SELECT batch_id into l_batch_id
1561: FROM GME_BATCH_STEPS
1562: WHERE batchstep_id = p_entity_key;
1563: l_message_token := 'GMO_ENTITY_OPERATION';
1564: l_user_key_label := FND_MESSAGE.GET_STRING('GMO',l_message_token);
1565: l_batch_prog_rec.PROGRESSION_ID := NULL;