APPS.WF_ITEM_IMPORT dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 10: -- wf_notification_attributes

6:
7: procedure erase(X_Item_type VARCHAR2, X_Item_key VARCHAR2) is
8:
9: begin
10: -- wf_notification_attributes
11: delete from wf_notification_attributes
12: where rowid in
13: (select row_id
14: from wf_ha_ntfa_v v

Line 11: delete from wf_notification_attributes

7: procedure erase(X_Item_type VARCHAR2, X_Item_key VARCHAR2) is
8:
9: begin
10: -- wf_notification_attributes
11: delete from wf_notification_attributes
12: where rowid in
13: (select row_id
14: from wf_ha_ntfa_v v
15: where v.Item_type = X_Item_type

Line 217: -- repopulates WF_NOTIFICATION_ATTRIBUTES

213: end;
214:
215:
216:
217: -- repopulates WF_NOTIFICATION_ATTRIBUTES
218: procedure import_ntf_attr_row(
219: X_NOTIFICATION_ID NUMBER,
220: X_NAME VARCHAR2,
221: X_TEXT_VALUE VARCHAR2,

Line 226: insert into WF_NOTIFICATION_ATTRIBUTES

222: X_NUMBER_VALUE NUMBER,
223: X_DATE_VALUE DATE) is
224:
225: begin
226: insert into WF_NOTIFICATION_ATTRIBUTES
227: (NOTIFICATION_ID, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
228: select X_NOTIFICATION_ID, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
229: X_DATE_VALUE
230: from dual;