APPS.POR_UTIL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 996: from wf_item_activity_statuses

992: and parent_item_key = l_wf_itemkey;
993:
994: cursor wf_notifs (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
995: select notification_id
996: from wf_item_activity_statuses
997: where item_type = l_wf_itemtype
998: and item_key = l_wf_itemkey
999: and notification_id is not null;
1000:

Line 2116: FROM wf_item_activity_statuses wfs,

2112:
2113: BEGIN
2114: SELECT NVL(activity_status, 'N')
2115: INTO l_activity_status
2116: FROM wf_item_activity_statuses wfs,
2117: wf_items wfi,
2118: wf_process_activities wfa
2119: WHERE wfi.item_type = l_item_type
2120: and wfi.item_key = l_item_key

Line 2155: FROM wf_item_activity_statuses wfs,

2151:
2152: BEGIN
2153: SELECT NVL(activity_status, 'N')
2154: INTO l_activity_status
2155: FROM wf_item_activity_statuses wfs,
2156: wf_items wfi,
2157: wf_process_activities wfa
2158: WHERE wfi.item_type = l_item_type
2159: and wfi.item_key = c1_rec.item_key

Line 2862: from wf_item_activity_statuses stat,

2858: PROCEDURE cancel_workflow(p_headerId in NUMBER) IS
2859:
2860: cursor c1(itemtype varchar2, itemkey varchar2) is
2861: select stat.notification_id
2862: from wf_item_activity_statuses stat,
2863: wf_items item
2864: where stat.item_type = itemtype
2865: AND item.item_type = itemtype
2866: AND item.parent_item_key = itemkey

Line 2871: from wf_item_activity_statuses

2867: AND stat.item_key = item.item_key
2868: AND stat.activity_status = 'NOTIFIED'
2869: UNION
2870: select notification_id
2871: from wf_item_activity_statuses
2872: where item_type = itemtype
2873: AND item_key = itemkey
2874: AND activity_status = 'NOTIFIED'
2875: AND notification_id is NOT NULL;