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

Line 16: , x_dim_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map

12: procedure init_dim_map
13: ( p_dimension in varchar2
14: , p_filter_flag in varchar2
15: , x_dimension_tbl in out nocopy t_dimension_tbl
16: , x_dim_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
17: )
18: is
19:
20: l_dimension_rec t_dimension_rec;

Line 21: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

17: )
18: is
19:
20: l_dimension_rec t_dimension_rec;
21: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
22:
23: begin
24:
25: if p_dimension = G_CATEGORY then

Line 485: return poa_dbi_util_pkg.poa_dbi_join_tbl

481: function get_join_info
482: ( p_view_by in varchar2
483: , p_dimension_tbl in out nocopy t_dimension_tbl
484: )
485: return poa_dbi_util_pkg.poa_dbi_join_tbl
486: is
487: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
488: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
489: l_dimension_rec t_dimension_rec;

Line 487: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

483: , p_dimension_tbl in out nocopy t_dimension_tbl
484: )
485: return poa_dbi_util_pkg.poa_dbi_join_tbl
486: is
487: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
488: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
489: l_dimension_rec t_dimension_rec;
490: l_key varchar2(200);
491: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

Line 488: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

484: )
485: return poa_dbi_util_pkg.poa_dbi_join_tbl
486: is
487: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
488: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
489: l_dimension_rec t_dimension_rec;
490: l_key varchar2(200);
491: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
492: --

Line 491: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

487: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
488: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
489: l_dimension_rec t_dimension_rec;
490: l_key varchar2(200);
491: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
492: --
493: begin
494: -- reinitialize the join table
495: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

Line 495: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

491: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
492: --
493: begin
494: -- reinitialize the join table
495: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
496:
497: if p_view_by is not null then
498: if p_dimension_tbl.exists(p_view_by) then
499: l_dimension_rec := p_dimension_tbl(p_view_by);

Line 717: , x_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map

713: -- this is a public procedure, see package specification for it's
714: -- description
715: procedure register_dimension_levels
716: ( x_dimension_tbl in out nocopy t_dimension_tbl
717: , x_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
718: , p_dimension1 in varchar2
719: , p_filter_flag1 in varchar2
720: , p_dimension2 in varchar2 default null
721: , p_filter_flag2 in varchar2 default null

Line 831: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map

827: -- description
828: procedure process_parameters
829: ( p_param in bis_pmv_page_parameter_tbl
830: , p_dimension_tbl in out nocopy t_dimension_tbl
831: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
832: , p_trend in varchar2
833: , p_custom_output in out nocopy bis_query_attributes_tbl
834: , x_cur_suffix out nocopy varchar2
835: , x_where_clause out nocopy varchar2

Line 837: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl

833: , p_custom_output in out nocopy bis_query_attributes_tbl
834: , x_cur_suffix out nocopy varchar2
835: , x_where_clause out nocopy varchar2
836: , x_viewby_select out nocopy varchar2
837: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
838: , x_dim_bmap out nocopy number
839: , x_comparison_type out nocopy varchar2
840: , x_xtd out nocopy varchar2
841: , x_uom_suffix out nocopy varchar2

Line 871: poa_dbi_util_pkg.get_parameter_values

867: end if;
868:
869: l_dim_bmap := 0;
870:
871: poa_dbi_util_pkg.get_parameter_values
872: ( p_param => p_param -- in, passed in
873: , p_dim_map => p_dim_filter_map -- in, passed in, extended by register_dimension_levels
874: , p_view_by => l_view_by -- out, used locally
875: , p_cur_suffix => x_cur_suffix -- out, returned to caller

Line 905: l_where_clause := poa_dbi_util_pkg.get_where_clauses

901: ) is null then
902: p_dimension_tbl(G_CATEGORY).oset_col_name1 := 'vbh_parent_category_id';
903: end if;
904:
905: l_where_clause := poa_dbi_util_pkg.get_where_clauses
906: ( p_dim_filter_map
907: , case
908: when p_trend = 'Y' then 'Y'
909: else 'N'

Line 1024: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map

1020: -- as there are many reports already that do not use this parameter.
1021: procedure process_parameters
1022: ( p_param in bis_pmv_page_parameter_tbl
1023: , p_dimension_tbl in out nocopy t_dimension_tbl
1024: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
1025: , p_trend in varchar2
1026: , p_custom_output in out nocopy bis_query_attributes_tbl
1027: , x_cur_suffix out nocopy varchar2
1028: , x_where_clause out nocopy varchar2

Line 1030: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl

1026: , p_custom_output in out nocopy bis_query_attributes_tbl
1027: , x_cur_suffix out nocopy varchar2
1028: , x_where_clause out nocopy varchar2
1029: , x_viewby_select out nocopy varchar2
1030: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
1031: , x_dim_bmap out nocopy number
1032: , x_comparison_type out nocopy varchar2
1033: , x_xtd out nocopy varchar2
1034: ) is

Line 1179: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1175: l_dimension_tbl t_dimension_tbl;
1176: l_select_list varchar2(4000);
1177: l_fact_select_list varchar2(4000);
1178: l_key varchar2(200);
1179: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1180: l_col_name varchar2(200);
1181: begin
1182: -- build fact select list
1183: l_key := p_detail_col_tbl.first;

Line 1255: return poa_dbi_util_pkg.change_clause(p_current_column,p_prior_column) ||

1251: ) return varchar2
1252: is
1253: begin
1254: if nvl(p_percent,'Y') = 'Y' then
1255: return poa_dbi_util_pkg.change_clause(p_current_column,p_prior_column) ||
1256: ' ' || p_column_alias;
1257: end if;
1258: return poa_dbi_util_pkg.change_clause(p_current_column,p_prior_column,'X') ||
1259: ' ' || p_column_alias;

Line 1258: return poa_dbi_util_pkg.change_clause(p_current_column,p_prior_column,'X') ||

1254: if nvl(p_percent,'Y') = 'Y' then
1255: return poa_dbi_util_pkg.change_clause(p_current_column,p_prior_column) ||
1256: ' ' || p_column_alias;
1257: end if;
1258: return poa_dbi_util_pkg.change_clause(p_current_column,p_prior_column,'X') ||
1259: ' ' || p_column_alias;
1260: end change_column;
1261:
1262: -- this is a public function, see the package specification for it's

Line 1272: return poa_dbi_util_pkg.rate_clause( p_numerator

1268: , p_percent in varchar2 default null -- treated as 'Y'
1269: ) return varchar2
1270: is
1271: begin
1272: return poa_dbi_util_pkg.rate_clause( p_numerator
1273: , p_denominator
1274: , case nvl(p_percent,'Y')
1275: when 'Y' then 'P'
1276: else 'NP'

Line 1310: , p_join_tbl in out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl

1306: -- description
1307: function add_view_by
1308: ( p_view_by in varchar2
1309: , p_dimension_tbl in t_dimension_tbl
1310: , p_join_tbl in out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
1311: )
1312: return varchar2
1313: is
1314:

Line 1315: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

1311: )
1312: return varchar2
1313: is
1314:
1315: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
1316: l_dimension_rec t_dimension_rec;
1317: l_return varchar2(200);
1318:
1319: begin

Line 1356: , p_dim_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map

1352: -- this is a public procedure, see the package specification for it's
1353: -- description
1354: procedure check_district_filter
1355: ( p_param in bis_pmv_page_parameter_tbl
1356: , p_dim_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
1357: )
1358: is
1359: begin
1360: null;

Line 1366: ( p_join_tables in poa_dbi_util_pkg.poa_dbi_join_tbl

1362:
1363: -- this is a public function, see the package specification for it's
1364: -- description
1365: function get_inner_select_col
1366: ( p_join_tables in poa_dbi_util_pkg.poa_dbi_join_tbl
1367: ) return varchar2
1368: is
1369:
1370: l_select_list varchar2(500);