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_CA_INST_ALL

Line 189: g_v_fee_alt_code igs_ca_inst_all.alternate_code%TYPE;

185:
186: g_inst_liable_progs_tbl inst_prog_det_tbl_typ;
187: g_n_inst_progs_cntr NUMBER;
188:
189: g_v_fee_alt_code igs_ca_inst_all.alternate_code%TYPE;
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:

Line 218: CURSOR g_c_alternate_code ( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

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
220: SELECT alternate_code
221: FROM igs_ca_inst_all
222: WHERE cal_type = cp_v_cal_type

Line 219: cp_n_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

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
220: SELECT alternate_code
221: FROM igs_ca_inst_all
222: WHERE cal_type = cp_v_cal_type
223: AND sequence_number = cp_n_seq_num;

Line 221: FROM igs_ca_inst_all

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
220: SELECT alternate_code
221: FROM igs_ca_inst_all
222: WHERE cal_type = cp_v_cal_type
223: AND sequence_number = cp_n_seq_num;
224:
225: g_v_res_profile CONSTANT VARCHAR2(100) := fnd_profile.VALUE('IGS_FI_RES_CLASS_ID');

Line 4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,

4511: FUNCTION finp_ins_enr_fee_ass(p_effective_dt IN DATE ,
4512: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
4517: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
4518: p_trace_on IN VARCHAR2 ,
4519: p_test_run IN VARCHAR2 ,

Line 4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,

4512: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
4517: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
4518: p_trace_on IN VARCHAR2 ,
4519: p_test_run IN VARCHAR2 ,
4520: p_creation_dt IN OUT NOCOPY DATE ,

Line 4722: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,

4718: FROM hz_parties p
4719: WHERE p.party_id = cp_n_person_id;
4720:
4721: CURSOR cur_spa (cp_n_person_id hz_parties.party_id%TYPE,
4722: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,

Line 4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,

4719: WHERE p.party_id = cp_n_person_id;
4720:
4721: CURSOR cur_spa (cp_n_person_id hz_parties.party_id%TYPE,
4722: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,

Line 6801: cp_load_cal_type igs_ca_inst_all.cal_type%TYPE,

6797: -- Enh# 3741400, igs_en_get_suaeh_dtl.enrp_get_suaeh_eff_st is replaced with SYSDATE
6798: CURSOR c_sua_load ( cp_person_id hz_parties.party_id%TYPE,
6799: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
6800: cp_course_version igs_ps_ver_all.version_number%TYPE,
6801: cp_load_cal_type igs_ca_inst_all.cal_type%TYPE,
6802: cp_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
6803: cp_v_fee_ass_ind VARCHAR2,
6804: cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,
6805: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE,

Line 6802: cp_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

6798: CURSOR c_sua_load ( cp_person_id hz_parties.party_id%TYPE,
6799: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
6800: cp_course_version igs_ps_ver_all.version_number%TYPE,
6801: cp_load_cal_type igs_ca_inst_all.cal_type%TYPE,
6802: cp_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
6803: cp_v_fee_ass_ind VARCHAR2,
6804: cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,
6805: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE,
6806: cp_v_enrp_get_load_apply VARCHAR2

Line 7719: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,

7715: -------------------------------------------------------------------------------
7716: FUNCTION finpl_prc_fee_cat_fee_liab (
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,

Line 7720: p_fee_ci_sequence_num igs_ca_inst_all.sequence_number%TYPE,

7716: FUNCTION finpl_prc_fee_cat_fee_liab (
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,

Line 7795: igs_ca_inst_all ci

7791: ci.start_dt,
7792: ci.end_dt
7793: FROM IGS_FI_F_CAT_CA_INST fcci,
7794: IGS_FI_FEE_STR_STAT fss,
7795: igs_ca_inst_all ci
7796: WHERE fcci.FEE_CAT = p_fee_cat AND
7797: (p_fee_cal_type IS NULL OR fcci.fee_cal_type = p_fee_cal_type) AND
7798: (p_fee_ci_sequence_num IS NULL OR
7799: fcci.fee_ci_sequence_number = p_fee_ci_sequence_num) AND

Line 9380: l_d_adm_ld_start_dt igs_ca_inst_all.start_dt%TYPE;

9376: shtatiko 09-JAN-2003 Enh# 3167098, Created this function.
9377: ***************************************************************/
9378:
9379: current_rec prd_prog_details_rec_typ;
9380: l_d_adm_ld_start_dt igs_ca_inst_all.start_dt%TYPE;
9381: l_d_fee_ld_start_dt igs_ca_inst_all.start_dt%TYPE;
9382: l_d_crs_cmpl_dt DATE;
9383: l_v_message_name fnd_new_messages.message_name%TYPE;
9384:

Line 9381: l_d_fee_ld_start_dt igs_ca_inst_all.start_dt%TYPE;

9377: ***************************************************************/
9378:
9379: current_rec prd_prog_details_rec_typ;
9380: l_d_adm_ld_start_dt igs_ca_inst_all.start_dt%TYPE;
9381: l_d_fee_ld_start_dt igs_ca_inst_all.start_dt%TYPE;
9382: l_d_crs_cmpl_dt DATE;
9383: l_v_message_name fnd_new_messages.message_name%TYPE;
9384:
9385: -- Cursor to get latest intermission end date.

Line 9421: CURSOR c_sub_adm_cal ( cp_v_adm_cal_type igs_ca_inst_all.cal_type%TYPE,

9417: AND app.admission_appl_number = apl_in.admission_appl_number;
9418: rec_adm_details c_adm_details%ROWTYPE;
9419:
9420: -- Cursor to Get the subordinate Load Calendar Instance for the derived Admission Calendar Instance
9421: CURSOR c_sub_adm_cal ( cp_v_adm_cal_type igs_ca_inst_all.cal_type%TYPE,
9422: cp_n_adm_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
9423: cp_v_admission igs_ca_type.s_cal_cat%TYPE,
9424: cp_v_load igs_ca_type.s_cal_cat%TYPE ) IS
9425: SELECT rl.sub_cal_type,

Line 9422: cp_n_adm_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,

9418: rec_adm_details c_adm_details%ROWTYPE;
9419:
9420: -- Cursor to Get the subordinate Load Calendar Instance for the derived Admission Calendar Instance
9421: CURSOR c_sub_adm_cal ( cp_v_adm_cal_type igs_ca_inst_all.cal_type%TYPE,
9422: cp_n_adm_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
9423: cp_v_admission igs_ca_type.s_cal_cat%TYPE,
9424: cp_v_load igs_ca_type.s_cal_cat%TYPE ) IS
9425: SELECT rl.sub_cal_type,
9426: rl.sub_ci_sequence_number

Line 9439: CURSOR c_get_start_dt ( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

9435: AND rl.sup_ci_sequence_number = cp_n_adm_ci_seq_num;
9436: rec_sub_adm_cal c_sub_adm_cal%ROWTYPE;
9437:
9438: -- Cursor to get Start Date of Calendar Instance given
9439: CURSOR c_get_start_dt ( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
9440: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
9441: SELECT start_dt
9442: FROM igs_ca_inst_all
9443: WHERE cal_type = cp_v_cal_type

Line 9440: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS

9436: rec_sub_adm_cal c_sub_adm_cal%ROWTYPE;
9437:
9438: -- Cursor to get Start Date of Calendar Instance given
9439: CURSOR c_get_start_dt ( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
9440: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
9441: SELECT start_dt
9442: FROM igs_ca_inst_all
9443: WHERE cal_type = cp_v_cal_type
9444: AND sequence_number = cp_n_ci_seq_num;

Line 9442: FROM igs_ca_inst_all

9438: -- Cursor to get Start Date of Calendar Instance given
9439: CURSOR c_get_start_dt ( cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
9440: cp_n_ci_seq_num igs_ca_inst_all.sequence_number%TYPE ) IS
9441: SELECT start_dt
9442: FROM igs_ca_inst_all
9443: WHERE cal_type = cp_v_cal_type
9444: AND sequence_number = cp_n_ci_seq_num;
9445:
9446: l_v_adm_alt_code igs_ca_inst_all.alternate_code%TYPE;

Line 9446: l_v_adm_alt_code igs_ca_inst_all.alternate_code%TYPE;

9442: FROM igs_ca_inst_all
9443: WHERE cal_type = cp_v_cal_type
9444: AND sequence_number = cp_n_ci_seq_num;
9445:
9446: l_v_adm_alt_code igs_ca_inst_all.alternate_code%TYPE;
9447: l_v_adm_load_alt_code igs_ca_inst_all.alternate_code%TYPE;
9448:
9449:
9450: BEGIN

Line 9447: l_v_adm_load_alt_code igs_ca_inst_all.alternate_code%TYPE;

9443: WHERE cal_type = cp_v_cal_type
9444: AND sequence_number = cp_n_ci_seq_num;
9445:
9446: l_v_adm_alt_code igs_ca_inst_all.alternate_code%TYPE;
9447: l_v_adm_load_alt_code igs_ca_inst_all.alternate_code%TYPE;
9448:
9449:
9450: BEGIN
9451: