DBA Data[Home] [Help]

APPS.HR_APPROVAL_SS dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 220: from wf_notification_attributes

216:
217: if ( funmode = 'RESPOND' ) then
218: select text_value
219: into lv_result_code
220: from wf_notification_attributes
221: where notification_id=wf_engine.context_nid
222: and name='RESULT';
223:
224: begin

Line 237: from wf_notification_attributes

233: -- WF_NOTE
234: begin
235: select text_value
236: into lv_comments
237: from wf_notification_attributes
238: where notification_id=wf_engine.context_nid
239: and name='WF_NOTE';
240: exception
241: when others then

Line 3079: from wf_notification_attributes

3075: --sturlapa coding starts for bug 3866581
3076: begin
3077: select text_value
3078: into lv_result_code
3079: from wf_notification_attributes
3080: where notification_id=wf_engine.context_nid
3081: and name='RESULT';
3082:
3083: if(funmode='RESPOND' and lv_result_code='RESUBMIT') Then

Line 5499: from wf_notification_attributes wna

5495: p_approval_comments in varchar2)
5496: is
5497: cursor csr_wf_note_exists is
5498: select 1
5499: from wf_notification_attributes wna
5500: where notification_id = p_ntf_id
5501: and NAME = 'WF_NOTE';
5502: l_dummy number(1);
5503: begin