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 1402: from wf_notifications

1398: -- try getting from the notification context
1399: select substr(context,1,instr(context,':',1)-1)
1400: ,substr(context,instr(context,':')+1, ( instr(context,':',instr(context,':')+1 ) - instr(context,':')-1) )
1401: into lv_item_type, lv_item_key
1402: from wf_notifications
1403: where notification_id = p_ntfid;
1404: exception
1405: when no_data_found then
1406: hr_utility.set_location('Error in '|| g_package||'.'||c_proc ||SQLERRM ||' '||to_char(SQLCODE), 20);

Line 1442: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;

1438: lv_params fnd_form_functions_vl.parameters%type;
1439: lv_addtnlParams VARCHAR2(30) ;
1440: lv_restrict_edit_to_owner varchar2(3);
1441: -- fix for bug#3333763
1442: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

Line 1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;

1439: lv_addtnlParams VARCHAR2(30) ;
1440: lv_restrict_edit_to_owner varchar2(3);
1441: -- fix for bug#3333763
1442: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

Line 1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;

1440: lv_restrict_edit_to_owner varchar2(3);
1441: -- fix for bug#3333763
1442: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1448:

Line 1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;

1441: -- fix for bug#3333763
1442: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1448:
1449: begin

Line 1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;

1442: lv_ntf_role WF_NOTIFICATIONS.RECIPIENT_ROLE%type;
1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1448:
1449: begin
1450: g_debug := hr_utility.debug_enabled;

Line 1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;

1443: lv_ntf_msg_typ WF_NOTIFICATIONS.MESSAGE_TYPE%type;
1444: lv_ntf_msg_name WF_NOTIFICATIONS.MESSAGE_NAME%type;
1445: lv_ntf_prior WF_NOTIFICATIONS.PRIORITY%type;
1446: lv_ntf_due WF_NOTIFICATIONS.DUE_DATE%type;
1447: lv_ntf_status WF_NOTIFICATIONS.STATUS%type;
1448:
1449: begin
1450: g_debug := hr_utility.debug_enabled;
1451: if g_debug then

Line 1458: 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);

1454:
1455: -- fix for bug#3333763
1456: -- check the status of the notification before doing any iterations.
1457: -- Get notification recipient and status
1458: 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);
1459:
1460: if (lv_ntf_status <> 'OPEN') then
1461: -- no more iteration return
1462: document :=null;

Line 1523: from wf_notifications wn, wf_message_attributes_vl wma

1519: -- get the translated display name for the url link
1520: begin
1521: select wma.display_name
1522: into lv_link_label
1523: from wf_notifications wn, wf_message_attributes_vl wma
1524: where wn.notification_id = document_id
1525: and wn.message_name = wma.message_name
1526: and wma.message_type = lv_item_type
1527: and wma.name = 'EDIT_TXN_URL';

Line 1558: document_type := wf_notification.doc_html;

1554: ''||
1555: ''
1556: ||lv_link_label||' ';
1557: -- set the document type
1558: document_type := wf_notification.doc_html;
1559:
1560: else
1561: document := null;
1562: end if;

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

Line 1880: document_type := wf_notification.doc_html;

1876: end if;
1877: -- get the itemtype and item key for the notification id
1878: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1879: -- set the document type
1880: document_type := wf_notification.doc_html;
1881: -- set the document
1882: if g_debug then
1883: hr_utility.set_location('Calling getProcessDisplayName',12);
1884: hr_utility.set_location('ItemType:'||lv_item_type,13);

Line 2084: document_type := wf_notification.doc_html;

2080: end if;
2081:
2082:
2083: -- set the document type
2084: document_type := wf_notification.doc_html;
2085:
2086: if g_debug then
2087: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
2088: end if;

Line 2355: from WF_NOTIFICATIONS WN

2351:
2352: if(l_username = p_username) then
2353: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
2354: into recipient, orig_recipient, from_role, more_info_role
2355: from WF_NOTIFICATIONS WN
2356: where WN.NOTIFICATION_ID = p_nid;
2357:
2358: Wf_Directory.GetUserRoles(p_username,userRoles);
2359: matchFound := false;