DBA Data[Home] [Help]

APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT dependencies on IEU_UWQ_SEL_RT_NODES

Line 9: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE

5: -- Sub-Program Unit Declarations
6:
7:
8: PROCEDURE UPDATE_SEL_RT_NODE
9: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE

Line 10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE

6:
7:
8: PROCEDURE UPDATE_SEL_RT_NODE
9: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE

Line 11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE

7:
8: PROCEDURE UPDATE_SEL_RT_NODE
9: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE

Line 12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE

8: PROCEDURE UPDATE_SEL_RT_NODE
9: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE

Line 13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE

9: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE
10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE

Line 14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE

10: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE
11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE

Line 15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE

11: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE
12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE

Line 16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE

12: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE
13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE

Line 17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE

13: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE
14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE

Line 18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE

14: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE
15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE

Line 19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE

15: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE
16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23: DEFAULT NULL

Line 20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE

16: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23: DEFAULT NULL
24: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE

Line 21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE

17: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23: DEFAULT NULL
24: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
25: DEFAULT NULL

Line 22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE

18: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
19: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23: DEFAULT NULL
24: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
25: DEFAULT NULL
26: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE

Line 24: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE

20: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
21: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23: DEFAULT NULL
24: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
25: DEFAULT NULL
26: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE
27: DEFAULT NULL -- Niraj, Bug 4389449, Added to handle node depth passed by Media nodes of IEU
28: );

Line 26: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE

22: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
23: DEFAULT NULL
24: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
25: DEFAULT NULL
26: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE
27: DEFAULT NULL -- Niraj, Bug 4389449, Added to handle node depth passed by Media nodes of IEU
28: );
29:
30: PROCEDURE CREATE_MYWORK_NODE