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.IGF_AP_OSS_INTR_DTLS dependencies on IGS_PS_VER

Line 26: CURSOR resp_org_unit_cur(p_course_cd igs_ps_ver_all.course_cd%TYPE,

22: IS
23:
24: -- Cursor to get Responsible Org Unit code
25: --
26: CURSOR resp_org_unit_cur(p_course_cd igs_ps_ver_all.course_cd%TYPE,
27: p_ver_num igs_ps_ver_all.version_number%TYPE)
28: IS
29: SELECT responsible_org_unit_cd org_unit_code
30: FROM igs_ps_ver pver

Line 27: p_ver_num igs_ps_ver_all.version_number%TYPE)

23:
24: -- Cursor to get Responsible Org Unit code
25: --
26: CURSOR resp_org_unit_cur(p_course_cd igs_ps_ver_all.course_cd%TYPE,
27: p_ver_num igs_ps_ver_all.version_number%TYPE)
28: IS
29: SELECT responsible_org_unit_cd org_unit_code
30: FROM igs_ps_ver pver
31: WHERE pver.course_cd = p_course_cd

Line 30: FROM igs_ps_ver pver

26: CURSOR resp_org_unit_cur(p_course_cd igs_ps_ver_all.course_cd%TYPE,
27: p_ver_num igs_ps_ver_all.version_number%TYPE)
28: IS
29: SELECT responsible_org_unit_cd org_unit_code
30: FROM igs_ps_ver pver
31: WHERE pver.course_cd = p_course_cd
32: AND pver.version_number = p_ver_num;
33:
34: org_unit_rec resp_org_unit_cur%ROWTYPE;

Line 35: lv_adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;

31: WHERE pver.course_cd = p_course_cd
32: AND pver.version_number = p_ver_num;
33:
34: org_unit_rec resp_org_unit_cur%ROWTYPE;
35: lv_adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
36: lv_enrl_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
37: --
38: -- Cursor to get "Ability to Benefit" test check
39: -- Below query will return a record, if the Student has taken this test.

Line 36: lv_enrl_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;

32: AND pver.version_number = p_ver_num;
33:
34: org_unit_rec resp_org_unit_cur%ROWTYPE;
35: lv_adm_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
36: lv_enrl_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
37: --
38: -- Cursor to get "Ability to Benefit" test check
39: -- Below query will return a record, if the Student has taken this test.
40: --

Line 73: lv_req_cp igs_ps_ver_all.credit_points_required%TYPE;

69: -- ]
70:
71: -- These variables are needed to get enrol_credit_pt details
72: -- [
73: lv_req_cp igs_ps_ver_all.credit_points_required%TYPE;
74: lv_passed_cp NUMBER(15,2);
75: -- this is enrl_total_cp
76: lv_adv_stnd_cp NUMBER(15,2);
77: -- this is enrl_cuml_trans_cp

Line 134: CURSOR get_adm_cnt(cp_course_cd igs_ps_ver.course_cd%TYPE) IS

130: WHERE person_id = p_person_id;
131:
132: --Added the cursor to resolve bug 2296776
133:
134: CURSOR get_adm_cnt(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
135: SELECT COUNT(*) cnt FROM igs_ad_ps_appl_inst
136: WHERE person_id=p_person_id AND
137: course_cd = cp_course_cd;
138:

Line 142: CURSOR get_adm_dtls(cp_course_cd igs_ps_ver.course_cd%TYPE) IS

138:
139: l_adm_cnt_rec get_adm_cnt%ROWTYPE;
140:
141:
142: CURSOR get_adm_dtls(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
143: SELECT adm.course_type adm_course_type,adps.course_cd adm_course_cd,
144: adps.admission_appl_number adm_appl_number
145: FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,
146: igs_ps_ver adm,igs_ps_ver enrl

Line 146: igs_ps_ver adm,igs_ps_ver enrl

142: CURSOR get_adm_dtls(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
143: SELECT adm.course_type adm_course_type,adps.course_cd adm_course_cd,
144: adps.admission_appl_number adm_appl_number
145: FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,
146: igs_ps_ver adm,igs_ps_ver enrl
147: WHERE adps.person_id=p_person_id AND adps.person_id= enps.person_id
148: AND enps.course_cd=cp_course_cd AND enps.course_cd=enrl.course_cd
149: AND adps.course_cd = adm.course_cd AND adm.course_type=enrl.course_type;
150:

Line 212: CURSOR en_std_cur (p_course_cd igs_ps_ver_all.course_type%TYPE,

208:
209: --
210: -- Cursor to get enrlloment details
211: --
212: CURSOR en_std_cur (p_course_cd igs_ps_ver_all.course_type%TYPE,
213: p_version_number igs_ps_ver_all.version_number%TYPE)
214: IS
215: SELECT
216: course_type enrl_program_type

Line 213: p_version_number igs_ps_ver_all.version_number%TYPE)

209: --
210: -- Cursor to get enrlloment details
211: --
212: CURSOR en_std_cur (p_course_cd igs_ps_ver_all.course_type%TYPE,
213: p_version_number igs_ps_ver_all.version_number%TYPE)
214: IS
215: SELECT
216: course_type enrl_program_type
217: FROM igs_ps_ver

Line 217: FROM igs_ps_ver

213: p_version_number igs_ps_ver_all.version_number%TYPE)
214: IS
215: SELECT
216: course_type enrl_program_type
217: FROM igs_ps_ver
218: WHERE
219: course_cd = p_course_cd
220: AND
221: version_number = p_version_number;

Line 295: cp_course_cd igs_ps_ver.course_cd%TYPE) IS

291:
292: --Added the cursor to resolve bug 2296776
293:
294: CURSOR get_uset_dtls(cp_person_id igf_ap_fa_base_rec.person_id%TYPE,
295: cp_course_cd igs_ps_ver.course_cd%TYPE) IS
296: SELECT susa.unit_set_cd,susa.course_cd,susa.us_version_number
297: FROM igs_as_su_setatmpt susa,
298: igs_en_unit_set us ,
299: igs_en_unit_set_cat usc,