37: delete from wf_item_attribute_values
38: where Item_type = X_Item_type
39: and Item_key = X_Item_key;
40:
41: -- wf_items
42: delete from wf_items
43: where Item_type = X_Item_type
44: and Item_key = X_Item_key;
45: end;
38: where Item_type = X_Item_type
39: and Item_key = X_Item_key;
40:
41: -- wf_items
42: delete from wf_items
43: where Item_type = X_Item_type
44: and Item_key = X_Item_key;
45: end;
46:
44: and Item_key = X_Item_key;
45: end;
46:
47:
48: -- repopulates WF_ITEMS
49: procedure import_item_row(
50: X_ITEM_TYPE VARCHAR2,
51: X_ITEM_KEY VARCHAR2,
52: X_ROOT_ACTIVITY VARCHAR2,
60: X_USER_KEY VARCHAR2,
61: X_HA_MIGRATION_FLAG VARCHAR2) is
62:
63: begin
64: insert into WF_ITEMS
65: (ITEM_TYPE, ITEM_KEY, ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION,
66: OWNER_ROLE, PARENT_ITEM_TYPE, PARENT_ITEM_KEY, PARENT_CONTEXT,
67: BEGIN_DATE, END_DATE, USER_KEY, HA_MIGRATION_FLAG)
68: select X_ITEM_TYPE, X_ITEM_KEY, X_ROOT_ACTIVITY, X_ROOT_ACTIVITY_VERSION,