APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_EN_ATD_TYPE_ALL

Line 1096: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;

1092: DECLARE
1093: cst_on CONSTANT VARCHAR2(10) := 'ON';
1094: cst_off CONSTANT VARCHAR2(10) := 'OFF';
1095: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
1096: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;
1097: v_derived_attendance_mode VARCHAR2(10); -- Used only in case of Derived Profile. Holds values On, Off, and Composite.
1098: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1099: 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.
1100: v_on_att_mode BOOLEAN := FALSE;

Line 1111: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,

1107: l_c_scafv c_scafv%ROWTYPE;
1108:
1109: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1110: -- nominated values are used
1111: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
1112: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1113: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);
1114: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1115: l_v_prg_liabale VARCHAR2(10);

Line 1948: v_derived_attendance_type igs_en_atd_type_all.attendance_type%TYPE;

1944: cst_on CONSTANT VARCHAR2(10) := 'ON';
1945: cst_off CONSTANT VARCHAR2(10) := 'OFF';
1946: cst_composite CONSTANT VARCHAR2(10) := 'COMPOSITE';
1947: v_total_period_load NUMBER;
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;

Line 1975: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,

1971: l_c_course_cd igs_ps_ver_all.course_cd%TYPE;
1972:
1973: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1974: -- nominated values are used
1975: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
1976: govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1977: prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE);
1978: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1979: