DBA Data[Home] [Help]

APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_PMF_QUERY_ATTRIBUTES

Line 50: TYPE BIS_PMF_QUERY_ATTRIBUTES_TABLE IS TABLE OF BIS_PMF_QUERY_ATTRIBUTES;

46: ,Select_String VARCHAR2(32000)
47: ,Time_level VARCHAR2(2000)
48: );
49:
50: TYPE BIS_PMF_QUERY_ATTRIBUTES_TABLE IS TABLE OF BIS_PMF_QUERY_ATTRIBUTES;
51:
52: PROCEDURE GET_DIMLEVEL_SELECT_STRING
53: (p_DimLevelName IN VARCHAR2
54: ,p_add_distinct IN VARCHAR2 := 'F'

Line 127: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE

123: ,p_region_code IN ak_regions.region_code%TYPE
124: ,x_select_string OUT NOCOPY VARCHAR2
125: ,x_table_name OUT NOCOPY VARCHAR2
126: ,x_where_clause OUT NOCOPY VARCHAR2
127: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE
128: ,x_id_name OUT NOCOPY VARCHAR2
129: ,x_value_name OUT NOCOPY VARCHAR2
130: ,x_parent_name OUT NOCOPY VARCHAR2
131: ,x_time_level OUT NOCOPY VARCHAR2