[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mum.uom_code
INTO l_uom_code
FROM mtl_units_of_measure mum
WHERE mum.unit_of_measure = p_uom;
PO_DEBUG.debug_stmt(l_log_head,l_progress,'Directly Insert into Temp table');
PO_DEBUG.debug_stmt(l_log_head,l_progress,'Call INSERT_LINES2');
QP_PREQ_GRP.INSERT_LINES2
(p_line_index => l_line_index_tbl,
p_line_type_code => l_line_type_code_tbl,
p_pricing_effective_date => l_pricinl_effective_date_tbl,
p_active_date_first => l_active_date_first_tbl,
p_active_date_first_type => l_active_date_first_type_tbl,
p_active_date_second => l_active_date_second_tbl,
p_active_date_second_type => l_active_date_second_type_tbl,
p_line_quantity => l_line_quantity_tbl,
p_line_uom_code => l_line_uom_code_tbl,
p_request_type_code => l_request_type_code_tbl,
p_priced_quantity => l_priced_quantity_tbl,
p_priced_uom_code => l_priced_uom_code_tbl,
p_currency_code => l_currency_code_tbl,
p_unit_price => l_unit_price_tbl,
p_percent_price => l_percent_price_tbl,
p_uom_quantity => l_uom_quantity_tbl,
p_adjusted_unit_price => l_adjusted_unit_price_tbl,
p_upd_adjusted_unit_price => l_upd_adjusted_unit_price_tbl,
p_processed_flag => l_processed_flag_tbl,
p_price_flag => l_price_flag_tbl,
p_line_id => l_line_id_tbl,
p_processing_order => l_processing_order_tbl,
p_pricing_status_code => l_pricing_status_code_tbl,
p_pricing_status_text => l_pricing_status_text_tbl,
p_rounding_flag => l_rounding_flag_tbl,
p_rounding_factor => l_rounding_factor_tbl,
p_qualifiers_exist_flag => l_qualifiers_exist_flag_tbl,
p_pricing_attrs_exist_flag => l_pricing_attrs_exist_flag_tbl,
p_price_list_id => l_price_list_id_tbl,
p_validated_flag => l_pl_validated_flag_tbl,
p_price_request_code => l_price_request_code_tbl,
p_usage_pricing_type => l_usage_pricing_type_tbl,
p_line_category => l_line_category_tbl,
p_line_unit_price => l_line_unit_price_tbl,
p_list_price_override_flag => l_list_price_overide_flag_tbl,
x_status_code => x_return_status,
x_status_text => l_return_status_text);
PO_DEBUG.debug_stmt(l_log_head,l_progress,'After Calling INSERT_LINES2');
l_control_rec.temp_table_insert_flag := 'N';
SELECT line_unit_price,
adjusted_unit_price,
pricing_status_code,
pricing_status_text
INTO x_base_unit_price,
x_unit_price,
l_price_status_code,
l_price_status_text
FROM QP_PREQ_LINES_TMP
WHERE line_id = l_line_id
AND (processed_code IS NULL OR processed_code <> 'INVALID');
SELECT purchase_basis,
-- Bug 3343261: should use value_basis instead of matching_basis
-- matching_basis,
order_type_lookup_code
INTO l_purchase_basis,
-- Bug 3343261: should use value_basis instead of matching_basis
-- l_matching_basis,
l_value_basis
FROM PO_LINE_TYPES
WHERE line_type_id = p_line_type_id;
SELECT mum.uom_code
INTO l_uom_code
FROM mtl_units_of_measure mum
WHERE mum.unit_of_measure = p_line_rec_tbl(j).unit_of_measure;
PO_LOG.stmt(l_log_head,d_pos,'Directly Insert into Temp table');
PO_LOG.stmt(l_log_head,d_pos,'Call INSERT_LINES2');
QP_PREQ_GRP.INSERT_LINES2
(p_line_index => l_line_index_tbl,
p_line_type_code => l_line_type_code_tbl,
p_pricing_effective_date => l_pricinl_effective_date_tbl,
p_active_date_first => l_active_date_first_tbl,
p_active_date_first_type => l_active_date_first_type_tbl,
p_active_date_second => l_active_date_second_tbl,
p_active_date_second_type => l_active_date_second_type_tbl,
p_line_quantity => l_line_quantity_tbl,
p_line_uom_code => l_line_uom_code_tbl,
p_request_type_code => l_request_type_code_tbl,
p_priced_quantity => l_priced_quantity_tbl,
p_priced_uom_code => l_priced_uom_code_tbl,
p_currency_code => l_currency_code_tbl,
p_unit_price => l_unit_price_tbl,
p_percent_price => l_percent_price_tbl,
p_uom_quantity => l_uom_quantity_tbl,
p_adjusted_unit_price => l_adjusted_unit_price_tbl,
p_upd_adjusted_unit_price => l_upd_adjusted_unit_price_tbl,
p_processed_flag => l_processed_flag_tbl,
p_price_flag => l_price_flag_tbl,
p_line_id => l_line_id_tbl,
p_processing_order => l_processing_order_tbl,
p_pricing_status_code => l_pricing_status_code_tbl,
p_pricing_status_text => l_pricing_status_text_tbl,
p_rounding_flag => l_rounding_flag_tbl,
p_rounding_factor => l_rounding_factor_tbl,
p_qualifiers_exist_flag => l_qualifiers_exist_flag_tbl,
p_pricing_attrs_exist_flag => l_pricing_attrs_exist_flag_tbl,
p_price_list_id => l_price_list_id_tbl,
p_validated_flag => l_pl_validated_flag_tbl,
p_price_request_code => l_price_request_code_tbl,
p_usage_pricing_type => l_usage_pricing_type_tbl,
p_line_category => l_line_category_tbl,
p_line_unit_price => l_line_unit_price_tbl,
p_list_price_override_flag => l_list_price_overide_flag_tbl,
x_status_code => x_return_status,
x_status_text => l_return_status_text);
PO_LOG.stmt(l_log_head,d_pos,'After Calling INSERT_LINES2');
l_control_rec.temp_table_insert_flag := 'N';
select line_index,
line_id,
line_unit_price base_unit_price, -- base price
order_uom_selling_price adjusted_price, -- adjusted_price
pricing_status_code, --pricing status code
pricing_status_text -- pricing status text
into
x_price_tbl(j).line_index,
x_price_tbl(j).line_id,
x_price_tbl(j).base_unit_price,
x_price_tbl(j).adjusted_price,
x_price_tbl(j).pricing_status_code,
x_price_tbl(j).pricing_status_text
from qp_preq_lines_tmp
where line_index = j;
select charge_type_code,
order_qty_adj_amt freight_charge,
pricing_status_code,
pricing_status_text BULK COLLECT into l_freight_charge_rec_tbl
from qp_ldets_v
where line_index = j
and list_line_type_code='FREIGHT_CHARGE'
and applied_flag = 'Y';
select pricing_status_code, pricing_status_text into
x_price_tbl(j).pricing_status_code,
x_price_tbl(j).pricing_status_text
from
qp_preq_lines_tmp where line_index =j;