APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_TEST_RESULTS

Line 870: FROM igs_ad_test_results iatr

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 );
873:
874: CURSOR c_igs_ad_acad_history_v IS

Line 884: CURSOR c_igs_ad_test_results_v IS

880: SELECT rowid
881: FROM HZ_PERSON_INTEREST PI
882: WHERE party_ID = p_person_id;
883:
884: CURSOR c_igs_ad_test_results_v IS
885: SELECT rowid row_id
886: FROM igs_ad_test_results
887: WHERE person_id = p_person_id;
888:

Line 886: FROM igs_ad_test_results

882: WHERE party_ID = p_person_id;
883:
884: CURSOR c_igs_ad_test_results_v IS
885: SELECT rowid row_id
886: FROM igs_ad_test_results
887: WHERE person_id = p_person_id;
888:
889: CURSOR c_igs_ad_app_intent_v IS
890: SELECT rowid row_id

Line 1026: lv_rowid_test_rslt igs_ad_test_results_v.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;
1028: lv_rowid_acad_int igs_ad_acad_interest_v.row_id%TYPE;
1029: lv_rowid_spl_int igs_ad_spl_interests_v.row_id%TYPE;
1030: lv_rowid_spl_tal IGS_AD_SPL_TALENTS_V.row_id%TYPE;

Line 1277: OPEN c_igs_ad_test_results_v;

1273: END IF;
1274: END IF;
1275:
1276: IF rowid_test_rslt_table.count = 0 AND l_ad_test_rslt_rule_exists THEN
1277: OPEN c_igs_ad_test_results_v;
1278: FETCH c_igs_ad_test_results_v BULK COLLECT INTO rowid_test_rslt_table ;
1279: IF c_igs_ad_test_results_v%ISOPEN THEN
1280: CLOSE c_igs_ad_test_results_v;
1281: END IF;

Line 1278: FETCH c_igs_ad_test_results_v BULK COLLECT INTO rowid_test_rslt_table ;

1274: END IF;
1275:
1276: IF rowid_test_rslt_table.count = 0 AND l_ad_test_rslt_rule_exists THEN
1277: OPEN c_igs_ad_test_results_v;
1278: FETCH c_igs_ad_test_results_v BULK COLLECT INTO rowid_test_rslt_table ;
1279: IF c_igs_ad_test_results_v%ISOPEN THEN
1280: CLOSE c_igs_ad_test_results_v;
1281: END IF;
1282: END IF;

Line 1279: IF c_igs_ad_test_results_v%ISOPEN THEN

1275:
1276: IF rowid_test_rslt_table.count = 0 AND l_ad_test_rslt_rule_exists THEN
1277: OPEN c_igs_ad_test_results_v;
1278: FETCH c_igs_ad_test_results_v BULK COLLECT INTO rowid_test_rslt_table ;
1279: IF c_igs_ad_test_results_v%ISOPEN THEN
1280: CLOSE c_igs_ad_test_results_v;
1281: END IF;
1282: END IF;
1283:

Line 1280: CLOSE c_igs_ad_test_results_v;

1276: IF rowid_test_rslt_table.count = 0 AND l_ad_test_rslt_rule_exists THEN
1277: OPEN c_igs_ad_test_results_v;
1278: FETCH c_igs_ad_test_results_v BULK COLLECT INTO rowid_test_rslt_table ;
1279: IF c_igs_ad_test_results_v%ISOPEN THEN
1280: CLOSE c_igs_ad_test_results_v;
1281: END IF;
1282: END IF;
1283:
1284: IF rowid_app_int_table.count = 0 AND l_app_intent_rule_exists THEN