DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on OE_ORDER_CACHE

Line 150: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;

146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(2000);
148:
149: l_invoice_numbering_method VARCHAR2(1) := NVL(FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD'), 'A');
150: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
151: l_order_type_rec OE_Order_Cache.order_type_Rec_Type;
152:
153: l_cust_trx_type_id NUMBER;
154: l_invoice_source_id NUMBER;

Line 151: l_order_type_rec OE_Order_Cache.order_type_Rec_Type;

147: l_msg_data VARCHAR2(2000);
148:
149: l_invoice_numbering_method VARCHAR2(1) := NVL(FND_PROFILE.VALUE('WSH_INVOICE_NUMBERING_METHOD'), 'A');
150: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
151: l_order_type_rec OE_Order_Cache.order_type_Rec_Type;
152:
153: l_cust_trx_type_id NUMBER;
154: l_invoice_source_id NUMBER;
155: l_non_d_invoice_source_id NUMBER;

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

209: g_invoice_to_site_tbl(i) := -99;
210: END;
211:
212: -- Populate cust_trx_type_id, invoice_source_id, non_delivery_inoice_source_id
213: l_line_type_rec := oe_order_cache.load_line_type(g_line_type_id_tbl(i));
214: l_cust_trx_type_id := l_line_type_rec.cust_trx_type_id;
215: l_invoice_source_id := l_line_type_rec.invoice_source_id;
216: l_non_d_invoice_source_id := l_line_type_rec.non_delivery_invoice_source_id;
217:

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

225: IF l_cust_trx_type_id IS NULL OR
226: (l_invoice_source_id IS NULL AND (g_shippable_flag_tbl(i) = 'Y' OR l_invoice_numbering_method = 'A')) OR
227: (l_non_d_invoice_source_id IS NULL AND l_invoice_numbering_method = 'D' AND g_shippable_flag_tbl(i) = 'N') THEN
228:
229: l_order_type_rec := oe_order_cache.load_order_type(OE_Order_Cache.g_header_rec.order_type_id);
230: l_cust_trx_type_id2 := l_order_type_rec.cust_trx_type_id;
231: l_invoice_source_id2 := l_order_type_rec.invoice_source_id;
232: l_non_d_invoice_source_id2 := l_order_type_rec.non_delivery_invoice_source_id;
233: END IF;