APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_TST_RSLT_DTLS

Line 866: CURSOR c_igs_ad_tst_rslt_dtls_v IS

862: SELECT rowid row_id
863: FROM igs_pe_teach_periods
864: WHERE person_id = p_person_id;
865:
866: CURSOR c_igs_ad_tst_rslt_dtls_v IS
867: SELECT iatrdv.rowid row_id
868: FROM igs_ad_tst_rslt_dtls iatrdv
869: WHERE EXISTS (SELECT 'X'
870: FROM igs_ad_test_results iatr

Line 868: FROM igs_ad_tst_rslt_dtls iatrdv

864: WHERE person_id = p_person_id;
865:
866: CURSOR c_igs_ad_tst_rslt_dtls_v IS
867: SELECT iatrdv.rowid row_id
868: FROM igs_ad_tst_rslt_dtls iatrdv
869: WHERE EXISTS (SELECT 'X'
870: FROM igs_ad_test_results iatr
871: WHERE iatr.person_id = p_person_id
872: AND iatrdv.test_results_id = iatr.test_results_id );

Line 1023: lv_rowid_tst_rslt igs_ad_tst_rslt_dtls_v.row_id%TYPE;

1019: lv_rowid_pe_citizen_status igs_pe_eit_restatus_v.row_id%TYPE;
1020: lv_rowid_pe_ctz igs_pe_citizenship_v.row_id%TYPE;
1021: lv_rowid_pe_res igs_pe_res_dtls.row_id%TYPE;
1022: lv_rowid_pe_teach igs_pe_teach_periods_v.row_id%TYPE;
1023: lv_rowid_tst_rslt igs_ad_tst_rslt_dtls_v.row_id%TYPE;
1024: lv_rowid_acad_hist igs_ad_acad_history_v.row_id%TYPE;
1025: lv_rowid_extr_act igs_ad_extracurr_act_v.row_id%TYPE;
1026: lv_rowid_test_rslt igs_ad_test_results_v.row_id%TYPE;
1027: lv_rowid_app_int igs_ad_app_intent_v.row_id%TYPE;

Line 1253: OPEN c_igs_ad_tst_rslt_dtls_v;

1249: END IF;
1250: END IF;
1251:
1252: IF rowid_tst_rslt_dtl_table.count = 0 AND l_ad_tst_rslt_dtl_rule_exists THEN
1253: OPEN c_igs_ad_tst_rslt_dtls_v;
1254: FETCH c_igs_ad_tst_rslt_dtls_v BULK COLLECT INTO rowid_tst_rslt_dtl_table ;
1255: IF c_igs_ad_tst_rslt_dtls_v%ISOPEN THEN
1256: CLOSE c_igs_ad_tst_rslt_dtls_v;
1257: END IF;

Line 1254: FETCH c_igs_ad_tst_rslt_dtls_v BULK COLLECT INTO rowid_tst_rslt_dtl_table ;

1250: END IF;
1251:
1252: IF rowid_tst_rslt_dtl_table.count = 0 AND l_ad_tst_rslt_dtl_rule_exists THEN
1253: OPEN c_igs_ad_tst_rslt_dtls_v;
1254: FETCH c_igs_ad_tst_rslt_dtls_v BULK COLLECT INTO rowid_tst_rslt_dtl_table ;
1255: IF c_igs_ad_tst_rslt_dtls_v%ISOPEN THEN
1256: CLOSE c_igs_ad_tst_rslt_dtls_v;
1257: END IF;
1258: END IF;

Line 1255: IF c_igs_ad_tst_rslt_dtls_v%ISOPEN THEN

1251:
1252: IF rowid_tst_rslt_dtl_table.count = 0 AND l_ad_tst_rslt_dtl_rule_exists THEN
1253: OPEN c_igs_ad_tst_rslt_dtls_v;
1254: FETCH c_igs_ad_tst_rslt_dtls_v BULK COLLECT INTO rowid_tst_rslt_dtl_table ;
1255: IF c_igs_ad_tst_rslt_dtls_v%ISOPEN THEN
1256: CLOSE c_igs_ad_tst_rslt_dtls_v;
1257: END IF;
1258: END IF;
1259:

Line 1256: CLOSE c_igs_ad_tst_rslt_dtls_v;

1252: IF rowid_tst_rslt_dtl_table.count = 0 AND l_ad_tst_rslt_dtl_rule_exists THEN
1253: OPEN c_igs_ad_tst_rslt_dtls_v;
1254: FETCH c_igs_ad_tst_rslt_dtls_v BULK COLLECT INTO rowid_tst_rslt_dtl_table ;
1255: IF c_igs_ad_tst_rslt_dtls_v%ISOPEN THEN
1256: CLOSE c_igs_ad_tst_rslt_dtls_v;
1257: END IF;
1258: END IF;
1259:
1260: IF rowid_acad_hist_table.count = 0 AND l_acad_hist_rule_exists THEN