APPS.IGS_AV_LVL_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT

Line 90: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type

86: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
87: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
88: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
89: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,
90: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type
91: );
92:
93: /*
94: validate_adv_std_db_cons function performs all the data integrity validation

Line 255: l_as_version_number igs_en_stdnt_ps_att.version_number%type;

251: l_auth_pers_id igs_pe_person.person_id%type;
252: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%type;
253: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type;
254: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%type;
255: l_as_version_number igs_en_stdnt_ps_att.version_number%type;
256:
257: -- variable declared to fetch data from validate_lvl_db_cons
258: l_av_stnd_unit_lvl_id igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type;
259:

Line 891: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type

887: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%type,
888: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%type,
889: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
890: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,
891: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%type
892: )
893: IS
894: /*****************************************************************************************************************
895: Created By : smanglm

Line 1298: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1294: /*
1295: check the course_attempt_status
1296: */
1297: DECLARE
1298: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1299: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1300: SELECT 'x'
1301: FROM igs_en_stdnt_ps_att
1302: WHERE person_id = cp_person_id

Line 1299: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS

1295: check the course_attempt_status
1296: */
1297: DECLARE
1298: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1299: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1300: SELECT 'x'
1301: FROM igs_en_stdnt_ps_att
1302: WHERE person_id = cp_person_id
1303: AND course_cd = cp_course_cd

Line 1301: FROM igs_en_stdnt_ps_att

1297: DECLARE
1298: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1299: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1300: SELECT 'x'
1301: FROM igs_en_stdnt_ps_att
1302: WHERE person_id = cp_person_id
1303: AND course_cd = cp_course_cd
1304: AND course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT','UNCONFIRM','DISCONTIN','COMPLETED');
1305: l_exists VARCHAR2(1);

Line 1675: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

1671: /*
1672: check the course_attempt_status
1673: */
1674: DECLARE
1675: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1677: SELECT 'x'
1678: FROM igs_en_stdnt_ps_att
1679: WHERE person_id = cp_person_id

Line 1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS

1672: check the course_attempt_status
1673: */
1674: DECLARE
1675: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1677: SELECT 'x'
1678: FROM igs_en_stdnt_ps_att
1679: WHERE person_id = cp_person_id
1680: AND course_cd = cp_course_cd

Line 1678: FROM igs_en_stdnt_ps_att

1674: DECLARE
1675: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1676: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1677: SELECT 'x'
1678: FROM igs_en_stdnt_ps_att
1679: WHERE person_id = cp_person_id
1680: AND course_cd = cp_course_cd
1681: AND course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT','UNCONFIRM','DISCONTIN','COMPLETED');
1682: l_exists VARCHAR2(1);