DBA Data[Home] [Help]

APPS.PO_APPROVAL_REMINDER_SV dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 2805: from wf_item_activity_statuses_v wias, wf_items_v wi

2801: --we want to make sure that the reminder notification with new item key
2802: --is aborted correctly.
2803: Cursor cand_active_wf(l_itemkey VARCHAR2) IS
2804: select wias.activity_status_code, wias.item_key
2805: from wf_item_activity_statuses_v wias, wf_items_v wi
2806: where wias.item_type = 'APVRMDER'
2807: and wias.item_key like l_itemkey||'%'
2808: and wias.item_type = wi.item_type
2809: and wias.item_key = wi.item_key

Line 3076: --wf_item_activity_statuses_v is a view which is based on

3072: BEGIN
3073: x_progress := 'PO_APPROVAL_REMINDER_SV.is_active-001';
3074:
3075: --bug#3693990 commented out the above sql because the view
3076: --wf_item_activity_statuses_v is a view which is based on
3077: --a union all between wf_item_activity_statuses and
3078: --wf_item_activity_statuses_h(history). A new record
3079: --gets inserted into history table when the wf process
3080: --raises an error.

Line 3083: --instead of query the wf_item_activity_statuses_v view directly.

3079: --gets inserted into history table when the wf process
3080: --raises an error.
3081: --WF Team has provided an api wf_engine.itemstatus to check the
3082: --active status of any given activity. We need to call this
3083: --instead of query the wf_item_activity_statuses_v view directly.
3084: BEGIN
3085: wf_engine.itemstatus (itemtype => x_item_type,
3086: itemkey => x_item_key,
3087: status => x_act_status,