DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_ORDER_CACHE

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

1106: IF (l_inv_cust_trx_type_id = 0 or x_credit_memo_type_id = 0)THEN
1107: --use cache instead of SQL for bug 4200055
1108: IF ( p_line_rec.line_type_id is not null
1109: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
1110: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1111: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1112: end if ;
1113: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
1114: then

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

1107: --use cache instead of SQL for bug 4200055
1108: IF ( p_line_rec.line_type_id is not null
1109: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
1110: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1111: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1112: end if ;
1113: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
1114: then
1115: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);

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

1109: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM ) THEN
1110: if (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1111: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1112: end if ;
1113: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
1114: then
1115: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);
1116: else
1117: l_inv_cust_trx_type_id := 0 ;

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

1111: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1112: end if ;
1113: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id )
1114: then
1115: l_inv_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0);
1116: else
1117: l_inv_cust_trx_type_id := 0 ;
1118: end if ;
1119: ELSE

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

1727:
1728: --use cache instead of SQL for bug 4200055
1729: IF ( p_line_rec.line_type_id is not null
1730: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM
1731: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1732: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1733: END IF ; -- end
1734:
1735: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line

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

1728: --use cache instead of SQL for bug 4200055
1729: IF ( p_line_rec.line_type_id is not null
1730: AND p_line_rec.line_type_id <> FND_API.G_MISS_NUM
1731: AND OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_rec.Line_Type_id) THEN
1732: OE_Order_Cache.Load_Line_type(p_line_rec.Line_Type_id) ;
1733: END IF ; -- end
1734:
1735: IF NOT Return_Line(p_line_rec) THEN -- Standard Order Line
1736: IF l_debug_level > 0 THEN

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

1736: IF l_debug_level > 0 THEN
1737: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1738: END IF;
1739: --use cache instead of SQL for bug 4200055
1740: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1741: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;
1742: else
1743: l_cust_trx_type_id := 0 ;
1744: end if ;

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

1737: oe_debug_pub.add( 'THIS IA A STANDARD ORDER LINE' , 5 ) ;
1738: END IF;
1739: --use cache instead of SQL for bug 4200055
1740: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1741: l_cust_trx_type_id := nvl(OE_Order_Cache.g_line_type_rec.cust_trx_type_id,0) ;
1742: else
1743: l_cust_trx_type_id := 0 ;
1744: end if ;
1745: /*SELECT NVL(lt.cust_trx_type_id, 0)

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

1795: IF l_debug_level > 0 THEN
1796: oe_debug_pub.add( 'THIS IS A NON-REFERENCED RETURN LINE ' , 5 ) ;
1797: END IF;
1798: --use cache instead of SQL for bug 4200055
1799: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1800: l_inv_cust_trx_type_id := nvl(OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id,0);
1801: else
1802: l_inv_cust_trx_type_id := 0 ;
1803: end if ;

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

1796: oe_debug_pub.add( 'THIS IS A NON-REFERENCED RETURN LINE ' , 5 ) ;
1797: END IF;
1798: --use cache instead of SQL for bug 4200055
1799: if (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_rec.Line_Type_id ) then
1800: l_inv_cust_trx_type_id := nvl(OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id,0);
1801: else
1802: l_inv_cust_trx_type_id := 0 ;
1803: end if ;
1804: /*SELECT NVL(lt.cust_trx_type_id, 0)

Line 5905: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

5901: l_partial_line_tax_amount NUMBER := 0;
5902: l_partial_line_freight_amount NUMBER := 0;
5903: l_partial_line_promised_amount NUMBER := 0;
5904: l_fulfilled_qty NUMBER;
5905: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
5906: l_user_id NUMBER;
5907: l_resp_id NUMBER;
5908: l_appl_id NUMBER;
5909: /*Added for FP bug # 3647389*/

Line 6711: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

6707: END IF;
6708: END IF;
6709:
6710: IF p_header_rec.conversion_type_code IS NOT NULL THEN
6711: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
6712: IF l_debug_level > 0 THEN
6713: oe_debug_pub.add( 'SOB CURRENCY: '||L_SET_OF_BOOKS_REC.CURRENCY_CODE||' TRANSACTIONAL CURRENCY: '||P_HEADER_REC.TRANSACTIONAL_CURR_CODE ) ;
6714: END IF;
6715: IF p_header_rec.transactional_curr_code = l_set_of_books_rec.currency_code THEN