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_AD_TST_RSLT_DTLS

Line 88: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

84: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%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:

Line 128: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

124: p_cal_type IN igs_ca_inst.cal_type%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

Line 148: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

144: p_cal_type IN igs_ca_inst.cal_type%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: )

Line 164: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

160: (
161: p_person_id IN igs_pe_person.person_id%type,
162: p_course_version IN igs_ps_ver.version_number%type,
163: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
164: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
165: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
166: )
167: RETURN BOOLEAN;
168:

Line 253: l_tst_rslt_dtls_id igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type;

249: l_cal_type igs_ca_inst.cal_type%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

Line 889: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

885: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%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

Line 1065: igs_ad_tst_rslt_dtls b,

1061: cp_person_id igs_ad_test_results.person_id%TYPE
1062: ) IS
1063: SELECT b.tst_rslt_dtls_id
1064: FROM igs_ad_test_results a,
1065: igs_ad_tst_rslt_dtls b,
1066: igs_ad_test_segments c
1067: WHERE a.test_results_id = b.test_results_id
1068: AND b.test_segment_id = c.test_segment_id
1069: AND c.admission_test_type = cp_admission_test_type

Line 1332: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

1328: p_cal_type IN igs_ca_inst.cal_type%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

Line 1535: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

1531: p_cal_type IN igs_ca_inst.cal_type%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: )

Line 1704: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,

1700: (
1701: p_person_id IN igs_pe_person.person_id%type,
1702: p_course_version IN igs_ps_ver.version_number%type,
1703: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%type,
1704: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1705: p_lgcy_adstlvl_rec IN lgcy_adstlvl_rec_type
1706: )
1707: RETURN BOOLEAN
1708: /*************************************************************