The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_row
( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
l_err VARCHAR2(500);
INSERT into CN_COMM_LINES_API_ALL
( SALESREP_ID,
PROCESSED_DATE,
PROCESSED_PERIOD_ID,
TRANSACTION_AMOUNT,
TRX_TYPE,
REVENUE_CLASS_ID,
LOAD_STATUS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
ATTRIBUTE31,
ATTRIBUTE32,
ATTRIBUTE33,
ATTRIBUTE34,
ATTRIBUTE35,
ATTRIBUTE36,
ATTRIBUTE37,
ATTRIBUTE38,
ATTRIBUTE39,
ATTRIBUTE40,
ATTRIBUTE41,
ATTRIBUTE42,
ATTRIBUTE43,
ATTRIBUTE44,
ATTRIBUTE45,
ATTRIBUTE46,
ATTRIBUTE47,
ATTRIBUTE48,
ATTRIBUTE49,
ATTRIBUTE50,
ATTRIBUTE51,
ATTRIBUTE52,
ATTRIBUTE53,
ATTRIBUTE54,
ATTRIBUTE55,
ATTRIBUTE56,
ATTRIBUTE57,
ATTRIBUTE58,
ATTRIBUTE59,
ATTRIBUTE60,
ATTRIBUTE61,
ATTRIBUTE62,
ATTRIBUTE63,
ATTRIBUTE64,
ATTRIBUTE65,
ATTRIBUTE66,
ATTRIBUTE67,
ATTRIBUTE68,
ATTRIBUTE69,
ATTRIBUTE70,
ATTRIBUTE71,
ATTRIBUTE72,
ATTRIBUTE73,
ATTRIBUTE74,
ATTRIBUTE75,
ATTRIBUTE76,
ATTRIBUTE77,
ATTRIBUTE78,
ATTRIBUTE79,
ATTRIBUTE80,
ATTRIBUTE81,
ATTRIBUTE82,
ATTRIBUTE83,
ATTRIBUTE84,
ATTRIBUTE85,
ATTRIBUTE86,
ATTRIBUTE87,
ATTRIBUTE88,
ATTRIBUTE89,
ATTRIBUTE90,
ATTRIBUTE91,
ATTRIBUTE92,
ATTRIBUTE93,
ATTRIBUTE94,
ATTRIBUTE95,
ATTRIBUTE96,
ATTRIBUTE97,
ATTRIBUTE98,
ATTRIBUTE99,
ATTRIBUTE100,
COMM_LINES_API_ID,
CONC_BATCH_ID,
PROCESS_BATCH_ID,
SALESREP_NUMBER,
ROLLUP_DATE,
SOURCE_DOC_ID,
SOURCE_DOC_TYPE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
TRANSACTION_CURRENCY_CODE,
EXCHANGE_RATE,
ACCTD_TRANSACTION_AMOUNT,
TRX_ID,
TRX_LINE_ID,
TRX_SALES_LINE_ID,
QUANTITY,
SOURCE_TRX_NUMBER,
DISCOUNT_PERCENTAGE,
MARGIN_PERCENTAGE,
SOURCE_TRX_ID,
SOURCE_TRX_LINE_ID,
SOURCE_TRX_SALES_LINE_ID,
NEGATED_FLAG,
CUSTOMER_ID,
INVENTORY_ITEM_ID,
ORDER_NUMBER,
BOOKED_DATE,
INVOICE_NUMBER,
INVOICE_DATE,
ADJUST_DATE,
ADJUSTED_BY,
REVENUE_TYPE,
ADJUST_ROLLUP_FLAG,
ADJUST_COMMENTS,
ADJUST_STATUS,
LINE_NUMBER,
BILL_TO_ADDRESS_ID,
SHIP_TO_ADDRESS_ID,
BILL_TO_CONTACT_ID,
SHIP_TO_CONTACT_ID,
ADJ_COMM_LINES_API_ID,
PRE_DEFINED_RC_FLAG,
ROLLUP_FLAG,
FORECAST_ID,
UPSIDE_QUANTITY,
UPSIDE_AMOUNT,
UOM_CODE,
REASON_CODE,
TYPE,
PRE_PROCESSED_CODE,
QUOTA_ID,
SRP_PLAN_ASSIGN_ID,
ROLE_ID,
COMP_GROUP_ID,
COMMISSION_AMOUNT,
EMPLOYEE_NUMBER,
REVERSAL_FLAG,
REVERSAL_HEADER_ID,
SALES_CHANNEL,
OBJECT_VERSION_NUMBER,
SPLIT_PCT,
SPLIT_STATUS,
ORG_ID,
TERR_ID,
TERR_NAME,
PRESERVE_CREDIT_OVERRIDE_FLAG
)
select
DECODE(p_comm_lines_api_rec.SALESREP_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SALESREP_ID),
DECODE(p_comm_lines_api_rec.PROCESSED_DATE, FND_API.G_MISS_DATE, NULL,
trunc(p_comm_lines_api_rec.processed_date)),
DECODE(p_comm_lines_api_rec.PROCESSED_PERIOD_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.PROCESSED_PERIOD_ID),
DECODE(p_comm_lines_api_rec.TRANSACTION_AMOUNT, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.TRANSACTION_AMOUNT),
DECODE(p_comm_lines_api_rec.TRX_TYPE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.TRX_TYPE),
DECODE(p_comm_lines_api_rec.REVENUE_CLASS_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.REVENUE_CLASS_ID),
DECODE(p_comm_lines_api_rec.LOAD_STATUS, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.LOAD_STATUS),
DECODE(p_comm_lines_api_rec.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE_CATEGORY),
DECODE(p_comm_lines_api_rec.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE1),
DECODE(p_comm_lines_api_rec.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE2),
DECODE(p_comm_lines_api_rec.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE3),
DECODE(p_comm_lines_api_rec.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE4),
DECODE(p_comm_lines_api_rec.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE5),
DECODE(p_comm_lines_api_rec.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE6),
DECODE(p_comm_lines_api_rec.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE7),
DECODE(p_comm_lines_api_rec.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE8),
DECODE(p_comm_lines_api_rec.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE9),
DECODE(p_comm_lines_api_rec.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE10),
DECODE(p_comm_lines_api_rec.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE11),
DECODE(p_comm_lines_api_rec.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE12),
DECODE(p_comm_lines_api_rec.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE13),
DECODE(p_comm_lines_api_rec.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE14),
DECODE(p_comm_lines_api_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE15),
DECODE(p_comm_lines_api_rec.ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE16),
DECODE(p_comm_lines_api_rec.ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE17),
DECODE(p_comm_lines_api_rec.ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE18),
DECODE(p_comm_lines_api_rec.ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE19),
DECODE(p_comm_lines_api_rec.ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE20),
DECODE(p_comm_lines_api_rec.ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE21),
DECODE(p_comm_lines_api_rec.ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE22),
DECODE(p_comm_lines_api_rec.ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE23),
DECODE(p_comm_lines_api_rec.ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE24),
DECODE(p_comm_lines_api_rec.ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE25),
DECODE(p_comm_lines_api_rec.ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE26),
DECODE(p_comm_lines_api_rec.ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE27),
DECODE(p_comm_lines_api_rec.ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE28),
DECODE(p_comm_lines_api_rec.ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE29),
DECODE(p_comm_lines_api_rec.ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE30),
DECODE(p_comm_lines_api_rec.ATTRIBUTE31, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE31),
DECODE(p_comm_lines_api_rec.ATTRIBUTE32, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE32),
DECODE(p_comm_lines_api_rec.ATTRIBUTE33, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE33),
DECODE(p_comm_lines_api_rec.ATTRIBUTE34, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE34),
DECODE(p_comm_lines_api_rec.ATTRIBUTE35, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE35),
DECODE(p_comm_lines_api_rec.ATTRIBUTE36, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE36),
DECODE(p_comm_lines_api_rec.ATTRIBUTE37, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE37),
DECODE(p_comm_lines_api_rec.ATTRIBUTE38, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE38),
DECODE(p_comm_lines_api_rec.ATTRIBUTE39, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE39),
DECODE(p_comm_lines_api_rec.ATTRIBUTE40, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE40),
DECODE(p_comm_lines_api_rec.ATTRIBUTE41, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE41),
DECODE(p_comm_lines_api_rec.ATTRIBUTE42, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE42),
DECODE(p_comm_lines_api_rec.ATTRIBUTE43, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE43),
DECODE(p_comm_lines_api_rec.ATTRIBUTE44, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE44),
DECODE(p_comm_lines_api_rec.ATTRIBUTE45, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE45),
DECODE(p_comm_lines_api_rec.ATTRIBUTE46, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE46),
DECODE(p_comm_lines_api_rec.ATTRIBUTE47, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE47),
DECODE(p_comm_lines_api_rec.ATTRIBUTE48, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE48),
DECODE(p_comm_lines_api_rec.ATTRIBUTE49, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE49),
DECODE(p_comm_lines_api_rec.ATTRIBUTE50, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE50),
DECODE(p_comm_lines_api_rec.ATTRIBUTE51, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE51),
DECODE(p_comm_lines_api_rec.ATTRIBUTE52, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE52),
DECODE(p_comm_lines_api_rec.ATTRIBUTE53, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE53),
DECODE(p_comm_lines_api_rec.ATTRIBUTE54, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE54),
DECODE(p_comm_lines_api_rec.ATTRIBUTE55, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE55),
DECODE(p_comm_lines_api_rec.ATTRIBUTE56, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE56),
DECODE(p_comm_lines_api_rec.ATTRIBUTE57, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE57),
DECODE(p_comm_lines_api_rec.ATTRIBUTE58, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE58),
DECODE(p_comm_lines_api_rec.ATTRIBUTE59, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE59),
DECODE(p_comm_lines_api_rec.ATTRIBUTE60, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE60),
DECODE(p_comm_lines_api_rec.ATTRIBUTE61, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE61),
DECODE(p_comm_lines_api_rec.ATTRIBUTE62, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE62),
DECODE(p_comm_lines_api_rec.ATTRIBUTE63, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE63),
DECODE(p_comm_lines_api_rec.ATTRIBUTE64, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE64),
DECODE(p_comm_lines_api_rec.ATTRIBUTE65, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE65),
DECODE(p_comm_lines_api_rec.ATTRIBUTE66, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE66),
DECODE(p_comm_lines_api_rec.ATTRIBUTE67, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE67),
DECODE(p_comm_lines_api_rec.ATTRIBUTE68, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE68),
DECODE(p_comm_lines_api_rec.ATTRIBUTE69, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE69),
DECODE(p_comm_lines_api_rec.ATTRIBUTE70, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE70),
DECODE(p_comm_lines_api_rec.ATTRIBUTE71, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE71),
DECODE(p_comm_lines_api_rec.ATTRIBUTE72, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE72),
DECODE(p_comm_lines_api_rec.ATTRIBUTE73, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE73),
DECODE(p_comm_lines_api_rec.ATTRIBUTE74, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE74),
DECODE(p_comm_lines_api_rec.ATTRIBUTE75, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE75),
DECODE(p_comm_lines_api_rec.ATTRIBUTE76, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE76),
DECODE(p_comm_lines_api_rec.ATTRIBUTE77, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE77),
DECODE(p_comm_lines_api_rec.ATTRIBUTE78, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE78),
DECODE(p_comm_lines_api_rec.ATTRIBUTE79, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE79),
DECODE(p_comm_lines_api_rec.ATTRIBUTE80, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE80),
DECODE(p_comm_lines_api_rec.ATTRIBUTE81, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE81),
DECODE(p_comm_lines_api_rec.ATTRIBUTE82, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE82),
DECODE(p_comm_lines_api_rec.ATTRIBUTE83, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE83),
DECODE(p_comm_lines_api_rec.ATTRIBUTE84, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE84),
DECODE(p_comm_lines_api_rec.ATTRIBUTE85, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE85),
DECODE(p_comm_lines_api_rec.ATTRIBUTE86, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE86),
DECODE(p_comm_lines_api_rec.ATTRIBUTE87, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE87),
DECODE(p_comm_lines_api_rec.ATTRIBUTE88, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE88),
DECODE(p_comm_lines_api_rec.ATTRIBUTE89, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE89),
DECODE(p_comm_lines_api_rec.ATTRIBUTE90, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE90),
DECODE(p_comm_lines_api_rec.ATTRIBUTE91, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE91),
DECODE(p_comm_lines_api_rec.ATTRIBUTE92, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE92),
DECODE(p_comm_lines_api_rec.ATTRIBUTE93, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE93),
DECODE(p_comm_lines_api_rec.ATTRIBUTE94, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE94),
DECODE(p_comm_lines_api_rec.ATTRIBUTE95, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE95),
DECODE(p_comm_lines_api_rec.ATTRIBUTE96, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE96),
DECODE(p_comm_lines_api_rec.ATTRIBUTE97, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE97),
DECODE(p_comm_lines_api_rec.ATTRIBUTE98, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE98),
DECODE(p_comm_lines_api_rec.ATTRIBUTE99, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE99),
DECODE(p_comm_lines_api_rec.ATTRIBUTE100, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ATTRIBUTE100),
DECODE(p_comm_lines_api_rec.COMM_LINES_API_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.COMM_LINES_API_ID),
DECODE(p_comm_lines_api_rec.CONC_BATCH_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.CONC_BATCH_ID),
DECODE(p_comm_lines_api_rec.PROCESS_BATCH_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.PROCESS_BATCH_ID),
DECODE(p_comm_lines_api_rec.SALESREP_NUMBER, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SALESREP_NUMBER),
DECODE(p_comm_lines_api_rec.ROLLUP_DATE, FND_API.G_MISS_DATE, NULL,
p_comm_lines_api_rec.ROLLUP_DATE),
DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SOURCE_DOC_ID),
DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.SOURCE_DOC_TYPE),
fnd_global.user_id,
Sysdate,
fnd_global.user_id,
Sysdate,
fnd_global.login_id,
DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
DECODE(p_comm_lines_api_rec.EXCHANGE_RATE, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.EXCHANGE_RATE),
DECODE(p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT),
DECODE(p_comm_lines_api_rec.TRX_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.TRX_ID),
DECODE(p_comm_lines_api_rec.TRX_LINE_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.TRX_LINE_ID),
DECODE(p_comm_lines_api_rec.TRX_SALES_LINE_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.TRX_SALES_LINE_ID),
DECODE(p_comm_lines_api_rec.QUANTITY, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.QUANTITY),
DECODE(p_comm_lines_api_rec.SOURCE_TRX_NUMBER, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.SOURCE_TRX_NUMBER),
DECODE(p_comm_lines_api_rec.DISCOUNT_PERCENTAGE, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.DISCOUNT_PERCENTAGE),
DECODE(p_comm_lines_api_rec.MARGIN_PERCENTAGE, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.MARGIN_PERCENTAGE),
DECODE(p_comm_lines_api_rec.SOURCE_TRX_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SOURCE_TRX_ID),
DECODE(p_comm_lines_api_rec.SOURCE_TRX_LINE_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SOURCE_TRX_LINE_ID),
DECODE(p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID),
DECODE(p_comm_lines_api_rec.NEGATED_FLAG, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.NEGATED_FLAG),
DECODE(p_comm_lines_api_rec.CUSTOMER_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.CUSTOMER_ID),
DECODE(p_comm_lines_api_rec.INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.INVENTORY_ITEM_ID),
DECODE(p_comm_lines_api_rec.ORDER_NUMBER, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.ORDER_NUMBER),
DECODE(p_comm_lines_api_rec.BOOKED_DATE, FND_API.G_MISS_DATE, NULL,
p_comm_lines_api_rec.BOOKED_DATE),
DECODE(p_comm_lines_api_rec.INVOICE_NUMBER, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.INVOICE_NUMBER),
DECODE(p_comm_lines_api_rec.INVOICE_DATE, FND_API.G_MISS_DATE, NULL,
p_comm_lines_api_rec.INVOICE_DATE),
DECODE(p_comm_lines_api_rec.ADJUST_DATE, FND_API.G_MISS_DATE, NULL,
p_comm_lines_api_rec.ADJUST_DATE),
DECODE(p_comm_lines_api_rec.ADJUSTED_BY, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ADJUSTED_BY),
DECODE(p_comm_lines_api_rec.REVENUE_TYPE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.REVENUE_TYPE),
DECODE(p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG),
DECODE(p_comm_lines_api_rec.ADJUST_COMMENTS, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ADJUST_COMMENTS),
NVL(DECODE(p_comm_lines_api_rec.ADJUST_STATUS, FND_API.G_MISS_CHAR, NULL, p_comm_lines_api_rec.ADJUST_STATUS),'NEW'),
DECODE(p_comm_lines_api_rec.LINE_NUMBER, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.LINE_NUMBER),
DECODE(p_comm_lines_api_rec.BILL_TO_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.BILL_TO_ADDRESS_ID),
DECODE(p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID),
DECODE(p_comm_lines_api_rec.BILL_TO_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.BILL_TO_CONTACT_ID),
DECODE(p_comm_lines_api_rec.SHIP_TO_CONTACT_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SHIP_TO_CONTACT_ID),
DECODE(p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID),
DECODE(p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG),
DECODE(p_comm_lines_api_rec.ROLLUP_FLAG, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.ROLLUP_FLAG),
DECODE(p_comm_lines_api_rec.FORECAST_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.FORECAST_ID),
DECODE(p_comm_lines_api_rec.UPSIDE_QUANTITY, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.UPSIDE_QUANTITY),
DECODE(p_comm_lines_api_rec.UPSIDE_AMOUNT, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.UPSIDE_AMOUNT),
DECODE(p_comm_lines_api_rec.UOM_CODE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.UOM_CODE),
DECODE(p_comm_lines_api_rec.REASON_CODE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.REASON_CODE),
DECODE(p_comm_lines_api_rec.TYPE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.TYPE),
DECODE(p_comm_lines_api_rec.PRE_PROCESSED_CODE, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.PRE_PROCESSED_CODE),
DECODE(p_comm_lines_api_rec.QUOTA_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.QUOTA_ID),
DECODE(p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID),
DECODE(p_comm_lines_api_rec.ROLE_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.ROLE_ID),
DECODE(p_comm_lines_api_rec.COMP_GROUP_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.COMP_GROUP_ID),
DECODE(p_comm_lines_api_rec.COMMISSION_AMOUNT, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.COMMISSION_AMOUNT),
DECODE(p_comm_lines_api_rec.EMPLOYEE_NUMBER, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.EMPLOYEE_NUMBER),
DECODE(p_comm_lines_api_rec.REVERSAL_FLAG, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.REVERSAL_FLAG),
DECODE(p_comm_lines_api_rec.REVERSAL_HEADER_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.REVERSAL_HEADER_ID),
DECODE(p_comm_lines_api_rec.SALES_CHANNEL, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.SALES_CHANNEL),
1,
DECODE(p_comm_lines_api_rec.SPLIT_PCT, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.SPLIT_PCT),
DECODE(p_comm_lines_api_rec.SPLIT_STATUS, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.SPLIT_STATUS),
DECODE(p_comm_lines_api_rec.ORG_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.ORG_ID),
/* Added for Crediting Bug */
DECODE(p_comm_lines_api_rec.TERR_ID, FND_API.G_MISS_NUM, NULL,
p_comm_lines_api_rec.TERR_ID),
DECODE(p_comm_lines_api_rec.TERR_NAME, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.TERR_NAME),
DECODE(p_comm_lines_api_rec.PRESERVE_CREDIT_OVERRIDE_FLAG, FND_API.G_MISS_CHAR, NULL,
p_comm_lines_api_rec.PRESERVE_CREDIT_OVERRIDE_FLAG)
from dual;
END insert_row;
PROCEDURE update_row
( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
BEGIN
UPDATE CN_COMM_LINES_API oldrec
SET
SALESREP_ID = DECODE(p_comm_lines_api_rec.SALESREP_ID,
FND_API.G_MISS_NUM,
oldrec.SALESREP_ID,
p_comm_lines_api_rec.SALESREP_ID),
PROCESSED_DATE = DECODE(p_comm_lines_api_rec.PROCESSED_DATE,
FND_API.G_MISS_DATE,
oldrec.PROCESSED_DATE,
p_comm_lines_api_rec.PROCESSED_DATE),
PROCESSED_PERIOD_ID = DECODE(p_comm_lines_api_rec.PROCESSED_PERIOD_ID,
FND_API.G_MISS_NUM,
oldrec.PROCESSED_PERIOD_ID,
p_comm_lines_api_rec.PROCESSED_PERIOD_ID),
TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.TRANSACTION_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.TRANSACTION_AMOUNT,
p_comm_lines_api_rec.TRANSACTION_AMOUNT),
TRX_TYPE = DECODE(p_comm_lines_api_rec.TRX_TYPE,
FND_API.G_MISS_CHAR,
oldrec.TRX_TYPE,
p_comm_lines_api_rec.TRX_TYPE),
REVENUE_CLASS_ID = DECODE(p_comm_lines_api_rec.REVENUE_CLASS_ID,
FND_API.G_MISS_NUM,
oldrec.REVENUE_CLASS_ID,
p_comm_lines_api_rec.REVENUE_CLASS_ID),
LOAD_STATUS = DECODE(p_comm_lines_api_rec.LOAD_STATUS,
FND_API.G_MISS_CHAR,
oldrec.LOAD_STATUS,
p_comm_lines_api_rec.LOAD_STATUS),
ATTRIBUTE_CATEGORY = DECODE(p_comm_lines_api_rec.ATTRIBUTE_CATEGORY,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE_CATEGORY,
p_comm_lines_api_rec.ATTRIBUTE_CATEGORY),
ATTRIBUTE1 = DECODE(p_comm_lines_api_rec.ATTRIBUTE1,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE1,
p_comm_lines_api_rec.ATTRIBUTE1),
ATTRIBUTE2 = DECODE(p_comm_lines_api_rec.ATTRIBUTE2,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE2,
p_comm_lines_api_rec.ATTRIBUTE2),
ATTRIBUTE3 = DECODE(p_comm_lines_api_rec.ATTRIBUTE3,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE3,
p_comm_lines_api_rec.ATTRIBUTE3),
ATTRIBUTE4 = DECODE(p_comm_lines_api_rec.ATTRIBUTE4,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE4,
p_comm_lines_api_rec.ATTRIBUTE4),
ATTRIBUTE5 = DECODE(p_comm_lines_api_rec.ATTRIBUTE5,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE5,
p_comm_lines_api_rec.ATTRIBUTE5),
ATTRIBUTE6 = DECODE(p_comm_lines_api_rec.ATTRIBUTE6,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE6,
p_comm_lines_api_rec.ATTRIBUTE6),
ATTRIBUTE7 = DECODE(p_comm_lines_api_rec.ATTRIBUTE7,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE7,
p_comm_lines_api_rec.ATTRIBUTE7),
ATTRIBUTE8 = DECODE(p_comm_lines_api_rec.ATTRIBUTE8,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE8,
p_comm_lines_api_rec.ATTRIBUTE8),
ATTRIBUTE9 = DECODE(p_comm_lines_api_rec.ATTRIBUTE9,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE9,
p_comm_lines_api_rec.ATTRIBUTE9),
ATTRIBUTE10 = DECODE(p_comm_lines_api_rec.ATTRIBUTE10,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE10,
p_comm_lines_api_rec.ATTRIBUTE10),
ATTRIBUTE11 = DECODE(p_comm_lines_api_rec.ATTRIBUTE11,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE11,
p_comm_lines_api_rec.ATTRIBUTE11),
ATTRIBUTE12 = DECODE(p_comm_lines_api_rec.ATTRIBUTE12,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE12,
p_comm_lines_api_rec.ATTRIBUTE12),
ATTRIBUTE13 = DECODE(p_comm_lines_api_rec.ATTRIBUTE13,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE13,
p_comm_lines_api_rec.ATTRIBUTE13),
ATTRIBUTE14 = DECODE(p_comm_lines_api_rec.ATTRIBUTE14,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE14,
p_comm_lines_api_rec.ATTRIBUTE14),
ATTRIBUTE15 = DECODE(p_comm_lines_api_rec.ATTRIBUTE15,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE15,
p_comm_lines_api_rec.ATTRIBUTE15),
ATTRIBUTE16 = DECODE(p_comm_lines_api_rec.ATTRIBUTE16,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE16,
p_comm_lines_api_rec.ATTRIBUTE16),
ATTRIBUTE17 = DECODE(p_comm_lines_api_rec.ATTRIBUTE17,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE17,
p_comm_lines_api_rec.ATTRIBUTE17),
ATTRIBUTE18 = DECODE(p_comm_lines_api_rec.ATTRIBUTE18,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE18,
p_comm_lines_api_rec.ATTRIBUTE18),
ATTRIBUTE19 = DECODE(p_comm_lines_api_rec.ATTRIBUTE19,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE19,
p_comm_lines_api_rec.ATTRIBUTE19),
ATTRIBUTE20 = DECODE(p_comm_lines_api_rec.ATTRIBUTE20,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE20,
p_comm_lines_api_rec.ATTRIBUTE20),
ATTRIBUTE21 = DECODE(p_comm_lines_api_rec.ATTRIBUTE21,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE21,
p_comm_lines_api_rec.ATTRIBUTE21),
ATTRIBUTE22 = DECODE(p_comm_lines_api_rec.ATTRIBUTE22,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE22,
p_comm_lines_api_rec.ATTRIBUTE22),
ATTRIBUTE23 = DECODE(p_comm_lines_api_rec.ATTRIBUTE23,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE23,
p_comm_lines_api_rec.ATTRIBUTE23),
ATTRIBUTE24 = DECODE(p_comm_lines_api_rec.ATTRIBUTE24,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE24,
p_comm_lines_api_rec.ATTRIBUTE24),
ATTRIBUTE25 = DECODE(p_comm_lines_api_rec.ATTRIBUTE25,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE25,
p_comm_lines_api_rec.ATTRIBUTE25),
ATTRIBUTE26 = DECODE(p_comm_lines_api_rec.ATTRIBUTE26,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE26,
p_comm_lines_api_rec.ATTRIBUTE26),
ATTRIBUTE27 = DECODE(p_comm_lines_api_rec.ATTRIBUTE27,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE27,
p_comm_lines_api_rec.ATTRIBUTE27),
ATTRIBUTE28 = DECODE(p_comm_lines_api_rec.ATTRIBUTE28,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE28,
p_comm_lines_api_rec.ATTRIBUTE28),
ATTRIBUTE29 = DECODE(p_comm_lines_api_rec.ATTRIBUTE29,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE29,
p_comm_lines_api_rec.ATTRIBUTE29),
ATTRIBUTE30 = DECODE(p_comm_lines_api_rec.ATTRIBUTE30,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE30,
p_comm_lines_api_rec.ATTRIBUTE30),
ATTRIBUTE31 = DECODE(p_comm_lines_api_rec.ATTRIBUTE31,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE31,
p_comm_lines_api_rec.ATTRIBUTE31),
ATTRIBUTE32 = DECODE(p_comm_lines_api_rec.ATTRIBUTE32,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE32,
p_comm_lines_api_rec.ATTRIBUTE32),
ATTRIBUTE33 = DECODE(p_comm_lines_api_rec.ATTRIBUTE33,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE33,
p_comm_lines_api_rec.ATTRIBUTE33),
ATTRIBUTE34 = DECODE(p_comm_lines_api_rec.ATTRIBUTE34,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE34,
p_comm_lines_api_rec.ATTRIBUTE34),
ATTRIBUTE35 = DECODE(p_comm_lines_api_rec.ATTRIBUTE35,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE35,
p_comm_lines_api_rec.ATTRIBUTE35),
ATTRIBUTE36 = DECODE(p_comm_lines_api_rec.ATTRIBUTE36,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE36,
p_comm_lines_api_rec.ATTRIBUTE36),
ATTRIBUTE37 = DECODE(p_comm_lines_api_rec.ATTRIBUTE37,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE37,
p_comm_lines_api_rec.ATTRIBUTE37),
ATTRIBUTE38 = DECODE(p_comm_lines_api_rec.ATTRIBUTE38,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE38,
p_comm_lines_api_rec.ATTRIBUTE38),
ATTRIBUTE39 = DECODE(p_comm_lines_api_rec.ATTRIBUTE39,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE39,
p_comm_lines_api_rec.ATTRIBUTE39),
ATTRIBUTE40 = DECODE(p_comm_lines_api_rec.ATTRIBUTE40,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE40,
p_comm_lines_api_rec.ATTRIBUTE40),
ATTRIBUTE41 = DECODE(p_comm_lines_api_rec.ATTRIBUTE41,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE41,
p_comm_lines_api_rec.ATTRIBUTE41),
ATTRIBUTE42 = DECODE(p_comm_lines_api_rec.ATTRIBUTE42,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE42,
p_comm_lines_api_rec.ATTRIBUTE42),
ATTRIBUTE43 = DECODE(p_comm_lines_api_rec.ATTRIBUTE43,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE43,
p_comm_lines_api_rec.ATTRIBUTE43),
ATTRIBUTE44 = DECODE(p_comm_lines_api_rec.ATTRIBUTE44,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE44,
p_comm_lines_api_rec.ATTRIBUTE44),
ATTRIBUTE45 = DECODE(p_comm_lines_api_rec.ATTRIBUTE45,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE45,
p_comm_lines_api_rec.ATTRIBUTE45),
ATTRIBUTE46 = DECODE(p_comm_lines_api_rec.ATTRIBUTE46,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE46,
p_comm_lines_api_rec.ATTRIBUTE46),
ATTRIBUTE47 = DECODE(p_comm_lines_api_rec.ATTRIBUTE47,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE47,
p_comm_lines_api_rec.ATTRIBUTE47),
ATTRIBUTE48 = DECODE(p_comm_lines_api_rec.ATTRIBUTE48,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE48,
p_comm_lines_api_rec.ATTRIBUTE48),
ATTRIBUTE49 = DECODE(p_comm_lines_api_rec.ATTRIBUTE49,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE49,
p_comm_lines_api_rec.ATTRIBUTE49),
ATTRIBUTE50 = DECODE(p_comm_lines_api_rec.ATTRIBUTE50,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE50,
p_comm_lines_api_rec.ATTRIBUTE50),
ATTRIBUTE51 = DECODE(p_comm_lines_api_rec.ATTRIBUTE51,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE51,
p_comm_lines_api_rec.ATTRIBUTE51),
ATTRIBUTE52 = DECODE(p_comm_lines_api_rec.ATTRIBUTE52,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE52,
p_comm_lines_api_rec.ATTRIBUTE52),
ATTRIBUTE53 = DECODE(p_comm_lines_api_rec.ATTRIBUTE53,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE53,
p_comm_lines_api_rec.ATTRIBUTE53),
ATTRIBUTE54 = DECODE(p_comm_lines_api_rec.ATTRIBUTE54,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE54,
p_comm_lines_api_rec.ATTRIBUTE54),
ATTRIBUTE55 = DECODE(p_comm_lines_api_rec.ATTRIBUTE55,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE55,
p_comm_lines_api_rec.ATTRIBUTE55),
ATTRIBUTE56 = DECODE(p_comm_lines_api_rec.ATTRIBUTE56,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE56,
p_comm_lines_api_rec.ATTRIBUTE56),
ATTRIBUTE57 = DECODE(p_comm_lines_api_rec.ATTRIBUTE57,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE57,
p_comm_lines_api_rec.ATTRIBUTE57),
ATTRIBUTE58 = DECODE(p_comm_lines_api_rec.ATTRIBUTE58,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE58,
p_comm_lines_api_rec.ATTRIBUTE58),
ATTRIBUTE59 = DECODE(p_comm_lines_api_rec.ATTRIBUTE59,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE59,
p_comm_lines_api_rec.ATTRIBUTE59),
ATTRIBUTE60 = DECODE(p_comm_lines_api_rec.ATTRIBUTE60,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE60,
p_comm_lines_api_rec.ATTRIBUTE60),
ATTRIBUTE61 = DECODE(p_comm_lines_api_rec.ATTRIBUTE61,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE61,
p_comm_lines_api_rec.ATTRIBUTE61),
ATTRIBUTE62 = DECODE(p_comm_lines_api_rec.ATTRIBUTE62,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE62,
p_comm_lines_api_rec.ATTRIBUTE62),
ATTRIBUTE63 = DECODE(p_comm_lines_api_rec.ATTRIBUTE63,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE63,
p_comm_lines_api_rec.ATTRIBUTE63),
ATTRIBUTE64 = DECODE(p_comm_lines_api_rec.ATTRIBUTE64,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE64,
p_comm_lines_api_rec.ATTRIBUTE64),
ATTRIBUTE65 = DECODE(p_comm_lines_api_rec.ATTRIBUTE65,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE65,
p_comm_lines_api_rec.ATTRIBUTE65),
ATTRIBUTE66 = DECODE(p_comm_lines_api_rec.ATTRIBUTE66,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE66,
p_comm_lines_api_rec.ATTRIBUTE66),
ATTRIBUTE67 = DECODE(p_comm_lines_api_rec.ATTRIBUTE67,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE67,
p_comm_lines_api_rec.ATTRIBUTE67),
ATTRIBUTE68 = DECODE(p_comm_lines_api_rec.ATTRIBUTE68,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE68,
p_comm_lines_api_rec.ATTRIBUTE68),
ATTRIBUTE69 = DECODE(p_comm_lines_api_rec.ATTRIBUTE69,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE69,
p_comm_lines_api_rec.ATTRIBUTE69),
ATTRIBUTE70 = DECODE(p_comm_lines_api_rec.ATTRIBUTE70,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE70,
p_comm_lines_api_rec.ATTRIBUTE70),
ATTRIBUTE71 = DECODE(p_comm_lines_api_rec.ATTRIBUTE71,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE71,
p_comm_lines_api_rec.ATTRIBUTE71),
ATTRIBUTE72 = DECODE(p_comm_lines_api_rec.ATTRIBUTE72,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE72,
p_comm_lines_api_rec.ATTRIBUTE72),
ATTRIBUTE73 = DECODE(p_comm_lines_api_rec.ATTRIBUTE73,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE73,
p_comm_lines_api_rec.ATTRIBUTE73),
ATTRIBUTE74 = DECODE(p_comm_lines_api_rec.ATTRIBUTE74,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE74,
p_comm_lines_api_rec.ATTRIBUTE74),
ATTRIBUTE75 = DECODE(p_comm_lines_api_rec.ATTRIBUTE75,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE75,
p_comm_lines_api_rec.ATTRIBUTE75),
ATTRIBUTE76 = DECODE(p_comm_lines_api_rec.ATTRIBUTE76,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE76,
p_comm_lines_api_rec.ATTRIBUTE76),
ATTRIBUTE77 = DECODE(p_comm_lines_api_rec.ATTRIBUTE77,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE77,
p_comm_lines_api_rec.ATTRIBUTE77),
ATTRIBUTE78 = DECODE(p_comm_lines_api_rec.ATTRIBUTE78,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE78,
p_comm_lines_api_rec.ATTRIBUTE78),
ATTRIBUTE79 = DECODE(p_comm_lines_api_rec.ATTRIBUTE79,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE79,
p_comm_lines_api_rec.ATTRIBUTE79),
ATTRIBUTE80 = DECODE(p_comm_lines_api_rec.ATTRIBUTE80,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE80,
p_comm_lines_api_rec.ATTRIBUTE80),
ATTRIBUTE81 = DECODE(p_comm_lines_api_rec.ATTRIBUTE81,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE81,
p_comm_lines_api_rec.ATTRIBUTE81),
ATTRIBUTE82 = DECODE(p_comm_lines_api_rec.ATTRIBUTE82,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE82,
p_comm_lines_api_rec.ATTRIBUTE82),
ATTRIBUTE83 = DECODE(p_comm_lines_api_rec.ATTRIBUTE83,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE83,
p_comm_lines_api_rec.ATTRIBUTE83),
ATTRIBUTE84 = DECODE(p_comm_lines_api_rec.ATTRIBUTE84,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE84,
p_comm_lines_api_rec.ATTRIBUTE84),
ATTRIBUTE85 = DECODE(p_comm_lines_api_rec.ATTRIBUTE85,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE85,
p_comm_lines_api_rec.ATTRIBUTE85),
ATTRIBUTE86 = DECODE(p_comm_lines_api_rec.ATTRIBUTE86,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE86,
p_comm_lines_api_rec.ATTRIBUTE86),
ATTRIBUTE87 = DECODE(p_comm_lines_api_rec.ATTRIBUTE87,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE87,
p_comm_lines_api_rec.ATTRIBUTE87),
ATTRIBUTE88 = DECODE(p_comm_lines_api_rec.ATTRIBUTE88,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE88,
p_comm_lines_api_rec.ATTRIBUTE88),
ATTRIBUTE89 = DECODE(p_comm_lines_api_rec.ATTRIBUTE89,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE89,
p_comm_lines_api_rec.ATTRIBUTE89),
ATTRIBUTE90 = DECODE(p_comm_lines_api_rec.ATTRIBUTE90,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE90,
p_comm_lines_api_rec.ATTRIBUTE90),
ATTRIBUTE91 = DECODE(p_comm_lines_api_rec.ATTRIBUTE91,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE91,
p_comm_lines_api_rec.ATTRIBUTE91),
ATTRIBUTE92 = DECODE(p_comm_lines_api_rec.ATTRIBUTE92,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE92,
p_comm_lines_api_rec.ATTRIBUTE92),
ATTRIBUTE93 = DECODE(p_comm_lines_api_rec.ATTRIBUTE93,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE93,
p_comm_lines_api_rec.ATTRIBUTE93),
ATTRIBUTE94 = DECODE(p_comm_lines_api_rec.ATTRIBUTE94,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE94,
p_comm_lines_api_rec.ATTRIBUTE94),
ATTRIBUTE95 = DECODE(p_comm_lines_api_rec.ATTRIBUTE95,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE95,
p_comm_lines_api_rec.ATTRIBUTE95),
ATTRIBUTE96 = DECODE(p_comm_lines_api_rec.ATTRIBUTE96,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE96,
p_comm_lines_api_rec.ATTRIBUTE96),
ATTRIBUTE97 = DECODE(p_comm_lines_api_rec.ATTRIBUTE97,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE97,
p_comm_lines_api_rec.ATTRIBUTE97),
ATTRIBUTE98 = DECODE(p_comm_lines_api_rec.ATTRIBUTE98,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE98,
p_comm_lines_api_rec.ATTRIBUTE98),
ATTRIBUTE99 = DECODE(p_comm_lines_api_rec.ATTRIBUTE99,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE99,
p_comm_lines_api_rec.ATTRIBUTE99),
ATTRIBUTE100 = DECODE(p_comm_lines_api_rec.ATTRIBUTE100,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE100,
p_comm_lines_api_rec.ATTRIBUTE100),
CONC_BATCH_ID = DECODE(p_comm_lines_api_rec.CONC_BATCH_ID,
FND_API.G_MISS_NUM,
oldrec.CONC_BATCH_ID,
p_comm_lines_api_rec.CONC_BATCH_ID),
PROCESS_BATCH_ID = DECODE(p_comm_lines_api_rec.PROCESS_BATCH_ID,
FND_API.G_MISS_NUM,
oldrec.PROCESS_BATCH_ID,
p_comm_lines_api_rec.PROCESS_BATCH_ID),
SALESREP_NUMBER = DECODE(p_comm_lines_api_rec.SALESREP_NUMBER,
FND_API.G_MISS_NUM,
oldrec.SALESREP_NUMBER,
p_comm_lines_api_rec.SALESREP_NUMBER),
ROLLUP_DATE = DECODE(p_comm_lines_api_rec.ROLLUP_DATE,
FND_API.G_MISS_DATE,
oldrec.ROLLUP_DATE,
p_comm_lines_api_rec.ROLLUP_DATE),
SOURCE_DOC_ID = DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_DOC_ID,
p_comm_lines_api_rec.SOURCE_DOC_ID),
SOURCE_DOC_TYPE = DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE,
FND_API.G_MISS_CHAR,
oldrec.SOURCE_DOC_TYPE,
p_comm_lines_api_rec.SOURCE_DOC_TYPE),
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_DATE = Sysdate,
LAST_UPDATE_LOGIN = fnd_global.login_id,
TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
FND_API.G_MISS_CHAR,
oldrec.TRANSACTION_CURRENCY_CODE,
p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
EXCHANGE_RATE = DECODE(p_comm_lines_api_rec.EXCHANGE_RATE,
FND_API.G_MISS_NUM,
oldrec.EXCHANGE_RATE,
p_comm_lines_api_rec.EXCHANGE_RATE),
ACCTD_TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.ACCTD_TRANSACTION_AMOUNT,
p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT),
TRX_ID = DECODE(p_comm_lines_api_rec.TRX_ID,
FND_API.G_MISS_NUM,
oldrec.TRX_ID,
p_comm_lines_api_rec.TRX_ID),
TRX_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.TRX_LINE_ID,
p_comm_lines_api_rec.TRX_LINE_ID),
TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_SALES_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.TRX_SALES_LINE_ID,
p_comm_lines_api_rec.TRX_SALES_LINE_ID),
QUANTITY = DECODE(p_comm_lines_api_rec.QUANTITY,
FND_API.G_MISS_NUM,
oldrec.QUANTITY,
p_comm_lines_api_rec.QUANTITY),
SOURCE_TRX_NUMBER = DECODE(p_comm_lines_api_rec.SOURCE_TRX_NUMBER,
FND_API.G_MISS_CHAR,
oldrec.SOURCE_TRX_NUMBER,
p_comm_lines_api_rec.SOURCE_TRX_NUMBER),
DISCOUNT_PERCENTAGE = DECODE(p_comm_lines_api_rec.DISCOUNT_PERCENTAGE,
FND_API.G_MISS_NUM,
oldrec.DISCOUNT_PERCENTAGE,
p_comm_lines_api_rec.DISCOUNT_PERCENTAGE),
MARGIN_PERCENTAGE = DECODE(p_comm_lines_api_rec.MARGIN_PERCENTAGE,
FND_API.G_MISS_NUM,
oldrec.MARGIN_PERCENTAGE,
p_comm_lines_api_rec.MARGIN_PERCENTAGE),
SOURCE_TRX_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_TRX_ID,
p_comm_lines_api_rec.SOURCE_TRX_ID),
SOURCE_TRX_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_TRX_LINE_ID,
p_comm_lines_api_rec.SOURCE_TRX_LINE_ID),
SOURCE_TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_TRX_SALES_LINE_ID,
p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID),
NEGATED_FLAG = DECODE(p_comm_lines_api_rec.NEGATED_FLAG,
FND_API.G_MISS_CHAR,
oldrec.NEGATED_FLAG,
p_comm_lines_api_rec.NEGATED_FLAG),
CUSTOMER_ID = DECODE(p_comm_lines_api_rec.CUSTOMER_ID,
FND_API.G_MISS_NUM,
oldrec.CUSTOMER_ID,
p_comm_lines_api_rec.CUSTOMER_ID),
INVENTORY_ITEM_ID = DECODE(p_comm_lines_api_rec.INVENTORY_ITEM_ID,
FND_API.G_MISS_NUM,
oldrec.INVENTORY_ITEM_ID,
p_comm_lines_api_rec.INVENTORY_ITEM_ID),
ORDER_NUMBER = DECODE(p_comm_lines_api_rec.ORDER_NUMBER,
FND_API.G_MISS_NUM,
oldrec.ORDER_NUMBER,
p_comm_lines_api_rec.ORDER_NUMBER),
BOOKED_DATE = DECODE(p_comm_lines_api_rec.BOOKED_DATE,
FND_API.G_MISS_DATE,
oldrec.BOOKED_DATE,
p_comm_lines_api_rec.BOOKED_DATE),
INVOICE_NUMBER = DECODE(p_comm_lines_api_rec.INVOICE_NUMBER,
FND_API.G_MISS_CHAR,
oldrec.INVOICE_NUMBER,
p_comm_lines_api_rec.INVOICE_NUMBER),
INVOICE_DATE = DECODE(p_comm_lines_api_rec.INVOICE_DATE,
FND_API.G_MISS_DATE,
oldrec.INVOICE_DATE,
p_comm_lines_api_rec.INVOICE_DATE),
ADJUST_DATE = DECODE(p_comm_lines_api_rec.ADJUST_DATE,
FND_API.G_MISS_DATE,
oldrec.ADJUST_DATE,
p_comm_lines_api_rec.ADJUST_DATE),
ADJUSTED_BY = DECODE(p_comm_lines_api_rec.ADJUSTED_BY,
FND_API.G_MISS_CHAR,
oldrec.ADJUSTED_BY,
p_comm_lines_api_rec.ADJUSTED_BY),
REVENUE_TYPE = DECODE(p_comm_lines_api_rec.REVENUE_TYPE,
FND_API.G_MISS_CHAR,
oldrec.REVENUE_TYPE,
p_comm_lines_api_rec.REVENUE_TYPE),
ADJUST_ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG,
FND_API.G_MISS_CHAR,
oldrec.ADJUST_ROLLUP_FLAG,
p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG),
ADJUST_COMMENTS = DECODE(p_comm_lines_api_rec.ADJUST_COMMENTS,
FND_API.G_MISS_CHAR,
oldrec.ADJUST_COMMENTS,
p_comm_lines_api_rec.ADJUST_COMMENTS),
ADJUST_STATUS = NVL(DECODE(p_comm_lines_api_rec.ADJUST_STATUS,
FND_API.G_MISS_CHAR,
oldrec.ADJUST_STATUS,
p_comm_lines_api_rec.ADJUST_STATUS),'NEW'),
LINE_NUMBER = DECODE(p_comm_lines_api_rec.LINE_NUMBER,
FND_API.G_MISS_NUM,
oldrec.LINE_NUMBER,
p_comm_lines_api_rec.LINE_NUMBER),
BILL_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.BILL_TO_ADDRESS_ID,
FND_API.G_MISS_NUM,
oldrec.BILL_TO_ADDRESS_ID,
p_comm_lines_api_rec.BILL_TO_ADDRESS_ID),
SHIP_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID,
FND_API.G_MISS_NUM,
oldrec.SHIP_TO_ADDRESS_ID,
p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID),
BILL_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.BILL_TO_CONTACT_ID,
FND_API.G_MISS_NUM,
oldrec.BILL_TO_CONTACT_ID,
p_comm_lines_api_rec.BILL_TO_CONTACT_ID),
SHIP_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_CONTACT_ID,
FND_API.G_MISS_NUM,
oldrec.SHIP_TO_CONTACT_ID,
p_comm_lines_api_rec.SHIP_TO_CONTACT_ID),
ADJ_COMM_LINES_API_ID = DECODE(p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID,
FND_API.G_MISS_NUM,
oldrec.ADJ_COMM_LINES_API_ID,
p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID),
PRE_DEFINED_RC_FLAG = DECODE(p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG,
FND_API.G_MISS_CHAR,
oldrec.PRE_DEFINED_RC_FLAG,
p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG),
ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ROLLUP_FLAG,
FND_API.G_MISS_CHAR,
oldrec.ROLLUP_FLAG,
p_comm_lines_api_rec.ROLLUP_FLAG),
FORECAST_ID = DECODE(p_comm_lines_api_rec.FORECAST_ID,
FND_API.G_MISS_NUM,
oldrec.FORECAST_ID,
p_comm_lines_api_rec.FORECAST_ID),
UPSIDE_QUANTITY = DECODE(p_comm_lines_api_rec.UPSIDE_QUANTITY,
FND_API.G_MISS_NUM,
oldrec.UPSIDE_QUANTITY,
p_comm_lines_api_rec.UPSIDE_QUANTITY),
UPSIDE_AMOUNT = DECODE(p_comm_lines_api_rec.UPSIDE_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.UPSIDE_AMOUNT,
p_comm_lines_api_rec.UPSIDE_AMOUNT),
UOM_CODE = DECODE(p_comm_lines_api_rec.UOM_CODE,
FND_API.G_MISS_CHAR,
oldrec.UOM_CODE,
p_comm_lines_api_rec.UOM_CODE),
REASON_CODE = DECODE(p_comm_lines_api_rec.REASON_CODE,
FND_API.G_MISS_CHAR,
oldrec.REASON_CODE,
p_comm_lines_api_rec.REASON_CODE),
TYPE = DECODE(p_comm_lines_api_rec.TYPE,
FND_API.G_MISS_CHAR,
oldrec.TYPE,
p_comm_lines_api_rec.TYPE),
PRE_PROCESSED_CODE = DECODE(p_comm_lines_api_rec.PRE_PROCESSED_CODE,
FND_API.G_MISS_CHAR,
oldrec.PRE_PROCESSED_CODE,
p_comm_lines_api_rec.PRE_PROCESSED_CODE),
QUOTA_ID = DECODE(p_comm_lines_api_rec.QUOTA_ID,
FND_API.G_MISS_NUM,
oldrec.QUOTA_ID,
p_comm_lines_api_rec.QUOTA_ID),
SRP_PLAN_ASSIGN_ID = DECODE(p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID,
FND_API.G_MISS_NUM,
oldrec.SRP_PLAN_ASSIGN_ID,
p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID),
ROLE_ID = DECODE(p_comm_lines_api_rec.ROLE_ID,
FND_API.G_MISS_NUM,
oldrec.ROLE_ID,
p_comm_lines_api_rec.ROLE_ID),
COMP_GROUP_ID = DECODE(p_comm_lines_api_rec.COMP_GROUP_ID,
FND_API.G_MISS_NUM,
oldrec.COMP_GROUP_ID,
p_comm_lines_api_rec.COMP_GROUP_ID),
COMMISSION_AMOUNT = DECODE(p_comm_lines_api_rec.COMMISSION_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.COMMISSION_AMOUNT,
p_comm_lines_api_rec.COMMISSION_AMOUNT),
EMPLOYEE_NUMBER = DECODE(p_comm_lines_api_rec.EMPLOYEE_NUMBER,
FND_API.G_MISS_CHAR,
oldrec.EMPLOYEE_NUMBER,
p_comm_lines_api_rec.EMPLOYEE_NUMBER),
REVERSAL_FLAG = DECODE(p_comm_lines_api_rec.REVERSAL_FLAG,
FND_API.G_MISS_CHAR,
oldrec.REVERSAL_FLAG,
p_comm_lines_api_rec.REVERSAL_FLAG),
REVERSAL_HEADER_ID = DECODE(p_comm_lines_api_rec.REVERSAL_HEADER_ID,
FND_API.G_MISS_NUM,
oldrec.REVERSAL_HEADER_ID,
p_comm_lines_api_rec.REVERSAL_HEADER_ID),
SALES_CHANNEL = DECODE(p_comm_lines_api_rec.SALES_CHANNEL,
FND_API.G_MISS_CHAR,
oldrec.SALES_CHANNEL,
p_comm_lines_api_rec.SALES_CHANNEL),
OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
SPLIT_PCT = DECODE(p_comm_lines_api_rec.SPLIT_PCT,
FND_API.G_MISS_NUM,
oldrec.SPLIT_PCT,
p_comm_lines_api_rec.SPLIT_PCT),
SPLIT_STATUS = DECODE(p_comm_lines_api_rec.SPLIT_STATUS,
FND_API.G_MISS_CHAR,
oldrec.SPLIT_STATUS,
p_comm_lines_api_rec.SPLIT_STATUS)
WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
END update_row;
PROCEDURE lock_update_row
( p_comm_lines_api_rec IN COMM_LINES_API_REC_TYPE) IS
CURSOR c IS
SELECT object_version_number
FROM CN_COMM_LINES_API
WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
UPDATE CN_COMM_LINES_API oldrec
SET
SALESREP_ID = DECODE(p_comm_lines_api_rec.SALESREP_ID,
FND_API.G_MISS_NUM,
oldrec.SALESREP_ID,
p_comm_lines_api_rec.SALESREP_ID),
PROCESSED_DATE = DECODE(p_comm_lines_api_rec.PROCESSED_DATE,
FND_API.G_MISS_DATE,
oldrec.PROCESSED_DATE,
p_comm_lines_api_rec.PROCESSED_DATE),
PROCESSED_PERIOD_ID = DECODE(p_comm_lines_api_rec.PROCESSED_PERIOD_ID,
FND_API.G_MISS_NUM,
oldrec.PROCESSED_PERIOD_ID,
p_comm_lines_api_rec.PROCESSED_PERIOD_ID),
TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.TRANSACTION_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.TRANSACTION_AMOUNT,
p_comm_lines_api_rec.TRANSACTION_AMOUNT),
TRX_TYPE = DECODE(p_comm_lines_api_rec.TRX_TYPE,
FND_API.G_MISS_CHAR,
oldrec.TRX_TYPE,
p_comm_lines_api_rec.TRX_TYPE),
REVENUE_CLASS_ID = DECODE(p_comm_lines_api_rec.REVENUE_CLASS_ID,
FND_API.G_MISS_NUM,
oldrec.REVENUE_CLASS_ID,
p_comm_lines_api_rec.REVENUE_CLASS_ID),
LOAD_STATUS = DECODE(p_comm_lines_api_rec.LOAD_STATUS,
FND_API.G_MISS_CHAR,
oldrec.LOAD_STATUS,
p_comm_lines_api_rec.LOAD_STATUS),
ATTRIBUTE_CATEGORY = DECODE(p_comm_lines_api_rec.ATTRIBUTE_CATEGORY,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE_CATEGORY,
p_comm_lines_api_rec.ATTRIBUTE_CATEGORY),
ATTRIBUTE1 = DECODE(p_comm_lines_api_rec.ATTRIBUTE1,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE1,
p_comm_lines_api_rec.ATTRIBUTE1),
ATTRIBUTE2 = DECODE(p_comm_lines_api_rec.ATTRIBUTE2,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE2,
p_comm_lines_api_rec.ATTRIBUTE2),
ATTRIBUTE3 = DECODE(p_comm_lines_api_rec.ATTRIBUTE3,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE3,
p_comm_lines_api_rec.ATTRIBUTE3),
ATTRIBUTE4 = DECODE(p_comm_lines_api_rec.ATTRIBUTE4,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE4,
p_comm_lines_api_rec.ATTRIBUTE4),
ATTRIBUTE5 = DECODE(p_comm_lines_api_rec.ATTRIBUTE5,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE5,
p_comm_lines_api_rec.ATTRIBUTE5),
ATTRIBUTE6 = DECODE(p_comm_lines_api_rec.ATTRIBUTE6,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE6,
p_comm_lines_api_rec.ATTRIBUTE6),
ATTRIBUTE7 = DECODE(p_comm_lines_api_rec.ATTRIBUTE7,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE7,
p_comm_lines_api_rec.ATTRIBUTE7),
ATTRIBUTE8 = DECODE(p_comm_lines_api_rec.ATTRIBUTE8,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE8,
p_comm_lines_api_rec.ATTRIBUTE8),
ATTRIBUTE9 = DECODE(p_comm_lines_api_rec.ATTRIBUTE9,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE9,
p_comm_lines_api_rec.ATTRIBUTE9),
ATTRIBUTE10 = DECODE(p_comm_lines_api_rec.ATTRIBUTE10,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE10,
p_comm_lines_api_rec.ATTRIBUTE10),
ATTRIBUTE11 = DECODE(p_comm_lines_api_rec.ATTRIBUTE11,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE11,
p_comm_lines_api_rec.ATTRIBUTE11),
ATTRIBUTE12 = DECODE(p_comm_lines_api_rec.ATTRIBUTE12,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE12,
p_comm_lines_api_rec.ATTRIBUTE12),
ATTRIBUTE13 = DECODE(p_comm_lines_api_rec.ATTRIBUTE13,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE13,
p_comm_lines_api_rec.ATTRIBUTE13),
ATTRIBUTE14 = DECODE(p_comm_lines_api_rec.ATTRIBUTE14,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE14,
p_comm_lines_api_rec.ATTRIBUTE14),
ATTRIBUTE15 = DECODE(p_comm_lines_api_rec.ATTRIBUTE15,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE15,
p_comm_lines_api_rec.ATTRIBUTE15),
ATTRIBUTE16 = DECODE(p_comm_lines_api_rec.ATTRIBUTE16,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE16,
p_comm_lines_api_rec.ATTRIBUTE16),
ATTRIBUTE17 = DECODE(p_comm_lines_api_rec.ATTRIBUTE17,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE17,
p_comm_lines_api_rec.ATTRIBUTE17),
ATTRIBUTE18 = DECODE(p_comm_lines_api_rec.ATTRIBUTE18,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE18,
p_comm_lines_api_rec.ATTRIBUTE18),
ATTRIBUTE19 = DECODE(p_comm_lines_api_rec.ATTRIBUTE19,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE19,
p_comm_lines_api_rec.ATTRIBUTE19),
ATTRIBUTE20 = DECODE(p_comm_lines_api_rec.ATTRIBUTE20,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE20,
p_comm_lines_api_rec.ATTRIBUTE20),
ATTRIBUTE21 = DECODE(p_comm_lines_api_rec.ATTRIBUTE21,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE21,
p_comm_lines_api_rec.ATTRIBUTE21),
ATTRIBUTE22 = DECODE(p_comm_lines_api_rec.ATTRIBUTE22,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE22,
p_comm_lines_api_rec.ATTRIBUTE22),
ATTRIBUTE23 = DECODE(p_comm_lines_api_rec.ATTRIBUTE23,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE23,
p_comm_lines_api_rec.ATTRIBUTE23),
ATTRIBUTE24 = DECODE(p_comm_lines_api_rec.ATTRIBUTE24,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE24,
p_comm_lines_api_rec.ATTRIBUTE24),
ATTRIBUTE25 = DECODE(p_comm_lines_api_rec.ATTRIBUTE25,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE25,
p_comm_lines_api_rec.ATTRIBUTE25),
ATTRIBUTE26 = DECODE(p_comm_lines_api_rec.ATTRIBUTE26,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE26,
p_comm_lines_api_rec.ATTRIBUTE26),
ATTRIBUTE27 = DECODE(p_comm_lines_api_rec.ATTRIBUTE27,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE27,
p_comm_lines_api_rec.ATTRIBUTE27),
ATTRIBUTE28 = DECODE(p_comm_lines_api_rec.ATTRIBUTE28,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE28,
p_comm_lines_api_rec.ATTRIBUTE28),
ATTRIBUTE29 = DECODE(p_comm_lines_api_rec.ATTRIBUTE29,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE29,
p_comm_lines_api_rec.ATTRIBUTE29),
ATTRIBUTE30 = DECODE(p_comm_lines_api_rec.ATTRIBUTE30,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE30,
p_comm_lines_api_rec.ATTRIBUTE30),
ATTRIBUTE31 = DECODE(p_comm_lines_api_rec.ATTRIBUTE31,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE31,
p_comm_lines_api_rec.ATTRIBUTE31),
ATTRIBUTE32 = DECODE(p_comm_lines_api_rec.ATTRIBUTE32,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE32,
p_comm_lines_api_rec.ATTRIBUTE32),
ATTRIBUTE33 = DECODE(p_comm_lines_api_rec.ATTRIBUTE33,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE33,
p_comm_lines_api_rec.ATTRIBUTE33),
ATTRIBUTE34 = DECODE(p_comm_lines_api_rec.ATTRIBUTE34,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE34,
p_comm_lines_api_rec.ATTRIBUTE34),
ATTRIBUTE35 = DECODE(p_comm_lines_api_rec.ATTRIBUTE35,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE35,
p_comm_lines_api_rec.ATTRIBUTE35),
ATTRIBUTE36 = DECODE(p_comm_lines_api_rec.ATTRIBUTE36,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE36,
p_comm_lines_api_rec.ATTRIBUTE36),
ATTRIBUTE37 = DECODE(p_comm_lines_api_rec.ATTRIBUTE37,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE37,
p_comm_lines_api_rec.ATTRIBUTE37),
ATTRIBUTE38 = DECODE(p_comm_lines_api_rec.ATTRIBUTE38,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE38,
p_comm_lines_api_rec.ATTRIBUTE38),
ATTRIBUTE39 = DECODE(p_comm_lines_api_rec.ATTRIBUTE39,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE39,
p_comm_lines_api_rec.ATTRIBUTE39),
ATTRIBUTE40 = DECODE(p_comm_lines_api_rec.ATTRIBUTE40,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE40,
p_comm_lines_api_rec.ATTRIBUTE40),
ATTRIBUTE41 = DECODE(p_comm_lines_api_rec.ATTRIBUTE41,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE41,
p_comm_lines_api_rec.ATTRIBUTE41),
ATTRIBUTE42 = DECODE(p_comm_lines_api_rec.ATTRIBUTE42,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE42,
p_comm_lines_api_rec.ATTRIBUTE42),
ATTRIBUTE43 = DECODE(p_comm_lines_api_rec.ATTRIBUTE43,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE43,
p_comm_lines_api_rec.ATTRIBUTE43),
ATTRIBUTE44 = DECODE(p_comm_lines_api_rec.ATTRIBUTE44,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE44,
p_comm_lines_api_rec.ATTRIBUTE44),
ATTRIBUTE45 = DECODE(p_comm_lines_api_rec.ATTRIBUTE45,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE45,
p_comm_lines_api_rec.ATTRIBUTE45),
ATTRIBUTE46 = DECODE(p_comm_lines_api_rec.ATTRIBUTE46,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE46,
p_comm_lines_api_rec.ATTRIBUTE46),
ATTRIBUTE47 = DECODE(p_comm_lines_api_rec.ATTRIBUTE47,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE47,
p_comm_lines_api_rec.ATTRIBUTE47),
ATTRIBUTE48 = DECODE(p_comm_lines_api_rec.ATTRIBUTE48,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE48,
p_comm_lines_api_rec.ATTRIBUTE48),
ATTRIBUTE49 = DECODE(p_comm_lines_api_rec.ATTRIBUTE49,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE49,
p_comm_lines_api_rec.ATTRIBUTE49),
ATTRIBUTE50 = DECODE(p_comm_lines_api_rec.ATTRIBUTE50,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE50,
p_comm_lines_api_rec.ATTRIBUTE50),
ATTRIBUTE51 = DECODE(p_comm_lines_api_rec.ATTRIBUTE51,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE51,
p_comm_lines_api_rec.ATTRIBUTE51),
ATTRIBUTE52 = DECODE(p_comm_lines_api_rec.ATTRIBUTE52,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE52,
p_comm_lines_api_rec.ATTRIBUTE52),
ATTRIBUTE53 = DECODE(p_comm_lines_api_rec.ATTRIBUTE53,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE53,
p_comm_lines_api_rec.ATTRIBUTE53),
ATTRIBUTE54 = DECODE(p_comm_lines_api_rec.ATTRIBUTE54,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE54,
p_comm_lines_api_rec.ATTRIBUTE54),
ATTRIBUTE55 = DECODE(p_comm_lines_api_rec.ATTRIBUTE55,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE55,
p_comm_lines_api_rec.ATTRIBUTE55),
ATTRIBUTE56 = DECODE(p_comm_lines_api_rec.ATTRIBUTE56,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE56,
p_comm_lines_api_rec.ATTRIBUTE56),
ATTRIBUTE57 = DECODE(p_comm_lines_api_rec.ATTRIBUTE57,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE57,
p_comm_lines_api_rec.ATTRIBUTE57),
ATTRIBUTE58 = DECODE(p_comm_lines_api_rec.ATTRIBUTE58,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE58,
p_comm_lines_api_rec.ATTRIBUTE58),
ATTRIBUTE59 = DECODE(p_comm_lines_api_rec.ATTRIBUTE59,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE59,
p_comm_lines_api_rec.ATTRIBUTE59),
ATTRIBUTE60 = DECODE(p_comm_lines_api_rec.ATTRIBUTE60,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE60,
p_comm_lines_api_rec.ATTRIBUTE60),
ATTRIBUTE61 = DECODE(p_comm_lines_api_rec.ATTRIBUTE61,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE61,
p_comm_lines_api_rec.ATTRIBUTE61),
ATTRIBUTE62 = DECODE(p_comm_lines_api_rec.ATTRIBUTE62,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE62,
p_comm_lines_api_rec.ATTRIBUTE62),
ATTRIBUTE63 = DECODE(p_comm_lines_api_rec.ATTRIBUTE63,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE63,
p_comm_lines_api_rec.ATTRIBUTE63),
ATTRIBUTE64 = DECODE(p_comm_lines_api_rec.ATTRIBUTE64,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE64,
p_comm_lines_api_rec.ATTRIBUTE64),
ATTRIBUTE65 = DECODE(p_comm_lines_api_rec.ATTRIBUTE65,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE65,
p_comm_lines_api_rec.ATTRIBUTE65),
ATTRIBUTE66 = DECODE(p_comm_lines_api_rec.ATTRIBUTE66,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE66,
p_comm_lines_api_rec.ATTRIBUTE66),
ATTRIBUTE67 = DECODE(p_comm_lines_api_rec.ATTRIBUTE67,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE67,
p_comm_lines_api_rec.ATTRIBUTE67),
ATTRIBUTE68 = DECODE(p_comm_lines_api_rec.ATTRIBUTE68,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE68,
p_comm_lines_api_rec.ATTRIBUTE68),
ATTRIBUTE69 = DECODE(p_comm_lines_api_rec.ATTRIBUTE69,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE69,
p_comm_lines_api_rec.ATTRIBUTE69),
ATTRIBUTE70 = DECODE(p_comm_lines_api_rec.ATTRIBUTE70,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE70,
p_comm_lines_api_rec.ATTRIBUTE70),
ATTRIBUTE71 = DECODE(p_comm_lines_api_rec.ATTRIBUTE71,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE71,
p_comm_lines_api_rec.ATTRIBUTE71),
ATTRIBUTE72 = DECODE(p_comm_lines_api_rec.ATTRIBUTE72,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE72,
p_comm_lines_api_rec.ATTRIBUTE72),
ATTRIBUTE73 = DECODE(p_comm_lines_api_rec.ATTRIBUTE73,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE73,
p_comm_lines_api_rec.ATTRIBUTE73),
ATTRIBUTE74 = DECODE(p_comm_lines_api_rec.ATTRIBUTE74,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE74,
p_comm_lines_api_rec.ATTRIBUTE74),
ATTRIBUTE75 = DECODE(p_comm_lines_api_rec.ATTRIBUTE75,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE75,
p_comm_lines_api_rec.ATTRIBUTE75),
ATTRIBUTE76 = DECODE(p_comm_lines_api_rec.ATTRIBUTE76,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE76,
p_comm_lines_api_rec.ATTRIBUTE76),
ATTRIBUTE77 = DECODE(p_comm_lines_api_rec.ATTRIBUTE77,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE77,
p_comm_lines_api_rec.ATTRIBUTE77),
ATTRIBUTE78 = DECODE(p_comm_lines_api_rec.ATTRIBUTE78,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE78,
p_comm_lines_api_rec.ATTRIBUTE78),
ATTRIBUTE79 = DECODE(p_comm_lines_api_rec.ATTRIBUTE79,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE79,
p_comm_lines_api_rec.ATTRIBUTE79),
ATTRIBUTE80 = DECODE(p_comm_lines_api_rec.ATTRIBUTE80,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE80,
p_comm_lines_api_rec.ATTRIBUTE80),
ATTRIBUTE81 = DECODE(p_comm_lines_api_rec.ATTRIBUTE81,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE81,
p_comm_lines_api_rec.ATTRIBUTE81),
ATTRIBUTE82 = DECODE(p_comm_lines_api_rec.ATTRIBUTE82,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE82,
p_comm_lines_api_rec.ATTRIBUTE82),
ATTRIBUTE83 = DECODE(p_comm_lines_api_rec.ATTRIBUTE83,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE83,
p_comm_lines_api_rec.ATTRIBUTE83),
ATTRIBUTE84 = DECODE(p_comm_lines_api_rec.ATTRIBUTE84,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE84,
p_comm_lines_api_rec.ATTRIBUTE84),
ATTRIBUTE85 = DECODE(p_comm_lines_api_rec.ATTRIBUTE85,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE85,
p_comm_lines_api_rec.ATTRIBUTE85),
ATTRIBUTE86 = DECODE(p_comm_lines_api_rec.ATTRIBUTE86,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE86,
p_comm_lines_api_rec.ATTRIBUTE86),
ATTRIBUTE87 = DECODE(p_comm_lines_api_rec.ATTRIBUTE87,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE87,
p_comm_lines_api_rec.ATTRIBUTE87),
ATTRIBUTE88 = DECODE(p_comm_lines_api_rec.ATTRIBUTE88,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE88,
p_comm_lines_api_rec.ATTRIBUTE88),
ATTRIBUTE89 = DECODE(p_comm_lines_api_rec.ATTRIBUTE89,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE89,
p_comm_lines_api_rec.ATTRIBUTE89),
ATTRIBUTE90 = DECODE(p_comm_lines_api_rec.ATTRIBUTE90,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE90,
p_comm_lines_api_rec.ATTRIBUTE90),
ATTRIBUTE91 = DECODE(p_comm_lines_api_rec.ATTRIBUTE91,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE91,
p_comm_lines_api_rec.ATTRIBUTE91),
ATTRIBUTE92 = DECODE(p_comm_lines_api_rec.ATTRIBUTE92,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE92,
p_comm_lines_api_rec.ATTRIBUTE92),
ATTRIBUTE93 = DECODE(p_comm_lines_api_rec.ATTRIBUTE93,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE93,
p_comm_lines_api_rec.ATTRIBUTE93),
ATTRIBUTE94 = DECODE(p_comm_lines_api_rec.ATTRIBUTE94,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE94,
p_comm_lines_api_rec.ATTRIBUTE94),
ATTRIBUTE95 = DECODE(p_comm_lines_api_rec.ATTRIBUTE95,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE95,
p_comm_lines_api_rec.ATTRIBUTE95),
ATTRIBUTE96 = DECODE(p_comm_lines_api_rec.ATTRIBUTE96,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE96,
p_comm_lines_api_rec.ATTRIBUTE96),
ATTRIBUTE97 = DECODE(p_comm_lines_api_rec.ATTRIBUTE97,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE97,
p_comm_lines_api_rec.ATTRIBUTE97),
ATTRIBUTE98 = DECODE(p_comm_lines_api_rec.ATTRIBUTE98,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE98,
p_comm_lines_api_rec.ATTRIBUTE98),
ATTRIBUTE99 = DECODE(p_comm_lines_api_rec.ATTRIBUTE99,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE99,
p_comm_lines_api_rec.ATTRIBUTE99),
ATTRIBUTE100 = DECODE(p_comm_lines_api_rec.ATTRIBUTE100,
FND_API.G_MISS_CHAR,
oldrec.ATTRIBUTE100,
p_comm_lines_api_rec.ATTRIBUTE100),
CONC_BATCH_ID = DECODE(p_comm_lines_api_rec.CONC_BATCH_ID,
FND_API.G_MISS_NUM,
oldrec.CONC_BATCH_ID,
p_comm_lines_api_rec.CONC_BATCH_ID),
PROCESS_BATCH_ID = DECODE(p_comm_lines_api_rec.PROCESS_BATCH_ID,
FND_API.G_MISS_NUM,
oldrec.PROCESS_BATCH_ID,
p_comm_lines_api_rec.PROCESS_BATCH_ID),
SALESREP_NUMBER = DECODE(p_comm_lines_api_rec.SALESREP_NUMBER,
FND_API.G_MISS_NUM,
oldrec.SALESREP_NUMBER,
p_comm_lines_api_rec.SALESREP_NUMBER),
ROLLUP_DATE = DECODE(p_comm_lines_api_rec.ROLLUP_DATE,
FND_API.G_MISS_DATE,
oldrec.ROLLUP_DATE,
p_comm_lines_api_rec.ROLLUP_DATE),
SOURCE_DOC_ID = DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_DOC_ID,
p_comm_lines_api_rec.SOURCE_DOC_ID),
SOURCE_DOC_TYPE = DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE,
FND_API.G_MISS_CHAR,
oldrec.SOURCE_DOC_TYPE,
p_comm_lines_api_rec.SOURCE_DOC_TYPE),
LAST_UPDATED_BY = fnd_global.user_id,
LAST_UPDATE_DATE = Sysdate,
LAST_UPDATE_LOGIN = fnd_global.login_id,
TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
FND_API.G_MISS_CHAR,
oldrec.TRANSACTION_CURRENCY_CODE,
p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
EXCHANGE_RATE = DECODE(p_comm_lines_api_rec.EXCHANGE_RATE,
FND_API.G_MISS_NUM,
oldrec.EXCHANGE_RATE,
p_comm_lines_api_rec.EXCHANGE_RATE),
ACCTD_TRANSACTION_AMOUNT = DECODE(p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.ACCTD_TRANSACTION_AMOUNT,
p_comm_lines_api_rec.ACCTD_TRANSACTION_AMOUNT),
TRX_ID = DECODE(p_comm_lines_api_rec.TRX_ID,
FND_API.G_MISS_NUM,
oldrec.TRX_ID,
p_comm_lines_api_rec.TRX_ID),
TRX_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.TRX_LINE_ID,
p_comm_lines_api_rec.TRX_LINE_ID),
TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.TRX_SALES_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.TRX_SALES_LINE_ID,
p_comm_lines_api_rec.TRX_SALES_LINE_ID),
QUANTITY = DECODE(p_comm_lines_api_rec.QUANTITY,
FND_API.G_MISS_NUM,
oldrec.QUANTITY,
p_comm_lines_api_rec.QUANTITY),
SOURCE_TRX_NUMBER = DECODE(p_comm_lines_api_rec.SOURCE_TRX_NUMBER,
FND_API.G_MISS_CHAR,
oldrec.SOURCE_TRX_NUMBER,
p_comm_lines_api_rec.SOURCE_TRX_NUMBER),
DISCOUNT_PERCENTAGE = DECODE(p_comm_lines_api_rec.DISCOUNT_PERCENTAGE,
FND_API.G_MISS_NUM,
oldrec.DISCOUNT_PERCENTAGE,
p_comm_lines_api_rec.DISCOUNT_PERCENTAGE),
MARGIN_PERCENTAGE = DECODE(p_comm_lines_api_rec.MARGIN_PERCENTAGE,
FND_API.G_MISS_NUM,
oldrec.MARGIN_PERCENTAGE,
p_comm_lines_api_rec.MARGIN_PERCENTAGE),
SOURCE_TRX_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_TRX_ID,
p_comm_lines_api_rec.SOURCE_TRX_ID),
SOURCE_TRX_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_TRX_LINE_ID,
p_comm_lines_api_rec.SOURCE_TRX_LINE_ID),
SOURCE_TRX_SALES_LINE_ID = DECODE(p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID,
FND_API.G_MISS_NUM,
oldrec.SOURCE_TRX_SALES_LINE_ID,
p_comm_lines_api_rec.SOURCE_TRX_SALES_LINE_ID),
NEGATED_FLAG = DECODE(p_comm_lines_api_rec.NEGATED_FLAG,
FND_API.G_MISS_CHAR,
oldrec.NEGATED_FLAG,
p_comm_lines_api_rec.NEGATED_FLAG),
CUSTOMER_ID = DECODE(p_comm_lines_api_rec.CUSTOMER_ID,
FND_API.G_MISS_NUM,
oldrec.CUSTOMER_ID,
p_comm_lines_api_rec.CUSTOMER_ID),
INVENTORY_ITEM_ID = DECODE(p_comm_lines_api_rec.INVENTORY_ITEM_ID,
FND_API.G_MISS_NUM,
oldrec.INVENTORY_ITEM_ID,
p_comm_lines_api_rec.INVENTORY_ITEM_ID),
ORDER_NUMBER = DECODE(p_comm_lines_api_rec.ORDER_NUMBER,
FND_API.G_MISS_NUM,
oldrec.ORDER_NUMBER,
p_comm_lines_api_rec.ORDER_NUMBER),
BOOKED_DATE = DECODE(p_comm_lines_api_rec.BOOKED_DATE,
FND_API.G_MISS_DATE,
oldrec.BOOKED_DATE,
p_comm_lines_api_rec.BOOKED_DATE),
INVOICE_NUMBER = DECODE(p_comm_lines_api_rec.INVOICE_NUMBER,
FND_API.G_MISS_CHAR,
oldrec.INVOICE_NUMBER,
p_comm_lines_api_rec.INVOICE_NUMBER),
INVOICE_DATE = DECODE(p_comm_lines_api_rec.INVOICE_DATE,
FND_API.G_MISS_DATE,
oldrec.INVOICE_DATE,
p_comm_lines_api_rec.INVOICE_DATE),
ADJUST_DATE = DECODE(p_comm_lines_api_rec.ADJUST_DATE,
FND_API.G_MISS_DATE,
oldrec.ADJUST_DATE,
p_comm_lines_api_rec.ADJUST_DATE),
ADJUSTED_BY = DECODE(p_comm_lines_api_rec.ADJUSTED_BY,
FND_API.G_MISS_CHAR,
oldrec.ADJUSTED_BY,
p_comm_lines_api_rec.ADJUSTED_BY),
REVENUE_TYPE = DECODE(p_comm_lines_api_rec.REVENUE_TYPE,
FND_API.G_MISS_CHAR,
oldrec.REVENUE_TYPE,
p_comm_lines_api_rec.REVENUE_TYPE),
ADJUST_ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG,
FND_API.G_MISS_CHAR,
oldrec.ADJUST_ROLLUP_FLAG,
p_comm_lines_api_rec.ADJUST_ROLLUP_FLAG),
ADJUST_COMMENTS = DECODE(p_comm_lines_api_rec.ADJUST_COMMENTS,
FND_API.G_MISS_CHAR,
oldrec.ADJUST_COMMENTS,
p_comm_lines_api_rec.ADJUST_COMMENTS),
ADJUST_STATUS = NVL(DECODE(p_comm_lines_api_rec.ADJUST_STATUS,
FND_API.G_MISS_CHAR,
oldrec.ADJUST_STATUS,
p_comm_lines_api_rec.ADJUST_STATUS),'NEW'),
LINE_NUMBER = DECODE(p_comm_lines_api_rec.LINE_NUMBER,
FND_API.G_MISS_NUM,
oldrec.LINE_NUMBER,
p_comm_lines_api_rec.LINE_NUMBER),
BILL_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.BILL_TO_ADDRESS_ID,
FND_API.G_MISS_NUM,
oldrec.BILL_TO_ADDRESS_ID,
p_comm_lines_api_rec.BILL_TO_ADDRESS_ID),
SHIP_TO_ADDRESS_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID,
FND_API.G_MISS_NUM,
oldrec.SHIP_TO_ADDRESS_ID,
p_comm_lines_api_rec.SHIP_TO_ADDRESS_ID),
BILL_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.BILL_TO_CONTACT_ID,
FND_API.G_MISS_NUM,
oldrec.BILL_TO_CONTACT_ID,
p_comm_lines_api_rec.BILL_TO_CONTACT_ID),
SHIP_TO_CONTACT_ID = DECODE(p_comm_lines_api_rec.SHIP_TO_CONTACT_ID,
FND_API.G_MISS_NUM,
oldrec.SHIP_TO_CONTACT_ID,
p_comm_lines_api_rec.SHIP_TO_CONTACT_ID),
ADJ_COMM_LINES_API_ID = DECODE(p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID,
FND_API.G_MISS_NUM,
oldrec.ADJ_COMM_LINES_API_ID,
p_comm_lines_api_rec.ADJ_COMM_LINES_API_ID),
PRE_DEFINED_RC_FLAG = DECODE(p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG,
FND_API.G_MISS_CHAR,
oldrec.PRE_DEFINED_RC_FLAG,
p_comm_lines_api_rec.PRE_DEFINED_RC_FLAG),
ROLLUP_FLAG = DECODE(p_comm_lines_api_rec.ROLLUP_FLAG,
FND_API.G_MISS_CHAR,
oldrec.ROLLUP_FLAG,
p_comm_lines_api_rec.ROLLUP_FLAG),
FORECAST_ID = DECODE(p_comm_lines_api_rec.FORECAST_ID,
FND_API.G_MISS_NUM,
oldrec.FORECAST_ID,
p_comm_lines_api_rec.FORECAST_ID),
UPSIDE_QUANTITY = DECODE(p_comm_lines_api_rec.UPSIDE_QUANTITY,
FND_API.G_MISS_NUM,
oldrec.UPSIDE_QUANTITY,
p_comm_lines_api_rec.UPSIDE_QUANTITY),
UPSIDE_AMOUNT = DECODE(p_comm_lines_api_rec.UPSIDE_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.UPSIDE_AMOUNT,
p_comm_lines_api_rec.UPSIDE_AMOUNT),
UOM_CODE = DECODE(p_comm_lines_api_rec.UOM_CODE,
FND_API.G_MISS_CHAR,
oldrec.UOM_CODE,
p_comm_lines_api_rec.UOM_CODE),
REASON_CODE = DECODE(p_comm_lines_api_rec.REASON_CODE,
FND_API.G_MISS_CHAR,
oldrec.REASON_CODE,
p_comm_lines_api_rec.REASON_CODE),
TYPE = DECODE(p_comm_lines_api_rec.TYPE,
FND_API.G_MISS_CHAR,
oldrec.TYPE,
p_comm_lines_api_rec.TYPE),
PRE_PROCESSED_CODE = DECODE(p_comm_lines_api_rec.PRE_PROCESSED_CODE,
FND_API.G_MISS_CHAR,
oldrec.PRE_PROCESSED_CODE,
p_comm_lines_api_rec.PRE_PROCESSED_CODE),
QUOTA_ID = DECODE(p_comm_lines_api_rec.QUOTA_ID,
FND_API.G_MISS_NUM,
oldrec.QUOTA_ID,
p_comm_lines_api_rec.QUOTA_ID),
SRP_PLAN_ASSIGN_ID = DECODE(p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID,
FND_API.G_MISS_NUM,
oldrec.SRP_PLAN_ASSIGN_ID,
p_comm_lines_api_rec.SRP_PLAN_ASSIGN_ID),
ROLE_ID = DECODE(p_comm_lines_api_rec.ROLE_ID,
FND_API.G_MISS_NUM,
oldrec.ROLE_ID,
p_comm_lines_api_rec.ROLE_ID),
COMP_GROUP_ID = DECODE(p_comm_lines_api_rec.COMP_GROUP_ID,
FND_API.G_MISS_NUM,
oldrec.COMP_GROUP_ID,
p_comm_lines_api_rec.COMP_GROUP_ID),
COMMISSION_AMOUNT = DECODE(p_comm_lines_api_rec.COMMISSION_AMOUNT,
FND_API.G_MISS_NUM,
oldrec.COMMISSION_AMOUNT,
p_comm_lines_api_rec.COMMISSION_AMOUNT),
EMPLOYEE_NUMBER = DECODE(p_comm_lines_api_rec.EMPLOYEE_NUMBER,
FND_API.G_MISS_CHAR,
oldrec.EMPLOYEE_NUMBER,
p_comm_lines_api_rec.EMPLOYEE_NUMBER),
REVERSAL_FLAG = DECODE(p_comm_lines_api_rec.REVERSAL_FLAG,
FND_API.G_MISS_CHAR,
oldrec.REVERSAL_FLAG,
p_comm_lines_api_rec.REVERSAL_FLAG),
REVERSAL_HEADER_ID = DECODE(p_comm_lines_api_rec.REVERSAL_HEADER_ID,
FND_API.G_MISS_NUM,
oldrec.REVERSAL_HEADER_ID,
p_comm_lines_api_rec.REVERSAL_HEADER_ID),
SALES_CHANNEL = DECODE(p_comm_lines_api_rec.SALES_CHANNEL,
FND_API.G_MISS_CHAR,
oldrec.SALES_CHANNEL,
p_comm_lines_api_rec.SALES_CHANNEL),
OBJECT_VERSION_NUMBER = oldrec.OBJECT_VERSION_NUMBER + 1,
SPLIT_PCT = DECODE(p_comm_lines_api_rec.SPLIT_PCT,
FND_API.G_MISS_NUM,
oldrec.SPLIT_PCT,
p_comm_lines_api_rec.SPLIT_PCT),
SPLIT_STATUS = DECODE(p_comm_lines_api_rec.SPLIT_STATUS,
FND_API.G_MISS_CHAR,
oldrec.SPLIT_STATUS,
p_comm_lines_api_rec.SPLIT_STATUS)
WHERE comm_lines_api_id = p_comm_lines_api_rec.comm_lines_api_id;
END lock_update_row;
PROCEDURE delete_row
(
p_comm_lines_api_id NUMBER
) IS
BEGIN
DELETE FROM CN_COMM_LINES_API
WHERE comm_lines_api_id = p_comm_lines_api_id;
END Delete_row;
SELECT a.*,
b.salesrep_number employee_number
FROM cn_commission_headers a,
cn_rs_salesreps b
WHERE a.direct_salesrep_id = b.salesrep_id AND
a.commission_header_id = l_commission_header_id
AND a.org_id = x_org_id
AND a.org_id = b.org_id;
SELECT *
FROM cn_comm_lines_api
WHERE source_trx_line_id = lid
AND NVL(source_trx_id,-99) = NVL(hid,-99)
AND NVL(source_doc_type,'DUMMY') = NVL(sd_type,'DUMMY')
AND negated_flag IS NULL
AND org_id = x_org_id;
SELECT commission_header_id,adjust_status,quantity,trx_type,
transaction_amount,transaction_amount_orig
INTO l_reversal_header_id,l_adjust_status,l_quantity,l_trx_type,
l_transaction_amount,l_transaction_amount_orig
FROM cn_commission_headers
WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
AND org_id = x_org_id
AND (adjust_status NOT IN ('FROZEN','REVERSAL'))-- OR
-- adjust_status IS NULL)
AND trx_type NOT IN ('ITD','GRP','THR');
UPDATE cn_commission_headers
SET adjust_status = 'FROZEN',
reversal_header_id = l_reversal_header_id,
reversal_flag = l_reversal_flag,
adjust_date = l_adjust_date,
-- clku, update the last updated info
last_update_date = sysdate,
last_updated_by = fnd_global.user_id,
last_update_login = fnd_global.login_id
WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
AND org_id = x_org_id;
SELECT cn_comm_lines_api_s.NEXTVAL
INTO l_comm_lines_api_id
FROM dual;
cn_comm_lines_api_pkg.insert_row(l_api_rec);
UPDATE cn_comm_lines_api
SET load_status = 'OBSOLETE',
adjust_status = 'FROZEN'
WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
AND org_id = x_org_id;