DBA Data[Home] [Help]

APPS.OE_HEADER_PATTR_UTIL dependencies on OE_ORDER_CACHE

Line 3472: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM

3468: */
3469:
3470: Begin
3471: -- use order_header cache instead of sql : bug 4200055
3472: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else

Line 3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL

3469:
3470: Begin
3471: -- use order_header cache instead of sql : bug 4200055
3472: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else
3477: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Price_Att_Rec.Header_Id);

Line 3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then

3470: Begin
3471: -- use order_header cache instead of sql : bug 4200055
3472: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else
3477: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Price_Att_Rec.Header_Id);
3478: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

Line 3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

3471: -- use order_header cache instead of sql : bug 4200055
3472: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else
3477: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Price_Att_Rec.Header_Id);
3478: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3479: end if ;

Line 3477: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Price_Att_Rec.Header_Id);

3473: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else
3477: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Price_Att_Rec.Header_Id);
3478: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3479: end if ;
3480: /*Select booked_flag Into
3481: l_booked_flag

Line 3478: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;

3474: and OE_Order_Cache.g_header_rec.header_id = p_x_Header_Price_Att_Rec.Header_Id ) then
3475: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3476: else
3477: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Price_Att_Rec.Header_Id);
3478: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
3479: end if ;
3480: /*Select booked_flag Into
3481: l_booked_flag
3482: From OE_Order_Headers where