APPS.OE_HEADER_SCREDIT_UTIL dependencies on OE_ORDER_CACHE

Line 714: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN

710: NULL;
711: --SG{
712:
713:
714: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
715: --header not available in cache, load info to cache
716: IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
717: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
718: ELSE

Line 717: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);

713:
714: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
715: --header not available in cache, load info to cache
716: IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
717: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
718: ELSE
719: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
720: END IF;
721: END IF;

Line 723: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN

719: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
720: END IF;
721: END IF;
722:
723: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
724: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
725: ELSE
726: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
727: END IF;

Line 724: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;

720: END IF;
721: END IF;
722:
723: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
724: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
725: ELSE
726: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
727: END IF;
728:

Line 726: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;

722:
723: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
724: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
725: ELSE
726: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
727: END IF;
728:
729: --5620190: Added the IF condition, so that Get_Sales_Group id is called only if
730: --the record doesn't have a sales group id, which could have been populated

Line 748: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN

744: IF nvl(p_x_Header_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
745: AND nvl(p_x_Header_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
746: THEN
747:
748: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
749: --header not available in cache, load info to cache
750: IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
751: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
752: ELSE

Line 751: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);

747:
748: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
749: --header not available in cache, load info to cache
750: IF p_x_Header_Scredit_rec.Header_Id IS NOT NULL THEN
751: OE_ORDER_CACHE.Load_Order_Header(p_x_Header_Scredit_rec.Header_Id);
752: ELSE
753: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
754: END IF;
755: END IF;

Line 757: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN

753: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
754: END IF;
755: END IF;
756:
757: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
758: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
759: ELSE
760: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
761: END IF;

Line 758: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;

754: END IF;
755: END IF;
756:
757: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
758: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
759: ELSE
760: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
761: END IF;
762: oe_debug_pub.add('Before getting sales group');

Line 760: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;

756:
757: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
758: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
759: ELSE
760: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
761: END IF;
762: oe_debug_pub.add('Before getting sales group');
763: Get_Sales_Group(p_date => l_sg_date,
764: p_sales_rep_id =>p_x_Header_Scredit_rec.salesrep_id,