[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Quote_Line_Rows(
P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type
:= ASO_QUOTE_PUB.G_MISS_qte_line_REC,
P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type
:= ASO_QUOTE_PUB.G_MISS_Control_Rec,
P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_Payment_TBL,
P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_Price_Adj_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_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_shipment_TBL,
P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_tax_detail_TBL,
P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_freight_charge_TBL,
P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_Price_attributes_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_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type
:= ASO_QUOTE_PUB.G_Miss_Line_Attribs_Ext_Tbl,
P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
:= ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)
IS
cursor get_quote_number( l_qte_header_id number) is
SELECT quote_number
FROM aso_quote_headers_all
WHERE quote_header_id = l_qte_header_id;
aso_debug_pub.add('Insert_Quote_lines - Begin ', 1, 'Y');
ASO_QUOTE_LINES_PKG.Insert_Row(
px_QUOTE_LINE_ID => x_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 => p_qte_line_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_qte_line_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_qte_line_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_qte_line_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => p_qte_line_rec.QUOTE_HEADER_ID,
p_ORG_ID => p_qte_line_rec.ORG_ID ,
p_LINE_CATEGORY_CODE => p_qte_line_rec.LINE_CATEGORY_CODE ,
p_ITEM_TYPE_CODE => p_qte_line_rec.ITEM_TYPE_CODE ,
p_LINE_NUMBER => p_qte_line_rec.LINE_NUMBER,
p_START_DATE_ACTIVE => trunc(p_qte_line_rec.START_DATE_ACTIVE),
p_END_DATE_ACTIVE => trunc(p_qte_line_rec.END_DATE_ACTIVE) ,
p_ORDER_LINE_TYPE_ID => p_qte_line_rec.ORDER_LINE_TYPE_ID ,
p_INVOICE_TO_PARTY_SITE_ID=> p_qte_line_rec.INVOICE_TO_PARTY_SITE_ID,
p_INVOICE_TO_PARTY_ID => p_qte_line_rec.INVOICE_TO_PARTY_ID ,
p_INVOICE_TO_CUST_ACCOUNT_ID => p_qte_line_rec.INVOICE_TO_CUST_ACCOUNT_ID ,
p_ORGANIZATION_ID => p_qte_line_rec.ORGANIZATION_ID,
p_INVENTORY_ITEM_ID => p_qte_line_rec.INVENTORY_ITEM_ID ,
p_QUANTITY => p_qte_line_rec.QUANTITY ,
p_UOM_CODE => p_qte_line_rec.UOM_CODE ,
p_MARKETING_SOURCE_CODE_ID=> p_qte_line_rec.marketing_source_code_id,
p_PRICE_LIST_ID => p_qte_line_rec.PRICE_LIST_ID ,
p_PRICE_LIST_LINE_ID => p_qte_line_rec.PRICE_LIST_LINE_ID,
p_CURRENCY_CODE => p_qte_line_rec.CURRENCY_CODE ,
p_LINE_LIST_PRICE => p_qte_line_rec.LINE_LIST_PRICE ,
p_LINE_ADJUSTED_AMOUNT => p_qte_line_rec.LINE_ADJUSTED_AMOUNT ,
p_LINE_ADJUSTED_PERCENT => p_qte_line_rec.LINE_ADJUSTED_PERCENT,
p_LINE_QUOTE_PRICE => p_qte_line_rec.LINE_QUOTE_PRICE ,
p_RELATED_ITEM_ID => p_qte_line_rec.RELATED_ITEM_ID ,
p_ITEM_RELATIONSHIP_TYPE => p_qte_line_rec.ITEM_RELATIONSHIP_TYPE,
p_ACCOUNTING_RULE_ID => p_qte_line_rec.ACCOUNTING_RULE_ID,
p_INVOICING_RULE_ID => p_qte_line_rec.INVOICING_RULE_ID,
p_SPLIT_SHIPMENT_FLAG => p_qte_line_rec.SPLIT_SHIPMENT_FLAG ,
p_BACKORDER_FLAG => p_qte_line_rec.BACKORDER_FLAG ,
p_MINISITE_ID => p_qte_line_rec.MINISITE_ID,
p_SECTION_ID => p_qte_line_rec.SECTION_ID,
p_ATTRIBUTE_CATEGORY => p_qte_line_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_qte_line_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_qte_line_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_qte_line_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_qte_line_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_qte_line_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_qte_line_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_qte_line_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_qte_line_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_qte_line_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_qte_line_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_qte_line_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_qte_line_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_qte_line_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_qte_line_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_qte_line_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => p_qte_line_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => p_qte_line_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => p_qte_line_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => p_qte_line_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => p_qte_line_rec.ATTRIBUTE20,
p_PRICED_PRICE_LIST_ID => p_qte_line_rec.PRICED_PRICE_LIST_ID,
p_AGREEMENT_ID => p_qte_line_rec.AGREEMENT_ID,
p_COMMITMENT_ID => p_qte_line_rec.COMMITMENT_ID,
p_DISPLAY_ARITHMETIC_OPERATOR => p_qte_line_rec.DISPLAY_ARITHMETIC_OPERATOR,
p_LINE_TYPE_SOURCE_FLAG => p_qte_line_rec.LINE_TYPE_SOURCE_FLAG,
p_SERVICE_ITEM_FLAG => p_qte_line_rec.SERVICE_ITEM_FLAG,
p_SERVICEABLE_PRODUCT_FLAG => p_qte_line_rec.SERVICEABLE_PRODUCT_FLAG,
p_INVOICE_TO_CUST_PARTY_ID => p_qte_line_rec.INVOICE_TO_CUST_PARTY_ID,
P_Selling_Price_Change => p_qte_line_rec.Selling_Price_Change,
P_Recalculate_flag => p_qte_line_rec.recalculate_flag,
p_pricing_line_type_indicator => p_qte_line_rec.pricing_line_type_indicator,
p_END_CUSTOMER_PARTY_ID => p_qte_line_rec.END_CUSTOMER_PARTY_ID,
p_END_CUSTOMER_CUST_PARTY_ID => p_qte_line_rec.END_CUSTOMER_CUST_PARTY_ID,
p_END_CUSTOMER_PARTY_SITE_ID => p_qte_line_rec.END_CUSTOMER_PARTY_SITE_ID,
p_END_CUSTOMER_CUST_ACCOUNT_ID => p_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID,
p_OBJECT_VERSION_NUMBER => p_qte_line_rec.OBJECT_VERSION_NUMBER,
p_CHARGE_PERIODICITY_CODE => p_qte_line_rec.CHARGE_PERIODICITY_CODE, -- Recurring charges Change
p_SHIP_MODEL_COMPLETE_FLAG => p_qte_line_rec.SHIP_MODEL_COMPLETE_FLAG,
p_LINE_PAYNOW_CHARGES => p_qte_line_rec.LINE_PAYNOW_CHARGES,
p_LINE_PAYNOW_TAX => p_qte_line_rec.LINE_PAYNOW_TAX,
p_LINE_PAYNOW_SUBTOTAL => p_qte_line_rec.LINE_PAYNOW_SUBTOTAL,
p_PRICING_QUANTITY_UOM => p_qte_line_rec.PRICING_QUANTITY_UOM,
p_PRICING_QUANTITY => p_qte_line_rec.PRICING_QUANTITY,
p_CONFIG_MODEL_TYPE => p_qte_line_rec.CONFIG_MODEL_TYPE
);
aso_debug_pub.add('Insert_Quote_lines - quote_line.insert_row ', 1, 'N');
ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(
px_QUOTE_LINE_DETAIL_ID => x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_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_dtl_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_qte_line_dtl_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_qte_line_dtl_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_qte_line_dtl_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_LINE_ID => l_qte_line_dtl_rec.QUOTE_LINE_ID,
p_CONFIG_HEADER_ID => l_qte_line_dtl_rec.CONFIG_HEADER_ID,
p_CONFIG_REVISION_NUM => l_qte_line_dtl_rec.CONFIG_REVISION_NUM,
p_COMPLETE_CONFIGURATION_FLAG
=> l_qte_line_dtl_rec.COMPLETE_CONFIGURATION_FLAG,
p_VALID_CONFIGURATION_FLAG
=> l_qte_line_dtl_rec.VALID_CONFIGURATION_FLAG,
p_COMPONENT_CODE => l_qte_line_dtl_rec.COMPONENT_CODE,
p_SERVICE_COTERMINATE_FLAG
=> l_qte_line_dtl_rec.SERVICE_COTERMINATE_FLAG,
p_SERVICE_DURATION => l_qte_line_dtl_rec.SERVICE_DURATION,
p_SERVICE_PERIOD => l_qte_line_dtl_rec.SERVICE_PERIOD,
p_SERVICE_UNIT_SELLING_PERCENT
=> l_qte_line_dtl_rec.SERVICE_UNIT_SELLING_PERCENT,
p_SERVICE_UNIT_LIST_PERCENT
=> l_qte_line_dtl_rec.SERVICE_UNIT_LIST_PERCENT,
p_SERVICE_NUMBER => l_qte_line_dtl_rec.SERVICE_NUMBER,
p_UNIT_PERCENT_BASE_PRICE
=> l_qte_line_dtl_rec.UNIT_PERCENT_BASE_PRICE,
p_ATTRIBUTE_CATEGORY => l_qte_line_dtl_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_qte_line_dtl_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_qte_line_dtl_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_qte_line_dtl_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_qte_line_dtl_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_qte_line_dtl_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_qte_line_dtl_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_qte_line_dtl_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_qte_line_dtl_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_qte_line_dtl_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_qte_line_dtl_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_qte_line_dtl_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_qte_line_dtl_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_qte_line_dtl_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_qte_line_dtl_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_qte_line_dtl_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_qte_line_dtl_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_qte_line_dtl_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_qte_line_dtl_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_qte_line_dtl_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_qte_line_dtl_rec.ATTRIBUTE20,
p_SERVICE_REF_TYPE_CODE => l_qte_line_dtl_rec.SERVICE_REF_TYPE_CODE,
p_SERVICE_REF_ORDER_NUMBER
=> l_qte_line_dtl_rec.SERVICE_REF_ORDER_NUMBER,
p_SERVICE_REF_LINE_NUMBER
=> l_qte_line_dtl_rec.SERVICE_REF_LINE_NUMBER,
p_SERVICE_REF_LINE_ID => l_qte_line_dtl_rec.SERVICE_REF_LINE_ID,
p_SERVICE_REF_SYSTEM_ID => l_qte_line_dtl_rec.SERVICE_REF_SYSTEM_ID,
p_SERVICE_REF_OPTION_NUMB
=> l_qte_line_dtl_rec.SERVICE_REF_OPTION_NUMB,
p_SERVICE_REF_SHIPMENT_NUMB
=> l_qte_line_dtl_rec.SERVICE_REF_SHIPMENT_NUMB,
p_RETURN_REF_TYPE => l_qte_line_dtl_rec.RETURN_REF_TYPE,
p_RETURN_REF_HEADER_ID => l_qte_line_dtl_rec.RETURN_REF_HEADER_ID,
p_RETURN_REF_LINE_ID => l_qte_line_dtl_rec.RETURN_REF_LINE_ID,
p_RETURN_ATTRIBUTE1 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE1,
p_RETURN_ATTRIBUTE2 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE2,
p_RETURN_ATTRIBUTE3 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE3,
p_RETURN_ATTRIBUTE4 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE4,
p_RETURN_ATTRIBUTE5 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE5,
p_RETURN_ATTRIBUTE6 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE6,
p_RETURN_ATTRIBUTE7 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE7,
p_RETURN_ATTRIBUTE8 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE8,
p_RETURN_ATTRIBUTE9 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE9,
p_RETURN_ATTRIBUTE10 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE10,
p_RETURN_ATTRIBUTE11 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE11,
p_RETURN_ATTRIBUTE15 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE15,
p_RETURN_ATTRIBUTE12 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE12,
p_RETURN_ATTRIBUTE13 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE13,
p_RETURN_ATTRIBUTE14 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE14,
p_RETURN_REASON_CODE => l_qte_line_dtl_rec.RETURN_REASON_CODE,
p_CONFIG_ITEM_ID => l_qte_line_dtl_rec.CONFIG_ITEM_ID,
p_REF_TYPE_CODE => l_qte_line_dtl_rec.REF_TYPE_CODE,
p_REF_LINE_ID => l_qte_line_dtl_rec.REF_LINE_ID,
p_INSTANCE_ID => l_qte_line_dtl_rec.INSTANCE_ID,
p_BOM_SORT_ORDER => l_qte_line_dtl_rec.BOM_SORT_ORDER,
p_CONFIG_DELTA => l_qte_line_dtl_rec.CONFIG_DELTA,
p_CONFIG_INSTANCE_NAME => l_qte_line_dtl_rec.CONFIG_INSTANCE_NAME,
P_OBJECT_VERSION_NUMBER => l_qte_line_dtl_rec.OBJECT_VERSION_NUMBER,
p_top_model_line_id => l_qte_line_dtl_rec.top_model_line_id,
p_ato_line_id => l_qte_line_dtl_rec.ato_line_id,
p_component_sequence_id => l_qte_line_dtl_rec.component_sequence_id
);
aso_debug_pub.add('Insert_Quote_lines - quote_line_details.insert_row '|| x_return_status, 1, 'N');
ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(
px_PRICE_ATTRIBUTE_ID => x_price_attributes_tbl(i).price_attribute_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 => p_qte_line_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_qte_line_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_qte_line_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_qte_line_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => p_qte_line_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_price_attributes_rec.quote_line_id,
p_FLEX_TITLE => l_price_attributes_rec.flex_title,
p_PRICING_CONTEXT => l_price_attributes_rec.pricing_context,
p_PRICING_ATTRIBUTE1 => l_price_attributes_rec.PRICING_ATTRIBUTE1,
p_PRICING_ATTRIBUTE2 => l_price_attributes_rec.PRICING_ATTRIBUTE2,
p_PRICING_ATTRIBUTE3 => l_price_attributes_rec.PRICING_ATTRIBUTE3,
p_PRICING_ATTRIBUTE4 => l_price_attributes_rec.PRICING_ATTRIBUTE4,
p_PRICING_ATTRIBUTE5 => l_price_attributes_rec.PRICING_ATTRIBUTE5,
p_PRICING_ATTRIBUTE6 => l_price_attributes_rec.PRICING_ATTRIBUTE6,
p_PRICING_ATTRIBUTE7 => l_price_attributes_rec.PRICING_ATTRIBUTE7,
p_PRICING_ATTRIBUTE8 => l_price_attributes_rec.PRICING_ATTRIBUTE8,
p_PRICING_ATTRIBUTE9 => l_price_attributes_rec.PRICING_ATTRIBUTE9,
p_PRICING_ATTRIBUTE10 => l_price_attributes_rec.PRICING_ATTRIBUTE10,
p_PRICING_ATTRIBUTE11 => l_price_attributes_rec.PRICING_ATTRIBUTE11,
p_PRICING_ATTRIBUTE12 => l_price_attributes_rec.PRICING_ATTRIBUTE12,
p_PRICING_ATTRIBUTE13 => l_price_attributes_rec.PRICING_ATTRIBUTE13,
p_PRICING_ATTRIBUTE14 => l_price_attributes_rec.PRICING_ATTRIBUTE14,
p_PRICING_ATTRIBUTE15 => l_price_attributes_rec.PRICING_ATTRIBUTE15,
p_PRICING_ATTRIBUTE16 => l_price_attributes_rec.PRICING_ATTRIBUTE16,
p_PRICING_ATTRIBUTE17 => l_price_attributes_rec.PRICING_ATTRIBUTE17,
p_PRICING_ATTRIBUTE18 => l_price_attributes_rec.PRICING_ATTRIBUTE18,
p_PRICING_ATTRIBUTE19 => l_price_attributes_rec.PRICING_ATTRIBUTE19,
p_PRICING_ATTRIBUTE20 => l_price_attributes_rec.PRICING_ATTRIBUTE20,
p_PRICING_ATTRIBUTE21 => l_price_attributes_rec.PRICING_ATTRIBUTE21,
p_PRICING_ATTRIBUTE22 => l_price_attributes_rec.PRICING_ATTRIBUTE22,
p_PRICING_ATTRIBUTE23 => l_price_attributes_rec.PRICING_ATTRIBUTE23,
p_PRICING_ATTRIBUTE24 => l_price_attributes_rec.PRICING_ATTRIBUTE24,
p_PRICING_ATTRIBUTE25 => l_price_attributes_rec.PRICING_ATTRIBUTE25,
p_PRICING_ATTRIBUTE26 => l_price_attributes_rec.PRICING_ATTRIBUTE26,
p_PRICING_ATTRIBUTE27 => l_price_attributes_rec.PRICING_ATTRIBUTE27,
p_PRICING_ATTRIBUTE28 => l_price_attributes_rec.PRICING_ATTRIBUTE28,
p_PRICING_ATTRIBUTE29 => l_price_attributes_rec.PRICING_ATTRIBUTE29,
p_PRICING_ATTRIBUTE30 => l_price_attributes_rec.PRICING_ATTRIBUTE30,
p_PRICING_ATTRIBUTE31 => l_price_attributes_rec.PRICING_ATTRIBUTE31,
p_PRICING_ATTRIBUTE32 => l_price_attributes_rec.PRICING_ATTRIBUTE32,
p_PRICING_ATTRIBUTE33 => l_price_attributes_rec.PRICING_ATTRIBUTE33,
p_PRICING_ATTRIBUTE34 => l_price_attributes_rec.PRICING_ATTRIBUTE34,
p_PRICING_ATTRIBUTE35 => l_price_attributes_rec.PRICING_ATTRIBUTE35,
p_PRICING_ATTRIBUTE36 => l_price_attributes_rec.PRICING_ATTRIBUTE36,
p_PRICING_ATTRIBUTE37 => l_price_attributes_rec.PRICING_ATTRIBUTE37,
p_PRICING_ATTRIBUTE38 => l_price_attributes_rec.PRICING_ATTRIBUTE38,
p_PRICING_ATTRIBUTE39 => l_price_attributes_rec.PRICING_ATTRIBUTE39,
p_PRICING_ATTRIBUTE40 => l_price_attributes_rec.PRICING_ATTRIBUTE40,
p_PRICING_ATTRIBUTE41 => l_price_attributes_rec.PRICING_ATTRIBUTE41,
p_PRICING_ATTRIBUTE42 => l_price_attributes_rec.PRICING_ATTRIBUTE42,
p_PRICING_ATTRIBUTE43 => l_price_attributes_rec.PRICING_ATTRIBUTE43,
p_PRICING_ATTRIBUTE44 => l_price_attributes_rec.PRICING_ATTRIBUTE44,
p_PRICING_ATTRIBUTE45 => l_price_attributes_rec.PRICING_ATTRIBUTE45,
p_PRICING_ATTRIBUTE46 => l_price_attributes_rec.PRICING_ATTRIBUTE46,
p_PRICING_ATTRIBUTE47 => l_price_attributes_rec.PRICING_ATTRIBUTE47,
p_PRICING_ATTRIBUTE48 => l_price_attributes_rec.PRICING_ATTRIBUTE48,
p_PRICING_ATTRIBUTE49 => l_price_attributes_rec.PRICING_ATTRIBUTE49,
p_PRICING_ATTRIBUTE50 => l_price_attributes_rec.PRICING_ATTRIBUTE50,
p_PRICING_ATTRIBUTE51 => l_price_attributes_rec.PRICING_ATTRIBUTE51,
p_PRICING_ATTRIBUTE52 => l_price_attributes_rec.PRICING_ATTRIBUTE52,
p_PRICING_ATTRIBUTE53 => l_price_attributes_rec.PRICING_ATTRIBUTE53,
p_PRICING_ATTRIBUTE54 => l_price_attributes_rec.PRICING_ATTRIBUTE54,
p_PRICING_ATTRIBUTE55 => l_price_attributes_rec.PRICING_ATTRIBUTE55,
p_PRICING_ATTRIBUTE56 => l_price_attributes_rec.PRICING_ATTRIBUTE56,
p_PRICING_ATTRIBUTE57 => l_price_attributes_rec.PRICING_ATTRIBUTE57,
p_PRICING_ATTRIBUTE58 => l_price_attributes_rec.PRICING_ATTRIBUTE58,
p_PRICING_ATTRIBUTE59 => l_price_attributes_rec.PRICING_ATTRIBUTE59,
p_PRICING_ATTRIBUTE60 => l_price_attributes_rec.PRICING_ATTRIBUTE60,
p_PRICING_ATTRIBUTE61 => l_price_attributes_rec.PRICING_ATTRIBUTE61,
p_PRICING_ATTRIBUTE62 => l_price_attributes_rec.PRICING_ATTRIBUTE62,
p_PRICING_ATTRIBUTE63 => l_price_attributes_rec.PRICING_ATTRIBUTE63,
p_PRICING_ATTRIBUTE64 => l_price_attributes_rec.PRICING_ATTRIBUTE64,
p_PRICING_ATTRIBUTE65 => l_price_attributes_rec.PRICING_ATTRIBUTE65,
p_PRICING_ATTRIBUTE66 => l_price_attributes_rec.PRICING_ATTRIBUTE66,
p_PRICING_ATTRIBUTE67 => l_price_attributes_rec.PRICING_ATTRIBUTE67,
p_PRICING_ATTRIBUTE68 => l_price_attributes_rec.PRICING_ATTRIBUTE68,
p_PRICING_ATTRIBUTE69 => l_price_attributes_rec.PRICING_ATTRIBUTE69,
p_PRICING_ATTRIBUTE70 => l_price_attributes_rec.PRICING_ATTRIBUTE70,
p_PRICING_ATTRIBUTE71 => l_price_attributes_rec.PRICING_ATTRIBUTE71,
p_PRICING_ATTRIBUTE72 => l_price_attributes_rec.PRICING_ATTRIBUTE72,
p_PRICING_ATTRIBUTE73 => l_price_attributes_rec.PRICING_ATTRIBUTE73,
p_PRICING_ATTRIBUTE74 => l_price_attributes_rec.PRICING_ATTRIBUTE74,
p_PRICING_ATTRIBUTE75 => l_price_attributes_rec.PRICING_ATTRIBUTE75,
p_PRICING_ATTRIBUTE76 => l_price_attributes_rec.PRICING_ATTRIBUTE76,
p_PRICING_ATTRIBUTE77 => l_price_attributes_rec.PRICING_ATTRIBUTE77,
p_PRICING_ATTRIBUTE78 => l_price_attributes_rec.PRICING_ATTRIBUTE78,
p_PRICING_ATTRIBUTE79 => l_price_attributes_rec.PRICING_ATTRIBUTE79,
p_PRICING_ATTRIBUTE80 => l_price_attributes_rec.PRICING_ATTRIBUTE80,
p_PRICING_ATTRIBUTE81 => l_price_attributes_rec.PRICING_ATTRIBUTE81,
p_PRICING_ATTRIBUTE82 => l_price_attributes_rec.PRICING_ATTRIBUTE82,
p_PRICING_ATTRIBUTE83 => l_price_attributes_rec.PRICING_ATTRIBUTE83,
p_PRICING_ATTRIBUTE84 => l_price_attributes_rec.PRICING_ATTRIBUTE84,
p_PRICING_ATTRIBUTE85 => l_price_attributes_rec.PRICING_ATTRIBUTE85,
p_PRICING_ATTRIBUTE86 => l_price_attributes_rec.PRICING_ATTRIBUTE86,
p_PRICING_ATTRIBUTE87 => l_price_attributes_rec.PRICING_ATTRIBUTE87,
p_PRICING_ATTRIBUTE88 => l_price_attributes_rec.PRICING_ATTRIBUTE88,
p_PRICING_ATTRIBUTE89 => l_price_attributes_rec.PRICING_ATTRIBUTE89,
p_PRICING_ATTRIBUTE90 => l_price_attributes_rec.PRICING_ATTRIBUTE90,
p_PRICING_ATTRIBUTE91 => l_price_attributes_rec.PRICING_ATTRIBUTE91,
p_PRICING_ATTRIBUTE92 => l_price_attributes_rec.PRICING_ATTRIBUTE92,
p_PRICING_ATTRIBUTE93 => l_price_attributes_rec.PRICING_ATTRIBUTE93,
p_PRICING_ATTRIBUTE94 => l_price_attributes_rec.PRICING_ATTRIBUTE94,
p_PRICING_ATTRIBUTE95 => l_price_attributes_rec.PRICING_ATTRIBUTE95,
p_PRICING_ATTRIBUTE96 => l_price_attributes_rec.PRICING_ATTRIBUTE96,
p_PRICING_ATTRIBUTE97 => l_price_attributes_rec.PRICING_ATTRIBUTE97,
p_PRICING_ATTRIBUTE98 => l_price_attributes_rec.PRICING_ATTRIBUTE98,
p_PRICING_ATTRIBUTE99 => l_price_attributes_rec.PRICING_ATTRIBUTE99,
p_PRICING_ATTRIBUTE100 => l_price_attributes_rec.PRICING_ATTRIBUTE100,
p_CONTEXT => l_price_attributes_rec.CONTEXT,
p_ATTRIBUTE1 => l_price_attributes_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_price_attributes_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_price_attributes_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_price_attributes_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_price_attributes_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_price_attributes_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_price_attributes_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_price_attributes_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_price_attributes_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_price_attributes_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_price_attributes_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_price_attributes_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_price_attributes_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_price_attributes_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_price_attributes_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_price_attributes_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_price_attributes_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_price_attributes_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_price_attributes_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_price_attributes_rec.ATTRIBUTE20,
p_OBJECT_VERSION_NUMBER => l_price_attributes_rec.OBJECT_VERSION_NUMBER
);
aso_debug_pub.add('Insert_Quote_lines - price_attr.insert_row ', 1, 'N');
ASO_SALES_CREDITS_PKG.Insert_Row(
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_REQUEST_ID => l_sales_CREDIT_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_sales_CREDIT_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_sales_CREDIT_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_sales_CREDIT_rec.PROGRAM_UPDATE_DATE,
px_SALES_CREDIT_ID => x_SALES_CREDIT_tbl(i).SALES_CREDIT_ID,
p_QUOTE_HEADER_ID => l_sales_CREDIT_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_sales_CREDIT_rec.QUOTE_LINE_ID,
p_PERCENT => l_sales_CREDIT_rec.PERCENT,
p_RESOURCE_ID => l_sales_CREDIT_rec.RESOURCE_ID,
p_RESOURCE_GROUP_ID => l_sales_CREDIT_rec.RESOURCE_GROUP_ID,
p_EMPLOYEE_PERSON_ID => l_sales_CREDIT_rec.EMPLOYEE_PERSON_ID,
p_SALES_CREDIT_TYPE_ID => l_sales_CREDIT_rec.SALES_CREDIT_TYPE_ID,
-- p_SECURITY_GROUP_ID => l_sales_CREDIT_rec.SECURITY_GROUP_ID,
p_ATTRIBUTE_CATEGORY_CODE => l_sales_CREDIT_rec.ATTRIBUTE_CATEGORY_CODE,
p_ATTRIBUTE1 => l_sales_CREDIT_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_sales_CREDIT_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_sales_CREDIT_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_sales_CREDIT_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_sales_CREDIT_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_sales_CREDIT_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_sales_CREDIT_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_sales_CREDIT_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_sales_CREDIT_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_sales_CREDIT_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_sales_CREDIT_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_sales_CREDIT_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_sales_CREDIT_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_sales_CREDIT_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_sales_CREDIT_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_sales_CREDIT_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_sales_CREDIT_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_sales_CREDIT_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_sales_CREDIT_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_sales_CREDIT_rec.ATTRIBUTE20,
p_SYSTEM_ASSIGNED_FLAG => 'N',
p_CREDIT_RULE_ID => l_sales_CREDIT_rec.CREDIT_RULE_ID,
p_OBJECT_VERSION_NUMBER => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);
aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).ship_method_code'||p_shipment_tbl(1).ship_method_code, 1, 'Y');
aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- p_shipment_tbl(1).freight_terms_code'||p_shipment_tbl(1).freight_terms_code, 1, 'Y');
ASO_SHIPMENTS_PKG.Insert_Row(
px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_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_shipment_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_shipment_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_shipment_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_shipment_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_shipment_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_shipment_rec.QUOTE_LINE_ID,
p_PROMISE_DATE => l_shipment_rec.PROMISE_DATE,
p_REQUEST_DATE => l_shipment_rec.REQUEST_DATE,
p_SCHEDULE_SHIP_DATE => l_shipment_rec.SCHEDULE_SHIP_DATE,
p_SHIP_TO_PARTY_SITE_ID => l_shipment_rec.SHIP_TO_PARTY_SITE_ID,
p_SHIP_TO_PARTY_ID => l_shipment_rec.SHIP_TO_PARTY_ID,
p_SHIP_TO_CUST_ACCOUNT_ID => l_shipment_rec.SHIP_TO_CUST_ACCOUNT_ID ,
p_SHIP_PARTIAL_FLAG => l_shipment_rec.SHIP_PARTIAL_FLAG,
p_SHIP_SET_ID => l_shipment_rec.SHIP_SET_ID,
p_SHIP_METHOD_CODE => l_shipment_rec.SHIP_METHOD_CODE,
p_FREIGHT_TERMS_CODE => l_shipment_rec.FREIGHT_TERMS_CODE,
p_FREIGHT_CARRIER_CODE => l_shipment_rec.FREIGHT_CARRIER_CODE,
p_FOB_CODE => l_shipment_rec.FOB_CODE,
p_SHIPPING_INSTRUCTIONS => l_shipment_rec.SHIPPING_INSTRUCTIONS,
p_PACKING_INSTRUCTIONS => l_shipment_rec.PACKING_INSTRUCTIONS,
p_SHIPMENT_PRIORITY_CODE => l_shipment_rec.SHIPMENT_PRIORITY_CODE,
p_SHIP_QUOTE_PRICE => l_shipment_rec.SHIP_QUOTE_PRICE,
p_QUANTITY => l_shipment_rec.QUANTITY,
p_RESERVED_QUANTITY => l_shipment_rec.RESERVED_QUANTITY,
p_RESERVATION_ID => l_shipment_rec.RESERVATION_ID,
p_ORDER_LINE_ID => l_shipment_rec.ORDER_LINE_ID,
p_ATTRIBUTE_CATEGORY => l_shipment_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_shipment_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_shipment_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_shipment_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_shipment_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_shipment_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_shipment_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_shipment_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_shipment_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_shipment_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_shipment_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_shipment_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_shipment_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_shipment_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_shipment_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_shipment_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_shipment_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_shipment_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_shipment_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_shipment_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_shipment_rec.ATTRIBUTE20,
p_SHIP_FROM_ORG_ID => l_shipment_rec.SHIP_FROM_ORG_ID,
p_SHIP_TO_CUST_PARTY_ID => l_shipment_rec.SHIP_TO_CUST_PARTY_ID,
p_SHIP_METHOD_CODE_FROM => l_shipment_rec.SHIP_METHOD_CODE_FROM,
p_FREIGHT_TERMS_CODE_FROM => l_shipment_rec.FREIGHT_TERMS_CODE_FROM,
p_OBJECT_VERSION_NUMBER => l_shipment_rec.OBJECT_VERSION_NUMBER,
p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
p_DEMAND_CLASS_CODE => l_shipment_rec.DEMAND_CLASS_CODE
);
aso_debug_pub.add('Insert_Quote_lines - shipments.insert_row ', 1, 'N');
ASO_FREIGHT_CHARGES_PKG.Insert_Row(
px_FREIGHT_CHARGE_ID => x_FREIGHT_CHARGE_tbl(i).freight_charge_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_freight_charge_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID
=> l_freight_charge_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_freight_charge_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_freight_charge_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_SHIPMENT_ID => l_freight_charge_rec.QUOTE_SHIPMENT_ID,
p_FREIGHT_CHARGE_TYPE_ID
=> l_freight_charge_rec.FREIGHT_CHARGE_TYPE_ID,
p_CHARGE_AMOUNT => l_freight_charge_rec.CHARGE_AMOUNT,
p_ATTRIBUTE_CATEGORY => l_freight_charge_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_freight_charge_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_freight_charge_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_freight_charge_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_freight_charge_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_freight_charge_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_freight_charge_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_freight_charge_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_freight_charge_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_freight_charge_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_freight_charge_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_freight_charge_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_freight_charge_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_freight_charge_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_freight_charge_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_freight_charge_rec.ATTRIBUTE15);
aso_debug_pub.add('Insert_Quote_lines - after frieght.insert_row '||x_return_status, 1, 'N');
ASO_TAX_DETAILS_PKG.Insert_Row(
px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_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_tax_detail_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_tax_detail_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_tax_detail_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE=> l_tax_detail_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_tax_detail_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_tax_detail_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_tax_detail_rec.QUOTE_SHIPMENT_ID,
p_ORIG_TAX_CODE => l_tax_detail_rec.ORIG_TAX_CODE,
p_TAX_CODE => l_tax_detail_rec.TAX_CODE,
p_TAX_RATE => l_tax_detail_rec.TAX_RATE,
p_TAX_DATE => l_tax_detail_rec.TAX_DATE,
p_TAX_AMOUNT => l_tax_detail_rec.TAX_AMOUNT,
p_TAX_EXEMPT_FLAG => l_tax_detail_rec.TAX_EXEMPT_FLAG,
p_TAX_EXEMPT_NUMBER => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
p_TAX_EXEMPT_REASON_CODE =>l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
p_ATTRIBUTE_CATEGORY => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_tax_detail_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_tax_detail_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_tax_detail_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_tax_detail_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_tax_detail_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_tax_detail_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_tax_detail_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_tax_detail_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_tax_detail_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_tax_detail_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_tax_detail_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_tax_detail_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_tax_detail_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_tax_detail_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_tax_detail_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_tax_detail_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_tax_detail_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_tax_detail_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_tax_detail_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_tax_detail_rec.ATTRIBUTE20,
p_TAX_INCLUSIVE_FLAG => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
);
aso_debug_pub.add('Insert_Quote_lines - after tax_details.insert_row '|| x_return_status, 1, 'N');
ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
px_PRICE_ADJUSTMENT_ID => x_price_adj_tbl(i).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_QUOTE_SHIPMENT_ID => l_price_adj_rec.QUOTE_SHIPMENT_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_LIST_HEADER_ID => l_price_adj_rec. ,
-- p_LIST_LINE_ID => l_price_adj_rec. ,
-- p_LIST_LINE_TYPE_CODE => l_price_adj_rec.,
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('Insert_Quote_lines - after price_adj.insert_row ', 1, 'N');
ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
px_PRICE_ADJ_ATTRIB_ID
=> x_price_adj_attr_tbl(i).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_tbl(i).PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_price_adj_attr_tbl(i).PROGRAM_ID,
p_PROGRAM_UPDATE_DATE =>l_price_adj_attr_tbl(i).PROGRAM_UPDATE_DATE,
p_REQUEST_ID => l_price_adj_attr_tbl(i).REQUEST_ID,
p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID,
p_PRICING_CONTEXT => l_price_adj_attr_tbl(i).PRICING_CONTEXT,
p_PRICING_ATTRIBUTE => l_price_adj_attr_tbl(i).PRICING_ATTRIBUTE,
p_PRICING_ATTR_VALUE_FROM
=> l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_FROM,
p_PRICING_ATTR_VALUE_TO
=> l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_TO,
p_COMPARISON_OPERATOR
=> l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
p_FLEX_TITLE => l_price_adj_attr_tbl(i).FLEX_TITLE,
P_OBJECT_VERSION_NUMBER => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER
);
aso_debug_pub.add('Insert_Quote_lines - price_adj_attr.insert_row ', 1, 'N');
aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');
aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
aso_debug_pub.add('Insert_Quote_Line_Rows: Before call to create_payment_row ', 1, 'Y');
aso_debug_pub.add('Insert_Quote_Line_Rows: After call to create_payment_row: x_return_status: '||x_return_status, 1, 'Y');
aso_debug_pub.add('Insert_Quote_lines - payment.insert_row ', 1, 'N');
ASO_QUOTE_PARTIES_PKG.Insert_Row(
px_QUOTE_PARTY_ID => x_quote_party_tbl(i).QUOTE_PARTY_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_LAST_UPDATED_BY => G_USER_ID,
p_REQUEST_ID => l_QUOTE_PARTY_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_QUOTE_PARTY_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_QUOTE_PARTY_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_QUOTE_PARTY_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_QUOTE_PARTY_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_QUOTE_PARTY_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_QUOTE_PARTY_rec.QUOTE_SHIPMENT_ID,
p_PARTY_TYPE => l_QUOTE_PARTY_rec.PARTY_TYPE,
p_PARTY_ID => l_QUOTE_PARTY_rec.PARTY_ID,
p_PARTY_OBJECT_TYPE => l_QUOTE_PARTY_rec.PARTY_OBJECT_TYPE,
p_PARTY_OBJECT_ID => l_QUOTE_PARTY_rec.PARTY_OBJECT_ID,
p_ATTRIBUTE_CATEGORY => l_QUOTE_PARTY_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_QUOTE_PARTY_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_QUOTE_PARTY_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_QUOTE_PARTY_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_QUOTE_PARTY_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_QUOTE_PARTY_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_QUOTE_PARTY_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_QUOTE_PARTY_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_QUOTE_PARTY_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_QUOTE_PARTY_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_QUOTE_PARTY_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_QUOTE_PARTY_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_QUOTE_PARTY_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_QUOTE_PARTY_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_QUOTE_PARTY_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_QUOTE_PARTY_rec.ATTRIBUTE15,
-- p_SECURITY_GROUP_ID => p_QUOTE_PARTY_rec.SECURITY_GROUP_ID);
ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row(
px_LINE_ATTRIBUTE_ID => x_LINE_ATTRIBS_EXT_TBL(i).LINE_ATTRIBUTE_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_LINE_ATTRIBS_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_LINE_ATTRIBS_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
p_APPLICATION_ID => l_LINE_ATTRIBS_rec.APPLICATION_ID,
p_STATUS => l_LINE_ATTRIBS_rec.STATUS,
p_QUOTE_HEADER_ID => l_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
p_ATTRIBUTE_TYPE_CODE => l_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
p_NAME => l_LINE_ATTRIBS_rec.NAME,
p_VALUE => l_LINE_ATTRIBS_rec.VALUE,
p_VALUE_TYPE => l_LINE_ATTRIBS_rec.VALUE_TYPE,
p_START_DATE_ACTIVE => l_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
p_END_DATE_ACTIVE => l_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
P_OBJECT_VERSION_NUMBER => l_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER);
aso_debug_pub.add('Insert_Quote_lines - line_attribs.insert_row ', 1, 'N');
-- Adding the call to insert record in the ASO_CHANGED_QUOTES
-- Finding the quote number
open get_quote_number(X_Qte_Line_Rec.QUOTE_HEADER_ID);
aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Insert_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
-- Call to insert record in ASO_CHANGED_QUOTES
ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
P_Update_Header_Flag IN VARCHAR2 := FND_API.G_TRUE,
P_operation_code IN VARCHAR2,
X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
X_Qte_Line_Dtl_TBL OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type,
X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)
IS
/* 2633507 - hyang: using lc_organization_id as cursor variable */
CURSOR C_item1(inv1 NUMBER, lc_organization_id NUMBER) IS
select primary_uom_code, service_item_flag,serviceable_product_flag,ship_model_complete_flag,
payment_terms_id,config_model_type
from mtl_system_items_b
where inventory_item_id = inv1
and organization_id = lc_organization_id;
SELECT count(*) ,sum(quantity)
FROM aso_shipments
WHERE quote_line_id = p_qte_line_rec.quote_line_id;
SELECT quote_header_id, organization_id, inventory_item_id
FROM aso_quote_lines_all
WHERE quote_line_id = p_qte_line_rec.quote_line_id;
SELECT cust_account_id, party_id
FROM aso_quote_headers_all
WHERE quote_header_id = p_qte_line_rec.quote_header_id;
SELECT qln.start_date_active, qln.end_date_active,
detail.service_duration, detail.service_period,
detail.service_coterminate_flag,
qhd.cust_account_id, qhd.party_id
FROM aso_quote_lines_all qln,
aso_quote_line_details detail,
aso_quote_headers_all qhd
WHERE detail.quote_line_id = qln.quote_line_id
AND qln.quote_line_id = p_qte_line_rec.quote_line_id
AND qln.quote_header_id = qhd.quote_header_id;
SELECT org_id
FROM aso_quote_headers_all
WHERE quote_header_id = p_qte_line_rec.quote_header_id;
SELECT line_number
FROM aso_quote_lines_all
where quote_line_id = p_quote_line_id;
select config_item_id, bom_sort_order
from cz_config_details_v
where config_hdr_id = p_config_header_id and
config_rev_nbr = p_config_revision_num and
component_code = p_component_code;
select bom_sort_order
from cz_config_details_v
where config_hdr_id = p_config_header_id and
config_rev_nbr = p_config_revision_num and
config_item_id = p_config_item_id;
SELECT charge_periodicity_code
FROM mtl_system_items_b
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_organization_id;
select payment_term_id
from aso_payments
where quote_header_id = l_qte_hdr_id
and quote_line_id is null;
SELECT Decode(i.bom_item_type , 1, 'MDL',2,'OPT',3,'PLN',4,'STD')
INTO l_qte_line_rec.item_type_code
FROM mtl_system_items_b i
WHERE inventory_item_id = l_qte_line_rec.inventory_item_id
AND organization_id = l_qte_line_rec.organization_id;
SELECT max(line_number) into l_line_number
FROM aso_quote_lines_all
WHERE quote_header_id = l_qte_line_rec.quote_header_id;
IF p_operation_code = 'UPDATE' THEN
l_qte_line_rec.service_item_flag := fnd_api.g_miss_char;
--Made changes in cursor to select inventory_item_id for Bug#2930734
OPEN C_header;
aso_debug_pub.add('populate_quote_line: operation_code: UPDATE');
select quantity into l_qte_line_rec.quantity from aso_quote_lines_All
where quote_line_id = l_qte_line_rec.quote_line_id;
SELECT shipment_id into l_shipment_tbl(1).shipment_id
FROM aso_shipments
WHERE quote_line_id = l_qte_line_rec.quote_line_id
AND quote_header_id = l_qte_line_rec.quote_header_id;
l_shipment_tbl(1).operation_code := 'UPDATE';
aso_debug_pub.add('Populate_Quote_lines:Update :before call to ASO_SERVICE_CONTRACTS_INT.Get_service_attributes', 1, 'N');
l_qte_line_dtl_tbl(1).operation_code := 'UPDATE';
aso_debug_pub.add('Before populating config_item_id,bom_sort_order. Operation_code = UPDATE');
END IF; -- operation code 'update'
aso_debug_pub.add('Populate_Quote_lines:Update :after update '||X_Return_Status, 1, 'N');
P_Update_Header_Flag IN VARCHAR2 := 'Y',
X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
X_Qte_Line_Dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type,
X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)
IS
Cursor C_Get_quote(c_QUOTE_HEADER_ID Number) IS
Select LAST_UPDATE_DATE, QUOTE_STATUS_ID, QUOTE_NUMBER, TOTAL_ADJUSTED_PERCENT
From ASO_QUOTE_HEADERS_ALL
Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B
WHERE quote_status_id = c_qte_status_id;
SELECT max(quote_version)
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_number = X_qte_number;
SELECT CUST_ACCOUNT_ID
FROM ASO_QUOTE_HEADERS_ALL
WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID FROM mtl_system_items_b
WHERE RESERVABLE_TYPE =1 AND
MTL_TRANSACTIONS_ENABLED_FLAG = 'Y' AND
INVENTORY_ITEM_ID= C_inv_item_id AND
ORGANIZATION_ID = C_Organization_id;
Select quote_expiration_date
From ASO_QUOTE_HEADERS_ALL
Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
SELECT org_id
FROM aso_quote_headers_all
WHERE quote_header_id = p_qte_line_rec.quote_header_id;
select service_item_flag,serviceable_product_flag
from aso_quote_lines_All
where quote_line_id = p_qln_id;
SELECT line_category_code
FROM aso_quote_lines_all
WHERE quote_line_id = p_quote_line_id;
select config_model_type
from mtl_system_items_b
where INVENTORY_ITEM_ID= C_inv_item_id
AND ORGANIZATION_ID = C_Organization_id;
SELECT org_id,quote_type FROM aso_quote_headers_all
WHERE quote_header_id = P_qte_line_rec.quote_header_id;
l_last_update_date DATE;
l_update_allowed VARCHAR2(1);
l_call_update varchar2(1);
IF (p_update_header_flag = 'Y') THEN
Open C_Get_quote( p_qte_line_rec.QUOTE_HEADER_ID);
Fetch C_Get_quote into l_LAST_UPDATE_DATE, l_qte_status_id, l_quote_number, l_hd_discount_percent;
FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (trunc(l_last_update_date) <> trunc(p_control_rec.last_update_date)) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
aso_debug_pub.add('After Last update date validation',1,'N');
Fetch C_qte_status into l_update_allowed, l_auto_version;
aso_debug_pub.add('l_update_allowed: '|| nvl(l_update_allowed,'null'),1,'N');
update aso_quote_headers_all
set quote_version = l_quote_version + 1,
max_version_flag = 'Y',
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = p_qte_line_rec.quote_header_id;
update aso_quote_headers_all
set max_version_flag = 'N',
quote_version = l_old_header_rec.quote_version,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = x_quote_header_id;
update aso_quote_headers_all
set quote_version = l_quote_version,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = p_qte_line_rec.quote_header_id;
END IF; -- header update flag
if (p_sales_credit_tbl(i).operation_code = 'CREATE' or p_sales_credit_tbl(i).operation_code = 'UPDATE') then
ASO_VALIDATE_PVT.Validate_Resource_id(
p_init_msg_list => FND_API.G_FALSE,
p_resource_id => p_sales_credit_tbl(i).resource_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
Insert_Quote_Line_Rows(
P_Qte_Line_Rec => l_Qte_Line_Rec ,
P_Control_Rec => l_Control_Rec ,
P_Payment_Tbl => l_Payment_Tbl ,
P_Price_Adj_Tbl => l_Price_Adj_Tbl ,
P_Qte_Line_Dtl_tbl => l_Qte_Line_Dtl_tbl ,
P_Shipment_Tbl => l_Shipment_Tbl ,
P_Tax_Detail_Tbl => l_Tax_Detail_Tbl ,
P_Freight_Charge_Tbl => l_Freight_Charge_Tbl ,
P_Price_Attributes_Tbl => l_Price_Attributes_Tbl ,
P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl ,
P_Line_Attribs_Ext_Tbl => l_Line_Attribs_Ext_Tbl,
P_Sales_Credit_Tbl => l_sales_credit_tbl,
P_Quote_Party_Tbl => l_quote_party_tbl,
X_Qte_Line_Rec => X_Qte_Line_Rec ,
X_Payment_Tbl => X_Payment_Tbl ,
X_Price_Adj_Tbl => X_Price_Adj_Tbl ,
X_Qte_Line_Dtl_tbl => X_Qte_Line_Dtl_tbl ,
X_Shipment_Tbl => X_Shipment_Tbl ,
X_Tax_Detail_Tbl => X_Tax_Detail_Tbl ,
X_Freight_Charge_Tbl => X_Freight_Charge_Tbl ,
X_Price_Attributes_Tbl => X_Price_Attributes_Tbl ,
X_Price_Adj_Attr_Tbl => X_Price_Adj_Attr_Tbl ,
X_Line_Attribs_Ext_Tbl => X_Line_Attribs_Ext_Tbl,
X_Sales_Credit_Tbl =>x_sales_credit_tbl,
X_Quote_Party_Tbl =>x_quote_party_tbl,
X_Return_Status => X_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
FND_MESSAGE.Set_Name('ASO', 'ASO_INSERT_ERROR');
aso_debug_pub.add('Create_Quote_lines - after insert_quote_line_rows '||x_return_status, 1, 'Y');
l_call_update := FND_API.G_FALSE;
l_call_update := FND_API.G_TRUE;
l_call_update := FND_API.G_TRUE;
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_call_update'||l_call_update,1, 'N');
IF l_call_update = FND_API.G_TRUE THEN
ASO_QUOTE_LINES_PVT.service_item_qty_update
(p_qte_line_rec => X_Qte_Line_Rec ,
p_service_item_flag => l_service,
x_return_status => X_return_status
);
aso_debug_pub.add('Create_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '|| x_return_status, 1, 'Y');
l_tax_control_rec.update_db := 'Y' ; --FND_API.G_TRUE;
UPDATE ASO_SHIPMENTS
SET reservation_id = l_shipment_tbl(i).reservation_id,
reserved_quantity = l_shipment_tbl(i).reserved_quantity,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
WHERE shipment_id = l_shipment_tbl(i).shipment_id;
IF p_update_header_flag = 'Y' THEN
-- Update Quote total info (do summation to get TOTAL_LIST_PRICE,
-- TOTAL_ADJUSTED_AMOUNT, TOTAL_TAX, TOTAL_SHIPPING_CHARGE, SURCHARGE,
-- TOTAL_QUOTE_PRICE, PAYMENT_AMOUNT)
-- IF calculate_tax_flag = 'N', not summation on line level tax,
-- just take the value of p_qte_rec.total_tax as the total_tax
-- IF calculate_Freight_Charge = 'N', not summation on line level freight charge,
-- just take the value of p_qte_rec.total_freight_charge
-- how can i get the calc_tax_flag and calc_freight_charge_flag ??
IF aso_debug_pub.g_debug_flag = 'Y' THEN
aso_debug_pub.add('Create_Quote_lines - before update_quote_total '||l_return_status, 1, 'Y');
ASO_QUOTE_HEADERS_PVT.Update_Quote_Total (
P_Qte_Header_id => x_Qte_line_rec.quote_header_id,
P_calculate_tax => l_control_rec.CALCULATE_TAX_FLAG,
P_calculate_freight_charge=> l_control_rec.calculate_freight_charge_flag,
p_control_rec => l_control_rec,
X_Return_Status => l_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
-- Adding the call to insert record in the ASO_CHANGED_QUOTES
SELECT quote_number
INTO l_quote_number
FROM aso_quote_headers
WHERE quote_header_id = x_Qte_line_rec.quote_header_id ;
aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Create_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
-- Call to insert record in ASO_CHANGED_QUOTES
ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
PROCEDURE Update_Quote_Line(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_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_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_MISS_tax_detail_TBL,
P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := ASO_QUOTE_PUB.G_MISS_freight_charge_TBL,
P_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Price_attributes_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_Line_Attribs_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type := ASO_QUOTE_PUB.G_Miss_Line_Attribs_Ext_Tbl,
P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
P_Update_Header_Flag IN VARCHAR2 := 'Y',
X_Qte_Line_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Rec_Type,
X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
X_Price_Adj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
X_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type ,
X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type ,
X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
X_Line_Attribs_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_type,
X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)
IS
G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
SELECT head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
head.TOTAL_ADJUSTED_PERCENT,head.quote_expiration_date
FROM ASO_QUOTE_HEADERS_ALL head,
ASO_QUOTE_LINES_ALL line
WHERE head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
AND line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B
WHERE quote_status_id = c_qte_status_id;
SELECT max(quote_version)
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_number = X_qte_number;
SELECT sum(customer_product_quantity) FROM cs_line_inst_details
WHERE quote_line_shipment_id = X_shipment_id;
select b.quantity
from csi_t_transaction_lines a, csi_t_txn_line_details b
where a.source_transaction_table='ASO_QUOTE_LINES_ALL'
and a.source_transaction_id = x_quote_line_id
and a.transaction_line_id = b.transaction_line_id;
SELECT count(*)
FROM aso_shipments
WHERE quote_line_id = l_quote_line_id;
SELECT CUST_ACCOUNT_ID
FROM ASO_QUOTE_HEADERS_ALL
WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
Select quote_expiration_date
From ASO_QUOTE_HEADERS_ALL
Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
SELECT org_id
FROM aso_quote_lines_all
WHERE quote_line_id = p_qte_line_rec.quote_line_id;
select inventory_item_id
from aso_quote_lines_all
where quote_line_id = P_Qte_Line_Rec.quote_line_id;
select service_item_flag,serviceable_product_flag
from aso_quote_lines_All
where quote_line_id = p_qln_id;
select quote_line_id from aso_quote_lines_all
where quote_line_id = p_qte_line_rec.quote_line_id;
select line_category_code
from aso_quote_lines_all
where quote_line_id = p_quote_line_id;
select a.line_category_code, a.order_line_type_id, b.config_header_id, b.config_revision_num
from aso_quote_lines_all a, aso_quote_line_details b
where a.quote_line_id = b.quote_line_id
and a.quote_line_id = p_quote_line_id;
select item_type_code
from aso_quote_lines_all
where quote_line_id = p_qte_line_rec.quote_line_id;
select quote_line_id
from aso_quote_line_details
where service_ref_line_id = p_qte_line_rec.quote_line_id;
select price_adjustment_id
from aso_price_adj_relationships a
where a.price_adjustment_id = ( select price_adjustment_id
from aso_price_adjustments b
where a.price_adjustment_id = b.price_adjustment_id
and b.MODIFIER_LINE_TYPE_CODE = 'PBH')
and a.rltd_price_adj_id = p_price_adjustment_id;
l_last_update_date DATE;
l_api_name VARCHAR2(50) := 'Update_Quote_Line';
l_update_allowed VARCHAR2(1);
l_call_update varchar2(1);
SELECT 'x' FROM ASO_LINE_RELATIONSHIPS
WHERE quote_line_id = p_line_id and
related_quote_line_id = p_rel_line_id
AND relationship_type_code = 'SERVICE';
SELECT payment_term_id_from,payment_term_id
FROM ASO_PAYMENTS
WHERE payment_id = p_payment_id;
SELECT ship_method_code_from,ship_method_code,
Freight_terms_code_from,Freight_terms_code
FROM ASO_SHIPMENTS
WHERE shipment_id = p_shipment_id;
select service_ref_type_code from aso_quote_line_details
where quote_line_detail_id = p_quote_line_detail_id;
select payment_type_code
from aso_payments
where payment_id = l_payment_id;
select invoice_to_cust_party_id
from aso_quote_lines_all
where quote_line_id = l_qte_line_id;
SAVEPOINT UPDATE_quote_line_PVT;
aso_debug_pub.add('Update_Quote_line - Begin ', 1, 'Y');
IF (p_update_header_flag = 'Y') THEN
Open C_Get_quote( p_qte_line_rec.QUOTE_LINE_ID);
Fetch C_Get_quote into l_LAST_UPDATE_DATE, l_qte_status_id, l_quote_number, l_hd_discount_percent,l_quote_exp_date;
FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (trunc(l_last_update_date) <> trunc(p_control_rec.last_update_date)) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
aso_debug_pub.add('After Last update date validation',1,'N');
Fetch C_qte_status into l_update_allowed, l_auto_version;
aso_debug_pub.add('l_update_allowed: '||l_update_allowed,1,'N');
aso_debug_pub.add('Update_Quote_Line: After copy_quote');
update aso_quote_headers_all
set quote_version = l_quote_version + 1,
max_version_flag = 'Y',
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = p_qte_line_rec.quote_header_id;
update aso_quote_headers_all
set max_version_flag = 'N',
quote_version = l_old_header_rec.quote_version,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = x_quote_header_id;
update aso_quote_headers_all
set quote_version = l_quote_version,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = p_qte_line_rec.quote_header_id;
END IF; -- update header flag
aso_debug_pub.add('Update_Quote_Line: Before defaulting framework', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: populate defaulting control record from the line control record', 1, 'Y');
l_def_control_rec.Defaulting_Flow_Code := 'UPDATE';
l_def_control_rec.last_update_date := p_control_rec.last_update_date;
aso_debug_pub.add('last_update_date: '|| l_def_control_rec.last_update_date, 1, 'Y');
aso_debug_pub.add('Update_Quote_Line - Before Calling Default_Entity procedure', 1, 'Y');
aso_debug_pub.add('Update_Quote_line: After call to ASO_DEFAULTING_INT.Default_Entity', 1, 'Y');
aso_debug_pub.add('Update_Quote_line: x_return_status: '|| x_return_status, 1, 'Y');
aso_debug_pub.add('Update_Quote_line - before validation', 1, 'Y');
aso_debug_pub.add('Update_Quote_line: ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM: '||ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM, 1, 'Y');
if (p_sales_credit_tbl(i).operation_code = 'CREATE' or p_sales_credit_tbl(i).operation_code = 'UPDATE') then
ASO_VALIDATE_PVT.Validate_Resource_id(
p_init_msg_list => FND_API.G_FALSE,
p_resource_id => p_sales_credit_tbl(i).resource_id ,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
SELECT inventory_item_id INTO l_inventory_item_id
FROM aso_quote_lines_all
WHERE quote_line_id = lx_qte_line_rec.quote_line_id;
aso_debug_pub.add('Update_Quote_Line: before Validate_UOM_code: l_organization_id: '|| l_organization_id, 1, 'N');
aso_debug_pub.add('Update_Quote_Line: before Validate_UOM_code: l_inventory_item_id: '|| l_inventory_item_id, 1, 'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
aso_debug_pub.add('Update_Quote_Lines after Validate_Configuration :x_return_status:'||x_return_status,1, 'N');
aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID', 1, 'Y');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID.', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID (no lx_ln_shipment_tbl)', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: after Validate_ship_from_org_ID (no lx_ln_shipment_tbl)', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS (no lx_ln_shipment_tbl)', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: before Validate_ship_from_org_ID (no db_shipment_tbl)', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line: after Validate_ship_from_org_ID (no db_shipment_tbl)', 1, 'Y');
aso_debug_pub.add('Update_Quote_line - before Inst details and populate_quote_line ', 1, 'N');
aso_debug_pub.add('Update_Quote_Line - after Validate_Agreement:lx_qte_line_rec.UOM_Code: '||lx_qte_line_rec.UOM_Code,1, 'N');
aso_debug_pub.add('Update_Quote_Line - after Validate_Agreement:lx_qte_line_rec.Quantity: '||lx_qte_line_rec.Quantity,1, 'N');
aso_debug_pub.add('Update_Quote_Line - Invalid Quantity for EDU: ',1, 'N');
aso_debug_pub.add('Update_Quote_Line - Before call to Populate_Quote_Line.',1, 'N');
P_Operation_Code => 'UPDATE',
X_Qte_Line_Rec => l_Qte_Line_Rec,
X_Payment_Tbl => l_Payment_Tbl,
X_Price_Adj_Tbl => l_Price_Adj_Tbl,
X_Qte_Line_Dtl_tbl => l_Qte_Line_Dtl_tbl,
X_Shipment_Tbl => l_Shipment_Tbl,
X_Tax_Detail_Tbl => l_Tax_Detail_Tbl,
X_Freight_Charge_Tbl => l_Freight_Charge_Tbl,
X_Price_Attributes_Tbl => l_Price_Attributes_Tbl,
X_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl,
X_Line_Attribs_Ext_Tbl => l_Line_Attribs_Ext_Tbl,
X_Sales_Credit_Tbl => l_sales_credit_tbl,
x_Quote_Party_Tbl => l_quote_party_tbl,
X_Return_Status => X_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data );
aso_debug_pub.add('Update_Quote_Line - After call to Populate_Quote_Line: x_return_status: '|| x_return_status ,1, 'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: Begin Inter entity validations');
aso_debug_pub.add('Update_Quote_line - ship method codeof quote line is being updated ', 1, 'N');
aso_debug_pub.add('Update_Quote_line - before validate ship_method_code ', 1, 'N');
p_operation_code => 'UPDATE',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
aso_debug_pub.add('Update_Quote_line - After validate ship_method_code ', 1, 'N');
aso_debug_pub.add('Update_Quote_line - Organization id of quote line is being updated ', 1, 'N');
aso_debug_pub.add('Update_Quote_line - before validate ship_method_code ', 1, 'N');
p_operation_code => 'UPDATE',
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
aso_debug_pub.add('Update_Quote_line - After validate ship_method_code ', 1, 'N');
aso_debug_pub.add('Update_Quote_line: After Validate_Service: x_return_status: '|| x_return_status);
aso_debug_pub.add('Update_Quote_line: After validate service period: x_return_status: '|| x_return_status);
aso_debug_pub.add('UPDATE_QUOTE_LINE: Before calling aso_validate_pvt.validate_service_ref_line_id');
aso_debug_pub.add('UPDATE_QUOTE_LINE: After calling aso_validate_pvt.validate_service_ref_line_id');
aso_debug_pub.add('UPDATE_QUOTE_LINE: x_return_status: '|| x_return_status);
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: End of Inter entity validations');
aso_debug_pub.add('Update_Quote_Line - after Validate_Line_Tradein:x_return_status: '||x_return_status, 1, 'N');
aso_debug_pub.add('Update_Quote_Line - after Validate_IB_Return_Qty:x_return_status: '||x_return_status, 1, 'N');
aso_debug_pub.add('Update_Quote_Line - before Validate_Agreement:l_Qte_Line_Rec.Agreement_Id: '||l_Qte_Line_Rec.Agreement_Id, 1, 'N');
aso_debug_pub.add('Update_Quote_Line - after Validate_Agreement:x_return_status: '||x_return_status, 1, 'N');
ASO_QUOTE_LINES_PKG.Update_Row(
p_QUOTE_LINE_ID => l_Qte_Line_Rec.QUOTE_LINE_ID,
p_CREATION_DATE => l_qte_line_rec.creation_date,
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 => trunc(l_qte_line_rec.START_DATE_ACTIVE),
p_END_DATE_ACTIVE => trunc(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_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_PRICED_PRICE_LIST_ID => l_qte_line_rec.PRICED_PRICE_LIST_ID,
p_AGREEMENT_ID => l_qte_line_rec.AGREEMENT_ID,
p_COMMITMENT_ID => l_qte_line_rec.COMMITMENT_ID,
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('Update_Quote_line - after line.update ', 1, 'N');
aso_debug_pub.add('Update_Quote_lines - l_Qte_Line_Rec.line_category_code: '||l_Qte_Line_Rec.line_category_code, 1, 'Y');
aso_debug_pub.add('Update_Quote_lines - l_Qte_Line_Rec.order_line_type_id: '||l_Qte_Line_Rec.order_line_type_id, 1, 'Y');
aso_debug_pub.add('Update_Quote_lines - l_Qte_Line_Rec.item_type_code: '||l_Qte_Line_Rec.item_type_code, 1, 'Y');
aso_debug_pub.add('Update_Quote_lines - Cursor c_item_type_code: l_item_type_code: '||l_item_type_code, 1, 'Y');
aso_debug_pub.add('Update_Quote_lines - Updating l_line_category_code of children.');
update aso_quote_lines_all
set line_category_code = l_line_category_code,
order_line_type_id = l_order_line_type_id,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where NVL(line_type_source_flag,'X') <> 'C'
and quote_line_id in( select quote_line_id
from aso_quote_line_details
where ref_line_id is not null
and ref_type_code = 'CONFIG'
and config_header_id = l_config_header_id
and config_revision_num = l_config_revision_num );
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_quote_line: line_category_code
update, inside WHEN OTHERS EXCEPTION');
ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(
px_QUOTE_LINE_DETAIL_ID
=> x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_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_dtl_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID
=> l_qte_line_dtl_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_qte_line_dtl_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_qte_line_dtl_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_LINE_ID => l_qte_line_dtl_rec.QUOTE_LINE_ID,
p_CONFIG_HEADER_ID => l_qte_line_dtl_rec.CONFIG_HEADER_ID,
p_CONFIG_REVISION_NUM => l_qte_line_dtl_rec.CONFIG_REVISION_NUM,
p_COMPLETE_CONFIGURATION_FLAG
=> l_qte_line_dtl_rec.COMPLETE_CONFIGURATION_FLAG,
p_VALID_CONFIGURATION_FLAG
=> l_qte_line_dtl_rec.VALID_CONFIGURATION_FLAG,
p_COMPONENT_CODE => l_qte_line_dtl_rec.COMPONENT_CODE,
p_SERVICE_COTERMINATE_FLAG
=> l_qte_line_dtl_rec.SERVICE_COTERMINATE_FLAG,
p_SERVICE_DURATION => l_qte_line_dtl_rec.SERVICE_DURATION,
p_SERVICE_PERIOD => l_qte_line_dtl_rec.SERVICE_PERIOD,
p_SERVICE_UNIT_SELLING_PERCENT
=> l_qte_line_dtl_rec.SERVICE_UNIT_SELLING_PERCENT,
p_SERVICE_UNIT_LIST_PERCENT
=> l_qte_line_dtl_rec.SERVICE_UNIT_LIST_PERCENT,
p_SERVICE_NUMBER => l_qte_line_dtl_rec.SERVICE_NUMBER,
p_UNIT_PERCENT_BASE_PRICE
=> l_qte_line_dtl_rec.UNIT_PERCENT_BASE_PRICE,
p_ATTRIBUTE_CATEGORY => l_qte_line_dtl_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_qte_line_dtl_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_qte_line_dtl_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_qte_line_dtl_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_qte_line_dtl_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_qte_line_dtl_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_qte_line_dtl_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_qte_line_dtl_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_qte_line_dtl_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_qte_line_dtl_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_qte_line_dtl_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_qte_line_dtl_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_qte_line_dtl_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_qte_line_dtl_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_qte_line_dtl_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_qte_line_dtl_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_qte_line_dtl_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_qte_line_dtl_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_qte_line_dtl_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_qte_line_dtl_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_qte_line_dtl_rec.ATTRIBUTE20,
p_SERVICE_REF_TYPE_CODE => l_qte_line_dtl_rec.SERVICE_REF_TYPE_CODE,
p_SERVICE_REF_ORDER_NUMBER
=> l_qte_line_dtl_rec.SERVICE_REF_ORDER_NUMBER,
p_SERVICE_REF_LINE_NUMBER
=> l_qte_line_dtl_rec.SERVICE_REF_LINE_NUMBER,
p_SERVICE_REF_LINE_ID => l_qte_line_dtl_rec.SERVICE_REF_LINE_ID,
p_SERVICE_REF_SYSTEM_ID => l_qte_line_dtl_rec.SERVICE_REF_SYSTEM_ID,
p_SERVICE_REF_OPTION_NUMB
=> l_qte_line_dtl_rec.SERVICE_REF_OPTION_NUMB,
p_SERVICE_REF_SHIPMENT_NUMB
=> l_qte_line_dtl_rec.SERVICE_REF_SHIPMENT_NUMB,
p_RETURN_REF_TYPE => l_qte_line_dtl_rec.RETURN_REF_TYPE,
p_RETURN_REF_HEADER_ID => l_qte_line_dtl_rec.RETURN_REF_HEADER_ID,
p_RETURN_REF_LINE_ID => l_qte_line_dtl_rec.RETURN_REF_LINE_ID,
p_RETURN_ATTRIBUTE1 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE1,
p_RETURN_ATTRIBUTE2 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE2,
p_RETURN_ATTRIBUTE3 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE3,
p_RETURN_ATTRIBUTE4 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE4,
p_RETURN_ATTRIBUTE5 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE5,
p_RETURN_ATTRIBUTE6 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE6,
p_RETURN_ATTRIBUTE7 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE7,
p_RETURN_ATTRIBUTE8 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE8,
p_RETURN_ATTRIBUTE9 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE9,
p_RETURN_ATTRIBUTE10 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE10,
p_RETURN_ATTRIBUTE11 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE11,
p_RETURN_ATTRIBUTE15 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE15,
p_RETURN_ATTRIBUTE12 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE12,
p_RETURN_ATTRIBUTE13 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE13,
p_RETURN_ATTRIBUTE14 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE14,
p_RETURN_REASON_CODE => l_qte_line_dtl_rec.RETURN_REASON_CODE,
p_CONFIG_ITEM_ID => l_qte_line_dtl_rec.CONFIG_ITEM_ID,
p_REF_TYPE_CODE => l_qte_line_dtl_rec.REF_TYPE_CODE,
p_REF_LINE_ID => l_qte_line_dtl_rec.REF_LINE_ID,
p_INSTANCE_ID => l_qte_line_dtl_rec.INSTANCE_ID,
p_BOM_SORT_ORDER => l_qte_line_dtl_rec.BOM_SORT_ORDER,
p_CONFIG_DELTA => l_qte_line_dtl_rec.CONFIG_DELTA,
p_CONFIG_INSTANCE_NAME => l_qte_line_dtl_rec.CONFIG_INSTANCE_NAME,
p_OBJECT_VERSION_NUMBER => l_qte_line_dtl_rec.OBJECT_VERSION_NUMBER,
p_top_model_line_id => l_qte_line_dtl_rec.top_model_line_id,
p_ato_line_id => l_qte_line_dtl_rec.ato_line_id,
p_component_sequence_id => l_qte_line_dtl_rec.component_sequence_id
);
ELSIF l_qte_line_dtl_tbl(i).operation_code = 'UPDATE' THEN
x_qte_line_dtl_tbl(i) := l_qte_line_dtl_rec;
ASO_QUOTE_LINE_DETAILS_PKG.Update_Row(
p_QUOTE_LINE_DETAIL_ID => l_qte_line_dtl_rec.QUOTE_LINE_DETAIL_ID,
p_CREATION_DATE => l_qte_line_dtl_rec.creation_date,
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_dtl_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID
=> l_qte_line_dtl_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_qte_line_dtl_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_qte_line_dtl_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_LINE_ID => l_qte_line_dtl_rec.QUOTE_LINE_ID,
p_CONFIG_HEADER_ID => l_qte_line_dtl_rec.CONFIG_HEADER_ID,
p_CONFIG_REVISION_NUM => l_qte_line_dtl_rec.CONFIG_REVISION_NUM,
p_COMPLETE_CONFIGURATION_FLAG
=> l_qte_line_dtl_rec.COMPLETE_CONFIGURATION_FLAG,
p_VALID_CONFIGURATION_FLAG
=> l_qte_line_dtl_rec.VALID_CONFIGURATION_FLAG,
p_COMPONENT_CODE => l_qte_line_dtl_rec.COMPONENT_CODE,
p_SERVICE_COTERMINATE_FLAG
=> l_qte_line_dtl_rec.SERVICE_COTERMINATE_FLAG,
p_SERVICE_DURATION => l_qte_line_dtl_rec.SERVICE_DURATION,
p_SERVICE_PERIOD => l_qte_line_dtl_rec.SERVICE_PERIOD,
p_SERVICE_UNIT_SELLING_PERCENT
=> l_qte_line_dtl_rec.SERVICE_UNIT_SELLING_PERCENT,
p_SERVICE_UNIT_LIST_PERCENT
=> l_qte_line_dtl_rec.SERVICE_UNIT_LIST_PERCENT,
p_SERVICE_NUMBER => l_qte_line_dtl_rec.SERVICE_NUMBER,
p_UNIT_PERCENT_BASE_PRICE
=> l_qte_line_dtl_rec.UNIT_PERCENT_BASE_PRICE,
p_ATTRIBUTE_CATEGORY => l_qte_line_dtl_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_qte_line_dtl_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_qte_line_dtl_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_qte_line_dtl_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_qte_line_dtl_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_qte_line_dtl_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_qte_line_dtl_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_qte_line_dtl_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_qte_line_dtl_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_qte_line_dtl_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_qte_line_dtl_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_qte_line_dtl_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_qte_line_dtl_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_qte_line_dtl_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_qte_line_dtl_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_qte_line_dtl_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_qte_line_dtl_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_qte_line_dtl_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_qte_line_dtl_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_qte_line_dtl_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_qte_line_dtl_rec.ATTRIBUTE20,
p_SERVICE_REF_TYPE_CODE => l_qte_line_dtl_rec.SERVICE_REF_TYPE_CODE,
p_SERVICE_REF_ORDER_NUMBER
=> l_qte_line_dtl_rec.SERVICE_REF_ORDER_NUMBER,
p_SERVICE_REF_LINE_NUMBER
=> l_qte_line_dtl_rec.SERVICE_REF_LINE_NUMBER,
p_SERVICE_REF_LINE_ID => l_qte_line_dtl_rec.SERVICE_REF_LINE_ID,
p_SERVICE_REF_SYSTEM_ID => l_qte_line_dtl_rec.SERVICE_REF_SYSTEM_ID,
p_SERVICE_REF_OPTION_NUMB
=> l_qte_line_dtl_rec.SERVICE_REF_OPTION_NUMB,
p_SERVICE_REF_SHIPMENT_NUMB
=> l_qte_line_dtl_rec.SERVICE_REF_SHIPMENT_NUMB,
p_RETURN_REF_TYPE => l_qte_line_dtl_rec.RETURN_REF_TYPE,
p_RETURN_REF_HEADER_ID=> l_qte_line_dtl_rec.RETURN_REF_HEADER_ID,
p_RETURN_REF_LINE_ID => l_qte_line_dtl_rec.RETURN_REF_LINE_ID,
p_RETURN_ATTRIBUTE1 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE1,
p_RETURN_ATTRIBUTE2 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE2,
p_RETURN_ATTRIBUTE3 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE3,
p_RETURN_ATTRIBUTE4 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE4,
p_RETURN_ATTRIBUTE5 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE5,
p_RETURN_ATTRIBUTE6 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE6,
p_RETURN_ATTRIBUTE7 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE7,
p_RETURN_ATTRIBUTE8 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE8,
p_RETURN_ATTRIBUTE9 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE9,
p_RETURN_ATTRIBUTE10 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE10,
p_RETURN_ATTRIBUTE11 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE11,
p_RETURN_ATTRIBUTE15 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE15,
p_RETURN_ATTRIBUTE12 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE12,
p_RETURN_ATTRIBUTE13 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE13,
p_RETURN_ATTRIBUTE14 => l_qte_line_dtl_rec.RETURN_ATTRIBUTE14,
p_RETURN_REASON_CODE => l_qte_line_dtl_rec.RETURN_REASON_CODE,
p_CONFIG_ITEM_ID => l_qte_line_dtl_rec.CONFIG_ITEM_ID,
p_REF_TYPE_CODE => l_qte_line_dtl_rec.REF_TYPE_CODE,
p_REF_LINE_ID => l_qte_line_dtl_rec.REF_LINE_ID,
p_INSTANCE_ID => l_qte_line_dtl_rec.INSTANCE_ID,
p_BOM_SORT_ORDER => l_qte_line_dtl_rec.BOM_SORT_ORDER,
p_CONFIG_DELTA => l_qte_line_dtl_rec.CONFIG_DELTA,
p_CONFIG_INSTANCE_NAME => l_qte_line_dtl_rec.CONFIG_INSTANCE_NAME,
p_OBJECT_VERSION_NUMBER => l_qte_line_dtl_rec.OBJECT_VERSION_NUMBER,
p_top_model_line_id => l_qte_line_dtl_rec.top_model_line_id,
p_ato_line_id => l_qte_line_dtl_rec.ato_line_id,
p_component_sequence_id => l_qte_line_dtl_rec.component_sequence_id
);
ELSIF l_qte_line_dtl_tbl(i).operation_code = 'DELETE' THEN
ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(
p_QUOTE_LINE_DETAIL_ID => l_qte_line_dtl_rec.quote_line_detail_id);
aso_debug_pub.add('Update_Quote_line - after line_details.update ', 1, 'Y');
l_call_update := FND_API.G_FALSE;
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_service_item_flag'||l_service_item_flag,1,'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag, 1, 'N');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_service_item_flag = Y',1,'N');
l_call_update := FND_API.G_TRUE;
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_serviceable_product_flag = Y',
1,'N');
l_call_update := FND_API.G_TRUE;
aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_call_update'||l_call_update,1,'N');
IF l_call_update = FND_API.G_TRUE THEN
ASO_QUOTE_LINES_PVT.service_item_qty_update
(p_qte_line_rec => l_Qte_Line_Rec ,
p_service_item_flag => l_service,
x_return_status => X_return_status
);
aso_debug_pub.add('Update_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '||x_return_status, 1, 'Y');
aso_debug_pub.add('Update_quote_lines, Item not found in inventry',1,'N');
ASO_SALES_CREDITS_PKG.Insert_Row(
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_REQUEST_ID => l_sales_CREDIT_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_sales_CREDIT_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_sales_CREDIT_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_sales_CREDIT_rec.PROGRAM_UPDATE_DATE,
px_SALES_CREDIT_ID => x_SALES_CREDIT_tbl(i).SALES_CREDIT_ID,
p_QUOTE_HEADER_ID => l_sales_CREDIT_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_sales_CREDIT_rec.QUOTE_LINE_ID,
p_PERCENT => l_sales_CREDIT_rec.PERCENT,
p_RESOURCE_ID => l_sales_CREDIT_rec.RESOURCE_ID,
p_RESOURCE_GROUP_ID => l_sales_CREDIT_rec.RESOURCE_GROUP_ID,
p_EMPLOYEE_PERSON_ID => l_sales_CREDIT_rec.EMPLOYEE_PERSON_ID,
p_SALES_CREDIT_TYPE_ID => l_sales_CREDIT_rec.SALES_CREDIT_TYPE_ID,
-- p_SECURITY_GROUP_ID => l_sales_CREDIT_rec.SECURITY_GROUP_ID,
p_ATTRIBUTE_CATEGORY_CODE => l_sales_CREDIT_rec.ATTRIBUTE_CATEGORY_CODE,
p_ATTRIBUTE1 => l_sales_CREDIT_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_sales_CREDIT_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_sales_CREDIT_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_sales_CREDIT_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_sales_CREDIT_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_sales_CREDIT_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_sales_CREDIT_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_sales_CREDIT_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_sales_CREDIT_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_sales_CREDIT_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_sales_CREDIT_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_sales_CREDIT_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_sales_CREDIT_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_sales_CREDIT_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_sales_CREDIT_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_sales_CREDIT_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_sales_CREDIT_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_sales_CREDIT_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_sales_CREDIT_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_sales_CREDIT_rec.ATTRIBUTE20,
p_SYSTEM_ASSIGNED_FLAG => 'N',
p_CREDIT_RULE_ID => l_sales_CREDIT_rec.CREDIT_RULE_ID,
p_OBJECT_VERSION_NUMBER => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);
ELSIF l_sales_credit_rec.operation_code = 'UPDATE' THEN
ASO_SALES_CREDITS_PKG.Update_Row(
p_CREATION_DATE => l_sales_CREDIT_rec.creation_date,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_REQUEST_ID => l_sales_CREDIT_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID=> l_sales_CREDIT_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_sales_CREDIT_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_sales_CREDIT_rec.PROGRAM_UPDATE_DATE,
p_SALES_CREDIT_ID => l_SALES_CREDIT_rec.SALES_CREDIT_ID,
p_QUOTE_HEADER_ID => l_sales_CREDIT_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_sales_CREDIT_rec.QUOTE_LINE_ID,
p_PERCENT => l_sales_CREDIT_rec.PERCENT,
p_RESOURCE_ID => l_sales_CREDIT_rec.RESOURCE_ID,
p_RESOURCE_GROUP_ID => l_sales_CREDIT_rec.RESOURCE_GROUP_ID,
p_EMPLOYEE_PERSON_ID => l_sales_CREDIT_rec.EMPLOYEE_PERSON_ID,
p_SALES_CREDIT_TYPE_ID => l_sales_CREDIT_rec.SALES_CREDIT_TYPE_ID,
-- p_SECURITY_GROUP_ID => l_sales_CREDIT_rec.SECURITY_GROUP_ID,
p_ATTRIBUTE_CATEGORY_CODE => l_sales_CREDIT_rec.ATTRIBUTE_CATEGORY_CODE,
p_ATTRIBUTE1 => l_sales_CREDIT_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_sales_CREDIT_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_sales_CREDIT_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_sales_CREDIT_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_sales_CREDIT_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_sales_CREDIT_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_sales_CREDIT_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_sales_CREDIT_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_sales_CREDIT_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_sales_CREDIT_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_sales_CREDIT_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_sales_CREDIT_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_sales_CREDIT_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_sales_CREDIT_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_sales_CREDIT_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_sales_CREDIT_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_sales_CREDIT_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_sales_CREDIT_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_sales_CREDIT_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_sales_CREDIT_rec.ATTRIBUTE20,
p_SYSTEM_ASSIGNED_FLAG => 'N',
p_CREDIT_RULE_ID => l_sales_CREDIT_rec.CREDIT_RULE_ID,
p_OBJECT_VERSION_NUMBER => l_sales_CREDIT_rec.OBJECT_VERSION_NUMBER);
ELSIF l_sales_credit_rec.operation_code = 'DELETE' THEN
ASO_SALES_CREDITS_PKG.Delete_Row(
p_SALES_CREDIT_ID => l_SALES_CREDIT_rec.SALES_CREDIT_ID);
ASO_PRICE_ATTRIBUTES_PKG.Insert_Row(
px_PRICE_ATTRIBUTE_ID => x_price_attributes_tbl(i).price_attribute_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_QUOTE_LINE_ID => l_price_attributes_rec.quote_line_id,
p_FLEX_TITLE => l_price_attributes_rec.flex_title,
p_PRICING_CONTEXT => l_price_attributes_rec.pricing_context,
p_PRICING_ATTRIBUTE1 => l_price_attributes_rec.PRICING_ATTRIBUTE1,
p_PRICING_ATTRIBUTE2 => l_price_attributes_rec.PRICING_ATTRIBUTE2,
p_PRICING_ATTRIBUTE3 => l_price_attributes_rec.PRICING_ATTRIBUTE3,
p_PRICING_ATTRIBUTE4 => l_price_attributes_rec.PRICING_ATTRIBUTE4,
p_PRICING_ATTRIBUTE5 => l_price_attributes_rec.PRICING_ATTRIBUTE5,
p_PRICING_ATTRIBUTE6 => l_price_attributes_rec.PRICING_ATTRIBUTE6,
p_PRICING_ATTRIBUTE7 => l_price_attributes_rec.PRICING_ATTRIBUTE7,
p_PRICING_ATTRIBUTE8 => l_price_attributes_rec.PRICING_ATTRIBUTE8,
p_PRICING_ATTRIBUTE9 => l_price_attributes_rec.PRICING_ATTRIBUTE9,
p_PRICING_ATTRIBUTE10 => l_price_attributes_rec.PRICING_ATTRIBUTE10,
p_PRICING_ATTRIBUTE11 => l_price_attributes_rec.PRICING_ATTRIBUTE11,
p_PRICING_ATTRIBUTE12 => l_price_attributes_rec.PRICING_ATTRIBUTE12,
p_PRICING_ATTRIBUTE13 => l_price_attributes_rec.PRICING_ATTRIBUTE13,
p_PRICING_ATTRIBUTE14 => l_price_attributes_rec.PRICING_ATTRIBUTE14,
p_PRICING_ATTRIBUTE15 => l_price_attributes_rec.PRICING_ATTRIBUTE15,
p_PRICING_ATTRIBUTE16 => l_price_attributes_rec.PRICING_ATTRIBUTE16,
p_PRICING_ATTRIBUTE17 => l_price_attributes_rec.PRICING_ATTRIBUTE17,
p_PRICING_ATTRIBUTE18 => l_price_attributes_rec.PRICING_ATTRIBUTE18,
p_PRICING_ATTRIBUTE19 => l_price_attributes_rec.PRICING_ATTRIBUTE19,
p_PRICING_ATTRIBUTE20 => l_price_attributes_rec.PRICING_ATTRIBUTE20,
p_PRICING_ATTRIBUTE21 => l_price_attributes_rec.PRICING_ATTRIBUTE21,
p_PRICING_ATTRIBUTE22 => l_price_attributes_rec.PRICING_ATTRIBUTE22,
p_PRICING_ATTRIBUTE23 => l_price_attributes_rec.PRICING_ATTRIBUTE23,
p_PRICING_ATTRIBUTE24 => l_price_attributes_rec.PRICING_ATTRIBUTE24,
p_PRICING_ATTRIBUTE25 => l_price_attributes_rec.PRICING_ATTRIBUTE25,
p_PRICING_ATTRIBUTE26 => l_price_attributes_rec.PRICING_ATTRIBUTE26,
p_PRICING_ATTRIBUTE27 => l_price_attributes_rec.PRICING_ATTRIBUTE27,
p_PRICING_ATTRIBUTE28 => l_price_attributes_rec.PRICING_ATTRIBUTE28,
p_PRICING_ATTRIBUTE29 => l_price_attributes_rec.PRICING_ATTRIBUTE29,
p_PRICING_ATTRIBUTE30 => l_price_attributes_rec.PRICING_ATTRIBUTE30,
p_PRICING_ATTRIBUTE31 => l_price_attributes_rec.PRICING_ATTRIBUTE31,
p_PRICING_ATTRIBUTE32 => l_price_attributes_rec.PRICING_ATTRIBUTE32,
p_PRICING_ATTRIBUTE33 => l_price_attributes_rec.PRICING_ATTRIBUTE33,
p_PRICING_ATTRIBUTE34 => l_price_attributes_rec.PRICING_ATTRIBUTE34,
p_PRICING_ATTRIBUTE35 => l_price_attributes_rec.PRICING_ATTRIBUTE35,
p_PRICING_ATTRIBUTE36 => l_price_attributes_rec.PRICING_ATTRIBUTE36,
p_PRICING_ATTRIBUTE37 => l_price_attributes_rec.PRICING_ATTRIBUTE37,
p_PRICING_ATTRIBUTE38 => l_price_attributes_rec.PRICING_ATTRIBUTE38,
p_PRICING_ATTRIBUTE39 => l_price_attributes_rec.PRICING_ATTRIBUTE39,
p_PRICING_ATTRIBUTE40 => l_price_attributes_rec.PRICING_ATTRIBUTE40,
p_PRICING_ATTRIBUTE41 => l_price_attributes_rec.PRICING_ATTRIBUTE41,
p_PRICING_ATTRIBUTE42 => l_price_attributes_rec.PRICING_ATTRIBUTE42,
p_PRICING_ATTRIBUTE43 => l_price_attributes_rec.PRICING_ATTRIBUTE43,
p_PRICING_ATTRIBUTE44 => l_price_attributes_rec.PRICING_ATTRIBUTE44,
p_PRICING_ATTRIBUTE45 => l_price_attributes_rec.PRICING_ATTRIBUTE45,
p_PRICING_ATTRIBUTE46 => l_price_attributes_rec.PRICING_ATTRIBUTE46,
p_PRICING_ATTRIBUTE47 => l_price_attributes_rec.PRICING_ATTRIBUTE47,
p_PRICING_ATTRIBUTE48 => l_price_attributes_rec.PRICING_ATTRIBUTE48,
p_PRICING_ATTRIBUTE49 => l_price_attributes_rec.PRICING_ATTRIBUTE49,
p_PRICING_ATTRIBUTE50 => l_price_attributes_rec.PRICING_ATTRIBUTE50,
p_PRICING_ATTRIBUTE51 => l_price_attributes_rec.PRICING_ATTRIBUTE51,
p_PRICING_ATTRIBUTE52 => l_price_attributes_rec.PRICING_ATTRIBUTE52,
p_PRICING_ATTRIBUTE53 => l_price_attributes_rec.PRICING_ATTRIBUTE53,
p_PRICING_ATTRIBUTE54 => l_price_attributes_rec.PRICING_ATTRIBUTE54,
p_PRICING_ATTRIBUTE55 => l_price_attributes_rec.PRICING_ATTRIBUTE55,
p_PRICING_ATTRIBUTE56 => l_price_attributes_rec.PRICING_ATTRIBUTE56,
p_PRICING_ATTRIBUTE57 => l_price_attributes_rec.PRICING_ATTRIBUTE57,
p_PRICING_ATTRIBUTE58 => l_price_attributes_rec.PRICING_ATTRIBUTE58,
p_PRICING_ATTRIBUTE59 => l_price_attributes_rec.PRICING_ATTRIBUTE59,
p_PRICING_ATTRIBUTE60 => l_price_attributes_rec.PRICING_ATTRIBUTE60,
p_PRICING_ATTRIBUTE61 => l_price_attributes_rec.PRICING_ATTRIBUTE61,
p_PRICING_ATTRIBUTE62 => l_price_attributes_rec.PRICING_ATTRIBUTE62,
p_PRICING_ATTRIBUTE63 => l_price_attributes_rec.PRICING_ATTRIBUTE63,
p_PRICING_ATTRIBUTE64 => l_price_attributes_rec.PRICING_ATTRIBUTE64,
p_PRICING_ATTRIBUTE65 => l_price_attributes_rec.PRICING_ATTRIBUTE65,
p_PRICING_ATTRIBUTE66 => l_price_attributes_rec.PRICING_ATTRIBUTE66,
p_PRICING_ATTRIBUTE67 => l_price_attributes_rec.PRICING_ATTRIBUTE67,
p_PRICING_ATTRIBUTE68 => l_price_attributes_rec.PRICING_ATTRIBUTE68,
p_PRICING_ATTRIBUTE69 => l_price_attributes_rec.PRICING_ATTRIBUTE69,
p_PRICING_ATTRIBUTE70 => l_price_attributes_rec.PRICING_ATTRIBUTE70,
p_PRICING_ATTRIBUTE71 => l_price_attributes_rec.PRICING_ATTRIBUTE71,
p_PRICING_ATTRIBUTE72 => l_price_attributes_rec.PRICING_ATTRIBUTE72,
p_PRICING_ATTRIBUTE73 => l_price_attributes_rec.PRICING_ATTRIBUTE73,
p_PRICING_ATTRIBUTE74 => l_price_attributes_rec.PRICING_ATTRIBUTE74,
p_PRICING_ATTRIBUTE75 => l_price_attributes_rec.PRICING_ATTRIBUTE75,
p_PRICING_ATTRIBUTE76 => l_price_attributes_rec.PRICING_ATTRIBUTE76,
p_PRICING_ATTRIBUTE77 => l_price_attributes_rec.PRICING_ATTRIBUTE77,
p_PRICING_ATTRIBUTE78 => l_price_attributes_rec.PRICING_ATTRIBUTE78,
p_PRICING_ATTRIBUTE79 => l_price_attributes_rec.PRICING_ATTRIBUTE79,
p_PRICING_ATTRIBUTE80 => l_price_attributes_rec.PRICING_ATTRIBUTE80,
p_PRICING_ATTRIBUTE81 => l_price_attributes_rec.PRICING_ATTRIBUTE81,
p_PRICING_ATTRIBUTE82 => l_price_attributes_rec.PRICING_ATTRIBUTE82,
p_PRICING_ATTRIBUTE83 => l_price_attributes_rec.PRICING_ATTRIBUTE83,
p_PRICING_ATTRIBUTE84 => l_price_attributes_rec.PRICING_ATTRIBUTE84,
p_PRICING_ATTRIBUTE85 => l_price_attributes_rec.PRICING_ATTRIBUTE85,
p_PRICING_ATTRIBUTE86 => l_price_attributes_rec.PRICING_ATTRIBUTE86,
p_PRICING_ATTRIBUTE87 => l_price_attributes_rec.PRICING_ATTRIBUTE87,
p_PRICING_ATTRIBUTE88 => l_price_attributes_rec.PRICING_ATTRIBUTE88,
p_PRICING_ATTRIBUTE89 => l_price_attributes_rec.PRICING_ATTRIBUTE89,
p_PRICING_ATTRIBUTE90 => l_price_attributes_rec.PRICING_ATTRIBUTE90,
p_PRICING_ATTRIBUTE91 => l_price_attributes_rec.PRICING_ATTRIBUTE91,
p_PRICING_ATTRIBUTE92 => l_price_attributes_rec.PRICING_ATTRIBUTE92,
p_PRICING_ATTRIBUTE93 => l_price_attributes_rec.PRICING_ATTRIBUTE93,
p_PRICING_ATTRIBUTE94 => l_price_attributes_rec.PRICING_ATTRIBUTE94,
p_PRICING_ATTRIBUTE95 => l_price_attributes_rec.PRICING_ATTRIBUTE95,
p_PRICING_ATTRIBUTE96 => l_price_attributes_rec.PRICING_ATTRIBUTE96,
p_PRICING_ATTRIBUTE97 => l_price_attributes_rec.PRICING_ATTRIBUTE97,
p_PRICING_ATTRIBUTE98 => l_price_attributes_rec.PRICING_ATTRIBUTE98,
p_PRICING_ATTRIBUTE99 => l_price_attributes_rec.PRICING_ATTRIBUTE99,
p_PRICING_ATTRIBUTE100 => l_price_attributes_rec.PRICING_ATTRIBUTE100,
p_CONTEXT => l_price_attributes_rec.CONTEXT,
p_ATTRIBUTE1 => l_price_attributes_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_price_attributes_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_price_attributes_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_price_attributes_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_price_attributes_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_price_attributes_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_price_attributes_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_price_attributes_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_price_attributes_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_price_attributes_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_price_attributes_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_price_attributes_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_price_attributes_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_price_attributes_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_price_attributes_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_price_attributes_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_price_attributes_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_price_attributes_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_price_attributes_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_price_attributes_rec.ATTRIBUTE20,
p_OBJECT_VERSION_NUMBER => l_price_attributes_rec.OBJECT_VERSION_NUMBER
);
ELSIF l_price_attributes_rec.operation_code = 'UPDATE' THEN
ASO_PRICE_ATTRIBUTES_PKG.Update_Row(
p_PRICE_ATTRIBUTE_ID => l_price_attributes_rec.price_attribute_id,
p_CREATION_DATE => l_price_attributes_rec.creation_date,
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_QUOTE_LINE_ID => l_price_attributes_rec.quote_line_id,
p_FLEX_TITLE => l_price_attributes_rec.flex_title,
p_PRICING_CONTEXT => l_price_attributes_rec.pricing_context,
p_PRICING_ATTRIBUTE1 => l_price_attributes_rec.PRICING_ATTRIBUTE1,
p_PRICING_ATTRIBUTE2 => l_price_attributes_rec.PRICING_ATTRIBUTE2,
p_PRICING_ATTRIBUTE3 => l_price_attributes_rec.PRICING_ATTRIBUTE3,
p_PRICING_ATTRIBUTE4 => l_price_attributes_rec.PRICING_ATTRIBUTE4,
p_PRICING_ATTRIBUTE5 => l_price_attributes_rec.PRICING_ATTRIBUTE5,
p_PRICING_ATTRIBUTE6 => l_price_attributes_rec.PRICING_ATTRIBUTE6,
p_PRICING_ATTRIBUTE7 => l_price_attributes_rec.PRICING_ATTRIBUTE7,
p_PRICING_ATTRIBUTE8 => l_price_attributes_rec.PRICING_ATTRIBUTE8,
p_PRICING_ATTRIBUTE9 => l_price_attributes_rec.PRICING_ATTRIBUTE9,
p_PRICING_ATTRIBUTE10 => l_price_attributes_rec.PRICING_ATTRIBUTE10,
p_PRICING_ATTRIBUTE11 => l_price_attributes_rec.PRICING_ATTRIBUTE11,
p_PRICING_ATTRIBUTE12 => l_price_attributes_rec.PRICING_ATTRIBUTE12,
p_PRICING_ATTRIBUTE13 => l_price_attributes_rec.PRICING_ATTRIBUTE13,
p_PRICING_ATTRIBUTE14 => l_price_attributes_rec.PRICING_ATTRIBUTE14,
p_PRICING_ATTRIBUTE15 => l_price_attributes_rec.PRICING_ATTRIBUTE15,
p_PRICING_ATTRIBUTE16 => l_price_attributes_rec.PRICING_ATTRIBUTE16,
p_PRICING_ATTRIBUTE17 => l_price_attributes_rec.PRICING_ATTRIBUTE17,
p_PRICING_ATTRIBUTE18 => l_price_attributes_rec.PRICING_ATTRIBUTE18,
p_PRICING_ATTRIBUTE19 => l_price_attributes_rec.PRICING_ATTRIBUTE19,
p_PRICING_ATTRIBUTE20 => l_price_attributes_rec.PRICING_ATTRIBUTE20,
p_PRICING_ATTRIBUTE21 => l_price_attributes_rec.PRICING_ATTRIBUTE21,
p_PRICING_ATTRIBUTE22 => l_price_attributes_rec.PRICING_ATTRIBUTE22,
p_PRICING_ATTRIBUTE23 => l_price_attributes_rec.PRICING_ATTRIBUTE23,
p_PRICING_ATTRIBUTE24 => l_price_attributes_rec.PRICING_ATTRIBUTE24,
p_PRICING_ATTRIBUTE25 => l_price_attributes_rec.PRICING_ATTRIBUTE25,
p_PRICING_ATTRIBUTE26 => l_price_attributes_rec.PRICING_ATTRIBUTE26,
p_PRICING_ATTRIBUTE27 => l_price_attributes_rec.PRICING_ATTRIBUTE27,
p_PRICING_ATTRIBUTE28 => l_price_attributes_rec.PRICING_ATTRIBUTE28,
p_PRICING_ATTRIBUTE29 => l_price_attributes_rec.PRICING_ATTRIBUTE29,
p_PRICING_ATTRIBUTE30 => l_price_attributes_rec.PRICING_ATTRIBUTE30,
p_PRICING_ATTRIBUTE31 => l_price_attributes_rec.PRICING_ATTRIBUTE31,
p_PRICING_ATTRIBUTE32 => l_price_attributes_rec.PRICING_ATTRIBUTE32,
p_PRICING_ATTRIBUTE33 => l_price_attributes_rec.PRICING_ATTRIBUTE33,
p_PRICING_ATTRIBUTE34 => l_price_attributes_rec.PRICING_ATTRIBUTE34,
p_PRICING_ATTRIBUTE35 => l_price_attributes_rec.PRICING_ATTRIBUTE35,
p_PRICING_ATTRIBUTE36 => l_price_attributes_rec.PRICING_ATTRIBUTE36,
p_PRICING_ATTRIBUTE37 => l_price_attributes_rec.PRICING_ATTRIBUTE37,
p_PRICING_ATTRIBUTE38 => l_price_attributes_rec.PRICING_ATTRIBUTE38,
p_PRICING_ATTRIBUTE39 => l_price_attributes_rec.PRICING_ATTRIBUTE39,
p_PRICING_ATTRIBUTE40 => l_price_attributes_rec.PRICING_ATTRIBUTE40,
p_PRICING_ATTRIBUTE41 => l_price_attributes_rec.PRICING_ATTRIBUTE41,
p_PRICING_ATTRIBUTE42 => l_price_attributes_rec.PRICING_ATTRIBUTE42,
p_PRICING_ATTRIBUTE43 => l_price_attributes_rec.PRICING_ATTRIBUTE43,
p_PRICING_ATTRIBUTE44 => l_price_attributes_rec.PRICING_ATTRIBUTE44,
p_PRICING_ATTRIBUTE45 => l_price_attributes_rec.PRICING_ATTRIBUTE45,
p_PRICING_ATTRIBUTE46 => l_price_attributes_rec.PRICING_ATTRIBUTE46,
p_PRICING_ATTRIBUTE47 => l_price_attributes_rec.PRICING_ATTRIBUTE47,
p_PRICING_ATTRIBUTE48 => l_price_attributes_rec.PRICING_ATTRIBUTE48,
p_PRICING_ATTRIBUTE49 => l_price_attributes_rec.PRICING_ATTRIBUTE49,
p_PRICING_ATTRIBUTE50 => l_price_attributes_rec.PRICING_ATTRIBUTE50,
p_PRICING_ATTRIBUTE51 => l_price_attributes_rec.PRICING_ATTRIBUTE51,
p_PRICING_ATTRIBUTE52 => l_price_attributes_rec.PRICING_ATTRIBUTE52,
p_PRICING_ATTRIBUTE53 => l_price_attributes_rec.PRICING_ATTRIBUTE53,
p_PRICING_ATTRIBUTE54 => l_price_attributes_rec.PRICING_ATTRIBUTE54,
p_PRICING_ATTRIBUTE55 => l_price_attributes_rec.PRICING_ATTRIBUTE55,
p_PRICING_ATTRIBUTE56 => l_price_attributes_rec.PRICING_ATTRIBUTE56,
p_PRICING_ATTRIBUTE57 => l_price_attributes_rec.PRICING_ATTRIBUTE57,
p_PRICING_ATTRIBUTE58 => l_price_attributes_rec.PRICING_ATTRIBUTE58,
p_PRICING_ATTRIBUTE59 => l_price_attributes_rec.PRICING_ATTRIBUTE59,
p_PRICING_ATTRIBUTE60 => l_price_attributes_rec.PRICING_ATTRIBUTE60,
p_PRICING_ATTRIBUTE61 => l_price_attributes_rec.PRICING_ATTRIBUTE61,
p_PRICING_ATTRIBUTE62 => l_price_attributes_rec.PRICING_ATTRIBUTE62,
p_PRICING_ATTRIBUTE63 => l_price_attributes_rec.PRICING_ATTRIBUTE63,
p_PRICING_ATTRIBUTE64 => l_price_attributes_rec.PRICING_ATTRIBUTE64,
p_PRICING_ATTRIBUTE65 => l_price_attributes_rec.PRICING_ATTRIBUTE65,
p_PRICING_ATTRIBUTE66 => l_price_attributes_rec.PRICING_ATTRIBUTE66,
p_PRICING_ATTRIBUTE67 => l_price_attributes_rec.PRICING_ATTRIBUTE67,
p_PRICING_ATTRIBUTE68 => l_price_attributes_rec.PRICING_ATTRIBUTE68,
p_PRICING_ATTRIBUTE69 => l_price_attributes_rec.PRICING_ATTRIBUTE69,
p_PRICING_ATTRIBUTE70 => l_price_attributes_rec.PRICING_ATTRIBUTE70,
p_PRICING_ATTRIBUTE71 => l_price_attributes_rec.PRICING_ATTRIBUTE71,
p_PRICING_ATTRIBUTE72 => l_price_attributes_rec.PRICING_ATTRIBUTE72,
p_PRICING_ATTRIBUTE73 => l_price_attributes_rec.PRICING_ATTRIBUTE73,
p_PRICING_ATTRIBUTE74 => l_price_attributes_rec.PRICING_ATTRIBUTE74,
p_PRICING_ATTRIBUTE75 => l_price_attributes_rec.PRICING_ATTRIBUTE75,
p_PRICING_ATTRIBUTE76 => l_price_attributes_rec.PRICING_ATTRIBUTE76,
p_PRICING_ATTRIBUTE77 => l_price_attributes_rec.PRICING_ATTRIBUTE77,
p_PRICING_ATTRIBUTE78 => l_price_attributes_rec.PRICING_ATTRIBUTE78,
p_PRICING_ATTRIBUTE79 => l_price_attributes_rec.PRICING_ATTRIBUTE79,
p_PRICING_ATTRIBUTE80 => l_price_attributes_rec.PRICING_ATTRIBUTE80,
p_PRICING_ATTRIBUTE81 => l_price_attributes_rec.PRICING_ATTRIBUTE81,
p_PRICING_ATTRIBUTE82 => l_price_attributes_rec.PRICING_ATTRIBUTE82,
p_PRICING_ATTRIBUTE83 => l_price_attributes_rec.PRICING_ATTRIBUTE83,
p_PRICING_ATTRIBUTE84 => l_price_attributes_rec.PRICING_ATTRIBUTE84,
p_PRICING_ATTRIBUTE85 => l_price_attributes_rec.PRICING_ATTRIBUTE85,
p_PRICING_ATTRIBUTE86 => l_price_attributes_rec.PRICING_ATTRIBUTE86,
p_PRICING_ATTRIBUTE87 => l_price_attributes_rec.PRICING_ATTRIBUTE87,
p_PRICING_ATTRIBUTE88 => l_price_attributes_rec.PRICING_ATTRIBUTE88,
p_PRICING_ATTRIBUTE89 => l_price_attributes_rec.PRICING_ATTRIBUTE89,
p_PRICING_ATTRIBUTE90 => l_price_attributes_rec.PRICING_ATTRIBUTE90,
p_PRICING_ATTRIBUTE91 => l_price_attributes_rec.PRICING_ATTRIBUTE91,
p_PRICING_ATTRIBUTE92 => l_price_attributes_rec.PRICING_ATTRIBUTE92,
p_PRICING_ATTRIBUTE93 => l_price_attributes_rec.PRICING_ATTRIBUTE93,
p_PRICING_ATTRIBUTE94 => l_price_attributes_rec.PRICING_ATTRIBUTE94,
p_PRICING_ATTRIBUTE95 => l_price_attributes_rec.PRICING_ATTRIBUTE95,
p_PRICING_ATTRIBUTE96 => l_price_attributes_rec.PRICING_ATTRIBUTE96,
p_PRICING_ATTRIBUTE97 => l_price_attributes_rec.PRICING_ATTRIBUTE97,
p_PRICING_ATTRIBUTE98 => l_price_attributes_rec.PRICING_ATTRIBUTE98,
p_PRICING_ATTRIBUTE99 => l_price_attributes_rec.PRICING_ATTRIBUTE99,
p_PRICING_ATTRIBUTE100 => l_price_attributes_rec.PRICING_ATTRIBUTE100,
p_CONTEXT => l_price_attributes_rec.CONTEXT,
p_ATTRIBUTE1 => l_price_attributes_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_price_attributes_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_price_attributes_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_price_attributes_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_price_attributes_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_price_attributes_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_price_attributes_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_price_attributes_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_price_attributes_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_price_attributes_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_price_attributes_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_price_attributes_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_price_attributes_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_price_attributes_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_price_attributes_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_price_attributes_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_price_attributes_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_price_attributes_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_price_attributes_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_price_attributes_rec.ATTRIBUTE20,
p_OBJECT_VERSION_NUMBER => l_price_attributes_rec.OBJECT_VERSION_NUMBER
);
aso_debug_pub.add('Update_Quote_line - after line_price_attribs.update ', 1, 'N');
aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).ship_method_code'||l_shipment_tbl(1).ship_method_code, 1, 'Y');
aso_debug_pub.add('Before ASO_SHIPMENTS_PKG.insert_rows Quote Line- l_shipment_tbl(1).freight_terms_code'||l_shipment_tbl(1).freight_terms_code, 1, 'Y');
ASO_SHIPMENTS_PKG.Insert_Row(
px_SHIPMENT_ID => x_shipment_tbl(i).SHIPMENT_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_shipment_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_shipment_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_shipment_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_shipment_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_shipment_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_shipment_rec.QUOTE_LINE_ID,
p_PROMISE_DATE => l_shipment_rec.PROMISE_DATE,
p_REQUEST_DATE => l_shipment_rec.REQUEST_DATE,
p_SCHEDULE_SHIP_DATE => l_shipment_rec.SCHEDULE_SHIP_DATE,
p_SHIP_TO_PARTY_SITE_ID => l_shipment_rec.SHIP_TO_PARTY_SITE_ID,
p_SHIP_TO_PARTY_ID => l_shipment_rec.SHIP_TO_PARTY_ID,
p_SHIP_TO_CUST_ACCOUNT_ID => l_shipment_rec.SHIP_TO_CUST_ACCOUNT_ID ,
p_SHIP_PARTIAL_FLAG => l_shipment_rec.SHIP_PARTIAL_FLAG,
p_SHIP_SET_ID => l_shipment_rec.SHIP_SET_ID,
p_SHIP_METHOD_CODE => l_shipment_rec.SHIP_METHOD_CODE,
p_FREIGHT_TERMS_CODE=> l_shipment_rec.FREIGHT_TERMS_CODE,
p_FREIGHT_CARRIER_CODE => l_shipment_rec.FREIGHT_CARRIER_CODE,
p_FOB_CODE => l_shipment_rec.FOB_CODE,
p_SHIPPING_INSTRUCTIONS => l_shipment_rec.SHIPPING_INSTRUCTIONS,
p_PACKING_INSTRUCTIONS => l_shipment_rec.PACKING_INSTRUCTIONS,
p_SHIPMENT_PRIORITY_CODE => l_shipment_rec.SHIPMENT_PRIORITY_CODE,
p_SHIP_QUOTE_PRICE => l_shipment_rec.SHIP_QUOTE_PRICE,
p_QUANTITY => l_shipment_rec.QUANTITY,
p_RESERVED_QUANTITY => l_shipment_rec.RESERVED_QUANTITY,
p_RESERVATION_ID => l_shipment_rec.RESERVATION_ID,
p_ORDER_LINE_ID => l_shipment_rec.ORDER_LINE_ID,
p_ATTRIBUTE_CATEGORY => l_shipment_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_shipment_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_shipment_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_shipment_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_shipment_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_shipment_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_shipment_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_shipment_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_shipment_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_shipment_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_shipment_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_shipment_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_shipment_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_shipment_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_shipment_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_shipment_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_shipment_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_shipment_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_shipment_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_shipment_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_shipment_rec.ATTRIBUTE20,
p_SHIP_FROM_ORG_ID => l_shipment_rec.SHIP_FROM_ORG_ID,
p_SHIP_TO_CUST_PARTY_ID => l_shipment_rec.SHIP_TO_CUST_PARTY_ID,
p_SHIP_METHOD_CODE_FROM => l_shipment_rec.SHIP_METHOD_CODE_FROM,
p_FREIGHT_TERMS_CODE_FROM => l_shipment_rec.FREIGHT_TERMS_CODE_FROM,
p_OBJECT_VERSION_NUMBER => l_shipment_rec.OBJECT_VERSION_NUMBER,
p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
p_DEMAND_CLASS_CODE => l_shipment_rec.DEMAND_CLASS_CODE
);
ELSIF l_shipment_rec.operation_code = 'UPDATE' THEN
IF l_shipment_rec.ship_method_code = fnd_api.g_miss_char THEN
FOR l_ship_db_rec IN c_db_ship_freight_terms(l_shipment_rec.shipment_id) LOOP
IF l_ship_db_rec.ship_method_code_from is null THEN
l_shipment_rec.ship_method_code_from := l_ship_db_rec.ship_method_code;
ASO_SHIPMENTS_PKG.Update_Row(
p_SHIPMENT_ID => l_shipment_tbl(i).SHIPMENT_ID,
p_CREATION_DATE => l_shipment_tbl(i).creation_date,
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_shipment_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_shipment_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_shipment_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_shipment_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_shipment_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_shipment_rec.QUOTE_LINE_ID,
p_PROMISE_DATE => l_shipment_rec.PROMISE_DATE,
p_REQUEST_DATE => l_shipment_rec.REQUEST_DATE,
p_SCHEDULE_SHIP_DATE=> l_shipment_rec.SCHEDULE_SHIP_DATE,
p_SHIP_TO_PARTY_SITE_ID => l_shipment_rec.SHIP_TO_PARTY_SITE_ID,
p_SHIP_TO_PARTY_ID => l_shipment_rec.SHIP_TO_PARTY_ID,
p_SHIP_TO_CUST_ACCOUNT_ID => l_shipment_rec.SHIP_TO_CUST_ACCOUNT_ID ,
p_SHIP_PARTIAL_FLAG => l_shipment_rec.SHIP_PARTIAL_FLAG,
p_SHIP_SET_ID => l_shipment_rec.SHIP_SET_ID,
p_SHIP_METHOD_CODE => l_shipment_rec.SHIP_METHOD_CODE,
p_FREIGHT_TERMS_CODE=> l_shipment_rec.FREIGHT_TERMS_CODE,
p_FREIGHT_CARRIER_CODE => l_shipment_rec.FREIGHT_CARRIER_CODE,
p_FOB_CODE => l_shipment_rec.FOB_CODE,
p_SHIPPING_INSTRUCTIONS => l_shipment_rec.SHIPPING_INSTRUCTIONS,
p_PACKING_INSTRUCTIONS => l_shipment_rec.PACKING_INSTRUCTIONS,
p_SHIPMENT_PRIORITY_CODE => l_shipment_rec.SHIPMENT_PRIORITY_CODE,
p_SHIP_QUOTE_PRICE => l_shipment_rec.SHIP_QUOTE_PRICE,
p_QUANTITY => l_shipment_rec.QUANTITY,
p_RESERVED_QUANTITY => l_shipment_rec.RESERVED_QUANTITY,
p_RESERVATION_ID => l_shipment_rec.RESERVATION_ID,
p_ORDER_LINE_ID => l_shipment_rec.ORDER_LINE_ID,
p_ATTRIBUTE_CATEGORY => l_shipment_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_shipment_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_shipment_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_shipment_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_shipment_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_shipment_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_shipment_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_shipment_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_shipment_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_shipment_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_shipment_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_shipment_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_shipment_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_shipment_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_shipment_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_shipment_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_shipment_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_shipment_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_shipment_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_shipment_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_shipment_rec.ATTRIBUTE20,
p_SHIP_FROM_ORG_ID =>l_shipment_rec.SHIP_FROM_ORG_ID,
p_SHIP_TO_CUST_PARTY_ID => l_shipment_rec.SHIP_TO_CUST_PARTY_ID,
p_SHIP_METHOD_CODE_FROM => l_shipment_rec.SHIP_METHOD_CODE_FROM,
p_FREIGHT_TERMS_CODE_FROM => l_shipment_rec.FREIGHT_TERMS_CODE_FROM,
p_OBJECT_VERSION_NUMBER => l_shipment_rec.OBJECT_VERSION_NUMBER,
p_REQUEST_DATE_TYPE => l_shipment_rec.REQUEST_DATE_TYPE,
p_DEMAND_CLASS_CODE => l_shipment_rec.DEMAND_CLASS_CODE
);
ELSIF l_shipment_rec.operation_code = 'DELETE' THEN
OPEN C_ship_partial(l_qte_line_rec.QUOTE_LINE_ID);
FND_MESSAGE.Set_Name('ASO', 'DELETE_SHIPMENT');
ASO_SHIPMENTS_PKG.Delete_Row(
p_SHIPMENT_ID => l_shipment_tbl(i).SHIPMENT_ID);
ASO_FREIGHT_CHARGES_PKG.Insert_Row(
px_FREIGHT_CHARGE_ID => x_FREIGHT_CHARGE_tbl(i).freight_charge_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_freight_charge_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID
=> l_freight_charge_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_freight_charge_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_freight_charge_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_SHIPMENT_ID => l_freight_charge_rec.QUOTE_SHIPMENT_ID,
p_FREIGHT_CHARGE_TYPE_ID
=> l_freight_charge_rec.FREIGHT_CHARGE_TYPE_ID,
p_CHARGE_AMOUNT => l_freight_charge_rec.CHARGE_AMOUNT,
p_ATTRIBUTE_CATEGORY => l_freight_charge_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_freight_charge_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_freight_charge_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_freight_charge_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_freight_charge_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_freight_charge_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_freight_charge_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_freight_charge_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_freight_charge_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_freight_charge_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_freight_charge_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_freight_charge_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_freight_charge_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_freight_charge_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_freight_charge_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_freight_charge_rec.ATTRIBUTE15
);
ELSIF l_freight_charge_rec.operation_code = 'UPDATE' THEN
ASO_FREIGHT_CHARGES_PKG.Update_Row(
p_FREIGHT_CHARGE_ID => p_FREIGHT_CHARGE_tbl(i).freight_charge_id,
p_CREATION_DATE => l_freight_charge_rec.creation_date,
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_freight_charge_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID
=> l_freight_charge_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_freight_charge_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_freight_charge_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_SHIPMENT_ID => l_freight_charge_rec.QUOTE_SHIPMENT_ID,
p_FREIGHT_CHARGE_TYPE_ID
=> l_freight_charge_rec.FREIGHT_CHARGE_TYPE_ID,
p_CHARGE_AMOUNT => l_freight_charge_rec.CHARGE_AMOUNT,
p_ATTRIBUTE_CATEGORY => l_freight_charge_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_freight_charge_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_freight_charge_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_freight_charge_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_freight_charge_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_freight_charge_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_freight_charge_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_freight_charge_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_freight_charge_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_freight_charge_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_freight_charge_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_freight_charge_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_freight_charge_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_freight_charge_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_freight_charge_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_freight_charge_rec.ATTRIBUTE15);
ELSIF l_freight_charge_rec.operation_code = 'DELETE' THEN
ASO_FREIGHT_CHARGES_PKG.delete_Row(
p_FREIGHT_CHARGE_ID => p_FREIGHT_CHARGE_tbl(i).freight_charge_id);
ASO_TAX_DETAILS_PKG.Insert_Row(
px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_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_tax_detail_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_tax_detail_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_tax_detail_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_tax_detail_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_tax_detail_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_tax_detail_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_tax_detail_rec.QUOTE_SHIPMENT_ID,
p_ORIG_TAX_CODE => l_tax_detail_rec.ORIG_TAX_CODE,
p_TAX_CODE => l_tax_detail_rec.TAX_CODE,
p_TAX_RATE => l_tax_detail_rec.TAX_RATE,
p_TAX_DATE => l_tax_detail_rec.TAX_DATE,
p_TAX_AMOUNT => l_tax_detail_rec.TAX_AMOUNT,
p_TAX_EXEMPT_FLAG => l_tax_detail_rec.TAX_EXEMPT_FLAG,
p_TAX_EXEMPT_NUMBER => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
p_TAX_EXEMPT_REASON_CODE =>l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
p_ATTRIBUTE_CATEGORY => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_tax_detail_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_tax_detail_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_tax_detail_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_tax_detail_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_tax_detail_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_tax_detail_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_tax_detail_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_tax_detail_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_tax_detail_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_tax_detail_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_tax_detail_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_tax_detail_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_tax_detail_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_tax_detail_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_tax_detail_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_tax_detail_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_tax_detail_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_tax_detail_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_tax_detail_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_tax_detail_rec.ATTRIBUTE20,
p_TAX_INCLUSIVE_FLAG => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
);
ELSIF l_tax_detail_rec.operation_code = 'UPDATE' THEN
ASO_TAX_DETAILS_PKG.Update_Row(
p_TAX_DETAIL_ID => l_tax_detail_rec.TAX_DETAIL_ID,
p_CREATION_DATE => l_tax_detail_rec.creation_date,
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_tax_detail_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_tax_detail_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_tax_detail_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_tax_detail_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_tax_detail_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_tax_detail_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_tax_detail_rec.QUOTE_SHIPMENT_ID,
p_ORIG_TAX_CODE => l_tax_detail_rec.ORIG_TAX_CODE,
p_TAX_CODE => l_tax_detail_rec.TAX_CODE,
p_TAX_RATE => l_tax_detail_rec.TAX_RATE,
p_TAX_DATE => l_tax_detail_rec.TAX_DATE,
p_TAX_AMOUNT => l_tax_detail_rec.TAX_AMOUNT,
p_TAX_EXEMPT_FLAG => l_tax_detail_rec.TAX_EXEMPT_FLAG,
p_TAX_EXEMPT_NUMBER => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
p_TAX_EXEMPT_REASON_CODE =>l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
p_ATTRIBUTE_CATEGORY => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_tax_detail_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_tax_detail_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_tax_detail_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_tax_detail_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_tax_detail_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_tax_detail_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_tax_detail_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_tax_detail_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_tax_detail_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_tax_detail_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_tax_detail_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_tax_detail_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_tax_detail_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_tax_detail_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_tax_detail_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_tax_detail_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_tax_detail_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_tax_detail_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_tax_detail_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_tax_detail_rec.ATTRIBUTE20,
p_TAX_INCLUSIVE_FLAG => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
);
ELSIF l_tax_detail_rec.operation_code = 'DELETE' THEN
ASO_TAX_DETAILS_PKG.Delete_Row(
p_TAX_DETAIL_ID => l_tax_detail_tbl(i).TAX_DETAIL_ID);
ASO_QUOTE_PARTIES_PKG.Insert_Row(
px_QUOTE_PARTY_ID => x_quote_party_tbl(i).QUOTE_PARTY_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_LAST_UPDATED_BY => G_USER_ID,
p_REQUEST_ID => l_QUOTE_PARTY_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_QUOTE_PARTY_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_QUOTE_PARTY_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_QUOTE_PARTY_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_QUOTE_PARTY_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_QUOTE_PARTY_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_QUOTE_PARTY_rec.QUOTE_SHIPMENT_ID,
p_PARTY_TYPE => l_QUOTE_PARTY_rec.PARTY_TYPE,
p_PARTY_ID => l_QUOTE_PARTY_rec.PARTY_ID,
p_PARTY_OBJECT_TYPE => l_QUOTE_PARTY_rec.PARTY_OBJECT_TYPE,
p_PARTY_OBJECT_ID => l_QUOTE_PARTY_rec.PARTY_OBJECT_ID,
p_ATTRIBUTE_CATEGORY => l_QUOTE_PARTY_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_QUOTE_PARTY_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_QUOTE_PARTY_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_QUOTE_PARTY_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_QUOTE_PARTY_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_QUOTE_PARTY_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_QUOTE_PARTY_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_QUOTE_PARTY_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_QUOTE_PARTY_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_QUOTE_PARTY_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_QUOTE_PARTY_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_QUOTE_PARTY_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_QUOTE_PARTY_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_QUOTE_PARTY_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_QUOTE_PARTY_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_QUOTE_PARTY_rec.ATTRIBUTE15,
-- p_SECURITY_GROUP_ID => p_QUOTE_PARTY_rec.SECURITY_GROUP_ID);
ELSIF l_quote_party_rec.operation_code = 'UPDATE' THEN
ASO_QUOTE_PARTIES_PKG.Update_Row(
p_QUOTE_PARTY_ID => l_quote_party_rec.QUOTE_PARTY_ID,
p_CREATION_DATE => l_quote_party_rec.creation_date,
p_CREATED_BY => G_USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_LAST_UPDATED_BY => G_USER_ID,
p_REQUEST_ID => l_QUOTE_PARTY_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_QUOTE_PARTY_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_QUOTE_PARTY_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_QUOTE_PARTY_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_QUOTE_PARTY_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_QUOTE_PARTY_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_QUOTE_PARTY_rec.QUOTE_SHIPMENT_ID,
p_PARTY_TYPE => l_QUOTE_PARTY_rec.PARTY_TYPE,
p_PARTY_ID => l_QUOTE_PARTY_rec.PARTY_ID,
p_PARTY_OBJECT_TYPE => l_QUOTE_PARTY_rec.PARTY_OBJECT_TYPE,
p_PARTY_OBJECT_ID => l_QUOTE_PARTY_rec.PARTY_OBJECT_ID,
p_ATTRIBUTE_CATEGORY => l_QUOTE_PARTY_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_QUOTE_PARTY_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_QUOTE_PARTY_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_QUOTE_PARTY_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_QUOTE_PARTY_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_QUOTE_PARTY_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_QUOTE_PARTY_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_QUOTE_PARTY_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_QUOTE_PARTY_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_QUOTE_PARTY_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_QUOTE_PARTY_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_QUOTE_PARTY_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_QUOTE_PARTY_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_QUOTE_PARTY_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_QUOTE_PARTY_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_QUOTE_PARTY_rec.ATTRIBUTE15,
p_OBJECT_VERSION_NUMBER => l_QUOTE_PARTY_rec.OBJECT_VERSION_NUMBER);
ELSIF l_quote_party_rec.operation_code = 'DELETE' THEN
ASO_QUOTE_PARTIES_PKG.Delete_Row(
p_QUOTE_PARTY_ID => l_QUOTE_PARTY_rec.QUOTE_PARTY_ID);
ASO_PRICE_ADJUSTMENTS_PKG.Insert_Row(
px_PRICE_ADJUSTMENT_ID => x_price_adj_tbl(i).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_QUOTE_SHIPMENT_ID => l_price_adj_rec.QUOTE_SHIPMENT_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_LIST_HEADER_ID => l_price_adj_rec. ,
-- p_LIST_LINE_ID => l_price_adj_rec. ,
-- p_LIST_LINE_TYPE_CODE => l_price_adj_rec.,
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);
ELSIF l_price_adj_rec.operation_code = 'UPDATE' THEN
-- New Code for updating PBH
if l_price_adj_rec.updated_flag = 'Y' then
l_price_adjustment_id := null;
UPDATE aso_price_adjustments
SET updated_flag = 'Y',
applied_flag = null
Where price_adjustment_id in ( SELECT rltd_price_adj_id
FROM aso_price_adj_relationships b
WHERE price_adjustment_id = l_price_adjustment_id );
UPDATE aso_price_adjustments
SET updated_flag = 'Y',
applied_flag = 'Y'
Where price_adjustment_id = l_price_adjustment_id;
ASO_PRICE_ADJUSTMENTS_PKG.Update_Row(
p_PRICE_ADJUSTMENT_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID,
p_CREATION_DATE => l_price_adj_rec.creation_date,
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_QUOTE_SHIPMENT_ID => l_price_adj_rec.QUOTE_SHIPMENT_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_LIST_HEADER_ID => l_price_adj_rec. ,
-- p_LIST_LINE_ID => l_price_adj_rec. ,
-- p_LIST_LINE_TYPE_CODE => l_price_adj_rec.,
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
);
ELSIF l_price_adj_rec.operation_code = 'DELETE' THEN
ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
p_PRICE_ADJ_ID => l_price_adj_rec.PRICE_ADJUSTMENT_ID);
ASO_PRICE_ADJ_ATTRIBS_PKG.Insert_Row(
px_PRICE_ADJ_ATTRIB_ID=> x_price_adj_attr_tbl(i).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_tbl(i).PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_price_adj_attr_tbl(i).PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_price_adj_attr_tbl(i).PROGRAM_UPDATE_DATE,
p_REQUEST_ID => l_price_adj_attr_tbl(i).REQUEST_ID,
p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID,
p_PRICING_CONTEXT => l_price_adj_attr_tbl(i).PRICING_CONTEXT,
p_PRICING_ATTRIBUTE => l_price_adj_attr_tbl(i).PRICING_ATTRIBUTE,
p_PRICING_ATTR_VALUE_FROM
=> l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_FROM,
p_PRICING_ATTR_VALUE_TO
=> l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_TO,
p_COMPARISON_OPERATOR => l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
p_FLEX_TITLE => l_price_adj_attr_tbl(i).FLEX_TITLE ,
p_OBJECT_VERSION_NUMBER => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER);
ELSIF l_price_adj_attr_tbl(i).operation_code = 'UPDATE' THEN
ASO_PRICE_ADJ_ATTRIBS_PKG.Update_Row(
p_PRICE_ADJ_ATTRIB_ID => l_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID,
p_CREATION_DATE => l_price_adj_attr_tbl(i).creation_date,
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_tbl(i).PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_price_adj_attr_tbl(i).PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_price_adj_attr_tbl(i).PROGRAM_UPDATE_DATE,
p_REQUEST_ID => l_price_adj_attr_tbl(i).REQUEST_ID,
p_PRICE_ADJUSTMENT_ID => l_price_adj_attr_tbl(i).PRICE_ADJUSTMENT_ID,
p_PRICING_CONTEXT => l_price_adj_attr_tbl(i).PRICING_CONTEXT,
p_PRICING_ATTRIBUTE => l_price_adj_attr_tbl(i).PRICING_ATTRIBUTE,
p_PRICING_ATTR_VALUE_FROM
=> l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_FROM,
p_PRICING_ATTR_VALUE_TO
=> l_price_adj_attr_tbl(i).PRICING_ATTR_VALUE_TO,
p_COMPARISON_OPERATOR => l_price_adj_attr_tbl(i).COMPARISON_OPERATOR,
p_FLEX_TITLE => l_price_adj_attr_tbl(i).FLEX_TITLE ,
p_OBJECT_VERSION_NUMBER => l_price_adj_attr_tbl(i).OBJECT_VERSION_NUMBER
);
ELSIF l_price_adj_attr_tbl(i).operation_code = 'DELETE' THEN
ASO_PRICE_ADJ_ATTRIBS_PKG.Delete_Row(
p_PRICE_ADJ_ATTRIB_ID => l_price_adj_attr_tbl(i).PRICE_ADJ_ATTRIB_ID);
aso_debug_pub.add('Update_Rows: l_Price_Attributes_Tbl.count: '||l_Price_Attributes_Tbl.count,1, 'N');
aso_debug_pub.add('Update_Rows: Before call to aso_pricing_int.Delete_Promotion',1, 'N');
aso_pricing_int.Delete_Promotion (
P_Api_Version_Number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
p_price_attr_tbl => l_Price_Attributes_Tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
aso_debug_pub.add('Update_Rows: After call to Delete_Promotion: x_return_status: '||x_return_status,1, 'N');
aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Line l_payment_tbl(i).payment_term_id'||l_payment_tbl(i).payment_term_id, 1, 'Y');
aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Insert Rows Quote Linel_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
aso_debug_pub.add('Update_Quote_Line_Rows: Before call to create_payment_row ', 1, 'Y');
aso_debug_pub.add('Update_Quote_Line_Rows: After call to create_payment_row: x_return_status: '||x_return_status, 1, 'Y');
ELSIF l_payment_rec.operation_code = 'UPDATE' THEN
IF l_payment_rec.payment_term_id = FND_API.G_MISS_NUM THEN
FOR l_payment_db_rec IN c_db_payment_terms(l_payment_rec.PAYMENT_ID) LOOP
IF l_payment_db_rec.payment_term_id_from IS NULL THEN
l_payment_rec.payment_term_id_from := l_payment_db_rec.payment_term_id;
aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.payment_term_id'||l_payment_rec.payment_term_id, 1, 'Y');
aso_debug_pub.add('Inside ASO_PAYMENTS_PKG - Update Rows l_payment_rec.PAYMENT_TERM_ID_FROM'||l_payment_rec.PAYMENT_TERM_ID_FROM, 1, 'Y');
aso_debug_pub.add('Update_Quote_Line_Rows: Before call to update_payment_row ', 1, 'Y');
aso_payment_int.update_payment_row(p_payment_rec => l_payment_rec ,
x_payment_rec => x_payment_tbl(i),
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
aso_debug_pub.add('Update_Quote_Line_Rows: After call to update_payment_row: x_return_status: '||x_return_status, 1, 'Y');
ELSIF l_payment_rec.operation_code = 'DELETE' THEN
-- Suyog Payments Changes
IF aso_debug_pub.g_debug_flag = 'Y' THEN
aso_debug_pub.add('Update_Quote_Line_Rows: Before call to delete_payment_row ', 1, 'Y');
aso_payment_int.delete_payment_row(p_payment_rec => l_payment_rec ,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
aso_debug_pub.add('Update_Quote_Line_Rows: After call to delete_payment_row: x_return_status: '||x_return_status, 1, 'Y');
ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Insert_Row(
px_LINE_ATTRIBUTE_ID => x_LINE_ATTRIBS_EXT_TBL(i).LINE_ATTRIBUTE_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_LINE_ATTRIBS_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_LINE_ATTRIBS_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
p_APPLICATION_ID => l_LINE_ATTRIBS_rec.APPLICATION_ID,
p_STATUS => l_LINE_ATTRIBS_rec.STATUS,
p_QUOTE_HEADER_ID => l_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
p_ATTRIBUTE_TYPE_CODE => l_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
p_NAME => l_LINE_ATTRIBS_rec.NAME,
p_VALUE => l_LINE_ATTRIBS_rec.VALUE,
p_VALUE_TYPE => l_LINE_ATTRIBS_rec.VALUE_TYPE,
p_START_DATE_ACTIVE => l_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
p_END_DATE_ACTIVE => l_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
p_OBJECT_VERSION_NUMBER => l_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER);
ELSIF l_line_attribs_rec.operation_code = 'UPDATE' THEN
ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Update_Row(
p_LINE_ATTRIBUTE_ID => l_LINE_ATTRIBS_REC.LINE_ATTRIBUTE_ID,
p_CREATION_DATE => l_LINE_ATTRIBS_rec.creation_date,
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_LINE_ATTRIBS_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID =>l_LINE_ATTRIBS_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_LINE_ATTRIBS_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_LINE_ATTRIBS_rec.PROGRAM_UPDATE_DATE,
p_APPLICATION_ID => l_LINE_ATTRIBS_rec.APPLICATION_ID,
p_STATUS => l_LINE_ATTRIBS_rec.STATUS,
p_QUOTE_HEADER_ID => l_LINE_ATTRIBS_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_LINE_ATTRIBS_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_LINE_ATTRIBS_rec.QUOTE_SHIPMENT_ID,
p_ATTRIBUTE_TYPE_CODE => l_LINE_ATTRIBS_rec.ATTRIBUTE_TYPE_CODE,
p_NAME => l_LINE_ATTRIBS_rec.NAME,
p_VALUE => l_LINE_ATTRIBS_rec.VALUE,
p_VALUE_TYPE => l_LINE_ATTRIBS_rec.VALUE_TYPE,
p_START_DATE_ACTIVE => l_LINE_ATTRIBS_rec.START_DATE_ACTIVE,
p_END_DATE_ACTIVE => l_LINE_ATTRIBS_rec.END_DATE_ACTIVE,
p_OBJECT_VERSION_NUMBER => l_LINE_ATTRIBS_rec.OBJECT_VERSION_NUMBER);
ELSIF l_line_attribs_rec.operation_code = 'DELETE' THEN
ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.delete_Row(
p_LINE_ATTRIB_ID => l_LINE_ATTRIBS_rec.LINE_ATTRIBUTE_ID);
update aso_quote_lines_all
set split_shipment_flag = 'T',
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_line_id = l_Qte_Line_Rec.quote_line_id;
update aso_quote_lines_all
set split_shipment_flag = 'F',
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_line_id = l_Qte_Line_Rec.quote_line_id;
aso_debug_pub.add('Update_Quote_line - before calculate_tax_flag ', 1, 'N');
l_tax_control_rec.update_db := 'Y' ; --FND_API.G_TRUE;
SELECT reservation_id INTO l_shipment_tbl(i).reservation_id
FROM ASO_SHIPMENTS
WHERE shipment_id = l_shipment_tbl(i).shipment_id;
ASO_RESERVATION_INT.Update_reservation(
P_Api_Version_Number => 1.0,
p_line_rec => x_qte_line_rec,
p_shipment_rec => l_shipment_tbl(i),
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
UPDATE ASO_SHIPMENTS
SET reservation_id = l_shipment_tbl(i).reservation_id,
reserved_quantity = l_shipment_tbl(i).reserved_quantity,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
WHERE shipment_id = l_shipment_tbl(i).shipment_id;
IF p_update_header_flag = 'Y' THEN
-- Update Quote total info (do summation to get TOTAL_LIST_PRICE,
-- TOTAL_ADJUSTED_AMOUNT, TOTAL_TAX, TOTAL_SHIPPING_CHARGE, SURCHARGE,
-- TOTAL_QUOTE_PRICE, PAYMENT_AMOUNT)
-- IF calculate_tax_flag = 'N', not summation on line level tax,
-- just take the value of p_qte_rec.total_tax as the total_tax
-- IF calculate_Freight_Charge = 'N', not summation on line level freight charge,
-- just take the value of p_qte_rec.total_freight_charge
-- how can i get the calc_tax_flag and calc_freight_charge_flag ??
ASO_QUOTE_HEADERS_PVT.Update_Quote_Total (
P_Qte_Header_id => l_Qte_Line_Rec.quote_header_id,
P_calculate_tax => l_control_rec.CALCULATE_TAX_FLAG,
P_calculate_freight_charge=> l_control_rec.calculate_freight_charge_flag,
p_control_rec => l_control_rec,
X_Return_Status => l_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
-- Adding the call to insert record in the ASO_CHANGED_QUOTES
SELECT quote_number
INTO l_quote_number
FROM aso_quote_headers
WHERE quote_header_id = l_Qte_Line_Rec.quote_header_id;
aso_debug_pub.add('ASO_QUOTE_LINES_PVT.update_quote_line : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
-- Call to insert record in ASO_CHANGED_QUOTES
ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
End Update_quote_line;
PROCEDURE Delete_Quote_Line(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type
:= ASO_QUOTE_PUB.G_MISS_Control_Rec,
P_Update_Header_Flag IN VARCHAR2 := 'Y',
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)
IS
Cursor C_Get_quote(c_QUOTE_LINE_ID Number) IS
Select head.LAST_UPDATE_DATE, head.QUOTE_STATUS_ID, head.QUOTE_NUMBER,
head.TOTAL_ADJUSTED_PERCENT, head.quote_header_id
From ASO_QUOTE_HEADERS_ALL head,
ASO_QUOTE_LINES_ALL line
Where head.QUOTE_HEADER_ID = line.QUOTE_HEADER_ID
And line.QUOTE_LINE_ID = c_QUOTE_LINE_ID;
SELECT UPDATE_ALLOWED_FLAG, AUTO_VERSION_FLAG FROM ASO_QUOTE_STATUSES_B
WHERE quote_status_id = c_qte_status_id;
SELECT max(quote_version)
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_number = X_qte_number;
SELECT shipment_id, reservation_id
FROM aso_shipments
WHERE quote_line_id = p_qte_line_rec.quote_line_id;
SELECT line_inst_detail_id
FROM cs_line_inst_details
WHERE quote_line_shipment_id = shipment_id;
select transaction_line_id
from csi_t_transaction_lines
where source_transaction_id = p_qte_line_rec.quote_line_id
and source_transaction_table = 'ASO_QUOTE_LINES_ALL';
SELECT qln.item_type_code, dtl.config_header_id, dtl.config_revision_num, dtl.ref_type_code
FROM aso_quote_lines_all qln, aso_quote_line_details dtl
WHERE qln.quote_line_id = p_qte_line_rec.quote_line_id
AND qln.quote_line_id = dtl.quote_line_id;
SELECT quote_line_id
FROM aso_quote_line_details
WHERE ref_line_id = l_quote_line_id
AND ref_type_code = 'TOP_MODEL';
select pricing_line_type_indicator
from aso_quote_lines_all
where quote_line_id = P_qte_line_Rec.quote_line_id;
select modifier_line_type_code
from aso_price_adjustments
where quote_line_id = p_qte_line_rec.quote_line_id
and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
select a.quote_line_id
from aso_price_adjustments a, aso_price_adj_relationships b
where a.price_adjustment_id = b.rltd_price_adj_id
and b.quote_line_id = p_qte_line_rec.quote_line_id
and a.quote_line_id <> p_qte_line_rec.quote_line_id;
SELECT quote_number
FROM aso_quote_headers
WHERE quote_header_id = qte_hdr_id;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_quote_line';
l_last_update_date DATE;
l_update_allowed VARCHAR2(1);
aso_debug_pub.add('Delete_Quote_lines - Begin ', 1, 'Y');
aso_debug_pub.add('Delete_Quote_Line: P_qte_line_Rec.quote_line_id: '||P_qte_line_Rec.quote_line_id);
aso_debug_pub.add('Delete_Quote_Line: P_Update_Header_Flag: '||P_Update_Header_Flag);
SAVEPOINT DELETE_quote_line_PVT;
IF (p_update_header_flag = 'Y') THEN
Open C_Get_quote( p_qte_line_rec.QUOTE_LINE_ID);
Fetch C_Get_quote into l_LAST_UPDATE_DATE, l_qte_status_id,
l_quote_number, l_hd_discount_percent,
l_quote_header_id;
FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
END IF; -- update header flag
If (l_last_update_date is NULL or
l_last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If l_last_update_date <> p_control_rec.last_update_date Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
Fetch C_qte_status into l_update_allowed, l_auto_version;
aso_debug_pub.add('Delete_Quote_Line: l_auto_version: '|| l_auto_version);
fetch c_get_quote into l_last_update_date, l_qte_status_id,
l_quote_number, l_hd_discount_percent,
l_quote_header_id;
aso_debug_pub.add('Delete_Quote_Line: After call to aso_copy_quote_pvt.copy_quote');
update aso_quote_headers_all
set quote_version = l_quote_version + 1,
max_version_flag = 'Y',
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = p_qte_line_rec.quote_header_id;
update aso_quote_headers_all
set max_version_flag = 'N',
quote_version = l_old_header_rec.quote_version,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = x_quote_header_id;
update aso_quote_headers_all
set quote_version = l_quote_version,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_header_id = p_qte_line_rec.quote_header_id;
select rel.rltd_price_adj_id
BULK COLLECT INTO
adj_id_tbl
from aso_price_adj_relationships rel,
aso_price_adjustments adj
where rel.price_adjustment_id = adj.price_adjustment_id
and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
and rel.price_adjustment_id in (select a.price_adjustment_id
from aso_price_adj_relationships a,
aso_price_adjustments b
where a.rltd_price_adj_id = b.price_adjustment_id
and b.quote_line_id = p_qte_line_rec.quote_line_id);
aso_debug_pub.add('No. of free adjustment lines selected is sql%rowcount: '||sql%rowcount);
UPDATE aso_price_adjustments
SET updated_flag = 'Y'
WHERE price_adjustment_id = adj_id_tbl(i)
AND modifier_line_type_code = G_DISCOUNT;
aso_debug_pub.add('No of adjustment lines updated is sql%rowcount: '||sql%rowcount);
select a.price_adjustment_id
BULK COLLECT INTO
adj_id_tbl
from aso_price_adj_relationships a, aso_price_adjustments b
where a.rltd_price_adj_id = b.price_adjustment_id
and b.quote_line_id = p_qte_line_rec.quote_line_id;
aso_debug_pub.add('No. of PRG adjustment lines selected is sql%rowcount: '||sql%rowcount);
UPDATE aso_price_adjustments
SET updated_flag = 'Y'
WHERE price_adjustment_id = adj_id_tbl(i)
AND modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
aso_debug_pub.add('No of PRG adjustment lines updated is sql%rowcount: '||sql%rowcount);
aso_debug_pub.add('Delete_Quote_Line: Updation of updated_flag column in aso_price_adjustments table failed.');
aso_debug_pub.add('After updation of updated_flag column in aso_price_adjustments table.', 1, 'Y');
aso_quote_lines_pvt.delete_quote_line(
P_Api_Version_Number => 1.0,
p_control_rec => p_control_rec,
p_update_header_flag => fnd_api.g_false,
P_qte_Line_Rec => l_qte_line_rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
ASO_QUOTE_LINE_ATTRIBS_EXT_PKG.Delete_Row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
ASO_PRICE_ATTRIBUTES_PKG.Delete_Row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
ASO_LINE_RLTSHIP_PVT.Delete_line_rltship(
P_Api_Version_Number => 1.0,
p_control_rec => p_control_rec,
P_LINE_RLTSHIP_Rec => l_line_rltship_rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
ASO_PRICE_ADJ_RLTSHIP_PVT.Delete_Price_Adj_Rltship(
P_Api_Version_Number => 1.0,
P_PRICE_ADJ_RLTSHIP_Rec => l_price_adj_rltship_rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
ASO_PRICE_ADJUSTMENTS_PKG.Delete_Row(
p_LINE_ID => p_qte_line_rec.quote_line_id,
p_TYPE_CODE => 'QUOTE_LINE');
aso_debug_pub.add('Delete_Quote_Line: Before call to delete_payment_row ', 1, 'Y');
aso_debug_pub.add('Delete_Quote_Line: l_payment_tbl.count: '|| l_payment_tbl.count, 1, 'Y');
aso_debug_pub.add('Delete_Quote_Line: Inside if for payment tbl count > 0 ', 1, 'Y');
aso_debug_pub.add('Delete_Quote_Line: Before call to delete_payment_row', 1, 'Y');
aso_payment_int.delete_payment_row(p_payment_rec => l_payment_rec ,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
aso_debug_pub.add('Delete_Quote_Line: After call to delete_payment_row: x_return_status: '||x_return_status, 1, 'Y');
aso_debug_pub.add('Delete_Quote_Line: Before calling table handler to delete payment row', 1, 'Y');
aso_payments_pkg.Delete_Row(p_payment_id => l_payment_tbl(1).payment_id);
aso_debug_pub.add('Delete_Quote_Line: After deleting the payment row', 1, 'Y');
ASO_FREIGHT_CHARGES_PKG.delete_Row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
ASO_TAX_DETAILS_PKG.Delete_Row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
aso_debug_pub.add('Delete_Quote_Line: Before deleting the sales credits', 1, 'Y');
ASO_SALES_CREDITS_PKG.Delete_row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
aso_debug_pub.add('Delete_Quote_Line: Before deleting the quote parties', 1, 'Y');
ASO_QUOTE_PARTIES_PKG.Delete_row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
ASO_CFG_INT.DELETE_CONFIGURATION(
P_API_VERSION_NUMBER => 1.0,
P_INIT_MSG_LIST => FND_API.G_FALSE,
P_CONFIG_HDR_ID => l_config_id,
P_CONFIG_REV_NBR => l_rev_num,
X_RETURN_STATUS => x_return_status,
X_MSG_COUNT => x_msg_count,
X_MSG_DATA => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
ASO_QUOTE_LINES_PVT.Delete_Quote_Line(
P_Api_Version_Number => 1.0,
p_control_rec => p_control_rec,
p_update_header_flag => p_update_header_flag,
P_qte_Line_Rec => l_qte_line_rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
aso_debug_pub.add('Delete_Quote_Line: Before deleting the quote line details', 1, 'Y');
ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(
p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
ASO_INSTBASE_INT.Delete_Installation_Detail(
p_api_version_number => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_inst_dtl_id => l_line_inst_dtl_id
);
FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
ASO_SHIPMENT_PVT.Delete_shipment(
P_Api_Version_Number => 1.0,
P_SHIPMENT_Rec => l_shipment_rec,
X_Return_Status => x_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_DELETE');
aso_debug_pub.add('Delete_Quote_Line: Before deleting the quote line', 1, 'Y');
ASO_QUOTE_LINES_PKG.Delete_Row( p_quote_line_id => p_qte_line_rec.quote_line_id);
aso_debug_pub.add('Delete_Quote_Line: After deleting the quote line', 1, 'Y');
IF p_update_header_flag = 'Y' THEN
-- Update Quote total info (do summation to get TOTAL_LIST_PRICE,
-- TOTAL_ADJUSTED_AMOUNT, TOTAL_TAX, TOTAL_SHIPPING_CHARGE, SURCHARGE,
-- TOTAL_QUOTE_PRICE, PAYMENT_AMOUNT)
-- IF calculate_tax_flag = 'N', not summation on line level tax,
-- just take the value of p_qte_rec.total_tax as the total_tax
-- IF calculate_Freight_Charge = 'N', not summation on line level freight charge,
-- just take the value of p_qte_rec.total_freight_charge
-- how can i get the calc_tax_flag and calc_freight_charge_flag ??
ASO_QUOTE_HEADERS_PVT.Update_Quote_Total(
P_Qte_Header_id => l_quote_header_id,
P_calculate_tax => p_control_rec.CALCULATE_TAX_FLAG,
P_calculate_freight_charge => p_control_rec.calculate_freight_charge_flag,
p_control_rec => p_control_rec,
X_Return_Status => l_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
FND_MESSAGE.Set_Name('ASO', 'ASO_UPDATE_QUOTE_TOTAL');
aso_debug_pub.add('Delete_Quote_Line: Before call to Delete_OTA_Line.');
ASO_EDUCATION_INT.Delete_OTA_Line(
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_Qte_Line_Id => p_qte_line_rec.quote_line_id,
X_Return_Status => l_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data);
aso_debug_pub.add('Delete_Quote_Line: After call to Delete_OTA_Line.');
aso_debug_pub.add('Delete_Quote_Line: l_return_status: '|| l_return_status);
-- Adding the call to insert record in the ASO_CHANGED_QUOTES
IF ((p_qte_line_rec.quote_header_id is not null) and (p_qte_line_rec.quote_header_id <> FND_API.G_MISS_NUM)) THEN
IF aso_debug_pub.g_debug_flag = 'Y' THEN
aso_debug_pub.add('ASO_QUOTE_LINES_PVT.delete_quote_line : Before calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, Quote Header ID :' || p_qte_line_rec.quote_header_id, 1, 'Y');
aso_debug_pub.add('ASO_QUOTE_LINES_PVT.delete_quote_line : Before calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_qte_number, 1, 'Y');
-- Call to insert record in ASO_CHANGED_QUOTES
ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_number);
Procedure service_item_qty_update
(p_qte_line_rec IN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE,
p_service_item_flag IN VARCHAR2,
x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)IS
CURSOR C_ord_qty(ord_line_id NUMBER) IS
SELECT ordered_quantity
FROM oe_order_lines_All
WHERE line_id = ord_line_id;
SELECT quantity
FROM CSI_ITEM_INSTANCES
WHERE instance_id = p_instance_id;
SELECT quantity
FROM aso_quote_lines_all
WHERE quote_line_id = p_quote_line_id;
l_update_flag VARCHAR2(1) := FND_API.G_FALSE;
aso_debug_pub.add('Procedure Service_item_qty_update Starts.', 1, 'Y');
aso_debug_pub.add('Service_item_qty_update: Inside IF condition p_service_item_flag = FND_API.G_FALSE', 1, 'N');
UPDATE aso_quote_lines_all
set quantity = l_qte_line_rec.quantity,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_line_id IN
( select quote_line_id from aso_quote_line_details
where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );
aso_debug_pub.add('Service_item_qty_update:Exception1',1,'N');
aso_debug_pub.add('Service_item_qty_update:ELSE condition of p_service_item_flag = FND_API.G_FALSE', 1, 'N');
aso_debug_pub.add('Service_item_qty_update: ASO_UTILITY_PVT.Query_Line_Dtl_Rows', 1, 'N');
aso_debug_pub.add('Service_item_qty_update: Cursor C_quantity: l_quantity: '||l_quantity, 1, 'N');
aso_debug_pub.add('Service_item_qty_update: Inside cursor C_quantity%NOTFOUND ', 1, 'N');
l_update_flag := FND_API.G_TRUE;
aso_debug_pub.add('Service_item_qty_update: Cursor C_ord_qty: l_quantity: '||l_quantity, 1, 'N');
aso_debug_pub.add('Service_item_qty_update: Inside cursor C_ord_qty%NOTFOUND condition.', 1, 'N');
l_update_flag := FND_API.G_TRUE;
aso_debug_pub.add('Service_item_qty_update: Cursor C_cs_qty: l_quantity: '||l_quantity, 1, 'N');
aso_debug_pub.add('Service_item_qty_update: Inside cursor C_cs_qty%NOTFOUND condition. ', 1, 'N');
aso_debug_pub.add('Service_item_qty_update: cursor C_cs_qty%FOUND ', 1, 'N ');
l_update_flag := FND_API.G_TRUE;
IF x_return_status <> FND_API.G_RET_STS_ERROR AND l_update_flag = FND_API.G_TRUE THEN
Begin
UPDATE aso_quote_lines_all
set quantity = l_quantity,
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.conc_login_id
where quote_line_id = p_qte_line_rec.quote_line_id;
aso_debug_pub.add('Service_item_qty_update:Exception raised when others', 1, 'N');
l_update_flag := FND_API.G_FALSE;
End service_item_qty_update;