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

Line 299: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE,

295: p_seq_number OUT NOCOPY igs_ca_inst. sequence_number%TYPE,
296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,
297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,
298: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
299: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE,
300: p_reference_code_id OUT NOCOPY igs_ge_ref_cd.reference_code_id%TYPE
301: )RETURN BOOLEAN IS
302: /*===========================================================================+
303: | FUNCTION |

Line 373: CURSOR c_credit_points ( cp_unit_cd p_lgcy_adstunt_rec.UNIT_CD%TYPE , cp_version_number igs_en_stdnt_ps_att.version_number%TYPE) IS

369: AND a.admission_test_type = cp_admission_test_type
370: AND a.test_date = cp_test_date
371: AND c.test_segment_name = cp_test_segment_name
372: AND a.person_id = cp_person_id;
373: CURSOR c_credit_points ( cp_unit_cd p_lgcy_adstunt_rec.UNIT_CD%TYPE , cp_version_number igs_en_stdnt_ps_att.version_number%TYPE) IS
374: SELECT nvl(achievable_credit_points ,enrolled_credit_points) credit_points
375: FROM igs_ps_unit_ver
376: WHERE unit_cd=cp_unit_cd and version_number = cp_version_number ;
377:

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

725: /*
726: check the course_attempt_status
727: */
728: DECLARE
729: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
730: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
731: SELECT 'x'
732: FROM igs_en_stdnt_ps_att
733: WHERE person_id = cp_person_id

Line 730: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS

726: check the course_attempt_status
727: */
728: DECLARE
729: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
730: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
731: SELECT 'x'
732: FROM igs_en_stdnt_ps_att
733: WHERE person_id = cp_person_id
734: AND course_cd = cp_course_cd

Line 732: FROM igs_en_stdnt_ps_att

728: DECLARE
729: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
730: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
731: SELECT 'x'
732: FROM igs_en_stdnt_ps_att
733: WHERE person_id = cp_person_id
734: AND course_cd = cp_course_cd
735: AND course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT','UNCONFIRM','DISCONTIN','COMPLETED');
736: l_exists VARCHAR2(1);

Line 761: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

757: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
758: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
759: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
760: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
761: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
762: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_stnd_unit_all.av_stnd_unit_id%TYPE
763: )RETURN BOOLEAN IS
764: /*===========================================================================+
765: | FUNCTION |

Line 943: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE

939: p_seq_number IN igs_ca_inst. sequence_number%TYPE,
940: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
941: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%TYPE,
942: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
943: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE
944: )RETURN BOOLEAN IS
945: /*===========================================================================+
946: | FUNCTION |
947: | validate_unit |

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

1137: /*
1138: check the course_attempt_status
1139: */
1140: DECLARE
1141: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1142: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1143: SELECT 'x'
1144: FROM igs_en_stdnt_ps_att
1145: WHERE person_id = cp_person_id

Line 1142: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS

1138: check the course_attempt_status
1139: */
1140: DECLARE
1141: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1142: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1143: SELECT 'x'
1144: FROM igs_en_stdnt_ps_att
1145: WHERE person_id = cp_person_id
1146: AND course_cd = cp_course_cd

Line 1144: FROM igs_en_stdnt_ps_att

1140: DECLARE
1141: CURSOR c_exists (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1142: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ) IS
1143: SELECT 'x'
1144: FROM igs_en_stdnt_ps_att
1145: WHERE person_id = cp_person_id
1146: AND course_cd = cp_course_cd
1147: AND course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT','UNCONFIRM','DISCONTIN','COMPLETED');
1148: l_exists VARCHAR2(1);

Line 1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;

1595: l_seq_number igs_ca_inst. sequence_number%TYPE;
1596: l_auth_pers_id igs_pe_person.person_id%TYPE;
1597: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1598: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE;
1599: l_as_version_number igs_en_stdnt_ps_att.version_number%TYPE;
1600: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
1601: L_REQUEST_ID igs_av_stnd_unit_all.request_id%TYPE ;
1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;