DBA Data[Home] [Help]

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: --10649674

Line 282: l_fnd_user_name := 'SYSADMIN';

278: IF c2%NOTFOUND
279: THEN
280: --10649674
281: if(p_person_id = -99) then
282: l_fnd_user_name := 'SYSADMIN';
283: else
284: hr_utility.TRACE ('fnd person does not exist ' || p_person_id);
285: wf_core.RAISE ('fnd person does not exist ' || p_person_id);
286: end if;

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

287: END IF;
288:
289: CLOSE c2;
290:
291: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);
292: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
293: 3000
294: );
295: RETURN l_fnd_user_name;

Line 295: RETURN l_fnd_user_name;

291: hr_utility.TRACE ('l_fnd_user_name : ' || l_fnd_user_name);
292: hr_utility.set_location ('Exiting ' || g_package || ' : ' || l_proc,
293: 3000
294: );
295: RETURN l_fnd_user_name;
296: EXCEPTION
297: WHEN OTHERS
298: THEN
299: /* wf_core.CONTEXT (g_package,

Line 300: 'get_fnd_user_name',

296: EXCEPTION
297: WHEN OTHERS
298: THEN
299: /* wf_core.CONTEXT (g_package,
300: 'get_fnd_user_name',
301: p_person_id,
302: 'Error occured in while getting the fnd_user_name'
303: );
304: RAISE;*/

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

298: THEN
299: /* wf_core.CONTEXT (g_package,
300: 'get_fnd_user_name',
301: p_person_id,
302: 'Error occured in while getting the fnd_user_name'
303: );
304: RAISE;*/
305:
306: return null;

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

311: -- get_curren_notification_id
312: -- This function gives the notification id for a paticular user.
313: -- IN
314: -- p_item_key -- the item key
315: -- p_fnd_user_name -- fnd user name to whom the notification was sent.
316: -- RETURN
317: -- notification id
318: --
319: FUNCTION get_current_notification_id (

Line 321: , p_fnd_user_name IN VARCHAR2

317: -- notification id
318: --
319: FUNCTION get_current_notification_id (
320: p_item_key IN VARCHAR2
321: , p_fnd_user_name IN VARCHAR2
322: )
323: RETURN NUMBER IS
324: l_notification_id NUMBER;
325: l_proc VARCHAR2 (100) := 'get_current_notification_id';

Line 332: AND assigned_user = p_fnd_user_name;

328: SELECT notification_id
329: FROM wf_item_activity_statuses
330: WHERE item_key = p_item_key
331: AND item_type = g_itemtype
332: AND assigned_user = p_fnd_user_name;
333: BEGIN
334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);

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

332: AND assigned_user = p_fnd_user_name;
333: BEGIN
334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');

Line 338: IF p_fnd_user_name IS NULL THEN

334: hr_utility.set_location ('Entering ' || g_package || ' : ' || l_proc, 2000);
335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');
341: END IF;
342:

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

335: hr_utility.TRACE ('p_item_key : ' || p_item_key);
336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');
341: END IF;
342:
343: OPEN c1;

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

336: hr_utility.TRACE ('p_fnd_user_name : ' || p_fnd_user_name);
337:
338: IF p_fnd_user_name IS NULL THEN
339: hr_utility.TRACE ('p_fnd_user_name is null');
340: wf_core.RAISE ('p_fnd_user_name is null');
341: END IF;
342:
343: OPEN c1;
344: FETCH c1 INTO l_notification_id;

Line 348: || p_fnd_user_name

344: FETCH c1 INTO l_notification_id;
345:
346: IF c1%NOTFOUND THEN
347: hr_utility.TRACE ( 'Notification id not present for the user '
348: || p_fnd_user_name
349: || 'for the item key'
350: || p_item_key);
351: wf_core.RAISE ( 'Notification id is not present for the user '
352: || p_fnd_user_name

Line 352: || p_fnd_user_name

348: || p_fnd_user_name
349: || 'for the item key'
350: || p_item_key);
351: wf_core.RAISE ( 'Notification id is not present for the user '
352: || p_fnd_user_name
353: || ' for the item key'
354: || p_item_key);
355: END IF;
356:

Line 366: , p_fnd_user_name

362: WHEN OTHERS THEN
363: wf_core.CONTEXT (g_package
364: , 'get_current_notification_id'
365: , p_item_key
366: , p_fnd_user_name
367: , 'Error occured in while getting the get_current_notification_id'
368: );
369: RAISE;
370: END;

Line 380: l_from_fnd_user_name VARCHAR2 (2000);

376: funcmode IN VARCHAR2,
377: RESULT OUT NOCOPY VARCHAR2
378: )
379: IS
380: l_from_fnd_user_name VARCHAR2 (2000);
381: l_notification_id VARCHAR2 (2000);
382: l_status VARCHAR2 (60);
383: BEGIN
384: l_from_fnd_user_name :=

Line 384: l_from_fnd_user_name :=

380: l_from_fnd_user_name VARCHAR2 (2000);
381: l_notification_id VARCHAR2 (2000);
382: l_status VARCHAR2 (60);
383: BEGIN
384: l_from_fnd_user_name :=
385: wf_engine.getitemattrtext (itemtype => 'BENCWBFY',
386: itemkey => itemkey,
387: aname => 'RCVR_USER_NAME'
388: );

Line 391: p_fnd_user_name => l_from_fnd_user_name

387: aname => 'RCVR_USER_NAME'
388: );
389: l_notification_id :=
390: get_current_notification_id (p_item_key => itemkey,
391: p_fnd_user_name => l_from_fnd_user_name
392: );
393:
394: BEGIN
395: SELECT n.status

Line 411: responder => l_from_fnd_user_name

407:
408: IF (l_status = 'OPEN')
409: THEN
410: wf_notification.CLOSE (nid => l_notification_id,
411: responder => l_from_fnd_user_name
412: );
413: END IF;
414: EXCEPTION
415: WHEN OTHERS

Line 437: l_rcvr_fnd_user_name VARCHAR2 (2000);

433: p_group_per_in_ler_id IN NUMBER,
434: p_transaction_id IN NUMBER
435: )
436: IS
437: l_rcvr_fnd_user_name VARCHAR2 (2000);
438: l_from_fnd_user_name VARCHAR2 (2000);
439: l_err_name VARCHAR2 (30);
440: l_err_msg VARCHAR2 (2000);
441: l_err_stack VARCHAR2 (32000);

Line 438: l_from_fnd_user_name VARCHAR2 (2000);

434: p_transaction_id IN NUMBER
435: )
436: IS
437: l_rcvr_fnd_user_name VARCHAR2 (2000);
438: l_from_fnd_user_name VARCHAR2 (2000);
439: l_err_name VARCHAR2 (30);
440: l_err_msg VARCHAR2 (2000);
441: l_err_stack VARCHAR2 (32000);
442: l_for_period VARCHAR2(30);

Line 447: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);

443: l_proc VARCHAR2 (100) := 'set_common_item_attributes';
444: BEGIN
445: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,
446: 100);
447: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
448: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
449:
450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);

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

444: BEGIN
445: hr_utility.set_location ('Entering ' || g_package || ':' || l_proc,
446: 100);
447: l_rcvr_fnd_user_name := get_fnd_user_name (p_rcvr_person_id);
448: hr_utility.TRACE ('l_rcvr_fnd_user_name ' || l_rcvr_fnd_user_name);
449:
450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);
452:

Line 453: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);

449:
450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);
452:
453: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);
454: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);
455:
456: wf_engine.setitemattrtext (itemtype => g_itemtype,
457: itemkey => p_item_key,

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

450: l_for_period := get_for_period (p_group_per_in_ler_id);
451: hr_utility.TRACE ('l_for_period ' || l_for_period);
452:
453: l_from_fnd_user_name := get_fnd_user_name (p_from_person_id);
454: hr_utility.TRACE ('l_from_fnd_user_name ' || l_from_fnd_user_name);
455:
456: wf_engine.setitemattrtext (itemtype => g_itemtype,
457: itemkey => p_item_key,
458: aname => 'MESSAGE_TYPE',

Line 467: avalue => l_rcvr_fnd_user_name

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

Line 470: || l_rcvr_fnd_user_name

466: aname => 'RCVR_USER_NAME',
467: avalue => l_rcvr_fnd_user_name
468: );
469: hr_utility.TRACE ( ' item attribute RCVR_USER_NAME is set to '
470: || l_rcvr_fnd_user_name
471: );
472: wf_engine.setitemattrtext (itemtype => g_itemtype,
473: itemkey => p_item_key,
474: aname => 'RCVR_PERSON_NAME',

Line 479: || l_rcvr_fnd_user_name

475: avalue => get_person_name
476: (p_group_per_in_ler_id)
477: );
478: hr_utility.TRACE ( ' item attribute RCVR_PERSON_NAME is set to '
479: || l_rcvr_fnd_user_name
480: );
481: wf_engine.setitemattrtext
482: (itemtype => 'BENCWBFY',
483: itemkey => p_item_key,

Line 525: avalue => l_from_fnd_user_name

521: );
522: wf_engine.setitemattrtext (itemtype => g_itemtype,
523: itemkey => p_item_key,
524: aname => 'FROM_ROLE',
525: avalue => l_from_fnd_user_name
526: );
527: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '
528: || l_from_fnd_user_name
529: );

Line 528: || l_from_fnd_user_name

524: aname => 'FROM_ROLE',
525: avalue => l_from_fnd_user_name
526: );
527: hr_utility.TRACE ( ' item attribute FROM_ROLE is set to '
528: || l_from_fnd_user_name
529: );
530: hr_utility.set_location ('Exiting ' || g_package || ':' || l_proc, 100);
531: END;
532:

Line 787: fnd_user usr,

783: SELECT pei.person_id person_id, ppf.full_name person_name,
784: usr.user_name user_name, usr.user_id user_id
785: FROM per_people_extra_info pei,
786: per_all_people_f ppf,
787: fnd_user usr,
788: pqh_roles rls
789: WHERE information_type = 'PQH_ROLE_USERS'
790: AND pei.person_id = ppf.person_id
791: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date