131: ;
132:
133: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
132:
133: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
133: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
141: COMMIT;
134:
135: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
136: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
137: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(SQL%ROWCOUNT));
138: fnd_file.put_line(fnd_file.log, fnd_message.get);
139: fnd_file.new_line(fnd_file.log,1);
140:
141: COMMIT;
142:
292: l_den_update_count := l_den_update_count + SQL%ROWCOUNT ;
293:
294: END IF;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
293:
294: END IF;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
294: END IF;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
302: COMMIT;
295:
296: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
297: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_GROUPS_DENORM');
298: fnd_message.set_token('P_ROWCOUNT', TO_CHAR(l_update_count));
299: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
300: fnd_file.new_line(fnd_file.LOG,1);
301:
302: COMMIT;
303:
325:
326: l_update_count := l_update_count + SQL%ROWCOUNT ;
327: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
326: l_update_count := l_update_count + SQL%ROWCOUNT ;
327: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
327: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
335: COMMIT;
328:
329: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TO_INACT_COUNT');
330: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
331: fnd_message.set_token('P_ROWCOUNT', to_char(l_update_count));
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.new_line(fnd_file.log,1);
334:
335: COMMIT;
336:
343: ;
344:
345: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
344:
345: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
345: l_role_update_count := l_role_update_count + SQL%ROWCOUNT ;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
353: COMMIT;
346:
347: fnd_message.set_name('JTF', 'JTF_RS_INACT_TO_ACTIVE_COUNT');
348: fnd_message.set_token('P_TABLE_NAME', 'JTF_RS_ROLE_RELATIONS');
349: fnd_message.set_token('P_ROWCOUNT', to_char(SQL%ROWCOUNT));
350: fnd_file.put_line(fnd_file.log, fnd_message.get);
351: fnd_file.new_line(fnd_file.log,1);
352:
353: COMMIT;
354: