APPS.WF_ENGINE_UTIL dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 2791: insert into WF_NOTIFICATION_ATTRIBUTES (

2787: replace(ntf_row.CONTEXT,':'||old_itemkey||':',':'||new_itemkey||':'));
2788:
2789:
2790: -- create notification attributes
2791: insert into WF_NOTIFICATION_ATTRIBUTES (
2792: NOTIFICATION_ID,
2793: NAME,
2794: TEXT_VALUE,
2795: NUMBER_VALUE,

Line 2803: from WF_NOTIFICATION_ATTRIBUTES

2799: NAME,
2800: TEXT_VALUE,
2801: NUMBER_VALUE,
2802: DATE_VALUE
2803: from WF_NOTIFICATION_ATTRIBUTES
2804: where notification_id = ntf_row.notification_id
2805: union all
2806: select nid,
2807: NAME,

Line 2816: from WF_NOTIFICATION_ATTRIBUTES

2812: where MESSAGE_TYPE = ntf_row.MESSAGE_TYPE
2813: and MESSAGE_NAME = ntf_row.MESSAGE_NAME
2814: and name not in
2815: (select name
2816: from WF_NOTIFICATION_ATTRIBUTES
2817: where notification_id = ntf_row.notification_id);
2818:
2819: -- Copy associated Notification Comments
2820: INSERT INTO wf_comments

Line 2912: update WF_NOTIFICATION_ATTRIBUTES

2908:
2909: --
2910: -- Update the notification attribute
2911: --
2912: update WF_NOTIFICATION_ATTRIBUTES
2913: set TEXT_VALUE = attr_tvalue,
2914: NUMBER_VALUE = attr_nvalue,
2915: DATE_VALUE = attr_dvalue
2916: where notification_id = message_attr_row.notification_id