APPS.WF_ITEM_IMPORT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

   delete from wf_notification_attributes
   where rowid in
      (select row_id
	 from wf_ha_ntfa_v v
        where v.Item_type = X_Item_type
	  and v.Item_key = X_Item_key);

Line: 19

   delete from wf_notifications
   where rowid in
      (select row_id
         from wf_ha_ntf_v v
        where v.Item_type = X_Item_type
          and v.Item_key = X_Item_key);

Line: 27

   delete from wf_item_activity_statuses
   where Item_type = X_Item_type
     and Item_key = X_Item_key;

Line: 32

   delete from wf_item_activity_statuses_h
   where Item_type = X_Item_type
     and Item_key = X_Item_key;

Line: 37

   delete from wf_item_attribute_values
      where Item_type = X_Item_type
     and Item_key = X_Item_key;

Line: 42

   delete from wf_items
      where Item_type = X_Item_type
     and Item_key = X_Item_key;

Line: 64

    insert into WF_ITEMS
    (ITEM_TYPE, ITEM_KEY, ROOT_ACTIVITY, ROOT_ACTIVITY_VERSION,
     OWNER_ROLE, PARENT_ITEM_TYPE, PARENT_ITEM_KEY, PARENT_CONTEXT,
     BEGIN_DATE, END_DATE, USER_KEY, HA_MIGRATION_FLAG)
     select X_ITEM_TYPE, X_ITEM_KEY, X_ROOT_ACTIVITY, X_ROOT_ACTIVITY_VERSION,
     X_OWNER_ROLE, X_PARENT_ITEM_TYPE, X_PARENT_ITEM_KEY, X_PARENT_CONTEXT,
     X_BEGIN_DATE, X_END_DATE, X_USER_KEY, X_HA_MIGRATION_FLAG
     from dual;

Line: 85

    insert into WF_ITEM_ATTRIBUTE_VALUES
    (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE,
	EVENT_VALUE)
    select X_ITEM_TYPE, X_ITEM_KEY, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
     X_DATE_VALUE, X_EVENT_VALUE
     from dual;

Line: 106

    insert into WF_ITEM_ATTRIBUTE_VALUES
    (ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
    select X_ITEM_TYPE, X_ITEM_KEY, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
     X_DATE_VALUE
     from dual;

Line: 132

    insert into WF_ITEM_ACTIVITY_STATUSES
    (ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS,
     ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE,
     END_DATE, EXECUTION_TIME, ERROR_NAME, ERROR_MESSAGE,
     ERROR_STACK, OUTBOUND_QUEUE_ID, DUE_DATE)
    select X_ITEM_TYPE, X_ITEM_KEY, X_PROCESS_ACTIVITY, X_ACTIVITY_STATUS,
     X_ACTIVITY_RESULT_CODE, X_ASSIGNED_USER, X_NOTIFICATION_ID, X_BEGIN_DATE,
     X_END_DATE, X_EXECUTION_TIME, X_ERROR_NAME, X_ERROR_MESSAGE,
     X_ERROR_STACK, hextoraw(X_OUTBOUND_QUEUE_ID), X_DUE_DATE
    from dual;

Line: 163

    insert into WF_ITEM_ACTIVITY_STATUSES_H
    (ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS,
     ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE,
     END_DATE, EXECUTION_TIME, ERROR_NAME, ERROR_MESSAGE,
     ERROR_STACK, OUTBOUND_QUEUE_ID, DUE_DATE)
    select X_ITEM_TYPE, X_ITEM_KEY, X_PROCESS_ACTIVITY, X_ACTIVITY_STATUS,
     X_ACTIVITY_RESULT_CODE, X_ASSIGNED_USER, X_NOTIFICATION_ID, X_BEGIN_DATE,
     X_END_DATE, X_EXECUTION_TIME, X_ERROR_NAME, X_ERROR_MESSAGE,
     X_ERROR_STACK, hextoraw(X_OUTBOUND_QUEUE_ID), X_DUE_DATE
    from dual;

Line: 201

    insert into WF_NOTIFICATIONS
    (NOTIFICATION_ID, GROUP_ID, MESSAGE_TYPE, MESSAGE_NAME,
     RECIPIENT_ROLE, STATUS, ACCESS_KEY, MAIL_STATUS, PRIORITY,
     BEGIN_DATE, END_DATE, DUE_DATE, RESPONDER, USER_COMMENT,
     CALLBACK, CONTEXT, ORIGINAL_RECIPIENT, FROM_USER, TO_USER,
     SUBJECT, LANGUAGE, MORE_INFO_ROLE)
    select X_NOTIFICATION_ID, X_GROUP_ID, X_MESSAGE_TYPE, X_MESSAGE_NAME,
     X_RECIPIENT_ROLE, X_STATUS, X_ACCESS_KEY, X_MAIL_STATUS, X_PRIORITY,
     X_BEGIN_DATE, X_END_DATE, X_DUE_DATE, X_RESPONDER, X_USER_COMMENT,
     X_CALLBACK, X_CONTEXT, X_ORIGINAL_RECIPIENT, X_FROM_USER, X_TO_USER,
     X_SUBJECT, X_LANGUAGE, X_MORE_INFO_ROLE
    from dual;

Line: 226

    insert into WF_NOTIFICATION_ATTRIBUTES
    (NOTIFICATION_ID, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE)
    select X_NOTIFICATION_ID, X_NAME, X_TEXT_VALUE, X_NUMBER_VALUE,
	X_DATE_VALUE
    from dual;