eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FUNCTION_SECURITY_CACHE dependencies on WF_PARAMETER_LIST_T

Line 4: procedure raise_event(p_event_name in varchar2, p_event_key in varchar2 ,p_parameters in wf_parameter_list_t default NULL)

1: package body FND_FUNCTION_SECURITY_CACHE as
2: /* $Header: AFFSCIB.pls 120.2 2005/11/09 07:05:07 rosthoma ship $ */
3:
4: procedure raise_event(p_event_name in varchar2, p_event_key in varchar2 ,p_parameters in wf_parameter_list_t default NULL)
5: is
6: begin
7: wf_event.raise(p_event_name=>p_event_name,p_event_key=>p_event_key,p_parameters => p_parameters);
8: -- dbms_output.put_line('['||p_event_name||']['||p_event_key||']');

Line 14: l_parameters wf_parameter_list_t := wf_parameter_list_t();

10: end;
11:
12: procedure delete_function(p_function_id in number)
13: is
14: l_parameters wf_parameter_list_t := wf_parameter_list_t();
15: begin
16: wf_event.addparametertolist(p_name => 'FND_FUNCTION_ID',
17: p_value => p_function_id,
18: p_parameterlist => l_parameters);

Line 26: l_parameters wf_parameter_list_t := wf_parameter_list_t();

22: end;
23:
24: procedure insert_function(p_function_id in number)
25: is
26: l_parameters wf_parameter_list_t := wf_parameter_list_t();
27: begin
28: wf_event.addparametertolist(p_name => 'FND_FUNCTION_ID',
29: p_value => p_function_id,
30: p_parameterlist => l_parameters);

Line 39: l_parameters wf_parameter_list_t := wf_parameter_list_t();

35: end;
36:
37: procedure update_function(p_function_id in number)
38: is
39: l_parameters wf_parameter_list_t := wf_parameter_list_t();
40: begin
41: wf_event.addparametertolist(p_name => 'FND_FUNCTION_ID',
42: p_value => p_function_id,
43: p_parameterlist => l_parameters);

Line 54: l_parameters wf_parameter_list_t := wf_parameter_list_t();

50:
51: procedure delete_grant(p_grant_guid in raw, p_grantee_type in varchar2,
52: p_grantee_key in varchar2)
53: is
54: l_parameters wf_parameter_list_t := wf_parameter_list_t();
55: begin
56: wf_event.addparametertolist(p_name => 'FND_GRANT_GUID',
57: p_value => p_grant_guid,
58: p_parameterlist => l_parameters);

Line 77: l_parameters wf_parameter_list_t := wf_parameter_list_t();

73:
74: procedure insert_grant(p_grant_guid in raw, p_grantee_type in varchar2,
75: p_grantee_key in varchar2)
76: is
77: l_parameters wf_parameter_list_t := wf_parameter_list_t();
78: begin
79: wf_event.addparametertolist(p_name => 'FND_GRANT_GUID',
80: p_value => p_grant_guid,
81: p_parameterlist => l_parameters);

Line 100: l_parameters wf_parameter_list_t := wf_parameter_list_t();

96:
97: procedure update_grant(p_grant_guid in raw, p_grantee_type in varchar2,
98: p_grantee_key in varchar2)
99: is
100: l_parameters wf_parameter_list_t := wf_parameter_list_t();
101: begin
102: wf_event.addparametertolist(p_name => 'FND_GRANT_GUID',
103: p_value => p_grant_guid,
104: p_parameterlist => l_parameters);

Line 122: l_parameters wf_parameter_list_t := wf_parameter_list_t();

118: end;
119:
120: procedure delete_menu(p_menu_id in number)
121: is
122: l_parameters wf_parameter_list_t := wf_parameter_list_t();
123: begin
124:
125: wf_event.addparametertolist(p_name => 'FND_MENU_ID',
126: p_value => p_menu_id,

Line 136: l_parameters wf_parameter_list_t := wf_parameter_list_t();

132: end;
133:
134: procedure insert_menu(p_menu_id in number)
135: is
136: l_parameters wf_parameter_list_t := wf_parameter_list_t();
137: begin
138: wf_event.addparametertolist(p_name => 'FND_MENU_ID',
139: p_value => p_menu_id,
140: p_parameterlist => l_parameters);

Line 149: l_parameters wf_parameter_list_t := wf_parameter_list_t();

145: end;
146:
147: procedure update_menu(p_menu_id in number)
148: is
149: l_parameters wf_parameter_list_t := wf_parameter_list_t();
150: begin
151:
152: wf_event.addparametertolist(p_name => 'FND_MENU_ID',
153: p_value => p_menu_id,

Line 164: l_parameters wf_parameter_list_t := wf_parameter_list_t();

160:
161: procedure delete_menu_entry(p_menu_id in number, p_sub_menu_id in number,
162: p_function_id in number)
163: is
164: l_parameters wf_parameter_list_t := wf_parameter_list_t();
165: begin
166: update_menu(p_menu_id);
167: wf_event.addparametertolist(p_name => 'FND_MENU_ID',
168: p_value => p_menu_id,

Line 190: l_parameters wf_parameter_list_t := wf_parameter_list_t();

186:
187: procedure insert_menu_entry(p_menu_id in number, p_sub_menu_id in number,
188: p_function_id in number)
189: is
190: l_parameters wf_parameter_list_t := wf_parameter_list_t();
191: begin
192: update_menu(p_menu_id);
193:
194: wf_event.addparametertolist(p_name => 'FND_MENU_ID',

Line 215: l_parameters wf_parameter_list_t := wf_parameter_list_t();

211:
212: procedure update_menu_entry(p_menu_id in number, p_sub_menu_id in number,
213: p_function_id in number)
214: is
215: l_parameters wf_parameter_list_t := wf_parameter_list_t();
216: begin
217: update_menu(p_menu_id);
218:
219: wf_event.addparametertolist(p_name => 'FND_MENU_ID',

Line 239: l_parameters wf_parameter_list_t := wf_parameter_list_t();

235: end;
236:
237: procedure delete_resp(p_resp_id in number, p_resp_appl_id in number)
238: is
239: l_parameters wf_parameter_list_t := wf_parameter_list_t();
240: begin
241:
242: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
243: p_value => p_resp_id,

Line 257: l_parameters wf_parameter_list_t := wf_parameter_list_t();

253: end;
254:
255: procedure insert_resp(p_resp_id in number, p_resp_appl_id in number)
256: is
257: l_parameters wf_parameter_list_t := wf_parameter_list_t();
258: begin
259:
260: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
261: p_value => p_resp_id,

Line 275: l_parameters wf_parameter_list_t := wf_parameter_list_t();

271: end;
272:
273: procedure update_resp(p_resp_id in number, p_resp_appl_id in number)
274: is
275: l_parameters wf_parameter_list_t := wf_parameter_list_t();
276: begin
277:
278: wf_event.addparametertolist(p_name => 'FND_RESPONSIBILITY_ID',
279: p_value => p_resp_id,

Line 293: l_parameters wf_parameter_list_t := wf_parameter_list_t();

289: end;
290:
291: procedure delete_secgrp(p_security_group_id in number)
292: is
293: l_parameters wf_parameter_list_t := wf_parameter_list_t();
294: begin
295:
296: wf_event.addparametertolist(p_name => 'FND_SECURITY_GROUP_ID',
297: p_value => p_security_group_id,

Line 307: l_parameters wf_parameter_list_t := wf_parameter_list_t();

303: end;
304:
305: procedure insert_secgrp(p_security_group_id in number)
306: is
307: l_parameters wf_parameter_list_t := wf_parameter_list_t();
308: begin
309: wf_event.addparametertolist(p_name => 'FND_SECURITY_GROUP_ID',
310: p_value => p_security_group_id,
311: p_parameterlist => l_parameters);

Line 320: l_parameters wf_parameter_list_t := wf_parameter_list_t();

316: end;
317:
318: procedure update_secgrp(p_security_group_id in number)
319: is
320: l_parameters wf_parameter_list_t := wf_parameter_list_t();
321: begin
322:
323: wf_event.addparametertolist(p_name => 'FND_SECURITY_GROUP_ID',
324: p_value => p_security_group_id,

Line 334: l_parameters wf_parameter_list_t := wf_parameter_list_t();

330: end;
331:
332: procedure delete_user(p_user_id in number)
333: is
334: l_parameters wf_parameter_list_t := wf_parameter_list_t();
335: begin
336: wf_event.addparametertolist(p_name => 'FND_USER_ID',
337: p_value => p_user_id,
338: p_parameterlist => l_parameters);

Line 347: l_parameters wf_parameter_list_t := wf_parameter_list_t();

343: end;
344:
345: procedure insert_user(p_user_id in number)
346: is
347: l_parameters wf_parameter_list_t := wf_parameter_list_t();
348: begin
349: raise_event(p_event_name=>'oracle.apps.fnd.user.insert',
350: p_event_key=>to_char(p_user_id),
351: p_parameters => l_parameters);

Line 356: l_parameters wf_parameter_list_t := wf_parameter_list_t();

352: end;
353:
354: procedure update_user(p_user_id in number)
355: is
356: l_parameters wf_parameter_list_t := wf_parameter_list_t();
357: begin
358:
359: wf_event.addparametertolist(p_name => 'FND_USER_ID',
360: p_value => p_user_id,

Line 391: l_parameters wf_parameter_list_t := wf_parameter_list_t();

387: end;
388:
389: procedure delete_user_role(p_user_id in number, p_role_name in varchar2)
390: is
391: l_parameters wf_parameter_list_t := wf_parameter_list_t();
392: begin
393: wf_event.addparametertolist(p_name => 'FND_USER_ID',
394: p_value => p_user_id,
395: p_parameterlist => l_parameters);

Line 409: l_parameters wf_parameter_list_t := wf_parameter_list_t();

405: end;
406:
407: procedure insert_user_role(p_user_id in number, p_role_name in varchar2)
408: is
409: l_parameters wf_parameter_list_t := wf_parameter_list_t();
410: begin
411:
412: wf_event.addparametertolist(p_name => 'FND_USER_ID',
413: p_value => p_user_id,

Line 429: l_parameters wf_parameter_list_t := wf_parameter_list_t();

425: end;
426:
427: procedure update_user_role(p_user_id in number, p_role_name in varchar2)
428: is
429: l_parameters wf_parameter_list_t := wf_parameter_list_t();
430: begin
431:
432: wf_event.addparametertolist(p_name => 'FND_USER_ID',
433: p_value => p_user_id,