APPS.HR_WORKFLOW_SS dependencies on WF_NOTIFICATIONS

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