APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_NOTIFICATIONS

Line 312: from wf_notifications wn, wf_message_attributes_vl wma

308: -- get the translated display name for the url link
309: begin
310: select wma.display_name
311: into lv_link_label
312: from wf_notifications wn, wf_message_attributes_vl wma
313: where wn.notification_id = document_id
314: and wn.message_name = wma.message_name
315: and wma.message_type = lv_item_type
316: and wma.name = 'OBJECT_URL';

Line 397: comments wf_notifications .user_comment%type;

393:
394: colon pls_integer;
395: avalue varchar2(240);
396: notid pls_integer;
397: comments wf_notifications .user_comment%type;
398: document varchar2(240);
399: document_type varchar2(240);
400:
401: begin

Line 1132: FROM wf_notifications

1128: IF (notification_rec.notification_id IS NOT NULL)
1129: THEN
1130: SELECT original_recipient
1131: INTO original_forward_to_user
1132: FROM wf_notifications
1133: WHERE notification_id = notification_rec.notification_id;
1134:
1135: prll_ntf := wf_engine.getitemattrtext (p_itemtype, p_itemkey, 'PRLL_TRNSFR_DET', TRUE);
1136:

Line 1403: p_notification_id in wf_notifications.item_key%type,

1399: end notify_appraisee;
1400:
1401: FUNCTION isAppraiser
1402: (
1403: p_notification_id in wf_notifications.item_key%type,
1404: p_loggedin_person_id in number
1405: )RETURN varchar2
1406: IS
1407: l_result varchar2(2) := 'N';

Line 1411: select orig_system_id into l_person_id from WF_NOTIFICATIONS ,wf_roles

1407: l_result varchar2(2) := 'N';
1408: l_person_id wf_roles.orig_system_id%type;
1409: BEGIN
1410:
1411: select orig_system_id into l_person_id from WF_NOTIFICATIONS ,wf_roles
1412: WHERE
1413: notification_id=p_notification_id and
1414: recipient_role = name and
1415: orig_system = 'PER';