APPS.ASO_PRICING_FLOWS_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 758: from ASO_QUOTE_LINES_ALL

754: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
755:
756: CURSOR c_get_cust_acct_id_ln(p_qte_line_id number) IS
757: select decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',END_CUSTOMER_CUST_ACCOUNT_ID) cust_account_id
758: from ASO_QUOTE_LINES_ALL
759: WHERE quote_line_id = p_qte_line_id;
760:
761: cursor c_get_price_list(p_qte_hdr_id number) is
762: select price_list_id

Line 964: from aso_quote_lines_all

960: if p_qte_line_tbl(i).operation_code='UPDATE' then
961:
962: select nvl(service_item_flag,'N'), nvl(serviceable_product_flag,'N')
963: into l_service_item_flg, l_servicable_item_flg
964: from aso_quote_lines_all
965: where quote_line_id=p_qte_line_tbl(i).quote_line_id;
966: else
967: l_service_item_flg:= NVL(p_qte_line_tbl(i).service_item_flag,'N') ;
968: l_servicable_item_flg:=nvl(p_qte_line_tbl(i).serviceable_product_flag,'N');

Line 999: from aso_quote_lines_all

995: if p_qte_line_tbl(j).operation_code='UPDATE' then
996:
997: select nvl(service_item_flag,'N'), nvl(serviceable_product_flag,'N')
998: into l_service_item_flg1, l_servicable_item_flg1
999: from aso_quote_lines_all
1000: where quote_line_id=p_qte_line_tbl(j).quote_line_id;
1001: else
1002: l_service_item_flg1:= NVL(p_qte_line_tbl(j).service_item_flag,'N');
1003: l_servicable_item_flg1:=nvl(p_qte_line_tbl(j).serviceable_product_flag,'N');

Line 1909: from aso_quote_lines_all

1905: l_changed_qte_line_tbl(p_qte_line_tbl(i).quote_line_id) := l_qte_line_tbl(p_qte_line_tbl(i).quote_line_id);
1906:
1907: -- Code added for option lines bug 8976983
1908: select nvl(item_type_code,'X') into l_item_type_code
1909: from aso_quote_lines_all
1910: where quote_line_id = p_qte_line_tbl(i).quote_line_id;
1911:
1912: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1913: aso_debug_pub.add('8976983 ASO_PRICING_FLOWS_PVT:MODEL ITEM header id :'||p_qte_line_tbl(i).item_type_code,1,'Y');

Line 1949: select quote_line_id from aso_quote_lines_all

1945: FROM aso_quote_line_details
1946: WHERE ref_type_code = 'CONFIG'
1947: AND top_model_line_id = p_qte_line_tbl(i).quote_line_id
1948: AND quote_line_id in (
1949: select quote_line_id from aso_quote_lines_all
1950: where quote_header_id=p_qte_line_tbl(i).quote_header_id
1951: and item_type_code in ('CFG')))
1952: loop
1953: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2206: FROM ASO_QUOTE_LINES_ALL

2202: --Check no of lines in the db and the (l_price_index - 2), if <> then l_complete_qte_flag is 'N'
2203:
2204: SELECT count(rowid)
2205: INTO l_db_ln_counter
2206: FROM ASO_QUOTE_LINES_ALL
2207: WHERE quote_header_id = p_qte_header_rec.quote_header_id;
2208: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2209: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:l_db_ln_counter:'||l_db_ln_counter,1,'Y');
2210: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:l_price_index:'||l_price_index,1,'Y');