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_LOG_TRANSACTION_CONTEXT

Line 11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;

7:
8: /******************************************************************************/
9: /***Constants for Changes due to system Log ***********************************/
10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;

10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
16: TYPE VARCAHRSmallListTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
17:
18:

Line 34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT

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
38: --List

Line 355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT

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
359: is

Line 377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;

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);
381: */

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

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);
381: */
382: end printCount;

Line 552: || ' from FND_LOG_TRANSACTION_CONTEXT fltc ';

548: l_part3 :='';
549: l_part4 :='';
550:
551: l_retu := 'select distinct fltc.TRANSACTION_CONTEXT_ID '
552: || ' from FND_LOG_TRANSACTION_CONTEXT fltc ';
553:
554:
555: if (pTrType = C_TR_REQUEST_TYPE) then
556: l_part1 := ' where fltc.TRANSACTION_TYPE = ''REQUEST'' ';

Line 907: --doesn't exist in fnd_log_transaction_context but meets the input date range.

903: END DELETE_MESSAGES_INFO;
904:
905: --------------------------------------------------------------------------------
906: --This function deletes those log messages whose transaction Context Id is
907: --doesn't exist in fnd_log_transaction_context but meets the input date range.
908:
909: procedure DELETE_MESSAGES_INVALID_TRID(pRetCode out NOCOPY number
910: ,X_START_DATE IN DATE, X_END_DATE IN DATE )
911: IS

Line 927: not exists (select null from FND_LOG_TRANSACTION_CONTEXT fltc

923: select flm.TRANSACTION_CONTEXT_ID BULK COLLECT into l_EXList
924: from
925: FND_LOG_MESSAGES flm
926: where
927: not exists (select null from FND_LOG_TRANSACTION_CONTEXT fltc
928: where flm.TRANSACTION_CONTEXT_ID = fltc.TRANSACTION_CONTEXT_ID)
929: and (X_START_DATE is null or flm.TIMESTAMP >= X_START_DATE)
930: and (X_END_DATE is null or flm.TIMESTAMP <= X_END_DATE);
931:

Line 973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');

969: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS
970: doCommit;
971:
972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');
974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS

Line 974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';

970: doCommit;
971:
972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');
974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS
978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))

Line 976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)

972:
973: fdebug('Start Del FND_LOG_TRANSACTION_CONTEXT');
974: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
975: FORALL ii IN l_start..l_end
976: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
977: and NOT EXISTS
978: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))
979: and NOT EXISTS
980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));

Line 983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT

979: and NOT EXISTS
980: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));
981:
982: l_retu := sql%rowcount;
983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT
984: doCommit;
985: return l_retu;
986: fdebug('End Del FND_LOG_TRANSACTION_CONTEXT');
987:

Line 986: fdebug('End Del FND_LOG_TRANSACTION_CONTEXT');

982: l_retu := sql%rowcount;
983: s_rows_deleted_fltc := s_rows_deleted_fltc + sql%rowcount; --FND_LOG_TRANSACTION_CONTEXT
984: doCommit;
985: return l_retu;
986: fdebug('End Del FND_LOG_TRANSACTION_CONTEXT');
987:
988: EXCEPTION
989: when others then
990: fdebug('Failed in DEL_METR_TRANS_INFO');

Line 1202: --fnd_log_transaction_context.

1198: DELETE_UNIQUEA_EXCEPTIONS_INFO(l_retCode);
1199: commit;
1200:
1201: --Delete the messages whose transaction context id doesn't exist in
1202: --fnd_log_transaction_context.
1203: DELETE_MESSAGES_INVALID_TRID(l_retCode, X_START_DATE, X_END_DATE);
1204: commit;
1205:
1206: printCount;