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.BIM_SGMT_INTL_UI_PVT dependencies on BIM_PMV_DBI_UTL_PKG

Line 9: Label1 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_C');

5: FUNCTION GLb( p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL , num in number)
6: RETURN VARCHAR2 IS
7:
8: l_val VARCHAR2(50);
9: Label1 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_C');
10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');
11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');

Line 10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');

6: RETURN VARCHAR2 IS
7:
8: l_val VARCHAR2(50);
9: Label1 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_C');
10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');
11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');

Line 11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');

7:
8: l_val VARCHAR2(50);
9: Label1 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_C');
10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');
11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');

Line 12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');

8: l_val VARCHAR2(50);
9: Label1 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_C');
10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');
11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');

Line 13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');

9: Label1 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_C');
10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');
11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');
17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');

Line 14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');

10: Label2 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_C');
11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');
17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');
18: Label10 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_G');

Line 15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');

11: Label3 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_C');
12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');
17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');
18: Label10 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_G');
19: BEGIN

Line 16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');

12: Label4 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_C');
13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');
17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');
18: Label10 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_G');
19: BEGIN
20:

Line 17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');

13: Label5 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_C');
14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');
17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');
18: Label10 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_G');
19: BEGIN
20:
21: IF (p_page_parameter_tbl.count > 0) THEN

Line 18: Label10 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_G');

14: Label6 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('BOOK_G');
15: Label7 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('OPPT_G');
16: Label8 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('LEAD_G');
17: Label9 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('RESP_G');
18: Label10 CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_LOOKUP_VALUE('ACT_G');
19: BEGIN
20:
21: IF (p_page_parameter_tbl.count > 0) THEN
22:

Line 159: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

155:
156: BEGIN
157: x_custom_output := bis_query_attributes_tbl ();
158: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
159: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
160: l_as_of_date ,
161: l_period_type,
162: l_record_type_id,
163: l_view_by,

Line 441: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

437:
438: BEGIN
439: x_custom_output := bis_query_attributes_tbl ();
440: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
441: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
442: l_as_of_date ,
443: l_period_type,
444: l_record_type_id,
445: l_view_by,

Line 575: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

571:
572: BEGIN
573: x_custom_output := bis_query_attributes_tbl ();
574: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
575: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
576: l_as_of_date ,
577: l_period_type,
578: l_record_type_id,
579: l_view_by,

Line 719: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

715:
716: BEGIN
717: x_custom_output := bis_query_attributes_tbl ();
718: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
719: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
720: l_as_of_date ,
721: l_period_type,
722: l_record_type_id,
723: l_view_by,

Line 842: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

838:
839: BEGIN
840: x_custom_output := bis_query_attributes_tbl ();
841: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
842: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
843: l_as_of_date ,
844: l_period_type,
845: l_record_type_id,
846: l_view_by,

Line 990: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

986:
987: BEGIN
988: x_custom_output := bis_query_attributes_tbl ();
989: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
990: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
991: l_as_of_date ,
992: l_period_type,
993: l_record_type_id,
994: l_view_by,

Line 1567: bim_pmv_dbi_utl_pkg.get_lookup_value(''DASS'') value,

1563: '||l_where||'
1564: GROUP BY p.value , p.id , p.leaf_node_flag
1565: UNION ALL
1566: SELECT
1567: bim_pmv_dbi_utl_pkg.get_lookup_value(''DASS'') value,
1568: p.id viewbyid,
1569: p.leaf_node_flag leaf_node_flag,
1570: SUM(decode(cal.report_date,&BIS_CURRENT_ASOF_DATE,a.activities_count,0)) activities ,
1571: SUM(decode(cal.report_date,&BIS_PREVIOUS_ASOF_DATE,a.activities_count,0)) prev_activities,

Line 1675: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

1671:
1672: BEGIN
1673: x_custom_output := bis_query_attributes_tbl ();
1674: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1675: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
1676: l_as_of_date ,
1677: l_period_type,
1678: l_record_type_id,
1679: l_view_by,

Line 1871: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,

1867:
1868: BEGIN
1869: x_custom_output := bis_query_attributes_tbl ();
1870: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1871: bim_pmv_dbi_utl_pkg.get_bim_page_sgmt_params(p_page_parameter_tbl,
1872: l_as_of_date ,
1873: l_period_type,
1874: l_record_type_id,
1875: l_view_by,