APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_ACAD_HONORS_V

Line 925: CURSOR c_igs_pe_acad_honors_v IS

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
926: SELECT rowid row_id
927: FROM igs_pe_acad_honors
928: WHERE person_id = p_person_id;
929:

Line 1034: lv_rowid_acad_hon igs_pe_acad_honors_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;
1038:

Line 1341: OPEN c_igs_pe_acad_honors_v;

1337: END IF;
1338: END IF;
1339:
1340: IF rowid_acad_hon_table.count = 0 AND l_pe_acad_hnrs_rule_exists THEN
1341: OPEN c_igs_pe_acad_honors_v;
1342: FETCH c_igs_pe_acad_honors_v BULK COLLECT INTO rowid_acad_hon_table ;
1343: IF c_igs_pe_acad_honors_v%ISOPEN THEN
1344: CLOSE c_igs_pe_acad_honors_v;
1345: END IF;

Line 1342: FETCH c_igs_pe_acad_honors_v BULK COLLECT INTO rowid_acad_hon_table ;

1338: END IF;
1339:
1340: IF rowid_acad_hon_table.count = 0 AND l_pe_acad_hnrs_rule_exists THEN
1341: OPEN c_igs_pe_acad_honors_v;
1342: FETCH c_igs_pe_acad_honors_v BULK COLLECT INTO rowid_acad_hon_table ;
1343: IF c_igs_pe_acad_honors_v%ISOPEN THEN
1344: CLOSE c_igs_pe_acad_honors_v;
1345: END IF;
1346: END IF;

Line 1343: IF c_igs_pe_acad_honors_v%ISOPEN THEN

1339:
1340: IF rowid_acad_hon_table.count = 0 AND l_pe_acad_hnrs_rule_exists THEN
1341: OPEN c_igs_pe_acad_honors_v;
1342: FETCH c_igs_pe_acad_honors_v BULK COLLECT INTO rowid_acad_hon_table ;
1343: IF c_igs_pe_acad_honors_v%ISOPEN THEN
1344: CLOSE c_igs_pe_acad_honors_v;
1345: END IF;
1346: END IF;
1347:

Line 1344: CLOSE c_igs_pe_acad_honors_v;

1340: IF rowid_acad_hon_table.count = 0 AND l_pe_acad_hnrs_rule_exists THEN
1341: OPEN c_igs_pe_acad_honors_v;
1342: FETCH c_igs_pe_acad_honors_v BULK COLLECT INTO rowid_acad_hon_table ;
1343: IF c_igs_pe_acad_honors_v%ISOPEN THEN
1344: CLOSE c_igs_pe_acad_honors_v;
1345: END IF;
1346: END IF;
1347:
1348: