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

1149: hr_complete_appraisal_ss.gv_upd_trn_act_status_log ,
1150: true);
1151:
1152: -- set the document type
1153: document_type := wf_notification.doc_html;
1154:
1155: if g_debug then
1156: hr_utility.set_location('Leaving:'|| gv_package||'.'||c_proc, 30);
1157: end if;