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 380: wf_engine.getitemattrtext (itemtype => 'BENCWBFY',

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

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

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

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

455: );
456: hr_utility.TRACE ( ' item attribute MESSAGE_TYPE is set to '
457: || p_message_type
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: );

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

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

Line 476: wf_engine.setitemattrtext

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

Line 483: wf_engine.setitemattrtext

479: aname => 'MANAGER_NAME',
480: avalue => get_worksheet_manager_name
481: (p_group_per_in_ler_id)
482: );
483: wf_engine.setitemattrtext
484: (itemtype => 'BENCWBFY',
485: itemkey => p_item_key,
486: aname => 'PLAN_NAME',
487: avalue => get_plan_name

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

486: aname => 'PLAN_NAME',
487: avalue => get_plan_name
488: (p_group_per_in_ler_id)
489: );
490: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
491: itemkey => p_item_key,
492: aname => 'FOR_PERIOD',
493: avalue => l_for_period
494: );

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

497: || l_for_period
498: );
499:
500: hr_utility.TRACE (' item attribute PLAN_NAME is set ');
501: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
502: itemkey => p_item_key,
503: aname => 'GROUP_PER_IN_LER_ID',
504: avalue => p_group_per_in_ler_id
505: );

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

505: );
506: hr_utility.TRACE ( ' item attribute GROUP_PER_IN_LER_ID is set to '
507: || p_group_per_in_ler_id
508: );
509: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
510: itemkey => p_item_key,
511: aname => 'TRANSACTION_ID',
512: avalue => p_transaction_id
513: );

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

513: );
514: hr_utility.TRACE ( ' item attribute TRANSACTION_ID is set to '
515: || p_transaction_id
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: );

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

529: IS
530: BEGIN
531: hr_utility.TRACE ('p_item_key ' || p_item_key);
532:
533: wf_engine.setitemattrtext (itemtype => g_itemtype,
534: itemkey => p_item_key,
535: aname => 'FYI_COMMENTS',
536: avalue => get_access_ntf_comment(p_item_key)
537: );

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

541: IS
542: BEGIN
543: hr_utility.TRACE ('p_item_key ' || p_item_key);
544:
545: wf_engine.setitemattrtext (itemtype => g_itemtype,
546: itemkey => p_item_key,
547: aname => 'FYI_COMMENTS',
548: avalue => get_approve_ntf_comment(p_item_key)
549: );

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

553: IS
554: BEGIN
555: hr_utility.TRACE ('p_item_key ' || p_item_key);
556:
557: wf_engine.setitemattrtext (itemtype => g_itemtype,
558: itemkey => p_item_key,
559: aname => 'FYI_COMMENTS',
560: avalue => get_issue_bdgt_ntf_comment(p_item_key)
561: );

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

604:
605: hr_utility.TRACE ('p_rcvr_person_id : ' || p_rcvr_person_id);
606:
607: BEGIN
608: wf_engine.createprocess (itemtype => g_itemtype,
609: itemkey => l_itemkey,
610: process => g_wfprocess
611: );
612: hr_utility.TRACE ( 'Workflow process '

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

707: ('ws submitted item attributes are set successfully');
708: END IF;
709:
710: BEGIN
711: wf_engine.startprocess (itemtype => g_itemtype,
712: itemkey => l_itemkey);
713: hr_utility.TRACE ( 'Workflow process '
714: || g_wfprocess
715: || ' for itemtype '

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

845:
846: IF (funcmode = 'RUN')
847: THEN
848: l_message_type :=
849: wf_engine.getitemattrtext (itemtype => itemtype,
850: itemkey => itemkey,
851: aname => 'MESSAGE_TYPE'
852: );
853:

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

900: l_message_type VARCHAR2 (60);
901: l_proc VARCHAR2 (100) := 'is_notification_sent';
902: BEGIN
903: l_message_type :=
904: wf_engine.getitemattrtext (itemtype => itemtype,
905: itemkey => itemkey,
906: aname => 'MESSAGE_TYPE'
907: );
908: RESULT := 'COMPLETE:' || get_ntf_conf_value (l_message_type);