APPS.IGS_ST_GEN_001 dependencies on IGS_AS_UNIT_MODE

Line 25: cst_on CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'ON';

21: gv_other_details VARCHAR2(255);
22: gv_exception_msg VARCHAR2(100);
23: BEGIN
24: DECLARE
25: cst_on CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'ON';
26: cst_off CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'OFF';
27: cst_composite CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'COMPOSITE';
28: v_unit_mode_count NUMBER;
29: v_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;

Line 26: cst_off CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'OFF';

22: gv_exception_msg VARCHAR2(100);
23: BEGIN
24: DECLARE
25: cst_on CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'ON';
26: cst_off CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'OFF';
27: cst_composite CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'COMPOSITE';
28: v_unit_mode_count NUMBER;
29: v_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
30: v_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;

Line 27: cst_composite CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'COMPOSITE';

23: BEGIN
24: DECLARE
25: cst_on CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'ON';
26: cst_off CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'OFF';
27: cst_composite CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'COMPOSITE';
28: v_unit_mode_count NUMBER;
29: v_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
30: v_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
31: CURSOR c_count_unit_mode IS

Line 29: v_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;

25: cst_on CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'ON';
26: cst_off CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'OFF';
27: cst_composite CONSTANT IGS_AS_UNIT_MODE.s_unit_mode%TYPE := 'COMPOSITE';
28: v_unit_mode_count NUMBER;
29: v_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
30: v_attend_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
31: CURSOR c_count_unit_mode IS
32: SELECT COUNT(UNIQUE um.s_unit_mode)
33: FROM IGS_ST_GVT_STDNTLOAD gslo,

Line 36: IGS_AS_UNIT_MODE um,

32: SELECT COUNT(UNIQUE um.s_unit_mode)
33: FROM IGS_ST_GVT_STDNTLOAD gslo,
34: IGS_EN_ST_SNAPSHOT ess,
35: IGS_AS_UNIT_CLASS ucl,
36: IGS_AS_UNIT_MODE um,
37: IGS_ST_GVT_SPSHT_CTL gsc
38: WHERE gslo.submission_yr = p_submission_yr AND
39: gslo.submission_number = p_submission_number AND
40: gslo.person_id = p_person_id AND

Line 64: IGS_AS_UNIT_MODE um,

60: SELECT UNIQUE um.s_unit_mode
61: FROM IGS_ST_GVT_STDNTLOAD gslo,
62: IGS_EN_ST_SNAPSHOT ess,
63: IGS_AS_UNIT_CLASS ucl,
64: IGS_AS_UNIT_MODE um,
65: IGS_ST_GVT_SPSHT_CTL gsc
66: WHERE gslo.submission_yr = p_submission_yr AND
67: gslo.submission_number = p_submission_number AND
68: gslo.person_id = p_person_id AND