APPS.WF_NOTIFICATION dependencies on WF_NOTIFICATIONS_S

Line 3254: update WF_NOTIFICATIONS set

3250: return;
3251: exception
3252: when inactive_role then
3253: begin
3254: update WF_NOTIFICATIONS set
3255: USER_COMMENT = substr(USER_COMMENT||decode(nvl(USER_COMMENT,'T'),
3256: 'T', null, wf_core.newline)||wf_core.translate('INACTIVE_ROLE'), 1, 4000)
3257: where NOTIFICATION_ID = nid;
3258: exception

Line 3277: update WF_NOTIFICATIONS set

3273: 1, 4000);
3274: begin
3275: -- append newcomment to the existing comment.
3276: -- need to add a newline character if user_comment is not null.
3277: update WF_NOTIFICATIONS set
3278: USER_COMMENT = substr(USER_COMMENT||
3279: decode(nvl(USER_COMMENT,'T'),
3280: 'T', null, wf_core.newline)||
3281: Route.newcomment, 1, 4000)

Line 3616: select WF_NOTIFICATIONS_S.NEXTVAL

3612: -- Check role is valid and get mail preference
3613: mailpref := Wf_Notification.GetMailPreference(role, callback, context);
3614:
3615: -- Create new nid and insert notification
3616: select WF_NOTIFICATIONS_S.NEXTVAL
3617: into nid
3618: from SYS.DUAL;
3619:
3620: insert into WF_NOTIFICATIONS (

Line 4321: update WF_NOTIFICATIONS set

4317: -- BUG 2331070 CTILLEY - added update to FROM_ROLE
4318: -- Bug 2474770
4319: -- Update the more_info_role aswell
4320: if (fmode = 'TRANSFER') then
4321: update WF_NOTIFICATIONS set
4322: RECIPIENT_ROLE = ForwardInternal.new_role,
4323: ORIGINAL_RECIPIENT = decode(ForwardInternal.fmode,
4324: 'TRANSFER', ForwardInternal.new_role,
4325: ORIGINAL_RECIPIENT),

Line 4342: update WF_NOTIFICATIONS set

4338: Wf_Notification.SetComments(nid, l_from_role, new_role, 'TRANSFER',
4339: action_source, forward_comment);
4340:
4341: else
4342: update WF_NOTIFICATIONS set
4343: RECIPIENT_ROLE = ForwardInternal.new_role,
4344: ORIGINAL_RECIPIENT = decode(ForwardInternal.fmode,
4345: 'TRANSFER', ForwardInternal.new_role,
4346: ORIGINAL_RECIPIENT),

Line 4576: update WF_NOTIFICATIONS set

4572: else
4573: l_mail := '';
4574: end if;
4575:
4576: update WF_NOTIFICATIONS set
4577: STATUS = 'CANCELED',
4578: END_DATE = sysdate,
4579: -- USER_COMMENT = CancelSingle.newcomment,
4580: MAIL_STATUS = decode(MAIL_STATUS,