APPS.IGS_AV_VAL_AS dependencies on IGS_AV_ADV_STANDING

Line 15: cp_person_id IGS_AV_ADV_STANDING.person_id%TYPE,

11: gv_other_detail VARCHAR2(255);
12: BEGIN
13: DECLARE
14: CURSOR c_adv_stnd_v(
15: cp_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
16: cp_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
17: cp_version_number IGS_AV_ADV_STANDING.version_number%TYPE) IS
18: SELECT spa.course_cd
19: FROM IGS_EN_STDNT_PS_ATT spa

Line 16: cp_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,

12: BEGIN
13: DECLARE
14: CURSOR c_adv_stnd_v(
15: cp_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
16: cp_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
17: cp_version_number IGS_AV_ADV_STANDING.version_number%TYPE) IS
18: SELECT spa.course_cd
19: FROM IGS_EN_STDNT_PS_ATT spa
20: WHERE spa.person_id = cp_person_id AND

Line 17: cp_version_number IGS_AV_ADV_STANDING.version_number%TYPE) IS

13: DECLARE
14: CURSOR c_adv_stnd_v(
15: cp_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
16: cp_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
17: cp_version_number IGS_AV_ADV_STANDING.version_number%TYPE) IS
18: SELECT spa.course_cd
19: FROM IGS_EN_STDNT_PS_ATT spa
20: WHERE spa.person_id = cp_person_id AND
21: spa.course_cd = cp_course_cd AND

Line 27: -- Validate that IGS_AV_ADV_STANDING.course_cd is valid for the purposes of

23: spa.course_attempt_status IN
24: ('ENROLLED', 'INACTIVE', 'INTERMIT', 'UNCONFIRM', 'DISCONTIN','COMPLETED');
25:
26: BEGIN
27: -- Validate that IGS_AV_ADV_STANDING.course_cd is valid for the purposes of
28: -- Advanced Standing.
29: -- It must be contained within a IGS_EN_STDNT_PS_ATT by the nominated
30: -- person_id, with a status of 'enrolled', 'inactive', 'intermit' or
31: -- 'unconfirm'.

Line 64: cp_exempt_inst IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE) IS

60: gv_other_detail VARCHAR2(255);
61: BEGIN
62: DECLARE
63: CURSOR c_exempt_inst_v(
64: cp_exempt_inst IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE) IS
65: SELECT ihp.oss_org_unit_cd exemption_institution_cd
66: FROM igs_pe_hz_parties ihp
67: where ihp.inst_org_ind = 'I'
68: AND ihp.oi_govt_institution_cd IS NOT NULL

Line 77: -- Validate that IGS_AV_ADV_STANDING.exemption_institution_cd) is valid.

73: WHERE lk.lookup_type = 'OR_INST_EXEMPTIONS'
74: AND lk.enabled_flag = 'Y'
75: AND lk.lookup_code = cp_exempt_inst;
76: BEGIN
77: -- Validate that IGS_AV_ADV_STANDING.exemption_institution_cd) is valid.
78: -- The status is not considered, as it is allowable to select an inactive
79: -- IGS_OR_INSTITUTION for advanced standing basis details.
80: p_message_name := null;
81: -- Validate input parameters.