APPS.GMD_QMSMC dependencies on GMD_SPEC_MATCH_GRP

Line 74: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;

70: l_form varchar2(240);
71: l_log varchar2(2000);
72: l_valid_transaction boolean:=false;
73: l_vendor_spec_found boolean:=false;
74: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
75: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
76: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
77:
78: L_SPEC_ID NUMBER ;

Line 75: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;

71: l_log varchar2(2000);
72: l_valid_transaction boolean:=false;
73: l_vendor_spec_found boolean:=false;
74: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
75: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
76: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
77:
78: L_SPEC_ID NUMBER ;
79: L_SPEC_VR_ID NUMBER ;

Line 76: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;

72: l_valid_transaction boolean:=false;
73: l_vendor_spec_found boolean:=false;
74: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
75: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
76: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
77:
78: L_SPEC_ID NUMBER ;
79: L_SPEC_VR_ID NUMBER ;
80: L_SPEC_TYPE VARCHAR2(100) ;

Line 783: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(

779: IF (l_debug = 'Y') THEN
780: gmd_debug.put_line('Checking for Spec');
781: END IF;
782:
783: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(
784: p_supplier_spec_rec => l_supp_spec,
785: x_spec_id => l_spec_id,
786: x_spec_vr_id => l_spec_vr_id,
787: x_spec_type => l_spec_type ,

Line 1182: END IF; -- IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(

1178: || l_sampling_events.sampling_event_id); -- Bug # 4576699
1179:
1180: ELSE -- supplier spec not found
1181: l_vendor_spec_found:=false;
1182: END IF; -- IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(
1183:
1184: END IF; -- IF l_valid_transaction and l_event_name in ('oracle.apps.gml.po.receipt.created',
1185:
1186:

Line 1220: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(

1216: gmd_debug.put_line('Checking for Spec');
1217: END IF;
1218:
1219:
1220: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(
1221: p_inventory_spec_rec => l_inv_spec,
1222: x_spec_id => l_spec_id,
1223: x_spec_vr_id => l_spec_vr_id,
1224: x_return_status => l_return_status,

Line 1903: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;

1899: itemkey => P_itemkey,
1900: aname => 'EVENT_KEY');
1901:
1902: Approver AME_UTIL.APPROVERRECORD;
1903: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1904: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
1905: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
1906: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1907: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;

Line 2285: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(

2281: IF (l_debug = 'Y') THEN
2282: gmd_debug.put_line('Checking for WIP Spec ');
2283: END IF;
2284:
2285: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
2286: p_wip_spec_rec => l_wip_spec,
2287: x_spec_id => l_spec_id,
2288: x_spec_vr_id => l_spec_vr_id,
2289: x_return_status => l_return_status,