APPS.IGF_AW_LI_IMPORT dependencies on IGF_SE_AUTH

Line 1097: CURSOR c_get_auth_row (cp_auth_id igf_se_auth.auth_id%TYPE) IS

1093: SELECT ROWID row_id
1094: FROM igf_db_disb_holds_all
1095: WHERE award_id = p_award_id;
1096:
1097: CURSOR c_get_auth_row (cp_auth_id igf_se_auth.auth_id%TYPE) IS
1098: SELECT ROWID row_id
1099: FROM igf_se_auth
1100: WHERE auth_id = cp_auth_id;
1101:

Line 1099: FROM igf_se_auth

1095: WHERE award_id = p_award_id;
1096:
1097: CURSOR c_get_auth_row (cp_auth_id igf_se_auth.auth_id%TYPE) IS
1098: SELECT ROWID row_id
1099: FROM igf_se_auth
1100: WHERE auth_id = cp_auth_id;
1101:
1102: CURSOR c_get_disb_chg_dtls_row (p_award_id igf_aw_award_all.award_id%TYPE) IS
1103: SELECT ROWID row_id

Line 1178: igf_se_auth_pkg.delete_row(c_get_auth_row_rec.row_id);

1174: FOR c_get_disb_row_rec IN c_get_disb_row LOOP
1175: -- Delete the authorization record for the corresponsing Disb
1176: IF c_get_disb_row_rec.auth_id IS NOT NULL THEN
1177: FOR c_get_auth_row_rec IN c_get_auth_row(c_get_disb_row_rec.auth_id) LOOP
1178: igf_se_auth_pkg.delete_row(c_get_auth_row_rec.row_id);
1179: END LOOP;
1180: END IF;
1181: igf_aw_awd_disb_pkg.delete_row(c_get_disb_row_rec.row_id);
1182: END LOOP;