eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_FI_SPECIAL_FEES

Line 28: of the table IGS_FI_SPECIAL_FEES.

24: svuppala 04-AUG-2005 Enh 3392095 - Tution Waivers build
25: Impact of Charges API version Number change
26: Modified igs_fi_charges_api_pvt.create_charge - version 2.0 and x_waiver_amount
27: svuppala 29-MAR-05 Bug 4240402 Timezone impact; Truncating the time part in calling place of the table handlers
28: of the table IGS_FI_SPECIAL_FEES.
29: Modified the sysdate entries as Trunc(Sysdate).
30: uudayapr 21-Mar-05 Bug#4224392 Modified call_charges_api
31: rmaddipa 20-Sep-04 Enh#3880438 Modified assess_fees_pvt
32: rmaddipa 26-July-04 Enh#3787816 Manual Reversal Build

Line 290: old_amount igs_fi_special_fees.fee_amt%TYPE,

286: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
287: fee_type igs_fi_fee_type.fee_type%TYPE,
288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
290: old_amount igs_fi_special_fees.fee_amt%TYPE,
291: new_amount igs_fi_special_fees.fee_amt%TYPE,
292: invoice_id igs_fi_inv_int.invoice_id%TYPE);
293:
294: TYPE sp_fees_tab IS TABLE OF sp_fees_rec_type INDEX BY BINARY_INTEGER;

Line 291: new_amount igs_fi_special_fees.fee_amt%TYPE,

287: fee_type igs_fi_fee_type.fee_type%TYPE,
288: fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
289: fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
290: old_amount igs_fi_special_fees.fee_amt%TYPE,
291: new_amount igs_fi_special_fees.fee_amt%TYPE,
292: invoice_id igs_fi_inv_int.invoice_id%TYPE);
293:
294: TYPE sp_fees_tab IS TABLE OF sp_fees_rec_type INDEX BY BINARY_INTEGER;
295:

Line 306: cp_v_transaction_type_cd igs_fi_special_fees.s_transaction_type_code%TYPE) IS

302: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
303: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
304: cp_v_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
305: cp_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
306: cp_v_transaction_type_cd igs_fi_special_fees.s_transaction_type_code%TYPE) IS
307: SELECT fee_type,
308: invoice_id,
309: SUM(fee_amt) fee_amt
310: FROM igs_fi_special_fees

Line 310: FROM igs_fi_special_fees

306: cp_v_transaction_type_cd igs_fi_special_fees.s_transaction_type_code%TYPE) IS
307: SELECT fee_type,
308: invoice_id,
309: SUM(fee_amt) fee_amt
310: FROM igs_fi_special_fees
311: WHERE person_id = cp_n_person_id
312: AND course_cd = cp_v_course_cd
313: AND uoo_id = cp_n_uoo_id
314: AND fee_cal_type = cp_v_fee_cal_type

Line 365: l_n_special_fee_id igs_fi_special_fees.special_fee_id%TYPE := NULL;

361: l_v_currency_desc fnd_currencies_tl.name%TYPE := NULL;
362: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
363: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
364: l_n_source_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
365: l_n_special_fee_id igs_fi_special_fees.special_fee_id%TYPE := NULL;
366: l_n_net_amount igs_fi_special_fees.fee_amt%TYPE := 0.0;
367: l_n_retention_amt igs_fi_special_fees.fee_amt%TYPE := 0.0;
368: l_v_unit_section_desc VARCHAR2(4000) := NULL;
369:

Line 366: l_n_net_amount igs_fi_special_fees.fee_amt%TYPE := 0.0;

362: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
363: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
364: l_n_source_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
365: l_n_special_fee_id igs_fi_special_fees.special_fee_id%TYPE := NULL;
366: l_n_net_amount igs_fi_special_fees.fee_amt%TYPE := 0.0;
367: l_n_retention_amt igs_fi_special_fees.fee_amt%TYPE := 0.0;
368: l_v_unit_section_desc VARCHAR2(4000) := NULL;
369:
370: -- Temporary variables

Line 367: l_n_retention_amt igs_fi_special_fees.fee_amt%TYPE := 0.0;

363: l_n_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
364: l_n_source_invoice_id igs_fi_inv_int.invoice_id%TYPE := NULL;
365: l_n_special_fee_id igs_fi_special_fees.special_fee_id%TYPE := NULL;
366: l_n_net_amount igs_fi_special_fees.fee_amt%TYPE := 0.0;
367: l_n_retention_amt igs_fi_special_fees.fee_amt%TYPE := 0.0;
368: l_v_unit_section_desc VARCHAR2(4000) := NULL;
369:
370: -- Temporary variables
371: l_n_counter PLS_INTEGER := 0;

Line 646: igs_fi_special_fees_pkg.insert_row ( x_rowid => l_rowid,

642: -- After creation of retention charge, insert a record into the Special Fees table
643: -- Modified transaction_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
644: l_n_special_fee_id := NULL;
645: l_rowid := NULL;
646: igs_fi_special_fees_pkg.insert_row ( x_rowid => l_rowid,
647: x_special_fee_id => l_n_special_fee_id,
648: x_person_id => l_sp_fees_tbl(l_n_tbl_cnt).person_id,
649: x_course_cd => l_sp_fees_tbl(l_n_tbl_cnt).course_cd,
650: x_uoo_id => l_sp_fees_tbl(l_n_tbl_cnt).uoo_id,

Line 699: igs_fi_special_fees_pkg.insert_row ( x_rowid => l_rowid,

695: -- After creation of a special charge, insert a record into the Special Fees table
696: -- Modified transaction_date entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact
697: l_n_special_fee_id := NULL;
698: l_rowid := NULL;
699: igs_fi_special_fees_pkg.insert_row ( x_rowid => l_rowid,
700: x_special_fee_id => l_n_special_fee_id,
701: x_person_id => l_sp_fees_tbl(l_n_tbl_cnt).person_id,
702: x_course_cd => l_sp_fees_tbl(l_n_tbl_cnt).course_cd,
703: x_uoo_id => l_sp_fees_tbl(l_n_tbl_cnt).uoo_id,