APPS.WF_NOTIFICATION dependencies on WF_NOTIFICATIONS_S

Line 3364: update WF_NOTIFICATIONS set

3360: return;
3361: exception
3362: when inactive_role then
3363: begin
3364: update WF_NOTIFICATIONS set
3365: USER_COMMENT = substr(USER_COMMENT||decode(nvl(USER_COMMENT,'T'),
3366: 'T', null, wf_core.newline)||wf_core.translate('INACTIVE_ROLE'), 1, 4000)
3367: where NOTIFICATION_ID = nid;
3368: exception

Line 3391: update WF_NOTIFICATIONS set

3387: end if;
3388: begin
3389: -- append newcomment to the existing comment.
3390: -- need to add a newline character if user_comment is not null.
3391: update WF_NOTIFICATIONS set
3392: USER_COMMENT = substr(USER_COMMENT||
3393: decode(nvl(USER_COMMENT,'T'),
3394: 'T', null, wf_core.newline)||
3395: Route.newcomment, 1, 4000)

Line 3731: select WF_NOTIFICATIONS_S.NEXTVAL

3727: -- Check role is valid and get mail preference
3728: mailpref := Wf_Notification.GetMailPreference(role, callback, context);
3729:
3730: -- Create new nid and insert notification
3731: select WF_NOTIFICATIONS_S.NEXTVAL
3732: into nid
3733: from SYS.DUAL;
3734:
3735: insert into WF_NOTIFICATIONS (

Line 4484: update WF_NOTIFICATIONS set

4480: -- BUG 2331070 CTILLEY - added update to FROM_ROLE
4481: -- Bug 2474770
4482: -- Update the more_info_role aswell
4483: if (fmode = 'TRANSFER') then
4484: update WF_NOTIFICATIONS set
4485: RECIPIENT_ROLE = ForwardInternal.new_role,
4486: ORIGINAL_RECIPIENT = decode(ForwardInternal.fmode,
4487: 'TRANSFER', ForwardInternal.new_role,
4488: ORIGINAL_RECIPIENT),

Line 4506: update WF_NOTIFICATIONS set

4502: Wf_Notification.SetComments(nid, l_from_role, new_role, 'TRANSFER',
4503: action_source, forward_comment);
4504:
4505: else
4506: update WF_NOTIFICATIONS set
4507: RECIPIENT_ROLE = ForwardInternal.new_role,
4508: ORIGINAL_RECIPIENT = decode(ForwardInternal.fmode,
4509: 'TRANSFER', ForwardInternal.new_role,
4510: ORIGINAL_RECIPIENT),

Line 4741: update WF_NOTIFICATIONS set

4737: else
4738: l_mail := '';
4739: end if;
4740:
4741: update WF_NOTIFICATIONS set
4742: STATUS = 'CANCELED',
4743: END_DATE = sysdate,
4744: -- USER_COMMENT = CancelSingle.newcomment,
4745: MAIL_STATUS = decode(MAIL_STATUS,

Line 10178: l_ntf_status WF_NOTIFICATIONS.STATUS%TYPE;

10174:
10175: l_itemType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE := null;
10176: l_lookupCode_cnt number := 0;
10177: l_lookupType FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE := 'WF_NTF_RESP_DEFER_ITEM_TYPES';
10178: l_ntf_status WF_NOTIFICATIONS.STATUS%TYPE;
10179:
10180: l_dummy_var varchar2(400);
10181: response_found boolean;
10182: