[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row (
X_PROFILE_CLASS_AMOUNT_ID IN OUT NOCOPY NUMBER,
X_PROFILE_CLASS_ID IN NUMBER,
X_CURRENCY_CODE IN VARCHAR2,
X_TRX_CREDIT_LIMIT IN NUMBER,
X_OVERALL_CREDIT_LIMIT IN NUMBER,
X_MIN_DUNNING_AMOUNT IN NUMBER,
X_MAX_INTEREST_CHARGE IN NUMBER,
X_MIN_STATEMENT_AMOUNT IN NUMBER,
X_AUTO_REC_MIN_RECEIPT_AMOUNT IN NUMBER,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_INTEREST_RATE IN NUMBER,
X_MIN_FC_BALANCE_AMOUNT IN NUMBER,
X_MIN_FC_INVOICE_AMOUNT IN NUMBER,
X_MIN_DUNNING_INVOICE_AMOUNT IN NUMBER,
X_EXPIRATION_DATE IN DATE,
X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_EXCHANGE_RATE_TYPE IN VARCHAR2,
X_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
X_MIN_FC_INVOICE_PERCENT IN NUMBER,
X_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
X_MIN_FC_BALANCE_PERCENT IN NUMBER,
X_INTEREST_TYPE IN VARCHAR2,
X_INTEREST_FIXED_AMOUNT IN NUMBER,
X_INTEREST_SCHEDULE_ID IN NUMBER,
X_PENALTY_TYPE IN VARCHAR2,
X_PENALTY_RATE IN NUMBER,
X_MIN_INTEREST_CHARGE IN NUMBER,
X_PENALTY_FIXED_AMOUNT IN NUMBER,
X_PENALTY_SCHEDULE_ID IN NUMBER
) IS
l_success VARCHAR2(1) := 'N';
INSERT INTO HZ_CUST_PROF_CLASS_AMTS (
PROFILE_CLASS_AMOUNT_ID,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
CREATED_BY,
CREATION_DATE,
REQUEST_ID,
PROFILE_CLASS_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
CURRENCY_CODE,
PROGRAM_UPDATE_DATE,
LAST_UPDATE_LOGIN,
TRX_CREDIT_LIMIT,
OVERALL_CREDIT_LIMIT,
MIN_DUNNING_AMOUNT,
MAX_INTEREST_CHARGE,
MIN_STATEMENT_AMOUNT,
AUTO_REC_MIN_RECEIPT_AMOUNT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
INTEREST_RATE,
MIN_FC_BALANCE_AMOUNT,
MIN_FC_INVOICE_AMOUNT,
MIN_DUNNING_INVOICE_AMOUNT,
EXPIRATION_DATE,
JGZZ_ATTRIBUTE_CATEGORY,
JGZZ_ATTRIBUTE1,
JGZZ_ATTRIBUTE2,
JGZZ_ATTRIBUTE3,
JGZZ_ATTRIBUTE4,
JGZZ_ATTRIBUTE5,
JGZZ_ATTRIBUTE6,
JGZZ_ATTRIBUTE7,
JGZZ_ATTRIBUTE8,
JGZZ_ATTRIBUTE9,
JGZZ_ATTRIBUTE10,
JGZZ_ATTRIBUTE11,
JGZZ_ATTRIBUTE12,
JGZZ_ATTRIBUTE13,
JGZZ_ATTRIBUTE14,
JGZZ_ATTRIBUTE15,
GLOBAL_ATTRIBUTE1,
GLOBAL_ATTRIBUTE2,
GLOBAL_ATTRIBUTE3,
GLOBAL_ATTRIBUTE4,
GLOBAL_ATTRIBUTE5,
GLOBAL_ATTRIBUTE6,
GLOBAL_ATTRIBUTE7,
GLOBAL_ATTRIBUTE8,
GLOBAL_ATTRIBUTE9,
GLOBAL_ATTRIBUTE10,
GLOBAL_ATTRIBUTE11,
GLOBAL_ATTRIBUTE12,
GLOBAL_ATTRIBUTE13,
GLOBAL_ATTRIBUTE14,
GLOBAL_ATTRIBUTE15,
GLOBAL_ATTRIBUTE16,
GLOBAL_ATTRIBUTE17,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
GLOBAL_ATTRIBUTE_CATEGORY,
EXCHANGE_RATE_TYPE,
MIN_FC_INVOICE_OVERDUE_TYPE,
MIN_FC_INVOICE_PERCENT,
MIN_FC_BALANCE_OVERDUE_TYPE,
MIN_FC_BALANCE_PERCENT,
INTEREST_TYPE,
INTEREST_FIXED_AMOUNT,
INTEREST_SCHEDULE_ID,
PENALTY_TYPE,
PENALTY_RATE,
MIN_INTEREST_CHARGE,
PENALTY_FIXED_AMOUNT,
PENALTY_SCHEDULE_ID
)
VALUES (
DECODE( X_PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, NULL, HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL, X_PROFILE_CLASS_AMOUNT_ID ),
HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
HZ_UTILITY_V2PUB.CREATED_BY,
HZ_UTILITY_V2PUB.CREATION_DATE,
HZ_UTILITY_V2PUB.REQUEST_ID,
DECODE( X_PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
HZ_UTILITY_V2PUB.PROGRAM_ID,
DECODE( X_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, X_CURRENCY_CODE ),
HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
DECODE( X_TRX_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_TRX_CREDIT_LIMIT ),
DECODE( X_OVERALL_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_OVERALL_CREDIT_LIMIT ),
DECODE( X_MIN_DUNNING_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_AMOUNT ),
DECODE( X_MAX_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MAX_INTEREST_CHARGE ),
DECODE( X_MIN_STATEMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_STATEMENT_AMOUNT ),
DECODE( X_AUTO_REC_MIN_RECEIPT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_AUTO_REC_MIN_RECEIPT_AMOUNT ),
DECODE( X_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
DECODE( X_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
DECODE( X_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
DECODE( X_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
DECODE( X_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
DECODE( X_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
DECODE( X_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
DECODE( X_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
DECODE( X_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
DECODE( X_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
DECODE( X_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
DECODE( X_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
DECODE( X_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
DECODE( X_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
DECODE( X_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
DECODE( X_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
DECODE( X_INTEREST_RATE, FND_API.G_MISS_NUM, NULL, X_INTEREST_RATE ),
DECODE( X_MIN_FC_BALANCE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_AMOUNT ),
DECODE( X_MIN_FC_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_AMOUNT ),
DECODE( X_MIN_DUNNING_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_INVOICE_AMOUNT ),
DECODE( X_EXPIRATION_DATE, FND_API.G_MISS_DATE, TO_DATE( NULL ), X_EXPIRATION_DATE ),
DECODE( X_JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE_CATEGORY ),
DECODE( X_JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE1 ),
DECODE( X_JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE2 ),
DECODE( X_JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE3 ),
DECODE( X_JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE4 ),
DECODE( X_JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE5 ),
DECODE( X_JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE6 ),
DECODE( X_JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE7 ),
DECODE( X_JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE8 ),
DECODE( X_JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE9 ),
DECODE( X_JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE10 ),
DECODE( X_JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE11 ),
DECODE( X_JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE12 ),
DECODE( X_JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE13 ),
DECODE( X_JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE14 ),
DECODE( X_JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE15 ),
DECODE( X_GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
DECODE( X_GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
DECODE( X_GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
DECODE( X_GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
DECODE( X_GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
DECODE( X_GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
DECODE( X_GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
DECODE( X_GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
DECODE( X_GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
DECODE( X_GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
DECODE( X_GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
DECODE( X_GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
DECODE( X_GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
DECODE( X_GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
DECODE( X_GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
DECODE( X_GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
DECODE( X_GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
DECODE( X_GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
DECODE( X_GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
DECODE( X_GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
DECODE( X_EXCHANGE_RATE_TYPE, FND_API.G_MISS_CHAR, NULL, X_EXCHANGE_RATE_TYPE ),
DECODE( X_MIN_FC_INVOICE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_INVOICE_OVERDUE_TYPE ),
DECODE( X_MIN_FC_INVOICE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_PERCENT ),
DECODE( X_MIN_FC_BALANCE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_BALANCE_OVERDUE_TYPE ),
DECODE( X_MIN_FC_BALANCE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_PERCENT ),
DECODE( X_INTEREST_TYPE, FND_API.G_MISS_CHAR, NULL, X_INTEREST_TYPE ),
DECODE( X_INTEREST_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_INTEREST_FIXED_AMOUNT ),
DECODE( X_INTEREST_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_INTEREST_SCHEDULE_ID ),
DECODE( X_PENALTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PENALTY_TYPE ),
DECODE( X_PENALTY_RATE, FND_API.G_MISS_NUM, NULL, X_PENALTY_RATE ),
DECODE( X_MIN_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MIN_INTEREST_CHARGE ),
DECODE( X_PENALTY_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_PENALTY_FIXED_AMOUNT ),
DECODE( X_PENALTY_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_PENALTY_SCHEDULE_ID )
) RETURNING
PROFILE_CLASS_AMOUNT_ID
INTO
X_PROFILE_CLASS_AMOUNT_ID;
SELECT HZ_CUST_PROF_CLASS_AMTS_S.NEXTVAL
INTO X_PROFILE_CLASS_AMOUNT_ID FROM dual;
SELECT 'Y' INTO l_dummy
FROM HZ_CUST_PROF_CLASS_AMTS
WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;
END Insert_Row;
PROCEDURE Update_Row (
X_Rowid IN OUT NOCOPY VARCHAR2,
X_PROFILE_CLASS_AMOUNT_ID IN NUMBER,
X_PROFILE_CLASS_ID IN NUMBER,
X_CURRENCY_CODE IN VARCHAR2,
X_TRX_CREDIT_LIMIT IN NUMBER,
X_OVERALL_CREDIT_LIMIT IN NUMBER,
X_MIN_DUNNING_AMOUNT IN NUMBER,
X_MAX_INTEREST_CHARGE IN NUMBER,
X_MIN_STATEMENT_AMOUNT IN NUMBER,
X_AUTO_REC_MIN_RECEIPT_AMOUNT IN NUMBER,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_INTEREST_RATE IN NUMBER,
X_MIN_FC_BALANCE_AMOUNT IN NUMBER,
X_MIN_FC_INVOICE_AMOUNT IN NUMBER,
X_MIN_DUNNING_INVOICE_AMOUNT IN NUMBER,
X_EXPIRATION_DATE IN DATE,
X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_EXCHANGE_RATE_TYPE IN VARCHAR2,
X_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
X_MIN_FC_INVOICE_PERCENT IN NUMBER,
X_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
X_MIN_FC_BALANCE_PERCENT IN NUMBER,
X_INTEREST_TYPE IN VARCHAR2,
X_INTEREST_FIXED_AMOUNT IN NUMBER,
X_INTEREST_SCHEDULE_ID IN NUMBER,
X_PENALTY_TYPE IN VARCHAR2,
X_PENALTY_RATE IN NUMBER,
X_MIN_INTEREST_CHARGE IN NUMBER,
X_PENALTY_FIXED_AMOUNT IN NUMBER,
X_PENALTY_SCHEDULE_ID IN NUMBER
) IS
BEGIN
UPDATE HZ_CUST_PROF_CLASS_AMTS SET
PROFILE_CLASS_AMOUNT_ID = DECODE( X_PROFILE_CLASS_AMOUNT_ID, NULL, PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_AMOUNT_ID ),
LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
CREATED_BY = CREATED_BY,
CREATION_DATE = CREATION_DATE,
REQUEST_ID = HZ_UTILITY_V2PUB.REQUEST_ID,
PROFILE_CLASS_ID = DECODE( X_PROFILE_CLASS_ID, NULL, PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
PROGRAM_APPLICATION_ID = HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
PROGRAM_ID = HZ_UTILITY_V2PUB.PROGRAM_ID,
CURRENCY_CODE = DECODE( X_CURRENCY_CODE, NULL, CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, X_CURRENCY_CODE ),
PROGRAM_UPDATE_DATE = HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
TRX_CREDIT_LIMIT = DECODE( X_TRX_CREDIT_LIMIT, NULL, TRX_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_TRX_CREDIT_LIMIT ),
OVERALL_CREDIT_LIMIT = DECODE( X_OVERALL_CREDIT_LIMIT, NULL, OVERALL_CREDIT_LIMIT, FND_API.G_MISS_NUM, NULL, X_OVERALL_CREDIT_LIMIT ),
MIN_DUNNING_AMOUNT = DECODE( X_MIN_DUNNING_AMOUNT, NULL, MIN_DUNNING_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_AMOUNT ),
MAX_INTEREST_CHARGE = DECODE( X_MAX_INTEREST_CHARGE, NULL, MAX_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MAX_INTEREST_CHARGE ),
MIN_STATEMENT_AMOUNT = DECODE( X_MIN_STATEMENT_AMOUNT, NULL, MIN_STATEMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_STATEMENT_AMOUNT ),
AUTO_REC_MIN_RECEIPT_AMOUNT = DECODE( X_AUTO_REC_MIN_RECEIPT_AMOUNT, NULL, AUTO_REC_MIN_RECEIPT_AMOUNT, FND_API.G_MISS_NUM, NULL, X_AUTO_REC_MIN_RECEIPT_AMOUNT ),
ATTRIBUTE_CATEGORY = DECODE( X_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE_CATEGORY ),
ATTRIBUTE1 = DECODE( X_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE1 ),
ATTRIBUTE2 = DECODE( X_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE2 ),
ATTRIBUTE3 = DECODE( X_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE3 ),
ATTRIBUTE4 = DECODE( X_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE4 ),
ATTRIBUTE5 = DECODE( X_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE5 ),
ATTRIBUTE6 = DECODE( X_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE6 ),
ATTRIBUTE7 = DECODE( X_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE7 ),
ATTRIBUTE8 = DECODE( X_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE8 ),
ATTRIBUTE9 = DECODE( X_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE9 ),
ATTRIBUTE10 = DECODE( X_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE10 ),
ATTRIBUTE11 = DECODE( X_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE11 ),
ATTRIBUTE12 = DECODE( X_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE12 ),
ATTRIBUTE13 = DECODE( X_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE13 ),
ATTRIBUTE14 = DECODE( X_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE14 ),
ATTRIBUTE15 = DECODE( X_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_ATTRIBUTE15 ),
INTEREST_RATE = DECODE( X_INTEREST_RATE, NULL, INTEREST_RATE, FND_API.G_MISS_NUM, NULL, X_INTEREST_RATE ),
MIN_FC_BALANCE_AMOUNT = DECODE( X_MIN_FC_BALANCE_AMOUNT, NULL, MIN_FC_BALANCE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_AMOUNT ),
MIN_FC_INVOICE_AMOUNT = DECODE( X_MIN_FC_INVOICE_AMOUNT, NULL, MIN_FC_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_AMOUNT ),
MIN_DUNNING_INVOICE_AMOUNT = DECODE( X_MIN_DUNNING_INVOICE_AMOUNT, NULL, MIN_DUNNING_INVOICE_AMOUNT, FND_API.G_MISS_NUM, NULL, X_MIN_DUNNING_INVOICE_AMOUNT ),
EXPIRATION_DATE = DECODE( X_EXPIRATION_DATE, NULL, EXPIRATION_DATE, FND_API.G_MISS_DATE,
NULL, X_EXPIRATION_DATE ),
JGZZ_ATTRIBUTE_CATEGORY = DECODE( X_JGZZ_ATTRIBUTE_CATEGORY, NULL, JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE_CATEGORY ),
JGZZ_ATTRIBUTE1 = DECODE( X_JGZZ_ATTRIBUTE1, NULL, JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE1 ),
JGZZ_ATTRIBUTE2 = DECODE( X_JGZZ_ATTRIBUTE2, NULL, JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE2 ),
JGZZ_ATTRIBUTE3 = DECODE( X_JGZZ_ATTRIBUTE3, NULL, JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE3 ),
JGZZ_ATTRIBUTE4 = DECODE( X_JGZZ_ATTRIBUTE4, NULL, JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE4 ),
JGZZ_ATTRIBUTE5 = DECODE( X_JGZZ_ATTRIBUTE5, NULL, JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE5 ),
JGZZ_ATTRIBUTE6 = DECODE( X_JGZZ_ATTRIBUTE6, NULL, JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE6 ),
JGZZ_ATTRIBUTE7 = DECODE( X_JGZZ_ATTRIBUTE7, NULL, JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE7 ),
JGZZ_ATTRIBUTE8 = DECODE( X_JGZZ_ATTRIBUTE8, NULL, JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE8 ),
JGZZ_ATTRIBUTE9 = DECODE( X_JGZZ_ATTRIBUTE9, NULL, JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE9 ),
JGZZ_ATTRIBUTE10 = DECODE( X_JGZZ_ATTRIBUTE10, NULL, JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE10 ),
JGZZ_ATTRIBUTE11 = DECODE( X_JGZZ_ATTRIBUTE11, NULL, JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE11 ),
JGZZ_ATTRIBUTE12 = DECODE( X_JGZZ_ATTRIBUTE12, NULL, JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE12 ),
JGZZ_ATTRIBUTE13 = DECODE( X_JGZZ_ATTRIBUTE13, NULL, JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE13 ),
JGZZ_ATTRIBUTE14 = DECODE( X_JGZZ_ATTRIBUTE14, NULL, JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE14 ),
JGZZ_ATTRIBUTE15 = DECODE( X_JGZZ_ATTRIBUTE15, NULL, JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_JGZZ_ATTRIBUTE15 ),
GLOBAL_ATTRIBUTE1 = DECODE( X_GLOBAL_ATTRIBUTE1, NULL, GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE1 ),
GLOBAL_ATTRIBUTE2 = DECODE( X_GLOBAL_ATTRIBUTE2, NULL, GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE2 ),
GLOBAL_ATTRIBUTE3 = DECODE( X_GLOBAL_ATTRIBUTE3, NULL, GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE3 ),
GLOBAL_ATTRIBUTE4 = DECODE( X_GLOBAL_ATTRIBUTE4, NULL, GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE4 ),
GLOBAL_ATTRIBUTE5 = DECODE( X_GLOBAL_ATTRIBUTE5, NULL, GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE5 ),
GLOBAL_ATTRIBUTE6 = DECODE( X_GLOBAL_ATTRIBUTE6, NULL, GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE6 ),
GLOBAL_ATTRIBUTE7 = DECODE( X_GLOBAL_ATTRIBUTE7, NULL, GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE7 ),
GLOBAL_ATTRIBUTE8 = DECODE( X_GLOBAL_ATTRIBUTE8, NULL, GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE8 ),
GLOBAL_ATTRIBUTE9 = DECODE( X_GLOBAL_ATTRIBUTE9, NULL, GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE9 ),
GLOBAL_ATTRIBUTE10 = DECODE( X_GLOBAL_ATTRIBUTE10, NULL, GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE10 ),
GLOBAL_ATTRIBUTE11 = DECODE( X_GLOBAL_ATTRIBUTE11, NULL, GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE11 ),
GLOBAL_ATTRIBUTE12 = DECODE( X_GLOBAL_ATTRIBUTE12, NULL, GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE12 ),
GLOBAL_ATTRIBUTE13 = DECODE( X_GLOBAL_ATTRIBUTE13, NULL, GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE13 ),
GLOBAL_ATTRIBUTE14 = DECODE( X_GLOBAL_ATTRIBUTE14, NULL, GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE14 ),
GLOBAL_ATTRIBUTE15 = DECODE( X_GLOBAL_ATTRIBUTE15, NULL, GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE15 ),
GLOBAL_ATTRIBUTE16 = DECODE( X_GLOBAL_ATTRIBUTE16, NULL, GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE16 ),
GLOBAL_ATTRIBUTE17 = DECODE( X_GLOBAL_ATTRIBUTE17, NULL, GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE17 ),
GLOBAL_ATTRIBUTE18 = DECODE( X_GLOBAL_ATTRIBUTE18, NULL, GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE18 ),
GLOBAL_ATTRIBUTE19 = DECODE( X_GLOBAL_ATTRIBUTE19, NULL, GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE19 ),
GLOBAL_ATTRIBUTE20 = DECODE( X_GLOBAL_ATTRIBUTE20, NULL, GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE20 ),
GLOBAL_ATTRIBUTE_CATEGORY = DECODE( X_GLOBAL_ATTRIBUTE_CATEGORY, NULL, GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_GLOBAL_ATTRIBUTE_CATEGORY ),
EXCHANGE_RATE_TYPE = DECODE( X_EXCHANGE_RATE_TYPE, NULL, EXCHANGE_RATE_TYPE, FND_API.G_MISS_CHAR, NULL, X_EXCHANGE_RATE_TYPE ),
MIN_FC_INVOICE_OVERDUE_TYPE = DECODE( MIN_FC_INVOICE_OVERDUE_TYPE, NULL, MIN_FC_INVOICE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_INVOICE_OVERDUE_TYPE ),
MIN_FC_INVOICE_PERCENT = DECODE( X_MIN_FC_INVOICE_PERCENT, NULL, MIN_FC_INVOICE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_INVOICE_PERCENT ),
MIN_FC_BALANCE_OVERDUE_TYPE = DECODE( X_MIN_FC_BALANCE_OVERDUE_TYPE, NULL, MIN_FC_BALANCE_OVERDUE_TYPE, FND_API.G_MISS_CHAR, NULL, X_MIN_FC_BALANCE_OVERDUE_TYPE ),
MIN_FC_BALANCE_PERCENT = DECODE( X_MIN_FC_BALANCE_PERCENT, NULL, MIN_FC_BALANCE_PERCENT, FND_API.G_MISS_NUM, NULL, X_MIN_FC_BALANCE_PERCENT ),
INTEREST_TYPE = DECODE( X_INTEREST_TYPE, NULL, INTEREST_TYPE, FND_API.G_MISS_CHAR, NULL, X_INTEREST_TYPE ),
INTEREST_FIXED_AMOUNT = DECODE( X_INTEREST_FIXED_AMOUNT, NULL, INTEREST_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_INTEREST_FIXED_AMOUNT ),
INTEREST_SCHEDULE_ID = DECODE( X_INTEREST_SCHEDULE_ID, NULL, INTEREST_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_INTEREST_SCHEDULE_ID ),
PENALTY_TYPE = DECODE( X_PENALTY_TYPE, NULL, PENALTY_TYPE, FND_API.G_MISS_CHAR, NULL, X_PENALTY_TYPE ),
PENALTY_RATE = DECODE( X_PENALTY_RATE, NULL, PENALTY_RATE, FND_API.G_MISS_NUM, NULL, X_PENALTY_RATE ),
MIN_INTEREST_CHARGE = DECODE( X_MIN_INTEREST_CHARGE, NULL, MIN_INTEREST_CHARGE, FND_API.G_MISS_NUM, NULL, X_MIN_INTEREST_CHARGE ),
PENALTY_FIXED_AMOUNT = DECODE( X_PENALTY_FIXED_AMOUNT, NULL, PENALTY_FIXED_AMOUNT, FND_API.G_MISS_NUM, NULL, X_PENALTY_FIXED_AMOUNT ),
PENALTY_SCHEDULE_ID = DECODE( X_PENALTY_SCHEDULE_ID, NULL, PENALTY_SCHEDULE_ID, FND_API.G_MISS_NUM, NULL, X_PENALTY_SCHEDULE_ID )
WHERE ROWID = X_RowId;
END Update_Row;
X_LAST_UPDATED_BY IN NUMBER,
X_LAST_UPDATE_DATE IN DATE,
X_CREATED_BY IN NUMBER,
X_CREATION_DATE IN DATE,
X_REQUEST_ID IN NUMBER,
X_PROFILE_CLASS_ID IN NUMBER,
X_PROGRAM_APPLICATION_ID IN NUMBER,
X_PROGRAM_ID IN NUMBER,
X_CURRENCY_CODE IN VARCHAR2,
X_PROGRAM_UPDATE_DATE IN DATE,
X_LAST_UPDATE_LOGIN IN NUMBER,
X_TRX_CREDIT_LIMIT IN NUMBER,
X_OVERALL_CREDIT_LIMIT IN NUMBER,
X_MIN_DUNNING_AMOUNT IN NUMBER,
X_MAX_INTEREST_CHARGE IN NUMBER,
X_MIN_STATEMENT_AMOUNT IN NUMBER,
X_AUTO_REC_MIN_RECEIPT_AMOUNT IN NUMBER,
X_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_ATTRIBUTE1 IN VARCHAR2,
X_ATTRIBUTE2 IN VARCHAR2,
X_ATTRIBUTE3 IN VARCHAR2,
X_ATTRIBUTE4 IN VARCHAR2,
X_ATTRIBUTE5 IN VARCHAR2,
X_ATTRIBUTE6 IN VARCHAR2,
X_ATTRIBUTE7 IN VARCHAR2,
X_ATTRIBUTE8 IN VARCHAR2,
X_ATTRIBUTE9 IN VARCHAR2,
X_ATTRIBUTE10 IN VARCHAR2,
X_ATTRIBUTE11 IN VARCHAR2,
X_ATTRIBUTE12 IN VARCHAR2,
X_ATTRIBUTE13 IN VARCHAR2,
X_ATTRIBUTE14 IN VARCHAR2,
X_ATTRIBUTE15 IN VARCHAR2,
X_INTEREST_RATE IN NUMBER,
X_MIN_FC_BALANCE_AMOUNT IN NUMBER,
X_MIN_FC_INVOICE_AMOUNT IN NUMBER,
X_MIN_DUNNING_INVOICE_AMOUNT IN NUMBER,
X_EXPIRATION_DATE IN DATE,
X_JGZZ_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_JGZZ_ATTRIBUTE1 IN VARCHAR2,
X_JGZZ_ATTRIBUTE2 IN VARCHAR2,
X_JGZZ_ATTRIBUTE3 IN VARCHAR2,
X_JGZZ_ATTRIBUTE4 IN VARCHAR2,
X_JGZZ_ATTRIBUTE5 IN VARCHAR2,
X_JGZZ_ATTRIBUTE6 IN VARCHAR2,
X_JGZZ_ATTRIBUTE7 IN VARCHAR2,
X_JGZZ_ATTRIBUTE8 IN VARCHAR2,
X_JGZZ_ATTRIBUTE9 IN VARCHAR2,
X_JGZZ_ATTRIBUTE10 IN VARCHAR2,
X_JGZZ_ATTRIBUTE11 IN VARCHAR2,
X_JGZZ_ATTRIBUTE12 IN VARCHAR2,
X_JGZZ_ATTRIBUTE13 IN VARCHAR2,
X_JGZZ_ATTRIBUTE14 IN VARCHAR2,
X_JGZZ_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
X_EXCHANGE_RATE_TYPE IN VARCHAR2,
X_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
X_MIN_FC_INVOICE_PERCENT IN NUMBER,
X_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
X_MIN_FC_BALANCE_PERCENT IN NUMBER,
X_INTEREST_TYPE IN VARCHAR2,
X_INTEREST_FIXED_AMOUNT IN NUMBER,
X_INTEREST_SCHEDULE_ID IN NUMBER,
X_PENALTY_TYPE IN VARCHAR2,
X_PENALTY_RATE IN NUMBER,
X_MIN_INTEREST_CHARGE IN NUMBER,
X_PENALTY_FIXED_AMOUNT IN NUMBER,
X_PENALTY_SCHEDULE_ID IN NUMBER
) IS
CURSOR C IS
SELECT * FROM HZ_CUST_PROF_CLASS_AMTS
WHERE ROWID = x_Rowid
FOR UPDATE NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY )
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( X_LAST_UPDATED_BY IS NULL ) ) )
AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( X_LAST_UPDATE_DATE IS NULL ) ) )
AND ( ( Recinfo.CREATED_BY = X_CREATED_BY )
OR ( ( Recinfo.CREATED_BY IS NULL )
AND ( X_CREATED_BY IS NULL ) ) )
AND ( ( Recinfo.CREATION_DATE = X_CREATION_DATE )
OR ( ( Recinfo.CREATION_DATE IS NULL )
AND ( X_CREATION_DATE IS NULL ) ) )
AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( X_REQUEST_ID IS NULL ) ) )
AND ( ( Recinfo.PROFILE_CLASS_ID = X_PROFILE_CLASS_ID )
OR ( ( Recinfo.PROFILE_CLASS_ID IS NULL )
AND ( X_PROFILE_CLASS_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID )
OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
AND ( X_PROGRAM_APPLICATION_ID IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID )
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( X_PROGRAM_ID IS NULL ) ) )
AND ( ( Recinfo.CURRENCY_CODE = X_CURRENCY_CODE )
OR ( ( Recinfo.CURRENCY_CODE IS NULL )
AND ( X_CURRENCY_CODE IS NULL ) ) )
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE )
OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
AND ( X_PROGRAM_UPDATE_DATE IS NULL ) ) )
AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( X_LAST_UPDATE_LOGIN IS NULL ) ) )
AND ( ( Recinfo.TRX_CREDIT_LIMIT = X_TRX_CREDIT_LIMIT )
OR ( ( Recinfo.TRX_CREDIT_LIMIT IS NULL )
AND ( X_TRX_CREDIT_LIMIT IS NULL ) ) )
AND ( ( Recinfo.OVERALL_CREDIT_LIMIT = X_OVERALL_CREDIT_LIMIT )
OR ( ( Recinfo.OVERALL_CREDIT_LIMIT IS NULL )
AND ( X_OVERALL_CREDIT_LIMIT IS NULL ) ) )
AND ( ( Recinfo.MIN_DUNNING_AMOUNT = X_MIN_DUNNING_AMOUNT )
OR ( ( Recinfo.MIN_DUNNING_AMOUNT IS NULL )
AND ( X_MIN_DUNNING_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.MAX_INTEREST_CHARGE = X_MAX_INTEREST_CHARGE )
OR ( ( Recinfo.MAX_INTEREST_CHARGE IS NULL )
AND ( X_MAX_INTEREST_CHARGE IS NULL ) ) )
AND ( ( Recinfo.MIN_STATEMENT_AMOUNT = X_MIN_STATEMENT_AMOUNT )
OR ( ( Recinfo.MIN_STATEMENT_AMOUNT IS NULL )
AND ( X_MIN_STATEMENT_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.AUTO_REC_MIN_RECEIPT_AMOUNT = X_AUTO_REC_MIN_RECEIPT_AMOUNT )
OR ( ( Recinfo.AUTO_REC_MIN_RECEIPT_AMOUNT IS NULL )
AND ( X_AUTO_REC_MIN_RECEIPT_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY )
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( X_ATTRIBUTE_CATEGORY IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( X_ATTRIBUTE1 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( X_ATTRIBUTE2 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( X_ATTRIBUTE3 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( X_ATTRIBUTE4 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( X_ATTRIBUTE5 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( X_ATTRIBUTE6 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( X_ATTRIBUTE7 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( X_ATTRIBUTE8 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( X_ATTRIBUTE9 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( X_ATTRIBUTE10 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( X_ATTRIBUTE11 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( X_ATTRIBUTE12 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( X_ATTRIBUTE13 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( X_ATTRIBUTE14 IS NULL ) ) )
AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( X_ATTRIBUTE15 IS NULL ) ) )
AND ( ( Recinfo.INTEREST_RATE = X_INTEREST_RATE )
OR ( ( Recinfo.INTEREST_RATE IS NULL )
AND ( X_INTEREST_RATE IS NULL ) ) )
AND ( ( Recinfo.MIN_FC_BALANCE_AMOUNT = X_MIN_FC_BALANCE_AMOUNT )
OR ( ( Recinfo.MIN_FC_BALANCE_AMOUNT IS NULL )
AND ( X_MIN_FC_BALANCE_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.MIN_FC_INVOICE_AMOUNT = X_MIN_FC_INVOICE_AMOUNT )
OR ( ( Recinfo.MIN_FC_INVOICE_AMOUNT IS NULL )
AND ( X_MIN_FC_INVOICE_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.MIN_DUNNING_INVOICE_AMOUNT = X_MIN_DUNNING_INVOICE_AMOUNT )
OR ( ( Recinfo.MIN_DUNNING_INVOICE_AMOUNT IS NULL )
AND ( X_MIN_DUNNING_INVOICE_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.EXPIRATION_DATE = X_EXPIRATION_DATE )
OR ( ( Recinfo.EXPIRATION_DATE IS NULL )
AND ( X_EXPIRATION_DATE IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE_CATEGORY = X_JGZZ_ATTRIBUTE_CATEGORY )
OR ( ( Recinfo.JGZZ_ATTRIBUTE_CATEGORY IS NULL )
AND ( X_JGZZ_ATTRIBUTE_CATEGORY IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE1 = X_JGZZ_ATTRIBUTE1 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE1 IS NULL )
AND ( X_JGZZ_ATTRIBUTE1 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE2 = X_JGZZ_ATTRIBUTE2 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE2 IS NULL )
AND ( X_JGZZ_ATTRIBUTE2 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE3 = X_JGZZ_ATTRIBUTE3 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE3 IS NULL )
AND ( X_JGZZ_ATTRIBUTE3 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE4 = X_JGZZ_ATTRIBUTE4 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE4 IS NULL )
AND ( X_JGZZ_ATTRIBUTE4 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE5 = X_JGZZ_ATTRIBUTE5 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE5 IS NULL )
AND ( X_JGZZ_ATTRIBUTE5 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE6 = X_JGZZ_ATTRIBUTE6 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE6 IS NULL )
AND ( X_JGZZ_ATTRIBUTE6 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE7 = X_JGZZ_ATTRIBUTE7 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE7 IS NULL )
AND ( X_JGZZ_ATTRIBUTE7 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE8 = X_JGZZ_ATTRIBUTE8 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE8 IS NULL )
AND ( X_JGZZ_ATTRIBUTE8 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE9 = X_JGZZ_ATTRIBUTE9 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE9 IS NULL )
AND ( X_JGZZ_ATTRIBUTE9 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE10 = X_JGZZ_ATTRIBUTE10 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE10 IS NULL )
AND ( X_JGZZ_ATTRIBUTE10 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE11 = X_JGZZ_ATTRIBUTE11 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE11 IS NULL )
AND ( X_JGZZ_ATTRIBUTE11 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE12 = X_JGZZ_ATTRIBUTE12 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE12 IS NULL )
AND ( X_JGZZ_ATTRIBUTE12 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE13 = X_JGZZ_ATTRIBUTE13 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE13 IS NULL )
AND ( X_JGZZ_ATTRIBUTE13 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE14 = X_JGZZ_ATTRIBUTE14 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE14 IS NULL )
AND ( X_JGZZ_ATTRIBUTE14 IS NULL ) ) )
AND ( ( Recinfo.JGZZ_ATTRIBUTE15 = X_JGZZ_ATTRIBUTE15 )
OR ( ( Recinfo.JGZZ_ATTRIBUTE15 IS NULL )
AND ( X_JGZZ_ATTRIBUTE15 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE1 = X_GLOBAL_ATTRIBUTE1 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE1 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE1 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE2 = X_GLOBAL_ATTRIBUTE2 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE2 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE2 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE3 = X_GLOBAL_ATTRIBUTE3 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE3 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE3 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE4 = X_GLOBAL_ATTRIBUTE4 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE4 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE4 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE5 = X_GLOBAL_ATTRIBUTE5 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE5 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE5 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE6 = X_GLOBAL_ATTRIBUTE6 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE6 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE6 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE7 = X_GLOBAL_ATTRIBUTE7 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE7 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE7 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE8 = X_GLOBAL_ATTRIBUTE8 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE8 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE8 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE9 = X_GLOBAL_ATTRIBUTE9 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE9 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE9 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE10 = X_GLOBAL_ATTRIBUTE10 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE10 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE10 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE11 = X_GLOBAL_ATTRIBUTE11 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE11 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE11 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE12 = X_GLOBAL_ATTRIBUTE12 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE12 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE12 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE13 = X_GLOBAL_ATTRIBUTE13 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE13 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE13 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE14 = X_GLOBAL_ATTRIBUTE14 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE14 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE14 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE15 = X_GLOBAL_ATTRIBUTE15 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE15 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE15 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE16 = X_GLOBAL_ATTRIBUTE16 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE16 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE16 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE17 = X_GLOBAL_ATTRIBUTE17 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE17 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE17 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE18 = X_GLOBAL_ATTRIBUTE18 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE18 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE18 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE19 = X_GLOBAL_ATTRIBUTE19 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE19 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE19 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE20 = X_GLOBAL_ATTRIBUTE20 )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE20 IS NULL )
AND ( X_GLOBAL_ATTRIBUTE20 IS NULL ) ) )
AND ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY = X_GLOBAL_ATTRIBUTE_CATEGORY )
OR ( ( Recinfo.GLOBAL_ATTRIBUTE_CATEGORY IS NULL )
AND ( X_GLOBAL_ATTRIBUTE_CATEGORY IS NULL ) ) )
AND ( ( Recinfo.EXCHANGE_RATE_TYPE = X_EXCHANGE_RATE_TYPE )
OR ( ( Recinfo.EXCHANGE_RATE_TYPE IS NULL )
AND ( X_EXCHANGE_RATE_TYPE IS NULL ) ) )
AND ( ( Recinfo.MIN_FC_INVOICE_OVERDUE_TYPE = X_MIN_FC_INVOICE_OVERDUE_TYPE )
OR ( ( Recinfo.MIN_FC_INVOICE_OVERDUE_TYPE IS NULL )
AND ( X_MIN_FC_INVOICE_OVERDUE_TYPE IS NULL ) ) )
AND ( ( Recinfo.MIN_FC_INVOICE_PERCENT = X_MIN_FC_INVOICE_PERCENT )
OR ( ( Recinfo.MIN_FC_INVOICE_PERCENT IS NULL )
AND ( X_MIN_FC_INVOICE_PERCENT IS NULL ) ) )
AND ( ( Recinfo.MIN_FC_BALANCE_OVERDUE_TYPE = X_MIN_FC_BALANCE_OVERDUE_TYPE )
OR ( ( Recinfo.MIN_FC_BALANCE_OVERDUE_TYPE IS NULL )
AND ( X_MIN_FC_BALANCE_OVERDUE_TYPE IS NULL ) ) )
AND ( ( Recinfo.MIN_FC_BALANCE_PERCENT = X_MIN_FC_BALANCE_PERCENT )
OR ( ( Recinfo.MIN_FC_BALANCE_PERCENT IS NULL )
AND ( X_MIN_FC_BALANCE_PERCENT IS NULL ) ) )
AND ( ( Recinfo.INTEREST_TYPE = X_INTEREST_TYPE )
OR ( ( Recinfo.INTEREST_TYPE IS NULL )
AND ( X_INTEREST_TYPE IS NULL ) ) )
AND ( ( Recinfo.INTEREST_FIXED_AMOUNT = X_INTEREST_FIXED_AMOUNT )
OR ( ( Recinfo.INTEREST_FIXED_AMOUNT IS NULL )
AND ( X_INTEREST_FIXED_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.INTEREST_SCHEDULE_ID = X_INTEREST_SCHEDULE_ID )
OR ( ( Recinfo.INTEREST_SCHEDULE_ID IS NULL )
AND ( X_INTEREST_SCHEDULE_ID IS NULL ) ) )
AND ( ( Recinfo.PENALTY_TYPE = X_PENALTY_TYPE )
OR ( ( Recinfo.PENALTY_TYPE IS NULL )
AND ( X_PENALTY_TYPE IS NULL ) ) )
AND ( ( Recinfo.PENALTY_RATE = X_PENALTY_RATE )
OR ( ( Recinfo.PENALTY_RATE IS NULL )
AND ( X_PENALTY_RATE IS NULL ) ) )
AND ( ( Recinfo.MIN_INTEREST_CHARGE = X_MIN_INTEREST_CHARGE )
OR ( ( Recinfo.MIN_INTEREST_CHARGE IS NULL )
AND ( X_MIN_INTEREST_CHARGE IS NULL ) ) )
AND ( ( Recinfo.PENALTY_FIXED_AMOUNT = X_PENALTY_FIXED_AMOUNT )
OR ( ( Recinfo.PENALTY_FIXED_AMOUNT IS NULL )
AND ( X_PENALTY_FIXED_AMOUNT IS NULL ) ) )
AND ( ( Recinfo.PENALTY_SCHEDULE_ID = X_PENALTY_SCHEDULE_ID )
OR ( ( Recinfo.PENALTY_SCHEDULE_ID IS NULL )
AND ( X_PENALTY_SCHEDULE_ID IS NULL ) ) )
) THEN
RETURN;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
PROCEDURE Select_Row (
X_PROFILE_CLASS_AMOUNT_ID IN OUT NOCOPY NUMBER,
X_PROFILE_CLASS_ID OUT NOCOPY NUMBER,
X_CURRENCY_CODE OUT NOCOPY VARCHAR2,
X_TRX_CREDIT_LIMIT OUT NOCOPY NUMBER,
X_OVERALL_CREDIT_LIMIT OUT NOCOPY NUMBER,
X_MIN_DUNNING_AMOUNT OUT NOCOPY NUMBER,
X_MAX_INTEREST_CHARGE OUT NOCOPY NUMBER,
X_MIN_STATEMENT_AMOUNT OUT NOCOPY NUMBER,
X_AUTO_REC_MIN_RECEIPT_AMOUNT OUT NOCOPY NUMBER,
X_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
X_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
X_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
X_INTEREST_RATE OUT NOCOPY NUMBER,
X_MIN_FC_BALANCE_AMOUNT OUT NOCOPY NUMBER,
X_MIN_FC_INVOICE_AMOUNT OUT NOCOPY NUMBER,
X_MIN_DUNNING_INVOICE_AMOUNT OUT NOCOPY NUMBER,
X_EXPIRATION_DATE OUT NOCOPY DATE,
X_JGZZ_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
X_JGZZ_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE1 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE2 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE3 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE4 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE5 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE6 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE7 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE8 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE9 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE10 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE11 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE12 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE13 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE14 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE15 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE16 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE17 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE18 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE19 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE20 OUT NOCOPY VARCHAR2,
X_GLOBAL_ATTRIBUTE_CATEGORY OUT NOCOPY VARCHAR2,
X_EXCHANGE_RATE_TYPE OUT NOCOPY VARCHAR2,
X_MIN_FC_INVOICE_OVERDUE_TYPE OUT NOCOPY VARCHAR2,
X_MIN_FC_INVOICE_PERCENT OUT NOCOPY NUMBER,
X_MIN_FC_BALANCE_OVERDUE_TYPE OUT NOCOPY VARCHAR2,
X_MIN_FC_BALANCE_PERCENT OUT NOCOPY NUMBER,
X_INTEREST_TYPE OUT NOCOPY VARCHAR2,
X_INTEREST_FIXED_AMOUNT OUT NOCOPY NUMBER,
X_INTEREST_SCHEDULE_ID OUT NOCOPY NUMBER,
X_PENALTY_TYPE OUT NOCOPY VARCHAR2,
X_PENALTY_RATE OUT NOCOPY NUMBER,
X_MIN_INTEREST_CHARGE OUT NOCOPY NUMBER,
X_PENALTY_FIXED_AMOUNT OUT NOCOPY NUMBER,
X_PENALTY_SCHEDULE_ID OUT NOCOPY NUMBER
) IS
BEGIN
SELECT
NVL( PROFILE_CLASS_AMOUNT_ID, FND_API.G_MISS_NUM ),
NVL( PROFILE_CLASS_ID, FND_API.G_MISS_NUM ),
NVL( CURRENCY_CODE, FND_API.G_MISS_CHAR ),
NVL( TRX_CREDIT_LIMIT, FND_API.G_MISS_NUM ),
NVL( OVERALL_CREDIT_LIMIT, FND_API.G_MISS_NUM ),
NVL( MIN_DUNNING_AMOUNT, FND_API.G_MISS_NUM ),
NVL( MAX_INTEREST_CHARGE, FND_API.G_MISS_NUM ),
NVL( MIN_STATEMENT_AMOUNT, FND_API.G_MISS_NUM ),
NVL( AUTO_REC_MIN_RECEIPT_AMOUNT, FND_API.G_MISS_NUM ),
NVL( ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE1, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE2, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE3, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE4, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE5, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE6, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE7, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE8, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE9, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE10, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE11, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE12, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE13, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE14, FND_API.G_MISS_CHAR ),
NVL( ATTRIBUTE15, FND_API.G_MISS_CHAR ),
NVL( INTEREST_RATE, FND_API.G_MISS_NUM ),
NVL( MIN_FC_BALANCE_AMOUNT, FND_API.G_MISS_NUM ),
NVL( MIN_FC_INVOICE_AMOUNT, FND_API.G_MISS_NUM ),
NVL( MIN_DUNNING_INVOICE_AMOUNT, FND_API.G_MISS_NUM ),
NVL( EXPIRATION_DATE, FND_API.G_MISS_DATE ),
NVL( JGZZ_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
NVL( JGZZ_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE1, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE2, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE3, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE4, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE5, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE6, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE7, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE8, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE9, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE10, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE11, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE12, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE13, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE14, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE15, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE16, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE17, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE18, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE19, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE20, FND_API.G_MISS_CHAR ),
NVL( GLOBAL_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR ),
NVL( EXCHANGE_RATE_TYPE, FND_API.G_MISS_CHAR ),
NVL( MIN_FC_INVOICE_OVERDUE_TYPE, FND_API.G_MISS_CHAR ),
NVL( MIN_FC_INVOICE_PERCENT, FND_API.G_MISS_NUM ),
NVL( MIN_FC_BALANCE_OVERDUE_TYPE, FND_API.G_MISS_CHAR ),
NVL( MIN_FC_BALANCE_PERCENT, FND_API.G_MISS_NUM ),
NVL( INTEREST_TYPE, FND_API.G_MISS_CHAR ),
NVL( INTEREST_FIXED_AMOUNT, FND_API.G_MISS_NUM ),
NVL( INTEREST_SCHEDULE_ID, FND_API.G_MISS_NUM ),
NVL( PENALTY_TYPE, FND_API.G_MISS_CHAR ),
NVL( PENALTY_RATE, FND_API.G_MISS_NUM ),
NVL( MIN_INTEREST_CHARGE, FND_API.G_MISS_NUM ),
NVL( PENALTY_FIXED_AMOUNT, FND_API.G_MISS_NUM ),
NVL( PENALTY_SCHEDULE_ID, FND_API.G_MISS_NUM )
INTO
X_PROFILE_CLASS_AMOUNT_ID,
X_PROFILE_CLASS_ID,
X_CURRENCY_CODE,
X_TRX_CREDIT_LIMIT,
X_OVERALL_CREDIT_LIMIT,
X_MIN_DUNNING_AMOUNT,
X_MAX_INTEREST_CHARGE,
X_MIN_STATEMENT_AMOUNT,
X_AUTO_REC_MIN_RECEIPT_AMOUNT,
X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
X_INTEREST_RATE,
X_MIN_FC_BALANCE_AMOUNT,
X_MIN_FC_INVOICE_AMOUNT,
X_MIN_DUNNING_INVOICE_AMOUNT,
X_EXPIRATION_DATE,
X_JGZZ_ATTRIBUTE_CATEGORY,
X_JGZZ_ATTRIBUTE1,
X_JGZZ_ATTRIBUTE2,
X_JGZZ_ATTRIBUTE3,
X_JGZZ_ATTRIBUTE4,
X_JGZZ_ATTRIBUTE5,
X_JGZZ_ATTRIBUTE6,
X_JGZZ_ATTRIBUTE7,
X_JGZZ_ATTRIBUTE8,
X_JGZZ_ATTRIBUTE9,
X_JGZZ_ATTRIBUTE10,
X_JGZZ_ATTRIBUTE11,
X_JGZZ_ATTRIBUTE12,
X_JGZZ_ATTRIBUTE13,
X_JGZZ_ATTRIBUTE14,
X_JGZZ_ATTRIBUTE15,
X_GLOBAL_ATTRIBUTE1,
X_GLOBAL_ATTRIBUTE2,
X_GLOBAL_ATTRIBUTE3,
X_GLOBAL_ATTRIBUTE4,
X_GLOBAL_ATTRIBUTE5,
X_GLOBAL_ATTRIBUTE6,
X_GLOBAL_ATTRIBUTE7,
X_GLOBAL_ATTRIBUTE8,
X_GLOBAL_ATTRIBUTE9,
X_GLOBAL_ATTRIBUTE10,
X_GLOBAL_ATTRIBUTE11,
X_GLOBAL_ATTRIBUTE12,
X_GLOBAL_ATTRIBUTE13,
X_GLOBAL_ATTRIBUTE14,
X_GLOBAL_ATTRIBUTE15,
X_GLOBAL_ATTRIBUTE16,
X_GLOBAL_ATTRIBUTE17,
X_GLOBAL_ATTRIBUTE18,
X_GLOBAL_ATTRIBUTE19,
X_GLOBAL_ATTRIBUTE20,
X_GLOBAL_ATTRIBUTE_CATEGORY,
X_EXCHANGE_RATE_TYPE,
X_MIN_FC_INVOICE_OVERDUE_TYPE,
X_MIN_FC_INVOICE_PERCENT,
X_MIN_FC_BALANCE_OVERDUE_TYPE,
X_MIN_FC_BALANCE_PERCENT,
X_INTEREST_TYPE,
X_INTEREST_FIXED_AMOUNT,
X_INTEREST_SCHEDULE_ID,
X_PENALTY_TYPE,
X_PENALTY_RATE,
X_MIN_INTEREST_CHARGE,
X_PENALTY_FIXED_AMOUNT,
X_PENALTY_SCHEDULE_ID
FROM HZ_CUST_PROF_CLASS_AMTS
WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;
END Select_Row;
PROCEDURE Delete_Row (
X_PROFILE_CLASS_AMOUNT_ID IN NUMBER
) IS
BEGIN
DELETE FROM HZ_CUST_PROF_CLASS_AMTS
WHERE PROFILE_CLASS_AMOUNT_ID = X_PROFILE_CLASS_AMOUNT_ID;
END Delete_Row;