[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
p_ORG_ID NUMBER,
p_INCIDENT_ID NUMBER,
p_ORIGINAL_SOURCE_ID NUMBER,
p_ORIGINAL_SOURCE_CODE VARCHAR2,
p_SOURCE_ID NUMBER,
p_SOURCE_CODE VARCHAR2,
p_CONTRACT_LINE_ID NUMBER,
p_RATE_TYPE_CODE VARCHAR2,
p_CONTRACT_ID NUMBER,
p_COVERAGE_ID NUMBER,
p_COVERAGE_TXN_GROUP_ID NUMBER,
--p_EXCEPTION_COVERAGE_USED VARCHAR2,
p_CURRENCY_CODE VARCHAR2,
p_CONVERSION_RATE NUMBER,
p_CONVERSION_TYPE_CODE VARCHAR2,
p_CONVERSION_RATE_DATE DATE,
p_INVOICE_TO_ORG_ID NUMBER,
p_SHIP_TO_ORG_ID NUMBER,
p_PURCHASE_ORDER_NUM VARCHAR2,
p_ORDER_LINE_ID NUMBER,
p_LINE_TYPE_ID NUMBER,
p_LINE_CATEGORY_CODE VARCHAR2,
p_PRICE_LIST_HEADER_ID NUMBER,
p_LINE_NUMBER NUMBER,
p_INVENTORY_ITEM_ID NUMBER,
p_ITEM_REVISION VARCHAR2,
p_SERIAL_NUMBER VARCHAR2,
p_QUANTITY_REQUIRED NUMBER,
p_UNIT_OF_MEASURE_CODE VARCHAR2,
p_SELLING_PRICE NUMBER,
p_AFTER_WARRANTY_COST NUMBER,
--p_FUNC_CURR_AFT_WARR_COST NUMBER, -- Obsolete column 11/13/2002 mviswana
p_BUSINESS_PROCESS_ID NUMBER,
p_TRANSACTION_TYPE_ID NUMBER,
p_CUSTOMER_PRODUCT_ID NUMBER,
p_ORDER_HEADER_ID NUMBER,
p_INSTALLED_CP_RETURN_BY_DATE DATE,
p_NEW_CP_RETURN_BY_DATE DATE,
p_INTERFACE_TO_OE_FLAG VARCHAR2,
p_ROLLUP_FLAG VARCHAR2,
p_NO_CHARGE_FLAG VARCHAR2,
p_ADD_TO_ORDER_FLAG VARCHAR2,
p_RETURN_REASON_CODE VARCHAR2,
p_GENERATED_BY_BCA_ENGINE_FLAG VARCHAR2,
p_TRANSACTION_INVENTORY_ORG NUMBER,
p_TRANSACTION_SUB_INVENTORY VARCHAR2,
p_CHARGE_LINE_TYPE VARCHAR2,
p_SHIP_TO_ACCOUNT_ID NUMBER,
p_INVOICE_TO_ACCOUNT_ID NUMBER,
p_SHIP_TO_CONTACT_ID NUMBER,
p_BILL_TO_CONTACT_ID NUMBER,
p_LIST_PRICE NUMBER,
p_ACTIVITY_START_DATE_TIME DATE,
p_ACTIVITY_END_DATE_TIME DATE,
p_CONTRACT_DISCOUNT_AMOUNT NUMBER,
p_BILL_TO_PARTY_ID NUMBER,
p_SHIP_TO_PARTY_ID NUMBER,
p_PRICING_CONTEXT VARCHAR2,
p_PRICING_ATTRIBUTE1 VARCHAR2,
p_PRICING_ATTRIBUTE2 VARCHAR2,
p_PRICING_ATTRIBUTE3 VARCHAR2,
p_PRICING_ATTRIBUTE4 VARCHAR2,
p_PRICING_ATTRIBUTE5 VARCHAR2,
p_PRICING_ATTRIBUTE6 VARCHAR2,
p_PRICING_ATTRIBUTE7 VARCHAR2,
p_PRICING_ATTRIBUTE8 VARCHAR2,
p_PRICING_ATTRIBUTE9 VARCHAR2,
p_PRICING_ATTRIBUTE10 VARCHAR2,
p_PRICING_ATTRIBUTE11 VARCHAR2,
p_PRICING_ATTRIBUTE12 VARCHAR2,
p_PRICING_ATTRIBUTE13 VARCHAR2,
p_PRICING_ATTRIBUTE14 VARCHAR2,
p_PRICING_ATTRIBUTE15 VARCHAR2,
p_PRICING_ATTRIBUTE16 VARCHAR2,
p_PRICING_ATTRIBUTE17 VARCHAR2,
p_PRICING_ATTRIBUTE18 VARCHAR2,
p_PRICING_ATTRIBUTE19 VARCHAR2,
p_PRICING_ATTRIBUTE20 VARCHAR2,
p_PRICING_ATTRIBUTE21 VARCHAR2,
p_PRICING_ATTRIBUTE22 VARCHAR2,
p_PRICING_ATTRIBUTE23 VARCHAR2,
p_PRICING_ATTRIBUTE24 VARCHAR2,
p_PRICING_ATTRIBUTE25 VARCHAR2,
p_PRICING_ATTRIBUTE26 VARCHAR2,
p_PRICING_ATTRIBUTE27 VARCHAR2,
p_PRICING_ATTRIBUTE28 VARCHAR2,
p_PRICING_ATTRIBUTE29 VARCHAR2,
p_PRICING_ATTRIBUTE30 VARCHAR2,
p_PRICING_ATTRIBUTE31 VARCHAR2,
p_PRICING_ATTRIBUTE32 VARCHAR2,
p_PRICING_ATTRIBUTE33 VARCHAR2,
p_PRICING_ATTRIBUTE34 VARCHAR2,
p_PRICING_ATTRIBUTE35 VARCHAR2,
p_PRICING_ATTRIBUTE36 VARCHAR2,
p_PRICING_ATTRIBUTE37 VARCHAR2,
p_PRICING_ATTRIBUTE38 VARCHAR2,
p_PRICING_ATTRIBUTE39 VARCHAR2,
p_PRICING_ATTRIBUTE40 VARCHAR2,
p_PRICING_ATTRIBUTE41 VARCHAR2,
p_PRICING_ATTRIBUTE42 VARCHAR2,
p_PRICING_ATTRIBUTE43 VARCHAR2,
p_PRICING_ATTRIBUTE44 VARCHAR2,
p_PRICING_ATTRIBUTE45 VARCHAR2,
p_PRICING_ATTRIBUTE46 VARCHAR2,
p_PRICING_ATTRIBUTE47 VARCHAR2,
p_PRICING_ATTRIBUTE48 VARCHAR2,
p_PRICING_ATTRIBUTE49 VARCHAR2,
p_PRICING_ATTRIBUTE50 VARCHAR2,
p_PRICING_ATTRIBUTE51 VARCHAR2,
p_PRICING_ATTRIBUTE52 VARCHAR2,
p_PRICING_ATTRIBUTE53 VARCHAR2,
p_PRICING_ATTRIBUTE54 VARCHAR2,
p_PRICING_ATTRIBUTE55 VARCHAR2,
p_PRICING_ATTRIBUTE56 VARCHAR2,
p_PRICING_ATTRIBUTE57 VARCHAR2,
p_PRICING_ATTRIBUTE58 VARCHAR2,
p_PRICING_ATTRIBUTE59 VARCHAR2,
p_PRICING_ATTRIBUTE60 VARCHAR2,
p_PRICING_ATTRIBUTE61 VARCHAR2,
p_PRICING_ATTRIBUTE62 VARCHAR2,
p_PRICING_ATTRIBUTE63 VARCHAR2,
p_PRICING_ATTRIBUTE64 VARCHAR2,
p_PRICING_ATTRIBUTE65 VARCHAR2,
p_PRICING_ATTRIBUTE66 VARCHAR2,
p_PRICING_ATTRIBUTE67 VARCHAR2,
p_PRICING_ATTRIBUTE68 VARCHAR2,
p_PRICING_ATTRIBUTE69 VARCHAR2,
p_PRICING_ATTRIBUTE70 VARCHAR2,
p_PRICING_ATTRIBUTE71 VARCHAR2,
p_PRICING_ATTRIBUTE72 VARCHAR2,
p_PRICING_ATTRIBUTE73 VARCHAR2,
p_PRICING_ATTRIBUTE74 VARCHAR2,
p_PRICING_ATTRIBUTE75 VARCHAR2,
p_PRICING_ATTRIBUTE76 VARCHAR2,
p_PRICING_ATTRIBUTE77 VARCHAR2,
p_PRICING_ATTRIBUTE78 VARCHAR2,
p_PRICING_ATTRIBUTE79 VARCHAR2,
p_PRICING_ATTRIBUTE80 VARCHAR2,
p_PRICING_ATTRIBUTE81 VARCHAR2,
p_PRICING_ATTRIBUTE82 VARCHAR2,
p_PRICING_ATTRIBUTE83 VARCHAR2,
p_PRICING_ATTRIBUTE84 VARCHAR2,
p_PRICING_ATTRIBUTE85 VARCHAR2,
p_PRICING_ATTRIBUTE86 VARCHAR2,
p_PRICING_ATTRIBUTE87 VARCHAR2,
p_PRICING_ATTRIBUTE88 VARCHAR2,
p_PRICING_ATTRIBUTE89 VARCHAR2,
p_PRICING_ATTRIBUTE90 VARCHAR2,
p_PRICING_ATTRIBUTE91 VARCHAR2,
p_PRICING_ATTRIBUTE92 VARCHAR2,
p_PRICING_ATTRIBUTE93 VARCHAR2,
p_PRICING_ATTRIBUTE94 VARCHAR2,
p_PRICING_ATTRIBUTE95 VARCHAR2,
p_PRICING_ATTRIBUTE96 VARCHAR2,
p_PRICING_ATTRIBUTE97 VARCHAR2,
p_PRICING_ATTRIBUTE98 VARCHAR2,
p_PRICING_ATTRIBUTE99 VARCHAR2,
p_PRICING_ATTRIBUTE100 VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_CONTEXT VARCHAR2,
p_COVERAGE_BILL_RATE_ID NUMBER,
P_COVERAGE_BILLING_TYPE_ID NUMBER,
p_TXN_BILLING_TYPE_ID NUMBER,
p_SUBMIT_RESTRICTION_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
p_SUBMIT_ERROR_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
p_SUBMIT_FROM_SYSTEM VARCHAR2, -- Added Column mviswana 07/23/2003
p_LINE_SUBMITTED VARCHAR2, -- Added Column mviswana 07/23/2003
--p_EST_TAX_AMOUNT NUMBER, -- Obsolete column 11/13/2002 mviswana
--p_TAX_CODE VARCHAR2, -- Obsolete column 11/13/2002 mviswana
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER,
P_ESTIMATE_DETAIL_ID IN NUMBER,
x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER)
IS
/* CURSOR C IS
SELECT CS_ESTIMATE_DETAILS_S.nextval
FROM sys.dual; */
INSERT INTO CS_ESTIMATE_DETAILS(
ESTIMATE_DETAIL_ID,
ORG_ID,
INCIDENT_ID,
ORIGINAL_SOURCE_ID,
ORIGINAL_SOURCE_CODE,
SOURCE_ID,
SOURCE_CODE,
CONTRACT_LINE_ID,
RATE_TYPE_CODE,
CONTRACT_ID,
COVERAGE_ID,
COVERAGE_TXN_GROUP_ID,
--EXCEPTION_COVERAGE_USED,
CURRENCY_CODE,
CONVERSION_RATE,
CONVERSION_TYPE_CODE,
CONVERSION_RATE_DATE,
INVOICE_TO_ORG_ID,
SHIP_TO_ORG_ID,
PURCHASE_ORDER_NUM,
ORDER_LINE_ID,
LINE_TYPE_ID,
LINE_CATEGORY_CODE,
PRICE_LIST_HEADER_ID,
LINE_NUMBER,
INVENTORY_ITEM_ID,
ITEM_REVISION,
SERIAL_NUMBER,
QUANTITY_REQUIRED,
UNIT_OF_MEASURE_CODE,
SELLING_PRICE,
AFTER_WARRANTY_COST,
--FUNC_CURR_AFT_WARR_COST, -- Obsolete column 11/13/2002 mviswana
BUSINESS_PROCESS_ID,
TRANSACTION_TYPE_ID,
CUSTOMER_PRODUCT_ID,
ORDER_HEADER_ID,
INSTALLED_CP_RETURN_BY_DATE,
NEW_CP_RETURN_BY_DATE,
INTERFACE_TO_OE_FLAG,
ROLLUP_FLAG,
NO_CHARGE_FLAG,
ADD_TO_ORDER_FLAG,
RETURN_REASON_CODE,
GENERATED_BY_BCA_ENGINE_FLAG,
TRANSACTION_INVENTORY_ORG,
TRANSACTION_SUB_INVENTORY,
CHARGE_LINE_TYPE,
SHIP_TO_ACCOUNT_ID,
INVOICE_TO_ACCOUNT_ID,
SHIP_TO_CONTACT_ID,
BILL_TO_CONTACT_ID,
LIST_PRICE,
ACTIVITY_START_DATE_TIME,
ACTIVITY_END_DATE_TIME,
CONTRACT_DISCOUNT_AMOUNT,
BILL_TO_PARTY_ID,
SHIP_TO_PARTY_ID,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CONTEXT,
COVERAGE_BILL_RATE_ID,
--Obsoleted to fix Bug # 3477626
-- COVERAGE_BILLING_TYPE_ID ,
TXN_BILLING_TYPE_ID,
SUBMIT_RESTRICTION_MESSAGE,
SUBMIT_ERROR_MESSAGE,
SUBMIT_FROM_SYSTEM,
LINE_SUBMITTED,
--EST_TAX_AMOUNT, -- Obsolete column 11/13/2002 mviswana
--TAX_CODE, --Obsolete column 11/13/2002 mviswana
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
OBJECT_VERSION_NUMBER)
VALUES (
P_ESTIMATE_DETAIL_ID,
P_ORG_ID,
p_INCIDENT_ID,
p_ORIGINAL_SOURCE_ID,
p_ORIGINAL_SOURCE_CODE,
p_SOURCE_ID,
p_SOURCE_CODE,
p_CONTRACT_LINE_ID,
p_RATE_TYPE_CODE,
p_CONTRACT_ID,
p_COVERAGE_ID,
p_COVERAGE_TXN_GROUP_ID,
--p_EXCEPTION_COVERAGE_USED,
p_CURRENCY_CODE,
p_CONVERSION_RATE,
p_CONVERSION_TYPE_CODE,
p_CONVERSION_RATE_DATE,
p_INVOICE_TO_ORG_ID,
p_SHIP_TO_ORG_ID,
p_PURCHASE_ORDER_NUM,
p_ORDER_LINE_ID,
p_LINE_TYPE_ID,
p_LINE_CATEGORY_CODE,
p_PRICE_LIST_HEADER_ID,
p_LINE_NUMBER,
p_INVENTORY_ITEM_ID,
p_ITEM_REVISION,
p_SERIAL_NUMBER,
p_QUANTITY_REQUIRED,
p_UNIT_OF_MEASURE_CODE,
p_SELLING_PRICE,
p_AFTER_WARRANTY_COST,
--p_FUNC_CURR_AFT_WARR_COST, -- Obsolete column 11/13/2002 mviswana
p_BUSINESS_PROCESS_ID,
p_TRANSACTION_TYPE_ID,
p_CUSTOMER_PRODUCT_ID,
p_ORDER_HEADER_ID,
p_INSTALLED_CP_RETURN_BY_DATE,
p_NEW_CP_RETURN_BY_DATE,
p_INTERFACE_TO_OE_FLAG,
p_ROLLUP_FLAG,
p_NO_CHARGE_FLAG,
p_ADD_TO_ORDER_FLAG,
p_RETURN_REASON_CODE,
p_GENERATED_BY_BCA_ENGINE_FLAG,
p_TRANSACTION_INVENTORY_ORG,
p_TRANSACTION_SUB_INVENTORY,
p_CHARGE_LINE_TYPE,
p_SHIP_TO_ACCOUNT_ID,
p_INVOICE_TO_ACCOUNT_ID,
p_SHIP_TO_CONTACT_ID,
p_BILL_TO_CONTACT_ID,
p_LIST_PRICE,
p_ACTIVITY_START_DATE_TIME,
p_ACTIVITY_END_DATE_TIME,
p_CONTRACT_DISCOUNT_AMOUNT,
p_BILL_TO_PARTY_ID,
p_SHIP_TO_PARTY_ID,
p_PRICING_CONTEXT,
p_PRICING_ATTRIBUTE1,
p_PRICING_ATTRIBUTE2,
p_PRICING_ATTRIBUTE3,
p_PRICING_ATTRIBUTE4,
p_PRICING_ATTRIBUTE5,
p_PRICING_ATTRIBUTE6,
p_PRICING_ATTRIBUTE7,
p_PRICING_ATTRIBUTE8,
p_PRICING_ATTRIBUTE9,
p_PRICING_ATTRIBUTE10,
p_PRICING_ATTRIBUTE11,
p_PRICING_ATTRIBUTE12,
p_PRICING_ATTRIBUTE13,
p_PRICING_ATTRIBUTE14,
p_PRICING_ATTRIBUTE15,
p_PRICING_ATTRIBUTE16,
p_PRICING_ATTRIBUTE17,
p_PRICING_ATTRIBUTE18,
p_PRICING_ATTRIBUTE19,
p_PRICING_ATTRIBUTE20,
p_PRICING_ATTRIBUTE21,
p_PRICING_ATTRIBUTE22,
p_PRICING_ATTRIBUTE23,
p_PRICING_ATTRIBUTE24,
p_PRICING_ATTRIBUTE25,
p_PRICING_ATTRIBUTE26,
p_PRICING_ATTRIBUTE27,
p_PRICING_ATTRIBUTE28,
p_PRICING_ATTRIBUTE29,
p_PRICING_ATTRIBUTE30,
p_PRICING_ATTRIBUTE31,
p_PRICING_ATTRIBUTE32,
p_PRICING_ATTRIBUTE33,
p_PRICING_ATTRIBUTE34,
p_PRICING_ATTRIBUTE35,
p_PRICING_ATTRIBUTE36,
p_PRICING_ATTRIBUTE37,
p_PRICING_ATTRIBUTE38,
p_PRICING_ATTRIBUTE39,
p_PRICING_ATTRIBUTE40,
p_PRICING_ATTRIBUTE41,
p_PRICING_ATTRIBUTE42,
p_PRICING_ATTRIBUTE43,
p_PRICING_ATTRIBUTE44,
p_PRICING_ATTRIBUTE45,
p_PRICING_ATTRIBUTE46,
p_PRICING_ATTRIBUTE47,
p_PRICING_ATTRIBUTE48,
p_PRICING_ATTRIBUTE49,
p_PRICING_ATTRIBUTE50,
p_PRICING_ATTRIBUTE51,
p_PRICING_ATTRIBUTE52,
p_PRICING_ATTRIBUTE53,
p_PRICING_ATTRIBUTE54,
p_PRICING_ATTRIBUTE55,
p_PRICING_ATTRIBUTE56,
p_PRICING_ATTRIBUTE57,
p_PRICING_ATTRIBUTE58,
p_PRICING_ATTRIBUTE59,
p_PRICING_ATTRIBUTE60,
p_PRICING_ATTRIBUTE61,
p_PRICING_ATTRIBUTE62,
p_PRICING_ATTRIBUTE63,
p_PRICING_ATTRIBUTE64,
p_PRICING_ATTRIBUTE65,
p_PRICING_ATTRIBUTE66,
p_PRICING_ATTRIBUTE67,
p_PRICING_ATTRIBUTE68,
p_PRICING_ATTRIBUTE69,
p_PRICING_ATTRIBUTE70,
p_PRICING_ATTRIBUTE71,
p_PRICING_ATTRIBUTE72,
p_PRICING_ATTRIBUTE73,
p_PRICING_ATTRIBUTE74,
p_PRICING_ATTRIBUTE75,
p_PRICING_ATTRIBUTE76,
p_PRICING_ATTRIBUTE77,
p_PRICING_ATTRIBUTE78,
p_PRICING_ATTRIBUTE79,
p_PRICING_ATTRIBUTE80,
p_PRICING_ATTRIBUTE81,
p_PRICING_ATTRIBUTE82,
p_PRICING_ATTRIBUTE83,
p_PRICING_ATTRIBUTE84,
p_PRICING_ATTRIBUTE85,
p_PRICING_ATTRIBUTE86,
p_PRICING_ATTRIBUTE87,
p_PRICING_ATTRIBUTE88,
p_PRICING_ATTRIBUTE89,
p_PRICING_ATTRIBUTE90,
p_PRICING_ATTRIBUTE91,
p_PRICING_ATTRIBUTE92,
p_PRICING_ATTRIBUTE93,
p_PRICING_ATTRIBUTE94,
p_PRICING_ATTRIBUTE95,
p_PRICING_ATTRIBUTE96,
p_PRICING_ATTRIBUTE97,
p_PRICING_ATTRIBUTE98,
p_PRICING_ATTRIBUTE99,
p_PRICING_ATTRIBUTE100,
p_ATTRIBUTE1,
p_ATTRIBUTE2,
p_ATTRIBUTE3,
p_ATTRIBUTE4,
p_ATTRIBUTE5,
p_ATTRIBUTE6,
p_ATTRIBUTE7,
p_ATTRIBUTE8,
p_ATTRIBUTE9,
p_ATTRIBUTE10,
p_ATTRIBUTE11,
p_ATTRIBUTE12,
p_ATTRIBUTE13,
p_ATTRIBUTE14,
p_ATTRIBUTE15,
p_CONTEXT,
p_COVERAGE_BILL_RATE_ID,
--Obsoleted to fix Bug # 3477626
-- P_COVERAGE_BILLING_TYPE_ID ,
p_TXN_BILLING_TYPE_ID,
p_SUBMIT_RESTRICTION_MESSAGE , -- Added Column mviswana 07/23/2003
p_SUBMIT_ERROR_MESSAGE, -- Added Column mviswana 07/23/2003
p_SUBMIT_FROM_SYSTEM, -- Added Column mviswana 07/23/2003
p_LINE_SUBMITTED, -- Added Column mviswana 07/23/2003
--p_EST_TAX_AMOUNT, -- Obsolete column 11/13/2002 mviswana
--p_TAX_CODE, -- Obsolete column 11/13/2002 mviswana
p_LAST_UPDATE_DATE,
p_LAST_UPDATE_LOGIN,
p_LAST_UPDATED_BY,
p_CREATION_DATE,
p_CREATED_BY,
1
);
-- dbms_output.put_line('after insert into cs_estimate_details');
End Insert_Row;
PROCEDURE Update_Row(
X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
p_ESTIMATE_DETAIL_ID NUMBER,
p_ORG_ID NUMBER,
p_INCIDENT_ID NUMBER,
p_ORIGINAL_SOURCE_ID NUMBER,
p_ORIGINAL_SOURCE_CODE VARCHAR2,
p_SOURCE_ID NUMBER,
p_SOURCE_CODE VARCHAR2,
p_CONTRACT_LINE_ID NUMBER,
p_RATE_TYPE_CODE VARCHAR2,
p_CONTRACT_ID NUMBER,
p_COVERAGE_ID NUMBER,
p_COVERAGE_TXN_GROUP_ID NUMBER,
--p_EXCEPTION_COVERAGE_USED VARCHAR2,
p_CURRENCY_CODE VARCHAR2,
p_CONVERSION_RATE NUMBER,
p_CONVERSION_TYPE_CODE VARCHAR2,
p_CONVERSION_RATE_DATE DATE,
p_INVOICE_TO_ORG_ID NUMBER,
p_SHIP_TO_ORG_ID NUMBER,
p_PURCHASE_ORDER_NUM VARCHAR2,
p_ORDER_LINE_ID NUMBER,
p_LINE_TYPE_ID NUMBER,
p_LINE_CATEGORY_CODE VARCHAR2,
p_PRICE_LIST_HEADER_ID NUMBER,
p_LINE_NUMBER NUMBER,
p_INVENTORY_ITEM_ID NUMBER,
p_ITEM_REVISION VARCHAR2,
p_SERIAL_NUMBER VARCHAR2,
p_QUANTITY_REQUIRED NUMBER,
p_UNIT_OF_MEASURE_CODE VARCHAR2,
p_SELLING_PRICE NUMBER,
p_AFTER_WARRANTY_COST NUMBER,
--p_FUNC_CURR_AFT_WARR_COST NUMBER, -- Obsolete column 11/13/2002 mviswana
p_BUSINESS_PROCESS_ID NUMBER,
p_TRANSACTION_TYPE_ID NUMBER,
p_CUSTOMER_PRODUCT_ID NUMBER,
p_ORDER_HEADER_ID NUMBER,
p_INSTALLED_CP_RETURN_BY_DATE DATE,
p_NEW_CP_RETURN_BY_DATE DATE,
p_INTERFACE_TO_OE_FLAG VARCHAR2,
p_ROLLUP_FLAG VARCHAR2,
p_NO_CHARGE_FLAG VARCHAR2,
p_ADD_TO_ORDER_FLAG VARCHAR2,
p_RETURN_REASON_CODE VARCHAR2,
p_GENERATED_BY_BCA_ENGINE_FLAG VARCHAR2,
p_TRANSACTION_INVENTORY_ORG NUMBER,
p_TRANSACTION_SUB_INVENTORY VARCHAR2,
p_CHARGE_LINE_TYPE VARCHAR2,
p_SHIP_TO_ACCOUNT_ID NUMBER,
p_INVOICE_TO_ACCOUNT_ID NUMBER,
p_SHIP_TO_CONTACT_ID NUMBER,
p_BILL_TO_CONTACT_ID NUMBER,
p_LIST_PRICE NUMBER,
p_ACTIVITY_START_DATE_TIME DATE,
p_ACTIVITY_END_DATE_TIME DATE,
p_CONTRACT_DISCOUNT_AMOUNT NUMBER,
p_BILL_TO_PARTY_ID NUMBER,
p_SHIP_TO_PARTY_ID NUMBER,
p_PRICING_CONTEXT VARCHAR2,
p_PRICING_ATTRIBUTE1 VARCHAR2,
p_PRICING_ATTRIBUTE2 VARCHAR2,
p_PRICING_ATTRIBUTE3 VARCHAR2,
p_PRICING_ATTRIBUTE4 VARCHAR2,
p_PRICING_ATTRIBUTE5 VARCHAR2,
p_PRICING_ATTRIBUTE6 VARCHAR2,
p_PRICING_ATTRIBUTE7 VARCHAR2,
p_PRICING_ATTRIBUTE8 VARCHAR2,
p_PRICING_ATTRIBUTE9 VARCHAR2,
p_PRICING_ATTRIBUTE10 VARCHAR2,
p_PRICING_ATTRIBUTE11 VARCHAR2,
p_PRICING_ATTRIBUTE12 VARCHAR2,
p_PRICING_ATTRIBUTE13 VARCHAR2,
p_PRICING_ATTRIBUTE14 VARCHAR2,
p_PRICING_ATTRIBUTE15 VARCHAR2,
p_PRICING_ATTRIBUTE16 VARCHAR2,
p_PRICING_ATTRIBUTE17 VARCHAR2,
p_PRICING_ATTRIBUTE18 VARCHAR2,
p_PRICING_ATTRIBUTE19 VARCHAR2,
p_PRICING_ATTRIBUTE20 VARCHAR2,
p_PRICING_ATTRIBUTE21 VARCHAR2,
p_PRICING_ATTRIBUTE22 VARCHAR2,
p_PRICING_ATTRIBUTE23 VARCHAR2,
p_PRICING_ATTRIBUTE24 VARCHAR2,
p_PRICING_ATTRIBUTE25 VARCHAR2,
p_PRICING_ATTRIBUTE26 VARCHAR2,
p_PRICING_ATTRIBUTE27 VARCHAR2,
p_PRICING_ATTRIBUTE28 VARCHAR2,
p_PRICING_ATTRIBUTE29 VARCHAR2,
p_PRICING_ATTRIBUTE30 VARCHAR2,
p_PRICING_ATTRIBUTE31 VARCHAR2,
p_PRICING_ATTRIBUTE32 VARCHAR2,
p_PRICING_ATTRIBUTE33 VARCHAR2,
p_PRICING_ATTRIBUTE34 VARCHAR2,
p_PRICING_ATTRIBUTE35 VARCHAR2,
p_PRICING_ATTRIBUTE36 VARCHAR2,
p_PRICING_ATTRIBUTE37 VARCHAR2,
p_PRICING_ATTRIBUTE38 VARCHAR2,
p_PRICING_ATTRIBUTE39 VARCHAR2,
p_PRICING_ATTRIBUTE40 VARCHAR2,
p_PRICING_ATTRIBUTE41 VARCHAR2,
p_PRICING_ATTRIBUTE42 VARCHAR2,
p_PRICING_ATTRIBUTE43 VARCHAR2,
p_PRICING_ATTRIBUTE44 VARCHAR2,
p_PRICING_ATTRIBUTE45 VARCHAR2,
p_PRICING_ATTRIBUTE46 VARCHAR2,
p_PRICING_ATTRIBUTE47 VARCHAR2,
p_PRICING_ATTRIBUTE48 VARCHAR2,
p_PRICING_ATTRIBUTE49 VARCHAR2,
p_PRICING_ATTRIBUTE50 VARCHAR2,
p_PRICING_ATTRIBUTE51 VARCHAR2,
p_PRICING_ATTRIBUTE52 VARCHAR2,
p_PRICING_ATTRIBUTE53 VARCHAR2,
p_PRICING_ATTRIBUTE54 VARCHAR2,
p_PRICING_ATTRIBUTE55 VARCHAR2,
p_PRICING_ATTRIBUTE56 VARCHAR2,
p_PRICING_ATTRIBUTE57 VARCHAR2,
p_PRICING_ATTRIBUTE58 VARCHAR2,
p_PRICING_ATTRIBUTE59 VARCHAR2,
p_PRICING_ATTRIBUTE60 VARCHAR2,
p_PRICING_ATTRIBUTE61 VARCHAR2,
p_PRICING_ATTRIBUTE62 VARCHAR2,
p_PRICING_ATTRIBUTE63 VARCHAR2,
p_PRICING_ATTRIBUTE64 VARCHAR2,
p_PRICING_ATTRIBUTE65 VARCHAR2,
p_PRICING_ATTRIBUTE66 VARCHAR2,
p_PRICING_ATTRIBUTE67 VARCHAR2,
p_PRICING_ATTRIBUTE68 VARCHAR2,
p_PRICING_ATTRIBUTE69 VARCHAR2,
p_PRICING_ATTRIBUTE70 VARCHAR2,
p_PRICING_ATTRIBUTE71 VARCHAR2,
p_PRICING_ATTRIBUTE72 VARCHAR2,
p_PRICING_ATTRIBUTE73 VARCHAR2,
p_PRICING_ATTRIBUTE74 VARCHAR2,
p_PRICING_ATTRIBUTE75 VARCHAR2,
p_PRICING_ATTRIBUTE76 VARCHAR2,
p_PRICING_ATTRIBUTE77 VARCHAR2,
p_PRICING_ATTRIBUTE78 VARCHAR2,
p_PRICING_ATTRIBUTE79 VARCHAR2,
p_PRICING_ATTRIBUTE80 VARCHAR2,
p_PRICING_ATTRIBUTE81 VARCHAR2,
p_PRICING_ATTRIBUTE82 VARCHAR2,
p_PRICING_ATTRIBUTE83 VARCHAR2,
p_PRICING_ATTRIBUTE84 VARCHAR2,
p_PRICING_ATTRIBUTE85 VARCHAR2,
p_PRICING_ATTRIBUTE86 VARCHAR2,
p_PRICING_ATTRIBUTE87 VARCHAR2,
p_PRICING_ATTRIBUTE88 VARCHAR2,
p_PRICING_ATTRIBUTE89 VARCHAR2,
p_PRICING_ATTRIBUTE90 VARCHAR2,
p_PRICING_ATTRIBUTE91 VARCHAR2,
p_PRICING_ATTRIBUTE92 VARCHAR2,
p_PRICING_ATTRIBUTE93 VARCHAR2,
p_PRICING_ATTRIBUTE94 VARCHAR2,
p_PRICING_ATTRIBUTE95 VARCHAR2,
p_PRICING_ATTRIBUTE96 VARCHAR2,
p_PRICING_ATTRIBUTE97 VARCHAR2,
p_PRICING_ATTRIBUTE98 VARCHAR2,
p_PRICING_ATTRIBUTE99 VARCHAR2,
p_PRICING_ATTRIBUTE100 VARCHAR2,
p_ATTRIBUTE1 VARCHAR2,
p_ATTRIBUTE2 VARCHAR2,
p_ATTRIBUTE3 VARCHAR2,
p_ATTRIBUTE4 VARCHAR2,
p_ATTRIBUTE5 VARCHAR2,
p_ATTRIBUTE6 VARCHAR2,
p_ATTRIBUTE7 VARCHAR2,
p_ATTRIBUTE8 VARCHAR2,
p_ATTRIBUTE9 VARCHAR2,
p_ATTRIBUTE10 VARCHAR2,
p_ATTRIBUTE11 VARCHAR2,
p_ATTRIBUTE12 VARCHAR2,
p_ATTRIBUTE13 VARCHAR2,
p_ATTRIBUTE14 VARCHAR2,
p_ATTRIBUTE15 VARCHAR2,
p_CONTEXT VARCHAR2,
p_COVERAGE_BILL_RATE_ID NUMBER,
P_COVERAGE_BILLING_TYPE_ID NUMBER,
p_TXN_BILLING_TYPE_ID NUMBER,
p_SUBMIT_RESTRICTION_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
p_SUBMIT_ERROR_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
p_SUBMIT_FROM_SYSTEM VARCHAR2, -- Added Column mviswana 07/23/2003
p_LINE_SUBMITTED VARCHAR2, -- Added Column mviswana 07/23/2003
--p_EST_TAX_AMOUNT NUMBER, -- Obsolete column 11/13/2002 mviswana
--p_TAX_CODE VARCHAR2, -- Obsolete column 11/13/2002 mviswana
p_LAST_UPDATE_DATE DATE,
p_LAST_UPDATE_LOGIN NUMBER,
p_LAST_UPDATED_BY NUMBER,
p_CREATION_DATE DATE,
p_CREATED_BY NUMBER)
IS
CURSOR C2 IS
SELECT OBJECT_VERSION_NUMBER
FROM CS_ESTIMATE_DETAILS
WHERE estimate_detail_id = p_estimate_detail_id;
Update CS_ESTIMATE_DETAILS
SET
/* INCIDENT_ID = p_INCIDENT_ID,
ORG_ID = p_ORG_ID,
ORIGINAL_SOURCE_ID = p_ORIGINAL_SOURCE_ID,
ORIGINAL_SOURCE_CODE = p_ORIGINAL_SOURCE_CODE,
SOURCE_ID = p_SOURCE_ID,
SOURCE_CODE = p_SOURCE_CODE,
CONTRACT_ID = p_CONTRACT_ID,
COVERAGE_ID = p_COVERAGE_ID,
COVERAGE_TXN_GROUP_ID = p_COVERAGE_TXN_GROUP_ID,
--EXCEPTION_COVERAGE_USED = p_EXCEPTION_COVERAGE_USED,
CURRENCY_CODE = p_CURRENCY_CODE,
CONVERSION_RATE = p_CONVERSION_RATE,
CONVERSION_TYPE_CODE = p_CONVERSION_TYPE_CODE ,
CONVERSION_RATE_DATE = p_CONVERSION_RATE_DATE ,
INVOICE_TO_ORG_ID = p_INVOICE_TO_ORG_ID,
SHIP_TO_ORG_ID = p_SHIP_TO_ORG_ID,
PURCHASE_ORDER_NUM = p_PURCHASE_ORDER_NUM,
ORDER_LINE_ID = p_ORDER_LINE_ID, -- Obsolete column 11/13/2002 mviswana
LINE_TYPE_ID = p_LINE_TYPE_ID, -- Obsolete column 11/13/2002 mviswana
LINE_CATEGORY_CODE = p_LINE_CATEGORY_CODE,
PRICE_LIST_HEADER_ID = p_PRICE_LIST_HEADER_ID,
LINE_NUMBER = p_LINE_NUMBER,
INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID,
ITEM_REVISION = p_ITEM_REVISION,
SERIAL_NUMBER = p_SERIAL_NUMBER,
QUANTITY_REQUIRED = p_QUANTITY_REQUIRED,
UNIT_OF_MEASURE_CODE = p_UNIT_OF_MEASURE_CODE,
SELLING_PRICE = p_SELLING_PRICE,
AFTER_WARRANTY_COST = p_AFTER_WARRANTY_COST,
--FUNC_CURR_AFT_WARR_COST = p_FUNC_CURR_AFT_WARR_COST, -- Obsolete column 11/13/2002 mviswana
BUSINESS_PROCESS_ID = p_BUSINESS_PROCESS_ID,
TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID,
CUSTOMER_PRODUCT_ID = p_CUSTOMER_PRODUCT_ID,
ORDER_HEADER_ID = p_ORDER_HEADER_ID,
INSTALLED_CP_RETURN_BY_DATE = p_INSTALLED_CP_RETURN_BY_DATE,
NEW_CP_RETURN_BY_DATE = p_NEW_CP_RETURN_BY_DATE,
INTERFACE_TO_OE_FLAG = p_INTERFACE_TO_OE_FLAG,
ROLLUP_FLAG = p_ROLLUP_FLAG,
NO_CHARGE_FLAG = p_NO_CHARGE_FLAG,
ADD_TO_ORDER_FLAG = p_ADD_TO_ORDER_FLAG,
RETURN_REASON_CODE = p_RETURN_REASON_CODE,
GENERATED_BY_BCA_ENGINE_FLAG = p_GENERATED_BY_BCA_ENGINE_FLAG,
TRANSACTION_INVENTORY_ORG = p_TRANSACTION_INVENTORY_ORG,
TRANSACTION_SUB_INVENTORY = p_TRANSACTION_SUB_INVENTORY,
CHARGE_LINE_TYPE = p_CHARGE_LINE_TYPE,
SHIP_TO_ACCOUNT_ID = p_SHIP_TO_ACCOUNT_ID,
INVOICE_TO_ACCOUNT_ID = p_INVOICE_TO_ACCOUNT_ID,
SHIP_TO_CONTACT_ID = p_SHIP_TO_CONTACT_ID,
BILL_TO_CONTACT_ID = p_BILL_TO_CONTACT_ID,
LIST_PRICE = p_LIST_PRICE,
ACTIVITY_START_DATE_TIME = p_ACTIVITY_START_DATE_TIME,
ACTIVITY_END_DATE_TIME = p_ACTIVITY_END_DATE_TIME,
CONTRACT_DISCOUNT_AMOUNT = p_CONTRACT_DISCOUNT_AMOUNT,
BILL_TO_PARTY_ID = p_BILL_TO_PARTY_ID,
SHIP_TO_PARTY_ID = p_SHIP_TO_PARTY_ID,
PRICING_CONTEXT = p_PRICING_CONTEXT,
PRICING_ATTRIBUTE1 = p_PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2 = p_PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3 = p_PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4 = p_PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5 = p_PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6 = p_PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7 = p_PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8 = p_PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9 = p_PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10 = p_PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11 = p_PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12 = p_PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13 = p_PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14 = p_PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15 = p_PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16 = p_PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17 = p_PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18 = p_PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19 = p_PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20 = p_PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21 = p_PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22 = p_PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23 = p_PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24 = p_PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25 = p_PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26 = p_PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27 = p_PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28 = p_PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29 = p_PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30 = p_PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31 = p_PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32 = p_PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33 = p_PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34 = p_PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35 = p_PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36 = p_PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37 = p_PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38 = p_PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39 = p_PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40 = p_PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41 = p_PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42 = p_PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43 = p_PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44 = p_PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45 = p_PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46 = p_PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47 = p_PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48 = p_PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49 = p_PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50 = p_PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51 = p_PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52 = p_PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53 = p_PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54 = p_PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55 = p_PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56 = p_PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57 = p_PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58 = p_PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59 = p_PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60 = p_PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61 = p_PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62 = p_PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63 = p_PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64 = p_PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65 = p_PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66 = p_PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67 = p_PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68 = p_PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69 = p_PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70 = p_PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71 = p_PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72 = p_PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73 = p_PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74 = p_PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75 = p_PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76 = p_PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77 = p_PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78 = p_PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79 = p_PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80 = p_PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81 = p_PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82 = p_PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83 = p_PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84 = p_PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85 = p_PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86 = p_PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87 = p_PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88 = p_PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89 = p_PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90 = p_PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91 = p_PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92 = p_PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93 = p_PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94 = p_PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95 = p_PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96 = p_PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97 = p_PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98 = p_PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99 = p_PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100 = p_PRICING_ATTRIBUTE100,
ATTRIBUTE1 = p_ATTRIBUTE1,
ATTRIBUTE2 = p_ATTRIBUTE2,
ATTRIBUTE3 = p_ATTRIBUTE3,
ATTRIBUTE4 = p_ATTRIBUTE4,
ATTRIBUTE5 = p_ATTRIBUTE5,
ATTRIBUTE6 = p_ATTRIBUTE6,
ATTRIBUTE7 = p_ATTRIBUTE7,
ATTRIBUTE8 = p_ATTRIBUTE8,
ATTRIBUTE9 = p_ATTRIBUTE9,
ATTRIBUTE10 = p_ATTRIBUTE10,
ATTRIBUTE11 = p_ATTRIBUTE11,
ATTRIBUTE12 = p_ATTRIBUTE12,
ATTRIBUTE13 = p_ATTRIBUTE13,
ATTRIBUTE14 = p_ATTRIBUTE14,
ATTRIBUTE15 = p_ATTRIBUTE15,
CONTEXT = p_CONTEXT,
COVERAGE_BILL_RATE_ID = p_COVERAGE_BILL_RATE_ID,
TXN_BILLING_TYPE_ID = p_TXN_BILLING_TYPE_ID,
--EST_TAX_AMOUNT = p_EST_TAX_AMOUNT, -- Obsolete column 11/13/2002 mviswana
--TAX_CODE = p_TAX_CODE, -- Obsolete column 11/13/2002 mviswana
LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
LAST_UPDATED_BY = p_LAST_UPDATED_BY,
CREATION_DATE = p_CREATION_DATE,
CREATED_BY = p_CREATED_BY,
OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1 */
INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID),
ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
ORIGINAL_SOURCE_ID = decode( to_char(p_ORIGINAL_SOURCE_ID), FND_API.G_MISS_CHAR, ORIGINAL_SOURCE_ID, to_char(p_ORIGINAL_SOURCE_ID)),
ORIGINAL_SOURCE_CODE = decode( p_ORIGINAL_SOURCE_CODE, FND_API.G_MISS_CHAR, ORIGINAL_SOURCE_CODE, p_ORIGINAL_SOURCE_CODE),
SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID),
SOURCE_CODE = decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, SOURCE_CODE, p_SOURCE_CODE),
CONTRACT_LINE_ID = DECODE( p_CONTRACT_LINE_ID,FND_API.G_MISS_NUM,CONTRACT_LINE_ID, p_CONTRACT_LINE_ID),
RATE_TYPE_CODE = DECODE(p_RATE_TYPE_CODE,FND_API.G_MISS_CHAR,RATE_TYPE_CODE, p_RATE_TYPE_CODE),
CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID),
COVERAGE_ID = decode( p_COVERAGE_ID, FND_API.G_MISS_NUM, COVERAGE_ID, p_COVERAGE_ID),
COVERAGE_TXN_GROUP_ID = decode( p_COVERAGE_TXN_GROUP_ID, FND_API.G_MISS_NUM, COVERAGE_TXN_GROUP_ID, p_COVERAGE_TXN_GROUP_ID),
--EXCEPTION_COVERAGE_USED = decode( p_EXCEPTION_COVERAGE_USED, FND_API.G_MISS_CHAR, EXCEPTION_COVERAGE_USED, p_EXCEPTION_COVERAGE_USED),
CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
CONVERSION_RATE = decode( p_CONVERSION_RATE, FND_API.G_MISS_NUM, CONVERSION_RATE, p_CONVERSION_RATE),
CONVERSION_TYPE_CODE = decode( p_CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR, CONVERSION_TYPE_CODE, p_CONVERSION_TYPE_CODE),
CONVERSION_RATE_DATE = decode( p_CONVERSION_RATE_DATE, FND_API.G_MISS_DATE, CONVERSION_RATE_DATE, p_CONVERSION_RATE_DATE),
INVOICE_TO_ORG_ID = decode( p_INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM, INVOICE_TO_ORG_ID, p_INVOICE_TO_ORG_ID),
SHIP_TO_ORG_ID = decode( p_SHIP_TO_ORG_ID, FND_API.G_MISS_NUM, SHIP_TO_ORG_ID, p_SHIP_TO_ORG_ID),
PURCHASE_ORDER_NUM = decode( p_PURCHASE_ORDER_NUM, FND_API.G_MISS_CHAR, PURCHASE_ORDER_NUM, p_PURCHASE_ORDER_NUM),
ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
LINE_TYPE_ID = decode( p_LINE_TYPE_ID, FND_API.G_MISS_NUM, LINE_TYPE_ID, p_LINE_TYPE_ID),
LINE_CATEGORY_CODE = decode( p_LINE_CATEGORY_CODE, FND_API.G_MISS_CHAR, LINE_CATEGORY_CODE, p_LINE_CATEGORY_CODE),
PRICE_LIST_HEADER_ID = decode( p_PRICE_LIST_HEADER_ID, FND_API.G_MISS_NUM, PRICE_LIST_HEADER_ID, p_PRICE_LIST_HEADER_ID),
LINE_NUMBER = decode( p_LINE_NUMBER, FND_API.G_MISS_NUM, LINE_NUMBER, p_LINE_NUMBER),
INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION),
SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
QUANTITY_REQUIRED = decode( p_QUANTITY_REQUIRED, FND_API.G_MISS_NUM, QUANTITY_REQUIRED, p_QUANTITY_REQUIRED),
UNIT_OF_MEASURE_CODE = decode( p_UNIT_OF_MEASURE_CODE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE_CODE, p_UNIT_OF_MEASURE_CODE),
SELLING_PRICE = decode( p_SELLING_PRICE, FND_API.G_MISS_NUM, SELLING_PRICE, p_SELLING_PRICE),
AFTER_WARRANTY_COST = decode( p_AFTER_WARRANTY_COST, FND_API.G_MISS_NUM, AFTER_WARRANTY_COST, p_AFTER_WARRANTY_COST),
--FUNC_CURR_AFT_WARR_COST = decode( p_FUNC_CURR_AFT_WARR_COST, FND_API.G_MISS_NUM, FUNC_CURR_AFT_WARR_COST, p_FUNC_CURR_AFT_WARR_COST),
-- Obsolete column 11/13/2002 mviswana
BUSINESS_PROCESS_ID = decode( p_BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, p_BUSINESS_PROCESS_ID),
TRANSACTION_TYPE_ID = decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, p_TRANSACTION_TYPE_ID),
CUSTOMER_PRODUCT_ID = decode( p_CUSTOMER_PRODUCT_ID, FND_API.G_MISS_NUM, CUSTOMER_PRODUCT_ID, p_CUSTOMER_PRODUCT_ID),
ORDER_HEADER_ID = decode( p_ORDER_HEADER_ID, FND_API.G_MISS_NUM, ORDER_HEADER_ID, p_ORDER_HEADER_ID),
INSTALLED_CP_RETURN_BY_DATE = decode( p_INSTALLED_CP_RETURN_BY_DATE, FND_API.G_MISS_DATE, INSTALLED_CP_RETURN_BY_DATE, p_INSTALLED_CP_RETURN_BY_DATE),
NEW_CP_RETURN_BY_DATE = decode( p_NEW_CP_RETURN_BY_DATE, FND_API.G_MISS_DATE, NEW_CP_RETURN_BY_DATE, p_NEW_CP_RETURN_BY_DATE),
INTERFACE_TO_OE_FLAG = decode( p_INTERFACE_TO_OE_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OE_FLAG, p_INTERFACE_TO_OE_FLAG),
ROLLUP_FLAG = decode( p_ROLLUP_FLAG, FND_API.G_MISS_CHAR, ROLLUP_FLAG, p_ROLLUP_FLAG),
NO_CHARGE_FLAG = decode( p_NO_CHARGE_FLAG, FND_API.G_MISS_CHAR, NO_CHARGE_FLAG, p_NO_CHARGE_FLAG),
ADD_TO_ORDER_FLAG = decode( p_ADD_TO_ORDER_FLAG, FND_API.G_MISS_CHAR, ADD_TO_ORDER_FLAG, p_ADD_TO_ORDER_FLAG),
RETURN_REASON_CODE = decode( p_RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, p_RETURN_REASON_CODE),
GENERATED_BY_BCA_ENGINE_FLAG = decode(p_GENERATED_BY_BCA_ENGINE_FLAG,FND_API.G_MISS_CHAR,GENERATED_BY_BCA_ENGINE_FLAG,p_GENERATED_BY_BCA_ENGINE_FLAG),
TRANSACTION_INVENTORY_ORG = decode(p_TRANSACTION_INVENTORY_ORG,FND_API.G_MISS_NUM,TRANSACTION_INVENTORY_ORG,p_TRANSACTION_INVENTORY_ORG),
TRANSACTION_SUB_INVENTORY = decode(p_TRANSACTION_SUB_INVENTORY,FND_API.G_MISS_CHAR,TRANSACTION_SUB_INVENTORY,p_TRANSACTION_SUB_INVENTORY),
CHARGE_LINE_TYPE = decode(p_CHARGE_LINE_TYPE,FND_API.G_MISS_CHAR,CHARGE_LINE_TYPE,p_CHARGE_LINE_TYPE),
SHIP_TO_ACCOUNT_ID = decode(p_SHIP_TO_ACCOUNT_ID,FND_API.G_MISS_NUM,SHIP_TO_ACCOUNT_ID,p_SHIP_TO_ACCOUNT_ID),
INVOICE_TO_ACCOUNT_ID = decode(p_INVOICE_TO_ACCOUNT_ID,FND_API.G_MISS_NUM,INVOICE_TO_ACCOUNT_ID,p_INVOICE_TO_ACCOUNT_ID),
SHIP_TO_CONTACT_ID = decode(p_SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM,SHIP_TO_CONTACT_ID,p_SHIP_TO_CONTACT_ID),
BILL_TO_CONTACT_ID = decode(p_BILL_TO_CONTACT_ID,FND_API.G_MISS_NUM,BILL_TO_CONTACT_ID,p_BILL_TO_CONTACT_ID),
LIST_PRICE = decode(p_LIST_PRICE,FND_API.G_MISS_NUM,LIST_PRICE,p_LIST_PRICE),
ACTIVITY_START_DATE_TIME = decode(p_ACTIVITY_START_DATE_TIME,FND_API.G_MISS_DATE,ACTIVITY_START_DATE_TIME,p_ACTIVITY_START_DATE_TIME),
ACTIVITY_END_DATE_TIME = decode(p_ACTIVITY_END_DATE_TIME,FND_API.G_MISS_DATE,ACTIVITY_END_DATE_TIME,p_ACTIVITY_END_DATE_TIME),
CONTRACT_DISCOUNT_AMOUNT = decode(p_CONTRACT_DISCOUNT_AMOUNT,FND_API.G_MISS_NUM,CONTRACT_DISCOUNT_AMOUNT,p_CONTRACT_DISCOUNT_AMOUNT),
BILL_TO_PARTY_ID = decode(p_BILL_TO_PARTY_ID,FND_API.G_MISS_NUM,BILL_TO_PARTY_ID,p_BILL_TO_PARTY_ID),
SHIP_TO_PARTY_ID = decode(p_SHIP_TO_PARTY_ID,FND_API.G_MISS_NUM,SHIP_TO_PARTY_ID,p_SHIP_TO_PARTY_ID),
PRICING_CONTEXT = decode( p_PRICING_CONTEXT, FND_API.G_MISS_CHAR, PRICING_CONTEXT, p_PRICING_CONTEXT),
PRICING_ATTRIBUTE1 = decode( p_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE1, p_PRICING_ATTRIBUTE1),
PRICING_ATTRIBUTE2 = decode( p_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE2, p_PRICING_ATTRIBUTE2),
PRICING_ATTRIBUTE3 = decode( p_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE3, p_PRICING_ATTRIBUTE3),
PRICING_ATTRIBUTE4 = decode( p_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE4, p_PRICING_ATTRIBUTE4),
PRICING_ATTRIBUTE5 = decode( p_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE5, p_PRICING_ATTRIBUTE5),
PRICING_ATTRIBUTE6 = decode( p_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE6, p_PRICING_ATTRIBUTE6),
PRICING_ATTRIBUTE7 = decode( p_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE7, p_PRICING_ATTRIBUTE7),
PRICING_ATTRIBUTE8 = decode( p_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE8, p_PRICING_ATTRIBUTE8),
PRICING_ATTRIBUTE9 = decode( p_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE9, p_PRICING_ATTRIBUTE9),
PRICING_ATTRIBUTE10 = decode( p_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE10, p_PRICING_ATTRIBUTE10),
PRICING_ATTRIBUTE11 = decode( p_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE11, p_PRICING_ATTRIBUTE11),
PRICING_ATTRIBUTE12 = decode( p_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE12, p_PRICING_ATTRIBUTE12),
PRICING_ATTRIBUTE13 = decode( p_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE13, p_PRICING_ATTRIBUTE13),
PRICING_ATTRIBUTE14 = decode( p_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE14, p_PRICING_ATTRIBUTE14),
PRICING_ATTRIBUTE15 = decode( p_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE15, p_PRICING_ATTRIBUTE15),
PRICING_ATTRIBUTE16 = decode( p_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE16, p_PRICING_ATTRIBUTE16),
PRICING_ATTRIBUTE17 = decode( p_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE17, p_PRICING_ATTRIBUTE17),
PRICING_ATTRIBUTE18 = decode( p_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE18, p_PRICING_ATTRIBUTE18),
PRICING_ATTRIBUTE19 = decode( p_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE19, p_PRICING_ATTRIBUTE19),
PRICING_ATTRIBUTE20 = decode( p_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE20, p_PRICING_ATTRIBUTE20),
PRICING_ATTRIBUTE21 = decode( p_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE21, p_PRICING_ATTRIBUTE21),
PRICING_ATTRIBUTE22 = decode( p_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE22, p_PRICING_ATTRIBUTE22),
PRICING_ATTRIBUTE23 = decode( p_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE23, p_PRICING_ATTRIBUTE23),
PRICING_ATTRIBUTE24 = decode( p_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE24, p_PRICING_ATTRIBUTE24),
PRICING_ATTRIBUTE25 = decode( p_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE25, p_PRICING_ATTRIBUTE25),
PRICING_ATTRIBUTE26 = decode( p_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE26, p_PRICING_ATTRIBUTE26),
PRICING_ATTRIBUTE27 = decode( p_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE27, p_PRICING_ATTRIBUTE27),
PRICING_ATTRIBUTE28 = decode( p_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE28, p_PRICING_ATTRIBUTE28),
PRICING_ATTRIBUTE29 = decode( p_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE29, p_PRICING_ATTRIBUTE29),
PRICING_ATTRIBUTE30 = decode( p_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE30, p_PRICING_ATTRIBUTE30),
PRICING_ATTRIBUTE31 = decode( p_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE31, p_PRICING_ATTRIBUTE31),
PRICING_ATTRIBUTE32 = decode( p_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE32, p_PRICING_ATTRIBUTE32),
PRICING_ATTRIBUTE33 = decode( p_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE33, p_PRICING_ATTRIBUTE33),
PRICING_ATTRIBUTE34 = decode( p_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE34, p_PRICING_ATTRIBUTE34),
PRICING_ATTRIBUTE35 = decode( p_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE35, p_PRICING_ATTRIBUTE35),
PRICING_ATTRIBUTE36 = decode( p_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE36, p_PRICING_ATTRIBUTE36),
PRICING_ATTRIBUTE37 = decode( p_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE37, p_PRICING_ATTRIBUTE37),
PRICING_ATTRIBUTE38 = decode( p_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE38, p_PRICING_ATTRIBUTE38),
PRICING_ATTRIBUTE39 = decode( p_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE39, p_PRICING_ATTRIBUTE39),
PRICING_ATTRIBUTE40 = decode( p_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE40, p_PRICING_ATTRIBUTE40),
PRICING_ATTRIBUTE41 = decode( p_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE41, p_PRICING_ATTRIBUTE41),
PRICING_ATTRIBUTE42 = decode( p_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE42, p_PRICING_ATTRIBUTE42),
PRICING_ATTRIBUTE43 = decode( p_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE43, p_PRICING_ATTRIBUTE43),
PRICING_ATTRIBUTE44 = decode( p_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE44, p_PRICING_ATTRIBUTE44),
PRICING_ATTRIBUTE45 = decode( p_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE45, p_PRICING_ATTRIBUTE45),
PRICING_ATTRIBUTE46 = decode( p_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE46, p_PRICING_ATTRIBUTE46),
PRICING_ATTRIBUTE47 = decode( p_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE47, p_PRICING_ATTRIBUTE47),
PRICING_ATTRIBUTE48 = decode( p_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE48, p_PRICING_ATTRIBUTE48),
PRICING_ATTRIBUTE49 = decode( p_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE49, p_PRICING_ATTRIBUTE49),
PRICING_ATTRIBUTE50 = decode( p_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE50, p_PRICING_ATTRIBUTE50),
PRICING_ATTRIBUTE51 = decode( p_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE51, p_PRICING_ATTRIBUTE51),
PRICING_ATTRIBUTE52 = decode( p_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE52, p_PRICING_ATTRIBUTE52),
PRICING_ATTRIBUTE53 = decode( p_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE53, p_PRICING_ATTRIBUTE53),
PRICING_ATTRIBUTE54 = decode( p_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE54, p_PRICING_ATTRIBUTE54),
PRICING_ATTRIBUTE55 = decode( p_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE55, p_PRICING_ATTRIBUTE55),
PRICING_ATTRIBUTE56 = decode( p_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE56, p_PRICING_ATTRIBUTE56),
PRICING_ATTRIBUTE57 = decode( p_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE57, p_PRICING_ATTRIBUTE57),
PRICING_ATTRIBUTE58 = decode( p_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE58, p_PRICING_ATTRIBUTE58),
PRICING_ATTRIBUTE59 = decode( p_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE59, p_PRICING_ATTRIBUTE59),
PRICING_ATTRIBUTE60 = decode( p_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE60, p_PRICING_ATTRIBUTE60),
PRICING_ATTRIBUTE61 = decode( p_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE61, p_PRICING_ATTRIBUTE61),
PRICING_ATTRIBUTE62 = decode( p_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE62, p_PRICING_ATTRIBUTE62),
PRICING_ATTRIBUTE63 = decode( p_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE63, p_PRICING_ATTRIBUTE63),
PRICING_ATTRIBUTE64 = decode( p_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE64, p_PRICING_ATTRIBUTE64),
PRICING_ATTRIBUTE65 = decode( p_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE65, p_PRICING_ATTRIBUTE65),
PRICING_ATTRIBUTE66 = decode( p_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE66, p_PRICING_ATTRIBUTE66),
PRICING_ATTRIBUTE67 = decode( p_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE67, p_PRICING_ATTRIBUTE67),
PRICING_ATTRIBUTE68 = decode( p_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE68, p_PRICING_ATTRIBUTE68),
PRICING_ATTRIBUTE69 = decode( p_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE69, p_PRICING_ATTRIBUTE69),
PRICING_ATTRIBUTE70 = decode( p_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE70, p_PRICING_ATTRIBUTE70),
PRICING_ATTRIBUTE71 = decode( p_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE71, p_PRICING_ATTRIBUTE71),
PRICING_ATTRIBUTE72 = decode( p_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE72, p_PRICING_ATTRIBUTE72),
PRICING_ATTRIBUTE73 = decode( p_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE73, p_PRICING_ATTRIBUTE73),
PRICING_ATTRIBUTE74 = decode( p_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE74, p_PRICING_ATTRIBUTE74),
PRICING_ATTRIBUTE75 = decode( p_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE75, p_PRICING_ATTRIBUTE75),
PRICING_ATTRIBUTE76 = decode( p_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE76, p_PRICING_ATTRIBUTE76),
PRICING_ATTRIBUTE77 = decode( p_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE77, p_PRICING_ATTRIBUTE77),
PRICING_ATTRIBUTE78 = decode( p_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE78, p_PRICING_ATTRIBUTE78),
PRICING_ATTRIBUTE79 = decode( p_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE79, p_PRICING_ATTRIBUTE79),
PRICING_ATTRIBUTE80 = decode( p_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE80, p_PRICING_ATTRIBUTE80),
PRICING_ATTRIBUTE81 = decode( p_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE81, p_PRICING_ATTRIBUTE81),
PRICING_ATTRIBUTE82 = decode( p_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE82, p_PRICING_ATTRIBUTE82),
PRICING_ATTRIBUTE83 = decode( p_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE83, p_PRICING_ATTRIBUTE83),
PRICING_ATTRIBUTE84 = decode( p_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE84, p_PRICING_ATTRIBUTE84),
PRICING_ATTRIBUTE85 = decode( p_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE85, p_PRICING_ATTRIBUTE85),
PRICING_ATTRIBUTE86 = decode( p_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE86, p_PRICING_ATTRIBUTE86),
PRICING_ATTRIBUTE87 = decode( p_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE87, p_PRICING_ATTRIBUTE87),
PRICING_ATTRIBUTE88 = decode( p_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE88, p_PRICING_ATTRIBUTE88),
PRICING_ATTRIBUTE89 = decode( p_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE89, p_PRICING_ATTRIBUTE89),
PRICING_ATTRIBUTE90 = decode( p_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE90, p_PRICING_ATTRIBUTE90),
PRICING_ATTRIBUTE91 = decode( p_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE91, p_PRICING_ATTRIBUTE91),
PRICING_ATTRIBUTE92 = decode( p_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE92, p_PRICING_ATTRIBUTE92),
PRICING_ATTRIBUTE93 = decode( p_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE93, p_PRICING_ATTRIBUTE93),
PRICING_ATTRIBUTE94 = decode( p_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE94, p_PRICING_ATTRIBUTE94),
PRICING_ATTRIBUTE95 = decode( p_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE95, p_PRICING_ATTRIBUTE95),
PRICING_ATTRIBUTE96 = decode( p_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE96, p_PRICING_ATTRIBUTE96),
PRICING_ATTRIBUTE97 = decode( p_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE97, p_PRICING_ATTRIBUTE97),
PRICING_ATTRIBUTE98 = decode( p_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE98, p_PRICING_ATTRIBUTE98),
PRICING_ATTRIBUTE99 = decode( p_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE99, p_PRICING_ATTRIBUTE99),
PRICING_ATTRIBUTE100 = decode( p_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE100, p_PRICING_ATTRIBUTE100),
ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
COVERAGE_BILL_RATE_ID = decode( p_COVERAGE_BILL_RATE_ID, FND_API.G_MISS_NUM, COVERAGE_BILL_RATE_ID, p_COVERAGE_BILL_RATE_ID),
--Obsoleted to fix Bug # 3477626
-- COVERAGE_BILLING_TYPE_ID = decode( P_COVERAGE_BILLING_TYPE_ID, FND_API.G_MISS_NUM,COVERAGE_BILLING_TYPE_ID, p_COVERAGE_BILLING_TYPE_ID),
TXN_BILLING_TYPE_ID = decode( p_TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, p_TXN_BILLING_TYPE_ID),
SUBMIT_RESTRICTION_MESSAGE = decode( p_SUBMIT_RESTRICTION_MESSAGE, FND_API.G_MISS_CHAR, SUBMIT_RESTRICTION_MESSAGE, p_SUBMIT_RESTRICTION_MESSAGE),
SUBMIT_ERROR_MESSAGE = decode( p_SUBMIT_ERROR_MESSAGE, FND_API.G_MISS_CHAR, SUBMIT_ERROR_MESSAGE, p_SUBMIT_ERROR_MESSAGE),
SUBMIT_FROM_SYSTEM = decode( p_SUBMIT_FROM_SYSTEM, FND_API.G_MISS_CHAR, SUBMIT_FROM_SYSTEM, p_SUBMIT_FROM_SYSTEM),
LINE_SUBMITTED = decode( p_LINE_SUBMITTED, FND_API.G_MISS_CHAR, LINE_SUBMITTED, p_LINE_SUBMITTED),
--EST_TAX_AMOUNT = decode( p_EST_TAX_AMOUNT, FND_API.G_MISS_NUM, EST_TAX_AMOUNT, p_EST_TAX_AMOUNT),
-- Obsolete column 11/13/2002 mviswana
--TAX_CODE = decode( p_TAX_CODE, FND_API.G_MISS_CHAR, TAX_CODE, p_TAX_CODE),
-- Obsolete column 11/13/2002 mviswana
LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID;
END Update_Row;
PROCEDURE Delete_Row(
p_ESTIMATE_DETAIL_ID NUMBER)
IS
BEGIN
DELETE FROM CS_ESTIMATE_DETAILS
WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID;
END Delete_Row;
SELECT *
FROM CS_ESTIMATE_DETAILS
WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID
AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
FOR UPDATE of ESTIMATE_DETAIL_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');