[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
skharida 26-Jun-2006 Bug 5208136 - Removed the obsoleted columns from IGS_FI_INV_INT_PKG.update_row
agairola 28-Apr-2006 Bug: 5177774 added callout to Charges TBH
svuppala 04-AUG-2005 Enh 3392095 - Tution Waivers build
Impact of Charges API version Number change
Modified igs_fi_charges_api_pvt.create_charge - version 2.0 and x_waiver_amount
vvutukur 15-Nov-2002 Enh#2584986.Passed SYSDATE to the call to charges API for the parameter
l_chg_line_tbl(1).p_gl_date.
vvutukur 19-Sep-2002 Enh#2564643.Removed reference to subaccount_id.
********************************************************************************************** */
l_chg_rec IGS_FI_CHARGES_API_PVT.Header_Rec_Type;
CURSOR cur_chg IS SELECT s_chg_method_type FROM igs_fi_f_typ_ca_inst
WHERE fee_type =p_fee_type
AND fee_cal_type=p_fee_cal_type
AND fee_ci_sequence_number =p_fee_ci_sequence_number;
CURSOR cur_fee_desc IS SELECT description FROM igs_fi_fee_type
WHERE fee_type = p_fee_type;
SELECT inv.*
FROM igs_fi_inv_int inv
WHERE invoice_id = cp_invoice_id;
igs_fi_inv_int_pkg.update_row(x_rowid => l_rec_chg.row_id,
x_invoice_id => l_rec_chg.invoice_id,
x_person_id => l_rec_chg.person_id,
x_fee_type => l_rec_chg.fee_type,
x_fee_cat => l_rec_chg.fee_cat,
x_fee_cal_type => l_rec_chg.fee_cal_type,
x_fee_ci_sequence_number => l_rec_chg.fee_ci_sequence_number,
x_course_cd => l_rec_chg.course_cd,
x_attendance_mode => l_rec_chg.attendance_mode,
x_attendance_type => l_rec_chg.attendance_type,
x_invoice_amount_due => l_rec_chg.invoice_amount_due,
x_invoice_creation_date => l_rec_chg.invoice_creation_date,
x_invoice_desc => l_rec_chg.invoice_desc,
x_transaction_type => l_rec_chg.transaction_type,
x_currency_cd => l_rec_chg.currency_cd,
x_status => l_rec_chg.status,
x_attribute_category => l_rec_chg.attribute_category,
x_attribute1 => l_rec_chg.attribute1,
x_attribute2 => l_rec_chg.attribute2,
x_attribute3 => l_rec_chg.attribute3,
x_attribute4 => l_rec_chg.attribute4,
x_attribute5 => l_rec_chg.attribute5,
x_attribute6 => l_rec_chg.attribute6,
x_attribute7 => l_rec_chg.attribute7,
x_attribute8 => l_rec_chg.attribute8,
x_attribute9 => l_rec_chg.attribute9,
x_attribute10 => l_rec_chg.attribute10,
x_invoice_amount => l_rec_chg.invoice_amount,
x_bill_id => l_rec_chg.bill_id,
x_bill_number => l_rec_chg.bill_number,
x_bill_date => l_rec_chg.bill_date,
x_waiver_flag => p_waiver_flag,
x_waiver_reason => p_waiver_reason,
x_effective_date => l_rec_chg.effective_date,
x_invoice_number => l_rec_chg.invoice_number,
x_exchange_rate => l_rec_chg.exchange_rate,
x_bill_payment_due_date => l_rec_chg.bill_payment_due_date,
x_optional_fee_flag => l_rec_chg.optional_fee_flag,
x_reversal_gl_date => sysdate,
x_tax_year_code => l_rec_chg.tax_year_code,
x_waiver_name => l_rec_chg.waiver_name);