eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT dependencies on IEU_UWQ_SEL_RT_NODES

Line 7: (P_RESOURCE_ID IN IEU_UWQ_SEL_RT_NODES.RESOURCE_ID%TYPE

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

Line 8: ,P_SEL_ENUM_ID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_ID%TYPE

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

Line 9: ,P_NODE_ID IN IEU_UWQ_SEL_RT_NODES.NODE_ID%TYPE

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

Line 10: ,P_NODE_TYPE IN IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE

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

Line 11: ,P_NODE_LABEL IN IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE

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

Line 12: ,P_DATA_SOURCE IN IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE

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

Line 13: ,P_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE

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

Line 14: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE

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

Line 15: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE

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

Line 16: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE

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

Line 17: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE

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

Line 18: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE

14: ,P_MEDIA_TYPE_ID IN IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE
15: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
16: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
17: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
18: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
19: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
20: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
21: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
22: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE -- Added for bug 4389449

Line 19: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE

15: ,P_SEL_ENUM_PID IN IEU_UWQ_SEL_RT_NODES.SEL_ENUM_PID%TYPE
16: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
17: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
18: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
19: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
20: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
21: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
22: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE -- Added for bug 4389449
23: )

Line 20: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE

16: ,P_NODE_PID IN IEU_UWQ_SEL_RT_NODES.NODE_PID%TYPE
17: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
18: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
19: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
20: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
21: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
22: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE -- Added for bug 4389449
23: )
24: AS

Line 21: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE

17: ,P_NODE_WEIGHT IN IEU_UWQ_SEL_RT_NODES.NODE_WEIGHT%TYPE
18: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
19: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
20: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
21: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
22: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE -- Added for bug 4389449
23: )
24: AS
25: l_node_id NUMBER;

Line 22: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE -- Added for bug 4389449

18: ,P_WHERE_CLAUSE IN IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE
19: ,P_HIDE_IF_EMPTY IN IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE
20: ,P_REFRESH_VIEW_NAME IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE
21: ,P_REFRESH_VIEW_SUM_COL IN IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE
22: ,P_NODE_DEPTH IN IEU_UWQ_SEL_RT_NODES.NODE_DEPTH%TYPE -- Added for bug 4389449
23: )
24: AS
25: l_node_id NUMBER;
26: BEGIN

Line 54: UPDATE IEU_UWQ_SEL_RT_NODES

50: -- All subnodes start with a series under the PID.
51: l_node_id := P_NODE_ID + P_NODE_PID;
52:
53: BEGIN
54: UPDATE IEU_UWQ_SEL_RT_NODES
55: SET
56: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
57: LAST_UPDATE_DATE = SYSDATE,
58: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 81: INSERT INTO IEU_UWQ_SEL_RT_NODES

77:
78:
79: IF (SQL%NOTFOUND OR (SQL%ROWCOUNT <= 0)) THEN
80:
81: INSERT INTO IEU_UWQ_SEL_RT_NODES
82: ( SEL_RT_NODE_ID,
83: CREATED_BY,
84: CREATION_DATE,
85: LAST_UPDATED_BY,

Line 107: IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,

103: HIDE_IF_EMPTY,
104: NOT_VALID,
105: NODE_DEPTH) -- Added for bug 4389449
106: VALUES (
107: IEU_UWQ_SEL_RT_NODES_S1.NEXTVAL,
108: FND_GLOBAL.USER_ID,
109: SYSDATE,
110: FND_GLOBAL.USER_ID,
111: SYSDATE,