DBA Data[Home] [Help]

APPS.PV_ASSIGN_UTIL_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2995: -- wf_item_activity_statuses.notification_id is sometimes null when there is an error

2991:
2992:
2993: -- check root itemkey and all child itemkeys for any errors
2994: -- initially this cursor was using nid but found out that
2995: -- wf_item_activity_statuses.notification_id is sometimes null when there is an error
2996:
2997: -- ignore mailer errors (WFMLRSND_FAILED)
2998:
2999: cursor lc_wf_error_message(pc_itemtype varchar2, pc_itemkey varchar2) is

Line 3001: from wf_item_activity_statuses

2997: -- ignore mailer errors (WFMLRSND_FAILED)
2998:
2999: cursor lc_wf_error_message(pc_itemtype varchar2, pc_itemkey varchar2) is
3000: select error_message , error_stack
3001: from wf_item_activity_statuses
3002: where item_type = pc_itemtype
3003: and item_key in
3004: (select item_key from wf_items
3005: start with item_type = pc_itemtype and item_key = pc_itemkey