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 1584: lvalue wf_notification_attributes.NUMBER_VALUE%type;

1580: aname in varchar2,
1581: ignore_notfound in varchar2 default 'FALSE')
1582: return number is
1583: c_proc varchar2(30) default 'GetAttrNumber';
1584: lvalue wf_notification_attributes.NUMBER_VALUE%type;
1585: begin
1586: g_debug := hr_utility.debug_enabled;
1587:
1588: if g_debug then

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

1595: end if;
1596:
1597: begin
1598: if g_debug then
1599: hr_utility.set_location('querying wf_notification_attributes.number_value for aname:nid'||aname||':'||nid, 2);
1600: end if;
1601: select WNA.NUMBER_VALUE
1602: into lvalue
1603: from WF_NOTIFICATION_ATTRIBUTES WNA

Line 1603: from WF_NOTIFICATION_ATTRIBUTES WNA

1599: hr_utility.set_location('querying wf_notification_attributes.number_value for aname:nid'||aname||':'||nid, 2);
1600: end if;
1601: select WNA.NUMBER_VALUE
1602: into lvalue
1603: from WF_NOTIFICATION_ATTRIBUTES WNA
1604: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
1605: exception
1606: when no_data_found then
1607: if(ignore_notfound='TRUE') then

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

1616: return(lvalue);
1617: exception
1618: when others then
1619: wf_core.context('hr_workflow_ss', 'GetAttrNumber', to_char(nid), aname);
1620: hr_utility.set_location('Error querying wf_notification_attributes.NUMBER_VALUE for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1621: raise;
1622: end GetAttrNumber;
1623:
1624: function GetAttrText (nid in number,

Line 1629: lvalue wf_notification_attributes.text_value%type;

1625: aname in varchar2,
1626: ignore_notfound in varchar2 default 'FALSE')
1627: return varchar2 is
1628: c_proc varchar2(30) default 'GetAttrText';
1629: lvalue wf_notification_attributes.text_value%type;
1630: begin
1631: g_debug := hr_utility.debug_enabled;
1632:
1633: if g_debug then

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

1640: end if;
1641:
1642: begin
1643: if g_debug then
1644: hr_utility.set_location('querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid, 2);
1645: end if;
1646: select WNA.TEXT_VALUE
1647: into lvalue
1648: from WF_NOTIFICATION_ATTRIBUTES WNA

Line 1648: from WF_NOTIFICATION_ATTRIBUTES WNA

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

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

1661: return(lvalue);
1662: exception
1663: when others then
1664: wf_core.context('hr_workflow_ss', 'GetAttrText', to_char(nid), aname);
1665: hr_utility.set_location('Error querying wf_notification_attributes.text_value for aname:nid'||aname||':'||nid||'-'||SQLERRM ||' '||to_char(SQLCODE), 10);
1666: raise;
1667: end GetAttrText;
1668:
1669: function getApprStartingPointPersonId