DBA Data[Home] [Help]

APPS.OE_LINE_SCREDIT_UTIL dependencies on OE_ORDER_CACHE

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

788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:
791: --SG{
792: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
793: --header not available in cache, load info to cache
794: IF p_x_line_Scredit_rec.line_Id IS NOT NULL THEN
795: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
796: ELSE

Line 795: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);

791: --SG{
792: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
793: --header not available in cache, load info to cache
794: IF p_x_line_Scredit_rec.line_Id IS NOT NULL THEN
795: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
796: ELSE
797: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
798: END IF;
799: END IF;

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

797: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
798: END IF;
799: END IF;
800:
801: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
802: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
803: ELSE
804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;

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

798: END IF;
799: END IF;
800:
801: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
802: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
803: ELSE
804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;
806:

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

800:
801: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
802: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
803: ELSE
804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;
806:
807: --5692017
808: IF p_x_line_Scredit_rec.operation = oe_globals.g_opr_create AND

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

825: IF nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
826: AND nvl(p_x_line_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
827: THEN
828:
829: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
830: --header not available in cache, load info to cache
831: IF p_x_line_Scredit_rec.Header_Id IS NOT NULL THEN
832: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
833: ELSE

Line 832: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);

828:
829: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
830: --header not available in cache, load info to cache
831: IF p_x_line_Scredit_rec.Header_Id IS NOT NULL THEN
832: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
833: ELSE
834: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
835: END IF;
836: END IF;

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

834: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
835: END IF;
836: END IF;
837:
838: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
839: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
840: ELSE
841: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
842: END IF;

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

835: END IF;
836: END IF;
837:
838: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
839: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
840: ELSE
841: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
842: END IF;
843:

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

837:
838: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
839: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
840: ELSE
841: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
842: END IF;
843:
844: oe_debug_pub.add('Before getting sales group--line');
845: OE_Header_Scredit_Util.Get_Sales_Group(p_date => l_sg_date,

Line 2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)

2402: END IF;
2403: IF NOT OE_GLOBALS.EQUAL(G_HEADER_ID,p_line_rec.header_id) or
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else

Line 2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)

2403: IF NOT OE_GLOBALS.EQUAL(G_HEADER_ID,p_line_rec.header_id) or
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;

Line 2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then

2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;

Line 2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;

2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2413: end if ;

Line 2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;

2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2413: end if ;
2414: /*select salesrep_id
2415: into G_SALESREP_ID

Line 2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;

2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2413: end if ;
2414: /*select salesrep_id
2415: into G_SALESREP_ID
2416: from oe_order_headers