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.BEN_CWB_WF_NTF dependencies on FND_USER

Line 256: FUNCTION get_fnd_user_name (p_person_id IN NUMBER)

252:
253: RETURN ret_val;
254: END;
255:
256: FUNCTION get_fnd_user_name (p_person_id IN NUMBER)
257: RETURN VARCHAR2
258: IS
259: l_fnd_user_name VARCHAR2 (2000);
260: l_proc VARCHAR2 (100) := 'get_fnd_user_name';

Line 259: l_fnd_user_name VARCHAR2 (2000);

255:
256: FUNCTION get_fnd_user_name (p_person_id IN NUMBER)
257: RETURN VARCHAR2
258: IS
259: l_fnd_user_name VARCHAR2 (2000);
260: l_proc VARCHAR2 (100) := 'get_fnd_user_name';
261:
262: CURSOR c2
263: IS

Line 260: l_proc VARCHAR2 (100) := 'get_fnd_user_name';

256: FUNCTION get_fnd_user_name (p_person_id IN NUMBER)
257: RETURN VARCHAR2
258: IS
259: l_fnd_user_name VARCHAR2 (2000);
260: l_proc VARCHAR2 (100) := 'get_fnd_user_name';
261:
262: CURSOR c2
263: IS
264: SELECT user_name

Line 265: FROM fnd_user

261:
262: CURSOR c2
263: IS
264: SELECT user_name
265: FROM fnd_user
266: WHERE employee_id = p_person_id;
267: BEGIN
268: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc,
269: 3000

Line 276: INTO l_fnd_user_name;

272:
273: OPEN c2;
274:
275: FETCH c2
276: INTO l_fnd_user_name;
277:
278: IF c2%NOTFOUND
279: THEN
280: hr_utility.TRACE ('fnd person does not exist ' || p_person_id);

Line 286: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);

282: END IF;
283:
284: CLOSE c2;
285:
286: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);
287: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
288: 3000
289: );
290: RETURN l_fnd_user_name;

Line 290: RETURN l_fnd_user_name;

286: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);
287: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
288: 3000
289: );
290: RETURN l_fnd_user_name;
291: EXCEPTION
292: WHEN OTHERS
293: THEN
294: /* wf_core.CONTEXT (g_package,

Line 295: 'get_fnd_user_name',

291: EXCEPTION
292: WHEN OTHERS
293: THEN
294: /* wf_core.CONTEXT (g_package,
295: 'get_fnd_user_name',
296: p_person_id,
297: 'Error occured in while getting the fnd_user_name'
298: );
299: RAISE;*/

Line 297: 'Error occured in while getting the fnd_user_name'

293: THEN
294: /* wf_core.CONTEXT (g_package,
295: 'get_fnd_user_name',
296: p_person_id,
297: 'Error occured in while getting the fnd_user_name'
298: );
299: RAISE;*/
300:
301: return null;

Line 310: -- p_fnd_user_name -- fnd user name to whom the notification was sent.

306: -- get_curren_notification_id
307: -- This function gives the notification id for a paticular user.
308: -- IN
309: -- p_item_key -- the item key
310: -- p_fnd_user_name -- fnd user name to whom the notification was sent.
311: -- RETURN
312: -- notification id
313: --
314: FUNCTION get_current_notification_id (

Line 316: , p_fnd_user_name IN VARCHAR2

312: -- notification id
313: --
314: FUNCTION get_current_notification_id (
315: p_item_key IN VARCHAR2
316: , p_fnd_user_name IN VARCHAR2
317: )
318: RETURN NUMBER IS
319: l_notification_id NUMBER;
320: l_proc VARCHAR2 (100) := 'get_current_notification_id';

Line 327: AND assigned_user = p_fnd_user_name;

323: SELECT notification_id
324: FROM wf_item_activity_statuses
325: WHERE item_key = p_item_key
326: AND item_type = g_itemtype
327: AND assigned_user = p_fnd_user_name;
328: BEGIN
329: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
330: hr_utility.TRACE ('p_item_key : ' || p_item_key);
331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);

Line 331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);

327: AND assigned_user = p_fnd_user_name;
328: BEGIN
329: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
330: hr_utility.TRACE ('p_item_key : ' || p_item_key);
331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
332:
333: IF p_fnd_user_name IS NULL THEN
334: hr_utility.TRACE ('p_fnd_user_name is null');
335: wf_core.RAISE ('p_fnd_user_name is null');

Line 333: IF p_fnd_user_name IS NULL THEN

329: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
330: hr_utility.TRACE ('p_item_key : ' || p_item_key);
331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
332:
333: IF p_fnd_user_name IS NULL THEN
334: hr_utility.TRACE ('p_fnd_user_name is null');
335: wf_core.RAISE ('p_fnd_user_name is null');
336: END IF;
337:

Line 334: hr_utility.TRACE ('p_fnd_user_name is null');

330: hr_utility.TRACE ('p_item_key : ' || p_item_key);
331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
332:
333: IF p_fnd_user_name IS NULL THEN
334: hr_utility.TRACE ('p_fnd_user_name is null');
335: wf_core.RAISE ('p_fnd_user_name is null');
336: END IF;
337:
338: OPEN c1;

Line 335: wf_core.RAISE ('p_fnd_user_name is null');

331: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
332:
333: IF p_fnd_user_name IS NULL THEN
334: hr_utility.TRACE ('p_fnd_user_name is null');
335: wf_core.RAISE ('p_fnd_user_name is null');
336: END IF;
337:
338: OPEN c1;
339: FETCH c1 INTO l_notification_id;

Line 343: || p_fnd_user_name

339: FETCH c1 INTO l_notification_id;
340:
341: IF c1%NOTFOUND THEN
342: hr_utility.TRACE ( 'Notification id not present for the user '
343: || p_fnd_user_name
344: || 'for the item key'
345: || p_item_key);
346: wf_core.RAISE ( 'Notification id is not present for the user '
347: || p_fnd_user_name

Line 347: || p_fnd_user_name

343: || p_fnd_user_name
344: || 'for the item key'
345: || p_item_key);
346: wf_core.RAISE ( 'Notification id is not present for the user '
347: || p_fnd_user_name
348: || ' for the item key'
349: || p_item_key);
350: END IF;
351:

Line 361: , p_fnd_user_name

357: WHEN OTHERS THEN
358: wf_core.CONTEXT (g_package
359: , 'get_current_notification_id'
360: , p_item_key
361: , p_fnd_user_name
362: , 'Error occured in while getting the get_current_notification_id'
363: );
364: RAISE;
365: END;

Line 375: l_from_fnd_user_name VARCHAR2 (2000);

371: funcmode IN VARCHAR2,
372: RESULT OUT NOCOPY VARCHAR2
373: )
374: IS
375: l_from_fnd_user_name VARCHAR2 (2000);
376: l_notification_id VARCHAR2 (2000);
377: l_status VARCHAR2 (60);
378: BEGIN
379: l_from_fnd_user_name :=

Line 379: l_from_fnd_user_name :=

375: l_from_fnd_user_name VARCHAR2 (2000);
376: l_notification_id VARCHAR2 (2000);
377: l_status VARCHAR2 (60);
378: BEGIN
379: l_from_fnd_user_name :=
380: wf_engine.getitemattrtext (itemtype => 'BENCWBFY',
381: itemkey => itemkey,
382: aname => 'RCVR_USER_NAME'
383: );

Line 386: p_fnd_user_name => l_from_fnd_user_name

382: aname => 'RCVR_USER_NAME'
383: );
384: l_notification_id :=
385: get_current_notification_id (p_item_key => itemkey,
386: p_fnd_user_name => l_from_fnd_user_name
387: );
388:
389: BEGIN
390: SELECT n.status

Line 406: responder => l_from_fnd_user_name

402:
403: IF (l_status = 'OPEN')
404: THEN
405: wf_notification.CLOSE (nid => l_notification_id,
406: responder => l_from_fnd_user_name
407: );
408: END IF;
409: EXCEPTION
410: WHEN OTHERS

Line 432: l_rcvr_fnd_user_name VARCHAR2 (2000);

428: p_group_per_in_ler_id IN NUMBER,
429: p_transaction_id IN NUMBER
430: )
431: IS
432: l_rcvr_fnd_user_name VARCHAR2 (2000);
433: l_from_fnd_user_name VARCHAR2 (2000);
434: l_err_name VARCHAR2 (30);
435: l_err_msg VARCHAR2 (2000);
436: l_err_stack VARCHAR2 (32000);

Line 433: l_from_fnd_user_name VARCHAR2 (2000);

429: p_transaction_id IN NUMBER
430: )
431: IS
432: l_rcvr_fnd_user_name VARCHAR2 (2000);
433: l_from_fnd_user_name VARCHAR2 (2000);
434: l_err_name VARCHAR2 (30);
435: l_err_msg VARCHAR2 (2000);
436: l_err_stack VARCHAR2 (32000);
437: l_for_period VARCHAR2(30);

Line 442: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);

438: l_proc VARCHAR2 (100) := 'set_common_item_attributes';
439: BEGIN
440: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,
441: 100);
442: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
443: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
444:
445: l_for_period := get_for_period (p_group_per_in_ler_id);
446: hr_utility.TRACE ('l_for_period ' || l_for_period);

Line 443: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);

439: BEGIN
440: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,
441: 100);
442: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
443: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
444:
445: l_for_period := get_for_period (p_group_per_in_ler_id);
446: hr_utility.TRACE ('l_for_period ' || l_for_period);
447:

Line 448: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);

444:
445: l_for_period := get_for_period (p_group_per_in_ler_id);
446: hr_utility.TRACE ('l_for_period ' || l_for_period);
447:
448: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);
449: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);
450:
451: wf_engine.setitemattrtext (itemtype => g_itemtype,
452: itemkey => p_item_key,

Line 449: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);

445: l_for_period := get_for_period (p_group_per_in_ler_id);
446: hr_utility.TRACE ('l_for_period ' || l_for_period);
447:
448: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);
449: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);
450:
451: wf_engine.setitemattrtext (itemtype => g_itemtype,
452: itemkey => p_item_key,
453: aname => 'MESSAGE_TYPE',

Line 462: avalue => l_rcvr_fnd_user_name

458: );
459: wf_engine.setitemattrtext (itemtype => g_itemtype,
460: itemkey => p_item_key,
461: aname => 'RCVR_USER_NAME',
462: avalue => l_rcvr_fnd_user_name
463: );
464: hr_utility.TRACE ( ' item attribute RCVR_USER_NAME is set to '
465: || l_rcvr_fnd_user_name
466: );

Line 465: || l_rcvr_fnd_user_name

461: aname => 'RCVR_USER_NAME',
462: avalue => l_rcvr_fnd_user_name
463: );
464: hr_utility.TRACE ( ' item attribute RCVR_USER_NAME is set to '
465: || l_rcvr_fnd_user_name
466: );
467: wf_engine.setitemattrtext (itemtype => g_itemtype,
468: itemkey => p_item_key,
469: aname => 'RCVR_PERSON_NAME',

Line 474: || l_rcvr_fnd_user_name

470: avalue => get_person_name
471: (p_group_per_in_ler_id)
472: );
473: hr_utility.TRACE ( ' item attribute RCVR_PERSON_NAME is set to '
474: || l_rcvr_fnd_user_name
475: );
476: wf_engine.setitemattrtext
477: (itemtype => 'BENCWBFY',
478: itemkey => p_item_key,

Line 520: avalue => l_from_fnd_user_name

516: );
517: wf_engine.setitemattrtext (itemtype => g_itemtype,
518: itemkey => p_item_key,
519: aname => 'FROM_ROLE',
520: avalue => l_from_fnd_user_name
521: );
522: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '
523: || l_from_fnd_user_name
524: );

Line 523: || l_from_fnd_user_name

519: aname => 'FROM_ROLE',
520: avalue => l_from_fnd_user_name
521: );
522: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '
523: || l_from_fnd_user_name
524: );
525: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 100);
526: END;
527:

Line 782: fnd_user usr,

778: SELECT pei.person_id person_id, ppf.full_name person_name,
779: usr.user_name user_name, usr.user_id user_id
780: FROM per_people_extra_info pei,
781: per_all_people_f ppf,
782: fnd_user usr,
783: pqh_roles rls
784: WHERE information_type = 'PQH_ROLE_USERS'
785: AND pei.person_id = ppf.person_id
786: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date