DBA Data[Home] [Help]

APPS.IEU_UWQM_TASK_WL_MIG dependencies on IEU_UWQM_TASK_PRIORITY_NST

Line 5: RETURN SYSTEM.IEU_UWQM_TASK_PRIORITY_NST AS

1: PACKAGE BODY IEU_UWQM_TASK_WL_MIG AS
2: /* $Header: IEUVTKPB.pls 120.2 2006/05/02 12:21:54 pkumble noship $ */
3:
4: FUNCTION GET_TASKS_BY_PRIORITY
5: RETURN SYSTEM.IEU_UWQM_TASK_PRIORITY_NST AS
6:
7: l_priority_list l_pty_list;
8:
9: cursor l_tasks_cur is

Line 24: l_return_list SYSTEM.IEU_UWQM_TASK_PRIORITY_NST;

20: i number := 0;
21:
22: l_null_pty_count Number;
23:
24: l_return_list SYSTEM.IEU_UWQM_TASK_PRIORITY_NST;
25:
26: begin
27:
28: for ctr in l_tasks_cur loop

Line 57: l_return_list := SYSTEM.IEU_UWQM_TASK_PRIORITY_NST();

53: l_priority_list(ctr).task_count := l_priority_list(ctr).task_count + l_null_pty_count;
54: end if;
55: end loop;
56:
57: l_return_list := SYSTEM.IEU_UWQM_TASK_PRIORITY_NST();
58: for k in 1..l_priority_list.count loop
59: l_return_list.extend;
60: l_return_list(l_return_list.last) := SYSTEM.IEU_UWQM_TASK_PRIORITY_OBJ(l_priority_list(k).importance_level, l_priority_list(k).task_count);
61: end loop;