DBA Data[Home] [Help]

APPS.ASO_PRICING_CALLBACK_PVT dependencies on ASO_PRICING_INT

Line 19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,

15: PROCEDURE Config_Callback_Pricing_Order(
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 129: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

125: END IF;
126: l_request_type := p_control_rec.request_type;
127: l_pricing_event := p_control_rec.pricing_event;
128:
129: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
130: p_qte_header_rec => p_qte_header_rec,
131: p_shipment_rec => p_hd_shipment_rec);
132:
133: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 200: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

196:
197: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
198: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Begin Setting up the G_LINE_REC', 1, 'Y');
199: END IF;
200: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
201: p_qte_line_rec => l_qte_line_tbl(i),
202: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
203: p_shipment_rec => l_shipment_rec);
204: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 301: ASO_PRICING_INT.G_LINE_REC := NULL;

297: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:After PRICE_REQUEST l_return_status:'||l_return_status, 1, 'N');
298: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:After PRICE_REQUEST l_return_status_text '||l_return_status_text,1,'N');
299: END IF;
300:
301: ASO_PRICING_INT.G_LINE_REC := NULL;
302: ASO_PRICING_INT.G_HEADER_REC := NULL;
303:
304: i := lx_req_line_tbl.FIRST;
305: WHILE i IS NOT NULL LOOP

Line 302: ASO_PRICING_INT.G_HEADER_REC := NULL;

298: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:After PRICE_REQUEST l_return_status_text '||l_return_status_text,1,'N');
299: END IF;
300:
301: ASO_PRICING_INT.G_LINE_REC := NULL;
302: ASO_PRICING_INT.G_HEADER_REC := NULL;
303:
304: i := lx_req_line_tbl.FIRST;
305: WHILE i IS NOT NULL LOOP
306: lx_req_line_rec := lx_req_line_tbl(i);

Line 459: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,

455: PROCEDURE Config_Callback_Pricing_Order (
456: P_Api_Version_Number IN NUMBER,
457: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
458: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
460: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
461: p_qte_header_id IN NUMBER,
462: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
463: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 639: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');

635: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
636: BEGIN
637: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
638: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT: In copy attribs to req - Global Header Rec quote_status_id'
639: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
640: END IF;
641: for i in 1..p_pricing_contexts_Tbl.count loop
642: l_attr_index := l_attr_index +1;
643: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 643: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

639: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
640: END IF;
641: for i in 1..p_pricing_contexts_Tbl.count loop
642: l_attr_index := l_attr_index +1;
643: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
644: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'N';
645: ELSE
646: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'Y';
647: END IF;

Line 660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

656: end loop;
657: -- Copy the qualifiers
658: for i in 1..p_qualifier_contexts_Tbl.count loop
659: l_qual_index := l_qual_index +1;
660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
661: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'N';
662: ELSE
663: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'Y';
664: END IF;

Line 688: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');

684: copy_hdr_rec_to_line_flag boolean := TRUE;
685: BEGIN
686: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
687: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT: copy_hdr_attribs_to_line - Global Header Rec quote_status_id:'
688: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
689: END IF;
690: for i in 1..p_pricing_contexts_Tbl.count loop
691: l_attr_index := l_attr_index +1;
692: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 692: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

688: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
689: END IF;
690: for i in 1..p_pricing_contexts_Tbl.count loop
691: l_attr_index := l_attr_index +1;
692: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
693: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'N';
694: ELSE
695: px_Req_line_attr_tbl(l_attr_index).VALIDATED_FLAG := 'Y';
696: END IF;

Line 720: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

716: end loop;
717:
718: if copy_hdr_rec_to_line_flag then
719: l_qual_index := l_qual_index +1;
720: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
721: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'N';
722: ELSE
723: px_Req_qual_tbl(l_qual_index).VALIDATED_FLAG := 'Y';
724: END IF;

Line 816: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');

812:
813: begin
814: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
815: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT: In PL/SQL tbl,append_asked_for - Global_Header_Rec quote_status_id'
816: ||ASO_PRICING_INT.G_HEADER_REC.quote_status_id,1,'N');
817: END IF;
818: for asked_for_rec in asked_for_cur loop
819: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
820: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:In append_asked_for asked_for_rec.PRICING_ATTRIBUTE1'

Line 1634: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1630: else -- Copy the Qualifiers
1631: if asked_for_rec.PRICING_ATTRIBUTE1 is not null then -- Promotion
1632: i := px_Req_Qual_Tbl.count+1;
1633: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
1634: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1635: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
1636: ELSE
1637: px_Req_Qual_Tbl(i).Validated_Flag := 'Y';
1638: END IF;

Line 1647: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1643: if asked_for_rec.PRICING_ATTRIBUTE2 is not null then --Deal Component
1644: i := px_Req_Qual_Tbl.count+1;
1645: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
1646: --px_Req_Qual_Tbl(i).Validated_Flag := nvl(asked_for_rec.Override_Flag,'N');
1647: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1648: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
1649: ELSE
1650: px_Req_Qual_Tbl(i).Validated_Flag := 'Y';
1651: END IF;

Line 1660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1656: if asked_for_rec.PRICING_ATTRIBUTE3 is not null then -- Coupons
1657: i := px_Req_Qual_Tbl.count+1;
1658: px_Req_Qual_Tbl(i).Line_Index := p_Line_Index;
1659: --px_Req_Qual_Tbl(i).Validated_Flag := nvl(asked_for_rec.Override_Flag,'N');
1660: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1661: px_Req_Qual_Tbl(i).Validated_Flag := 'N';
1662: ELSE
1663: px_Req_Qual_Tbl(i).Validated_Flag := 'Y';
1664: END IF;

Line 2545: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:g_header_rec.PRICE_FROZEN_DATE '||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'N');

2541: px_req_line_tbl(1).LINE_TYPE_CODE := 'ORDER';
2542: px_req_line_tbl(1).CURRENCY_CODE := p_Header_rec.currency_code;
2543: px_req_line_tbl(1).PRICE_FLAG := 'Y';
2544: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2545: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:g_header_rec.PRICE_FROZEN_DATE '||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'N');
2546: END IF;
2547: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2549: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then

Line 2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE

2544: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2545: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:g_header_rec.PRICE_FROZEN_DATE '||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'N');
2546: END IF;
2547: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2549: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2550: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
2551: else
2552: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

Line 2549: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then

2545: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:g_header_rec.PRICE_FROZEN_DATE '||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'N');
2546: END IF;
2547: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2549: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2550: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
2551: else
2552: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
2553: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2552: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

2548: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2549: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2550: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
2551: else
2552: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
2553: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2554: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Header Request copy In else: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE '
2555: ||px_req_line_tbl(1).PRICING_EFFECTIVE_DATE,1,'N');
2556: END IF;

Line 2569: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,

2565: p_Request_Type VARCHAR2,
2566: p_pricing_event VARCHAR2,
2567: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2568: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
2569: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2570: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2571: is
2572: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2573: l_uom_rate NUMBER;

Line 2627: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE

2623: ELSE
2624: l_req_line_rec.PRICE_FLAG := 'Y';
2625: END IF;
2626: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2627: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2628: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2629: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
2630: else
2631: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

Line 2628: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then

2624: l_req_line_rec.PRICE_FLAG := 'Y';
2625: END IF;
2626: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
2627: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2628: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2629: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
2630: else
2631: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
2632: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2631: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

2627: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
2628: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
2629: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
2630: else
2631: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
2632: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2633: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Line Request copy in Else: l_req_line_rec.PRICING_EFFECTIVE_DATE '
2634: ||l_req_line_rec.PRICING_EFFECTIVE_DATE,1,'N');
2635: END IF;