APPS.GMD_MBR_UTIL_PKG dependencies on GMD_SPEC_MATCH_GRP

Line 138: p_wip_spec_rec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;

134: ,P_LOT_NUMBER IN VARCHAR2
135: ,P_FIND_SPEC_WITH_STEP IN VARCHAR2) RETURN NUMBER IS
136:
137: ret_value BOOLEAN;
138: p_wip_spec_rec GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
139: x_return_status VARCHAR2(4000);
140: x_message_data VARCHAR2(4000);
141: l_spec_id NUMBER := null;
142: l_spec_vr_id NUMBER := null;

Line 180: ret_value := gmd_spec_match_grp.find_wip_spec(p_wip_spec_rec,l_spec_id,l_spec_vr_id,x_return_status,x_message_data);

176: p_wip_spec_rec.FIND_SPEC_WITH_STEP := P_FIND_SPEC_WITH_STEP;
177: open get_item_revison;
178: fetch get_item_revison into p_wip_spec_rec.revision;
179: close get_item_revison;
180: ret_value := gmd_spec_match_grp.find_wip_spec(p_wip_spec_rec,l_spec_id,l_spec_vr_id,x_return_status,x_message_data);
181: IF RET_VALUE
182: THEN
183: OPEN get_sampling_plan_id;
184: FETCH get_sampling_plan_id INTO l_smpl_plan_id;