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_LVL_LGCY_PUB dependencies on IGS_UC_QUAL_DETS

Line 89: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,

85: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_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: /*

Line 129: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

125: p_seq_number IN igs_ca_inst.sequence_number%type,
126: p_auth_pers_id IN igs_pe_person.person_id%type,
127: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
129: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
130: p_course_version IN igs_ps_ver.version_number%type,
131: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
132: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type
133: )

Line 149: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

145: p_seq_number IN igs_ca_inst.sequence_number%type,
146: p_auth_pers_id IN igs_pe_person.person_id%type,
147: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
148: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
149: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
150: p_course_version IN igs_ps_ver.version_number%type,
151: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
152: )
153: RETURN BOOLEAN;

Line 254: l_qual_dets_id igs_uc_qual_dets.qual_dets_id%type;

250: l_sequence_number igs_ca_inst.sequence_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;

Line 890: p_qual_dets_id OUT NOCOPY igs_uc_qual_dets.qual_dets_id%type,

886: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_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: /*****************************************************************************************************************

Line 966: CURSOR c_qual_dets_id (cp_person_id igs_uc_qual_dets.person_id%TYPE,

962: IF p_lgcy_adstlvl_rec.qual_exam_level IS NOT NULL THEN
963:
964: DECLARE
965: -- cursor to get qual_dets_id
966: CURSOR c_qual_dets_id (cp_person_id igs_uc_qual_dets.person_id%TYPE,
967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,

Line 967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,

963:
964: DECLARE
965: -- cursor to get qual_dets_id
966: CURSOR c_qual_dets_id (cp_person_id igs_uc_qual_dets.person_id%TYPE,
967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,

Line 968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,

964: DECLARE
965: -- cursor to get qual_dets_id
966: CURSOR c_qual_dets_id (cp_person_id igs_uc_qual_dets.person_id%TYPE,
967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS

Line 969: cp_year igs_uc_qual_dets.year%TYPE,

965: -- cursor to get qual_dets_id
966: CURSOR c_qual_dets_id (cp_person_id igs_uc_qual_dets.person_id%TYPE,
967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
973: SELECT qual_dets_id

Line 970: cp_sitting igs_uc_qual_dets.sitting%TYPE,

966: CURSOR c_qual_dets_id (cp_person_id igs_uc_qual_dets.person_id%TYPE,
967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
973: SELECT qual_dets_id
974: FROM igs_uc_qual_dets

Line 971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,

967: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
973: SELECT qual_dets_id
974: FROM igs_uc_qual_dets
975: WHERE person_id = cp_person_id

Line 972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS

968: cp_subject_code igs_uc_qual_dets.subject_code%TYPE,
969: cp_year igs_uc_qual_dets.year%TYPE,
970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
973: SELECT qual_dets_id
974: FROM igs_uc_qual_dets
975: WHERE person_id = cp_person_id
976: AND exam_level = cp_exam_level

Line 974: FROM igs_uc_qual_dets

970: cp_sitting igs_uc_qual_dets.sitting%TYPE,
971: cp_awarding_body igs_uc_qual_dets.awarding_body%TYPE,
972: cp_approved_result igs_uc_qual_dets.approved_result%TYPE ) IS
973: SELECT qual_dets_id
974: FROM igs_uc_qual_dets
975: WHERE person_id = cp_person_id
976: AND exam_level = cp_exam_level
977: AND subject_code = cp_subject_code
978: AND year = cp_year

Line 1333: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

1329: p_seq_number IN igs_ca_inst.sequence_number%type,
1330: p_auth_pers_id IN igs_pe_person.person_id%type,
1331: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1333: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1334: p_course_version IN igs_ps_ver.version_number%type,
1335: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type,
1336: p_av_stnd_unit_lvl_id OUT NOCOPY igs_av_std_ulvlbasis_all.av_stnd_unit_lvl_id%type
1337: )

Line 1536: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,

1532: p_seq_number IN igs_ca_inst.sequence_number%type,
1533: p_auth_pers_id IN igs_pe_person.person_id%type,
1534: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1535: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1536: p_qual_dets_id IN igs_uc_qual_dets.qual_dets_id%type,
1537: p_course_version IN igs_ps_ver.version_number%type,
1538: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1539: )
1540: RETURN BOOLEAN