35: WHERE app_no = p_app_no;
36:
37: CURSOR cur_ucapst IS
38: SELECT ROWID
39: FROM igs_uc_app_stats
40: WHERE app_no = p_app_no;
41:
42: CURSOR cur_ucaddr IS
43: SELECT ROWID
62: BEGIN
63:
64: --Delete Wrong Applicant records from UCAS Interface tables by calling the corresponding TBH.
65: FOR x IN cur_ucapst LOOP
66: igs_uc_app_stats_pkg.delete_row ( x_rowid => x.ROWID );
67: END LOOP;
68:
69: FOR x IN cur_ucapre LOOP
70: igs_uc_app_results_pkg.delete_row ( x_rowid => x.ROWID );