APPS.GMD_GME_INT dependencies on GMD_SPEC_MATCH_GRP

Line 44: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;

40: L_SPEC_ID NUMBER ;
41: L_SPEC_VR_ID NUMBER ;
42: L_RETURN_STATUS VARCHAR2(100) ;
43: L_Msg_DATA VARCHAR2(2000) ;
44: l_wip_spec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
45: l_log varchar2(4000);
46: dummy number;
47: l_routingstepid number;
48: l_last_update_by NUMBER ;

Line 164: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(

160: IF (l_debug = 'Y') THEN
161: gmd_debug.put_line('Checking if WIP Spec exists ');
162: END IF;
163:
164: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
165: p_wip_spec_rec => l_wip_spec,
166: x_spec_id => l_spec_id,
167: x_spec_vr_id => l_spec_vr_id,
168: x_return_status => l_return_status,

Line 213: ELSE -- IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(

209:
210: END IF; -- IF l_control_batch_step_ind = 'Y' then
211:
212:
213: ELSE -- IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
214: IF (l_debug = 'Y') THEN
215: gmd_debug.put_line('WIP Spec does NOT exists ');
216: gmd_debug.put_line('p_resultout = F');
217: END IF;

Line 221: END IF; -- IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(

217: END IF;
218:
219: p_resultout:='F';
220:
221: END IF; -- IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
222:
223: -- changes end for Bug No.14033362
224:
225: END LOOP ; -- open C2(p_recipeid) ;