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,