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 304: from qpr_dim_sources

300: while l_count <= 8
301: loop
302:
303: select count(nvl(user_value_column, value_column)) into l_level_defined
304: from qpr_dim_sources
305: where instance_id = l_dim_src_instance_id
306: and instance_type = l_inst_type
307: and dim_code = p_dim_code
308: and hier_code = p_hier_code

Line 315: from qpr_dim_sources

311: if (l_level_defined <> 0)
312: then
313:
314: select count(nvl(user_attr_column, attr_column)) into l_attr_defined
315: from qpr_dim_sources
316: where instance_id = l_dim_src_instance_id
317: and instance_type = l_inst_type
318: and dim_code = p_dim_code
319: and hier_code = p_hier_code

Line 335: from qpr_dim_sources

331: into
332: l_value_column,
333: l_desc_column,
334: l_attr_column
335: from qpr_dim_sources
336: where instance_id = l_dim_src_instance_id
337: and instance_type = l_inst_type
338: and dim_code = p_dim_code
339: and hier_code = p_hier_code

Line 383: from qpr_dim_sources

379: nvl(user_desc_column, desc_column)
380: into
381: l_value_column,
382: l_desc_column
383: from qpr_dim_sources
384: where instance_id = l_dim_src_instance_id
385: and instance_type = l_inst_type
386: and dim_code = p_dim_code
387: and hier_code = p_hier_code

Line 443: from qpr_dim_sources

439: select
440: nvl(user_value_column, value_column)
441: into
442: l_value_column
443: from qpr_dim_sources
444: where instance_id = l_dim_src_instance_id
445: and instance_type = l_inst_type
446: and dim_code = p_dim_code
447: and hier_code = p_hier_code

Line 460: from qpr_dim_sources

456: end if;
457:
458: select distinct nvl(user_view_name, view_name)
459: into l_source_view_name
460: from qpr_dim_sources
461: where instance_id = l_dim_src_instance_id
462: and instance_type = l_inst_type
463: and dim_code = p_dim_code
464: and hier_code = p_hier_code;

Line 478: from qpr_dim_sources

474: if (date_from is not null) or (date_to is not null) then
475: l_date_column:=null;
476: select nvl(user_value_column, value_column)
477: into l_date_column
478: from qpr_dim_sources
479: where instance_id = l_dim_src_instance_id
480: and instance_type = l_inst_type
481: and dim_code = p_dim_code
482: and hier_code = p_hier_code