APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_SPL_TALENTS_V

Line 904: CURSOR c_igs_ad_spl_talents_v IS

900: SELECT rowid row_id
901: FROM igs_ad_spl_interests
902: WHERE person_id = p_person_id;
903:
904: CURSOR c_igs_ad_spl_talents_v IS
905: SELECT rowid row_id
906: FROM igs_ad_spl_talents
907: WHERE person_id = p_person_id;
908:

Line 1030: lv_rowid_spl_tal IGS_AD_SPL_TALENTS_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;
1031: lv_rowid_unit_set IGS_AD_UNIT_SETS_V.row_id%TYPE;
1032: lv_rowid_oth_inst IGS_AD_OTHER_INST_V.row_id%TYPE;
1033: lv_rowid_ath IGS_PE_ATHLETIC_PRG_V.row_id%TYPE; -- bug 2794983
1034: lv_rowid_acad_hon igs_pe_acad_honors_v.row_id%TYPE;

Line 1309: OPEN c_igs_ad_spl_talents_v;

1305: END IF;
1306: END IF;
1307:
1308: IF rowid_spl_tal_table.count = 0 AND l_spl_talent_rule_exists THEN
1309: OPEN c_igs_ad_spl_talents_v;
1310: FETCH c_igs_ad_spl_talents_v BULK COLLECT INTO rowid_spl_tal_table ;
1311: IF c_igs_ad_spl_talents_v%ISOPEN THEN
1312: CLOSE c_igs_ad_spl_talents_v;
1313: END IF;

Line 1310: FETCH c_igs_ad_spl_talents_v BULK COLLECT INTO rowid_spl_tal_table ;

1306: END IF;
1307:
1308: IF rowid_spl_tal_table.count = 0 AND l_spl_talent_rule_exists THEN
1309: OPEN c_igs_ad_spl_talents_v;
1310: FETCH c_igs_ad_spl_talents_v BULK COLLECT INTO rowid_spl_tal_table ;
1311: IF c_igs_ad_spl_talents_v%ISOPEN THEN
1312: CLOSE c_igs_ad_spl_talents_v;
1313: END IF;
1314: END IF;

Line 1311: IF c_igs_ad_spl_talents_v%ISOPEN THEN

1307:
1308: IF rowid_spl_tal_table.count = 0 AND l_spl_talent_rule_exists THEN
1309: OPEN c_igs_ad_spl_talents_v;
1310: FETCH c_igs_ad_spl_talents_v BULK COLLECT INTO rowid_spl_tal_table ;
1311: IF c_igs_ad_spl_talents_v%ISOPEN THEN
1312: CLOSE c_igs_ad_spl_talents_v;
1313: END IF;
1314: END IF;
1315:

Line 1312: CLOSE c_igs_ad_spl_talents_v;

1308: IF rowid_spl_tal_table.count = 0 AND l_spl_talent_rule_exists THEN
1309: OPEN c_igs_ad_spl_talents_v;
1310: FETCH c_igs_ad_spl_talents_v BULK COLLECT INTO rowid_spl_tal_table ;
1311: IF c_igs_ad_spl_talents_v%ISOPEN THEN
1312: CLOSE c_igs_ad_spl_talents_v;
1313: END IF;
1314: END IF;
1315:
1316: IF rowid_unit_set_table.count = 0 AND l_unit_sets_rule_exists THEN