DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on QP_PREQ_LINES_TMP

Line 815: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';

811: l_currency_code(p_ship_ln_tbl(j).shipment_line_id) := p_ship_ln_tbl(j).currency_code;
812: l_line_index := l_line_index + 1;
813: END LOOP;
814:
815: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';
816: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
817: p_procedure_name => l_proc_name,
818: p_debug_info => l_debug_info);
819:

Line 820: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp

816: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
817: p_procedure_name => l_proc_name,
818: p_debug_info => l_debug_info);
819:
820: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp
821: QP_PREQ_GRP.INSERT_LINES2(p_line_index => l_line_index_tbl,
822: p_line_type_code => l_line_type_code_tbl,
823: p_pricing_effective_date => l_pricinl_effective_date_tbl,
824: p_active_date_first => l_active_date_first_tbl,

Line 935: l_debug_info := 'Get pricing_status_code and pricing_status_text from qp_preq_lines_tmp';

931: l_qp_cost_table(k).base_unit_price := l_unit_price_tbl(k);
932: l_qp_cost_table(k).freight_charge_rec_tbl := l_freight_charge_rec_tbl;
933: l_qp_cost_table(k).line_id := l_line_id_tbl(k);
934:
935: l_debug_info := 'Get pricing_status_code and pricing_status_text from qp_preq_lines_tmp';
936: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
937: p_procedure_name => l_proc_name,
938: p_debug_info => l_debug_info);
939:

Line 944: FROM qp_preq_lines_tmp

940: SELECT pricing_status_code,
941: pricing_status_text
942: INTO l_qp_cost_table(k).pricing_status_code,
943: l_qp_cost_table(k).pricing_status_text
944: FROM qp_preq_lines_tmp
945: WHERE line_index = k;
946: END LOOP;
947:
948: l_debug_info := 'Check if the l_qp_cost_table has records';