145: -- Declare cursors --
146: ---------------------
147: cursor l_bi_attr_dims_csr is
148: select *
149: from fem_bi_attr_dimensions_v
150: where dimension_varchar_label <> 'ALL'
151: order by dimension_varchar_label;
152:
153: cursor l_child_requests_csr (p_parent_request_id number) is
157:
158: -------------------
159: -- Declare Types --
160: -------------------
161: type bi_attr_dims_table is table of fem_bi_attr_dimensions_v%rowtype;
162: type child_requests_table is table of fnd_concurrent_requests%rowtype;
163:
164: -----------------------
165: -- Declare variables --
232: -- Validate input parameter --
233: ------------------------------
234: begin
235: select 1 into l_dummy_number
236: from fem_bi_attr_dimensions_v
237: where dimension_varchar_label = p_dimension_varchar_label;
238: exception
239: when no_data_found then
240: raise l_attr_trans_invalid_dim_err;
840: -- Declare cursors --
841: ---------------------
842: cursor l_bi_attr_dims_csr is
843: select *
844: from fem_bi_attr_dimensions_v
845: where dimension_varchar_label <> 'ALL'
846: order by dimension_varchar_label;
847:
848: -------------------
847:
848: -------------------
849: -- Declare Types --
850: -------------------
851: type bi_attr_dims_table is table of fem_bi_attr_dimensions_v%rowtype;
852:
853: -----------------------
854: -- Declare variables --
855: -----------------------
891: -- Validate input parameter --
892: ------------------------------
893: begin
894: select 1 into l_dummy_number
895: from fem_bi_attr_dimensions_v
896: where dimension_varchar_label = p_dimension_varchar_label;
897: exception
898: when no_data_found then
899: raise l_attr_trans_invalid_dim_err;