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 JTF_NUMBER_TABLE

Line 52: l_qte_line_id_tbl JTF_NUMBER_TABLE;

48: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
49: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: x_pass_line VARCHAR2(10);
52: l_qte_line_id_tbl JTF_NUMBER_TABLE;
53: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
54: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
55: l_index_counter Number; -- This is used to keep track of lx_index_counter
56: lx_index_counter Number;

Line 53: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

49: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: x_pass_line VARCHAR2(10);
52: l_qte_line_id_tbl JTF_NUMBER_TABLE;
53: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
54: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
55: l_index_counter Number; -- This is used to keep track of lx_index_counter
56: lx_index_counter Number;
57: lx_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

Line 54: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

50: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
51: x_pass_line VARCHAR2(10);
52: l_qte_line_id_tbl JTF_NUMBER_TABLE;
53: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
54: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
55: l_index_counter Number; -- This is used to keep track of lx_index_counter
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;

Line 373: l_service_qte_line_id_tbl:= JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

369: else
370: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
371: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: First quote_line_id in l_service_qte_line_id_tbl',1,'Y');
372: END IF;
373: l_service_qte_line_id_tbl:= JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
374: end if;
375: end if;-- l_qte_line_tbl(i).service_item_flag = 'Y'
376:
377: /*Store all the quote_line_id processed*/

Line 388: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

384: ELSE
385: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
386: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: First quote_line_id in l_qte_line_id_tbl',1,'Y');
387: END IF;
388: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
389: END IF;
390: --increment the line index
391: px_line_index_search_tbl(l_qte_line_id) := l_price_index;
392: l_price_index:= l_price_index+1;

Line 456: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);

452: l_adj_id_tbl
453: FROM ASO_PRICE_ADJUSTMENTS adj
454: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
455: AND adj.price_adjustment_id NOT IN (SELECT column_value
456: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);
457:
458: if aso_debug_pub.g_debug_flag = 'Y' THEN
459: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount: '||sql%rowcount,1,'Y');
460: end if;

Line 720: l_qte_line_id_tbl JTF_NUMBER_TABLE;

716: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
717: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;
721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
722: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
723: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
724: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;

Line 721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

717: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;
721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
722: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
723: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
724: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
725: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;

Line 722: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

718: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
719: x_pass_line VARCHAR2(10);
720: l_qte_line_id_tbl JTF_NUMBER_TABLE;
721: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
722: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
723: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
724: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
725: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
726: l_service_proc_done_flag VARCHAR2(1);

Line 974: l_service_qte_line_id_tbl := JTF_NUMBER_TABLE(p_qte_line_tbl(i).quote_line_id);

970: ELSE
971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
972: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Service Qte Line ID Tbl NOT exists... ',1,'Y');
973: END IF;
974: l_service_qte_line_id_tbl := JTF_NUMBER_TABLE(p_qte_line_tbl(i).quote_line_id);
975: END IF;
976:
977: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
978: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Parent Service Line collection ... ',1,'Y');

Line 1240: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

1236: lx_index_counter := l_index_counter;
1237: END IF;
1238:
1239: IF ( i = 1 ) THEN
1240: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
1241: ELSE
1242: l_Qte_Line_id_tbl.extend;
1243: l_Qte_Line_id_tbl(i) := l_qte_line_tbl(i).quote_line_id;
1244: END IF;

Line 1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;

1508: lx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);
1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1513: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
1514: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
1515: l_index_counter Number; -- This is used to keep track of lx_index_counter
1516: lx_index_counter Number;

Line 1513: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

1509: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);
1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1513: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
1514: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
1515: l_index_counter Number; -- This is used to keep track of lx_index_counter
1516: lx_index_counter Number;
1517: lx_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

Line 1514: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

1510: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1511: x_pass_line VARCHAR2(10);
1512: l_qte_line_id_tbl JTF_NUMBER_TABLE;
1513: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
1514: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;
1515: l_index_counter Number; -- This is used to keep track of lx_index_counter
1516: lx_index_counter Number;
1517: lx_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
1518: l_adj_id_tbl Index_Link_Tbl_Type;

Line 1880: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

1876: ELSE
1877: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1878: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: First quote_line_id in l_qte_line_id_tbl',1,'Y');
1879: END IF;
1880: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
1881: END IF;
1882:
1883: --Store all the service lines processed in the service line id table
1884: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1899: l_service_qte_line_id_tbl:= JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

1895: else
1896: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1897: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: First quote_line_id in l_service_qte_line_id_tbl',1,'Y');
1898: END IF;
1899: l_service_qte_line_id_tbl:= JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
1900: end if;
1901: end if;-- l_qte_line_tbl(i).service_item_flag = 'Y'
1902:
1903: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2056: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);

2052: l_adj_id_tbl
2053: FROM ASO_PRICE_ADJUSTMENTS adj
2054: WHERE adj.quote_header_id = p_qte_header_rec.quote_header_id
2055: AND adj.price_adjustment_id NOT IN (SELECT column_value
2056: FROM TABLE (CAST(l_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) passed_adj);
2057:
2058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2059: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No. of adjustment lines selected is sql%rowcount(Both hdr and lines): '
2060: ||sql%rowcount,1,'Y');

Line 2143: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)));

2139: END IF;
2140:
2141: DELETE FROM ASO_PRICE_ADJ_RELATIONSHIPS
2142: WHERE quote_line_id IN (SELECT column_value
2143: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)));
2144:
2145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2146: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
2147: END IF;

Line 2154: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))

2150: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Begin DELETE FROM ASO_PRICE_ADJUSTMENTS', 1, 'Y');
2151: END IF;
2152: DELETE FROM ASO_PRICE_ADJUSTMENTS
2153: WHERE quote_line_id IN (SELECT column_value
2154: FROM TABLE (CAST(l_qte_line_id_tbl AS JTF_NUMBER_TABLE)))
2155: AND quote_header_id = p_qte_header_rec.quote_header_id;
2156: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2157: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Adjustment Lines deleted '||sql%ROWCOUNT,1,'Y');
2158: END IF;

Line 2414: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,

2410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2411: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2412: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2413: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2414: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2415: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2416: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2417: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2418: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2438: l_service_qte_line_id_tbl JTF_NUMBER_TABLE;

2434: l_return_status_text VARCHAR2(2000);
2435: l_message_text VARCHAR2(2000);
2436: l_return_status VARCHAR2(1);
2437:
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;

Line 2439: l_qte_line_id_tbl JTF_NUMBER_TABLE;

2435: l_message_text VARCHAR2(2000);
2436: l_return_status VARCHAR2(1);
2437:
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;

Line 2440: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

2436: l_return_status VARCHAR2(1);
2437:
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:

Line 2690: l_service_qte_line_id_tbl:= JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

2686: else
2687: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2688: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: First quote_line_id in l_service_qte_line_id_tbl',1,'Y');
2689: END IF;
2690: l_service_qte_line_id_tbl:= JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
2691: end if;
2692: end if;-- l_qte_line_tbl(i).service_item_flag = 'Y'
2693:
2694: /*Store all the quote_line_id processed*/

Line 2705: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);

2701: ELSE
2702: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2703: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: First quote_line_id in l_qte_line_id_tbl',1,'Y');
2704: END IF;
2705: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(l_qte_line_tbl(i).quote_line_id);
2706: END IF;
2707: --increment the line index
2708: px_line_index_search_tbl(l_qte_line_id) := l_price_index;
2709: l_price_index:= l_price_index+1;