23: TYPE BindValList IS TABLE OF BindValInfo
24: INDEX BY BINARY_INTEGER;
25:
26: /*Bug 6399243 Commented the code
27: TYPE IEU_UWQ_SEL_RT_NODES_REC IS RECORD (
28: SEL_RT_NODE_ID NUMBER,
29: CREATED_BY NUMBER,
30: CREATION_DATE DATE,
31: LAST_UPDATED_BY NUMBER,
34: RESOURCE_ID NUMBER,
35: SEL_ENUM_ID NUMBER,
36: NODE_ID NUMBER,
37: NODE_TYPE NUMBER,
38: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
39: COUNT NUMBER,
40: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
41: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
42: MEDIA_TYPE_ID NUMBER,
36: NODE_ID NUMBER,
37: NODE_TYPE NUMBER,
38: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
39: COUNT NUMBER,
40: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
41: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
42: MEDIA_TYPE_ID NUMBER,
43: SEL_ENUM_PID NUMBER,
44: NODE_PID NUMBER,
37: NODE_TYPE NUMBER,
38: NODE_LABEL IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE,
39: COUNT NUMBER,
40: DATA_SOURCE IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE,
41: VIEW_NAME IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE,
42: MEDIA_TYPE_ID NUMBER,
43: SEL_ENUM_PID NUMBER,
44: NODE_PID NUMBER,
45: NODE_WEIGHT NUMBER,
42: MEDIA_TYPE_ID NUMBER,
43: SEL_ENUM_PID NUMBER,
44: NODE_PID NUMBER,
45: NODE_WEIGHT NUMBER,
46: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
47: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
48: NOT_VALID IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE,
49: SECURITY_GROUP_ID NUMBER,
50: OBJECT_VERSION_NUMBER NUMBER,
43: SEL_ENUM_PID NUMBER,
44: NODE_PID NUMBER,
45: NODE_WEIGHT NUMBER,
46: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
47: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
48: NOT_VALID IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE,
49: SECURITY_GROUP_ID NUMBER,
50: OBJECT_VERSION_NUMBER NUMBER,
51: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
44: NODE_PID NUMBER,
45: NODE_WEIGHT NUMBER,
46: WHERE_CLAUSE IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE,
47: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
48: NOT_VALID IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE,
49: SECURITY_GROUP_ID NUMBER,
50: OBJECT_VERSION_NUMBER NUMBER,
51: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
52: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
47: HIDE_IF_EMPTY IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE,
48: NOT_VALID IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE,
49: SECURITY_GROUP_ID NUMBER,
50: OBJECT_VERSION_NUMBER NUMBER,
51: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
52: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
53: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE,
54: NODE_DEPTH NUMBER
55: );
48: NOT_VALID IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE,
49: SECURITY_GROUP_ID NUMBER,
50: OBJECT_VERSION_NUMBER NUMBER,
51: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
52: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
53: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE,
54: NODE_DEPTH NUMBER
55: );
56:
49: SECURITY_GROUP_ID NUMBER,
50: OBJECT_VERSION_NUMBER NUMBER,
51: REFRESH_VIEW_NAME IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE,
52: RES_CAT_ENUM_FLAG IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE,
53: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE,
54: NODE_DEPTH NUMBER
55: );
56:
57: TYPE IEU_UWQ_SEL_RT_NODES_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES_REC
53: REFRESH_VIEW_SUM_COL IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE,
54: NODE_DEPTH NUMBER
55: );
56:
57: TYPE IEU_UWQ_SEL_RT_NODES_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES_REC
58: INDEX BY BINARY_INTEGER;
59: */
60:
61: TYPE IEU_UWQ_SEL_RT_NODES_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES%ROWTYPE
57: TYPE IEU_UWQ_SEL_RT_NODES_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES_REC
58: INDEX BY BINARY_INTEGER;
59: */
60:
61: TYPE IEU_UWQ_SEL_RT_NODES_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES%ROWTYPE
62: INDEX BY BINARY_INTEGER;
63:
64:
65: /*Bug 6399243 Commented the code
90:
91: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
92: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
93:
94: TYPE NODE_LABEL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE INDEX BY BINARY_INTEGER;
95: TYPE DATA_SOURCE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE INDEX BY BINARY_INTEGER;
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
91: TYPE NUMBER_TAB IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
92: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
93:
94: TYPE NODE_LABEL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE INDEX BY BINARY_INTEGER;
95: TYPE DATA_SOURCE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE INDEX BY BINARY_INTEGER;
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
92: TYPE DATE_TAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
93:
94: TYPE NODE_LABEL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE INDEX BY BINARY_INTEGER;
95: TYPE DATA_SOURCE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE INDEX BY BINARY_INTEGER;
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
93:
94: TYPE NODE_LABEL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE INDEX BY BINARY_INTEGER;
95: TYPE DATA_SOURCE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE INDEX BY BINARY_INTEGER;
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
101: TYPE RES_CAT_ENUM_FLAG_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE INDEX BY BINARY_INTEGER;
94: TYPE NODE_LABEL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NODE_LABEL%TYPE INDEX BY BINARY_INTEGER;
95: TYPE DATA_SOURCE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE INDEX BY BINARY_INTEGER;
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
101: TYPE RES_CAT_ENUM_FLAG_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE INDEX BY BINARY_INTEGER;
102: TYPE REFRESH_VIEW_SUM_COL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE INDEX BY BINARY_INTEGER;
95: TYPE DATA_SOURCE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.DATA_SOURCE%TYPE INDEX BY BINARY_INTEGER;
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
101: TYPE RES_CAT_ENUM_FLAG_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE INDEX BY BINARY_INTEGER;
102: TYPE REFRESH_VIEW_SUM_COL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE INDEX BY BINARY_INTEGER;
103:
96: TYPE VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
101: TYPE RES_CAT_ENUM_FLAG_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE INDEX BY BINARY_INTEGER;
102: TYPE REFRESH_VIEW_SUM_COL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE BIND_VAR_NAME_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE INDEX BY BINARY_INTEGER;
97: TYPE WHERE_CLAUSE_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.WHERE_CLAUSE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
101: TYPE RES_CAT_ENUM_FLAG_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE INDEX BY BINARY_INTEGER;
102: TYPE REFRESH_VIEW_SUM_COL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE BIND_VAR_NAME_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE INDEX BY BINARY_INTEGER;
105: TYPE BIND_VAR_VALUE_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE INDEX BY BINARY_INTEGER;
98: TYPE HIDE_IF_EMPTY_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.HIDE_IF_EMPTY%TYPE INDEX BY BINARY_INTEGER;
99: TYPE NOT_VALID_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.NOT_VALID%TYPE INDEX BY BINARY_INTEGER;
100: TYPE REFRESH_VIEW_NAME_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_NAME%TYPE INDEX BY BINARY_INTEGER;
101: TYPE RES_CAT_ENUM_FLAG_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.RES_CAT_ENUM_FLAG%TYPE INDEX BY BINARY_INTEGER;
102: TYPE REFRESH_VIEW_SUM_COL_TAB IS TABLE OF IEU_UWQ_SEL_RT_NODES.REFRESH_VIEW_SUM_COL%TYPE INDEX BY BINARY_INTEGER;
103:
104: TYPE BIND_VAR_NAME_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE INDEX BY BINARY_INTEGER;
105: TYPE BIND_VAR_VALUE_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE INDEX BY BINARY_INTEGER;
106: TYPE BIND_VAR_DATATYPE_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE INDEX BY BINARY_INTEGER;