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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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