APPS.WF_ITEM_IMPORT dependencies on WF_NOTIFICATIONS

Line 18: -- wf_notifications

14: from wf_ha_ntfa_v v
15: where v.Item_type = X_Item_type
16: and v.Item_key = X_Item_key);
17:
18: -- wf_notifications
19: delete from wf_notifications
20: where rowid in
21: (select row_id
22: from wf_ha_ntf_v v

Line 19: delete from wf_notifications

15: where v.Item_type = X_Item_type
16: and v.Item_key = X_Item_key);
17:
18: -- wf_notifications
19: delete from wf_notifications
20: where rowid in
21: (select row_id
22: from wf_ha_ntf_v v
23: where v.Item_type = X_Item_type

Line 175: -- repopulates WF_NOTIFICATIONS

171: X_ERROR_STACK, hextoraw(X_OUTBOUND_QUEUE_ID), X_DUE_DATE
172: from dual;
173: end;
174:
175: -- repopulates WF_NOTIFICATIONS
176: procedure import_ntf_row(
177: X_NOTIFICATION_ID NUMBER,
178: X_GROUP_ID NUMBER,
179: X_MESSAGE_TYPE VARCHAR2,

Line 201: insert into WF_NOTIFICATIONS

197: X_LANGUAGE VARCHAR2,
198: X_MORE_INFO_ROLE VARCHAR2) is
199:
200: begin
201: insert into WF_NOTIFICATIONS
202: (NOTIFICATION_ID, GROUP_ID, MESSAGE_TYPE, MESSAGE_NAME,
203: RECIPIENT_ROLE, STATUS, ACCESS_KEY, MAIL_STATUS, PRIORITY,
204: BEGIN_DATE, END_DATE, DUE_DATE, RESPONDER, USER_COMMENT,
205: CALLBACK, CONTEXT, ORIGINAL_RECIPIENT, FROM_USER, TO_USER,