APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_ATHLETIC_PRG

Line 919: CURSOR c_igs_pe_athletic_prg_v IS -- bug 2794983

915: SELECT rowid row_id
916: FROM igs_ad_other_inst
917: WHERE person_id = p_person_id;
918:
919: CURSOR c_igs_pe_athletic_prg_v IS -- bug 2794983
920: SELECT rowid row_id
921: FROM igs_pe_athletic_prg
922: WHERE person_id = p_person_id;
923:

Line 921: FROM igs_pe_athletic_prg

917: WHERE person_id = p_person_id;
918:
919: CURSOR c_igs_pe_athletic_prg_v IS -- bug 2794983
920: SELECT rowid row_id
921: FROM igs_pe_athletic_prg
922: WHERE person_id = p_person_id;
923:
924: --ssawhney SWS104, ad_acad changed to pe_acad
925: CURSOR c_igs_pe_acad_honors_v IS

Line 1033: lv_rowid_ath IGS_PE_ATHLETIC_PRG_V.row_id%TYPE; -- bug 2794983

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:
1037: TYPE rowid_type IS TABLE OF igs_pe_person_addr.row_id%TYPE INDEX BY BINARY_INTEGER;

Line 1333: OPEN c_igs_pe_athletic_prg_v;

1329: END IF;
1330: END IF;
1331:
1332: IF rowid_ath_table.count = 0 AND l_athl_prog_rule_exists THEN
1333: OPEN c_igs_pe_athletic_prg_v;
1334: FETCH c_igs_pe_athletic_prg_v BULK COLLECT INTO rowid_ath_table ;
1335: IF c_igs_pe_athletic_prg_v%ISOPEN THEN
1336: CLOSE c_igs_pe_athletic_prg_v;
1337: END IF;

Line 1334: FETCH c_igs_pe_athletic_prg_v BULK COLLECT INTO rowid_ath_table ;

1330: END IF;
1331:
1332: IF rowid_ath_table.count = 0 AND l_athl_prog_rule_exists THEN
1333: OPEN c_igs_pe_athletic_prg_v;
1334: FETCH c_igs_pe_athletic_prg_v BULK COLLECT INTO rowid_ath_table ;
1335: IF c_igs_pe_athletic_prg_v%ISOPEN THEN
1336: CLOSE c_igs_pe_athletic_prg_v;
1337: END IF;
1338: END IF;

Line 1335: IF c_igs_pe_athletic_prg_v%ISOPEN THEN

1331:
1332: IF rowid_ath_table.count = 0 AND l_athl_prog_rule_exists THEN
1333: OPEN c_igs_pe_athletic_prg_v;
1334: FETCH c_igs_pe_athletic_prg_v BULK COLLECT INTO rowid_ath_table ;
1335: IF c_igs_pe_athletic_prg_v%ISOPEN THEN
1336: CLOSE c_igs_pe_athletic_prg_v;
1337: END IF;
1338: END IF;
1339:

Line 1336: CLOSE c_igs_pe_athletic_prg_v;

1332: IF rowid_ath_table.count = 0 AND l_athl_prog_rule_exists THEN
1333: OPEN c_igs_pe_athletic_prg_v;
1334: FETCH c_igs_pe_athletic_prg_v BULK COLLECT INTO rowid_ath_table ;
1335: IF c_igs_pe_athletic_prg_v%ISOPEN THEN
1336: CLOSE c_igs_pe_athletic_prg_v;
1337: END IF;
1338: END IF;
1339:
1340: IF rowid_acad_hon_table.count = 0 AND l_pe_acad_hnrs_rule_exists THEN