[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select MSIV.bom_item_type, MSIV.primary_uom_code
from mtl_system_items_vl MSIV
where MSIV.inventory_item_id = l_itmid AND MSIV.organization_id = p_organization_id;
l_sub_itm_tbl.DELETE;
l_sub_uom_tbl.DELETE;
l_sub_qty_tbl.DELETE;
SELECT party_id
FROM hz_cust_accounts
WHERE cust_account_id = l_cust_account_id;
SELECT master_organization_id
FROM oe_system_parameters_all
WHERE org_id = l_operating_unit;
SELECT service_duration, service_duration_period_code
FROM mtl_system_items_vl
WHERE inventory_item_id = l_item_id
AND organization_id = l_organization_id;
l_control_rec.temp_table_insert_flag := 'N';
IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': inserting request lines into QP temp table, total lines='||G_LINE_INDEX_TBL.count);
QP_PREQ_GRP.INSERT_LINES2
(p_LINE_INDEX => G_LINE_INDEX_TBL,
p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
p_PRICING_EFFECTIVE_DATE => G_PRICING_EFFECTIVE_DATE_TBL,
p_ACTIVE_DATE_FIRST => G_ACTIVE_DATE_FIRST_TBL,
p_ACTIVE_DATE_FIRST_TYPE => G_ACTIVE_DATE_FIRST_TYPE_TBL,
p_ACTIVE_DATE_SECOND => G_ACTIVE_DATE_SECOND_TBL,
p_ACTIVE_DATE_SECOND_TYPE => G_ACTIVE_DATE_SECOND_TYPE_TBL,
p_LINE_QUANTITY => P_LINE_QUANTITY_TBL,
p_LINE_UOM_CODE => P_UOM_CODE_TBL,
p_REQUEST_TYPE_CODE => G_REQUEST_TYPE_CODE_TBL,
p_PRICED_QUANTITY => G_PRICED_QUANTITY_TBL,
p_PRICED_UOM_CODE => P_UOM_CODE_TBL,
p_CURRENCY_CODE => G_CURRENCY_CODE_TBL,
p_UNIT_PRICE => G_UNIT_PRICE_TBL,
p_PERCENT_PRICE => G_PERCENT_PRICE_TBL,
p_UOM_QUANTITY => G_UOM_QUANTITY_TBL,
p_ADJUSTED_UNIT_PRICE => G_ADJUSTED_UNIT_PRICE_TBL,
p_UPD_ADJUSTED_UNIT_PRICE => G_UPD_ADJUSTED_UNIT_PRICE_TBL,
p_PROCESSED_FLAG => G_PROCESSED_FLAG_TBL,
p_PRICE_FLAG => G_PRICE_FLAG_TBL,
p_LINE_ID => G_LINE_ID_TBL,
p_PROCESSING_ORDER => G_PROCESSING_ORDER_TBL,
p_PRICING_STATUS_CODE => G_PRICING_STATUS_CODE_TBL,
p_PRICING_STATUS_TEXT => G_PRICING_STATUS_TEXT_TBL,
p_ROUNDING_FLAG => G_ROUNDING_FLAG_TBL,
p_ROUNDING_FACTOR => G_ROUNDING_FACTOR_TBL,
p_QUALIFIERS_EXIST_FLAG => G_QUALIFIERS_EXIST_FLAG_TBL,
p_PRICING_ATTRS_EXIST_FLAG => G_PRICING_ATTRS_EXIST_FLAG_TBL,
p_PRICE_LIST_ID => G_PRICE_LIST_ID_TBL,
p_VALIDATED_FLAG => G_PL_VALIDATED_FLAG_TBL,
p_PRICE_REQUEST_CODE => G_PRICE_REQUEST_CODE_TBL,
p_USAGE_PRICING_TYPE => G_USAGE_PRICING_TYPE_TBL,
--p_line_category => G_LINE_CATEGORY_TBL,
x_status_code => x_return_status,
x_status_text => x_return_status_text);
IBE_UTIL.debug('Error in insert_lines '||x_return_status_text);
IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': inserting related lines...');
QP_PREQ_GRP.INSERT_RLTD_LINES2
(p_LINE_INDEX => p_parentIndex_tbl,
p_LINE_DETAIL_INDEX => G_LINE_DETAIL_INDEX_TBL,
p_RELATIONSHIP_TYPE_CODE => G_RELATIONSHIP_TYPE_CODE,
p_RELATED_LINE_INDEX => p_childindex_tbl,
p_RELATED_LINE_DETAIL_INDEX => G_RLTD_LINE_DETAIL_INDEX_TBL,
x_status_code => x_return_status,
x_status_text => x_return_status_text);
IBE_UTIL.DEBUG(g_pkg_name||'.'||L_API||': related lines inserted, status='||x_return_status||', '||x_return_status_text);
SELECT LINE_ID, LINE_UOM_CODE, LINE_QUANTITY, LINE_UNIT_PRICE, ORDER_UOM_SELLING_PRICE, PRICING_STATUS_CODE, PRICING_STATUS_TEXT
FROM QP_PREQ_LINES_TMP
WHERE PRICING_STATUS_CODE=QP_PREQ_PUB.G_STATUS_UPDATED
ORDER BY LINE_ID;