APPS.FND_TRANSACTION dependencies on FND_TM_EVENTS

Line 73: -- Posts TM Event into FND_TM_EVENTS table as autonomous transaction

69:
70: --
71: -- post_tm_event
72: -- Purpose
73: -- Posts TM Event into FND_TM_EVENTS table as autonomous transaction
74: -- Arguments
75: -- event_type number
76: procedure post_tm_event( event_type in number,
77: application in varchar2,

Line 86: insert into fnd_tm_events

82: PRAGMA AUTONOMOUS_TRANSACTION;
83: begin
84: if ( event_type = 1 ) then
85: -- NO MANAGER DEFINED EVENT
86: insert into fnd_tm_events
87: (EVENT_TYPE, TIMESTAMP, TRANSACTION_ID,
88: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
89: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID)
90: SELECT event_type, sysdate, request_id,

Line 100: insert into fnd_tm_events

96: and fa.application_short_name = application;
97: elsif ( event_type = 2 ) then
98: -- MANAGER BUSY EVENT
99: /* mark soft busy event (2) */
100: insert into fnd_tm_events
101: (EVENT_TYPE, TIMESTAMP, TRANSACTION_ID,
102: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
103: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
104: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID,

Line 123: delete from fnd_tm_events

119: elsif ( event_type = 3 ) then
120: -- ALL MANAGERS WERE BUSY EVENT
121: -- delete previously posted soft busy events before posting hard busy
122: -- event.
123: delete from fnd_tm_events
124: where transaction_id = request_id
125: and event_type = 2;
126:
127: /* mark all appropriate managers as hard busy events */

Line 128: insert into fnd_tm_events

124: where transaction_id = request_id
125: and event_type = 2;
126:
127: /* mark all appropriate managers as hard busy events */
128: insert into fnd_tm_events
129: (EVENT_TYPE, TIMESTAMP, TRANSACTION_ID,
130: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
131: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
132: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID,

Line 172: insert into fnd_tm_events

168: SELECT application_id
169: from fnd_application
170: where application_short_name = application);
171:
172: insert into fnd_tm_events
173: (EVENT_TYPE, TIMESTAMP, TRANSACTION_ID,
174: QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID,
175: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
176: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID,

Line 186: insert into fnd_tm_events

182: fcq.RUNNING_PROCESSES, fcq.max_processes, timeout
183: from fnd_concurrent_queues fcq
184: where fcq.concurrent_queue_id = to_number(substr(tm_pipe,11));
185: else
186: insert into fnd_tm_events
187: (EVENT_TYPE, TIMESTAMP, TRANSACTION_ID,
188: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
189: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID, NUMDATA)
190: SELECT event_type, sysdate, request_id,