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

Line 1444: from wf_notifications

1440: -- try getting from the notification context
1441: select substr(context,1,instr(context,':',1)-1)
1442: ,substr(context,instr(context,':')+1, ( instr(context,':',instr(context,':')+1 ) - instr(context,':')-1) )
1443: into lv_item_type, lv_item_key
1444: from wf_notifications
1445: where notification_id = p_ntfid;
1446: exception
1447: when no_data_found then
1448: hr_utility.set_location('Error in '|| g_package||'.'||c_proc ||SQLERRM ||' '||to_char(SQLCODE), 20);

Line 1484: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;

1480: lv_params fnd_form_functions_vl.parameters%type;
1481: lv_addtnlParams VARCHAR2(30) ;
1482: lv_restrict_edit_to_owner varchar2(3);
1483: -- fix for bug#3333763
1484: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

Line 1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;

1481: lv_addtnlParams VARCHAR2(30) ;
1482: lv_restrict_edit_to_owner varchar2(3);
1483: -- fix for bug#3333763
1484: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1489: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

Line 1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;

1482: lv_restrict_edit_to_owner varchar2(3);
1483: -- fix for bug#3333763
1484: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1489: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1490:

Line 1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;

1483: -- fix for bug#3333763
1484: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1489: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1490:
1491: begin

Line 1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

1484: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1489: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1490:
1491: begin
1492: g_debug := hr_utility.debug_enabled;

Line 1489: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

1485: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1486: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1487: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1488: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1489: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1490:
1491: begin
1492: g_debug := hr_utility.debug_enabled;
1493: if g_debug then

Line 1500: Wf_Notification.GetInfo(document_id, lv_ntf_role, lv_ntf_msg_typ, lv_ntf_msg_name, lv_ntf_prior, lv_ntf_due, lv_ntf_status);

1496:
1497: -- fix for bug#3333763
1498: -- check the status of the notification before doing any iterations.
1499: -- Get notification recipient and status
1500: Wf_Notification.GetInfo(document_id, lv_ntf_role, lv_ntf_msg_typ, lv_ntf_msg_name, lv_ntf_prior, lv_ntf_due, lv_ntf_status);
1501:
1502: if (lv_ntf_status <> 'OPEN') then
1503: -- no more iteration return
1504: document :=null;

Line 1565: from wf_notifications wn, wf_message_attributes_vl wma

1561: -- get the translated display name for the url link
1562: begin
1563: select wma.display_name
1564: into lv_link_label
1565: from wf_notifications wn, wf_message_attributes_vl wma
1566: where wn.notification_id = document_id
1567: and wn.message_name = wma.message_name
1568: and wma.message_type = lv_item_type
1569: and wma.name = 'EDIT_TXN_URL';

Line 1600: document_type := wf_notification.doc_html;

1596: ''||
1597: ''
1598: ||lv_link_label||' ';
1599: -- set the document type
1600: document_type := wf_notification.doc_html;
1601:
1602: else
1603: document := null;
1604: end if;

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

Line 1922: document_type := wf_notification.doc_html;

1918: end if;
1919: -- get the itemtype and item key for the notification id
1920: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1921: -- set the document type
1922: document_type := wf_notification.doc_html;
1923: -- set the document
1924: if g_debug then
1925: hr_utility.set_location('Calling getProcessDisplayName',12);
1926: hr_utility.set_location('ItemType:'||lv_item_type,13);

Line 2128: document_type := wf_notification.doc_html;

2124: end if;
2125:
2126:
2127: -- set the document type
2128: document_type := wf_notification.doc_html;
2129:
2130: if g_debug then
2131: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2132: end if;

Line 2423: from WF_NOTIFICATIONS WN

2419:
2420: if(l_username = p_username) then
2421: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
2422: into recipient, orig_recipient, from_role, more_info_role
2423: from WF_NOTIFICATIONS WN
2424: where WN.NOTIFICATION_ID = p_nid;
2425:
2426: Wf_Directory.GetUserRoles(p_username,userRoles);
2427: matchFound := false;