APPS.ASO_PRICING_FLOWS_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 724: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;

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);
727: l_service_product_id_tbl Index_Link_Tbl_Type;
728: l_service_ref_line_id_tbl Index_Link_Tbl_Type;

Line 725: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;

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);
727: l_service_product_id_tbl Index_Link_Tbl_Type;
728: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
729: l_service_id_tbl Index_Link_Tbl_Type;

Line 740: FROM ASO_QUOTE_LINE_DETAILS

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
740: FROM ASO_QUOTE_LINE_DETAILS
741: WHERE quote_line_id = p_qte_line_id;
742:
743: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
744: SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,

Line 1945: FROM aso_quote_line_details

1941: aso_debug_pub.add('8976983 ASO_PRICING_FLOWS_PVT:MODEL ITEM line id :'||p_qte_line_tbl(i).quote_line_id,1,'Y');
1942: END IF;
1943: for opt_cursor in (
1944: SELECT quote_line_id
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