DBA Data[Home] [Help]

APPS.GMD_SPEC_MATCH_API dependencies on GMD_SPEC_MATCH_GRP

Line 32: find_cust_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;

28: , p_locator_id IN NUMBER
29: )
30: RETURN VARCHAR2
31: IS
32: find_cust_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;
33: l_spec_vr_id NUMBER;
34: l_spec_return_status VARCHAR(1);
35: l_return_status VARCHAR(1);
36: l_message_data VARCHAR(2000);

Line 48: result_lot_match_tbl GMD_SPEC_MATCH_GRP.result_lot_match_tbl;

44: l_header_id NUMBER;
45: l_organization_id NUMBER;
46:
47: l_spec_match_type VARCHAR2(4);
48: result_lot_match_tbl GMD_SPEC_MATCH_GRP.result_lot_match_tbl;
49:
50: Cursor get_order_line_info (p_source_line_id IN Number) Is
51: Select header_id
52: , ship_to_org_id ship_to_site_id

Line 91: l_spec_return := gmd_spec_match_grp.find_customer_spec

87: find_cust_spec_rec.order_id := l_header_id;
88: find_cust_spec_rec.order_line_id := p_source_line_id;
89: find_cust_spec_rec.exact_match := 'N';
90: find_cust_spec_rec.look_in_other_orgn := 'Y';
91: l_spec_return := gmd_spec_match_grp.find_customer_spec
92: ( p_customer_spec_rec => find_cust_spec_rec
93: ,x_spec_id => l_spec_hdr_id
94: ,x_spec_vr_id => l_spec_vr_id
95: ,x_return_status => l_spec_return_status

Line 105: GMD_SPEC_MATCH_GRP.get_result_match_for_spec

101: result_lot_match_tbl(1).subinventory := p_subinventory_code;
102: result_lot_match_tbl(1).locator_id := p_locator_id;
103: result_lot_match_tbl(1).organization_id := l_organization_id;
104: --Calling quality api to fetch the spec_match_type
105: GMD_SPEC_MATCH_GRP.get_result_match_for_spec
106: ( p_spec_id => l_spec_hdr_id
107: ,p_lots => result_lot_match_tbl
108: ,x_return_status => l_return_status
109: ,x_message_data => l_message_data