APPS.ISC_FS_EVENT_LOG_ETL_PKG dependencies on FND_GLOBAL

Line 80: , last_updated_by = fnd_global.user_id

76: begin
77:
78: update isc_fs_enable_events
79: set enabled = 'Y'
80: , last_updated_by = fnd_global.user_id
81: , last_update_date = sysdate
82: , last_update_login = fnd_global.login_id
83: , program_id = fnd_global.conc_program_id
84: , program_login_id = fnd_global.conc_login_id

Line 82: , last_update_login = fnd_global.login_id

78: update isc_fs_enable_events
79: set enabled = 'Y'
80: , last_updated_by = fnd_global.user_id
81: , last_update_date = sysdate
82: , last_update_login = fnd_global.login_id
83: , program_id = fnd_global.conc_program_id
84: , program_login_id = fnd_global.conc_login_id
85: , program_application_id = fnd_global.prog_appl_id
86: , request_id = fnd_global.conc_request_id;

Line 83: , program_id = fnd_global.conc_program_id

79: set enabled = 'Y'
80: , last_updated_by = fnd_global.user_id
81: , last_update_date = sysdate
82: , last_update_login = fnd_global.login_id
83: , program_id = fnd_global.conc_program_id
84: , program_login_id = fnd_global.conc_login_id
85: , program_application_id = fnd_global.prog_appl_id
86: , request_id = fnd_global.conc_request_id;
87:

Line 84: , program_login_id = fnd_global.conc_login_id

80: , last_updated_by = fnd_global.user_id
81: , last_update_date = sysdate
82: , last_update_login = fnd_global.login_id
83: , program_id = fnd_global.conc_program_id
84: , program_login_id = fnd_global.conc_login_id
85: , program_application_id = fnd_global.prog_appl_id
86: , request_id = fnd_global.conc_request_id;
87:
88: if sql%rowcount = 0 then

Line 85: , program_application_id = fnd_global.prog_appl_id

81: , last_update_date = sysdate
82: , last_update_login = fnd_global.login_id
83: , program_id = fnd_global.conc_program_id
84: , program_login_id = fnd_global.conc_login_id
85: , program_application_id = fnd_global.prog_appl_id
86: , request_id = fnd_global.conc_request_id;
87:
88: if sql%rowcount = 0 then
89:

Line 86: , request_id = fnd_global.conc_request_id;

82: , last_update_login = fnd_global.login_id
83: , program_id = fnd_global.conc_program_id
84: , program_login_id = fnd_global.conc_login_id
85: , program_application_id = fnd_global.prog_appl_id
86: , request_id = fnd_global.conc_request_id;
87:
88: if sql%rowcount = 0 then
89:
90: insert into

Line 105: , fnd_global.user_id

101: , request_id
102: )
103: values
104: ( 'Y'
105: , fnd_global.user_id
106: , sysdate
107: , fnd_global.user_id
108: , sysdate
109: , fnd_global.login_id

Line 107: , fnd_global.user_id

103: values
104: ( 'Y'
105: , fnd_global.user_id
106: , sysdate
107: , fnd_global.user_id
108: , sysdate
109: , fnd_global.login_id
110: , fnd_global.conc_program_id
111: , fnd_global.conc_login_id

Line 109: , fnd_global.login_id

105: , fnd_global.user_id
106: , sysdate
107: , fnd_global.user_id
108: , sysdate
109: , fnd_global.login_id
110: , fnd_global.conc_program_id
111: , fnd_global.conc_login_id
112: , fnd_global.prog_appl_id
113: , fnd_global.conc_request_id

Line 110: , fnd_global.conc_program_id

106: , sysdate
107: , fnd_global.user_id
108: , sysdate
109: , fnd_global.login_id
110: , fnd_global.conc_program_id
111: , fnd_global.conc_login_id
112: , fnd_global.prog_appl_id
113: , fnd_global.conc_request_id
114: );

Line 111: , fnd_global.conc_login_id

107: , fnd_global.user_id
108: , sysdate
109: , fnd_global.login_id
110: , fnd_global.conc_program_id
111: , fnd_global.conc_login_id
112: , fnd_global.prog_appl_id
113: , fnd_global.conc_request_id
114: );
115:

Line 112: , fnd_global.prog_appl_id

108: , sysdate
109: , fnd_global.login_id
110: , fnd_global.conc_program_id
111: , fnd_global.conc_login_id
112: , fnd_global.prog_appl_id
113: , fnd_global.conc_request_id
114: );
115:
116: end if;

Line 113: , fnd_global.conc_request_id

109: , fnd_global.login_id
110: , fnd_global.conc_program_id
111: , fnd_global.conc_login_id
112: , fnd_global.prog_appl_id
113: , fnd_global.conc_request_id
114: );
115:
116: end if;
117:

Line 195: , fnd_global.user_id

191: , l_source_object_type_code
192: , l_source_object_id
193: , l_task_id
194: , l_task_audit_id
195: , fnd_global.user_id
196: , sysdate
197: , fnd_global.user_id
198: , sysdate
199: , fnd_global.login_id

Line 197: , fnd_global.user_id

193: , l_task_id
194: , l_task_audit_id
195: , fnd_global.user_id
196: , sysdate
197: , fnd_global.user_id
198: , sysdate
199: , fnd_global.login_id
200: );
201: end if;

Line 199: , fnd_global.login_id

195: , fnd_global.user_id
196: , sysdate
197: , fnd_global.user_id
198: , sysdate
199: , fnd_global.login_id
200: );
201: end if;
202:
203: end if;

Line 299: , fnd_global.user_id

295: , l_source_object_type_code
296: , l_source_object_id
297: , l_task_id
298: , l_task_assignment_id
299: , fnd_global.user_id
300: , sysdate
301: , fnd_global.user_id
302: , sysdate
303: , fnd_global.login_id

Line 301: , fnd_global.user_id

297: , l_task_id
298: , l_task_assignment_id
299: , fnd_global.user_id
300: , sysdate
301: , fnd_global.user_id
302: , sysdate
303: , fnd_global.login_id
304: );
305:

Line 303: , fnd_global.login_id

299: , fnd_global.user_id
300: , sysdate
301: , fnd_global.user_id
302: , sysdate
303: , fnd_global.login_id
304: );
305:
306: end if;
307: close c_task;

Line 398: , fnd_global.user_id

394: , l_event_name
395: , t.source_object_type_code
396: , t.source_object_id
397: , t.task_id
398: , fnd_global.user_id
399: , sysdate
400: , fnd_global.user_id
401: , sysdate
402: , fnd_global.login_id

Line 400: , fnd_global.user_id

396: , t.source_object_id
397: , t.task_id
398: , fnd_global.user_id
399: , sysdate
400: , fnd_global.user_id
401: , sysdate
402: , fnd_global.login_id
403: from
404: cs_incidents_audit_b a

Line 402: , fnd_global.login_id

398: , fnd_global.user_id
399: , sysdate
400: , fnd_global.user_id
401: , sysdate
402: , fnd_global.login_id
403: from
404: cs_incidents_audit_b a
405: , jtf_tasks_b t
406: where