208: l_commit_size;
209: --
210: l_total_count := l_count + l_total_count;
211: END LOOP;
212: AP_Debug_Pkg.Print('Y', ' ');
213: AP_Debug_Pkg.Print('Y', 'Number of Distributions Updated : '
214: || TO_CHAR(l_total_count));
215: AP_Debug_Pkg.Print('Y', ' ');
216:
209: --
210: l_total_count := l_count + l_total_count;
211: END LOOP;
212: AP_Debug_Pkg.Print('Y', ' ');
213: AP_Debug_Pkg.Print('Y', 'Number of Distributions Updated : '
214: || TO_CHAR(l_total_count));
215: AP_Debug_Pkg.Print('Y', ' ');
216:
217: EXCEPTION
211: END LOOP;
212: AP_Debug_Pkg.Print('Y', ' ');
213: AP_Debug_Pkg.Print('Y', 'Number of Distributions Updated : '
214: || TO_CHAR(l_total_count));
215: AP_Debug_Pkg.Print('Y', ' ');
216:
217: EXCEPTION
218: --
219: WHEN OTHERS THEN