2: /* $Header: IEU_PS.pls 120.0 2005/06/02 15:42:38 appldev noship $ */
3:
4:
5: TYPE EnumeratorDataRecord IS RECORD (
6: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
7: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
3:
4:
5: TYPE EnumeratorDataRecord IS RECORD (
6: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
7: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
4:
5: TYPE EnumeratorDataRecord IS RECORD (
6: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
7: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
5: TYPE EnumeratorDataRecord IS RECORD (
6: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
7: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13: NODE_DEPTH NUMBER(2),
6: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
7: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13: NODE_DEPTH NUMBER(2),
14: BIND_VARS VARCHAR2(4000),
7: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13: NODE_DEPTH NUMBER(2),
14: BIND_VARS VARCHAR2(4000),
15: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
8: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
9: MEDIA_TYPE_ID IEU_UWQ_SEL_RT_NODES.MEDIA_TYPE_ID%TYPE,
10: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13: NODE_DEPTH NUMBER(2),
14: BIND_VARS VARCHAR2(4000),
15: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
16: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
11: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13: NODE_DEPTH NUMBER(2),
14: BIND_VARS VARCHAR2(4000),
15: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
16: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
17: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL
18: );
19:
12: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
13: NODE_DEPTH NUMBER(2),
14: BIND_VARS VARCHAR2(4000),
15: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
16: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
17: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL
18: );
19:
20: TYPE EnumeratorDataRecordList IS
13: NODE_DEPTH NUMBER(2),
14: BIND_VARS VARCHAR2(4000),
15: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
16: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
17: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL
18: );
19:
20: TYPE EnumeratorDataRecordList IS
21: TABLE OF EnumeratorDataRecord INDEX BY BINARY_INTEGER;
38: TYPE PluginDataRecList IS
39: TABLE OF PluginDataRecord INDEX BY BINARY_INTEGER;
40:
41: TYPE NodeDetailRecord IS RECORD (
42: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
43: NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
44: COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
39: TABLE OF PluginDataRecord INDEX BY BINARY_INTEGER;
40:
41: TYPE NodeDetailRecord IS RECORD (
42: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
43: NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
44: COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
47: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL,
41: TYPE NodeDetailRecord IS RECORD (
42: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
43: NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
44: COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
47: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL,
48: RAW_NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
49: RAW_COMPLETE_WHERE_CLAUSE VARCHAR2(4000)
42: NODE_TYPE IEU_UWQ_SEL_RT_NODES.NODE_TYPE%TYPE,
43: NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
44: COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
47: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL,
48: RAW_NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
49: RAW_COMPLETE_WHERE_CLAUSE VARCHAR2(4000)
50: );
43: NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
44: COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
47: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL,
48: RAW_NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
49: RAW_COMPLETE_WHERE_CLAUSE VARCHAR2(4000)
50: );
51:
44: COMPLETE_WHERE_CLAUSE VARCHAR2(4000),
45: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
46: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
47: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE := NULL,
48: RAW_NODE_RUNTIME_WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
49: RAW_COMPLETE_WHERE_CLAUSE VARCHAR2(4000)
50: );
51:
52: TYPE NodeDetailRecList IS