eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_LOG_ADMIN dependencies on FND_OAM_BIZEX_SENT_NOTIF

Line 33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF

29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES
30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS
33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF
34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT
35:
36:
37: ---Constants used for dynamic SQL

Line 354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF

350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES
351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS
354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT
356: END init;
357:
358: procedure printCount

Line 375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;

371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;

Line 376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);

372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);

Line 757: fdebug('Start Del FND_OAM_BIZEX_SENT_NOTIF');

753: );
754: s_rows_deleted_fen := s_rows_deleted_fen + sql%rowcount; --FND_EXCEPTION_NOTES
755: doCommit;
756:
757: fdebug('Start Del FND_OAM_BIZEX_SENT_NOTIF');
758: l_table := 'FND_OAM_BIZEX_SENT_NOTIF';
759: FORALL ii IN l_start..l_end
760: DELETE FROM FND_OAM_BIZEX_SENT_NOTIF fobsf
761: WHERE fobsf.UNIQUE_EXCEPTION_ID = p_UEXList(ii)

Line 758: l_table := 'FND_OAM_BIZEX_SENT_NOTIF';

754: s_rows_deleted_fen := s_rows_deleted_fen + sql%rowcount; --FND_EXCEPTION_NOTES
755: doCommit;
756:
757: fdebug('Start Del FND_OAM_BIZEX_SENT_NOTIF');
758: l_table := 'FND_OAM_BIZEX_SENT_NOTIF';
759: FORALL ii IN l_start..l_end
760: DELETE FROM FND_OAM_BIZEX_SENT_NOTIF fobsf
761: WHERE fobsf.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
762: and NOT EXISTS

Line 760: DELETE FROM FND_OAM_BIZEX_SENT_NOTIF fobsf

756:
757: fdebug('Start Del FND_OAM_BIZEX_SENT_NOTIF');
758: l_table := 'FND_OAM_BIZEX_SENT_NOTIF';
759: FORALL ii IN l_start..l_end
760: DELETE FROM FND_OAM_BIZEX_SENT_NOTIF fobsf
761: WHERE fobsf.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
762: and NOT EXISTS
763: (SELECT null from FND_LOG_EXCEPTIONS fle
764: where fle.UNIQUE_EXCEPTION_ID = fobsf.UNIQUE_EXCEPTION_ID

Line 766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF

762: and NOT EXISTS
763: (SELECT null from FND_LOG_EXCEPTIONS fle
764: where fle.UNIQUE_EXCEPTION_ID = fobsf.UNIQUE_EXCEPTION_ID
765: );
766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;
768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';