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_FEE_ASS dependencies on IGS_FI_CONTROL_ALL

Line 62: Removed reference to res_dt_alias of table igs_fi_control_all and associated code

58: of the tables IGS_FI_FEE_AS_ALL, IGS_FI_FEE_AS_ITEMS.
59: Modified the sysdate entries as Trunc(Sysdate) and
60: p_effective_dt also modified as trunc(p_effective_dt) where ever required .
61: pathipat 18-Nov-2004 Bug 4017841 - Modified get_stdnt_res_status_cd() and finp_ins_enr_fee_ass()
62: Removed reference to res_dt_alias of table igs_fi_control_all and associated code
63: rmaddipa 05-NOV-2004 Enh 3988455, Modified get_stdnt_unit_set_dtls
64: rmaddipa 03-Nov-2004 Enh 3988455, Modified the procedure finpl_prc_predictive_scas
65: rnirwani 13-Sep-2004 changed cursor c_latest_intermit_date to not consider logically deleted records and
66: also to avoid un-approved intermission records. Bug# 3885804

Line 194: g_v_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'CAREER';

190:
191: -- This is set to TRUE if Institution Fee is to be assessed in Predictive Mode.
192: g_b_prc_inst_fee BOOLEAN;
193:
194: g_v_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'CAREER';
195: g_v_program CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PROGRAM';
196: g_v_primary_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PRIMARY_CAREER';
197: g_v_retention CONSTANT igs_fi_inv_int_all.transaction_type%TYPE := 'RETENTION';
198:

Line 195: g_v_program CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PROGRAM';

191: -- This is set to TRUE if Institution Fee is to be assessed in Predictive Mode.
192: g_b_prc_inst_fee BOOLEAN;
193:
194: g_v_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'CAREER';
195: g_v_program CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PROGRAM';
196: g_v_primary_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PRIMARY_CAREER';
197: g_v_retention CONSTANT igs_fi_inv_int_all.transaction_type%TYPE := 'RETENTION';
198:
199: g_v_chgmthd_flatrate CONSTANT igs_fi_invln_int_all.s_chg_method_type%TYPE := 'FLATRATE';

Line 196: g_v_primary_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PRIMARY_CAREER';

192: g_b_prc_inst_fee BOOLEAN;
193:
194: g_v_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'CAREER';
195: g_v_program CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PROGRAM';
196: g_v_primary_career CONSTANT igs_fi_control_all.fee_calc_mthd_code%TYPE := 'PRIMARY_CAREER';
197: g_v_retention CONSTANT igs_fi_inv_int_all.transaction_type%TYPE := 'RETENTION';
198:
199: g_v_chgmthd_flatrate CONSTANT igs_fi_invln_int_all.s_chg_method_type%TYPE := 'FLATRATE';
200:

Line 215: g_v_currency_cd igs_fi_control_all.currency_cd%TYPE := NULL;

211:
212: g_n_org_id CONSTANT igs_fi_fee_as_all.org_id%TYPE := igs_ge_gen_003.get_org_id;
213:
214: -- Global variable to hold Currency Code - assigned a value in finp_ins_enr_fee_ass, cursor c_fi_control
215: g_v_currency_cd igs_fi_control_all.currency_cd%TYPE := NULL;
216:
217: -- Global Cursor to get the Alternate Code for a Calendar Instance passed.
218: CURSOR g_c_alternate_code ( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
219: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

Line 4600: FROM igs_fi_control_all;

4596: -- cursor for getting Fee Calculation Method, Program Change Date Alias
4597: CURSOR c_fi_control IS
4598: SELECT fee_calc_mthd_code,
4599: currency_cd
4600: FROM igs_fi_control_all;
4601:
4602: l_c_fi_control c_fi_control%ROWTYPE;
4603:
4604: -- cursor for checking course type

Line 4621: l_c_control_curr igs_fi_control_all.currency_cd%TYPE;

4617: AND ci_sequence_number = p_fee_ci_sequence_num;
4618:
4619: l_c_daiv c_daiv%ROWTYPE;
4620:
4621: l_c_control_curr igs_fi_control_all.currency_cd%TYPE;
4622:
4623: CURSOR cur_fee_cat_curr(cp_fee_cat IN VARCHAR2) IS
4624: SELECT currency_cd
4625: FROM igs_fi_fee_cat_all

Line 5652: p_currency igs_fi_control_all.currency_cd%TYPE,

5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
5651: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%TYPE,
5652: p_currency igs_fi_control_all.currency_cd%TYPE,
5653: p_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE,
5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
5655: p_effective_dt DATE,
5656: p_trace_on VARCHAR2,

Line 7721: p_local_currency igs_fi_control_all.currency_cd%TYPE,

7717: p_effective_dt DATE,
7718: p_trace_on VARCHAR2,
7719: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
7720: p_fee_ci_sequence_num igs_ca_inst_all.sequence_number%TYPE,
7721: p_local_currency igs_fi_control_all.currency_cd%TYPE,
7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,
7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,

Line 9147: p_v_curr_cd IN igs_fi_control_all.currency_cd%TYPE,

9143: p_v_career IN igs_ps_ver_all.course_type%TYPE,
9144: p_v_fee_category IN igs_fi_fee_cat_all.fee_cat%TYPE,
9145: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
9146: p_n_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
9147: p_v_curr_cd IN igs_fi_control_all.currency_cd%TYPE,
9148: p_d_effective_date IN DATE,
9149: p_v_trace_on IN VARCHAR2,
9150: p_b_record_found OUT NOCOPY BOOLEAN,
9151: p_v_message_name OUT NOCOPY VARCHAR2,