APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on AK_REGIONS

Line 131: ,p_region_code IN ak_regions.region_code%TYPE

127: p_bis_source IN VARCHAR2
128: ,p_is_relation_recursive IN VARCHAR2
129: ,p_is_relationship_found IN VARCHAR2
130: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
131: ,p_region_code IN ak_regions.region_code%TYPE
132: ,x_select_string OUT NOCOPY VARCHAR2
133: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE-- (attribute_value, attribute_data_type)
134: ,x_where_clause OUT NOCOPY VARCHAR2
135: ,x_data_source OUT NOCOPY VARCHAR2

Line 165: ,p_region_code IN ak_regions.region_code%TYPE

161:
162: --================================================================
163: PROCEDURE get_bsc_data_source(
164: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
165: ,p_region_code IN ak_regions.region_code%TYPE
166: ,x_id_name OUT NOCOPY VARCHAR2
167: ,x_value_name OUT NOCOPY VARCHAR2
168: ,x_parent_name OUT NOCOPY VARCHAR2
169: ,x_select_string OUT NOCOPY VARCHAR2

Line 249: ,p_region_code IN ak_regions.region_code%TYPE

245: --==================================================================
246: PROCEDURE Get_Bsc_Dim_Obj_details
247: (
248: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
249: ,p_region_code IN ak_regions.region_code%TYPE
250: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
251: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
252: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
253: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE

Line 1199: ,p_region_code IN ak_regions.region_code%TYPE

1195: PROCEDURE get_dimlevel_select_wrap (
1196: p_dimLevel IN VARCHAR2
1197: ,p_paramlist IN VARCHAR2
1198: ,p_bis_source IN VARCHAR2
1199: ,p_region_code IN ak_regions.region_code%TYPE
1200: ,x_select_string OUT NOCOPY VARCHAR2
1201: ,x_table_name OUT NOCOPY VARCHAR2
1202: ,x_where_clause OUT NOCOPY VARCHAR2
1203: ,x_bind_param_string OUT NOCOPY VARCHAR2

Line 1306: ,p_region_code IN ak_regions.region_code%TYPE

1302: PROCEDURE get_dimlevel_select_string(
1303: p_dimlevel_rec IN BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_rec_Type
1304: ,p_param_lists_tbl IN BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_tbl_Type
1305: ,p_bis_source IN bis_levels.source%TYPE := NULL
1306: ,p_region_code IN ak_regions.region_code%TYPE
1307: ,x_select_string OUT NOCOPY VARCHAR2
1308: ,x_table_name OUT NOCOPY VARCHAR2
1309: ,x_where_clause OUT NOCOPY VARCHAR2
1310: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE

Line 1436: ,p_region_code IN ak_regions.region_code%TYPE

1432: p_bis_source IN VARCHAR2
1433: ,p_is_relation_recursive IN VARCHAR2
1434: ,p_is_relationship_found IN VARCHAR2
1435: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1436: ,p_region_code IN ak_regions.region_code%TYPE
1437: ,x_select_string OUT NOCOPY VARCHAR2
1438: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE-- (attribute_value, attribute_data_type)
1439: ,x_where_clause OUT NOCOPY VARCHAR2
1440: ,x_data_source OUT NOCOPY VARCHAR2

Line 1605: ,p_region_code IN ak_regions.region_code%TYPE

1601:
1602: --================================================================
1603: PROCEDURE get_bsc_data_source(
1604: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1605: ,p_region_code IN ak_regions.region_code%TYPE
1606: ,x_id_name OUT NOCOPY VARCHAR2
1607: ,x_value_name OUT NOCOPY VARCHAR2
1608: ,x_parent_name OUT NOCOPY VARCHAR2
1609: ,x_select_string OUT NOCOPY VARCHAR2

Line 2064: ,p_region_code IN ak_regions.region_code%TYPE

2060:
2061: PROCEDURE Get_Bsc_Dim_Obj_details
2062: (
2063: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
2064: ,p_region_code IN ak_regions.region_code%TYPE
2065: ,x_child_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2066: ,x_child_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE
2067: ,x_parent_level_pk_col OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE
2068: ,x_parent_level_view_name OUT NOCOPY BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE

Line 2107: l_region_code ak_regions.region_code%TYPE;

2103: l_parent_level_pk_col BSC_SYS_DIM_LEVELS_B.LEVEL_PK_COL%TYPE;
2104: l_parent_level_view_name BSC_SYS_DIM_LEVELS_B.LEVEL_VIEW_NAME%TYPE;
2105: l_restrict_all_value VARCHAR2(100);
2106:
2107: l_region_code ak_regions.region_code%TYPE;
2108: l_indicator bsc_kpis_b.indicator%TYPE;
2109: l_count NUMBER :=0;
2110:
2111: BEGIN