APPS.GMD_COA_DATA_OM dependencies on GMD_SPEC_MATCH_GRP

Line 144: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;

140: v_current_header VARCHAR2(75);
141: l_chk_whse_null NUMBER;
142: l_chk_lot_null NUMBER;
143: l_chk_orgn_null NUMBER;
144: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;
145: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
146: x_return_flag BOOLEAN;
147: x_spec_id NUMBER;
148: x_spec_vr_id NUMBER;

Line 145: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;

141: l_chk_whse_null NUMBER;
142: l_chk_lot_null NUMBER;
143: l_chk_orgn_null NUMBER;
144: p_customer_spec_rec GMD_SPEC_MATCH_GRP.customer_spec_rec_type;
145: p_inventory_spec_rec GMD_SPEC_MATCH_GRP.inventory_spec_rec_type;
146: x_return_flag BOOLEAN;
147: x_spec_id NUMBER;
148: x_spec_vr_id NUMBER;
149: x_return_status VARCHAR2(1000);

Line 185: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC(p_customer_spec_rec,

181: p_customer_spec_rec.org_id := tbl_hdr(loop_counter).org_id;
182: p_customer_spec_rec.order_id := tbl_hdr(loop_counter).order_id;
183:
184: x_return_flag := FALSE;
185: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC(p_customer_spec_rec,
186: x_spec_id,
187: x_spec_vr_id,
188: x_return_status,
189: x_message_data);

Line 190: trace('Look_For_CoC_Specs, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);

186: x_spec_id,
187: x_spec_vr_id,
188: x_return_status,
189: x_message_data);
190: trace('Look_For_CoC_Specs, GMD_SPEC_MATCH_GRP.FIND_CUSTOMER_SPEC , Spec_id '||x_spec_id);
191: IF (x_return_flag = FALSE) THEN
192:
193: p_inventory_spec_rec.item_id := tbl_hdr(loop_counter).item_id;
194: p_inventory_spec_rec.lot_id := tbl_hdr(loop_counter).lot_id;

Line 199: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec ,

195: p_inventory_spec_rec.date_effective := SYSDATE;
196: p_inventory_spec_rec.whse_code := tbl_hdr(loop_counter).whse_code;
197: -- p_inventory_spec_rec.org_id := tbl_hdr(loop_counter).org_id;
198:
199: x_return_flag := GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec ,
200: x_spec_id ,
201: x_spec_vr_id,
202: x_return_status,
203: x_message_data);

Line 204: trace('Look_For_CoC_Specs, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);

200: x_spec_id ,
201: x_spec_vr_id,
202: x_return_status,
203: x_message_data);
204: trace('Look_For_CoC_Specs, GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC , Spec_id '||x_spec_id);
205: END IF;
206:
207: FOR qc_cur_rec IN get_spec_details
208: (x_spec_id) LOOP