APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_EXTRACURR_ACT_V

Line 879: CURSOR c_igs_ad_extracurr_act_v IS

875: SELECT row_id
876: FROM igs_ad_acad_history_v
877: WHERE person_id = p_person_id;
878:
879: CURSOR c_igs_ad_extracurr_act_v IS
880: SELECT rowid
881: FROM HZ_PERSON_INTEREST PI
882: WHERE party_ID = p_person_id;
883:

Line 1025: lv_rowid_extr_act igs_ad_extracurr_act_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;
1027: lv_rowid_app_int igs_ad_app_intent_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;

Line 1269: OPEN c_igs_ad_extracurr_act_v;

1265: END IF;
1266: END IF;
1267:
1268: IF rowid_extr_act_table.count = 0 AND l_extra_cur_rule_exists THEN
1269: OPEN c_igs_ad_extracurr_act_v;
1270: FETCH c_igs_ad_extracurr_act_v BULK COLLECT INTO rowid_extr_act_table ;
1271: IF c_igs_ad_extracurr_act_v%ISOPEN THEN
1272: CLOSE c_igs_ad_extracurr_act_v;
1273: END IF;

Line 1270: FETCH c_igs_ad_extracurr_act_v BULK COLLECT INTO rowid_extr_act_table ;

1266: END IF;
1267:
1268: IF rowid_extr_act_table.count = 0 AND l_extra_cur_rule_exists THEN
1269: OPEN c_igs_ad_extracurr_act_v;
1270: FETCH c_igs_ad_extracurr_act_v BULK COLLECT INTO rowid_extr_act_table ;
1271: IF c_igs_ad_extracurr_act_v%ISOPEN THEN
1272: CLOSE c_igs_ad_extracurr_act_v;
1273: END IF;
1274: END IF;

Line 1271: IF c_igs_ad_extracurr_act_v%ISOPEN THEN

1267:
1268: IF rowid_extr_act_table.count = 0 AND l_extra_cur_rule_exists THEN
1269: OPEN c_igs_ad_extracurr_act_v;
1270: FETCH c_igs_ad_extracurr_act_v BULK COLLECT INTO rowid_extr_act_table ;
1271: IF c_igs_ad_extracurr_act_v%ISOPEN THEN
1272: CLOSE c_igs_ad_extracurr_act_v;
1273: END IF;
1274: END IF;
1275:

Line 1272: CLOSE c_igs_ad_extracurr_act_v;

1268: IF rowid_extr_act_table.count = 0 AND l_extra_cur_rule_exists THEN
1269: OPEN c_igs_ad_extracurr_act_v;
1270: FETCH c_igs_ad_extracurr_act_v BULK COLLECT INTO rowid_extr_act_table ;
1271: IF c_igs_ad_extracurr_act_v%ISOPEN THEN
1272: CLOSE c_igs_ad_extracurr_act_v;
1273: END IF;
1274: END IF;
1275:
1276: IF rowid_test_rslt_table.count = 0 AND l_ad_test_rslt_rule_exists THEN