DBA Data[Home] [Help]

APPS.FND_TRANSACTION dependencies on FND_GLOBAL

Line 55: sid, fnd_global.user_id, fnd_global.login_id,

51: concurrent_queue_id, time_in_number, source_type
52: )
53: values
54: (
55: sid, fnd_global.user_id, fnd_global.login_id,
56: sysdate, function_name, substr(action_cnt || '|' || action_name, 1, 30),
57: substr(message_text, 1, ARGMAX),
58: fnd_global.resp_appl_id, fnd_global.resp_id,
59: fnd_global.security_group_id,request_id,

Line 58: fnd_global.resp_appl_id, fnd_global.resp_id,

54: (
55: sid, fnd_global.user_id, fnd_global.login_id,
56: sysdate, function_name, substr(action_cnt || '|' || action_name, 1, 30),
57: substr(message_text, 1, ARGMAX),
58: fnd_global.resp_appl_id, fnd_global.resp_id,
59: fnd_global.security_group_id,request_id,
60: g_program_appl_id, g_program_id,
61: conc_queue_id, dbms_utility.get_time, s_type
62: );

Line 59: fnd_global.security_group_id,request_id,

55: sid, fnd_global.user_id, fnd_global.login_id,
56: sysdate, function_name, substr(action_cnt || '|' || action_name, 1, 30),
57: substr(message_text, 1, ARGMAX),
58: fnd_global.resp_appl_id, fnd_global.resp_id,
59: fnd_global.security_group_id,request_id,
60: g_program_appl_id, g_program_id,
61: conc_queue_id, dbms_utility.get_time, s_type
62: );
63:

Line 92: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id

88: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
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;

Line 109: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,

105: RUNNING_PROCESSES, TARGET_PROCESSES)
106: SELECT event_type, sysdate, request_id,
107: FCQ.application_id, queue_id,
108: fcp.application_id, fcp.concurrent_program_id,
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

Line 141: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,

137: INDEX (fcpp,FND_CONC_PROCESSOR_PROGRAMS_U2) */
138: 3, sysdate, request_id,
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,

Line 155: and fr.responsibility_id = fnd_global.resp_id

151: and fcpp.concurrent_program_id = fcp.concurrent_program_id
152: and fcpp.program_application_id = fcp.application_id
153: and fcp.application_id = fa.application_id
154: and fa.application_short_name = application
155: and fr.responsibility_id = fnd_global.resp_id
156: and fr.application_id = fnd_global.resp_appl_id
157: and fr.data_group_id = fcq.data_group_id
158: and fcq.manager_type = '3';
159: elsif ( event_type = 4 ) then

Line 156: and fr.application_id = fnd_global.resp_appl_id

152: and fcpp.program_application_id = fcp.application_id
153: and fcp.application_id = fa.application_id
154: and fa.application_short_name = application
155: and fr.responsibility_id = fnd_global.resp_id
156: and fr.application_id = fnd_global.resp_appl_id
157: and fr.data_group_id = fcq.data_group_id
158: and fcq.manager_type = '3';
159: elsif ( event_type = 4 ) then
160: /* mark timeout event (4) */

Line 181: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,

177: RUNNING_PROCESSES, TARGET_PROCESSES, NUMDATA)
178: SELECT 4, sysdate, request_id,
179: FCQ.application_id, fcq.concurrent_queue_id,
180: temp_fcp_application_id, temp_fcp_concurrent_program_id,
181: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id,
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

Line 192: fnd_global.user_id, fnd_global.resp_appl_id, fnd_global.resp_id, timeout

188: PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
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;

Line 410: secgrpid := fnd_global.security_group_id;

406: Where PARAMETER = 'NLS_NUMERIC_CHARACTERS';
407:
408:
409: --get security_group_id
410: secgrpid := fnd_global.security_group_id;
411:
412: if (enable_trace_flag = 'Y') then
413: enable_trace_flag := 'TRUE';
414: else