APPS.HR_WORKFLOW_SS dependencies on WF_NOTIFICATIONS

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 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 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;