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 2279: from wf_notification_attributes

2275: --sturlapa coding starts for bug 3866581
2276: begin
2277: select text_value
2278: into lv_result_code
2279: from wf_notification_attributes
2280: where notification_id=wf_engine.context_nid
2281: and name='RESULT';
2282:
2283: if(funmode='RESPOND' and lv_result_code='RESUBMIT') Then

Line 4458: from wf_notification_attributes wna

4454: p_approval_comments in varchar2)
4455: is
4456: cursor csr_wf_note_exists is
4457: select 1
4458: from wf_notification_attributes wna
4459: where notification_id = p_ntf_id
4460: and NAME = 'WF_NOTE';
4461: l_dummy number(1);
4462: begin