[Home] [Help]
30: WHERE app_no = p_app_no;
31:
32: CURSOR cur_ucapre IS
33: SELECT ROWID
34: FROM igs_uc_app_results
35: WHERE app_no = p_app_no;
36:
37: CURSOR cur_ucapst IS
38: SELECT ROWID
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 );
71: END LOOP;
72:
73: FOR x IN cur_ucapcr LOOP
74: igs_uc_app_clr_rnd_pkg.delete_row ( x_rowid => x.ROWID );