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.

APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_FI_FEE_TYPE

Line 52: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE)AS

48:
49: PROCEDURE log_details(p_v_person_number IN hz_parties.party_number%TYPE,
50: p_v_fee_period IN VARCHAR2,
51: p_v_unit_section_desc IN VARCHAR2,
52: p_v_fee_type IN igs_fi_fee_type.fee_type%TYPE)AS
53: /******************************************************************
54: Created By : Priya Athipatla
55: Date Created By : 15-Oct-2003
56: Purpose : Logs details as follows-

Line 123: CURSOR cur_fee_type_desc(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS

119: Modified igs_fi_charges_api_pvt.create_charge - version 2.0 and x_waiver_amount
120: uudayapr 21-MAR-05 Bug# 4224392 Added the cursors c_org_unit_cd to retreive the
121: Org_cd and location cd and pass it to the create_charge.
122: ******************************************************************/
123: CURSOR cur_fee_type_desc(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
124: SELECT description
125: FROM igs_fi_fee_type
126: WHERE fee_type = cp_v_fee_type;
127:

Line 125: FROM igs_fi_fee_type

121: Org_cd and location cd and pass it to the create_charge.
122: ******************************************************************/
123: CURSOR cur_fee_type_desc(cp_v_fee_type igs_fi_fee_type.fee_type%TYPE) IS
124: SELECT description
125: FROM igs_fi_fee_type
126: WHERE fee_type = cp_v_fee_type;
127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,

Line 161: l_v_fee_type_desc igs_fi_fee_type.description%TYPE := NULL;

157: AND uv.version_number = uoo.version_number
158: AND asuc.unit_class = uoo.unit_class
159: AND uoo.uoo_id = cp_uoo_id;
160:
161: l_v_fee_type_desc igs_fi_fee_type.description%TYPE := NULL;
162: l_rec_chg_header igs_fi_charges_api_pvt.header_rec_type;
163: l_rec_chg_line_tbl igs_fi_charges_api_pvt.line_tbl_type;
164: l_rec_chg_line_id_tbl igs_fi_charges_api_pvt.line_id_tbl_type;
165: l_v_return_status VARCHAR2(1) := NULL;

Line 287: fee_type igs_fi_fee_type.fee_type%TYPE,

283:
284: TYPE sp_fees_rec_type IS RECORD( person_id hz_parties.party_id%TYPE,
285: course_cd igs_ps_ver.course_cd%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,

Line 390: CURSOR cur_optional_payment_ind(cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS

386: l_v_sua_status igs_en_su_attempt.unit_attempt_status%TYPE := NULL;
387: l_d_disc_dt igs_en_su_attempt.discontinued_dt%TYPE := NULL;
388:
389: -- Cursor to get optional payment Indicator for a given fee type
390: CURSOR cur_optional_payment_ind(cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
391: SELECT optional_payment_ind
392: FROM igs_fi_fee_type
393: WHERE fee_type = cp_fee_type;
394:

Line 392: FROM igs_fi_fee_type

388:
389: -- Cursor to get optional payment Indicator for a given fee type
390: CURSOR cur_optional_payment_ind(cp_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
391: SELECT optional_payment_ind
392: FROM igs_fi_fee_type
393: WHERE fee_type = cp_fee_type;
394:
395: l_v_optional_payment_ind igs_fi_fee_type_all.optional_payment_ind%TYPE;
396: l_v_unit_transferred VARCHAR2(1);

Line 395: l_v_optional_payment_ind igs_fi_fee_type_all.optional_payment_ind%TYPE;

391: SELECT optional_payment_ind
392: FROM igs_fi_fee_type
393: WHERE fee_type = cp_fee_type;
394:
395: l_v_optional_payment_ind igs_fi_fee_type_all.optional_payment_ind%TYPE;
396: l_v_unit_transferred VARCHAR2(1);
397:
398: l_v_disc_reason igs_en_su_attempt.dcnt_reason_cd%TYPE;
399: