13: TYPE EligibleMediaList IS TABLE OF EligibleMediaInfo
14: INDEX BY BINARY_INTEGER;
15:
16: TYPE BindValInfo IS RECORD (
17: sel_rt_node_id IEU_UWQ_RTNODE_BIND_VALS.SEL_RT_NODE_ID%TYPE,
18: node_id IEU_UWQ_RTNODE_BIND_VALS.NODE_ID%TYPE,
19: bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
20: bind_var_value IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE
21: );
14: INDEX BY BINARY_INTEGER;
15:
16: TYPE BindValInfo IS RECORD (
17: sel_rt_node_id IEU_UWQ_RTNODE_BIND_VALS.SEL_RT_NODE_ID%TYPE,
18: node_id IEU_UWQ_RTNODE_BIND_VALS.NODE_ID%TYPE,
19: bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
20: bind_var_value IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE
21: );
22:
15:
16: TYPE BindValInfo IS RECORD (
17: sel_rt_node_id IEU_UWQ_RTNODE_BIND_VALS.SEL_RT_NODE_ID%TYPE,
18: node_id IEU_UWQ_RTNODE_BIND_VALS.NODE_ID%TYPE,
19: bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
20: bind_var_value IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE
21: );
22:
23: TYPE BindValList IS TABLE OF BindValInfo
16: TYPE BindValInfo IS RECORD (
17: sel_rt_node_id IEU_UWQ_RTNODE_BIND_VALS.SEL_RT_NODE_ID%TYPE,
18: node_id IEU_UWQ_RTNODE_BIND_VALS.NODE_ID%TYPE,
19: bind_var_name IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
20: bind_var_value IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE
21: );
22:
23: TYPE BindValList IS TABLE OF BindValInfo
24: INDEX BY BINARY_INTEGER;
62: INDEX BY BINARY_INTEGER;
63:
64:
65: /*Bug 6399243 Commented the code
66: TYPE IEU_UWQ_RTNODE_BIND_VALS_REC IS RECORD (
67: RTNODE_BIND_VAR_ID NUMBER,
68: OBJECT_VERSION_NUMBER NUMBER,
69: CREATED_BY NUMBER,
70: CREATION_DATE DATE,
74: SECURITY_GROUP_ID NUMBER,
75: SEL_RT_NODE_ID NUMBER,
76: RESOURCE_ID NUMBER,
77: NODE_ID NUMBER,
78: BIND_VAR_NAME IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
79: BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE,
80: BIND_VAR_DATATYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE,
81: NOT_VALID_FLAG IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE
82: );
75: SEL_RT_NODE_ID NUMBER,
76: RESOURCE_ID NUMBER,
77: NODE_ID NUMBER,
78: BIND_VAR_NAME IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
79: BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE,
80: BIND_VAR_DATATYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE,
81: NOT_VALID_FLAG IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE
82: );
83:
76: RESOURCE_ID NUMBER,
77: NODE_ID NUMBER,
78: BIND_VAR_NAME IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
79: BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE,
80: BIND_VAR_DATATYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE,
81: NOT_VALID_FLAG IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE
82: );
83:
84: TYPE IEU_UWQ_RTNODE_BIND_VALS_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS_REC
77: NODE_ID NUMBER,
78: BIND_VAR_NAME IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_NAME%TYPE,
79: BIND_VAR_VALUE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_VALUE%TYPE,
80: BIND_VAR_DATATYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE,
81: NOT_VALID_FLAG IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE
82: );
83:
84: TYPE IEU_UWQ_RTNODE_BIND_VALS_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS_REC
85: INDEX BY BINARY_INTEGER;
80: BIND_VAR_DATATYPE IEU_UWQ_RTNODE_BIND_VALS.BIND_VAR_DATATYPE%TYPE,
81: NOT_VALID_FLAG IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE
82: );
83:
84: TYPE IEU_UWQ_RTNODE_BIND_VALS_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS_REC
85: INDEX BY BINARY_INTEGER;
86: */
87:
88: TYPE IEU_UWQ_RTNODE_BIND_VALS_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS%ROWTYPE
84: TYPE IEU_UWQ_RTNODE_BIND_VALS_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS_REC
85: INDEX BY BINARY_INTEGER;
86: */
87:
88: TYPE IEU_UWQ_RTNODE_BIND_VALS_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS%ROWTYPE
89: INDEX BY BINARY_INTEGER;
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;
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;
107: TYPE NOT_VALID_FLAG_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
108:
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;
107: TYPE NOT_VALID_FLAG_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
108:
109: /* Used to determine classes to load by the client plugin loader */
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;
107: TYPE NOT_VALID_FLAG_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
108:
109: /* Used to determine classes to load by the client plugin loader */
110: PROCEDURE DETERMINE_CLI_PLUGINS
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;
107: TYPE NOT_VALID_FLAG_TAB IS TABLE OF IEU_UWQ_RTNODE_BIND_VALS.NOT_VALID_FLAG%TYPE INDEX BY BINARY_INTEGER;
108:
109: /* Used to determine classes to load by the client plugin loader */
110: PROCEDURE DETERMINE_CLI_PLUGINS
111: (P_RESOURCE_ID IN NUMBER