[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_control_rec.TEMP_TABLE_INSERT_FLAG := 'Y';
select flex_title, pricing_context, pricing_attribute1,
pricing_attribute2 , pricing_attribute3 , pricing_attribute4 , pricing_attribute5 ,
pricing_attribute6 , pricing_attribute7 , pricing_attribute8 , pricing_attribute9 ,
pricing_attribute10 , pricing_attribute11 , pricing_attribute12 , pricing_attribute13 ,
pricing_attribute14 , pricing_attribute15 , pricing_attribute16 , pricing_attribute17 ,
pricing_attribute18 , pricing_attribute19 , pricing_attribute20 , pricing_attribute21 ,
pricing_attribute22 , pricing_attribute23 , pricing_attribute24 , pricing_attribute25 ,
pricing_attribute26 , pricing_attribute27 , pricing_attribute28 , pricing_attribute29 ,
pricing_attribute30 , pricing_attribute31 , pricing_attribute32 , pricing_attribute33 ,
pricing_attribute34 , pricing_attribute35 , pricing_attribute36 , pricing_attribute37 ,
pricing_attribute38 , pricing_attribute39 , pricing_attribute40 , pricing_attribute41 ,
pricing_attribute42 , pricing_attribute43 , pricing_attribute44 , pricing_attribute45 ,
pricing_attribute46 , pricing_attribute47 , pricing_attribute48 , pricing_attribute49 ,
pricing_attribute50 , pricing_attribute51 , pricing_attribute52 , pricing_attribute53 ,
pricing_attribute54 , pricing_attribute55 , pricing_attribute56 , pricing_attribute57 ,
pricing_attribute58 , pricing_attribute59 , pricing_attribute60 , pricing_attribute61 ,
pricing_attribute62 , pricing_attribute63 , pricing_attribute64 , pricing_attribute65 ,
pricing_attribute66 , pricing_attribute67 , pricing_attribute68 , pricing_attribute69 ,
pricing_attribute70 , pricing_attribute71 , pricing_attribute72 , pricing_attribute73 ,
pricing_attribute74 , pricing_attribute75 , pricing_attribute76 , pricing_attribute77 ,
pricing_attribute78 , pricing_attribute79 , pricing_attribute80 , pricing_attribute81 ,
pricing_attribute82 , pricing_attribute83 , pricing_attribute84 , pricing_attribute85 ,
pricing_attribute86 , pricing_attribute87 , pricing_attribute88 , pricing_attribute89 ,
pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
pricing_attribute98 , pricing_attribute99 , pricing_attribute100
,Override_Flag
from aso_price_attributes a
where ( a.QUOTE_HEADER_ID = p_header_id )
and (p_header_id is not null and p_header_id <> FND_API.G_MISS_NUM)
and a.quote_line_id is null
/*
* New Code - Union is changed to union all
*/
UNION ALL
select flex_title, pricing_context, pricing_attribute1,
pricing_attribute2 , pricing_attribute3 , pricing_attribute4 , pricing_attribute5 ,
pricing_attribute6 , pricing_attribute7 , pricing_attribute8 , pricing_attribute9 ,
pricing_attribute10 , pricing_attribute11 , pricing_attribute12 , pricing_attribute13 ,
pricing_attribute14 , pricing_attribute15 , pricing_attribute16 , pricing_attribute17 ,
pricing_attribute18 , pricing_attribute19 , pricing_attribute20 , pricing_attribute21 ,
pricing_attribute22 , pricing_attribute23 , pricing_attribute24 , pricing_attribute25 ,
pricing_attribute26 , pricing_attribute27 , pricing_attribute28 , pricing_attribute29 ,
pricing_attribute30 , pricing_attribute31 , pricing_attribute32 , pricing_attribute33 ,
pricing_attribute34 , pricing_attribute35 , pricing_attribute36 , pricing_attribute37 ,
pricing_attribute38 , pricing_attribute39 , pricing_attribute40 , pricing_attribute41 ,
pricing_attribute42 , pricing_attribute43 , pricing_attribute44 , pricing_attribute45 ,
pricing_attribute46 , pricing_attribute47 , pricing_attribute48 , pricing_attribute49 ,
pricing_attribute50 , pricing_attribute51 , pricing_attribute52 , pricing_attribute53 ,
pricing_attribute54 , pricing_attribute55 , pricing_attribute56 , pricing_attribute57 ,
pricing_attribute58 , pricing_attribute59 , pricing_attribute60 , pricing_attribute61 ,
pricing_attribute62 , pricing_attribute63 , pricing_attribute64 , pricing_attribute65 ,
pricing_attribute66 , pricing_attribute67 , pricing_attribute68 , pricing_attribute69 ,
pricing_attribute70 , pricing_attribute71 , pricing_attribute72 , pricing_attribute73 ,
pricing_attribute74 , pricing_attribute75 , pricing_attribute76 , pricing_attribute77 ,
pricing_attribute78 , pricing_attribute79 , pricing_attribute80 , pricing_attribute81 ,
pricing_attribute82 , pricing_attribute83 , pricing_attribute84 , pricing_attribute85 ,
pricing_attribute86 , pricing_attribute87 , pricing_attribute88 , pricing_attribute89 ,
pricing_attribute90 , pricing_attribute91 , pricing_attribute92 , pricing_attribute93 ,
pricing_attribute94 , pricing_attribute95 , pricing_attribute96 , pricing_attribute97 ,
pricing_attribute98 , pricing_attribute99 , pricing_attribute100
,Override_Flag
from aso_price_attributes a
where ( a.QUOTE_line_id = p_line_id )
and (p_line_id is not null and p_line_id <> FND_API.G_MISS_NUM);
l_req_line_rec.UPDATED_ADJUSTED_UNIT_PRICE := p_Line_rec.line_quote_price;
l_qte_line_rec.operation_code := 'UPDATE';
QP_PREQ_GRP.G_STATUS_UPDATED,
QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
QP_PREQ_GRP.G_STATUS_UNCHANGED)
THEN
l_req_line_dtl_rec := p_req_line_detail_Tbl(i);
l_price_adj_rec.UPDATE_ALLOWABLE_FLAG :=
p_req_line_detail_Rec.Override_flag;
l_price_adj_rec.UPDATED_FLAG := p_req_line_detail_Rec.UPDATED_FLAG;
l_price_adj_rec.update_allowed := p_req_line_detail_Rec.OVERRIDE_FLAG;
l_price_adj_rec.UPDATE_ALLOWABLE_FLAG := p_req_line_detail_Rec.Override_flag;
l_price_adj_rec.UPDATED_FLAG := p_req_line_detail_Rec.UPDATED_FLAG;
l_price_adj_rec.update_allowed := p_req_line_detail_Rec.OVERRIDE_FLAG;
l_req_line_rec.status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED,
QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
QP_PREQ_GRP.G_STATUS_UNCHANGED)
Then
IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in ELSEIF',1,'Y');
l_qte_line_rec.operation_code := 'UPDATE';
PROCEDURE Update_Quote_Rows(
P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
:= ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
:= ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
:= ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)
IS
G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Update_Quote_Rows', 1, 'Y');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_qte_line_rec.operation_code in Update Quote Rows is '
||l_qte_line_rec.operation_code,1,'N');
IF l_qte_line_rec.operation_code = 'UPDATE' THEN
IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_QUOTE_LINES_PKG.Update_Row QUOTE_HEADER_ID'
||l_qte_line_rec.QUOTE_HEADER_ID, 1, 'N');
ASO_QUOTE_LINES_PKG.Update_Row(
p_QUOTE_LINE_ID => l_qte_line_rec.QUOTE_LINE_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_REQUEST_ID => l_qte_line_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_qte_line_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_qte_line_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_qte_line_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_qte_line_rec.QUOTE_HEADER_ID,
p_ORG_ID => l_qte_line_rec.ORG_ID ,
p_LINE_CATEGORY_CODE => l_qte_line_rec.LINE_CATEGORY_CODE ,
p_ITEM_TYPE_CODE => l_qte_line_rec.ITEM_TYPE_CODE,
p_LINE_NUMBER => l_qte_line_rec.LINE_NUMBER,
p_START_DATE_ACTIVE => l_qte_line_rec.START_DATE_ACTIVE,
p_END_DATE_ACTIVE => l_qte_line_rec.END_DATE_ACTIVE,
p_ORDER_LINE_TYPE_ID => l_qte_line_rec.ORDER_LINE_TYPE_ID,
p_INVOICE_TO_PARTY_SITE_ID => l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID,
p_INVOICE_TO_PARTY_ID => l_qte_line_rec.INVOICE_TO_PARTY_ID,
p_INVOICE_TO_CUST_ACCOUNT_ID => l_qte_line_rec.INVOICE_TO_CUST_ACCOUNT_ID,
p_ORGANIZATION_ID => l_qte_line_rec.ORGANIZATION_ID,
p_INVENTORY_ITEM_ID => l_qte_line_rec.INVENTORY_ITEM_ID ,
p_QUANTITY => l_qte_line_rec.QUANTITY,
p_UOM_CODE => l_qte_line_rec.UOM_CODE,
p_MARKETING_SOURCE_CODE_ID => l_qte_line_rec.marketing_source_code_id,
p_PRICE_LIST_ID => l_qte_line_rec.PRICE_LIST_ID,
p_PRICE_LIST_LINE_ID => l_qte_line_rec.PRICE_LIST_LINE_ID,
p_CURRENCY_CODE => l_qte_line_rec.CURRENCY_CODE,
p_LINE_LIST_PRICE => l_qte_line_rec.LINE_LIST_PRICE,
p_LINE_ADJUSTED_AMOUNT => l_qte_line_rec.LINE_ADJUSTED_AMOUNT,
p_LINE_ADJUSTED_PERCENT => l_qte_line_rec.LINE_ADJUSTED_PERCENT,
p_LINE_QUOTE_PRICE => l_qte_line_rec.LINE_QUOTE_PRICE,
p_RELATED_ITEM_ID => l_qte_line_rec.RELATED_ITEM_ID,
p_ITEM_RELATIONSHIP_TYPE => l_qte_line_rec.ITEM_RELATIONSHIP_TYPE,
p_ACCOUNTING_RULE_ID => l_qte_line_rec.ACCOUNTING_RULE_ID,
p_INVOICING_RULE_ID => l_qte_line_rec.INVOICING_RULE_ID,
p_SPLIT_SHIPMENT_FLAG => l_qte_line_rec.SPLIT_SHIPMENT_FLAG,
p_BACKORDER_FLAG => l_qte_line_rec.BACKORDER_FLAG,
p_minisite_id => l_qte_line_rec.minisite_id,
p_section_id => l_qte_line_rec.section_id,
p_PRICED_PRICE_LIST_ID => l_qte_line_rec.PRICED_PRICE_LIST_ID,
p_COMMITMENT_ID => l_qte_line_rec.COMMITMENT_ID,
p_AGREEMENT_ID => l_qte_line_rec.AGREEMENT_ID,
p_ATTRIBUTE_CATEGORY => l_qte_line_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_qte_line_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_qte_line_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_qte_line_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_qte_line_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_qte_line_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_qte_line_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_qte_line_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_qte_line_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_qte_line_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_qte_line_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_qte_line_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_qte_line_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_qte_line_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_qte_line_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_qte_line_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_qte_line_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_qte_line_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_qte_line_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_qte_line_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_qte_line_rec.ATTRIBUTE20,
p_DISPLAY_ARITHMETIC_OPERATOR => l_qte_line_rec.DISPLAY_ARITHMETIC_OPERATOR,
p_line_type_source_flag => l_qte_line_rec.line_type_source_flag,
p_SERVICE_ITEM_FLAG => l_qte_line_rec.SERVICE_ITEM_FLAG,
p_SERVICEABLE_PRODUCT_FLAG => l_qte_line_rec.SERVICEABLE_PRODUCT_FLAG,
p_INVOICE_TO_CUST_PARTY_ID => l_qte_line_rec.INVOICE_TO_CUST_PARTY_ID,
p_SELLING_PRICE_CHANGE => l_qte_line_rec.SELLING_PRICE_CHANGE,
p_RECALCULATE_FLAG => l_qte_line_rec.RECALCULATE_FLAG,
p_pricing_line_type_indicator => l_qte_line_rec.pricing_line_type_indicator,
p_END_CUSTOMER_PARTY_ID => l_qte_line_rec.END_CUSTOMER_PARTY_ID,
p_END_CUSTOMER_CUST_PARTY_ID => l_qte_line_rec.END_CUSTOMER_CUST_PARTY_ID,
p_END_CUSTOMER_PARTY_SITE_ID => l_qte_line_rec.END_CUSTOMER_PARTY_SITE_ID,
p_END_CUSTOMER_CUST_ACCOUNT_ID => l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
p_OBJECT_VERSION_NUMBER => l_qte_line_rec.OBJECT_VERSION_NUMBER,
p_CHARGE_PERIODICITY_CODE => l_qte_line_rec.CHARGE_PERIODICITY_CODE, -- Recurring charges Change
p_ship_model_complete_flag => l_qte_line_rec.ship_model_complete_flag,
p_LINE_PAYNOW_CHARGES => l_qte_line_rec.LINE_PAYNOW_CHARGES,
p_LINE_PAYNOW_TAX => l_qte_line_rec.LINE_PAYNOW_TAX,
p_LINE_PAYNOW_SUBTOTAL => l_qte_line_rec.LINE_PAYNOW_SUBTOTAL,
p_PRICING_QUANTITY_UOM => l_qte_line_rec.PRICING_QUANTITY_UOM,
p_PRICING_QUANTITY => l_qte_line_rec.PRICING_QUANTITY,
p_CONFIG_MODEL_TYPE => l_qte_line_rec.CONFIG_MODEL_TYPE
);
aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_QUOTE_LINES_PKG.Update_Row with UPDATE', 1, 'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update The quote line in l_Price_Adj_Tbl is '
||l_Price_Adj_Tbl(j).quote_line_id,1,'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Update The quote line in l_Price_Adj_Rltship_Tbl is '
||l_Price_Adj_Rltship_Tbl(j).quote_line_id,1,'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_QUOTE_LINES_PKG.Insert_Row QUOTE_HEADER_ID'
||l_qte_line_rec.QUOTE_HEADER_ID, 1, 'N');
ASO_QUOTE_LINES_PKG.Insert_Row(
px_QUOTE_LINE_ID => l_QUOTE_LINE_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_REQUEST_ID => l_qte_line_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_qte_line_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_qte_line_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_qte_line_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_qte_line_rec.QUOTE_HEADER_ID,
p_ORG_ID => l_qte_line_rec.ORG_ID,
p_LINE_CATEGORY_CODE => l_qte_line_rec.LINE_CATEGORY_CODE,
p_ITEM_TYPE_CODE => l_qte_line_rec.ITEM_TYPE_CODE,
p_LINE_NUMBER => l_qte_line_rec.LINE_NUMBER,
p_START_DATE_ACTIVE => l_qte_line_rec.START_DATE_ACTIVE,
p_END_DATE_ACTIVE => l_qte_line_rec.END_DATE_ACTIVE,
p_ORDER_LINE_TYPE_ID => l_qte_line_rec.ORDER_LINE_TYPE_ID,
p_INVOICE_TO_PARTY_SITE_ID => l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID,
p_INVOICE_TO_PARTY_ID => l_qte_line_rec.INVOICE_TO_PARTY_ID,
p_INVOICE_TO_CUST_ACCOUNT_ID => l_qte_line_rec.INVOICE_TO_CUST_ACCOUNT_ID,
p_ORGANIZATION_ID => l_qte_line_rec.ORGANIZATION_ID,
p_INVENTORY_ITEM_ID => l_qte_line_rec.INVENTORY_ITEM_ID,
p_QUANTITY => l_qte_line_rec.QUANTITY,
p_UOM_CODE => l_qte_line_rec.UOM_CODE,
p_MARKETING_SOURCE_CODE_ID => l_qte_line_rec.marketing_source_code_id,
p_PRICE_LIST_ID => l_qte_line_rec.PRICE_LIST_ID,
p_PRICE_LIST_LINE_ID => l_qte_line_rec.PRICE_LIST_LINE_ID,
p_CURRENCY_CODE => l_qte_line_rec.CURRENCY_CODE,
p_LINE_LIST_PRICE => l_qte_line_rec.LINE_LIST_PRICE,
p_LINE_ADJUSTED_AMOUNT => l_qte_line_rec.LINE_ADJUSTED_AMOUNT,
p_LINE_ADJUSTED_PERCENT => l_qte_line_rec.LINE_ADJUSTED_PERCENT,
p_LINE_QUOTE_PRICE => l_qte_line_rec.LINE_QUOTE_PRICE,
p_RELATED_ITEM_ID => l_qte_line_rec.RELATED_ITEM_ID,
p_ITEM_RELATIONSHIP_TYPE => l_qte_line_rec.ITEM_RELATIONSHIP_TYPE,
p_ACCOUNTING_RULE_ID => l_qte_line_rec.ACCOUNTING_RULE_ID,
p_INVOICING_RULE_ID => l_qte_line_rec.INVOICING_RULE_ID,
p_SPLIT_SHIPMENT_FLAG => l_qte_line_rec.SPLIT_SHIPMENT_FLAG,
p_BACKORDER_FLAG => l_qte_line_rec.BACKORDER_FLAG,
p_minisite_id => l_qte_line_rec.minisite_id,
p_section_id => l_qte_line_rec.section_id,
p_PRICED_PRICE_LIST_ID => l_qte_line_rec.PRICED_PRICE_LIST_ID,
p_COMMITMENT_ID => l_qte_line_rec.COMMITMENT_ID,
p_AGREEMENT_ID => l_qte_line_rec.AGREEMENT_ID,
p_ATTRIBUTE_CATEGORY => l_qte_line_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_qte_line_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_qte_line_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_qte_line_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_qte_line_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_qte_line_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_qte_line_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_qte_line_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_qte_line_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_qte_line_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_qte_line_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_qte_line_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_qte_line_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_qte_line_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_qte_line_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_qte_line_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_qte_line_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_qte_line_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_qte_line_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_qte_line_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_qte_line_rec.ATTRIBUTE20,
p_DISPLAY_ARITHMETIC_OPERATOR => l_qte_line_rec.DISPLAY_ARITHMETIC_OPERATOR,
p_line_type_source_flag => l_qte_line_rec.line_type_source_flag,
p_SERVICE_ITEM_FLAG => l_qte_line_rec.SERVICE_ITEM_FLAG,
p_SERVICEABLE_PRODUCT_FLAG => l_qte_line_rec.SERVICEABLE_PRODUCT_FLAG,
p_INVOICE_TO_CUST_PARTY_ID => l_qte_line_rec.INVOICE_TO_CUST_PARTY_ID,
p_SELLING_PRICE_CHANGE => l_qte_line_rec.SELLING_PRICE_CHANGE,
p_RECALCULATE_FLAG => l_qte_line_rec.RECALCULATE_FLAG,
p_pricing_line_type_indicator => l_qte_line_rec.pricing_line_type_indicator,
p_END_CUSTOMER_PARTY_ID => l_qte_line_rec.END_CUSTOMER_PARTY_ID,
p_END_CUSTOMER_CUST_PARTY_ID => l_qte_line_rec.END_CUSTOMER_CUST_PARTY_ID,
p_END_CUSTOMER_PARTY_SITE_ID => l_qte_line_rec.END_CUSTOMER_PARTY_SITE_ID,
p_END_CUSTOMER_CUST_ACCOUNT_ID => l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
p_OBJECT_VERSION_NUMBER => l_qte_line_rec.OBJECT_VERSION_NUMBER,
p_CHARGE_PERIODICITY_CODE => l_qte_line_rec.CHARGE_PERIODICITY_CODE, -- Recurring charges Change
p_ship_model_complete_flag => l_qte_line_rec.ship_model_complete_flag,
p_LINE_PAYNOW_CHARGES => l_qte_line_rec.LINE_PAYNOW_CHARGES,
p_LINE_PAYNOW_TAX => l_qte_line_rec.LINE_PAYNOW_TAX,
p_LINE_PAYNOW_SUBTOTAL => l_qte_line_rec.LINE_PAYNOW_SUBTOTAL,
p_PRICING_QUANTITY_UOM => l_qte_line_rec.PRICING_QUANTITY_UOM,
p_PRICING_QUANTITY => l_qte_line_rec.PRICING_QUANTITY,
p_CONFIG_MODEL_TYPE => l_qte_line_rec.CONFIG_MODEL_TYPE
);
aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_QUOTE_LINES_PKG.Insert_row with CREATE', 1, 'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row', 1, 'N');
ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
px_PRICE_ADJUSTMENT_ID => l_PRICE_ADJUSTMENT_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_PROGRAM_APPLICATION_ID => l_price_adj_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_price_adj_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_price_adj_rec.PROGRAM_UPDATE_DATE,
p_REQUEST_ID => l_price_adj_rec.REQUEST_ID,
p_QUOTE_HEADER_ID => l_price_adj_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_price_adj_rec.QUOTE_LINE_ID,
p_MODIFIER_HEADER_ID => l_price_adj_rec.MODIFIER_HEADER_ID,
p_MODIFIER_LINE_ID => l_price_adj_rec.MODIFIER_LINE_ID,
p_MODIFIER_LINE_TYPE_CODE => l_price_adj_rec.MODIFIER_LINE_TYPE_CODE,
p_MODIFIER_MECHANISM_TYPE_CODE => l_price_adj_rec.MODIFIER_MECHANISM_TYPE_CODE,
p_MODIFIED_FROM => l_price_adj_rec.MODIFIED_FROM,
p_MODIFIED_TO => l_price_adj_rec.MODIFIED_TO,
p_OPERAND => l_price_adj_rec.OPERAND,
p_ARITHMETIC_OPERATOR => l_price_adj_rec.ARITHMETIC_OPERATOR,
p_AUTOMATIC_FLAG => l_price_adj_rec.AUTOMATIC_FLAG,
p_UPDATE_ALLOWABLE_FLAG => l_price_adj_rec.UPDATE_ALLOWABLE_FLAG,
p_UPDATED_FLAG => l_price_adj_rec.UPDATED_FLAG,
p_APPLIED_FLAG => l_price_adj_rec.APPLIED_FLAG,
p_ON_INVOICE_FLAG => l_price_adj_rec.ON_INVOICE_FLAG,
p_PRICING_PHASE_ID => l_price_adj_rec.PRICING_PHASE_ID,
p_ATTRIBUTE_CATEGORY => l_price_adj_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_price_adj_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_price_adj_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_price_adj_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_price_adj_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_price_adj_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_price_adj_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_price_adj_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_price_adj_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_price_adj_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_price_adj_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_price_adj_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_price_adj_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_price_adj_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_price_adj_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_price_adj_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_price_adj_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_price_adj_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_price_adj_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_price_adj_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_price_adj_rec.ATTRIBUTE20,
p_ORIG_SYS_DISCOUNT_REF => l_price_adj_rec.ORIG_SYS_DISCOUNT_REF,
p_CHANGE_SEQUENCE => l_price_adj_rec.CHANGE_SEQUENCE,
p_UPDATE_ALLOWED => l_price_adj_rec.UPDATE_ALLOWED,
p_CHANGE_REASON_CODE => l_price_adj_rec.CHANGE_REASON_CODE,
p_CHANGE_REASON_TEXT => l_price_adj_rec.CHANGE_REASON_TEXT,
p_COST_ID => l_price_adj_rec.COST_ID,
p_TAX_CODE => l_price_adj_rec.TAX_CODE,
p_TAX_EXEMPT_FLAG => l_price_adj_rec.TAX_EXEMPT_FLAG,
p_TAX_EXEMPT_NUMBER => l_price_adj_rec.TAX_EXEMPT_NUMBER,
p_TAX_EXEMPT_REASON_CODE => l_price_adj_rec.TAX_EXEMPT_REASON_CODE,
p_PARENT_ADJUSTMENT_ID => l_price_adj_rec.PARENT_ADJUSTMENT_ID,
p_INVOICED_FLAG => l_price_adj_rec.INVOICED_FLAG,
p_ESTIMATED_FLAG => l_price_adj_rec.ESTIMATED_FLAG,
p_INC_IN_SALES_PERFORMANCE => l_price_adj_rec.INC_IN_SALES_PERFORMANCE,
p_SPLIT_ACTION_CODE => l_price_adj_rec.SPLIT_ACTION_CODE,
p_ADJUSTED_AMOUNT => l_price_adj_rec.ADJUSTED_AMOUNT,
p_CHARGE_TYPE_CODE => l_price_adj_rec.CHARGE_TYPE_CODE,
p_CHARGE_SUBTYPE_CODE => l_price_adj_rec.CHARGE_SUBTYPE_CODE,
p_RANGE_BREAK_QUANTITY => l_price_adj_rec.RANGE_BREAK_QUANTITY,
p_ACCRUAL_CONVERSION_RATE => l_price_adj_rec.ACCRUAL_CONVERSION_RATE,
p_PRICING_GROUP_SEQUENCE => l_price_adj_rec.PRICING_GROUP_SEQUENCE,
p_ACCRUAL_FLAG => l_price_adj_rec.ACCRUAL_FLAG,
p_LIST_LINE_NO => l_price_adj_rec.LIST_LINE_NO,
p_SOURCE_SYSTEM_CODE => l_price_adj_rec.SOURCE_SYSTEM_CODE,
p_BENEFIT_QTY => l_price_adj_rec.BENEFIT_QTY,
p_BENEFIT_UOM_CODE => l_price_adj_rec.BENEFIT_UOM_CODE,
p_PRINT_ON_INVOICE_FLAG => l_price_adj_rec.PRINT_ON_INVOICE_FLAG,
p_EXPIRATION_DATE => l_price_adj_rec.EXPIRATION_DATE,
p_REBATE_TRANSACTION_TYPE_CODE => l_price_adj_rec.REBATE_TRANSACTION_TYPE_CODE,
p_REBATE_TRANSACTION_REFERENCE => l_price_adj_rec.REBATE_TRANSACTION_REFERENCE,
p_REBATE_PAYMENT_SYSTEM_CODE => l_price_adj_rec.REBATE_PAYMENT_SYSTEM_CODE,
p_REDEEMED_DATE => l_price_adj_rec.REDEEMED_DATE,
p_REDEEMED_FLAG => l_price_adj_rec.REDEEMED_FLAG,
p_MODIFIER_LEVEL_CODE => l_price_adj_rec.MODIFIER_LEVEL_CODE,
p_PRICE_BREAK_TYPE_CODE => l_price_adj_rec.PRICE_BREAK_TYPE_CODE,
p_SUBSTITUTION_ATTRIBUTE => l_price_adj_rec.SUBSTITUTION_ATTRIBUTE,
p_PRORATION_TYPE_CODE => l_price_adj_rec.PRORATION_TYPE_CODE,
p_INCLUDE_ON_RETURNS_FLAG => l_price_adj_rec.INCLUDE_ON_RETURNS_FLAG,
p_CREDIT_OR_CHARGE_FLAG => l_price_adj_rec.CREDIT_OR_CHARGE_FLAG,
p_OPERAND_PER_PQTY => l_price_adj_rec.OPERAND_PER_PQTY,
p_ADJUSTED_AMOUNT_PER_PQTY => l_price_adj_rec.ADJUSTED_AMOUNT_PER_PQTY,
p_OBJECT_VERSION_NUMBER => l_price_adj_rec.OBJECT_VERSION_NUMBER
);
aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row PRICE_ADJUSTMENT_ID'
||l_PRICE_ADJUSTMENT_ID, 1, 'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxStart inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxxx', 1, 'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');
ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
px_PRICE_ADJ_ATTRIB_ID => l_price_adj_attr_rec.PRICE_ADJ_ATTRIB_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_PROGRAM_APPLICATION_ID =>l_price_adj_attr_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_price_adj_attr_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_price_adj_attr_rec.PROGRAM_UPDATE_DATE,
p_REQUEST_ID => l_price_adj_attr_rec.REQUEST_ID,
p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_rec.PRICE_ADJUSTMENT_ID,
p_PRICING_CONTEXT => l_price_adj_attr_rec.PRICING_CONTEXT,
p_PRICING_ATTRIBUTE => l_price_adj_attr_rec.PRICING_ATTRIBUTE,
p_PRICING_ATTR_VALUE_FROM => l_price_adj_attr_rec.PRICING_ATTR_VALUE_FROM,
p_PRICING_ATTR_VALUE_TO => l_price_adj_attr_rec.PRICING_ATTR_VALUE_TO,
p_COMPARISON_OPERATOR => l_price_adj_attr_rec.COMPARISON_OPERATOR,
p_FLEX_TITLE => l_price_adj_attr_rec.FLEX_TITLE,
p_OBJECT_VERSION_NUMBER => l_price_adj_attr_rec.OBJECT_VERSION_NUMBER);
aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row', 1, 'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:xxxxxxxxxxFinish inserting into ASO_PRICE_ADJ_ATTRIBSxxxxxx', 1, 'N');
aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
ASO_PRICE_RLTSHIPS_PKG.Insert_Row(
px_ADJ_RELATIONSHIP_ID => l_price_adj_rltship_rec.ADJ_RELATIONSHIP_ID,
p_creation_date => sysdate,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => sysdate,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_LOGIN => G_USER_ID,
p_PROGRAM_APPLICATION_ID => l_price_adj_rltship_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_price_adj_rltship_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_price_adj_rltship_rec.PROGRAM_UPDATE_DATE,
p_REQUEST_ID => l_price_adj_rltship_rec.REQUEST_ID,
p_QUOTE_LINE_ID => l_price_adj_rltship_rec.quote_line_id,
p_PRICE_ADJUSTMENT_ID => l_price_adj_rltship_rec.price_adjustment_id,
p_RLTD_PRICE_ADJ_ID => l_price_adj_rltship_rec.rltd_price_adj_id,
p_quote_shipment_id => l_price_adj_rltship_rec.quote_shipment_id,
p_OBJECT_VERSION_NUMBER => l_price_adj_rltship_rec.OBJECT_VERSION_NUMBER
);
aso_debug_pub.add('ASO_PRICING_CORE_PVT:After ASO_PRICE_RLTSHIPS_PKG.Insert_Row', 1, 'N');
END Update_Quote_Rows;