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
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);
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 ;
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 ;
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
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