[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE do_update_customer_profile (
p_customer_profile_rec IN OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
PROCEDURE do_update_cust_profile_amt (
p_cust_profile_amt_rec IN OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
);
SELECT a.party_id
FROM hz_cust_accounts a,
hz_parties b
WHERE a.cust_account_id = p_cust_account_id
AND a.party_id = b.party_id
AND b.status = DECODE(p_active,'ALL',b.status,p_active);
SELECT 'Y'
FROM hz_parties
WHERE party_id = p_party_id
AND status = DECODE(p_active,'ALL',status,p_active);
SELECT review_cycle
FROM hz_cust_profile_classes
WHERE profile_class_id = p_cust_prof_class_id;
* HZ_CUSTOMER_PROFILES_PKG.Insert_Row
* HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_create_profile_amt If it is set to FND_API.G_TRUE, API create customer
* profile amounts by copying corresponding data
* from customer profile class amounts.
* IN/OUT:
* p_customer_profile_rec Customer profile record. One customer account
* must have a customer profile. One account site
* use can optionally have one customer profile.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* OUT:
* x_cust_account_profile_id Customer account profile ID.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
* 07-15-2004 Rajib Ranjan Borah o Bug 3767719. Used variable l_default_profile_class_id
* instead of using the hard-coded value 0 to improve
* performance. This query and the one in package
* HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
* will be parsed only once.
*/
PROCEDURE do_create_customer_profile (
p_customer_profile_rec IN OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
p_create_profile_amt IN VARCHAR2,
x_cust_account_profile_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_create_customer_profile';
SELECT PROFILE_CLASS_AMOUNT_ID
FROM HZ_CUST_PROF_CLASS_AMTS
WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
select cons_bill_level, cons_inv_type
from hz_customer_profiles
where cust_account_id = p_customer_profile_rec.cust_account_id
and site_use_id is NULL
and cons_inv_flag = 'Y';
SELECT STATUS, NAME INTO l_status, l_profile_class_name
FROM HZ_CUST_PROFILE_CLASSES
WHERE PROFILE_CLASS_ID = l_default_profile_class_id; -- Bug 3767719.
SELECT * INTO l_profile_class_rec
FROM HZ_CUST_PROFILE_CLASSES
WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
p_create_update_flag => 'C',
p_customer_profile_rec => p_customer_profile_rec,
p_rowid => NULL,
x_return_status => x_return_status );
hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUSTOMER_PROFILES_PKG.Insert_Row (
X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,
X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
X_STATUS => p_customer_profile_rec.status,
X_COLLECTOR_ID => p_customer_profile_rec.collector_id,
X_CREDIT_ANALYST_ID => p_customer_profile_rec.credit_analyst_id,
X_CREDIT_CHECKING => p_customer_profile_rec.credit_checking,
X_NEXT_CREDIT_REVIEW_DATE => p_customer_profile_rec.next_credit_review_date,
X_TOLERANCE => p_customer_profile_rec.tolerance,
X_DISCOUNT_TERMS => p_customer_profile_rec.discount_terms,
X_DUNNING_LETTERS => p_customer_profile_rec.dunning_letters,
X_INTEREST_CHARGES => p_customer_profile_rec.interest_charges,
X_SEND_STATEMENTS => p_customer_profile_rec.send_statements,
X_CREDIT_BALANCE_STATEMENTS => p_customer_profile_rec.credit_balance_statements,
X_CREDIT_HOLD => p_customer_profile_rec.credit_hold,
X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
X_RISK_CODE => p_customer_profile_rec.risk_code,
X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,
X_DISCOUNT_GRACE_DAYS => p_customer_profile_rec.discount_grace_days,
X_STATEMENT_CYCLE_ID => p_customer_profile_rec.statement_cycle_id,
X_ACCOUNT_STATUS => p_customer_profile_rec.account_status,
X_PERCENT_COLLECTABLE => p_customer_profile_rec.percent_collectable,
X_AUTOCASH_HIERARCHY_ID => p_customer_profile_rec.autocash_hierarchy_id,
X_ATTRIBUTE_CATEGORY => p_customer_profile_rec.attribute_category,
X_ATTRIBUTE1 => p_customer_profile_rec.attribute1,
X_ATTRIBUTE2 => p_customer_profile_rec.attribute2,
X_ATTRIBUTE3 => p_customer_profile_rec.attribute3,
X_ATTRIBUTE4 => p_customer_profile_rec.attribute4,
X_ATTRIBUTE5 => p_customer_profile_rec.attribute5,
X_ATTRIBUTE6 => p_customer_profile_rec.attribute6,
X_ATTRIBUTE7 => p_customer_profile_rec.attribute7,
X_ATTRIBUTE8 => p_customer_profile_rec.attribute8,
X_ATTRIBUTE9 => p_customer_profile_rec.attribute9,
X_ATTRIBUTE10 => p_customer_profile_rec.attribute10,
X_ATTRIBUTE11 => p_customer_profile_rec.attribute11,
X_ATTRIBUTE12 => p_customer_profile_rec.attribute12,
X_ATTRIBUTE13 => p_customer_profile_rec.attribute13,
X_ATTRIBUTE14 => p_customer_profile_rec.attribute14,
X_ATTRIBUTE15 => p_customer_profile_rec.attribute15,
X_AUTO_REC_INCL_DISPUTED_FLAG => p_customer_profile_rec.auto_rec_incl_disputed_flag,
X_TAX_PRINTING_OPTION => p_customer_profile_rec.tax_printing_option,
X_CHARGE_ON_FINANCE_CHARGE_FG => p_customer_profile_rec.charge_on_finance_charge_flag,
X_GROUPING_RULE_ID => p_customer_profile_rec.grouping_rule_id,
X_CLEARING_DAYS => p_customer_profile_rec.clearing_days,
X_JGZZ_ATTRIBUTE_CATEGORY => p_customer_profile_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => p_customer_profile_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => p_customer_profile_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => p_customer_profile_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => p_customer_profile_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => p_customer_profile_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => p_customer_profile_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => p_customer_profile_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => p_customer_profile_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => p_customer_profile_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => p_customer_profile_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => p_customer_profile_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => p_customer_profile_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => p_customer_profile_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => p_customer_profile_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => p_customer_profile_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => p_customer_profile_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_customer_profile_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_customer_profile_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_customer_profile_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_customer_profile_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_customer_profile_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_customer_profile_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_customer_profile_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_customer_profile_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_customer_profile_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_customer_profile_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_customer_profile_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_customer_profile_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_customer_profile_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_customer_profile_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_customer_profile_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_customer_profile_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_customer_profile_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_customer_profile_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_customer_profile_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_customer_profile_rec.global_attribute_category,
X_CONS_INV_FLAG => p_customer_profile_rec.cons_inv_flag,
X_CONS_INV_TYPE => p_customer_profile_rec.cons_inv_type,
X_AUTOCASH_HIERARCHY_ID_ADR => p_customer_profile_rec.autocash_hierarchy_id_for_adr,
X_LOCKBOX_MATCHING_OPTION => p_customer_profile_rec.lockbox_matching_option,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_customer_profile_rec.created_by_module,
X_APPLICATION_ID => p_customer_profile_rec.application_id,
X_REVIEW_CYCLE => p_customer_profile_rec.review_cycle,
X_last_credit_review_date => p_customer_profile_rec.last_credit_review_date,
X_party_id => p_customer_profile_rec.party_id,
X_CREDIT_CLASSIFICATION => p_customer_profile_rec.credit_classification,
X_CONS_BILL_LEVEL => p_customer_profile_rec.cons_bill_level,
X_LATE_CHARGE_CALCULATION_TRX => p_customer_profile_rec.late_charge_calculation_trx,
X_CREDIT_ITEMS_FLAG => p_customer_profile_rec.credit_items_flag,
X_DISPUTED_TRANSACTIONS_FLAG => p_customer_profile_rec.disputed_transactions_flag,
X_LATE_CHARGE_TYPE => p_customer_profile_rec.late_charge_type,
X_LATE_CHARGE_TERM_ID => p_customer_profile_rec.late_charge_term_id,
X_INTEREST_CALCULATION_PERIOD => p_customer_profile_rec.interest_calculation_period,
X_HOLD_CHARGED_INVOICES_FLAG => p_customer_profile_rec.hold_charged_invoices_flag,
X_MESSAGE_TEXT_ID => p_customer_profile_rec.message_text_id,
X_MULTIPLE_INTEREST_RATES_FLAG => p_customer_profile_rec.multiple_interest_rates_flag,
X_CHARGE_BEGIN_DATE => p_customer_profile_rec.charge_begin_date,
X_AUTOMATCH_SET_ID => p_customer_profile_rec.automatch_set_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Insert_Row (-) ' ||
'x_cust_account_profile_id = ' || x_cust_account_profile_id,
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
X_PROFILE_CLASS_ID => l_profile_class_id,
X_CURRENCY_CODE => l_cust_profile_amt_rec.currency_code,
X_TRX_CREDIT_LIMIT => l_cust_profile_amt_rec.trx_credit_limit,
X_OVERALL_CREDIT_LIMIT => l_cust_profile_amt_rec.overall_credit_limit,
X_MIN_DUNNING_AMOUNT => l_cust_profile_amt_rec.min_dunning_amount,
X_MAX_INTEREST_CHARGE => l_cust_profile_amt_rec.max_interest_charge,
X_MIN_STATEMENT_AMOUNT => l_cust_profile_amt_rec.min_statement_amount,
X_AUTO_REC_MIN_RECEIPT_AMOUNT => l_cust_profile_amt_rec.auto_rec_min_receipt_amount,
X_ATTRIBUTE_CATEGORY => l_cust_profile_amt_rec.attribute_category,
X_ATTRIBUTE1 => l_cust_profile_amt_rec.attribute1,
X_ATTRIBUTE2 => l_cust_profile_amt_rec.attribute2,
X_ATTRIBUTE3 => l_cust_profile_amt_rec.attribute3,
X_ATTRIBUTE4 => l_cust_profile_amt_rec.attribute4,
X_ATTRIBUTE5 => l_cust_profile_amt_rec.attribute5,
X_ATTRIBUTE6 => l_cust_profile_amt_rec.attribute6,
X_ATTRIBUTE7 => l_cust_profile_amt_rec.attribute7,
X_ATTRIBUTE8 => l_cust_profile_amt_rec.attribute8,
X_ATTRIBUTE9 => l_cust_profile_amt_rec.attribute9,
X_ATTRIBUTE10 => l_cust_profile_amt_rec.attribute10,
X_ATTRIBUTE11 => l_cust_profile_amt_rec.attribute11,
X_ATTRIBUTE12 => l_cust_profile_amt_rec.attribute12,
X_ATTRIBUTE13 => l_cust_profile_amt_rec.attribute13,
X_ATTRIBUTE14 => l_cust_profile_amt_rec.attribute14,
X_ATTRIBUTE15 => l_cust_profile_amt_rec.attribute15,
X_INTEREST_RATE => l_cust_profile_amt_rec.interest_rate,
X_MIN_FC_BALANCE_AMOUNT => l_cust_profile_amt_rec.min_fc_balance_amount,
X_MIN_FC_INVOICE_AMOUNT => l_cust_profile_amt_rec.min_fc_invoice_amount,
X_MIN_DUNNING_INVOICE_AMOUNT => l_cust_profile_amt_rec.min_dunning_invoice_amount,
X_EXPIRATION_DATE => l_cust_profile_amt_rec.expiration_date,
X_JGZZ_ATTRIBUTE_CATEGORY => l_cust_profile_amt_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => l_cust_profile_amt_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => l_cust_profile_amt_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => l_cust_profile_amt_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => l_cust_profile_amt_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => l_cust_profile_amt_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => l_cust_profile_amt_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => l_cust_profile_amt_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => l_cust_profile_amt_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => l_cust_profile_amt_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => l_cust_profile_amt_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => l_cust_profile_amt_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => l_cust_profile_amt_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => l_cust_profile_amt_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => l_cust_profile_amt_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => l_cust_profile_amt_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => l_cust_profile_amt_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => l_cust_profile_amt_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => l_cust_profile_amt_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => l_cust_profile_amt_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => l_cust_profile_amt_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => l_cust_profile_amt_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => l_cust_profile_amt_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => l_cust_profile_amt_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => l_cust_profile_amt_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => l_cust_profile_amt_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => l_cust_profile_amt_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => l_cust_profile_amt_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => l_cust_profile_amt_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => l_cust_profile_amt_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => l_cust_profile_amt_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => l_cust_profile_amt_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => l_cust_profile_amt_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => l_cust_profile_amt_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => l_cust_profile_amt_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => l_cust_profile_amt_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => l_cust_profile_amt_rec.global_attribute_category,
X_EXCHANGE_RATE_TYPE => l_cust_profile_amt_rec.exchange_rate_type,
X_MIN_FC_INVOICE_OVERDUE_TYPE => l_cust_profile_amt_rec.min_fc_invoice_overdue_type,
X_MIN_FC_INVOICE_PERCENT => l_cust_profile_amt_rec.min_fc_invoice_percent,
X_MIN_FC_BALANCE_OVERDUE_TYPE => l_cust_profile_amt_rec.min_fc_balance_overdue_type,
X_MIN_FC_BALANCE_PERCENT => l_cust_profile_amt_rec.min_fc_balance_percent,
X_INTEREST_TYPE => l_cust_profile_amt_rec.interest_type,
X_INTEREST_FIXED_AMOUNT => l_cust_profile_amt_rec.interest_fixed_amount,
X_INTEREST_SCHEDULE_ID => l_cust_profile_amt_rec.interest_schedule_id,
X_PENALTY_TYPE => l_cust_profile_amt_rec.penalty_type,
X_PENALTY_RATE => l_cust_profile_amt_rec.penalty_rate,
X_MIN_INTEREST_CHARGE => l_cust_profile_amt_rec.min_interest_charge,
X_PENALTY_FIXED_AMOUNT => l_cust_profile_amt_rec.penalty_fixed_amount,
X_PENALTY_SCHEDULE_ID => l_cust_profile_amt_rec.penalty_schedule_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
* PRIVATE PROCEDURE do_update_customer_profile
*
* DESCRIPTION
* Private procedure to update customer profile.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_ACCOUNT_VALIDATE_V2PUB.validate_customer_profile
* HZ_CUSTOMER_PROFILES_PKG.Update_Row
* HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row
*
* ARGUMENTS
* IN/OUT:
* p_customer_profile_rec Customer profile record. One customer account
* must have a customer profile. One account site
* use can optionally have one customer profile.
* p_object_version_number Used for locking the being updated record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE do_update_customer_profile (
p_customer_profile_rec IN OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_update_customer_profile'
SELECT PROFILE_CLASS_AMOUNT_ID
FROM HZ_CUST_PROF_CLASS_AMTS
WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
select cons_bill_level, cons_inv_type
from hz_customer_profiles
where cust_account_id = l_cust_account_id
and site_use_id is NULL
and cons_inv_flag = 'Y';
hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT ROWID, OBJECT_VERSION_NUMBER, CUST_ACCOUNT_ID, SITE_USE_ID,
CREATED_BY_MODULE, APPLICATION_ID,PROFILE_CLASS_ID, PARTY_ID,
CREDIT_HOLD , CONS_INV_FLAG, CONS_INV_TYPE, CONS_BILL_LEVEL,
LATE_CHARGE_TYPE, LATE_CHARGE_TERM_ID, MESSAGE_TEXT_ID, STANDARD_TERMS,
AUTOMATCH_SET_ID
INTO l_rowid, l_object_version_number, l_cust_account_id, l_site_use_id,
l_created_by_module, l_application_id,l_profile_class_id, l_party_id,
l_credit_hold, l_cons_inv_flag, l_cons_inv_type, l_cons_bill_level,
l_late_charge_type, l_late_charge_term_id, l_message_text_id, l_standard_terms,
l_automatch_set_id
FROM HZ_CUSTOMER_PROFILES
WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
FOR UPDATE NOWAIT;
SELECT * INTO l_profile_class_rec
FROM HZ_CUST_PROFILE_CLASSES
WHERE PROFILE_CLASS_ID = p_customer_profile_rec.profile_class_id;
p_create_update_flag => 'U',
p_customer_profile_rec => p_customer_profile_rec,
p_rowid => l_rowid,
x_return_status => x_return_status );
hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUSTOMER_PROFILES_PKG.Update_Row (
X_Rowid => l_rowid,
X_CUST_ACCOUNT_PROFILE_ID => p_customer_profile_rec.cust_account_profile_id,
X_CUST_ACCOUNT_ID => p_customer_profile_rec.cust_account_id,
X_STATUS => p_customer_profile_rec.status,
X_COLLECTOR_ID => p_customer_profile_rec.collector_id,
X_CREDIT_ANALYST_ID => p_customer_profile_rec.credit_analyst_id,
X_CREDIT_CHECKING => p_customer_profile_rec.credit_checking,
X_NEXT_CREDIT_REVIEW_DATE => p_customer_profile_rec.next_credit_review_date,
X_TOLERANCE => p_customer_profile_rec.tolerance,
X_DISCOUNT_TERMS => p_customer_profile_rec.discount_terms,
X_DUNNING_LETTERS => p_customer_profile_rec.dunning_letters,
X_INTEREST_CHARGES => p_customer_profile_rec.interest_charges,
X_SEND_STATEMENTS => p_customer_profile_rec.send_statements,
X_CREDIT_BALANCE_STATEMENTS => p_customer_profile_rec.credit_balance_statements,
X_CREDIT_HOLD => p_customer_profile_rec.credit_hold,
X_PROFILE_CLASS_ID => p_customer_profile_rec.profile_class_id,
X_SITE_USE_ID => p_customer_profile_rec.site_use_id,
X_CREDIT_RATING => p_customer_profile_rec.credit_rating,
X_RISK_CODE => p_customer_profile_rec.risk_code,
X_STANDARD_TERMS => p_customer_profile_rec.standard_terms,
X_OVERRIDE_TERMS => p_customer_profile_rec.override_terms,
X_DUNNING_LETTER_SET_ID => p_customer_profile_rec.dunning_letter_set_id,
X_INTEREST_PERIOD_DAYS => p_customer_profile_rec.interest_period_days,
X_PAYMENT_GRACE_DAYS => p_customer_profile_rec.payment_grace_days,
X_DISCOUNT_GRACE_DAYS => p_customer_profile_rec.discount_grace_days,
X_STATEMENT_CYCLE_ID => p_customer_profile_rec.statement_cycle_id,
X_ACCOUNT_STATUS => p_customer_profile_rec.account_status,
X_PERCENT_COLLECTABLE => p_customer_profile_rec.percent_collectable,
X_AUTOCASH_HIERARCHY_ID => p_customer_profile_rec.autocash_hierarchy_id,
X_ATTRIBUTE_CATEGORY => p_customer_profile_rec.attribute_category,
X_ATTRIBUTE1 => p_customer_profile_rec.attribute1,
X_ATTRIBUTE2 => p_customer_profile_rec.attribute2,
X_ATTRIBUTE3 => p_customer_profile_rec.attribute3,
X_ATTRIBUTE4 => p_customer_profile_rec.attribute4,
X_ATTRIBUTE5 => p_customer_profile_rec.attribute5,
X_ATTRIBUTE6 => p_customer_profile_rec.attribute6,
X_ATTRIBUTE7 => p_customer_profile_rec.attribute7,
X_ATTRIBUTE8 => p_customer_profile_rec.attribute8,
X_ATTRIBUTE9 => p_customer_profile_rec.attribute9,
X_ATTRIBUTE10 => p_customer_profile_rec.attribute10,
X_ATTRIBUTE11 => p_customer_profile_rec.attribute11,
X_ATTRIBUTE12 => p_customer_profile_rec.attribute12,
X_ATTRIBUTE13 => p_customer_profile_rec.attribute13,
X_ATTRIBUTE14 => p_customer_profile_rec.attribute14,
X_ATTRIBUTE15 => p_customer_profile_rec.attribute15,
X_AUTO_REC_INCL_DISPUTED_FLAG => p_customer_profile_rec.auto_rec_incl_disputed_flag,
X_TAX_PRINTING_OPTION => p_customer_profile_rec.tax_printing_option,
X_CHARGE_ON_FINANCE_CHARGE_FG => p_customer_profile_rec.charge_on_finance_charge_flag,
X_GROUPING_RULE_ID => p_customer_profile_rec.grouping_rule_id,
X_CLEARING_DAYS => p_customer_profile_rec.clearing_days,
X_JGZZ_ATTRIBUTE_CATEGORY => p_customer_profile_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => p_customer_profile_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => p_customer_profile_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => p_customer_profile_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => p_customer_profile_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => p_customer_profile_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => p_customer_profile_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => p_customer_profile_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => p_customer_profile_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => p_customer_profile_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => p_customer_profile_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => p_customer_profile_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => p_customer_profile_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => p_customer_profile_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => p_customer_profile_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => p_customer_profile_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => p_customer_profile_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_customer_profile_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_customer_profile_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_customer_profile_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_customer_profile_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_customer_profile_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_customer_profile_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_customer_profile_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_customer_profile_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_customer_profile_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_customer_profile_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_customer_profile_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_customer_profile_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_customer_profile_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_customer_profile_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_customer_profile_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_customer_profile_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_customer_profile_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_customer_profile_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_customer_profile_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_customer_profile_rec.global_attribute_category,
X_CONS_INV_FLAG => p_customer_profile_rec.cons_inv_flag,
X_CONS_INV_TYPE => p_customer_profile_rec.cons_inv_type,
X_AUTOCASH_HIERARCHY_ID_ADR => p_customer_profile_rec.autocash_hierarchy_id_for_adr,
X_LOCKBOX_MATCHING_OPTION => p_customer_profile_rec.lockbox_matching_option,
X_OBJECT_VERSION_NUMBER => p_object_version_number,
X_CREATED_BY_MODULE => p_customer_profile_rec.created_by_module,
X_APPLICATION_ID => p_customer_profile_rec.application_id,
X_review_cycle => p_customer_profile_rec.review_cycle,
X_last_credit_review_date => p_customer_profile_rec.last_credit_review_date,
X_party_id => p_customer_profile_rec.party_id,
X_CREDIT_CLASSIFICATION => p_customer_profile_rec.credit_classification,
X_CONS_BILL_LEVEL => p_customer_profile_rec.cons_bill_level,
X_LATE_CHARGE_CALCULATION_TRX => p_customer_profile_rec.late_charge_calculation_trx,
X_CREDIT_ITEMS_FLAG => p_customer_profile_rec.credit_items_flag,
X_DISPUTED_TRANSACTIONS_FLAG => p_customer_profile_rec.disputed_transactions_flag,
X_LATE_CHARGE_TYPE => p_customer_profile_rec.late_charge_type,
X_LATE_CHARGE_TERM_ID => p_customer_profile_rec.late_charge_term_id,
X_INTEREST_CALCULATION_PERIOD => p_customer_profile_rec.interest_calculation_period,
X_HOLD_CHARGED_INVOICES_FLAG => p_customer_profile_rec.hold_charged_invoices_flag,
X_MESSAGE_TEXT_ID => p_customer_profile_rec.message_text_id,
X_MULTIPLE_INTEREST_RATES_FLAG => p_customer_profile_rec.multiple_interest_rates_flag,
X_CHARGE_BEGIN_DATE => p_customer_profile_rec.charge_begin_date,
X_AUTOMATCH_SET_ID => p_customer_profile_rec.automatch_set_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Update_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
update HZ_CUSTOMER_PROFILES
set cons_bill_level = 'SITE'
where site_use_id is NOT NULL
and cons_inv_flag = 'Y'
and cust_account_id = l_cust_account_id;
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
X_PROFILE_CLASS_ID => l_profile_class_id,
X_CURRENCY_CODE => l_cust_profile_amt_rec.currency_code,
X_TRX_CREDIT_LIMIT => l_cust_profile_amt_rec.trx_credit_limit,
X_OVERALL_CREDIT_LIMIT => l_cust_profile_amt_rec.overall_credit_limit,
X_MIN_DUNNING_AMOUNT => l_cust_profile_amt_rec.min_dunning_amount,
X_MAX_INTEREST_CHARGE => l_cust_profile_amt_rec.max_interest_charge,
X_MIN_STATEMENT_AMOUNT => l_cust_profile_amt_rec.min_statement_amount,
X_AUTO_REC_MIN_RECEIPT_AMOUNT => l_cust_profile_amt_rec.auto_rec_min_receipt_amount,
X_ATTRIBUTE_CATEGORY => l_cust_profile_amt_rec.attribute_category,
X_ATTRIBUTE1 => l_cust_profile_amt_rec.attribute1,
X_ATTRIBUTE2 => l_cust_profile_amt_rec.attribute2,
X_ATTRIBUTE3 => l_cust_profile_amt_rec.attribute3,
X_ATTRIBUTE4 => l_cust_profile_amt_rec.attribute4,
X_ATTRIBUTE5 => l_cust_profile_amt_rec.attribute5,
X_ATTRIBUTE6 => l_cust_profile_amt_rec.attribute6,
X_ATTRIBUTE7 => l_cust_profile_amt_rec.attribute7,
X_ATTRIBUTE8 => l_cust_profile_amt_rec.attribute8,
X_ATTRIBUTE9 => l_cust_profile_amt_rec.attribute9,
X_ATTRIBUTE10 => l_cust_profile_amt_rec.attribute10,
X_ATTRIBUTE11 => l_cust_profile_amt_rec.attribute11,
X_ATTRIBUTE12 => l_cust_profile_amt_rec.attribute12,
X_ATTRIBUTE13 => l_cust_profile_amt_rec.attribute13,
X_ATTRIBUTE14 => l_cust_profile_amt_rec.attribute14,
X_ATTRIBUTE15 => l_cust_profile_amt_rec.attribute15,
X_INTEREST_RATE => l_cust_profile_amt_rec.interest_rate,
X_MIN_FC_BALANCE_AMOUNT => l_cust_profile_amt_rec.min_fc_balance_amount,
X_MIN_FC_INVOICE_AMOUNT => l_cust_profile_amt_rec.min_fc_invoice_amount,
X_MIN_DUNNING_INVOICE_AMOUNT => l_cust_profile_amt_rec.min_dunning_invoice_amount,
X_EXPIRATION_DATE => l_cust_profile_amt_rec.expiration_date,
X_JGZZ_ATTRIBUTE_CATEGORY => l_cust_profile_amt_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => l_cust_profile_amt_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => l_cust_profile_amt_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => l_cust_profile_amt_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => l_cust_profile_amt_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => l_cust_profile_amt_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => l_cust_profile_amt_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => l_cust_profile_amt_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => l_cust_profile_amt_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => l_cust_profile_amt_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => l_cust_profile_amt_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => l_cust_profile_amt_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => l_cust_profile_amt_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => l_cust_profile_amt_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => l_cust_profile_amt_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => l_cust_profile_amt_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => l_cust_profile_amt_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => l_cust_profile_amt_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => l_cust_profile_amt_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => l_cust_profile_amt_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => l_cust_profile_amt_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => l_cust_profile_amt_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => l_cust_profile_amt_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => l_cust_profile_amt_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => l_cust_profile_amt_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => l_cust_profile_amt_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => l_cust_profile_amt_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => l_cust_profile_amt_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => l_cust_profile_amt_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => l_cust_profile_amt_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => l_cust_profile_amt_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => l_cust_profile_amt_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => l_cust_profile_amt_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => l_cust_profile_amt_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => l_cust_profile_amt_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => l_cust_profile_amt_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => l_cust_profile_amt_rec.global_attribute_category,
X_EXCHANGE_RATE_TYPE => l_cust_profile_amt_rec.exchange_rate_type,
X_MIN_FC_INVOICE_OVERDUE_TYPE => l_cust_profile_amt_rec.min_fc_invoice_overdue_type,
X_MIN_FC_INVOICE_PERCENT => l_cust_profile_amt_rec.min_fc_invoice_percent,
X_MIN_FC_BALANCE_OVERDUE_TYPE => l_cust_profile_amt_rec.min_fc_balance_overdue_type,
X_MIN_FC_BALANCE_PERCENT => l_cust_profile_amt_rec.min_fc_balance_percent,
X_INTEREST_TYPE => l_cust_profile_amt_rec.interest_type,
X_INTEREST_FIXED_AMOUNT => l_cust_profile_amt_rec.interest_fixed_amount,
X_INTEREST_SCHEDULE_ID => l_cust_profile_amt_rec.interest_schedule_id,
X_PENALTY_TYPE => l_cust_profile_amt_rec.penalty_type,
X_PENALTY_RATE => l_cust_profile_amt_rec.penalty_rate,
X_MIN_INTEREST_CHARGE => l_cust_profile_amt_rec.min_interest_charge,
X_PENALTY_FIXED_AMOUNT => l_cust_profile_amt_rec.penalty_fixed_amount,
X_PENALTY_SCHEDULE_ID => l_cust_profile_amt_rec.penalty_schedule_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT CUST_ACCT_PROFILE_AMT_ID, OBJECT_VERSION_NUMBER
INTO l_cust_acct_profile_amt_id, l_amt_object_version_number
FROM HZ_CUST_PROFILE_AMTS
WHERE CUST_ACCOUNT_PROFILE_ID = p_customer_profile_rec.cust_account_profile_id
AND CURRENCY_CODE = l_cust_profile_amt_rec.currency_code;
update_cust_profile_amt (
p_cust_profile_amt_rec => l_cust_profile_amt_rec,
p_object_version_number => l_amt_object_version_number,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data );
hz_credit_usages_cascade_pkg.delete_credit_usages(
l_cust_profile_amt_rec.cust_acct_profile_amt_id
, x_return_status
, l_msg_count
, l_msg_data);
hz_utility_v2pub.debug(p_message=>'do_update_customer_profile (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_customer_profile;
* HZ_CUST_PROFILE_AMTS_PKG.Insert_Row
*
* ARGUMENTS
* IN:
* p_check_foreign_key If do foreign key checking on cust_account_id
* and cust_account_profile_id or not. Defaut value
* is FND_API.G_TRUE, which means API will do foreign
* key checking on these 2 columns.
* IN/OUT:
* p_cust_profile_amt_rec Customer profile amount record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* OUT:
* x_cust_acct_profile_amt_id Customer account profile amount ID.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE do_create_cust_profile_amt (
p_check_foreign_key IN VARCHAR2,
p_cust_profile_amt_rec IN OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
x_cust_acct_profile_amt_id OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_create_cust_profile_amt'
p_create_update_flag => 'C',
p_check_foreign_key => p_check_foreign_key,
p_cust_profile_amt_rec => p_cust_profile_amt_rec,
p_rowid => NULL,
x_return_status => x_return_status );
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT site_use_id
INTO l_site_use_id
FROM hz_customer_profiles
WHERE cust_account_id = p_cust_profile_amt_rec.cust_account_id
AND cust_account_profile_id = p_cust_profile_amt_rec.cust_account_profile_id ;
HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (
X_CUST_ACCT_PROFILE_AMT_ID => p_cust_profile_amt_rec.cust_acct_profile_amt_id,
X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,
X_TRX_CREDIT_LIMIT => p_cust_profile_amt_rec.trx_credit_limit,
X_OVERALL_CREDIT_LIMIT => p_cust_profile_amt_rec.overall_credit_limit,
X_MIN_DUNNING_AMOUNT => p_cust_profile_amt_rec.min_dunning_amount,
X_MIN_DUNNING_INVOICE_AMOUNT => p_cust_profile_amt_rec.min_dunning_invoice_amount,
X_MAX_INTEREST_CHARGE => p_cust_profile_amt_rec.max_interest_charge,
X_MIN_STATEMENT_AMOUNT => p_cust_profile_amt_rec.min_statement_amount,
X_AUTO_REC_MIN_RECEIPT_AMOUNT => p_cust_profile_amt_rec.auto_rec_min_receipt_amount,
X_INTEREST_RATE => p_cust_profile_amt_rec.interest_rate,
X_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_profile_amt_rec.attribute1,
X_ATTRIBUTE2 => p_cust_profile_amt_rec.attribute2,
X_ATTRIBUTE3 => p_cust_profile_amt_rec.attribute3,
X_ATTRIBUTE4 => p_cust_profile_amt_rec.attribute4,
X_ATTRIBUTE5 => p_cust_profile_amt_rec.attribute5,
X_ATTRIBUTE6 => p_cust_profile_amt_rec.attribute6,
X_ATTRIBUTE7 => p_cust_profile_amt_rec.attribute7,
X_ATTRIBUTE8 => p_cust_profile_amt_rec.attribute8,
X_ATTRIBUTE9 => p_cust_profile_amt_rec.attribute9,
X_ATTRIBUTE10 => p_cust_profile_amt_rec.attribute10,
X_ATTRIBUTE11 => p_cust_profile_amt_rec.attribute11,
X_ATTRIBUTE12 => p_cust_profile_amt_rec.attribute12,
X_ATTRIBUTE13 => p_cust_profile_amt_rec.attribute13,
X_ATTRIBUTE14 => p_cust_profile_amt_rec.attribute14,
X_ATTRIBUTE15 => p_cust_profile_amt_rec.attribute15,
X_MIN_FC_BALANCE_AMOUNT => p_cust_profile_amt_rec.min_fc_balance_amount,
X_MIN_FC_INVOICE_AMOUNT => p_cust_profile_amt_rec.min_fc_invoice_amount,
X_CUST_ACCOUNT_ID => p_cust_profile_amt_rec.cust_account_id,
X_SITE_USE_ID => p_cust_profile_amt_rec.site_use_id,
X_EXPIRATION_DATE => p_cust_profile_amt_rec.expiration_date,
X_JGZZ_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => p_cust_profile_amt_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => p_cust_profile_amt_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => p_cust_profile_amt_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => p_cust_profile_amt_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => p_cust_profile_amt_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => p_cust_profile_amt_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => p_cust_profile_amt_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => p_cust_profile_amt_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => p_cust_profile_amt_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => p_cust_profile_amt_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => p_cust_profile_amt_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => p_cust_profile_amt_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => p_cust_profile_amt_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => p_cust_profile_amt_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => p_cust_profile_amt_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => p_cust_profile_amt_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_profile_amt_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_profile_amt_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_profile_amt_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_profile_amt_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_profile_amt_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_profile_amt_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_profile_amt_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_profile_amt_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_profile_amt_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_profile_amt_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_profile_amt_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_profile_amt_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_profile_amt_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_profile_amt_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_profile_amt_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_profile_amt_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_profile_amt_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_profile_amt_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_profile_amt_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.global_attribute_category,
X_OBJECT_VERSION_NUMBER => 1,
X_CREATED_BY_MODULE => p_cust_profile_amt_rec.created_by_module,
X_APPLICATION_ID => p_cust_profile_amt_rec.application_id,
X_EXCHANGE_RATE_TYPE => p_cust_profile_amt_rec.exchange_rate_type,
X_MIN_FC_INVOICE_OVERDUE_TYPE => p_cust_profile_amt_rec.min_fc_invoice_overdue_type,
X_MIN_FC_INVOICE_PERCENT => p_cust_profile_amt_rec.min_fc_invoice_percent,
X_MIN_FC_BALANCE_OVERDUE_TYPE => p_cust_profile_amt_rec.min_fc_balance_overdue_type,
X_MIN_FC_BALANCE_PERCENT => p_cust_profile_amt_rec.min_fc_balance_percent,
X_INTEREST_TYPE => p_cust_profile_amt_rec.interest_type,
X_INTEREST_FIXED_AMOUNT => p_cust_profile_amt_rec.interest_fixed_amount,
X_INTEREST_SCHEDULE_ID => p_cust_profile_amt_rec.interest_schedule_id,
X_PENALTY_TYPE => p_cust_profile_amt_rec.penalty_type,
X_PENALTY_RATE => p_cust_profile_amt_rec.penalty_rate,
X_MIN_INTEREST_CHARGE => p_cust_profile_amt_rec.min_interest_charge,
X_PENALTY_FIXED_AMOUNT => p_cust_profile_amt_rec.penalty_fixed_amount,
X_PENALTY_SCHEDULE_ID => p_cust_profile_amt_rec.penalty_schedule_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Insert_Row (-) ' ||
'x_cust_acct_profile_amt_id = ' || x_cust_acct_profile_amt_id,
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
* PRIVATE PROCEDURE do_update_cust_profile_amt
*
* DESCRIPTION
* Private procedure to update customer profile amount.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_profile_amt
* HZ_CUST_PROFILE_AMTS_PKG.Update_Row
*
* ARGUMENTS
* IN/OUT:
* p_cust_profile_amt_rec Customer profile amount record.
* p_object_version_number Used for locking the being updated record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE do_update_cust_profile_amt (
p_cust_profile_amt_rec IN OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status IN OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := ''; --'do_update_cust_profile_amt';
hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
SELECT ROWID, OBJECT_VERSION_NUMBER
INTO l_rowid, l_object_version_number
FROM HZ_CUST_PROFILE_AMTS
WHERE CUST_ACCT_PROFILE_AMT_ID = p_cust_profile_amt_rec.cust_acct_profile_amt_id
FOR UPDATE NOWAIT;
p_create_update_flag => 'U',
p_check_foreign_key => NULL,
p_cust_profile_amt_rec => p_cust_profile_amt_rec,
p_rowid => l_rowid,
x_return_status => x_return_status );
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_PROFILE_AMTS_PKG.Update_Row (
X_Rowid => l_rowid,
X_CUST_ACCT_PROFILE_AMT_ID => p_cust_profile_amt_rec.cust_acct_profile_amt_id,
X_CUST_ACCOUNT_PROFILE_ID => p_cust_profile_amt_rec.cust_account_profile_id,
X_CURRENCY_CODE => p_cust_profile_amt_rec.currency_code,
X_TRX_CREDIT_LIMIT => p_cust_profile_amt_rec.trx_credit_limit,
X_OVERALL_CREDIT_LIMIT => p_cust_profile_amt_rec.overall_credit_limit,
X_MIN_DUNNING_AMOUNT => p_cust_profile_amt_rec.min_dunning_amount,
X_MIN_DUNNING_INVOICE_AMOUNT => p_cust_profile_amt_rec.min_dunning_invoice_amount,
X_MAX_INTEREST_CHARGE => p_cust_profile_amt_rec.max_interest_charge,
X_MIN_STATEMENT_AMOUNT => p_cust_profile_amt_rec.min_statement_amount,
X_AUTO_REC_MIN_RECEIPT_AMOUNT => p_cust_profile_amt_rec.auto_rec_min_receipt_amount,
X_INTEREST_RATE => p_cust_profile_amt_rec.interest_rate,
X_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.attribute_category,
X_ATTRIBUTE1 => p_cust_profile_amt_rec.attribute1,
X_ATTRIBUTE2 => p_cust_profile_amt_rec.attribute2,
X_ATTRIBUTE3 => p_cust_profile_amt_rec.attribute3,
X_ATTRIBUTE4 => p_cust_profile_amt_rec.attribute4,
X_ATTRIBUTE5 => p_cust_profile_amt_rec.attribute5,
X_ATTRIBUTE6 => p_cust_profile_amt_rec.attribute6,
X_ATTRIBUTE7 => p_cust_profile_amt_rec.attribute7,
X_ATTRIBUTE8 => p_cust_profile_amt_rec.attribute8,
X_ATTRIBUTE9 => p_cust_profile_amt_rec.attribute9,
X_ATTRIBUTE10 => p_cust_profile_amt_rec.attribute10,
X_ATTRIBUTE11 => p_cust_profile_amt_rec.attribute11,
X_ATTRIBUTE12 => p_cust_profile_amt_rec.attribute12,
X_ATTRIBUTE13 => p_cust_profile_amt_rec.attribute13,
X_ATTRIBUTE14 => p_cust_profile_amt_rec.attribute14,
X_ATTRIBUTE15 => p_cust_profile_amt_rec.attribute15,
X_MIN_FC_BALANCE_AMOUNT => p_cust_profile_amt_rec.min_fc_balance_amount,
X_MIN_FC_INVOICE_AMOUNT => p_cust_profile_amt_rec.min_fc_invoice_amount,
X_CUST_ACCOUNT_ID => p_cust_profile_amt_rec.cust_account_id,
X_SITE_USE_ID => p_cust_profile_amt_rec.site_use_id,
X_EXPIRATION_DATE => p_cust_profile_amt_rec.expiration_date,
X_JGZZ_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => p_cust_profile_amt_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => p_cust_profile_amt_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => p_cust_profile_amt_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => p_cust_profile_amt_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => p_cust_profile_amt_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => p_cust_profile_amt_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => p_cust_profile_amt_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => p_cust_profile_amt_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => p_cust_profile_amt_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => p_cust_profile_amt_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => p_cust_profile_amt_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => p_cust_profile_amt_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => p_cust_profile_amt_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => p_cust_profile_amt_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => p_cust_profile_amt_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => p_cust_profile_amt_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => p_cust_profile_amt_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => p_cust_profile_amt_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => p_cust_profile_amt_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => p_cust_profile_amt_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => p_cust_profile_amt_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => p_cust_profile_amt_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => p_cust_profile_amt_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => p_cust_profile_amt_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => p_cust_profile_amt_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => p_cust_profile_amt_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => p_cust_profile_amt_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => p_cust_profile_amt_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => p_cust_profile_amt_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => p_cust_profile_amt_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => p_cust_profile_amt_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => p_cust_profile_amt_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => p_cust_profile_amt_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => p_cust_profile_amt_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => p_cust_profile_amt_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => p_cust_profile_amt_rec.global_attribute_category,
X_OBJECT_VERSION_NUMBER => p_object_version_number,
X_CREATED_BY_MODULE => p_cust_profile_amt_rec.created_by_module,
X_APPLICATION_ID => p_cust_profile_amt_rec.application_id,
X_EXCHANGE_RATE_TYPE => p_cust_profile_amt_rec.exchange_rate_type,
X_MIN_FC_INVOICE_OVERDUE_TYPE => p_cust_profile_amt_rec.min_fc_invoice_overdue_type,
X_MIN_FC_INVOICE_PERCENT => p_cust_profile_amt_rec.min_fc_invoice_percent,
X_MIN_FC_BALANCE_OVERDUE_TYPE => p_cust_profile_amt_rec.min_fc_balance_overdue_type,
X_MIN_FC_BALANCE_PERCENT => p_cust_profile_amt_rec.min_fc_balance_percent,
X_INTEREST_TYPE => p_cust_profile_amt_rec.interest_type,
X_INTEREST_FIXED_AMOUNT => p_cust_profile_amt_rec.interest_fixed_amount,
X_INTEREST_SCHEDULE_ID => p_cust_profile_amt_rec.interest_schedule_id,
X_PENALTY_TYPE => p_cust_profile_amt_rec.penalty_type,
X_PENALTY_RATE => p_cust_profile_amt_rec.penalty_rate,
X_MIN_INTEREST_CHARGE => p_cust_profile_amt_rec.min_interest_charge,
X_PENALTY_FIXED_AMOUNT => p_cust_profile_amt_rec.penalty_fixed_amount,
X_PENALTY_SCHEDULE_ID => p_cust_profile_amt_rec.penalty_schedule_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Update_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
hz_utility_v2pub.debug(p_message=>'do_update_cust_profile_amt (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END do_update_cust_profile_amt;
* p_create_update_flag
*/
FUNCTION last_review_date_default
( p_review_cycle IN VARCHAR2 ,
p_last_review_date IN DATE ,
p_create_update_flag IN VARCHAR2)
RETURN DATE
IS
l_last_review_date DATE;
IF p_create_update_flag = 'C' THEN
l_last_review_date := SYSDATE;
ELSIF p_create_update_flag = 'U' THEN
l_last_review_date := SYSDATE;
* PROCEDURE update_customer_profile
*
* DESCRIPTION
* Updates customer profile.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_customer_profile_rec Customer profile record. One customer account
* must have a customer profile. One account site
* use can optionally have one customer profile.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE update_customer_profile (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_customer_profile_rec IN CUSTOMER_PROFILE_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_customer_profile_rec CUSTOMER_PROFILE_REC_TYPE := p_customer_profile_rec;
SAVEPOINT update_customer_profile;
hz_utility_v2pub.debug(p_message=>'update_customer_profile (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
do_update_customer_profile (
l_customer_profile_rec,
p_object_version_number,
x_return_status );
HZ_BUSINESS_EVENT_V2PVT.update_customer_profile_event (
l_customer_profile_rec , l_old_customer_profile_rec);
hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_customer_profile;
hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_customer_profile;
hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_customer_profile;
hz_utility_v2pub.debug(p_message=>'update_customer_profile (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END update_customer_profile;
* HZ_CUSTOMER_PROFILES_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_account_profile_id Customer account profile id.
* IN/OUT:
* OUT:
* x_customer_profile_rec Returned customer profile record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE get_customer_profile_rec (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_account_profile_id IN NUMBER,
x_customer_profile_rec OUT NOCOPY CUSTOMER_PROFILE_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUSTOMER_PROFILES_PKG.Select_Row (
X_CUST_ACCOUNT_PROFILE_ID => x_customer_profile_rec.cust_account_profile_id,
X_CUST_ACCOUNT_ID => x_customer_profile_rec.cust_account_id,
X_STATUS => x_customer_profile_rec.status,
X_COLLECTOR_ID => x_customer_profile_rec.collector_id,
X_CREDIT_ANALYST_ID => x_customer_profile_rec.credit_analyst_id,
X_CREDIT_CHECKING => x_customer_profile_rec.credit_checking,
X_NEXT_CREDIT_REVIEW_DATE => x_customer_profile_rec.next_credit_review_date,
X_TOLERANCE => x_customer_profile_rec.tolerance,
X_DISCOUNT_TERMS => x_customer_profile_rec.discount_terms,
X_DUNNING_LETTERS => x_customer_profile_rec.dunning_letters,
X_INTEREST_CHARGES => x_customer_profile_rec.interest_charges,
X_SEND_STATEMENTS => x_customer_profile_rec.send_statements,
X_CREDIT_BALANCE_STATEMENTS => x_customer_profile_rec.credit_balance_statements,
X_CREDIT_HOLD => x_customer_profile_rec.credit_hold,
X_PROFILE_CLASS_ID => x_customer_profile_rec.profile_class_id,
X_SITE_USE_ID => x_customer_profile_rec.site_use_id,
X_CREDIT_RATING => x_customer_profile_rec.credit_rating,
X_RISK_CODE => x_customer_profile_rec.risk_code,
X_STANDARD_TERMS => x_customer_profile_rec.standard_terms,
X_OVERRIDE_TERMS => x_customer_profile_rec.override_terms,
X_DUNNING_LETTER_SET_ID => x_customer_profile_rec.dunning_letter_set_id,
X_INTEREST_PERIOD_DAYS => x_customer_profile_rec.interest_period_days,
X_PAYMENT_GRACE_DAYS => x_customer_profile_rec.payment_grace_days,
X_DISCOUNT_GRACE_DAYS => x_customer_profile_rec.discount_grace_days,
X_STATEMENT_CYCLE_ID => x_customer_profile_rec.statement_cycle_id,
X_ACCOUNT_STATUS => x_customer_profile_rec.account_status,
X_PERCENT_COLLECTABLE => x_customer_profile_rec.percent_collectable,
X_AUTOCASH_HIERARCHY_ID => x_customer_profile_rec.autocash_hierarchy_id,
X_ATTRIBUTE_CATEGORY => x_customer_profile_rec.attribute_category,
X_ATTRIBUTE1 => x_customer_profile_rec.attribute1,
X_ATTRIBUTE2 => x_customer_profile_rec.attribute2,
X_ATTRIBUTE3 => x_customer_profile_rec.attribute3,
X_ATTRIBUTE4 => x_customer_profile_rec.attribute4,
X_ATTRIBUTE5 => x_customer_profile_rec.attribute5,
X_ATTRIBUTE6 => x_customer_profile_rec.attribute6,
X_ATTRIBUTE7 => x_customer_profile_rec.attribute7,
X_ATTRIBUTE8 => x_customer_profile_rec.attribute8,
X_ATTRIBUTE9 => x_customer_profile_rec.attribute9,
X_ATTRIBUTE10 => x_customer_profile_rec.attribute10,
X_ATTRIBUTE11 => x_customer_profile_rec.attribute11,
X_ATTRIBUTE12 => x_customer_profile_rec.attribute12,
X_ATTRIBUTE13 => x_customer_profile_rec.attribute13,
X_ATTRIBUTE14 => x_customer_profile_rec.attribute14,
X_ATTRIBUTE15 => x_customer_profile_rec.attribute15,
X_AUTO_REC_INCL_DISPUTED_FLAG => x_customer_profile_rec.auto_rec_incl_disputed_flag,
X_TAX_PRINTING_OPTION => x_customer_profile_rec.tax_printing_option,
X_CHARGE_ON_FINANCE_CHARGE_FG => x_customer_profile_rec.charge_on_finance_charge_flag,
X_GROUPING_RULE_ID => x_customer_profile_rec.grouping_rule_id,
X_CLEARING_DAYS => x_customer_profile_rec.clearing_days,
X_JGZZ_ATTRIBUTE_CATEGORY => x_customer_profile_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => x_customer_profile_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => x_customer_profile_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => x_customer_profile_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => x_customer_profile_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => x_customer_profile_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => x_customer_profile_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => x_customer_profile_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => x_customer_profile_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => x_customer_profile_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => x_customer_profile_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => x_customer_profile_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => x_customer_profile_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => x_customer_profile_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => x_customer_profile_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => x_customer_profile_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => x_customer_profile_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => x_customer_profile_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => x_customer_profile_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => x_customer_profile_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => x_customer_profile_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => x_customer_profile_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => x_customer_profile_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => x_customer_profile_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => x_customer_profile_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => x_customer_profile_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => x_customer_profile_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => x_customer_profile_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => x_customer_profile_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => x_customer_profile_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => x_customer_profile_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => x_customer_profile_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => x_customer_profile_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => x_customer_profile_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => x_customer_profile_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => x_customer_profile_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => x_customer_profile_rec.global_attribute_category,
X_CONS_INV_FLAG => x_customer_profile_rec.cons_inv_flag,
X_CONS_INV_TYPE => x_customer_profile_rec.cons_inv_type,
X_AUTOCASH_HIERARCHY_ID_ADR => x_customer_profile_rec.autocash_hierarchy_id_for_adr,
X_LOCKBOX_MATCHING_OPTION => x_customer_profile_rec.lockbox_matching_option,
X_CREATED_BY_MODULE => x_customer_profile_rec.created_by_module,
X_APPLICATION_ID => x_customer_profile_rec.application_id,
X_review_cycle => x_customer_profile_rec.review_cycle,
X_last_credit_review_date => x_customer_profile_rec.last_credit_review_date,
X_party_id => x_customer_profile_rec.party_id,
X_CREDIT_CLASSIFICATION => x_customer_profile_rec.credit_classification,
X_CONS_BILL_LEVEL => x_customer_profile_rec.cons_bill_level,
X_LATE_CHARGE_CALCULATION_TRX => x_customer_profile_rec.late_charge_calculation_trx,
X_CREDIT_ITEMS_FLAG => x_customer_profile_rec.credit_items_flag,
X_DISPUTED_TRANSACTIONS_FLAG => x_customer_profile_rec.disputed_transactions_flag,
X_LATE_CHARGE_TYPE => x_customer_profile_rec.late_charge_type,
X_LATE_CHARGE_TERM_ID => x_customer_profile_rec.late_charge_term_id,
X_INTEREST_CALCULATION_PERIOD => x_customer_profile_rec.interest_calculation_period,
X_HOLD_CHARGED_INVOICES_FLAG => x_customer_profile_rec.hold_charged_invoices_flag,
X_MESSAGE_TEXT_ID => x_customer_profile_rec.message_text_id,
X_MULTIPLE_INTEREST_RATES_FLAG => x_customer_profile_rec.multiple_interest_rates_flag,
X_CHARGE_BEGIN_DATE => x_customer_profile_rec.charge_begin_date,
X_AUTOMATCH_SET_ID => x_customer_profile_rec.automatch_set_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUSTOMER_PROFILES_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
* PROCEDURE update_cust_profile_amt
*
* DESCRIPTION
* Updates customer profile amounts.
*
* EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
* HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_profile_amt_rec Customer profile amount record.
* IN/OUT:
* p_object_version_number Used for locking the being updated record.
* OUT:
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE update_cust_profile_amt (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_profile_amt_rec IN CUST_PROFILE_AMT_REC_TYPE,
p_object_version_number IN OUT NOCOPY NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_cust_profile_amt_rec CUST_PROFILE_AMT_REC_TYPE := p_cust_profile_amt_rec;
SAVEPOINT update_cust_profile_amt;
hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
do_update_cust_profile_amt (
l_cust_profile_amt_rec,
p_object_version_number,
x_return_status );
HZ_BUSINESS_EVENT_V2PVT.update_cust_profile_amt_event (
l_cust_profile_amt_rec , l_old_cust_profile_amt_rec );
hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_profile_amt;
hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_profile_amt;
hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
ROLLBACK TO update_cust_profile_amt;
hz_utility_v2pub.debug(p_message=>'update_cust_profile_amt (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
END update_cust_profile_amt;
* HZ_CUST_PROFILE_AMTS_PKG.Select_Row
*
* ARGUMENTS
* IN:
* p_init_msg_list Initialize message stack if it is set to
* FND_API.G_TRUE. Default is FND_API.G_FALSE.
* p_cust_acct_profile_amt_id Customer account profile amount id.
* IN/OUT:
* OUT:
* x_cust_profile_amt_rec Returned customer profile amount record.
* x_return_status Return status after the call. The status can
* be FND_API.G_RET_STS_SUCCESS (success),
* FND_API.G_RET_STS_ERROR (error),
* FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
* x_msg_count Number of messages in message stack.
* x_msg_data Message text if x_msg_count is 1.
*
* NOTES
*
* MODIFICATION HISTORY
*
* 07-23-2001 Jianying Huang o Created.
*
*/
PROCEDURE get_cust_profile_amt_rec (
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_cust_acct_profile_amt_id IN NUMBER,
x_cust_profile_amt_rec OUT NOCOPY CUST_PROFILE_AMT_REC_TYPE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_debug_prefix VARCHAR2(30) := '';
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (+)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);
HZ_CUST_PROFILE_AMTS_PKG.Select_Row (
X_CUST_ACCT_PROFILE_AMT_ID => x_cust_profile_amt_rec.cust_acct_profile_amt_id,
X_CUST_ACCOUNT_PROFILE_ID => x_cust_profile_amt_rec.cust_account_profile_id,
X_CURRENCY_CODE => x_cust_profile_amt_rec.currency_code,
X_TRX_CREDIT_LIMIT => x_cust_profile_amt_rec.trx_credit_limit,
X_OVERALL_CREDIT_LIMIT => x_cust_profile_amt_rec.overall_credit_limit,
X_MIN_DUNNING_AMOUNT => x_cust_profile_amt_rec.min_dunning_amount,
X_MIN_DUNNING_INVOICE_AMOUNT => x_cust_profile_amt_rec.min_dunning_invoice_amount,
X_MAX_INTEREST_CHARGE => x_cust_profile_amt_rec.max_interest_charge,
X_MIN_STATEMENT_AMOUNT => x_cust_profile_amt_rec.min_statement_amount,
X_AUTO_REC_MIN_RECEIPT_AMOUNT => x_cust_profile_amt_rec.auto_rec_min_receipt_amount,
X_INTEREST_RATE => x_cust_profile_amt_rec.interest_rate,
X_ATTRIBUTE_CATEGORY => x_cust_profile_amt_rec.attribute_category,
X_ATTRIBUTE1 => x_cust_profile_amt_rec.attribute1,
X_ATTRIBUTE2 => x_cust_profile_amt_rec.attribute2,
X_ATTRIBUTE3 => x_cust_profile_amt_rec.attribute3,
X_ATTRIBUTE4 => x_cust_profile_amt_rec.attribute4,
X_ATTRIBUTE5 => x_cust_profile_amt_rec.attribute5,
X_ATTRIBUTE6 => x_cust_profile_amt_rec.attribute6,
X_ATTRIBUTE7 => x_cust_profile_amt_rec.attribute7,
X_ATTRIBUTE8 => x_cust_profile_amt_rec.attribute8,
X_ATTRIBUTE9 => x_cust_profile_amt_rec.attribute9,
X_ATTRIBUTE10 => x_cust_profile_amt_rec.attribute10,
X_ATTRIBUTE11 => x_cust_profile_amt_rec.attribute11,
X_ATTRIBUTE12 => x_cust_profile_amt_rec.attribute12,
X_ATTRIBUTE13 => x_cust_profile_amt_rec.attribute13,
X_ATTRIBUTE14 => x_cust_profile_amt_rec.attribute14,
X_ATTRIBUTE15 => x_cust_profile_amt_rec.attribute15,
X_MIN_FC_BALANCE_AMOUNT => x_cust_profile_amt_rec.min_fc_balance_amount,
X_MIN_FC_INVOICE_AMOUNT => x_cust_profile_amt_rec.min_fc_invoice_amount,
X_CUST_ACCOUNT_ID => x_cust_profile_amt_rec.cust_account_id,
X_SITE_USE_ID => x_cust_profile_amt_rec.site_use_id,
X_EXPIRATION_DATE => x_cust_profile_amt_rec.expiration_date,
X_JGZZ_ATTRIBUTE_CATEGORY => x_cust_profile_amt_rec.jgzz_attribute_category,
X_JGZZ_ATTRIBUTE1 => x_cust_profile_amt_rec.jgzz_attribute1,
X_JGZZ_ATTRIBUTE2 => x_cust_profile_amt_rec.jgzz_attribute2,
X_JGZZ_ATTRIBUTE3 => x_cust_profile_amt_rec.jgzz_attribute3,
X_JGZZ_ATTRIBUTE4 => x_cust_profile_amt_rec.jgzz_attribute4,
X_JGZZ_ATTRIBUTE5 => x_cust_profile_amt_rec.jgzz_attribute5,
X_JGZZ_ATTRIBUTE6 => x_cust_profile_amt_rec.jgzz_attribute6,
X_JGZZ_ATTRIBUTE7 => x_cust_profile_amt_rec.jgzz_attribute7,
X_JGZZ_ATTRIBUTE8 => x_cust_profile_amt_rec.jgzz_attribute8,
X_JGZZ_ATTRIBUTE9 => x_cust_profile_amt_rec.jgzz_attribute9,
X_JGZZ_ATTRIBUTE10 => x_cust_profile_amt_rec.jgzz_attribute10,
X_JGZZ_ATTRIBUTE11 => x_cust_profile_amt_rec.jgzz_attribute11,
X_JGZZ_ATTRIBUTE12 => x_cust_profile_amt_rec.jgzz_attribute12,
X_JGZZ_ATTRIBUTE13 => x_cust_profile_amt_rec.jgzz_attribute13,
X_JGZZ_ATTRIBUTE14 => x_cust_profile_amt_rec.jgzz_attribute14,
X_JGZZ_ATTRIBUTE15 => x_cust_profile_amt_rec.jgzz_attribute15,
X_GLOBAL_ATTRIBUTE1 => x_cust_profile_amt_rec.global_attribute1,
X_GLOBAL_ATTRIBUTE2 => x_cust_profile_amt_rec.global_attribute2,
X_GLOBAL_ATTRIBUTE3 => x_cust_profile_amt_rec.global_attribute3,
X_GLOBAL_ATTRIBUTE4 => x_cust_profile_amt_rec.global_attribute4,
X_GLOBAL_ATTRIBUTE5 => x_cust_profile_amt_rec.global_attribute5,
X_GLOBAL_ATTRIBUTE6 => x_cust_profile_amt_rec.global_attribute6,
X_GLOBAL_ATTRIBUTE7 => x_cust_profile_amt_rec.global_attribute7,
X_GLOBAL_ATTRIBUTE8 => x_cust_profile_amt_rec.global_attribute8,
X_GLOBAL_ATTRIBUTE9 => x_cust_profile_amt_rec.global_attribute9,
X_GLOBAL_ATTRIBUTE10 => x_cust_profile_amt_rec.global_attribute10,
X_GLOBAL_ATTRIBUTE11 => x_cust_profile_amt_rec.global_attribute11,
X_GLOBAL_ATTRIBUTE12 => x_cust_profile_amt_rec.global_attribute12,
X_GLOBAL_ATTRIBUTE13 => x_cust_profile_amt_rec.global_attribute13,
X_GLOBAL_ATTRIBUTE14 => x_cust_profile_amt_rec.global_attribute14,
X_GLOBAL_ATTRIBUTE15 => x_cust_profile_amt_rec.global_attribute15,
X_GLOBAL_ATTRIBUTE16 => x_cust_profile_amt_rec.global_attribute16,
X_GLOBAL_ATTRIBUTE17 => x_cust_profile_amt_rec.global_attribute17,
X_GLOBAL_ATTRIBUTE18 => x_cust_profile_amt_rec.global_attribute18,
X_GLOBAL_ATTRIBUTE19 => x_cust_profile_amt_rec.global_attribute19,
X_GLOBAL_ATTRIBUTE20 => x_cust_profile_amt_rec.global_attribute20,
X_GLOBAL_ATTRIBUTE_CATEGORY => x_cust_profile_amt_rec.global_attribute_category,
X_CREATED_BY_MODULE => x_cust_profile_amt_rec.created_by_module,
X_APPLICATION_ID => x_cust_profile_amt_rec.application_id,
X_EXCHANGE_RATE_TYPE => x_cust_profile_amt_rec.exchange_rate_type,
X_MIN_FC_INVOICE_OVERDUE_TYPE => x_cust_profile_amt_rec.min_fc_invoice_overdue_type,
X_MIN_FC_INVOICE_PERCENT => x_cust_profile_amt_rec.min_fc_invoice_percent,
X_MIN_FC_BALANCE_OVERDUE_TYPE => x_cust_profile_amt_rec.min_fc_balance_overdue_type,
X_MIN_FC_BALANCE_PERCENT => x_cust_profile_amt_rec.min_fc_balance_percent,
X_INTEREST_TYPE => x_cust_profile_amt_rec.interest_type,
X_INTEREST_FIXED_AMOUNT => x_cust_profile_amt_rec.interest_fixed_amount,
X_INTEREST_SCHEDULE_ID => x_cust_profile_amt_rec.interest_schedule_id,
X_PENALTY_TYPE => x_cust_profile_amt_rec.penalty_type,
X_PENALTY_RATE => x_cust_profile_amt_rec.penalty_rate,
X_MIN_INTEREST_CHARGE => x_cust_profile_amt_rec.min_interest_charge,
X_PENALTY_FIXED_AMOUNT => x_cust_profile_amt_rec.penalty_fixed_amount,
X_PENALTY_SCHEDULE_ID => x_cust_profile_amt_rec.penalty_schedule_id
);
hz_utility_v2pub.debug(p_message=>'HZ_CUST_PROFILE_AMTS_PKG.Select_Row (-)',
p_prefix=>l_debug_prefix,
p_msg_level=>fnd_log.level_procedure);