APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_ACAD_INTEREST

Line 894: CURSOR c_igs_ad_acad_interest_v IS

890: SELECT rowid row_id
891: FROM igs_ad_app_intent
892: WHERE person_id = p_person_id;
893:
894: CURSOR c_igs_ad_acad_interest_v IS
895: SELECT rowid row_id
896: FROM igs_ad_acad_interest
897: WHERE person_id = p_person_id;
898:

Line 896: FROM igs_ad_acad_interest

892: WHERE person_id = p_person_id;
893:
894: CURSOR c_igs_ad_acad_interest_v IS
895: SELECT rowid row_id
896: FROM igs_ad_acad_interest
897: WHERE person_id = p_person_id;
898:
899: CURSOR c_igs_ad_spl_interests_v IS
900: SELECT rowid row_id

Line 1028: lv_rowid_acad_int igs_ad_acad_interest_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;
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;

Line 1293: OPEN c_igs_ad_acad_interest_v;

1289: END IF;
1290: END IF;
1291:
1292: IF rowid_acad_int_table.count = 0 AND l_acad_interest_rule_exists THEN
1293: OPEN c_igs_ad_acad_interest_v;
1294: FETCH c_igs_ad_acad_interest_v BULK COLLECT INTO rowid_acad_int_table ;
1295: IF c_igs_ad_acad_interest_v%ISOPEN THEN
1296: CLOSE c_igs_ad_acad_interest_v;
1297: END IF;

Line 1294: FETCH c_igs_ad_acad_interest_v BULK COLLECT INTO rowid_acad_int_table ;

1290: END IF;
1291:
1292: IF rowid_acad_int_table.count = 0 AND l_acad_interest_rule_exists THEN
1293: OPEN c_igs_ad_acad_interest_v;
1294: FETCH c_igs_ad_acad_interest_v BULK COLLECT INTO rowid_acad_int_table ;
1295: IF c_igs_ad_acad_interest_v%ISOPEN THEN
1296: CLOSE c_igs_ad_acad_interest_v;
1297: END IF;
1298: END IF;

Line 1295: IF c_igs_ad_acad_interest_v%ISOPEN THEN

1291:
1292: IF rowid_acad_int_table.count = 0 AND l_acad_interest_rule_exists THEN
1293: OPEN c_igs_ad_acad_interest_v;
1294: FETCH c_igs_ad_acad_interest_v BULK COLLECT INTO rowid_acad_int_table ;
1295: IF c_igs_ad_acad_interest_v%ISOPEN THEN
1296: CLOSE c_igs_ad_acad_interest_v;
1297: END IF;
1298: END IF;
1299:

Line 1296: CLOSE c_igs_ad_acad_interest_v;

1292: IF rowid_acad_int_table.count = 0 AND l_acad_interest_rule_exists THEN
1293: OPEN c_igs_ad_acad_interest_v;
1294: FETCH c_igs_ad_acad_interest_v BULK COLLECT INTO rowid_acad_int_table ;
1295: IF c_igs_ad_acad_interest_v%ISOPEN THEN
1296: CLOSE c_igs_ad_acad_interest_v;
1297: END IF;
1298: END IF;
1299:
1300: IF rowid_spl_int_table.count = 0 AND l_spl_interest_rule_exists THEN