APPS.GMD_QMSMC dependencies on GMD_SPEC_MATCH_GRP

Line 70: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;

66: l_form varchar2(240);
67: l_log varchar2(2000);
68: l_valid_transaction boolean := false;
69: l_vendor_spec_found boolean := false;
70: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
71: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
72: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
73:
74: L_SPEC_ID NUMBER;

Line 71: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;

67: l_log varchar2(2000);
68: l_valid_transaction boolean := false;
69: l_vendor_spec_found boolean := false;
70: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
71: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
72: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
73:
74: L_SPEC_ID NUMBER;
75: L_SPEC_VR_ID NUMBER;

Line 72: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;

68: l_valid_transaction boolean := false;
69: l_vendor_spec_found boolean := false;
70: l_inv_spec GMD_SPEC_MATCH_GRP.INVENTORY_SPEC_REC_TYPE;
71: l_cust_spec GMD_SPEC_MATCH_GRP.CUSTOMER_SPEC_REC_TYPE;
72: l_supp_spec GMD_SPEC_MATCH_GRP.SUPPLIER_SPEC_REC_TYPE;
73:
74: L_SPEC_ID NUMBER;
75: L_SPEC_VR_ID NUMBER;
76: L_SPEC_TYPE VARCHAR2(100);

Line 933: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(p_supplier_spec_rec => l_supp_spec,

929: gmd_debug.put_line('l_supp_spec.grade = ' || l_grade);
930: gmd_debug.put_line('Checking for Spec');
931: END IF;
932:
933: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(p_supplier_spec_rec => l_supp_spec,
934: x_spec_id => l_spec_id,
935: x_spec_vr_id => l_spec_vr_id,
936: x_spec_type => l_spec_type,
937: x_return_status => l_return_status,

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

1356:
1357: ELSE
1358: -- supplier spec not found
1359: l_vendor_spec_found := false;
1360: END IF; -- IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(
1361:
1362: END IF; -- IF l_valid_transaction and l_event_name in ('oracle.apps.gml.po.receipt.created',
1363:
1364: /***************************************************************/

Line 1396: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec => l_inv_spec,

1392: IF (l_debug = 'Y') THEN
1393: gmd_debug.put_line('Checking for Spec');
1394: END IF;
1395:
1396: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec => l_inv_spec,
1397: x_spec_id => l_spec_id,
1398: x_spec_vr_id => l_spec_vr_id,
1399: x_return_status => l_return_status,
1400: x_message_data => l_msg_data) THEN

Line 2156: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;

2152: itemkey => P_itemkey,
2153: aname => 'EVENT_KEY');
2154:
2155: Approver AME_UTIL.APPROVERRECORD;
2156: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
2157: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
2158: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
2159: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2160: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;

Line 2568: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(p_wip_spec_rec => l_wip_spec,

2564: IF (l_debug = 'Y') THEN
2565: gmd_debug.put_line('Checking for WIP Spec ');
2566: END IF;
2567:
2568: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(p_wip_spec_rec => l_wip_spec,
2569: x_spec_id => l_spec_id,
2570: x_spec_vr_id => l_spec_vr_id,
2571: x_return_status => l_return_status,
2572: x_message_data => l_msg_data) THEN