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_REPOSITORY dependencies on FND_TABLE_OF_NUMBER

Line 36: LOG_LEVEL_TABLE FND_TABLE_OF_NUMBER;

32:
33: /* For Buffered Mode */
34: G_BUFFER_POS NUMBER := 1;
35: MODULE_TABLE FND_TABLE_OF_VARCHAR2_255;
36: LOG_LEVEL_TABLE FND_TABLE_OF_NUMBER;
37: MESSAGE_TEXT_TABLE FND_TABLE_OF_VARCHAR2_4000;
38: SESSION_ID_TABLE FND_TABLE_OF_NUMBER;
39: USER_ID_TABLE FND_TABLE_OF_NUMBER;
40: TIMESTAMP_TABLE FND_TABLE_OF_DATE;

Line 38: SESSION_ID_TABLE FND_TABLE_OF_NUMBER;

34: G_BUFFER_POS NUMBER := 1;
35: MODULE_TABLE FND_TABLE_OF_VARCHAR2_255;
36: LOG_LEVEL_TABLE FND_TABLE_OF_NUMBER;
37: MESSAGE_TEXT_TABLE FND_TABLE_OF_VARCHAR2_4000;
38: SESSION_ID_TABLE FND_TABLE_OF_NUMBER;
39: USER_ID_TABLE FND_TABLE_OF_NUMBER;
40: TIMESTAMP_TABLE FND_TABLE_OF_DATE;
41: LOG_SEQUENCE_TABLE FND_TABLE_OF_NUMBER;
42: ENCODED_TABLE FND_TABLE_OF_VARCHAR2_1;

Line 39: USER_ID_TABLE FND_TABLE_OF_NUMBER;

35: MODULE_TABLE FND_TABLE_OF_VARCHAR2_255;
36: LOG_LEVEL_TABLE FND_TABLE_OF_NUMBER;
37: MESSAGE_TEXT_TABLE FND_TABLE_OF_VARCHAR2_4000;
38: SESSION_ID_TABLE FND_TABLE_OF_NUMBER;
39: USER_ID_TABLE FND_TABLE_OF_NUMBER;
40: TIMESTAMP_TABLE FND_TABLE_OF_DATE;
41: LOG_SEQUENCE_TABLE FND_TABLE_OF_NUMBER;
42: ENCODED_TABLE FND_TABLE_OF_VARCHAR2_1;
43: NODE_TABLE varchar2(60) := NULL;

Line 41: LOG_SEQUENCE_TABLE FND_TABLE_OF_NUMBER;

37: MESSAGE_TEXT_TABLE FND_TABLE_OF_VARCHAR2_4000;
38: SESSION_ID_TABLE FND_TABLE_OF_NUMBER;
39: USER_ID_TABLE FND_TABLE_OF_NUMBER;
40: TIMESTAMP_TABLE FND_TABLE_OF_DATE;
41: LOG_SEQUENCE_TABLE FND_TABLE_OF_NUMBER;
42: ENCODED_TABLE FND_TABLE_OF_VARCHAR2_1;
43: NODE_TABLE varchar2(60) := NULL;
44: NODE_IP_ADDRESS_TABLE varchar2(30) := NULL;
45: PROCESS_ID_TABLE varchar2(120) := NULL;

Line 48: AUDSID_TABLE FND_TABLE_OF_NUMBER;

44: NODE_IP_ADDRESS_TABLE varchar2(30) := NULL;
45: PROCESS_ID_TABLE varchar2(120) := NULL;
46: JVM_ID_TABLE varchar2(120) := NULL;
47: THREAD_ID_TABLE FND_TABLE_OF_VARCHAR2_120;
48: AUDSID_TABLE FND_TABLE_OF_NUMBER;
49: DB_INSTANCE_TABLE FND_TABLE_OF_NUMBER;
50: TRANSACTION_CONTEXT_ID_TABLE FND_TABLE_OF_NUMBER;
51:
52: /*

Line 49: DB_INSTANCE_TABLE FND_TABLE_OF_NUMBER;

45: PROCESS_ID_TABLE varchar2(120) := NULL;
46: JVM_ID_TABLE varchar2(120) := NULL;
47: THREAD_ID_TABLE FND_TABLE_OF_VARCHAR2_120;
48: AUDSID_TABLE FND_TABLE_OF_NUMBER;
49: DB_INSTANCE_TABLE FND_TABLE_OF_NUMBER;
50: TRANSACTION_CONTEXT_ID_TABLE FND_TABLE_OF_NUMBER;
51:
52: /*
53: ** For GET_CONTEXT Function

Line 50: TRANSACTION_CONTEXT_ID_TABLE FND_TABLE_OF_NUMBER;

46: JVM_ID_TABLE varchar2(120) := NULL;
47: THREAD_ID_TABLE FND_TABLE_OF_VARCHAR2_120;
48: AUDSID_TABLE FND_TABLE_OF_NUMBER;
49: DB_INSTANCE_TABLE FND_TABLE_OF_NUMBER;
50: TRANSACTION_CONTEXT_ID_TABLE FND_TABLE_OF_NUMBER;
51:
52: /*
53: ** For GET_CONTEXT Function
54: ** Types for storing context info before calling autonomous

Line 941: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();

937: end if;
938:
939: if ( AFLOG_BUFFER_MODE_X > 0 ) then
940: MODULE_TABLE := FND_TABLE_OF_VARCHAR2_255();
941: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();
942: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
943: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
944: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
945: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();

Line 943: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();

939: if ( AFLOG_BUFFER_MODE_X > 0 ) then
940: MODULE_TABLE := FND_TABLE_OF_VARCHAR2_255();
941: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();
942: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
943: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
944: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
945: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
946: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
947: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();

Line 944: USER_ID_TABLE := FND_TABLE_OF_NUMBER();

940: MODULE_TABLE := FND_TABLE_OF_VARCHAR2_255();
941: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();
942: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
943: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
944: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
945: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
946: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
947: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
948: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();

Line 946: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();

942: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
943: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
944: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
945: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
946: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
947: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
948: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
949: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
950: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();

Line 949: AUDSID_TABLE := FND_TABLE_OF_NUMBER();

945: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
946: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
947: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
948: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
949: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
950: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
951: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();
952: end if;
953:

Line 950: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();

946: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
947: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
948: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
949: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
950: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
951: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();
952: end if;
953:
954: end if;

Line 951: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();

947: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
948: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
949: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
950: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
951: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();
952: end if;
953:
954: end if;
955: end SET_BUFFERED_MODE;

Line 2089: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,

2085: /**
2086: * Private function for Bulk logging messages
2087: */
2088: FUNCTION BULK_INSERT_PVT(MODULE_IN IN FND_TABLE_OF_VARCHAR2_255,
2089: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,
2090: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2091: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2092: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2093: TIMESTAMP_IN IN FND_TABLE_OF_DATE,

Line 2091: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,

2087: */
2088: FUNCTION BULK_INSERT_PVT(MODULE_IN IN FND_TABLE_OF_VARCHAR2_255,
2089: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,
2090: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2091: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2092: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2093: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2094: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,
2095: ENCODED_IN IN FND_TABLE_OF_VARCHAR2_1,

Line 2092: USER_ID_IN IN FND_TABLE_OF_NUMBER,

2088: FUNCTION BULK_INSERT_PVT(MODULE_IN IN FND_TABLE_OF_VARCHAR2_255,
2089: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,
2090: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2091: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2092: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2093: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2094: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,
2095: ENCODED_IN IN FND_TABLE_OF_VARCHAR2_1,
2096: NODE_IN IN varchar2,

Line 2094: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,

2090: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2091: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2092: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2093: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2094: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,
2095: ENCODED_IN IN FND_TABLE_OF_VARCHAR2_1,
2096: NODE_IN IN varchar2,
2097: NODE_IP_ADDRESS_IN IN varchar2,
2098: PROCESS_ID_IN IN varchar2,

Line 2101: AUDSID_IN IN FND_TABLE_OF_NUMBER,

2097: NODE_IP_ADDRESS_IN IN varchar2,
2098: PROCESS_ID_IN IN varchar2,
2099: JVM_ID_IN IN varchar2,
2100: THREAD_ID_IN IN FND_TABLE_OF_VARCHAR2_120,
2101: AUDSID_IN IN FND_TABLE_OF_NUMBER,
2102: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,
2103: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,
2104: SIZE_IN IN NUMBER) RETURN NUMBER is
2105: pragma AUTONOMOUS_TRANSACTION;

Line 2102: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,

2098: PROCESS_ID_IN IN varchar2,
2099: JVM_ID_IN IN varchar2,
2100: THREAD_ID_IN IN FND_TABLE_OF_VARCHAR2_120,
2101: AUDSID_IN IN FND_TABLE_OF_NUMBER,
2102: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,
2103: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,
2104: SIZE_IN IN NUMBER) RETURN NUMBER is
2105: pragma AUTONOMOUS_TRANSACTION;
2106: l_node varchar2(60);

Line 2103: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,

2099: JVM_ID_IN IN varchar2,
2100: THREAD_ID_IN IN FND_TABLE_OF_VARCHAR2_120,
2101: AUDSID_IN IN FND_TABLE_OF_NUMBER,
2102: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,
2103: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,
2104: SIZE_IN IN NUMBER) RETURN NUMBER is
2105: pragma AUTONOMOUS_TRANSACTION;
2106: l_node varchar2(60);
2107: l_node_ip_address varchar2(30);