eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PRICING_FLOWS_PVT dependencies on ASO_PRICING_CORE_PVT

Line 60: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;

56: lx_index_counter Number;
57: lx_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
58: l_adj_id_tbl Index_Link_Tbl_Type;
59: l_price_index Number;
60: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
61: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
62: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
63: l_pricing_start_time NUMBER;
64: l_pricing_end_time NUMBER;

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

101: If p_internal_call_flag = 'N' then
102: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
103: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Header Level... ',1,'Y');
104: END IF;
105: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
106: p_qte_header_rec => p_qte_header_rec,
107: p_shipment_rec => p_hd_shipment_rec);
108: end If;--If p_internal_call_flag = 'N' then
109:

Line 110: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;

106: p_qte_header_rec => p_qte_header_rec,
107: p_shipment_rec => p_hd_shipment_rec);
108: end If;--If p_internal_call_flag = 'N' then
109:
110: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
111: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
112: l_pricing_end_time := dbms_utility.get_time;
113: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;
114: END IF;

Line 135: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(

131: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
132: END IF;
133:
134:
135: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(
136: p_Request_Type => p_control_rec.request_type,
137: p_price_line_index => l_price_index,
138: px_index_counter => 1);
139:

Line 145: ASO_PRICING_CORE_PVT.Append_asked_for(

141: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Append_asked_for...',1,'Y');
142: END IF;
143:
144: lx_index_counter:= 1;
145: ASO_PRICING_CORE_PVT.Append_asked_for(
146: p_pricing_event => p_control_rec.pricing_event,
147: p_price_line_index => l_price_index,
148: p_header_id => p_qte_header_rec.quote_header_id,
149: px_index_counter => lx_index_counter);

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

300: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:l_shipment_rec.REQUEST_DATE:'
301: ||NVL(to_char(l_shipment_rec.REQUEST_DATE),'NULL'),1,'Y');
302: END IF;
303:
304: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
305: p_qte_line_rec => l_qte_line_tbl(i),
306: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
307: p_shipment_rec => l_shipment_rec);
308:

Line 309: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;

305: p_qte_line_rec => l_qte_line_tbl(i),
306: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
307: p_shipment_rec => l_shipment_rec);
308:
309: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
310:
311: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
312: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
313: l_pricing_end_time := dbms_utility.get_time;

Line 331: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(

327: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
328: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Line_To_Request...',1,'Y');
329: END IF;
330:
331: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(
332: p_Request_Type => p_control_rec.request_type,
333: p_price_line_index => l_price_index,
334: px_index_counter => i+1);
335:

Line 343: ASO_PRICING_CORE_PVT.Append_asked_for(

339: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Before Append Ask for lx_index_counter:'
340: ||lx_index_counter,1,'Y');
341: END IF;
342: l_index_counter := lx_index_counter;
343: ASO_PRICING_CORE_PVT.Append_asked_for(
344: p_pricing_event => p_control_rec.pricing_event,
345: p_price_line_index => l_price_index,
346: p_header_id => p_qte_header_rec.quote_header_id,
347: p_line_id => l_qte_line_tbl(i).quote_line_id,

Line 406: ASO_PRICING_CORE_PVT.Query_Price_Adjustments

402: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adjustments...',1,'Y');
403: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_id_tbl.count :'
404: ||NVL(l_qte_line_id_tbl.count,0),1,'Y');
405: END IF;
406: ASO_PRICING_CORE_PVT.Query_Price_Adjustments
407: (p_quote_header_id => p_qte_header_rec.quote_header_id,
408: p_qte_line_id_tbl => l_qte_line_id_tbl,
409: x_adj_id_tbl => l_qte_adj_id_tbl);
410:

Line 424: ASO_PRICING_CORE_PVT.Query_relationships

420: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_service_qte_line_id_tbl.count :'
421: ||NVL(l_service_qte_line_id_tbl.count,0),1,'Y');
422: end if;
423: END IF;
424: ASO_PRICING_CORE_PVT.Query_relationships
425: (p_qte_adj_id_tbl => l_qte_adj_id_tbl,
426: p_service_qte_line_id_tbl => l_service_qte_line_id_tbl);
427: else
428: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 513: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;

509: If (l_qte_line_tbl.count <> 0 ) OR (p_control_rec.pricing_event = 'ORDER') then
510: --Condition was placed because engine call was not necessary if the event is price and there are no lines
511:
512: --Need to modify the global index table of pls integer types
513: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
514: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
515: p_global_tbl => l_global_pls_tbl,
516: p_search_tbl => px_line_index_search_tbl);
517: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

Line 514: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(

510: --Condition was placed because engine call was not necessary if the event is price and there are no lines
511:
512: --Need to modify the global index table of pls integer types
513: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
514: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
515: p_global_tbl => l_global_pls_tbl,
516: p_search_tbl => px_line_index_search_tbl);
517: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
518: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 517: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

513: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
514: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
515: p_global_tbl => l_global_pls_tbl,
516: p_search_tbl => px_line_index_search_tbl);
517: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
518: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
519: p_global_tbl => l_global_num_tbl,
520: p_search_tbl => px_line_index_search_tbl);
521: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

Line 518: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

514: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
515: p_global_tbl => l_global_pls_tbl,
516: p_search_tbl => px_line_index_search_tbl);
517: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
518: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
519: p_global_tbl => l_global_num_tbl,
520: p_search_tbl => px_line_index_search_tbl);
521: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
522: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 521: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

517: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
518: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
519: p_global_tbl => l_global_num_tbl,
520: p_search_tbl => px_line_index_search_tbl);
521: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
522: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
523: p_global_tbl => l_global_num_tbl,
524: p_search_tbl => px_line_index_search_tbl);
525:

Line 522: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

518: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
519: p_global_tbl => l_global_num_tbl,
520: p_search_tbl => px_line_index_search_tbl);
521: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
522: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
523: p_global_tbl => l_global_num_tbl,
524: p_search_tbl => px_line_index_search_tbl);
525:
526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 532: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

528: l_pricing_end_time := dbms_utility.get_time;
529: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
530: END IF;
531:
532: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
533:
534: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
535: l_pricing_start_time := dbms_utility.get_time;
536: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);

Line 596: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(

592: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Post_Price_Request...',1,'Y');
593: END IF;
594:
595:
596: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
597: P_Api_Version_Number => 1.0,
598: P_Init_Msg_List => FND_API.G_FALSE,
599: P_Commit => FND_API.G_FALSE,
600: p_control_rec => l_prc_control_rec,

Line 612: ASO_PRICING_CORE_PVT.Process_PRG(

608: END IF;
609:
610: If p_internal_call_flag = 'N' then
611: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: ASO_PRICING_CORE_PVT.Process_PRG(
613: P_Api_Version_Number => 1.0,
614: P_Init_Msg_List => FND_API.G_FALSE,
615: P_Commit => FND_API.G_FALSE,
616: p_control_rec => l_prc_control_rec,

Line 636: ASO_PRICING_CORE_PVT.Process_Charges(

632: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '
633: ||x_qte_line_tbl.count,1,'Y');
634: END IF;
635:
636: ASO_PRICING_CORE_PVT.Process_Charges(
637: P_Api_Version_Number => 1.0,
638: P_Init_Msg_List => FND_API.G_FALSE,
639: P_Commit => FND_API.G_FALSE,
640: p_control_rec => l_prc_control_rec,

Line 733: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;

729: l_service_id_tbl Index_Link_Tbl_Type;
730: lx_index_counter Number;
731: l_index_counter Number; -- This is used to keep track of lx_index_counter
732: l_price_index Number;
733: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
734: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
735: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
736:
737: -- The following three cursors are needed for service lines processing.

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

840:
841: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
842: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Header Level... ',1,'Y');
843: END IF;
844: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
845: p_qte_header_rec => p_qte_header_rec,
846: p_shipment_rec => p_hd_shipment_rec);
847:
848: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;

Line 848: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;

844: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
845: p_qte_header_rec => p_qte_header_rec,
846: p_shipment_rec => p_hd_shipment_rec);
847:
848: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
849:
850: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
851: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build Contexts - Header Level ... ',1,'Y');
852: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: p_qte_header_rec.quote_header_id: '

Line 872: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(

868: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
869: END IF;
870:
871:
872: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(
873: p_Request_Type => p_control_rec.request_type,
874: p_price_line_index => l_price_index,
875: px_index_counter => 1);
876:

Line 882: ASO_PRICING_CORE_PVT.Append_asked_for(

878: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Append_asked_for...',1,'Y');
879: END IF;
880:
881: lx_index_counter := 1;
882: ASO_PRICING_CORE_PVT.Append_asked_for(
883: p_pricing_event => p_control_rec.pricing_event,
884: p_price_line_index => l_price_index,
885: p_header_id => p_qte_header_rec.quote_header_id,
886: px_index_counter => lx_index_counter);

Line 896: ASO_PRICING_CORE_PVT.Query_Price_Adj_Header(

892: IF ( p_control_rec.pricing_event = 'BATCH' ) THEN
893: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
894: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adj_Header...',1,'Y');
895: END IF;
896: ASO_PRICING_CORE_PVT.Query_Price_Adj_Header(
897: p_quote_header_id => p_qte_header_rec.quote_header_id) ;
898: END IF;
899: --increment the line index
900: l_price_index:= l_price_index+1;

Line 1046: -- l_service_qte_line_id_tbl is one of the parameter for ASO_PRICING_CORE_PVT.Query_Relationships procedure.

1042: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Service Line collection to pass for Query Relationships procedure... ',1,'Y');
1043: END IF;
1044:
1045: -- l_service_qte_line_id_tbl is used to collect all quote line id(s) of service lines only.
1046: -- l_service_qte_line_id_tbl is one of the parameter for ASO_PRICING_CORE_PVT.Query_Relationships procedure.
1047: IF l_service_qte_line_id_tbl.exists(1) THEN
1048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1049: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Service Qte Line ID Tbl already exists... ',1,'Y');
1050: END IF;

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

1339:
1340: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1341: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Line Level...', 1, 'Y');
1342: END IF;
1343: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
1344: p_qte_line_rec => l_qte_line_tbl(i),
1345: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
1346: p_shipment_rec => l_shipment_rec);
1347:

Line 1348: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;

1344: p_qte_line_rec => l_qte_line_tbl(i),
1345: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
1346: p_shipment_rec => l_shipment_rec);
1347:
1348: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
1349:
1350:
1351: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1352: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');

Line 1390: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(

1386: END IF;
1387:
1388: -- End fix for bug 5951790.
1389:
1390: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(
1391: p_Request_Type => p_control_rec.request_type,
1392: p_price_line_index => l_price_index,
1393: px_index_counter => i+1);
1394:

Line 1401: ASO_PRICING_CORE_PVT.Append_asked_for(

1397: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Append_asked_for...',1,'Y');
1398: END IF;
1399:
1400: l_index_counter := lx_index_counter;
1401: ASO_PRICING_CORE_PVT.Append_asked_for(
1402: p_pricing_event => p_control_rec.pricing_event
1403: ,p_price_line_index => l_price_index
1404: ,p_header_id => p_qte_header_rec.quote_header_id
1405: ,p_line_id => l_qte_line_tbl(i).quote_line_id

Line 1437: ASO_PRICING_CORE_PVT.Query_Price_Adjustments(

1433: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_id_tbl.count : '||NVL(l_qte_line_id_tbl.count,0),1,'Y');
1434: END IF;
1435:
1436: IF p_control_rec.pricing_event = 'BATCH' THEN
1437: ASO_PRICING_CORE_PVT.Query_Price_Adjustments(
1438: p_quote_header_id => p_qte_header_rec.quote_header_id,
1439: p_qte_line_id_tbl => l_qte_line_id_tbl,
1440: x_adj_id_tbl => l_qte_adj_id_tbl);
1441: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1450: ASO_PRICING_CORE_PVT.Query_Relationships(

1446: -- Adjustment,line,Services Relationships.
1447: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1448: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Relationships...',1,'Y');
1449: END IF;
1450: ASO_PRICING_CORE_PVT.Query_Relationships(
1451: p_qte_adj_id_tbl => l_qte_adj_id_tbl,
1452: p_service_qte_line_id_tbl => l_service_qte_line_id_tbl);
1453:
1454: FOR i IN 1..l_qte_line_tbl.count LOOP

Line 1489: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;

1485:
1486: If l_qte_line_tbl.count >0 then
1487:
1488: --Need to modify the global index table of pls integer types
1489: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
1490: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
1491: p_global_tbl => l_global_pls_tbl,
1492: p_search_tbl => px_line_index_search_tbl);
1493: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

Line 1490: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(

1486: If l_qte_line_tbl.count >0 then
1487:
1488: --Need to modify the global index table of pls integer types
1489: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
1490: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
1491: p_global_tbl => l_global_pls_tbl,
1492: p_search_tbl => px_line_index_search_tbl);
1493: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
1494: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 1493: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

1489: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
1490: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
1491: p_global_tbl => l_global_pls_tbl,
1492: p_search_tbl => px_line_index_search_tbl);
1493: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
1494: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
1495: p_global_tbl => l_global_num_tbl,
1496: p_search_tbl => px_line_index_search_tbl);
1497: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

Line 1494: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

1490: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
1491: p_global_tbl => l_global_pls_tbl,
1492: p_search_tbl => px_line_index_search_tbl);
1493: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
1494: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
1495: p_global_tbl => l_global_num_tbl,
1496: p_search_tbl => px_line_index_search_tbl);
1497: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
1498: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 1497: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

1493: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
1494: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
1495: p_global_tbl => l_global_num_tbl,
1496: p_search_tbl => px_line_index_search_tbl);
1497: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
1498: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
1499: p_global_tbl => l_global_num_tbl,
1500: p_search_tbl => px_line_index_search_tbl);
1501:

Line 1498: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

1494: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
1495: p_global_tbl => l_global_num_tbl,
1496: p_search_tbl => px_line_index_search_tbl);
1497: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
1498: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
1499: p_global_tbl => l_global_num_tbl,
1500: p_search_tbl => px_line_index_search_tbl);
1501:
1502: End If; -- l_qte_line_tbl.count >0

Line 1508: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

1504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1505: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Populate_QP_Temp_tables...',1,'Y');
1506: END IF;
1507:
1508: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
1509:
1510: -- Set the control rec for QP
1511:
1512: l_req_control_rec.pricing_event := p_control_rec.pricing_event;

Line 1560: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(

1556: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Price_To_Quote...',1,'Y');
1557: END IF;
1558:
1559:
1560: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
1561: P_Api_Version_Number => 1.0,
1562: P_Init_Msg_List => FND_API.G_FALSE,
1563: P_Commit => p_commit,
1564: p_control_rec => p_control_rec,

Line 1580: ASO_PRICING_CORE_PVT.Process_Charges(

1576: END IF;
1577:
1578: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: ASO_PRICING_CORE_PVT.Process_Charges(
1581: P_Api_Version_Number => 1.0,
1582: P_Init_Msg_List => FND_API.G_FALSE,
1583: P_Commit => p_commit,
1584: p_control_rec => p_control_rec,

Line 1698: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;

1694: lx_index_counter Number;
1695: lx_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
1696: l_adj_id_tbl Index_Link_Tbl_Type;
1697: l_price_index Number;
1698: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
1699: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
1700: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
1701:
1702: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

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

1760: If p_internal_call_flag = 'N' then
1761: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1762: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Set_Global_Rec - Header Level... ',1,'Y');
1763: END IF;
1764: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
1765: p_qte_header_rec => p_qte_header_rec,
1766: p_shipment_rec => p_hd_shipment_rec);
1767: end If;--If p_internal_call_flag = 'N' then
1768:

Line 1769: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;

1765: p_qte_header_rec => p_qte_header_rec,
1766: p_shipment_rec => p_hd_shipment_rec);
1767: end If;--If p_internal_call_flag = 'N' then
1768:
1769: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
1770:
1771: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1772: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Build_Context - Header Level... ',1,'Y');
1773: l_pricing_end_time := dbms_utility.get_time;

Line 1796: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(

1792: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
1793: END IF;
1794:
1795:
1796: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(
1797: p_Request_Type => p_control_rec.request_type,
1798: p_price_line_index => l_price_index,
1799: px_index_counter => 1);
1800:

Line 1806: ASO_PRICING_CORE_PVT.Append_asked_for(

1802: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Append_asked_for...',1,'Y');
1803: END IF;
1804:
1805: lx_index_counter:= 1;
1806: ASO_PRICING_CORE_PVT.Append_asked_for(
1807: p_pricing_event => p_control_rec.pricing_event,
1808: p_price_line_index => l_price_index,
1809: p_header_id => p_qte_header_rec.quote_header_id,
1810: px_index_counter => lx_index_counter);

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

2073: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:l_shipment_rec.REQUEST_DATE:'
2074: ||NVL(to_char(l_shipment_rec.REQUEST_DATE),'NULL'),1,'Y');
2075: END IF;
2076:
2077: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
2078: p_qte_line_rec => l_qte_line_tbl(i),
2079: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
2080: p_shipment_rec => l_shipment_rec);
2081:

Line 2082: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;

2078: p_qte_line_rec => l_qte_line_tbl(i),
2079: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
2080: p_shipment_rec => l_shipment_rec);
2081:
2082: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
2083:
2084: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2085: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
2086: l_pricing_end_time := dbms_utility.get_time;

Line 2146: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(

2142:
2143: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2144: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Line_To_Request...',1,'Y');
2145: END IF;
2146: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(
2147: p_Request_Type => p_control_rec.request_type,
2148: p_price_line_index => l_price_index,
2149: px_index_counter => l_price_index);
2150:

Line 2157: ASO_PRICING_CORE_PVT.Append_asked_for(

2153: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Before Append Ask for lx_index_counter:'
2154: ||lx_index_counter,1,'Y');
2155: END IF;
2156: l_index_counter := lx_index_counter;
2157: ASO_PRICING_CORE_PVT.Append_asked_for(
2158: p_pricing_event => p_control_rec.pricing_event,
2159: p_price_line_index => l_price_index,
2160: p_header_id => p_qte_header_rec.quote_header_id,
2161: p_line_id => l_qte_line_tbl(i).quote_line_id,

Line 2238: ASO_PRICING_CORE_PVT.Query_Price_Adjustments

2234: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adjustments...',1,'Y');
2235: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_id_tbl.count :'
2236: ||NVL(l_qte_line_id_tbl.count,0),1,'Y');
2237: END IF;
2238: ASO_PRICING_CORE_PVT.Query_Price_Adjustments
2239: (p_quote_header_id => p_qte_header_rec.quote_header_id,
2240: p_qte_line_id_tbl => l_qte_line_id_tbl,
2241: x_adj_id_tbl => l_qte_adj_id_tbl);
2242:

Line 2256: ASO_PRICING_CORE_PVT.Query_relationships

2252: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_service_qte_line_id_tbl.count :'
2253: ||NVL(l_service_qte_line_id_tbl.count,0),1,'Y');
2254: end if;
2255: END IF;
2256: ASO_PRICING_CORE_PVT.Query_relationships
2257: (p_qte_adj_id_tbl => l_qte_adj_id_tbl,
2258: p_service_qte_line_id_tbl => l_service_qte_line_id_tbl);
2259: else
2260: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2269: ASO_PRICING_CORE_PVT.Query_Price_Adj_Header

2265: --Just send the header level manual adjustments
2266: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2267: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adj_Header...',1,'Y');
2268: END IF;
2269: ASO_PRICING_CORE_PVT.Query_Price_Adj_Header
2270: (p_quote_header_id => p_qte_header_rec.quote_header_id);
2271:
2272: END IF; -- l_Qte_Line_id_tbl.EXISTS(1) check.
2273:

Line 2428: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;

2424: OR (lx_order_status_rec.summary_line_flag = 'Y') then
2425: --Condition was placed because engine call was not necessary if the event is price and there are no lines
2426:
2427: --Need to modify the global index table of pls integer types
2428: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
2429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2430: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Modifying G_LDET_LINE_INDEX_TBL',1,'Y');
2431: END IF;
2432: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(

Line 2432: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(

2428: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
2429: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2430: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Modifying G_LDET_LINE_INDEX_TBL',1,'Y');
2431: END IF;
2432: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
2433: p_global_tbl => l_global_pls_tbl,
2434: p_search_tbl => px_line_index_search_tbl);
2435: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
2436: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2435: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

2431: END IF;
2432: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
2433: p_global_tbl => l_global_pls_tbl,
2434: p_search_tbl => px_line_index_search_tbl);
2435: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
2436: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2437: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Modifying G_RLTD_LINE_INDEX_TBL',1,'Y');
2438: END IF;
2439: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 2439: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

2435: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
2436: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2437: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Modifying G_RLTD_LINE_INDEX_TBL',1,'Y');
2438: END IF;
2439: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
2440: p_global_tbl => l_global_num_tbl,
2441: p_search_tbl => px_line_index_search_tbl);
2442: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
2443: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2442: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

2438: END IF;
2439: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
2440: p_global_tbl => l_global_num_tbl,
2441: p_search_tbl => px_line_index_search_tbl);
2442: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
2443: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2444: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Modifying G_RLTD_RELATED_LINE_IND_TBL',1,'Y');
2445: END IF;
2446: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 2446: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

2442: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
2443: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2444: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Modifying G_RLTD_RELATED_LINE_IND_TBL',1,'Y');
2445: END IF;
2446: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
2447: p_global_tbl => l_global_num_tbl,
2448: p_search_tbl => px_line_index_search_tbl);
2449:
2450: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2456: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

2452: l_pricing_end_time := dbms_utility.get_time;
2453: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2454: END IF;
2455:
2456: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
2457:
2458: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2459: l_pricing_start_time := dbms_utility.get_time;
2460: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);

Line 2517: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(

2513: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Post_Price_Request...',1,'Y');
2514: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_complete_qte_flag:'||l_complete_qte_flag,1,'Y');
2515: END IF;
2516: /*Insert all the applied adjustments and the nonapplied manual adjustments*/
2517: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2518: P_Api_Version_Number => 1.0,
2519: P_Init_Msg_List => FND_API.G_FALSE,
2520: P_Commit => FND_API.G_FALSE,
2521: p_control_rec => l_prc_control_rec,

Line 2534: ASO_PRICING_CORE_PVT.Process_PRG(

2530: END IF;
2531:
2532: If p_internal_call_flag = 'N' then
2533: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2534: ASO_PRICING_CORE_PVT.Process_PRG(
2535: P_Api_Version_Number => 1.0,
2536: P_Init_Msg_List => FND_API.G_FALSE,
2537: P_Commit => FND_API.G_FALSE,
2538: p_control_rec => l_prc_control_rec,

Line 2558: ASO_PRICING_CORE_PVT.Process_Charges(

2554: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '
2555: ||x_qte_line_tbl.count,1,'Y');
2556: END IF;
2557:
2558: ASO_PRICING_CORE_PVT.Process_Charges(
2559: P_Api_Version_Number => 1.0,
2560: P_Init_Msg_List => FND_API.G_FALSE,
2561: P_Commit => FND_API.G_FALSE,
2562: p_control_rec => l_prc_control_rec,

Line 2681: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;

2677:
2678: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
2679: l_qte_line_id_tbl JTF_NUMBER_TABLE;
2680: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
2681: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
2682: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
2683: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
2684:
2685: l_pricing_start_time NUMBER;

Line 2724: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;

2720:
2721: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2722: aso_debug_pub.add('********************* PROCESSING HEADER STARTS *******************************',1,'Y');
2723: END IF;
2724: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
2725: /*Initialize the global tables*/
2726: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
2727:
2728: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2726: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;

2722: aso_debug_pub.add('********************* PROCESSING HEADER STARTS *******************************',1,'Y');
2723: END IF;
2724: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
2725: /*Initialize the global tables*/
2726: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
2727:
2728: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2729: l_pricing_end_time := dbms_utility.get_time;
2730: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;

Line 2750: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(

2746: l_accum_qp_time := l_pricing_start_time - l_pricing_end_time;
2747: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2748: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
2749: END IF;
2750: ASO_PRICING_CORE_PVT.Copy_Header_To_Request(
2751: p_Request_Type => p_control_rec.request_type,
2752: p_price_line_index => l_price_index,
2753: px_index_counter => 1);
2754:

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

2870: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:l_shipment_rec.REQUEST_DATE:'
2871: ||NVL(to_char(l_shipment_rec.REQUEST_DATE),'NULL'),1,'Y');
2872: END IF;
2873:
2874: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
2875: p_qte_line_rec => l_qte_line_tbl(i),
2876: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
2877: p_shipment_rec => l_shipment_rec);
2878:

Line 2879: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;

2875: p_qte_line_rec => l_qte_line_tbl(i),
2876: p_qte_line_dtl_rec => l_qte_line_dtl_rec,
2877: p_shipment_rec => l_shipment_rec);
2878:
2879: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
2880:
2881: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2882: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
2883: l_pricing_end_time := dbms_utility.get_time;

Line 2902: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(

2898: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2899: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Line_To_Request...',1,'Y');
2900: END IF;
2901:
2902: ASO_PRICING_CORE_PVT.Copy_Line_To_Request(
2903: p_Request_Type => p_control_rec.request_type,
2904: p_price_line_index => l_price_index,
2905: px_index_counter => i+1);
2906:

Line 2963: ASO_PRICING_CORE_PVT.Query_Price_Adj_All

2959: l_pricing_start_time := dbms_utility.get_time;
2960: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adj_All...',1,'Y');
2961: END IF;
2962:
2963: ASO_PRICING_CORE_PVT.Query_Price_Adj_All
2964: (p_quote_header_id => p_qte_header_rec.quote_header_id,
2965: x_adj_id_tbl => l_qte_adj_id_tbl);
2966:
2967:

Line 2972: ASO_PRICING_CORE_PVT.Query_Relationships(

2968: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2969: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Relationships...',1,'Y');
2970: END IF;
2971:
2972: ASO_PRICING_CORE_PVT.Query_Relationships(
2973: p_qte_adj_id_tbl => l_qte_adj_id_tbl,
2974: p_service_qte_line_id_tbl => l_service_qte_line_id_tbl);
2975:
2976:

Line 2999: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;

2995: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Hdr Adjustment Attributes deleted '||sql%ROWCOUNT,1,'Y');
2996: END IF;
2997:
2998: --Need to modify the global index table of pls integer types
2999: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
3000: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
3001: p_global_tbl => l_global_pls_tbl,
3002: p_search_tbl => px_line_index_search_tbl);
3003: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

Line 3000: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(

2996: END IF;
2997:
2998: --Need to modify the global index table of pls integer types
2999: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
3000: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
3001: p_global_tbl => l_global_pls_tbl,
3002: p_search_tbl => px_line_index_search_tbl);
3003: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
3004: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 3003: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;

2999: l_global_pls_tbl := ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL;
3000: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
3001: p_global_tbl => l_global_pls_tbl,
3002: p_search_tbl => px_line_index_search_tbl);
3003: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
3004: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
3005: p_global_tbl => l_global_num_tbl,
3006: p_search_tbl => px_line_index_search_tbl);
3007: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

Line 3004: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

3000: ASO_PRICING_CORE_PVT.G_LDET_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_PlsIndex_Table(
3001: p_global_tbl => l_global_pls_tbl,
3002: p_search_tbl => px_line_index_search_tbl);
3003: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
3004: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
3005: p_global_tbl => l_global_num_tbl,
3006: p_search_tbl => px_line_index_search_tbl);
3007: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
3008: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

Line 3007: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;

3003: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL;
3004: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
3005: p_global_tbl => l_global_num_tbl,
3006: p_search_tbl => px_line_index_search_tbl);
3007: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
3008: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
3009: p_global_tbl => l_global_num_tbl,
3010: p_search_tbl => px_line_index_search_tbl);
3011:

Line 3008: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(

3004: ASO_PRICING_CORE_PVT.G_RLTD_LINE_INDEX_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
3005: p_global_tbl => l_global_num_tbl,
3006: p_search_tbl => px_line_index_search_tbl);
3007: l_global_num_tbl := ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL;
3008: ASO_PRICING_CORE_PVT.G_RLTD_RELATED_LINE_IND_TBL:= ASO_PRICING_CORE_PVT.Modify_Global_NumIndex_Table(
3009: p_global_tbl => l_global_num_tbl,
3010: p_search_tbl => px_line_index_search_tbl);
3011:
3012: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 3018: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

3014: l_pricing_end_time := dbms_utility.get_time;
3015: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
3016: END IF;
3017:
3018: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
3019:
3020: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3021: l_pricing_start_time := dbms_utility.get_time;
3022: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);

Line 3077: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(

3073: ||l_return_status_text,1,'Y');
3074: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Post_Price_Request...',1,'Y');
3075: END IF;
3076:
3077: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
3078: P_Api_Version_Number => 1.0,
3079: P_Init_Msg_List => FND_API.G_FALSE,
3080: P_Commit => FND_API.G_FALSE,
3081: p_control_rec => l_prc_control_rec,

Line 3092: ASO_PRICING_CORE_PVT.Process_Charges(

3088: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Copy_Price_To_Quote : x_return_status: '
3089: ||nvl(x_return_status,'NULL'),1,'Y');
3090: END IF;
3091: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3092: ASO_PRICING_CORE_PVT.Process_Charges(
3093: P_Api_Version_Number => 1.0,
3094: P_Init_Msg_List => FND_API.G_FALSE,
3095: P_Commit => FND_API.G_FALSE,
3096: p_control_rec => l_prc_control_rec,