[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
|| gurprsin 26-Sep-2005 Bug 4607540, In create_credit, Credit Card Enryption enhancement, Modified the call to igs_fi_credits_pkg.insert_row method.
|| gurprsin 13-Sep-2005 Bug 3627209, After calling build accounts process, Added message on to the stack before adding it on to the fnd_message_pub.
|| pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
|| parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
|| svuppala 9-JUN-2005 Enh 4213629 - The automatic generation of the Receipt Number.
|| Added x_credit_number OUT parameter
|| bannamal 03-Jun-2005 Bug#3442712 Unit Level Fee Assessment Build. Modified the call
to igs_fi_prc_acct_pkg.build_accounts to add new paramters.
|| pathipat 22-Apr-2004 Enh 3558549 - Comm Receivables Enhancements
|| Modified TBH call to igs_fi_credits_pkg in create_credit()
|| vvutukur 14-Sep-2003 Enh#3045007.Payment Plans Build. Modified create_credit.
|| pathipat 13-Aug-2003 Enh 3076768 - Automatic Release of Holds
|| Proc create_credit(): Added call to finp_auto_release_holds()
|| vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Modified create_credit procedure.
|| schodava 11-Jun-2003 Enh# 2831587. Modified the create_credit procedure
|| shtatiko 30-APR-2003 Enh# 2831569, Modified create_credit
|| vchappid 19-May-2003 Build Bug# 2831572, Financial Accounting Enhancements
|| New Parameters - Attendance Type, Attendance Mode, Residency Status Code
|| added in procedure create_credit
----------------------------------------------------------------------------*/
PROCEDURE create_credit( p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_validation_level IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_credit_rec IN credit_rec_type,
p_attribute_record IN igs_fi_credits_api_pub.attribute_rec_type,
x_credit_id OUT NOCOPY igs_fi_credits_all.credit_id%TYPE,
x_credit_activity_id OUT NOCOPY igs_fi_cr_activities.credit_activity_id%TYPE,
x_credit_number OUT NOCOPY igs_fi_credits_all.credit_number%TYPE
) AS
/*----------------------------------------------------------------------------
|| Created By : vvutukur
|| Created On : 03-Apr-2003
|| Purpose : Private API for creating credit and deposit transactions.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| pathipat 17-May-2006 Bug 5104599 - After call to igs_fi_prc_balances.update_balances, added condition to not raise
|| exception if the messages were regd exclusion of credit types or fee types
|| svuppala 05-May-2006 Enh#3924836 Precision Issue. Done the formatting of amount in the beginning itslef
|| sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted to igs_fi_credits and
|| igs_fi_cr_activities_pkg are now rounded off to currency precision
uudayapr 8-Oct-2005 BUG 4660773 Commentted the Code LOgic introduced as part of Credit Card Enryption enhancement
|| gurprsin 26-Sep-2005 Bug 4607540, Credit Card Enryption enhancement, Modified the call to igs_fi_credits_pkg.insert_row method.
|| pmarada 26-JUL-2005 Enh 3392095, modifed as per tution waiver build, passing p_api_version
|| parameter value as 2.1 to the igs_fi_credit_pvt.create_credit call
|| svuppala 9-JUN-2005 Enh 4213629 - The automatic generation of the Receipt Number.
|| Added x_credit_number OUT parameter
|| pathipat 22-Apr-2004 Enh 3558549 - Comm Receivables Enhancements
|| Added param x_source_invoice_id in call to igs_fi_credits_pkg.insert_row()
|| Modified IF condition in validation of p_invoice_id.
|| vvutukur 14-Sep-2003 Enh#3045007.Payment Plans Build. Changes as specified in TD.
|| pathipat 13-Aug-2003 Enh 3076768 - Automatic Release of Holds
|| Added call to finp_auto_release_holds()
|| vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Added 3 new paramters lockbox_interface_id,batch_name,deposit_date
|| in the TBH call igs_fi_credits_pkg.insert_row.
|| shtatiko 30-APR-2003 Enh# 2831569, Added check for Manage Accounts
|| System Option. If its value is NULL then this will
|| error out. If its value is OTHER then it tries
|| to create a credit but doesn't update Standard
|| or Holds Balance for the person in context.
|| vchappid 19-May-2003 Build Bug# 2831572, Financial Accounting Enhancements
|| New Parameters - Attendance Type, Attendance Mode, Residency Status Code
|| added in procedure create_credit
----------------------------------------------------------------------------*/
--Cursors used in this procedure
--Cursor to derive revenue account from the credit account of source charge transaction.
CURSOR cur_override_dr(cp_invoice_id igs_fi_invln_int_all.invoice_id%TYPE) IS
SELECT rev_account_cd, rev_gl_ccid
FROM igs_fi_invln_int_all
WHERE invoice_id = cp_invoice_id;
SELECT admission_appl_number
FROM igs_ad_appl_all
WHERE person_id = cp_person_id
AND application_id = cp_application_id;
SELECT fwp.fee_cal_type, fwp.fee_ci_sequence_number, fwp.waiver_name
FROM igs_fi_waiver_pgms fwp
WHERE fwp.fee_cal_type = cp_fee_cal_type
AND fwp.fee_ci_sequence_number = cp_fee_ci_sequence_number
AND fwp.waiver_name = cp_waiver_name;
igs_fi_credits_pkg.insert_row( x_rowid => l_v_rowid,
x_credit_id => l_n_credit_id,
x_credit_number => l_v_credit_number,
x_status => p_credit_rec.p_credit_status,
x_credit_source => p_credit_rec.p_credit_source,
x_party_id => p_credit_rec.p_party_id,
x_credit_type_id => p_credit_rec.p_credit_type_id,
x_credit_instrument => p_credit_rec.p_credit_instrument,
x_description => p_credit_rec.p_description,
x_amount => l_n_amount,
x_currency_cd => l_v_currency_cd,
x_exchange_rate => 1,
x_transaction_date => TRUNC(l_d_transaction_date),
x_effective_date => TRUNC(l_d_effective_date),
x_reversal_date => NULL,
x_reversal_reason_code => NULL,
x_reversal_comments => NULL,
x_unapplied_amount => l_n_amount,
x_source_transaction_id => p_credit_rec.p_source_transaction_id,
x_merchant_id => NULL,
x_receipt_lockbox_number => p_credit_rec.p_receipt_lockbox_number,
x_credit_card_code => p_credit_rec.p_credit_card_code,
x_credit_card_holder_name => p_credit_rec.p_credit_card_holder_name,
--Bug 4607540, Credit Card Enryption enhancement
x_credit_card_number => l_v_cc_number,
x_credit_card_expiration_date => TRUNC(p_credit_rec.p_credit_card_expiration_date),
x_credit_card_approval_code => p_credit_rec.p_credit_card_approval_code,
x_awd_yr_cal_type => p_credit_rec.p_awd_yr_cal_type,
x_awd_yr_ci_sequence_number => p_credit_rec.p_awd_yr_ci_sequence_number,
x_fee_cal_type => p_credit_rec.p_fee_cal_type,
x_fee_ci_sequence_number => p_credit_rec.p_fee_ci_sequence_number,
x_attribute_category => p_attribute_record.p_attribute_category,
x_attribute1 => p_attribute_record.p_attribute1,
x_attribute2 => p_attribute_record.p_attribute2,
x_attribute3 => p_attribute_record.p_attribute3,
x_attribute4 => p_attribute_record.p_attribute4,
x_attribute5 => p_attribute_record.p_attribute5,
x_attribute6 => p_attribute_record.p_attribute6,
x_attribute7 => p_attribute_record.p_attribute7,
x_attribute8 => p_attribute_record.p_attribute8,
x_attribute9 => p_attribute_record.p_attribute9,
x_attribute10 => p_attribute_record.p_attribute10,
x_attribute11 => p_attribute_record.p_attribute11,
x_attribute12 => p_attribute_record.p_attribute12,
x_attribute13 => p_attribute_record.p_attribute13,
x_attribute14 => p_attribute_record.p_attribute14,
x_attribute15 => p_attribute_record.p_attribute15,
x_attribute16 => p_attribute_record.p_attribute16,
x_attribute17 => p_attribute_record.p_attribute17,
x_attribute18 => p_attribute_record.p_attribute18,
x_attribute19 => p_attribute_record.p_attribute19,
x_attribute20 => p_attribute_record.p_attribute20,
x_gl_date => p_credit_rec.p_gl_date,
x_check_number => p_credit_rec.p_check_number,
x_source_transaction_type => p_credit_rec.p_source_tran_type,
x_source_transaction_ref => p_credit_rec.p_source_tran_ref_number,
x_credit_card_payee_cd => p_credit_rec.p_v_credit_card_payee_cd,
x_credit_card_status_code => p_credit_rec.p_v_credit_card_status_code,
x_credit_card_tangible_cd => p_credit_rec.p_v_credit_card_tangible_cd,
x_lockbox_interface_id => p_credit_rec.p_lockbox_interface_id,
x_batch_name => p_credit_rec.p_batch_name,
x_deposit_date => p_credit_rec.p_deposit_date,
x_source_invoice_id => p_credit_rec.p_invoice_id,
x_tax_year_code => NULL,
x_waiver_name => p_credit_rec.p_waiver_name
);
igs_fi_cr_activities_pkg.insert_row(x_rowid => l_v_rowid,
x_credit_activity_id => l_n_credit_activity_id,
x_credit_id => l_n_credit_id,
x_status => p_credit_rec.p_credit_status,
x_transaction_date => TRUNC(l_d_transaction_date),
x_amount => l_n_amount,
x_dr_account_cd => l_v_dr_account_cd,
x_cr_account_cd => l_v_cr_account_cd,
x_dr_gl_ccid => l_n_dr_gl_ccid,
x_cr_gl_ccid => l_n_cr_gl_ccid,
x_bill_id => NULL,
x_bill_number => NULL,
x_bill_date => NULL,
x_posting_id => NULL,
x_gl_date => p_credit_rec.p_gl_date,
x_gl_posted_date => NULL,
x_posting_control_id => NULL
);
igs_fi_prc_balances.update_balances( p_party_id => p_credit_rec.p_party_id,
p_balance_type => l_standard,
p_balance_date => TRUNC(l_d_transaction_date),
p_amount => ((-1)*l_n_amount),
p_source => l_credit,
p_source_id => l_n_credit_id,
p_message_name => l_v_message_name
);
igs_fi_prc_balances.update_balances( p_party_id => p_credit_rec.p_party_id,
p_balance_type => l_hold,
p_balance_date => TRUNC(l_d_transaction_date),
p_amount => ((-1)*l_n_amount),
p_source => l_credit,
p_source_id => l_n_credit_id,
p_message_name => l_v_message_name
);