DBA Data[Home] [Help]

APPS.WF_NOTIFICATION_UTIL dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 33: update WF_NOTIFICATION_ATTRIBUTES

29: wf_core.raise('WFSQL_ARGS');
30: end if;
31:
32: -- Update attribute value
33: update WF_NOTIFICATION_ATTRIBUTES
34: set EVENT_VALUE = avalue
35: where NOTIFICATION_ID = nid and NAME = aname;
36:
37: if (SQL%NOTFOUND) then

Line 72: from WF_NOTIFICATION_ATTRIBUTES WNA

68:
69: begin
70: select WNA.EVENT_VALUE
71: into lvalue
72: from WF_NOTIFICATION_ATTRIBUTES WNA
73: where WNA.NOTIFICATION_ID = nid and WNA.NAME = aname;
74: exception
75: when no_data_found then
76: wf_core.token('NID', to_char(nid));