APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_NOTIFICATION

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 349: document_type := wf_notification.doc_html;

345: --||g_oa_html
346: ||lv_web_html_call||nvl(lv_params,'')||lv_addtnlParams||'>'
347: ||lv_link_label||' ';
348: -- set the document type
349: document_type := wf_notification.doc_html;
350:
351: -- else
352: -- document := null;
353: -- end if;

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 1229: document_type := wf_notification.doc_html;

1225: hr_complete_appraisal_ss.gv_upd_trn_act_status_log ,
1226: true);
1227:
1228: -- set the document type
1229: document_type := wf_notification.doc_html;
1230:
1231: if g_debug then
1232: hr_utility.set_location('Leaving:'|| gv_package||'.'||c_proc, 30);
1233: end if;

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