APPS.FND_TRANSACTION dependencies on FND_APPLICATION

Line 93: from fnd_concurrent_programs fcp, fnd_application fa

89: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID)
90: SELECT event_type, sysdate, request_id,
91: fcp.application_id, fcp.concurrent_program_id,
92: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id
93: from fnd_concurrent_programs fcp, fnd_application fa
94: where fcp.concurrent_program_name = program
95: and fcp.application_id = fa.application_id
96: and fa.application_short_name = application;
97: elsif ( event_type = 2 ) then

Line 113: fnd_application fa

109: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,
110: fcq.RUNNING_PROCESSES, fcq.max_processes
111: from fnd_concurrent_programs fcp,
112: fnd_concurrent_queues fcq,
113: fnd_application fa
114: where fcp.concurrent_program_name = program
115: and fcq.concurrent_queue_id = queue_id
116: and fcp.application_id = fa.application_id
117: and fa.application_short_name = application;

Line 143: from fnd_application fa,

139: FCQ.application_id, FCQ.concurrent_queue_id,
140: fcp.application_id, fcp.concurrent_program_id,
141: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,
142: fcq.RUNNING_PROCESSES, fcq.max_processes
143: from fnd_application fa,
144: fnd_concurrent_programs fcp,
145: fnd_conc_processor_programs fcpp,
146: fnd_responsibility fr,
147: fnd_concurrent_queues fcq

Line 169: from fnd_application

165: from fnd_concurrent_programs fcp
166: where fcp.concurrent_program_name = program
167: and fcp.application_id = (
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,

Line 193: from fnd_concurrent_programs fcp, fnd_application fa

189: USER_ID, RESP_APPL_ID, RESPONSIBILITY_ID, NUMDATA)
190: SELECT event_type, sysdate, request_id,
191: fcp.application_id, fcp.concurrent_program_id,
192: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id, timeout
193: from fnd_concurrent_programs fcp, fnd_application fa
194: where fcp.concurrent_program_name = program
195: and fcp.application_id = fa.application_id
196: and fa.application_short_name = application;
197: end if;

Line 376: FND_APPLICATION A

372: P.APPLICATION_ID, P.CONCURRENT_PROGRAM_ID
373: INTO enable_trace_flag, morg_cat,
374: g_program_appl_id, g_program_id
375: FROM FND_CONCURRENT_PROGRAMS P,
376: FND_APPLICATION A
377: where p.concurrent_program_name = program
378: and p.application_id = a.application_id
379: and a.application_short_name = application;
380: