DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on OE_ORDER_CACHE

Line 160: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;

156: l_msg_count NUMBER;
157: l_msg_data VARCHAR2(2000);
158:
159: l_invoice_numbering_method VARCHAR2(1) := NVL(FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD'), 'A');
160: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
161: l_order_type_rec OE_Order_Cache.order_type_Rec_Type;
162:
163: l_cust_trx_type_id NUMBER;
164: l_invoice_source_id NUMBER;

Line 161: l_order_type_rec OE_Order_Cache.order_type_Rec_Type;

157: l_msg_data VARCHAR2(2000);
158:
159: l_invoice_numbering_method VARCHAR2(1) := NVL(FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD'), 'A');
160: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
161: l_order_type_rec OE_Order_Cache.order_type_Rec_Type;
162:
163: l_cust_trx_type_id NUMBER;
164: l_invoice_source_id NUMBER;
165: l_non_d_invoice_source_id NUMBER;

Line 244: l_line_type_rec := oe_order_cache.load_line_type(g_line_type_id_tbl(i));

240: g_ship_to_site_tbl(i) := -99;
241: END;
242:
243: -- Populate cust_trx_type_id, invoice_source_id, non_delivery_inoice_source_id
244: l_line_type_rec := oe_order_cache.load_line_type(g_line_type_id_tbl(i));
245: l_cust_trx_type_id := l_line_type_rec.cust_trx_type_id;
246: l_invoice_source_id := l_line_type_rec.invoice_source_id;
247: l_non_d_invoice_source_id := l_line_type_rec.non_delivery_invoice_source_id;
248:

Line 260: l_order_type_rec := oe_order_cache.load_order_type(OE_Order_Cache.g_header_rec.order_type_id);

256: IF l_cust_trx_type_id IS NULL OR
257: (l_invoice_source_id IS NULL AND (g_shippable_flag_tbl(i) = 'Y' OR l_invoice_numbering_method = 'A')) OR
258: (l_non_d_invoice_source_id IS NULL AND l_invoice_numbering_method = 'D' AND g_shippable_flag_tbl(i) = 'N') THEN
259:
260: l_order_type_rec := oe_order_cache.load_order_type(OE_Order_Cache.g_header_rec.order_type_id);
261: l_cust_trx_type_id2 := l_order_type_rec.cust_trx_type_id;
262: l_invoice_source_id2 := l_order_type_rec.invoice_source_id;
263: l_non_d_invoice_source_id2 := l_order_type_rec.non_delivery_invoice_source_id;
264: END IF;