eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_PMF_GET_DIMLEVELS_PUB

Line 130: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

126: PROCEDURE get_select_string (
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

Line 148: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

144: );
145: --================================================================
146: PROCEDURE get_pmf_data_source(
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

Line 164: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

160: );
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

Line 178: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type

174: );
175: --================================================================
176:
177: PROCEDURE get_relationship_details (
178: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
179: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type
180: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
181: ,x_is_relationship_found OUT NOCOPY VARCHAR2
182: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec

Line 179: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type

175: --================================================================
176:
177: PROCEDURE get_relationship_details (
178: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
179: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type
180: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
181: ,x_is_relationship_found OUT NOCOPY VARCHAR2
182: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec
183: ,x_return_status OUT NOCOPY VARCHAR2

Line 182: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec

178: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
179: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type
180: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
181: ,x_is_relationship_found OUT NOCOPY VARCHAR2
182: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_count OUT NOCOPY NUMBER
185: ,x_msg_data OUT NOCOPY VARCHAR2
186: );

Line 190: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type

186: );
187: --================================================================
188:
189: PROCEDURE get_bsc_relationship_data (
190: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
191: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
192: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type
193: ,x_is_relationship_found OUT NOCOPY VARCHAR2
194: ,x_is_relation_recursive OUT NOCOPY VARCHAR2

Line 191: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type

187: --================================================================
188:
189: PROCEDURE get_bsc_relationship_data (
190: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
191: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
192: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type
193: ,x_is_relationship_found OUT NOCOPY VARCHAR2
194: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
195: ,x_return_status OUT NOCOPY VARCHAR2

Line 241: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

237: ,p_time_level IN VARCHAR2
238: ) ;
239:
240: FUNCTION is_append_where_clause(
241: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
242: ,p_is_relation_recursive IN VARCHAR2
243: ) RETURN BOOLEAN;
244:
245: --==================================================================

Line 248: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

244:
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

Line 1214: l_dimlevelrec BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_rec_Type;

1210: ,x_msg_count OUT NOCOPY NUMBER
1211: ,x_msg_data OUT NOCOPY VARCHAR2
1212: )
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;

Line 1215: l_parlevelrec BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_rec_Type;

1211: ,x_msg_data OUT NOCOPY VARCHAR2
1212: )
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);

Line 1216: l_dimleveltbl BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_tbl_Type;

1212: )
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);

Line 1303: p_dimlevel_rec IN BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_rec_Type

1299:
1300: --================================================================
1301:
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

Line 1304: ,p_param_lists_tbl IN BIS_PMF_GET_DIMLEVELS_PUB.dimlvl_tbl_Type

1300: --================================================================
1301:
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

Line 1324: l_dim_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;

1320: IS
1321: l_bis_source bis_levels.source%TYPE;
1322: l_is_relationship_found VARCHAR2(10);
1323: l_dim_level_short_name VARCHAR2(80);
1324: l_dim_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1325: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
1326: l_dim_un_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1327: BEGIN
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1326: l_dim_un_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;

1322: l_is_relationship_found VARCHAR2(10);
1323: l_dim_level_short_name VARCHAR2(80);
1324: l_dim_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1325: l_is_pmf_bsc_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
1326: l_dim_un_rel_info_rec bis_pmf_get_dimlevels_pub.dim_rel_info_rec;
1327: BEGIN
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329: l_bis_source := p_bis_source;
1330: IF (l_bis_source IS NULL) THEN

Line 1435: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

1431: PROCEDURE get_select_string (
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

Line 1520: ,p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

1516:
1517: --================================================================
1518: PROCEDURE get_pmf_data_source(
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

Line 1604: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

1600: END get_pmf_data_source;
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

Line 1700: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type

1696: */
1697: --===================================================================
1698:
1699: PROCEDURE get_relationship_details (
1700: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1701: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type
1702: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
1703: ,x_is_relationship_found OUT NOCOPY VARCHAR2
1704: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec

Line 1701: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type

1697: --===================================================================
1698:
1699: PROCEDURE get_relationship_details (
1700: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1701: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type
1702: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
1703: ,x_is_relationship_found OUT NOCOPY VARCHAR2
1704: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1705: ,x_return_status OUT NOCOPY VARCHAR2

Line 1704: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec

1700: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1701: ,p_parent_dimlvl_tbl IN bis_pmf_get_dimlevels_pub.dimlvl_tbl_type
1702: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
1703: ,x_is_relationship_found OUT NOCOPY VARCHAR2
1704: ,x_dim_rel_info_rec OUT NOCOPY bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1705: ,x_return_status OUT NOCOPY VARCHAR2
1706: ,x_msg_count OUT NOCOPY NUMBER
1707: ,x_msg_data OUT NOCOPY VARCHAR2
1708: )

Line 1711: l_parent_dimlvl_tbl bis_pmf_get_dimlevels_pub.dimlvl_tbl_type;

1707: ,x_msg_data OUT NOCOPY VARCHAR2
1708: )
1709: IS
1710: l_bsc_dim_rel_info_rec bsc_dimension_levels_pub.bsc_dim_level_rec_type;
1711: l_parent_dimlvl_tbl bis_pmf_get_dimlevels_pub.dimlvl_tbl_type;
1712: l_count NUMBER;
1713: err_msg VARCHAR2(3000);
1714: BEGIN
1715: l_parent_dimlvl_tbl := p_parent_dimlvl_tbl;

Line 1760: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type

1756:
1757: --=====================================================
1758:
1759: PROCEDURE get_bsc_relationship_data (
1760: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1761: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1762: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type
1763: ,x_is_relationship_found OUT NOCOPY VARCHAR2
1764: ,x_is_relation_recursive OUT NOCOPY VARCHAR2

Line 1761: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type

1757: --=====================================================
1758:
1759: PROCEDURE get_bsc_relationship_data (
1760: p_child_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1761: ,p_parent_dimlvl_rec IN bis_pmf_get_dimlevels_pub.dimlvl_rec_type
1762: ,x_bsc_dim_rel_info_rec OUT NOCOPY bsc_dimension_levels_pub.bsc_dim_level_rec_type
1763: ,x_is_relationship_found OUT NOCOPY VARCHAR2
1764: ,x_is_relation_recursive OUT NOCOPY VARCHAR2
1765: ,x_return_status OUT NOCOPY VARCHAR2

Line 1808: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

1804: * for parent-child relationship.
1805: * bsc_sys_dim_level_rels does not have WHO columns.
1806: */
1807: FUNCTION is_append_where_clause(
1808: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec
1809: ,p_is_relation_recursive IN VARCHAR2
1810: ) RETURN BOOLEAN
1811: IS
1812: l_created_by NUMBER;

Line 2063: p_dim_rel_info_rec IN bis_pmf_get_dimlevels_pub.dim_rel_info_rec

2059:
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