APPS.AMS_TASK_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 13: -- 05/12/04 vmodur Changed query to use wf_item_activity_statuses instead

9: -- 10/12/99 abhola Create.
10: -- 09/15/00 gjoby Modified to add workfow
11: -- 09/21/00 gjoby Modified to close thee cursor in delete tasks procedure
12: -- 04/15/01 musman commented out the call to the ams_object_attribute.
13: -- 05/12/04 vmodur Changed query to use wf_item_activity_statuses instead
14: -- of wf_item_activity_statuses_v for SQL Repository Perf Fix
15: ---------------------------------------------------------------------
16: --
17: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

Line 14: -- of wf_item_activity_statuses_v for SQL Repository Perf Fix

10: -- 09/15/00 gjoby Modified to add workfow
11: -- 09/21/00 gjoby Modified to close thee cursor in delete tasks procedure
12: -- 04/15/01 musman commented out the call to the ams_object_attribute.
13: -- 05/12/04 vmodur Changed query to use wf_item_activity_statuses instead
14: -- of wf_item_activity_statuses_v for SQL Repository Perf Fix
15: ---------------------------------------------------------------------
16: --
17: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
18: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 253: FROM wf_item_activity_statuses

249: -- For checking if workflow exists for this task
250: -- Workflow is with item_key as task_id || object_version_number
251: CURSOR c_check_wfprocess is
252: SELECT 'x'
253: FROM wf_item_activity_statuses
254: WHERE item_type = 'AMSTASK'
255: AND item_key like l_task_id || '%'
256: AND activity_status = 'ACTIVE';
257: CURSOR c_check_status is

Line 482: FROM wf_item_activity_statuses

478: -- For checking if workflow exists for this task
479: -- Workflow is with item_key as task_id || object_version_number
480: CURSOR c_check_wfprocess is
481: SELECT 'x'
482: FROM wf_item_activity_statuses
483: WHERE item_type = 'AMSTASK'
484: AND item_key like l_task_id || '%'
485: AND activity_status = 'ACTIVE';
486: