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.EGO_GROUP_WF_PKG dependencies on WF_ENGINE

Line 566: wf_engine.SetItemAttrNumber( itemtype => p_item_type,

562: mdebug('setting attribute: '|| l_names_tbl(i) || ' value - ' || l_values_tbl(i));
563: IF( l_names_tbl(i) = G_OWNER_ID ) THEN
564: l_owner_id := To_number(l_values_tbl(i));
565: --set owner id as the item level attribute
566: wf_engine.SetItemAttrNumber( itemtype => p_item_type,
567: itemkey => p_item_key,
568: aname => G_OWNER_ID,
569: avalue => To_number(l_values_tbl(i)));
570:

Line 574: wf_engine.SetItemAttrText( itemtype => p_item_type,

570:
571: ELSIF (l_names_tbl(i) = G_OWNER_NAME ) THEN
572: l_owner_name := l_values_tbl(i);
573: --set owner name as the item level attribute
574: wf_engine.SetItemAttrText( itemtype => p_item_type,
575: itemkey => p_item_key,
576: aname => G_OWNER_NAME,
577: avalue => l_values_tbl(i));
578: ELSIF (l_names_tbl(i) = G_OWNER_USER_NAME ) THEN

Line 581: wf_engine.SetItemAttrText( itemtype => p_item_type,

577: avalue => l_values_tbl(i));
578: ELSIF (l_names_tbl(i) = G_OWNER_USER_NAME ) THEN
579: l_owner_user_name := l_values_tbl(i);
580: --set owner user name as the item level attribute
581: wf_engine.SetItemAttrText( itemtype => p_item_type,
582: itemkey => p_item_key,
583: aname => G_OWNER_USER_NAME,
584: avalue => l_values_tbl(i));
585: ELSIF( l_names_tbl(i) = G_GROUP_ID ) THEN

Line 588: wf_engine.SetItemAttrNumber( itemtype => p_item_type,

584: avalue => l_values_tbl(i));
585: ELSIF( l_names_tbl(i) = G_GROUP_ID ) THEN
586: l_group_id := To_number(l_values_tbl(i));
587: --set group id as the item level attribute
588: wf_engine.SetItemAttrNumber( itemtype => p_item_type,
589: itemkey => p_item_key,
590: aname => G_GROUP_ID,
591: avalue => To_number(l_values_tbl(i)));
592: ELSIF (l_names_tbl(i) = G_GROUP_NAME ) THEN

Line 595: wf_engine.SetItemAttrText( itemtype => p_item_type,

591: avalue => To_number(l_values_tbl(i)));
592: ELSIF (l_names_tbl(i) = G_GROUP_NAME ) THEN
593: l_group_name := l_values_tbl(i);
594: --set group name as the item level attribute
595: wf_engine.SetItemAttrText( itemtype => p_item_type,
596: itemkey => p_item_key,
597: aname => G_GROUP_NAME,
598: avalue => l_values_tbl(i));
599: ELSIF( l_names_tbl(i) = G_MEMBER_ID ) THEN

Line 602: wf_engine.SetItemAttrNumber( itemtype => p_item_type,

598: avalue => l_values_tbl(i));
599: ELSIF( l_names_tbl(i) = G_MEMBER_ID ) THEN
600: l_member_id := To_number(l_values_tbl(i));
601: --set member id as the item level attribute
602: wf_engine.SetItemAttrNumber( itemtype => p_item_type,
603: itemkey => p_item_key,
604: aname => G_MEMBER_ID,
605: avalue => To_number(l_values_tbl(i)));
606: ELSIF (l_names_tbl(i) = G_MEMBER_NAME ) THEN

Line 609: wf_engine.SetItemAttrText( itemtype => p_item_type,

605: avalue => To_number(l_values_tbl(i)));
606: ELSIF (l_names_tbl(i) = G_MEMBER_NAME ) THEN
607: l_member_name := l_values_tbl(i);
608: --set member name as the item level attribute
609: wf_engine.SetItemAttrText( itemtype => p_item_type,
610: itemkey => p_item_key,
611: aname => G_MEMBER_NAME,
612: avalue => l_values_tbl(i));
613: ELSIF (l_names_tbl(i) = G_MEMBER_USER_NAME ) THEN

Line 616: wf_engine.SetItemAttrText( itemtype => p_item_type,

612: avalue => l_values_tbl(i));
613: ELSIF (l_names_tbl(i) = G_MEMBER_USER_NAME ) THEN
614: l_member_user_name := l_values_tbl(i);
615: --set member user name as the item level attribute
616: wf_engine.SetItemAttrText( itemtype => p_item_type,
617: itemkey => p_item_key,
618: aname => G_MEMBER_USER_NAME,
619: avalue => l_values_tbl(i));
620: ELSIF( l_names_tbl(i) = G_GROUP_MEMBER_REL_ID ) THEN

Line 623: wf_engine.SetItemAttrNumber( itemtype => p_item_type,

619: avalue => l_values_tbl(i));
620: ELSIF( l_names_tbl(i) = G_GROUP_MEMBER_REL_ID ) THEN
621: l_member_id := To_number(l_values_tbl(i));
622: --set member id as the item level attribute
623: wf_engine.SetItemAttrNumber( itemtype => p_item_type,
624: itemkey => p_item_key,
625: aname => G_GROUP_MEMBER_REL_ID,
626: avalue => To_number(l_values_tbl(i)));
627: ELSIF (l_names_tbl(i) = G_NOTE ) THEN

Line 629: wf_engine.SetItemAttrText( itemtype => p_item_type,

625: aname => G_GROUP_MEMBER_REL_ID,
626: avalue => To_number(l_values_tbl(i)));
627: ELSIF (l_names_tbl(i) = G_NOTE ) THEN
628: --set member user name as the item level attribute
629: wf_engine.SetItemAttrText( itemtype => p_item_type,
630: itemkey => p_item_key,
631: aname => G_MEMBER_NOTE,
632: avalue => l_values_tbl(i));
633: END IF;

Line 638: l_member_note := wf_engine.GetItemAttrText( itemtype => p_item_type,

634: END LOOP; --FOR i IN l_names_tbl.first .. l_names_tbl.last LOOP
635: END IF; --IF ( l_names_tbl.count > 0) THEN
636: mdebug (' SWFIA : All attributes sent ');
637:
638: l_member_note := wf_engine.GetItemAttrText( itemtype => p_item_type,
639: itemkey => p_item_key,
640: aname => G_MEMBER_NOTE);
641: IF (p_process_type = G_ADD_GROUP_MEMBER_TYPE) THEN
642:

Line 650: wf_engine.SetItemAttrText( itemtype => p_item_type,

646: fnd_message.set_token('MEMBER_NAME', l_member_name);
647: fnd_message.set_token('GROUP_NAME', l_group_name);
648:
649: --set message subject as the item level attribute
650: wf_engine.SetItemAttrText( itemtype => p_item_type,
651: itemkey => p_item_key,
652: aname =>'EGO_OWNER_APPROVAL_REQ_SUBJECT',
653: avalue => fnd_message.get);
654: ----------------------------------------------------------------------

Line 663: wf_engine.SetItemAttrText( itemtype => p_item_type,

659: --for the owner
660: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Req_Doc/'
661: ||p_item_type||':'||p_item_key;
662: --set Owner Approval Request body as the item level attribute
663: wf_engine.SetItemAttrText( itemtype => p_item_type,
664: itemkey => p_item_key,
665: aname =>'EGO_OWNER_APPROVAL_REQ_BODY',
666: avalue => l_msg_document_plsql_proc);
667:

Line 676: wf_engine.SetItemAttrText( itemtype => p_item_type,

672: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_SUBJ');
673: fnd_message.set_token('GROUP_NAME', l_group_name);
674:
675: --set message subject as the item level attribute
676: wf_engine.SetItemAttrText( itemtype => p_item_type,
677: itemkey => p_item_key,
678: aname =>'EGO_MEMBER_APPROVAL_SUBJECT',
679: avalue => fnd_message.get);
680:

Line 686: wf_engine.SetItemAttrText( itemtype => p_item_type,

682: -- and calling the package to dynamically create the document
683: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Msg_Doc/'
684: ||p_item_type||':'||p_item_key;
685: --set Reject Notification body as the item level attribute
686: wf_engine.SetItemAttrText( itemtype => p_item_type,
687: itemkey => p_item_key,
688: aname =>'EGO_MEMBER_APPROVAL_MSG_BODY',
689: avalue => l_msg_document_plsql_proc);
690: --

Line 706: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

702: ---- fnd_message.set_token('NOTE', '');
703: -- -- currently in workflow, the comments are not comming..
704: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
705: -- --set message body as the item level attribute
706: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
707: -- itemkey => p_item_key,
708: -- aname =>'EGO_MEMBER_APPROVAL_MSG_BODY',
709: -- avalue => fnd_message.get);
710: --

Line 719: wf_engine.SetItemAttrText( itemtype => p_item_type,

715: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_SUBJ');
716: fnd_message.set_token('GROUP_NAME', l_group_name);
717:
718: --set message subject as the item level attribute
719: wf_engine.SetItemAttrText( itemtype => p_item_type,
720: itemkey => p_item_key,
721: aname =>'EGO_MEMBER_REJECTION_SUBJECT',
722: avalue => fnd_message.get);
723:

Line 729: wf_engine.SetItemAttrText( itemtype => p_item_type,

725: -- and calling the package to dynamically create the document
726: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Reject_Msg_Doc/'
727: ||p_item_type||':'||p_item_key;
728: --set Reject Notification body as the item level attribute
729: wf_engine.SetItemAttrText( itemtype => p_item_type,
730: itemkey => p_item_key,
731: aname =>'EGO_MEMBER_REJECTION_MSG_BODY',
732: avalue => l_msg_document_plsql_proc);
733:

Line 751: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

747: ---- fnd_message.set_token('NOTE', '');
748: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
749: --
750: -- --set message subject as the item level attribute
751: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
752: -- itemkey => p_item_key,
753: -- aname =>'EGO_MEMBER_REJECTION_MSG_BODY',
754: -- avalue => fnd_message.get);
755: --

Line 772: wf_engine.SetItemAttrText( itemtype => p_item_type,

768: fnd_message.set_token('MEMBER_NAME', l_member_name);
769: fnd_message.set_token('GROUP_NAME', l_group_name);
770:
771: --set message subject as the item level attribute
772: wf_engine.SetItemAttrText( itemtype => p_item_type,
773: itemkey => p_item_key,
774: aname =>'EGO_OWNER_UNSUBSCR_FYI_SUBJECT',
775: avalue => fnd_message.get);
776:

Line 783: wf_engine.SetItemAttrText( itemtype => p_item_type,

779: mdebug (' Remove Group Member Subject Set '|| fnd_message.get);
780: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Owner_FYI_Doc/'
781: ||p_item_type||':'||p_item_key;
782: --set Reject Notification body as the item level attribute
783: wf_engine.SetItemAttrText( itemtype => p_item_type,
784: itemkey => p_item_key,
785: aname =>'EGO_OWNER_UNSUBSCR_FYI_BODY',
786: avalue => l_msg_document_plsql_proc);
787: --

Line 817: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

813: -- fnd_message.set_token('GROUP_NAME', l_group_name);
814: -- fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
815: --
816: -- --set message subject as the item level attribute
817: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
818: -- itemkey => p_item_key,
819: -- aname =>'EGO_OWNER_UNSUBSCR_FYI_BODY',
820: -- avalue => fnd_message.get);
821: -- mdebug (' Remove Group Member Body Set '|| fnd_message.get);

Line 832: wf_engine.SetItemAttrText( itemtype => p_item_type,

828: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_SUBJ');
829: fnd_message.set_token('GROUP_NAME', l_group_name);
830:
831: --set message subject as the item level attribute
832: wf_engine.SetItemAttrText( itemtype => p_item_type,
833: itemkey => p_item_key,
834: aname =>'EGO_UNSUBSCR_GRPMEM_CONF_SUBJ',
835: avalue => fnd_message.get);
836:

Line 842: wf_engine.SetItemAttrText( itemtype => p_item_type,

838: -- and calling the package to dynamically create the document
839: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Conf_Mem_Doc/'
840: ||p_item_type||':'||p_item_key;
841: --set Reject Notification body as the item level attribute
842: wf_engine.SetItemAttrText( itemtype => p_item_type,
843: itemkey => p_item_key,
844: aname =>'EGO_UNSUBSCR_GRPMEM_CONF_BODY',
845: avalue => l_msg_document_plsql_proc);
846: --

Line 859: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

855: --
856: -- fnd_message.set_token('GROUP_NAME', l_group_name);
857: --
858: -- --set message body as the item level attribute
859: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
860: -- itemkey => p_item_key,
861: -- aname =>'EGO_UNSUBSCR_GRPMEM_CONF_BODY',
862: -- avalue => fnd_message.get);
863: --

Line 996: wf_engine.CreateProcess ( itemtype => l_item_type,

992: mdebug (' SSP: setting the process type for WF ' || l_wf_process);
993:
994: mdebug (' SSP: setup of parameters complete for WF Creation ');
995: --create the process EGOGROUP
996: wf_engine.CreateProcess ( itemtype => l_item_type,
997: itemkey => l_item_key,
998: process => l_wf_process);
999:
1000: mdebug (' SSP: WF process created ');

Line 1027: wf_engine.StartProcess ( itemtype => l_item_type,

1023: mdebug (' SSP: WFItemAtributes set ');
1024: --Now that all the above global variables are available to the process,
1025: --Start the process EGOGROUP
1026: --The first process is to request an approval from Owner of the group
1027: wf_engine.StartProcess ( itemtype => l_item_type,
1028: itemkey => l_item_key );
1029:
1030: mdebug (' SSP: BYE - WF Process Started ');
1031: EXCEPTION

Line 1186: wf_engine.CreateProcess ( itemtype => l_item_type,

1182:
1183: mdebug('2 -- ' || l_item_key);
1184:
1185: --create the process EGOGROUP
1186: wf_engine.CreateProcess ( itemtype => l_item_type,
1187: itemkey => l_item_key,
1188: process => l_wf_process);
1189: mdebug('3');
1190: --no delimiters specified between name value pair combinations.

Line 1210: wf_engine.StartProcess ( itemtype => l_item_type,

1206:
1207: --Now that all the above global variables are available to the process,
1208: --Start the process EGOGROUP
1209: mdebug(' 6 ' || l_item_type || ' xx ' || l_item_key);
1210: wf_engine.StartProcess ( itemtype => l_item_type,
1211: itemkey => l_item_key );
1212:
1213: EXCEPTION
1214: WHEN OTHERS THEN

Line 1393: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,

1389:
1390: mdebug (' ADD_GROUP_MEMBER (AGM) : ....1.... ');
1391: IF ( p_funcmode = 'RUN' ) THEN
1392:
1393: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1394: itemkey => p_item_key,
1395: aname => G_GROUP_ID);
1396:
1397: l_member_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,

Line 1397: l_member_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,

1393: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1394: itemkey => p_item_key,
1395: aname => G_GROUP_ID);
1396:
1397: l_member_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1398: itemkey => p_item_key,
1399: aname => G_MEMBER_ID);
1400:
1401: OPEN c_get_member(cp_group_id => l_group_id

Line 1428: wf_engine.SetItemAttrText( itemtype => p_item_type,

1424: );
1425:
1426: mdebug (' AGM : Exiting out of EGO_PARTY_PUB.ADD_GROUP_MEMBER ');
1427: --store the relationship id generated, as item attribute
1428: wf_engine.SetItemAttrText( itemtype => p_item_type,
1429: itemkey => p_item_key,
1430: aname => G_GROUP_MEMBER_REL_ID,
1431: avalue => l_group_member_rel_id);
1432: mdebug (' AGM : Successfully set the parameters into the workflow ');

Line 1500: wf_engine.GetItemAttrNumber( itemtype => p_item_type,

1496: IF ( p_funcmode = 'RUN' ) THEN
1497:
1498: -- get the group member relationship id from Item attribute
1499: l_group_member_rel_id :=
1500: wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1501: itemkey => p_item_key,
1502: aname => G_GROUP_MEMBER_REL_ID);
1503: mdebug(' RGMP ' || to_char(l_group_member_rel_id));
1504: --

Line 1591: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,

1587: mdebug (' Entered Delete Group after sending notifications ');
1588: IF ( p_funcmode = 'RUN' ) THEN
1589:
1590: -- get the group id from Item attribute
1591: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1592: itemkey => p_item_key,
1593: aname => G_GROUP_ID);
1594: mdebug (' Group to be deleted ' || to_char(l_group_id));
1595: OPEN c_get_object_ver_no (cp_group_id => l_group_id);

Line 1680: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,

1676:
1677: IF ( p_funcmode = 'RUN' ) THEN
1678: mdebug (' 1 ');
1679: -- get the group id from Item attribute
1680: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1681: itemkey => p_item_key,
1682: aname => G_GROUP_ID);
1683: l_group_name := wf_engine.GetItemAttrText( itemtype => p_item_type,
1684: itemkey => p_item_key,

Line 1683: l_group_name := wf_engine.GetItemAttrText( itemtype => p_item_type,

1679: -- get the group id from Item attribute
1680: l_group_id := wf_engine.GetItemAttrNumber( itemtype => p_item_type,
1681: itemkey => p_item_key,
1682: aname => G_GROUP_ID);
1683: l_group_name := wf_engine.GetItemAttrText( itemtype => p_item_type,
1684: itemkey => p_item_key,
1685: aname => G_GROUP_NAME);
1686: mdebug (' 2 ' || l_group_name);
1687: wf_engine.SetItemAttrText(itemtype => p_item_type,

Line 1687: wf_engine.SetItemAttrText(itemtype => p_item_type,

1683: l_group_name := wf_engine.GetItemAttrText( itemtype => p_item_type,
1684: itemkey => p_item_key,
1685: aname => G_GROUP_NAME);
1686: mdebug (' 2 ' || l_group_name);
1687: wf_engine.SetItemAttrText(itemtype => p_item_type,
1688: itemkey => p_item_key,
1689: aname => 'FROM_ROLE',
1690: avalue => fnd_global.user_name());
1691: mdebug (' 3 ' || fnd_global.user_name());

Line 1700: wf_engine.SetItemAttrText(itemtype => p_item_type,

1696: ------------------------------------------------
1697: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_SUBJ');
1698: fnd_message.set_token('GROUP_NAME', l_group_name);
1699: --set message subject as the item level attribute
1700: wf_engine.SetItemAttrText(itemtype => p_item_type,
1701: itemkey => p_item_key,
1702: aname => 'EGO_GROUP_DEL_MEM_NOTF_SUBJ',
1703: avalue => fnd_message.get);
1704:

Line 1709: wf_engine.SetItemAttrText(itemtype => p_item_type,

1705: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Admin_Notif_Doc/'
1706: ||p_item_type||':'||p_item_key;
1707:
1708: --set Owner Group Del Message body as the item level attribute
1709: wf_engine.SetItemAttrText(itemtype => p_item_type,
1710: itemkey => p_item_key,
1711: aname =>'EGO_GROUP_DEL_MEM_NOTF_BODY',
1712: avalue => l_msg_document_plsql_proc);
1713: ------------------------------------------------

Line 1726: callback => 'WF_ENGINE.CB',

1722: role => cr.user_name,
1723: msg_type => l_item_type,
1724: msg_name => l_group_del_member_notif,
1725: due_date => NULL,
1726: callback => 'WF_ENGINE.CB',
1727: context => l_context,
1728: send_comment => NULL,
1729: priority => NULL
1730: );

Line 1740: wf_engine.SetItemAttrText(itemtype => p_item_type,

1736: ------------------------------------------------
1737: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Mem_Notif_Doc/'
1738: ||p_item_type||':'||p_item_key;
1739: --set Group Del Message body for Member as the item level attribute
1740: wf_engine.SetItemAttrText(itemtype => p_item_type,
1741: itemkey => p_item_key,
1742: aname =>'EGO_GROUP_DEL_MEM_NOTF_BODY',
1743: avalue => l_msg_document_plsql_proc);
1744: FOR cr in c_get_member_party_names (cp_group_id => l_group_id) LOOP

Line 1752: callback => 'WF_ENGINE.CB',

1748: role => cr.member_user_name,
1749: msg_type => l_item_type,
1750: msg_name => l_group_del_member_notif,
1751: due_date => NULL,
1752: callback => 'WF_ENGINE.CB',
1753: context => l_context,
1754: send_comment => NULL,
1755: priority => NULL
1756: );

Line 1842: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

1838: -- release 2.5
1839: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
1840: l_item_key := substr(document_id , instr(document_id,':')+1);
1841:
1842: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1843: itemkey => l_item_key,
1844: aname => G_GROUP_NAME);
1845:
1846: --

Line 1847: -- l_owner_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

1843: itemkey => l_item_key,
1844: aname => G_GROUP_NAME);
1845:
1846: --
1847: -- l_owner_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1848: -- itemkey => l_item_key,
1849: -- aname => G_OWNER_NAME);
1850: --
1851:

Line 1852: l_member_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

1848: -- itemkey => l_item_key,
1849: -- aname => G_OWNER_NAME);
1850: --
1851:
1852: l_member_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1853: itemkey => l_item_key,
1854: aname => G_MEMBER_NAME);
1855:
1856:

Line 1857: l_member_note := wf_engine.GetItemAttrText( itemtype => l_item_type,

1853: itemkey => l_item_key,
1854: aname => G_MEMBER_NAME);
1855:
1856:
1857: l_member_note := wf_engine.GetItemAttrText( itemtype => l_item_type,
1858: itemkey => l_item_key,
1859: aname => G_MEMBER_NOTE);
1860:
1861: -- OPEN c_get_ownerid(cp_group_name => l_group_name);

Line 1960: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

1956: -- release 2.5
1957: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
1958: l_item_key := substr(document_id , instr(document_id,':')+1);
1959:
1960: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1961: itemkey => l_item_key,
1962: aname => G_GROUP_NAME);
1963:
1964: l_member_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type,

Line 1964: l_member_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type,

1960: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1961: itemkey => l_item_key,
1962: aname => G_GROUP_NAME);
1963:
1964: l_member_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type,
1965: itemkey => l_item_key,
1966: aname => G_MEMBER_ID);
1967: l_mail_pref := get_mail_pref(l_member_id);
1968: IF (display_type = 'text/plain') THEN

Line 1976: l_user_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

1972: END IF;
1973:
1974: fnd_message.set_token('GROUP_NAME', l_group_name);
1975:
1976: l_user_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1977: itemkey => l_item_key,
1978: aname => G_RESPONDER_NAME);
1979: OPEN c_get_party_name (cp_user_name => l_user_name);
1980: FETCH c_get_party_name INTO l_respondent;

Line 2041: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

2037: -- release 2.5
2038: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
2039: l_item_key := substr(document_id , instr(document_id,':')+1);
2040:
2041: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2042: itemkey => l_item_key,
2043: aname => G_GROUP_NAME);
2044:
2045: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

Line 2045: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

2041: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2042: itemkey => l_item_key,
2043: aname => G_GROUP_NAME);
2044:
2045: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
2046: itemkey => l_item_key,
2047: aname => G_MEMBER_ID);
2048: l_mail_pref := get_mail_pref(l_member_id);
2049: IF (l_mail_pref = 'MAILTEXT') THEN

Line 2124: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

2120: -- release 2.5
2121: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
2122: l_item_key := substr(document_id , instr(document_id,':')+1);
2123:
2124: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2125: itemkey => l_item_key,
2126: aname => G_GROUP_NAME);
2127: l_member_name := wf_engine.GetItemAttrText(itemtype => l_item_type
2128: ,itemkey => l_item_key

Line 2127: l_member_name := wf_engine.GetItemAttrText(itemtype => l_item_type

2123:
2124: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2125: itemkey => l_item_key,
2126: aname => G_GROUP_NAME);
2127: l_member_name := wf_engine.GetItemAttrText(itemtype => l_item_type
2128: ,itemkey => l_item_key
2129: ,aname => G_MEMBER_NAME);
2130: l_member_note := wf_engine.GetItemAttrText( itemtype => l_item_type
2131: ,itemkey => l_item_key

Line 2130: l_member_note := wf_engine.GetItemAttrText( itemtype => l_item_type

2126: aname => G_GROUP_NAME);
2127: l_member_name := wf_engine.GetItemAttrText(itemtype => l_item_type
2128: ,itemkey => l_item_key
2129: ,aname => G_MEMBER_NAME);
2130: l_member_note := wf_engine.GetItemAttrText( itemtype => l_item_type
2131: ,itemkey => l_item_key
2132: ,aname => G_MEMBER_NOTE);
2133: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
2134: itemkey => l_item_key,

Line 2133: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

2129: ,aname => G_MEMBER_NAME);
2130: l_member_note := wf_engine.GetItemAttrText( itemtype => l_item_type
2131: ,itemkey => l_item_key
2132: ,aname => G_MEMBER_NOTE);
2133: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
2134: itemkey => l_item_key,
2135: aname => G_MEMBER_ID);
2136: l_mail_pref := get_mail_pref(l_member_id);
2137: IF (l_mail_pref = 'MAILTEXT') THEN

Line 2218: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

2214: -- release 2.5
2215: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
2216: l_item_key := substr(document_id , instr(document_id,':')+1);
2217:
2218: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2219: itemkey => l_item_key,
2220: aname => G_GROUP_NAME);
2221: l_member_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type,
2222: itemkey => l_item_key,

Line 2221: l_member_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type,

2217:
2218: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2219: itemkey => l_item_key,
2220: aname => G_GROUP_NAME);
2221: l_member_id := wf_engine.GetItemAttrNumber(itemtype => l_item_type,
2222: itemkey => l_item_key,
2223: aname => G_MEMBER_ID);
2224: l_mail_pref := get_mail_pref(l_member_id);
2225: IF (l_mail_pref = 'MAILTEXT') THEN

Line 2290: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

2286: -- release 2.5
2287: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
2288: l_item_key := substr(document_id , instr(document_id,':')+1);
2289:
2290: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2291: itemkey => l_item_key,
2292: aname => G_GROUP_NAME);
2293:
2294: l_deletion_note := wf_engine.GetItemAttrText( itemtype => l_item_type,

Line 2294: l_deletion_note := wf_engine.GetItemAttrText( itemtype => l_item_type,

2290: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2291: itemkey => l_item_key,
2292: aname => G_GROUP_NAME);
2293:
2294: l_deletion_note := wf_engine.GetItemAttrText( itemtype => l_item_type,
2295: itemkey => l_item_key,
2296: aname => G_MEMBER_NOTE);
2297:
2298: IF l_deletion_note IS NOT NULL THEN

Line 2306: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

2302: ELSE
2303: l_temp_message := NULL;
2304: END IF;
2305:
2306: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
2307: itemkey => l_item_key,
2308: aname => G_MEMBER_ID);
2309: l_mail_pref := get_mail_pref(l_member_id);
2310: IF (l_mail_pref = 'MAILTEXT') THEN

Line 2375: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,

2371: -- release 2.5
2372: l_item_type := nvl(substr(document_id, 1, instr(document_id,':')-1),G_ITEM_TYPE);
2373: l_item_key := substr(document_id , instr(document_id,':')+1);
2374:
2375: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2376: itemkey => l_item_key,
2377: aname => G_GROUP_NAME);
2378:
2379: l_deletion_note := wf_engine.GetItemAttrText( itemtype => l_item_type,

Line 2379: l_deletion_note := wf_engine.GetItemAttrText( itemtype => l_item_type,

2375: l_group_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
2376: itemkey => l_item_key,
2377: aname => G_GROUP_NAME);
2378:
2379: l_deletion_note := wf_engine.GetItemAttrText( itemtype => l_item_type,
2380: itemkey => l_item_key,
2381: aname => G_MEMBER_NOTE);
2382:
2383: IF l_deletion_note IS NOT NULL THEN

Line 2391: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,

2387: ELSE
2388: l_temp_message := NULL;
2389: END IF;
2390:
2391: l_member_id := wf_engine.GetItemAttrNumber( itemtype => l_item_type,
2392: itemkey => l_item_key,
2393: aname => G_MEMBER_ID);
2394: l_mail_pref := get_mail_pref(l_member_id);
2395: IF (l_mail_pref = 'MAILTEXT') THEN

Line 2446: ' - key: '|| itemkey||' - text: '||wf_engine.context_text);

2442: l_email_address VARCHAR2(32767);
2443: BEGIN
2444:
2445: mdebug (' GET_RESPONDER_NAME (GRN) : ....1.... mode: ' || funcmode ||
2446: ' - key: '|| itemkey||' - text: '||wf_engine.context_text);
2447: IF (funcmode = 'RESPOND' ) THEN
2448: -- bug 3354437
2449: -- get the responder name from the email address
2450: l_responder_name := wf_engine.context_text;

Line 2450: l_responder_name := wf_engine.context_text;

2446: ' - key: '|| itemkey||' - text: '||wf_engine.context_text);
2447: IF (funcmode = 'RESPOND' ) THEN
2448: -- bug 3354437
2449: -- get the responder name from the email address
2450: l_responder_name := wf_engine.context_text;
2451: l_email_start_loc := INSTR(l_responder_name,'<');
2452: IF l_email_start_loc <> 0 THEN
2453: l_email_end_loc := INSTR(l_responder_name,'>');
2454: l_email_address := SUBSTR(l_responder_name, l_email_start_loc+1, l_email_end_loc-l_email_start_loc-1);

Line 2471: Wf_Engine.SetItemAttrText( ItemType => itemtype,

2467: END;
2468: END IF;
2469: mdebug (' GET_RESPONDER_NAME (GRN) : ....8.... responder: ' || l_responder_name);
2470: -- set the item attribute
2471: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2472: ItemKey => itemkey,
2473: aname => G_RESPONDER_NAME,
2474: avalue => l_responder_name
2475: -- avalue => wf_engine.context_text

Line 2475: -- avalue => wf_engine.context_text

2471: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2472: ItemKey => itemkey,
2473: aname => G_RESPONDER_NAME,
2474: avalue => l_responder_name
2475: -- avalue => wf_engine.context_text
2476: );
2477:
2478: Resultout:= G_COMPLETE_STATUS;
2479: RETURN;

Line 2562: l_group_name := wf_engine.GetItemAttrText( itemtype => itemtype,

2558: BEGIN
2559:
2560: mdebug( ' Create group admin wf role ');
2561: l_role_name := G_GROUP_OBJECT_NAME || itemkey ;
2562: l_group_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2563: itemkey => itemkey,
2564: aname => G_GROUP_NAME);
2565: fnd_message.set_name('EGO', 'EGO_GROUP_APPROVER_LIST_NAME');
2566: fnd_message.set_token('GROUP_NAME', l_group_name);

Line 2571: wf_engine.SetItemAttrText (itemtype => itemtype,

2567: l_role_display_name := fnd_message.get;
2568: --
2569: -- set notification username
2570: --
2571: wf_engine.SetItemAttrText (itemtype => itemtype,
2572: itemkey => itemkey,
2573: aname => 'FROM_ROLE',
2574: avalue => fnd_global.user_name() );
2575:

Line 2581: l_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2577: -- create the adhoc role
2578: Wf_Directory.CreateAdHocRole (role_name => l_role_name,
2579: role_display_name => l_role_display_name
2580: );
2581: l_group_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2582: itemkey => itemkey,
2583: aname => G_GROUP_ID);
2584: FOR cr in c_get_admin_list( l_group_id ) LOOP
2585: Wf_Directory.AddUsersToAdHocRole (role_name => l_role_name,

Line 2588: Wf_Engine.SetItemAttrText( ItemType => itemtype,

2584: FOR cr in c_get_admin_list( l_group_id ) LOOP
2585: Wf_Directory.AddUsersToAdHocRole (role_name => l_role_name,
2586: role_users => cr.user_name);
2587: END LOOP; -- c_get_admin_list
2588: Wf_Engine.SetItemAttrText( ItemType => itemtype,
2589: ItemKey => itemkey,
2590: aname => G_OWNER_USER_NAME,
2591: avalue => l_role_name
2592: );