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_PMV_QUERY_PVT dependencies on BIS_PMV_PMF_PVT

Line 1920: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(1),pSource);

1916: if (upper(l_dimLevelValue_arr(1)) = '''ALL''' OR
1917: l_dimLevelValue_arr(1) = '''''' OR
1918: (l_dimLevel_arr(1) is not null and l_dimLevelValue_arr(1) is null))
1919: then
1920: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(1),pSource);
1921: l_dimLevelValue_arr(1) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(1)
1922: , l_dimension_level_short_name );
1923: end if;
1924:

Line 1921: l_dimLevelValue_arr(1) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(1)

1917: l_dimLevelValue_arr(1) = '''''' OR
1918: (l_dimLevel_arr(1) is not null and l_dimLevelValue_arr(1) is null))
1919: then
1920: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(1),pSource);
1921: l_dimLevelValue_arr(1) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(1)
1922: , l_dimension_level_short_name );
1923: end if;
1924:
1925: --Step 2 , get the dimension level id

Line 2000: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(2),pSource);

1996: if (upper(l_dimLevelValue_arr(2)) = '''ALL''' OR
1997: l_dimLevelValue_arr(2) = '''''' OR
1998: (l_dimLevel_arr(2) is not null and l_dimLevelValue_arr(2) is null))
1999: then
2000: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(2),pSource);
2001: l_dimLevelValue_arr(2) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(2)
2002: , l_dimension_level_short_name );
2003:
2004: end if;

Line 2001: l_dimLevelValue_arr(2) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(2)

1997: l_dimLevelValue_arr(2) = '''''' OR
1998: (l_dimLevel_arr(2) is not null and l_dimLevelValue_arr(2) is null))
1999: then
2000: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(2),pSource);
2001: l_dimLevelValue_arr(2) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(2)
2002: , l_dimension_level_short_name );
2003:
2004: end if;
2005:

Line 2083: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(3),pSource);

2079: if (upper(l_dimLevelValue_arr(3)) = '''ALL''' OR
2080: l_dimLevelValue_arr(3) = '''''' OR
2081: (l_dimLevel_arr(3) is not null and l_dimLevelValue_arr(3) is null))
2082: then
2083: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(3),pSource);
2084: l_dimLevelValue_arr(3) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(3)
2085: , l_dimension_level_short_name );
2086:
2087: end if;

Line 2084: l_dimLevelValue_arr(3) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(3)

2080: l_dimLevelValue_arr(3) = '''''' OR
2081: (l_dimLevel_arr(3) is not null and l_dimLevelValue_arr(3) is null))
2082: then
2083: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(3),pSource);
2084: l_dimLevelValue_arr(3) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(3)
2085: , l_dimension_level_short_name );
2086:
2087: end if;
2088:

Line 2165: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(4),pSource);

2161: if (upper(l_dimLevelValue_arr(4)) = '''ALL''' OR
2162: l_dimLevelValue_arr(4) = '''''' OR
2163: (l_dimLevel_arr(4) is not null and l_dimLevelValue_arr(4) is null))
2164: then
2165: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(4),pSource);
2166: l_dimLevelValue_arr(4) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(4)
2167: , l_dimension_level_short_name );
2168: end if;
2169:

Line 2166: l_dimLevelValue_arr(4) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(4)

2162: l_dimLevelValue_arr(4) = '''''' OR
2163: (l_dimLevel_arr(4) is not null and l_dimLevelValue_arr(4) is null))
2164: then
2165: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(4),pSource);
2166: l_dimLevelValue_arr(4) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(4)
2167: , l_dimension_level_short_name );
2168: end if;
2169:
2170: --Step 2 , get the dimension level id

Line 2246: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(5),pSource);

2242: if (upper(l_dimLevelValue_arr(5)) = '''ALL''' OR
2243: l_dimLevelValue_arr(5) = '''''' OR
2244: (l_dimLevel_arr(5) is not null and l_dimLevelValue_arr(5) is null))
2245: then
2246: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(5),pSource);
2247: l_dimLevelValue_arr(5) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(5)
2248: , l_dimension_level_short_name );
2249:
2250: end if;

Line 2247: l_dimLevelValue_arr(5) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(5)

2243: l_dimLevelValue_arr(5) = '''''' OR
2244: (l_dimLevel_arr(5) is not null and l_dimLevelValue_arr(5) is null))
2245: then
2246: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(5),pSource);
2247: l_dimLevelValue_arr(5) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(5)
2248: , l_dimension_level_short_name );
2249:
2250: end if;
2251:

Line 2328: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(6),pSource);

2324: if (upper(l_dimLevelValue_arr(6)) = '''ALL''' OR
2325: l_dimLevelValue_arr(6) = '''''' OR
2326: (l_dimLevel_arr(6) is not null and l_dimLevelValue_arr(6) is null))
2327: then
2328: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(6),pSource);
2329: l_dimLevelValue_arr(6) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(6)
2330: , l_dimension_level_short_name );
2331:
2332: end if;

Line 2329: l_dimLevelValue_arr(6) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(6)

2325: l_dimLevelValue_arr(6) = '''''' OR
2326: (l_dimLevel_arr(6) is not null and l_dimLevelValue_arr(6) is null))
2327: then
2328: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(6),pSource);
2329: l_dimLevelValue_arr(6) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(6)
2330: , l_dimension_level_short_name );
2331:
2332: end if;
2333:

Line 2410: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(7),pSource);

2406: if (upper(l_dimLevelValue_arr(7)) = '''ALL''' OR
2407: l_dimLevelValue_arr(7) = '''''' OR
2408: (l_dimLevel_arr(7) is not null and l_dimLevelValue_arr(7) is null))
2409: then
2410: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(7),pSource);
2411: l_dimLevelValue_arr(7) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(7)
2412: , l_dimension_level_short_name );
2413:
2414: end if;

Line 2411: l_dimLevelValue_arr(7) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(7)

2407: l_dimLevelValue_arr(7) = '''''' OR
2408: (l_dimLevel_arr(7) is not null and l_dimLevelValue_arr(7) is null))
2409: then
2410: l_dimension_level_short_name := BIS_PMV_PMF_PVT.getTotalDimLevelName(l_dim_arr(7),pSource);
2411: l_dimLevelValue_arr(7) := BIS_PMV_PMF_PVT.getTotalDimValue(pSource,l_dim_arr(7)
2412: , l_dimension_level_short_name );
2413:
2414: end if;
2415:

Line 2789: l_target_select := l_target_select || 'BIS_PMV_PMF_PVT.get_target_new(';

2785: -- so numbering is not in the same order, but this does not matter for binding
2786: -- also the case if there was an excpetion in some place in order_dimensions.
2787:
2788: if not(l_no_target) then
2789: l_target_select := l_target_select || 'BIS_PMV_PMF_PVT.get_target_new(';
2790:
2791: -- bind the first few variables
2792: x_bind_variables := x_bind_variables || SEPERATOR||p_report_type;
2793: x_bind_count := x_bind_count +1;