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 WF_ENGINE

Line 19: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

15: FROM ben_transaction
16: WHERE transaction_type = 'BDGTNTF'
17: AND transaction_id = to_number(v_transaction_id);
18: BEGIN
19: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',
20: itemkey => p_transaction_id,
21: aname => 'TRANSACTION_ID'
22: );
23: OPEN c1(l_transaction_id);

Line 49: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

45: FROM ben_transaction
46: WHERE transaction_type = 'APPRNTF'
47: AND transaction_id = to_number(v_transaction_id);
48: BEGIN
49: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',
50: itemkey => p_transaction_id,
51: aname => 'TRANSACTION_ID'
52: );
53: OPEN c1(l_transaction_id);

Line 78: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

74: SELECT attribute40
75: FROM ben_transaction
76: WHERE transaction_id = to_number(v_transaction_id);
77: BEGIN
78: l_transaction_id := wf_engine.getitemattrtext (itemtype => 'BENCWBFY',
79: itemkey => p_transaction_id,
80: aname => 'TRANSACTION_ID'
81: );
82: OPEN c1(l_transaction_id);

Line 385: wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

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: );
389: l_notification_id :=

Line 456: wf_engine.setitemattrtext (itemtype => g_itemtype,

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',
459: avalue => p_message_type
460: );

Line 464: wf_engine.setitemattrtext (itemtype => g_itemtype,

460: );
461: hr_utility.TRACE ( ' item attribute MESSAGE_TYPE is set to '
462: || p_message_type
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: );

Line 472: wf_engine.setitemattrtext (itemtype => g_itemtype,

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',
475: avalue => get_person_name
476: (p_group_per_in_ler_id)

Line 481: wf_engine.setitemattrtext

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,
484: aname => 'MANAGER_NAME',
485: avalue => get_worksheet_manager_name

Line 488: wf_engine.setitemattrtext

484: aname => 'MANAGER_NAME',
485: avalue => get_worksheet_manager_name
486: (p_group_per_in_ler_id)
487: );
488: wf_engine.setitemattrtext
489: (itemtype => 'BENCWBFY',
490: itemkey => p_item_key,
491: aname => 'PLAN_NAME',
492: avalue => get_plan_name

Line 495: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',

491: aname => 'PLAN_NAME',
492: avalue => get_plan_name
493: (p_group_per_in_ler_id)
494: );
495: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
496: itemkey => p_item_key,
497: aname => 'FOR_PERIOD',
498: avalue => l_for_period
499: );

Line 506: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',

502: || l_for_period
503: );
504:
505: hr_utility.TRACE (' item attribute PLAN_NAME is set ');
506: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
507: itemkey => p_item_key,
508: aname => 'GROUP_PER_IN_LER_ID',
509: avalue => p_group_per_in_ler_id
510: );

Line 514: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',

510: );
511: hr_utility.TRACE ( ' item attribute GROUP_PER_IN_LER_ID is set to '
512: || p_group_per_in_ler_id
513: );
514: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
515: itemkey => p_item_key,
516: aname => 'TRANSACTION_ID',
517: avalue => p_transaction_id
518: );

Line 522: wf_engine.setitemattrtext (itemtype => g_itemtype,

518: );
519: hr_utility.TRACE ( ' item attribute TRANSACTION_ID is set to '
520: || p_transaction_id
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: );

Line 538: wf_engine.setitemattrtext (itemtype => g_itemtype,

534: IS
535: BEGIN
536: hr_utility.TRACE ('p_item_key ' || p_item_key);
537:
538: wf_engine.setitemattrtext (itemtype => g_itemtype,
539: itemkey => p_item_key,
540: aname => 'FYI_COMMENTS',
541: avalue => get_access_ntf_comment(p_item_key)
542: );

Line 550: wf_engine.setitemattrtext (itemtype => g_itemtype,

546: IS
547: BEGIN
548: hr_utility.TRACE ('p_item_key ' || p_item_key);
549:
550: wf_engine.setitemattrtext (itemtype => g_itemtype,
551: itemkey => p_item_key,
552: aname => 'FYI_COMMENTS',
553: avalue => get_approve_ntf_comment(p_item_key)
554: );

Line 562: wf_engine.setitemattrtext (itemtype => g_itemtype,

558: IS
559: BEGIN
560: hr_utility.TRACE ('p_item_key ' || p_item_key);
561:
562: wf_engine.setitemattrtext (itemtype => g_itemtype,
563: itemkey => p_item_key,
564: aname => 'FYI_COMMENTS',
565: avalue => get_issue_bdgt_ntf_comment(p_item_key)
566: );

Line 613: wf_engine.createprocess (itemtype => g_itemtype,

609:
610: hr_utility.TRACE ('p_rcvr_person_id : ' || p_rcvr_person_id);
611:
612: BEGIN
613: wf_engine.createprocess (itemtype => g_itemtype,
614: itemkey => l_itemkey,
615: process => g_wfprocess
616: );
617: hr_utility.TRACE ( 'Workflow process '

Line 716: wf_engine.startprocess (itemtype => g_itemtype,

712: ('ws submitted item attributes are set successfully');
713: END IF;
714:
715: BEGIN
716: wf_engine.startprocess (itemtype => g_itemtype,
717: itemkey => l_itemkey);
718: hr_utility.TRACE ( 'Workflow process '
719: || g_wfprocess
720: || ' for itemtype '

Line 854: wf_engine.getitemattrtext (itemtype => itemtype,

850:
851: IF (funcmode = 'RUN')
852: THEN
853: l_message_type :=
854: wf_engine.getitemattrtext (itemtype => itemtype,
855: itemkey => itemkey,
856: aname => 'MESSAGE_TYPE'
857: );
858:

Line 909: wf_engine.getitemattrtext (itemtype => itemtype,

905: l_message_type VARCHAR2 (60);
906: l_proc VARCHAR2 (100) := 'is_notification_sent';
907: BEGIN
908: l_message_type :=
909: wf_engine.getitemattrtext (itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'MESSAGE_TYPE'
912: );
913: RESULT := 'COMPLETE:' || get_ntf_conf_value (l_message_type);