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_STDNT_DPSTS dependencies on IGS_EN_STDNT_PS_ATT

Line 45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';

41: g_c_transfer CONSTANT igs_lookup_values.lookup_code%TYPE := 'TRANSFER';
42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';
43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';

Line 46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';

42: g_c_forfeit CONSTANT igs_lookup_values.lookup_code%TYPE := 'FORFEIT';
43: g_c_enrdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'ENRDEPOSIT';
44: g_c_othdeposit CONSTANT igs_lookup_values.lookup_code%TYPE := 'OTHDEPOSIT';
45: g_c_sca_enrolled CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'ENROLLED';
46: g_c_sca_other CONSTANT igs_en_stdnt_ps_att.course_attempt_status%TYPE := 'OTHER';
47: g_c_appl_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'APPL';
48: g_c_all_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'ALL';
49: g_c_prg_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM';
50: g_c_prgty_dep_lvl CONSTANT igs_lookup_values.lookup_code%TYPE := 'PROGRAM_TYPE';

Line 69: TYPE stdnt_sca_status_tab IS TABLE OF igs_en_stdnt_ps_att.course_attempt_status%TYPE

65: TYPE stdnt_sca_typ_tab IS TABLE OF igs_ps_ver.course_type%TYPE
66: INDEX BY BINARY_INTEGER;
67:
68: -- Pl/SQL table for storing all Student Program Attempts Statuses
69: TYPE stdnt_sca_status_tab IS TABLE OF igs_en_stdnt_ps_att.course_attempt_status%TYPE
70: INDEX BY BINARY_INTEGER;
71:
72:
73: TYPE rec_input_param IS RECORD ( credit_class igs_fi_cr_types.credit_class%TYPE,

Line 144: p_c_sca_status igs_en_stdnt_ps_att.course_attempt_status%TYPE,

140: p_tab_course_cd stdnt_sca_tab,
141: p_tab_ver_num stdnt_sca_ver_num_tab,
142: p_tab_sca_typ stdnt_sca_typ_tab,
143: p_rec_input_param rec_input_param,
144: p_c_sca_status igs_en_stdnt_ps_att.course_attempt_status%TYPE,
145: p_c_dep_lvl VARCHAR2,
146: p_c_action OUT NOCOPY igs_lookup_values.lookup_code%TYPE,
147: p_c_sca_att_status OUT NOCOPY igs_lookup_values.lookup_code%TYPE)
148: AS

Line 170: FROM igs_en_stdnt_ps_att spa,

166: SELECT spa.course_cd course_cd,
167: spa.version_number version_number,
168: ps.course_type course_type,
169: spa.course_attempt_status course_attempt_status
170: FROM igs_en_stdnt_ps_att spa,
171: igs_ps_ver ps
172: WHERE spa.course_cd = ps.course_cd AND
173: spa.version_number = ps.version_number AND
174: spa.person_id = cp_n_person_id AND