APPS.QPR_LOAD_DIM_DATA dependencies on QPR_DIM_SOURCES

Line 36: from qpr_dim_sources

32:
33: cursor get_all_dim_hier (l_dim_src_instance_id number, l_inst_type varchar2)
34: is
35: select distinct dim_code dim, hier_code hier
36: from qpr_dim_sources
37: where instance_id = l_dim_src_instance_id
38: and instance_type = l_inst_type;
39:
40: cursor get_all_hier (p_dim_code varchar2, l_dim_src_instance_id number, l_inst_type varchar2)

Line 43: from qpr_dim_sources

39:
40: cursor get_all_hier (p_dim_code varchar2, l_dim_src_instance_id number, l_inst_type varchar2)
41: is
42: select distinct hier_code hier
43: from qpr_dim_sources
44: where instance_id = l_dim_src_instance_id
45: and dim_code = p_dim_code
46: and instance_type = l_inst_type;
47:

Line 76: from qpr_dim_sources

72: from qpr_instances
73: where instance_id = p_instance_id;
74:
75: select count(*) into l_check_instance
76: from qpr_dim_sources
77: where instance_id = p_instance_id;
78:
79: if (l_check_instance = 0)
80: then

Line 181: from qpr_dim_sources

177: while l_count <= 8
178: loop
179:
180: select count(nvl(user_value_column, value_column)) into l_level_defined
181: from qpr_dim_sources
182: where instance_id = l_dim_src_instance_id
183: and instance_type = l_inst_type
184: and dim_code = p_dim_code
185: and hier_code = p_hier_code

Line 192: from qpr_dim_sources

188: if (l_level_defined <> 0)
189: then
190:
191: select count(nvl(user_attr_column, attr_column)) into l_attr_defined
192: from qpr_dim_sources
193: where instance_id = l_dim_src_instance_id
194: and instance_type = l_inst_type
195: and dim_code = p_dim_code
196: and hier_code = p_hier_code

Line 212: from qpr_dim_sources

208: into
209: l_value_column,
210: l_desc_column,
211: l_attr_column
212: from qpr_dim_sources
213: where instance_id = l_dim_src_instance_id
214: and instance_type = l_inst_type
215: and dim_code = p_dim_code
216: and hier_code = p_hier_code

Line 260: from qpr_dim_sources

256: nvl(user_desc_column, desc_column)
257: into
258: l_value_column,
259: l_desc_column
260: from qpr_dim_sources
261: where instance_id = l_dim_src_instance_id
262: and instance_type = l_inst_type
263: and dim_code = p_dim_code
264: and hier_code = p_hier_code

Line 320: from qpr_dim_sources

316: select
317: nvl(user_value_column, value_column)
318: into
319: l_value_column
320: from qpr_dim_sources
321: where instance_id = l_dim_src_instance_id
322: and instance_type = l_inst_type
323: and dim_code = p_dim_code
324: and hier_code = p_hier_code

Line 337: from qpr_dim_sources

333: end if;
334:
335: select distinct nvl(user_view_name, view_name)
336: into l_source_view_name
337: from qpr_dim_sources
338: where instance_id = l_dim_src_instance_id
339: and instance_type = l_inst_type
340: and dim_code = p_dim_code
341: and hier_code = p_hier_code;

Line 355: from qpr_dim_sources

351: if (date_from is not null) or (date_to is not null) then
352: l_date_column:=null;
353: select nvl(user_value_column, value_column)
354: into l_date_column
355: from qpr_dim_sources
356: where instance_id = l_dim_src_instance_id
357: and instance_type = l_inst_type
358: and dim_code = p_dim_code
359: and hier_code = p_hier_code