DBA Data[Home] [Help]

APPS.WF_ENGINE_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 1585: -- WF_ITEM_ACTIVITY_STATUSES_H table.

1581:
1582: --
1583: -- Move_To_History (PRIVATE)
1584: -- Move the item activity status row from WF_ITEM_ACTIVITY_STATUSES to
1585: -- WF_ITEM_ACTIVITY_STATUSES_H table.
1586: -- IN
1587: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
1588: -- itemkey - A string generated from the application object's primary key.
1589: -- actid - The activity instance id.

Line 1598: INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (

1594: begin
1595:
1596: -- Copy row to history table, changing status to COMPLETE/#FORCE
1597: -- if status is not already complete.
1598: INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (
1599: ITEM_TYPE,
1600: ITEM_KEY,
1601: PROCESS_ACTIVITY,
1602: ACTIVITY_STATUS,

Line 1644: -- INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (

1640:
1641: -- 3966635 Workflow Provisioning Project
1642: -- Insert added so as not to loose the change. This insert
1643: -- should replace the one above.
1644: -- INSERT INTO WF_ITEM_ACTIVITY_STATUSES_H (
1645: -- ITEM_TYPE,
1646: -- ITEM_KEY,
1647: -- PROCESS_ACTIVITY,
1648: -- ACTIVITY_STATUS,

Line 2875: from wf_item_activity_statuses_h ias,

2871: cursor message_attrs_cursor(itemtype varchar2, itemkey varchar2) is
2872: select ma.NAME, ma.TYPE, ma.SUBTYPE,
2873: ma.TEXT_DEFAULT, ma.NUMBER_DEFAULT, ma.DATE_DEFAULT,
2874: n.notification_id
2875: from wf_item_activity_statuses_h ias,
2876: wf_notifications n,
2877: wf_message_attributes ma
2878: where ias.item_type = itemtype
2879: and ias.item_key = itemkey