DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_ORDER_CACHE

Line 895: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN

891: IF (l_inv_cust_trx_type_id = 0 or x_credit_memo_type_id = 0)THEN
892: --use cache instead of SQL for bug 4200055
893: IF ( p_line_rec.line_type_id is not null
894: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
895: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
896: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
897: end if ;
898: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
899: then

Line 896: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;

892: --use cache instead of SQL for bug 4200055
893: IF ( p_line_rec.line_type_id is not null
894: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
895: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
896: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
897: end if ;
898: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
899: then
900: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);

Line 898: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )

894: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
895: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
896: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
897: end if ;
898: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
899: then
900: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);
901: else
902: l_inv_cust_trx_type_id := 0 ;

Line 900: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);

896: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
897: end if ;
898: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
899: then
900: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);
901: else
902: l_inv_cust_trx_type_id := 0 ;
903: end if ;
904: ELSE

Line 1514: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN

1510:
1511: --use cache instead of SQL for bug 4200055
1512: IF ( p_line_rec.line_type_id is not null
1513: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM
1514: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1515: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1516: END IF ; -- end
1517:
1518: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line

Line 1515: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;

1511: --use cache instead of SQL for bug 4200055
1512: IF ( p_line_rec.line_type_id is not null
1513: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM
1514: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1515: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1516: END IF ; -- end
1517:
1518: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line
1519: IF l_debug_level > 0 THEN

Line 1523: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then

1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1521: END IF;
1522: --use cache instead of SQL for bug 4200055
1523: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1524: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;
1525: else
1526: l_cust_trx_type_id := 0 ;
1527: end if ;

Line 1524: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;

1520: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1521: END IF;
1522: --use cache instead of SQL for bug 4200055
1523: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1524: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;
1525: else
1526: l_cust_trx_type_id := 0 ;
1527: end if ;
1528: /*SELECT NVL(lt.cust_trx_type_id, 0)

Line 1582: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then

1578: IF l_debug_level > 0 THEN
1579: oe_debug_pub.add( 'THIS IS A NON-REFERENCED RETURN LINE ' , 5 ) ;
1580: END IF;
1581: --use cache instead of SQL for bug 4200055
1582: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1583: l_inv_cust_trx_type_id := nvl(OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id,0);
1584: else
1585: l_inv_cust_trx_type_id := 0 ;
1586: end if ;

Line 1583: l_inv_cust_trx_type_id := nvl(OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id,0);

1579: oe_debug_pub.add( 'THIS IS A NON-REFERENCED RETURN LINE ' , 5 ) ;
1580: END IF;
1581: --use cache instead of SQL for bug 4200055
1582: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1583: l_inv_cust_trx_type_id := nvl(OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id,0);
1584: else
1585: l_inv_cust_trx_type_id := 0 ;
1586: end if ;
1587: /*SELECT NVL(lt.cust_trx_type_id, 0)

Line 5661: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

5657: l_partial_line_tax_amount NUMBER := 0;
5658: l_partial_line_freight_amount NUMBER := 0;
5659: l_partial_line_promised_amount NUMBER := 0;
5660: l_fulfilled_qty NUMBER;
5661: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
5662: l_user_id NUMBER;
5663: l_resp_id NUMBER;
5664: l_appl_id NUMBER;
5665: /*Added for FP bug # 3647389*/

Line 6438: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

6434: END IF;
6435: END IF;
6436:
6437: IF p_header_rec.conversion_type_code IS NOT NULL THEN
6438: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
6439: IF l_debug_level > 0 THEN
6440: oe_debug_pub.add( 'SOB CURRENCY: '||L_SET_OF_BOOKS_REC.CURRENCY_CODE||' TRANSACTIONAL CURRENCY: '||P_HEADER_REC.TRANSACTIONAL_CURR_CODE ) ;
6441: END IF;
6442: IF p_header_rec.transactional_curr_code = l_set_of_books_rec.currency_code THEN