DBA Data[Home] [Help]

APPS.FEM_BI_DIMENSION_UTILS_PKG dependencies on FEM_BI_ATTR_DIMENSIONS_V

Line 149: from fem_bi_attr_dimensions_v

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

Line 161: type bi_attr_dims_table is table of fem_bi_attr_dimensions_v%rowtype;

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 --

Line 236: from fem_bi_attr_dimensions_v

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;

Line 844: from fem_bi_attr_dimensions_v

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

Line 851: type bi_attr_dims_table is table of fem_bi_attr_dimensions_v%rowtype;

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

Line 895: from fem_bi_attr_dimensions_v

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;