DBA Data[Home] [Help]

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 148: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(

144: IF (l_debug = 'Y') THEN
145: gmd_debug.put_line('Checking if WIP Spec exists ');
146: END IF;
147:
148: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
149: p_wip_spec_rec => l_wip_spec,
150: x_spec_id => l_spec_id,
151: x_spec_vr_id => l_spec_vr_id,
152: x_return_status => l_return_status,