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.BIX_PMV_DBI_UTL_PKG dependencies on POA_DBI_UTIL_PKG

Line 45: , p_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl

41: , p_version IN VARCHAR2
42: , p_mv_set IN VARCHAR2 /*-- ITM/OTM/ECM --*/
43: , p_where_clause OUT NOCOPY VARCHAR2
44: , p_mv OUT NOCOPY VARCHAR2
45: , p_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
46: , p_comp_type OUT NOCOPY VARCHAR2
47: , p_xtd OUT NOCOPY VARCHAR2
48: , p_view_by_select OUT NOCOPY VARCHAR2
49: , p_view_by OUT NOCOPY VARCHAR2

Line 62: , p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl

58:
59: FUNCTION status_sql_daylevel (
60: p_fact_name IN VARCHAR2
61: , p_row_type_where_clause IN VARCHAR2
62: , p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl
63: , p_join_tables IN poa_dbi_util_pkg.poa_dbi_join_tbl
64: , p_time_type IN VARCHAR2 default 'ESD'
65: , p_union IN VARCHAR2 default 'ALL'
66: )

Line 63: , p_join_tables IN poa_dbi_util_pkg.poa_dbi_join_tbl

59: FUNCTION status_sql_daylevel (
60: p_fact_name IN VARCHAR2
61: , p_row_type_where_clause IN VARCHAR2
62: , p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl
63: , p_join_tables IN poa_dbi_util_pkg.poa_dbi_join_tbl
64: , p_time_type IN VARCHAR2 default 'ESD'
65: , p_union IN VARCHAR2 default 'ALL'
66: )
67: RETURN VARCHAR2;

Line 110: , p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl

106: p_xtd IN VARCHAR2
107: , p_comparison_type IN VARCHAR2
108: , p_fact_name IN VARCHAR2
109: , p_where_clause IN VARCHAR2
110: , p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl
111: , p_use_grpid IN VARCHAR2 := 'Y'
112: , p_in_join_tables IN poa_dbi_util_pkg.poa_dbi_join_tbl
113: , p_fact_hint IN VARCHAR2 := null
114: , p_union_clause IN VARCHAR2 DEFAULT NULL)

Line 112: , p_in_join_tables IN poa_dbi_util_pkg.poa_dbi_join_tbl

108: , p_fact_name IN VARCHAR2
109: , p_where_clause IN VARCHAR2
110: , p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl
111: , p_use_grpid IN VARCHAR2 := 'Y'
112: , p_in_join_tables IN poa_dbi_util_pkg.poa_dbi_join_tbl
113: , p_fact_hint IN VARCHAR2 := null
114: , p_union_clause IN VARCHAR2 DEFAULT NULL)
115: RETURN VARCHAR2;
116:

Line 118: p_bix_col_tab IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_col_tbl,

114: , p_union_clause IN VARCHAR2 DEFAULT NULL)
115: RETURN VARCHAR2;
116:
117: FUNCTION GET_CONTINUED_MEASURES(
118: p_bix_col_tab IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_col_tbl,
119: p_where_clause IN OUT NOCOPY VARCHAR2,
120: p_xtd IN VARCHAR2,
121: p_comparison_type IN VARCHAR2,
122: p_mv_set IN VARCHAR2