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.OKC_ARTWF_PVT dependencies on WF_USERS

Line 223: result wf_users.display_name%type;

219:
220: function get_display_name(userid in varchar2)
221: return varchar2
222: is
223: result wf_users.display_name%type;
224: cursor disp_name(id in varchar2) is
225: select nvl(display_name, name)
226: from wf_users
227: where name = nvl(id, 'WFADMIN');

Line 226: from wf_users

222: is
223: result wf_users.display_name%type;
224: cursor disp_name(id in varchar2) is
225: select nvl(display_name, name)
226: from wf_users
227: where name = nvl(id, 'WFADMIN');
228: begin
229: open disp_name(userid);
230: fetch disp_name into result;

Line 876: approver_role wf_users.name%type;

872: resultout out nocopy varchar2)
873: is
874: org_id number;
875: art_intent varchar2(1);
876: approver_role wf_users.name%type;
877: approver_name wf_users.display_name%type;
878: begin
879:
880: org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);

Line 877: approver_name wf_users.display_name%type;

873: is
874: org_id number;
875: art_intent varchar2(1);
876: approver_role wf_users.name%type;
877: approver_name wf_users.display_name%type;
878: begin
879:
880: org_id := wf_engine.getItemAttrNumber(itemtype, itemkey, 'ORG_ID', false);
881: if ( funcmode = 'RUN' ) then

Line 886: from wf_users where name = approver_role;

882: art_intent := get_intent(itemtype, itemkey);
883: approver_role := get_approver(org_id, art_intent);
884: begin
885: select nvl(display_name, name) into approver_name
886: from wf_users where name = approver_role;
887: exception
888: when others then
889: approver_name := null;
890: end;

Line 983: approver_name wf_users.display_name%type;

979: and im.lookup_code = art.article_intent
980: and gm.lookup_code = artv.global_yn
981: and pm.lookup_code = artv.provision_yn;
982:
983: approver_name wf_users.display_name%type;
984:
985: begin
986: if ( funcmode = 'RUN' ) then
987: message_code := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'MESSAGE_CODE', false);

Line 1657: approverS wf_users.name%type;

1653: undefined_approver1B exception;
1654: undefined_approver2S exception;
1655: undefined_approver2B exception;
1656: result varchar2(1);
1657: approverS wf_users.name%type;
1658: approverB wf_users.name%type;
1659: begin
1660: result := 'N';
1661: fnd_msg_pub.initialize;

Line 1658: approverB wf_users.name%type;

1654: undefined_approver2S exception;
1655: undefined_approver2B exception;
1656: result varchar2(1);
1657: approverS wf_users.name%type;
1658: approverB wf_users.name%type;
1659: begin
1660: result := 'N';
1661: fnd_msg_pub.initialize;
1662: approverS := get_approver(p_org_id, 'S');

Line 1675: from wf_users

1671: end if;
1672:
1673: begin
1674: select 'Y' into result
1675: from wf_users
1676: where name = approverS;
1677: exception
1678: when others then
1679: raise undefined_approver2S;

Line 1687: from wf_users

1683: end if;
1684:
1685: begin
1686: select 'Y' into result
1687: from wf_users
1688: where name = approverB;
1689: exception
1690: when others then
1691: raise undefined_approver2B;

Line 1744: approverS wf_users.name%type;

1740: undefined_approver1B exception;
1741: undefined_approver2S exception;
1742: undefined_approver2B exception;
1743: result varchar2(1);
1744: approverS wf_users.name%type;
1745: approverB wf_users.name%type;
1746: begin
1747: result := 'N';
1748: fnd_msg_pub.initialize;

Line 1745: approverB wf_users.name%type;

1741: undefined_approver2S exception;
1742: undefined_approver2B exception;
1743: result varchar2(1);
1744: approverS wf_users.name%type;
1745: approverB wf_users.name%type;
1746: begin
1747: result := 'N';
1748: fnd_msg_pub.initialize;
1749: approverS := get_approver(p_org_id, 'S');

Line 1758: from wf_users

1754: raise undefined_approver1S;
1755: end if;
1756: begin
1757: select 'Y' into result
1758: from wf_users
1759: where name = approverS;
1760: exception
1761: when others then
1762: raise undefined_approver2S;

Line 1775: from wf_users

1771: raise undefined_approver1B;
1772: end if;
1773: begin
1774: select 'Y' into result
1775: from wf_users
1776: where name = approverB;
1777: exception
1778: when others then
1779: raise undefined_approver2B;

Line 1821: approver_name wf_users.display_name%type;

1817: funcmode in varchar2,
1818: resultout out nocopy varchar2
1819: )
1820: is
1821: approver_name wf_users.display_name%type;
1822: function_name varchar2(250);
1823:
1824: cursor approver(new_approver in varchar2) is
1825: select display_name

Line 1826: from wf_users

1822: function_name varchar2(250);
1823:
1824: cursor approver(new_approver in varchar2) is
1825: select display_name
1826: from wf_users
1827: where name = new_approver;
1828:
1829: begin
1830: if (funcmode = 'TRANSFER') then

Line 1925: requestor_name wf_users.display_name%type;

1921: org_id okc_articles_all.org_id%type;
1922: article_id okc_articles_all.article_id%type;
1923: article_version_id okc_article_versions.article_version_id%type;
1924:
1925: requestor_name wf_users.display_name%type;
1926: itemtype wf_engine.setctx_itemtype%type;
1927: itemkey wf_engine.setctx_itemkey%type;
1928: nid number;
1929: begin