APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_OTHER_INST_V

Line 914: CURSOR c_igs_ad_other_inst_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
916: FROM igs_ad_other_inst
917: WHERE person_id = p_person_id;
918:

Line 1032: lv_rowid_oth_inst IGS_AD_OTHER_INST_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:
1036:

Line 1325: OPEN c_igs_ad_other_inst_v;

1321: END IF;
1322: END IF;
1323:
1324: IF rowid_oth_inst_table.count = 0 AND l_other_inst_rule_exists THEN
1325: OPEN c_igs_ad_other_inst_v;
1326: FETCH c_igs_ad_other_inst_v BULK COLLECT INTO rowid_oth_inst_table ;
1327: IF c_igs_ad_other_inst_v%ISOPEN THEN
1328: CLOSE c_igs_ad_other_inst_v;
1329: END IF;

Line 1326: FETCH c_igs_ad_other_inst_v BULK COLLECT INTO rowid_oth_inst_table ;

1322: END IF;
1323:
1324: IF rowid_oth_inst_table.count = 0 AND l_other_inst_rule_exists THEN
1325: OPEN c_igs_ad_other_inst_v;
1326: FETCH c_igs_ad_other_inst_v BULK COLLECT INTO rowid_oth_inst_table ;
1327: IF c_igs_ad_other_inst_v%ISOPEN THEN
1328: CLOSE c_igs_ad_other_inst_v;
1329: END IF;
1330: END IF;

Line 1327: IF c_igs_ad_other_inst_v%ISOPEN THEN

1323:
1324: IF rowid_oth_inst_table.count = 0 AND l_other_inst_rule_exists THEN
1325: OPEN c_igs_ad_other_inst_v;
1326: FETCH c_igs_ad_other_inst_v BULK COLLECT INTO rowid_oth_inst_table ;
1327: IF c_igs_ad_other_inst_v%ISOPEN THEN
1328: CLOSE c_igs_ad_other_inst_v;
1329: END IF;
1330: END IF;
1331:

Line 1328: CLOSE c_igs_ad_other_inst_v;

1324: IF rowid_oth_inst_table.count = 0 AND l_other_inst_rule_exists THEN
1325: OPEN c_igs_ad_other_inst_v;
1326: FETCH c_igs_ad_other_inst_v BULK COLLECT INTO rowid_oth_inst_table ;
1327: IF c_igs_ad_other_inst_v%ISOPEN THEN
1328: CLOSE c_igs_ad_other_inst_v;
1329: END IF;
1330: END IF;
1331:
1332: IF rowid_ath_table.count = 0 AND l_athl_prog_rule_exists THEN