APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_PS_VER_ALL

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 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 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