APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_PMF_QUERY_ATTRIBUTES

Line 133: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE-- (attribute_value, attribute_data_type)

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
136: ,x_id_name OUT NOCOPY VARCHAR2
137: ,x_value_name OUT NOCOPY VARCHAR2

Line 151: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE

147: p_bis_source IN VARCHAR2
148: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
149: ,p_is_relation_recursive IN VARCHAR2
150: ,x_select_string OUT NOCOPY VARCHAR2
151: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE
152: ,x_data_source OUT NOCOPY VARCHAR2
153: ,x_id_name OUT NOCOPY VARCHAR2
154: ,x_value_name OUT NOCOPY VARCHAR2
155: ,x_parent_name OUT NOCOPY VARCHAR2

Line 1217: l_bind_params BIS_PMF_QUERY_ATTRIBUTES_TABLE;

1213: IS
1214: l_dimlevelrec BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_rec_Type;
1215: l_parlevelrec BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_rec_Type;
1216: l_dimleveltbl BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_tbl_Type;
1217: l_bind_params BIS_PMF_QUERY_ATTRIBUTES_TABLE;
1218: l_count NUMBER;
1219: -- l_parent_name VARCHAR2(300);
1220: -- l_time_level VARCHAR2(300);
1221: l_param_list VARCHAR2(32000);

Line 1310: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE

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
1311: ,x_id_name OUT NOCOPY VARCHAR2
1312: ,x_value_name OUT NOCOPY VARCHAR2
1313: ,x_parent_name OUT NOCOPY VARCHAR2
1314: ,x_time_level OUT NOCOPY VARCHAR2

Line 1420: RETURN BIS_PMF_QUERY_ATTRIBUTES

1416: END get_dimlevel_select_string;
1417:
1418: --==================================================================
1419: FUNCTION INITIALIZE_QUERY_TYPE
1420: RETURN BIS_PMF_QUERY_ATTRIBUTES
1421: IS
1422: l_query_attributes BIS_PMF_QUERY_ATTRIBUTES := BIS_PMF_QUERY_ATTRIBUTES(null,null,null);
1423: BEGIN
1424: RETURN l_query_attributes;

Line 1422: l_query_attributes BIS_PMF_QUERY_ATTRIBUTES := BIS_PMF_QUERY_ATTRIBUTES(null,null,null);

1418: --==================================================================
1419: FUNCTION INITIALIZE_QUERY_TYPE
1420: RETURN BIS_PMF_QUERY_ATTRIBUTES
1421: IS
1422: l_query_attributes BIS_PMF_QUERY_ATTRIBUTES := BIS_PMF_QUERY_ATTRIBUTES(null,null,null);
1423: BEGIN
1424: RETURN l_query_attributes;
1425: END INITIALIZE_QUERY_TYPE;
1426:

Line 1438: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE-- (attribute_value, attribute_data_type)

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
1441: ,x_id_name OUT NOCOPY VARCHAR2
1442: ,x_value_name OUT NOCOPY VARCHAR2

Line 1523: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE

1519: p_bis_source IN VARCHAR2
1520: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1521: ,p_is_relation_recursive IN VARCHAR2
1522: ,x_select_string OUT NOCOPY VARCHAR2
1523: ,x_bind_params OUT NOCOPY BIS_PMF_QUERY_ATTRIBUTES_TABLE
1524: ,x_data_source OUT NOCOPY VARCHAR2
1525: ,x_id_name OUT NOCOPY VARCHAR2
1526: ,x_value_name OUT NOCOPY VARCHAR2
1527: ,x_parent_name OUT NOCOPY VARCHAR2