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.HR_WORKFLOW_SS dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 1626: lvalue wf_notification_attributes.NUMBER_VALUE%type;

1622: aname in varchar2,
1623: ignore_notfound in varchar2 default 'FALSE')
1624: return number is
1625: c_proc varchar2(30) default 'GetAttrNumber';
1626: lvalue wf_notification_attributes.NUMBER_VALUE%type;
1627: begin
1628: g_debug := hr_utility.debug_enabled;
1629:
1630: if g_debug then

Line 1641: hr_utility.set_location('querying wf_notification_attributes.number_value for aname:nid'||aname||':'||nid, 2);

1637: end if;
1638:
1639: begin
1640: if g_debug then
1641: hr_utility.set_location('querying wf_notification_attributes.number_value for aname:nid'||aname||':'||nid, 2);
1642: end if;
1643: select WNA.NUMBER_VALUE
1644: into lvalue
1645: from WF_NOTIFICATION_ATTRIBUTES WNA

Line 1645: from WF_NOTIFICATION_ATTRIBUTES WNA

1641: hr_utility.set_location('querying wf_notification_attributes.number_value for aname:nid'||aname||':'||nid, 2);
1642: end if;
1643: select WNA.NUMBER_VALUE
1644: into lvalue
1645: from WF_NOTIFICATION_ATTRIBUTES WNA
1646: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
1647: exception
1648: when no_data_found then
1649: if(ignore_notfound='TRUE') then

Line 1662: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);

1658: return(lvalue);
1659: exception
1660: when others then
1661: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1662: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1663: raise;
1664: end GetAttrNumber;
1665:
1666: function GetAttrText (nid in number,

Line 1671: lvalue wf_notification_attributes.text_value%type;

1667: aname in varchar2,
1668: ignore_notfound in varchar2 default 'FALSE')
1669: return varchar2 is
1670: c_proc varchar2(30) default 'GetAttrText';
1671: lvalue wf_notification_attributes.text_value%type;
1672: begin
1673: g_debug := hr_utility.debug_enabled;
1674:
1675: if g_debug then

Line 1686: hr_utility.set_location('querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid, 2);

1682: end if;
1683:
1684: begin
1685: if g_debug then
1686: hr_utility.set_location('querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid, 2);
1687: end if;
1688: select WNA.TEXT_VALUE
1689: into lvalue
1690: from WF_NOTIFICATION_ATTRIBUTES WNA

Line 1690: from WF_NOTIFICATION_ATTRIBUTES WNA

1686: hr_utility.set_location('querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid, 2);
1687: end if;
1688: select WNA.TEXT_VALUE
1689: into lvalue
1690: from WF_NOTIFICATION_ATTRIBUTES WNA
1691: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
1692: exception
1693: when no_data_found then
1694: if(ignore_notfound='TRUE') then

Line 1707: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);

1703: return(lvalue);
1704: exception
1705: when others then
1706: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1707: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1708: raise;
1709: end GetAttrText;
1710:
1711: function getApprStartingPointPersonId