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;
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;
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;
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;
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: /*
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
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
915: end if;
916:
917: if ( AFLOG_BUFFER_MODE_X > 0 ) then
918: MODULE_TABLE := FND_TABLE_OF_VARCHAR2_255();
919: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();
920: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
921: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
922: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
923: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
917: if ( AFLOG_BUFFER_MODE_X > 0 ) then
918: MODULE_TABLE := FND_TABLE_OF_VARCHAR2_255();
919: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();
920: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
921: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
922: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
923: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
924: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
925: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
918: MODULE_TABLE := FND_TABLE_OF_VARCHAR2_255();
919: LOG_LEVEL_TABLE := FND_TABLE_OF_NUMBER();
920: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
921: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
922: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
923: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
924: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
925: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
926: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
920: MESSAGE_TEXT_TABLE := FND_TABLE_OF_VARCHAR2_4000();
921: SESSION_ID_TABLE := FND_TABLE_OF_NUMBER();
922: USER_ID_TABLE := FND_TABLE_OF_NUMBER();
923: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
924: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
925: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
926: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
927: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
928: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
923: TIMESTAMP_TABLE := FND_TABLE_OF_DATE();
924: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
925: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
926: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
927: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
928: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
929: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();
930: end if;
931:
924: LOG_SEQUENCE_TABLE := FND_TABLE_OF_NUMBER();
925: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
926: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
927: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
928: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
929: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();
930: end if;
931:
932: end if;
925: ENCODED_TABLE := FND_TABLE_OF_VARCHAR2_1();
926: THREAD_ID_TABLE := FND_TABLE_OF_VARCHAR2_120();
927: AUDSID_TABLE := FND_TABLE_OF_NUMBER();
928: DB_INSTANCE_TABLE := FND_TABLE_OF_NUMBER();
929: TRANSACTION_CONTEXT_ID_TABLE := FND_TABLE_OF_NUMBER();
930: end if;
931:
932: end if;
933: end SET_BUFFERED_MODE;
2036: /**
2037: * Private function for Bulk logging messages
2038: */
2039: FUNCTION BULK_INSERT_PVT(MODULE_IN IN FND_TABLE_OF_VARCHAR2_255,
2040: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,
2041: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2042: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2043: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2044: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2038: */
2039: FUNCTION BULK_INSERT_PVT(MODULE_IN IN FND_TABLE_OF_VARCHAR2_255,
2040: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,
2041: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2042: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2043: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2044: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2045: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,
2046: ENCODED_IN IN FND_TABLE_OF_VARCHAR2_1,
2039: FUNCTION BULK_INSERT_PVT(MODULE_IN IN FND_TABLE_OF_VARCHAR2_255,
2040: LOG_LEVEL_IN IN FND_TABLE_OF_NUMBER,
2041: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2042: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2043: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2044: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2045: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,
2046: ENCODED_IN IN FND_TABLE_OF_VARCHAR2_1,
2047: NODE_IN IN varchar2,
2041: MESSAGE_TEXT_IN IN FND_TABLE_OF_VARCHAR2_4000,
2042: SESSION_ID_IN IN FND_TABLE_OF_NUMBER,
2043: USER_ID_IN IN FND_TABLE_OF_NUMBER,
2044: TIMESTAMP_IN IN FND_TABLE_OF_DATE,
2045: LOG_SEQUENCE_IN IN FND_TABLE_OF_NUMBER,
2046: ENCODED_IN IN FND_TABLE_OF_VARCHAR2_1,
2047: NODE_IN IN varchar2,
2048: NODE_IP_ADDRESS_IN IN varchar2,
2049: PROCESS_ID_IN IN varchar2,
2048: NODE_IP_ADDRESS_IN IN varchar2,
2049: PROCESS_ID_IN IN varchar2,
2050: JVM_ID_IN IN varchar2,
2051: THREAD_ID_IN IN FND_TABLE_OF_VARCHAR2_120,
2052: AUDSID_IN IN FND_TABLE_OF_NUMBER,
2053: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,
2054: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,
2055: SIZE_IN IN NUMBER) RETURN NUMBER is
2056: pragma AUTONOMOUS_TRANSACTION;
2049: PROCESS_ID_IN IN varchar2,
2050: JVM_ID_IN IN varchar2,
2051: THREAD_ID_IN IN FND_TABLE_OF_VARCHAR2_120,
2052: AUDSID_IN IN FND_TABLE_OF_NUMBER,
2053: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,
2054: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,
2055: SIZE_IN IN NUMBER) RETURN NUMBER is
2056: pragma AUTONOMOUS_TRANSACTION;
2057: l_node varchar2(60);
2050: JVM_ID_IN IN varchar2,
2051: THREAD_ID_IN IN FND_TABLE_OF_VARCHAR2_120,
2052: AUDSID_IN IN FND_TABLE_OF_NUMBER,
2053: DB_INSTANCE_IN IN FND_TABLE_OF_NUMBER,
2054: TRANSACTION_CONTEXT_ID_IN IN FND_TABLE_OF_NUMBER,
2055: SIZE_IN IN NUMBER) RETURN NUMBER is
2056: pragma AUTONOMOUS_TRANSACTION;
2057: l_node varchar2(60);
2058: l_node_ip_address varchar2(30);