[Home] [Help]
205: g_v_fcfl_source VARCHAR2(10) := NULL;
206: g_v_wav_calc_flag VARCHAR2(1) := NULL;
207:
208: -- Profile for determining whether Nominated or Derived values are used
209: g_v_att_profile CONSTANT fnd_lookup_values.lookup_code%TYPE := FND_PROFILE.VALUE('IGS_FI_NOM_DER_VALUES');
210: g_v_auto_calc_wav_prof CONSTANT VARCHAR2(30) := fnd_profile.VALUE('IGS_FI_AUTO_CALC_WAIVERS');
211:
212: g_n_org_id CONSTANT igs_fi_fee_as_all.org_id%TYPE := igs_ge_gen_003.get_org_id;
213:
1948: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;
1949: v_derived_attendance_mode VARCHAR2(10); -- Used only in case of Derived Profile. Holds values On, Off, and Composite.
1950: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1951: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.
1952: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
1953: v_count NUMBER(5);
1954: v_on_att_mode BOOLEAN := FALSE;
1955: v_off_att_mode BOOLEAN := FALSE;
1956: v_composite_att_mode BOOLEAN := FALSE;
6734: v_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
6735: v_eftsu igs_fi_fee_as_all.chg_elements%TYPE;
6736: v_credit_points igs_fi_fee_as_all.chg_elements%TYPE;
6737: v_ret_true_flag BOOLEAN;
6738: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
6739: v_message_name VARCHAR2(30);
6740: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6741: v_derived_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE;
6742: l_eftsu NUMBER;
7771: v_fcflv_end_dt IGS_CA_DA_INST_V.alias_val%TYPE;
7772: v_fcci_found BOOLEAN;
7773: v_fcfl_found BOOLEAN;
7774: v_message_name VARCHAR2(30);
7775: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
7776: l_n_rec_count NUMBER;
7777: l_v_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
7778: l_v_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE;
7779: