DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PRICING_PVT dependencies on ASO_PRICING_INT

Line 115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '

111: px_req_line_tbl(1).LINE_TYPE_CODE := 'ORDER';
112: px_req_line_tbl(1).CURRENCY_CODE := p_Header_rec.currency_code;
113: px_req_line_tbl(1).PRICE_FLAG := 'Y';
114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '
116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');
117: END IF;
118: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
119: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE

Line 116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');

112: px_req_line_tbl(1).CURRENCY_CODE := p_Header_rec.currency_code;
113: px_req_line_tbl(1).PRICE_FLAG := 'Y';
114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '
116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');
117: END IF;
118: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
119: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
120: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then

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

115: aso_debug_pub.add('ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE '
116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');
117: END IF;
118: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
119: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
120: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
121: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
122: else
123: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

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

116: ||ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE,1,'N');
117: END IF;
118: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
119: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
120: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
121: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
122: else
123: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
124: end if;

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

119: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
120: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
121: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(sysdate);
122: else
123: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
124: end if;
125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
126: aso_debug_pub.add('Header Request copy: px_req_line_tbl(1).PRICING_EFFECTIVE_DATE '
127: ||px_req_line_tbl(1).PRICING_EFFECTIVE_DATE,1,'N');

Line 136: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,

132: p_Request_Type VARCHAR2,
133: p_pricing_event VARCHAR2,
134: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
135: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
136: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
137: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
138: is
139: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
140: l_uom_rate NUMBER;

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

178: l_req_line_rec.UPDATED_ADJUSTED_UNIT_PRICE := p_Line_rec.line_quote_price;
179: End If;
180: l_req_line_rec.PRICE_FLAG := 'Y';
181: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
182: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
183: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
184: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
185: else
186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);

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

179: End If;
180: l_req_line_rec.PRICE_FLAG := 'Y';
181: /*FastTrak: Price effective date is assigned to the price frozen unless the price frozen date is null*/
182: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
183: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
184: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
185: else
186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
187: end if;

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

182: if ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE = FND_API.G_MISS_DATE
183: OR ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE is NULL then
184: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(sysdate);
185: else
186: l_req_line_rec.PRICING_EFFECTIVE_DATE := trunc(ASO_PRICING_INT.g_header_rec.PRICE_FROZEN_DATE);
187: end if;
188: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
189: aso_debug_pub.add('copy line request: l_req_line_rec.PRICING_EFFECTIVE_DATE '
190: ||l_req_line_rec.PRICING_EFFECTIVE_DATE,1,'N');

Line 208: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,

204: PROCEDURE Validate_Pricing_Order(
205: P_Api_Version_Number IN NUMBER,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;

268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;
273: l_qte_line_prcd_child ASO_PRICING_INT.Index_Link_Tbl_Type;
274: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
275: l_call_flg Varchar2(1):='Q';
276: l_db_tbl_flg Varchar2(3);

Line 273: l_qte_line_prcd_child ASO_PRICING_INT.Index_Link_Tbl_Type;

269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;
273: l_qte_line_prcd_child ASO_PRICING_INT.Index_Link_Tbl_Type;
274: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
275: l_call_flg Varchar2(1):='Q';
276: l_db_tbl_flg Varchar2(3);
277: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

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

335: END IF;
336: l_request_type := p_control_rec.request_type;
337: l_pricing_event := p_control_rec.pricing_event;
338:
339: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
340: p_qte_header_rec => p_qte_header_rec,
341: p_shipment_rec => p_hd_shipment_rec);
342:
343: /*Debug msgs to check the value of global header record elements passed into pricing order*/

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

430:
431: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
432: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Begin Setting up the G_LINE_REC', 1, 'Y');
433: END IF;
434: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
435: p_qte_line_rec => l_qte_line_tbl(i),
436: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
437: p_shipment_rec => l_shipment_rec);
438: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 597: ASO_PRICING_INT.G_LINE_REC := NULL;

593:
594: /*In lx_Req_line_tbl check for the return status for each line and then populate that status in
595: **x_qte_line_tbl.
596: */
597: ASO_PRICING_INT.G_LINE_REC := NULL;
598: ASO_PRICING_INT.G_HEADER_REC := NULL;
599: /*Returning the same table back to the caller*/
600: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
601: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: After pricing call lx_qte_line_tbl.count:'

Line 598: ASO_PRICING_INT.G_HEADER_REC := NULL;

594: /*In lx_Req_line_tbl check for the return status for each line and then populate that status in
595: **x_qte_line_tbl.
596: */
597: ASO_PRICING_INT.G_LINE_REC := NULL;
598: ASO_PRICING_INT.G_HEADER_REC := NULL;
599: /*Returning the same table back to the caller*/
600: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
601: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT: After pricing call lx_qte_line_tbl.count:'
602: ||nvl(lx_qte_line_tbl.count,0),1,'Y');