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

Line 257: p_v_load_cal_type IN igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,

253: END log_to_fnd;
254:
255: PROCEDURE check_census_dt_setup(
256: p_v_predictive_mode IN VARCHAR2,
257: p_v_load_cal_type IN igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,
258: p_n_load_ci_seq_number IN igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,
259: p_d_cns_dt_als_val OUT NOCOPY DATE,
260: p_b_return_status OUT NOCOPY BOOLEAN,
261: p_v_message_name OUT NOCOPY VARCHAR2 ) IS

Line 258: p_n_load_ci_seq_number IN igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,

254:
255: PROCEDURE check_census_dt_setup(
256: p_v_predictive_mode IN VARCHAR2,
257: p_v_load_cal_type IN igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,
258: p_n_load_ci_seq_number IN igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,
259: p_d_cns_dt_als_val OUT NOCOPY DATE,
260: p_b_return_status OUT NOCOPY BOOLEAN,
261: p_v_message_name OUT NOCOPY VARCHAR2 ) IS
262: /*----------------------------------------------------------------------------

Line 386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,

382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
386: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
387: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
388: p_s_fee_trigger_cat IN VARCHAR2 ,
389: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,
390: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,

Line 1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,

1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,
1454: p_fee_cat IN IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE ,
1455: p_s_fee_type IN igs_fi_fee_type_all.s_fee_type%TYPE ,
1456: p_s_fee_trigger_cat IN VARCHAR2 ,
1457: p_rul_sequence_number IN igs_fi_f_cat_fee_lbl_all.rul_sequence_number%TYPE ,
1458: p_charge_method IN igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE ,

Line 1548: l_fee_category IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;

1544: lv_charge_override BOOLEAN := FALSE;
1545: lv_fee_assessment IGS_FI_FEE_AS_ITEMS.amount%TYPE;
1546: v_derived_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
1547: l_overide_chg_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE;
1548: l_fee_category IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
1549:
1550: l_ch_ovr_exist BOOLEAN := FALSE;
1551:
1552: l_b_elm_ranges_defined BOOLEAN := FALSE;

Line 2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,

2371: -------------------------------------------------------------------------------
2372: PROCEDURE finpl_find_far(
2373: p_person_id hz_parties.party_id%TYPE,
2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
2379: p_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,

Line 2824: l_v_fee_category igs_fi_f_cat_ca_inst.fee_cat%TYPE;

2820: l_n_sub_rec_found NUMBER; /* Used to check whether sub ranges are defined or not*/
2821: l_n_match_elm_rng NUMBER; /* Used to check whether global element range matches*/
2822: l_n_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;
2823: l_b_rate_matched BOOLEAN; /* To check whether rate matches*/
2824: l_v_fee_category igs_fi_f_cat_ca_inst.fee_cat%TYPE;
2825: l_v_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE;
2826: l_b_elm_range_rate_match BOOLEAN := FALSE; /* To check whether global element range rate matches or not*/
2827:
2828: -- Cursor to find all Global Element ranges defined for the input parameter combination.

Line 4544: v_fee_cat igs_fi_f_cat_ca_inst.fee_cat%TYPE;

4540: *************************************************************/
4541: BEGIN
4542: DECLARE
4543: e_one_record_expected EXCEPTION;
4544: v_fee_cat igs_fi_f_cat_ca_inst.fee_cat%TYPE;
4545: v_record_found BOOLEAN := FALSE;
4546: v_message_name VARCHAR2(30);
4547:
4548: l_fee_category igs_fi_fee_cat_all.fee_cat%TYPE;

Line 4560: FROM igs_fi_f_cat_ca_inst fcci,

4556: l_v_err_msg VARCHAR2(2000);
4557:
4558: CURSOR c_fcci_fss ( cp_effective_dt DATE) IS
4559: SELECT fcci.fee_cat
4560: FROM igs_fi_f_cat_ca_inst fcci,
4561: igs_fi_fee_str_stat fss
4562: WHERE fcci.fee_cat = p_fee_category
4563: AND (
4564: -- In Predictive, Select only when Effective Date (i.e., SYSDATE) is less than FCCI Start Date Alias Value.

Line 4612: CURSOR c_daiv( cp_dt_alias igs_fi_f_cat_ca_inst.start_dt_alias%TYPE) IS

4608: WHERE course_type = p_c_career;
4609:
4610: l_c_temp VARCHAR2(1);
4611:
4612: CURSOR c_daiv( cp_dt_alias igs_fi_f_cat_ca_inst.start_dt_alias%TYPE) IS
4613: SELECT alias_val
4614: FROM igs_ca_da_inst_v
4615: WHERE dt_alias = cp_dt_alias
4616: AND cal_type = p_fee_cal_type

Line 4654: cp_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,

4650: rec_sua_for_sec c_sua_for_sec%ROWTYPE;
4651:
4652: -- Cursor to derive Key Program for a given student and for a given term.
4653: CURSOR c_key_program ( cp_n_person_id PLS_INTEGER,
4654: cp_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,
4655: cp_n_load_ci_seq_num igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,
4656: cp_v_key_prog_flag igs_en_spa_terms.key_program_flag%TYPE ) IS
4657: SELECT program_cd, program_version
4658: FROM igs_en_spa_terms

Line 4655: cp_n_load_ci_seq_num igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,

4651:
4652: -- Cursor to derive Key Program for a given student and for a given term.
4653: CURSOR c_key_program ( cp_n_person_id PLS_INTEGER,
4654: cp_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,
4655: cp_n_load_ci_seq_num igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,
4656: cp_v_key_prog_flag igs_en_spa_terms.key_program_flag%TYPE ) IS
4657: SELECT program_cd, program_version
4658: FROM igs_en_spa_terms
4659: WHERE person_id = cp_n_person_id

Line 6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,

6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
6703: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
6704: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,

Line 7766: v_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;

7762: v_next_fcfl_flag BOOLEAN;
7763: v_charge_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE;
7764: v_charge_elements igs_fi_fee_as_all.chg_elements%TYPE;
7765: v_fee_assessment NUMBER;
7766: v_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;
7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;
7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;

Line 7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;

7763: v_charge_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE;
7764: v_charge_elements igs_fi_fee_as_all.chg_elements%TYPE;
7765: v_fee_assessment NUMBER;
7766: v_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;
7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;
7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;

Line 7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;

7764: v_charge_elements igs_fi_fee_as_all.chg_elements%TYPE;
7765: v_fee_assessment NUMBER;
7766: v_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
7767: v_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE;
7768: v_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE;
7769: v_fcci_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7770: v_fcflv_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7772: v_fcci_found BOOLEAN;

Line 7793: FROM IGS_FI_F_CAT_CA_INST fcci,

7789: fcci.end_dt_alias,
7790: fcci.end_dai_sequence_number,
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

Line 7864: cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,

7860: daiv.sequence_number = cp_dai_sequence_number AND
7861: daiv.CAL_TYPE =cp_fee_cal_type AND
7862: daiv.ci_sequence_number = cp_fee_ci_sequence_number;
7863: CURSOR c_fcflv (
7864: cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
7865: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
7866: cp_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE,
7867: cp_v_s_transaction_type igs_fi_fee_as_all.s_transaction_type%TYPE ) IS
7868: SELECT fcflv.fee_cal_type,

Line 7865: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,

7861: daiv.CAL_TYPE =cp_fee_cal_type AND
7862: daiv.ci_sequence_number = cp_fee_ci_sequence_number;
7863: CURSOR c_fcflv (
7864: cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
7865: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
7866: cp_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE,
7867: cp_v_s_transaction_type igs_fi_fee_as_all.s_transaction_type%TYPE ) IS
7868: SELECT fcflv.fee_cal_type,
7869: fcflv.fee_ci_sequence_number,

Line 7866: cp_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE,

7862: daiv.ci_sequence_number = cp_fee_ci_sequence_number;
7863: CURSOR c_fcflv (
7864: cp_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
7865: cp_fee_cal_type IGS_FI_F_CAT_CA_INST.fee_cal_type%TYPE,
7866: cp_fee_ci_sequence_number IGS_FI_F_CAT_CA_INST.fee_ci_sequence_number%TYPE,
7867: cp_v_s_transaction_type igs_fi_fee_as_all.s_transaction_type%TYPE ) IS
7868: SELECT fcflv.fee_cal_type,
7869: fcflv.fee_ci_sequence_number,
7870: fcflv.FEE_TYPE,