APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_TEACH_PERIODS_V

Line 861: CURSOR c_igs_pe_teach_periods_v 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
863: FROM igs_pe_teach_periods
864: WHERE person_id = p_person_id;
865:

Line 1022: lv_rowid_pe_teach igs_pe_teach_periods_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;
1026: lv_rowid_test_rslt igs_ad_test_results_v.row_id%TYPE;

Line 1245: OPEN c_igs_pe_teach_periods_v;

1241: END IF;
1242: END IF;
1243:
1244: IF rowid_pe_teach_table.count = 0 AND l_pe_teaching_exists THEN
1245: OPEN c_igs_pe_teach_periods_v;
1246: FETCH c_igs_pe_teach_periods_v BULK COLLECT INTO rowid_pe_teach_table ;
1247: IF c_igs_pe_teach_periods_v%ISOPEN THEN
1248: CLOSE c_igs_pe_teach_periods_v;
1249: END IF;

Line 1246: FETCH c_igs_pe_teach_periods_v BULK COLLECT INTO rowid_pe_teach_table ;

1242: END IF;
1243:
1244: IF rowid_pe_teach_table.count = 0 AND l_pe_teaching_exists THEN
1245: OPEN c_igs_pe_teach_periods_v;
1246: FETCH c_igs_pe_teach_periods_v BULK COLLECT INTO rowid_pe_teach_table ;
1247: IF c_igs_pe_teach_periods_v%ISOPEN THEN
1248: CLOSE c_igs_pe_teach_periods_v;
1249: END IF;
1250: END IF;

Line 1247: IF c_igs_pe_teach_periods_v%ISOPEN THEN

1243:
1244: IF rowid_pe_teach_table.count = 0 AND l_pe_teaching_exists THEN
1245: OPEN c_igs_pe_teach_periods_v;
1246: FETCH c_igs_pe_teach_periods_v BULK COLLECT INTO rowid_pe_teach_table ;
1247: IF c_igs_pe_teach_periods_v%ISOPEN THEN
1248: CLOSE c_igs_pe_teach_periods_v;
1249: END IF;
1250: END IF;
1251:

Line 1248: CLOSE c_igs_pe_teach_periods_v;

1244: IF rowid_pe_teach_table.count = 0 AND l_pe_teaching_exists THEN
1245: OPEN c_igs_pe_teach_periods_v;
1246: FETCH c_igs_pe_teach_periods_v BULK COLLECT INTO rowid_pe_teach_table ;
1247: IF c_igs_pe_teach_periods_v%ISOPEN THEN
1248: CLOSE c_igs_pe_teach_periods_v;
1249: END IF;
1250: END IF;
1251:
1252: IF rowid_tst_rslt_dtl_table.count = 0 AND l_ad_tst_rslt_dtl_rule_exists THEN