APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_RES_DTLS

Line 856: CURSOR c_igs_pe_res_dtls IS

852: SELECT row_id
853: FROM igs_pe_citizenship_v
854: WHERE party_id = p_person_id;
855:
856: CURSOR c_igs_pe_res_dtls IS
857: SELECT row_id
858: FROM igs_pe_res_dtls
859: WHERE person_id = p_person_id;
860:

Line 858: FROM igs_pe_res_dtls

854: WHERE party_id = p_person_id;
855:
856: CURSOR c_igs_pe_res_dtls IS
857: SELECT row_id
858: FROM igs_pe_res_dtls
859: WHERE person_id = p_person_id;
860:
861: CURSOR c_igs_pe_teach_periods_v IS
862: SELECT rowid row_id

Line 1021: lv_rowid_pe_res igs_pe_res_dtls.row_id%TYPE;

1017: lv_rowid_pers_dis igs_pe_pers_disablty_v.row_id%TYPE;
1018: -- lv_rowid_pe_stat igs_pe_stat_v.row_id%TYPE;
1019: lv_rowid_pe_citizen_status igs_pe_eit_restatus_v.row_id%TYPE;
1020: lv_rowid_pe_ctz igs_pe_citizenship_v.row_id%TYPE;
1021: lv_rowid_pe_res igs_pe_res_dtls.row_id%TYPE;
1022: lv_rowid_pe_teach igs_pe_teach_periods_v.row_id%TYPE;
1023: lv_rowid_tst_rslt igs_ad_tst_rslt_dtls_v.row_id%TYPE;
1024: lv_rowid_acad_hist igs_ad_acad_history_v.row_id%TYPE;
1025: lv_rowid_extr_act igs_ad_extracurr_act_v.row_id%TYPE;

Line 1237: OPEN c_igs_pe_res_dtls;

1233: END IF;
1234: END IF;
1235:
1236: IF rowid_pe_res_table.count = 0 AND l_pe_results_rule_exists THEN
1237: OPEN c_igs_pe_res_dtls;
1238: FETCH c_igs_pe_res_dtls BULK COLLECT INTO rowid_pe_res_table ;
1239: IF c_igs_pe_res_dtls%ISOPEN THEN
1240: CLOSE c_igs_pe_res_dtls;
1241: END IF;

Line 1238: FETCH c_igs_pe_res_dtls BULK COLLECT INTO rowid_pe_res_table ;

1234: END IF;
1235:
1236: IF rowid_pe_res_table.count = 0 AND l_pe_results_rule_exists THEN
1237: OPEN c_igs_pe_res_dtls;
1238: FETCH c_igs_pe_res_dtls BULK COLLECT INTO rowid_pe_res_table ;
1239: IF c_igs_pe_res_dtls%ISOPEN THEN
1240: CLOSE c_igs_pe_res_dtls;
1241: END IF;
1242: END IF;

Line 1239: IF c_igs_pe_res_dtls%ISOPEN THEN

1235:
1236: IF rowid_pe_res_table.count = 0 AND l_pe_results_rule_exists THEN
1237: OPEN c_igs_pe_res_dtls;
1238: FETCH c_igs_pe_res_dtls BULK COLLECT INTO rowid_pe_res_table ;
1239: IF c_igs_pe_res_dtls%ISOPEN THEN
1240: CLOSE c_igs_pe_res_dtls;
1241: END IF;
1242: END IF;
1243:

Line 1240: CLOSE c_igs_pe_res_dtls;

1236: IF rowid_pe_res_table.count = 0 AND l_pe_results_rule_exists THEN
1237: OPEN c_igs_pe_res_dtls;
1238: FETCH c_igs_pe_res_dtls BULK COLLECT INTO rowid_pe_res_table ;
1239: IF c_igs_pe_res_dtls%ISOPEN THEN
1240: CLOSE c_igs_pe_res_dtls;
1241: END IF;
1242: END IF;
1243:
1244: IF rowid_pe_teach_table.count = 0 AND l_pe_teaching_exists THEN