DBA Data[Home] [Help]

APPS.INL_CHARGE_PVT dependencies on QP_PREQ_LINES_TMP

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

1168: l_currency_code(p_ship_ln_tbl(j).shipment_line_id) := p_ship_ln_tbl(j).currency_code;
1169: l_line_index := l_line_index + 1;
1170: END LOOP;
1171:
1172: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';
1173: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1174: p_procedure_name => l_proc_name,
1175: p_debug_info => l_debug_info);
1176:

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

1173: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1174: p_procedure_name => l_proc_name,
1175: p_debug_info => l_debug_info);
1176:
1177: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp
1178: QP_PREQ_GRP.INSERT_LINES2(
1179: p_line_index => l_line_index_tbl,
1180: p_line_type_code => l_line_type_code_tbl,
1181: p_pricing_effective_date => l_pricinl_effective_date_tbl,

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

1294: l_qp_cost_table(k).base_unit_price := l_unit_price_tbl(k);
1295: l_qp_cost_table(k).freight_charge_rec_tbl := l_freight_charge_rec_tbl;
1296: l_qp_cost_table(k).line_id := l_line_id_tbl(k);
1297:
1298: l_debug_info := 'Get pricing_status_code and pricing_status_text from qp_preq_lines_tmp';
1299: INL_LOGGING_PVT.Log_Statement (
1300: p_module_name => g_module_name,
1301: p_procedure_name => l_proc_name,
1302: p_debug_info => l_debug_info

Line 1309: FROM qp_preq_lines_tmp

1305: SELECT pricing_status_code,
1306: pricing_status_text
1307: INTO l_qp_cost_table(k).pricing_status_code,
1308: l_qp_cost_table(k).pricing_status_text
1309: FROM qp_preq_lines_tmp
1310: WHERE line_index = k;
1311: END LOOP;
1312:
1313: l_debug_info := 'Check if the l_qp_cost_table has records';