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 QP_PREQ_GRP

Line 38: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

34: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
35: IS
36: l_api_name CONSTANT VARCHAR2(30) := 'Price_Entire_Quote';
37: l_api_version_number CONSTANT NUMBER := 1.0;
38: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
39: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
40: l_qte_line_id NUMBER;
41: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
42: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 61: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;

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;
65: l_accum_aso_time NUMBER;

Line 62: l_global_num_tbl QP_PREQ_GRP.NUMBER_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;
65: l_accum_aso_time NUMBER;
66: l_accum_qp_time NUMBER;

Line 561: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

557: l_pricing_end_time := dbms_utility.get_time;
558: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
559: END IF;
560:
561: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
562:
563: l_req_control_rec.ORG_ID := p_qte_header_rec.org_id;
564:
565: /* End of Change (MOAC) */

Line 705: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

701: IS
702: l_api_name CONSTANT VARCHAR2(30) := 'Price_Quote_Line';
703: l_api_version_number CONSTANT NUMBER := 1.0;
704: --l_request_type VARCHAR2(60);
705: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
706: l_qte_line_id NUMBER;
707: l_child_qte_line_id NUMBER;
708: l_found NUMBER;
709: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 734: l_global_pls_tbl QP_PREQ_GRP.pls_integer_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.
738: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS

Line 735: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;

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.
738: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS
739: SELECT service_ref_type_code , service_ref_line_id

Line 1348: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

1344: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1345: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
1346: END IF;
1347:
1348: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
1349:
1350: l_req_control_rec.ORG_ID := p_qte_header_rec.org_id;
1351:
1352: /* End of Change (MOAC) */

Line 1497: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

1493: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1494: IS
1495: l_api_name CONSTANT VARCHAR2(30) := 'Price_Quote_With_Change_Lines';
1496: l_api_version_number CONSTANT NUMBER := 1.0;
1497: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1498: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
1499: l_qte_line_id NUMBER;
1500: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1501: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1521: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;

1517: lx_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
1518: l_adj_id_tbl Index_Link_Tbl_Type;
1519: l_price_index Number;
1520: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
1521: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
1522: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
1523:
1524: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1525: l_changed_line_index NUMBER;

Line 1522: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;

1518: l_adj_id_tbl Index_Link_Tbl_Type;
1519: l_price_index Number;
1520: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
1521: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
1522: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
1523:
1524: l_changed_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1525: l_changed_line_index NUMBER;
1526: l_check_line_flag VARCHAR2(1);

Line 2243: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

2239: l_pricing_end_time := dbms_utility.get_time;
2240: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2241: END IF;
2242:
2243: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
2244:
2245: l_req_control_rec.ORG_ID := p_qte_header_rec.org_id;
2246:
2247: /* End of Change (MOAC) */

Line 2364: l_prc_control_rec.calculate_flag := QP_PREQ_GRP.G_CALCULATE_ONLY;

2360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2361: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Price Request should be called again to get header level adj',1,'Y');
2362: END IF;
2363:
2364: l_prc_control_rec.calculate_flag := QP_PREQ_GRP.G_CALCULATE_ONLY;
2365:
2366: --Call Calculate only call
2367:
2368: Price_Quote_Calculate_Call(

Line 2423: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

2419: IS
2420: l_api_name CONSTANT VARCHAR2(30) := 'Price_Quote_Calculate_Call';
2421: l_api_version_number CONSTANT NUMBER := 1.0;
2422: l_price_index NUMBER;
2423: l_req_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2424: l_prc_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE;
2425: x_pass_line VARCHAR2(10);
2426: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2427: l_qte_line_id NUMBER;

Line 2442: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;

2438: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
2439: l_qte_line_id_tbl JTF_NUMBER_TABLE;
2440: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
2441: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
2442: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
2443: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
2444:
2445: l_pricing_start_time NUMBER;
2446: l_pricing_end_time NUMBER;

Line 2443: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;

2439: l_qte_line_id_tbl JTF_NUMBER_TABLE;
2440: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
2441: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
2442: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
2443: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;
2444:
2445: l_pricing_start_time NUMBER;
2446: l_pricing_end_time NUMBER;
2447: l_accum_aso_time NUMBER;

Line 2802: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

2798: l_pricing_end_time := dbms_utility.get_time;
2799: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2800: END IF;
2801:
2802: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
2803:
2804: l_req_control_rec.ORG_ID := p_qte_header_rec.org_id;
2805:
2806: /* End of Change (MOAC) */