APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_UNIT_SETS

Line 909: CURSOR c_igs_ad_unit_sets_v IS

905: SELECT rowid row_id
906: FROM igs_ad_spl_talents
907: WHERE person_id = p_person_id;
908:
909: CURSOR c_igs_ad_unit_sets_v IS
910: SELECT rowid row_id
911: FROM igs_ad_unit_sets
912: WHERE person_id = p_person_id;
913:

Line 911: FROM igs_ad_unit_sets

907: WHERE person_id = p_person_id;
908:
909: CURSOR c_igs_ad_unit_sets_v IS
910: SELECT rowid row_id
911: FROM igs_ad_unit_sets
912: WHERE person_id = p_person_id;
913:
914: CURSOR c_igs_ad_other_inst_v IS
915: SELECT rowid row_id

Line 1031: lv_rowid_unit_set IGS_AD_UNIT_SETS_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;
1035:

Line 1317: OPEN c_igs_ad_unit_sets_v;

1313: END IF;
1314: END IF;
1315:
1316: IF rowid_unit_set_table.count = 0 AND l_unit_sets_rule_exists THEN
1317: OPEN c_igs_ad_unit_sets_v;
1318: FETCH c_igs_ad_unit_sets_v BULK COLLECT INTO rowid_unit_set_table ;
1319: IF c_igs_ad_unit_sets_v%ISOPEN THEN
1320: CLOSE c_igs_ad_unit_sets_v;
1321: END IF;

Line 1318: FETCH c_igs_ad_unit_sets_v BULK COLLECT INTO rowid_unit_set_table ;

1314: END IF;
1315:
1316: IF rowid_unit_set_table.count = 0 AND l_unit_sets_rule_exists THEN
1317: OPEN c_igs_ad_unit_sets_v;
1318: FETCH c_igs_ad_unit_sets_v BULK COLLECT INTO rowid_unit_set_table ;
1319: IF c_igs_ad_unit_sets_v%ISOPEN THEN
1320: CLOSE c_igs_ad_unit_sets_v;
1321: END IF;
1322: END IF;

Line 1319: IF c_igs_ad_unit_sets_v%ISOPEN THEN

1315:
1316: IF rowid_unit_set_table.count = 0 AND l_unit_sets_rule_exists THEN
1317: OPEN c_igs_ad_unit_sets_v;
1318: FETCH c_igs_ad_unit_sets_v BULK COLLECT INTO rowid_unit_set_table ;
1319: IF c_igs_ad_unit_sets_v%ISOPEN THEN
1320: CLOSE c_igs_ad_unit_sets_v;
1321: END IF;
1322: END IF;
1323:

Line 1320: CLOSE c_igs_ad_unit_sets_v;

1316: IF rowid_unit_set_table.count = 0 AND l_unit_sets_rule_exists THEN
1317: OPEN c_igs_ad_unit_sets_v;
1318: FETCH c_igs_ad_unit_sets_v BULK COLLECT INTO rowid_unit_set_table ;
1319: IF c_igs_ad_unit_sets_v%ISOPEN THEN
1320: CLOSE c_igs_ad_unit_sets_v;
1321: END IF;
1322: END IF;
1323:
1324: IF rowid_oth_inst_table.count = 0 AND l_other_inst_rule_exists THEN