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

Line 9: -- p_dim_map OUT poa_dbi_util_pkg.poa_dbi_dim_map

5: p_mv_bmap_tbl OUT NOCOPY oki_dbi_mv_bmap_tbl
6: , p_mv_set IN VARCHAR2);
7:
8: -- FUNCTION get_where_clauses (
9: -- p_dim_map OUT poa_dbi_util_pkg.poa_dbi_dim_map
10: -- , p_trend IN VARCHAR2)
11: -- RETURN VARCHAR2;
12:
13: PROCEDURE split_pseudo_rs_group (

Line 385: p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl

381: -- get_nested_cols () clause to get upper sql conditions
382: -- brrao added
383: -- -----------------------------------------------------
384: FUNCTION get_nested_cols (
385: p_col_name IN poa_dbi_util_pkg.poa_dbi_col_tbl
386: ,period_type IN VARCHAR2
387: ,P_TREND in varchar2 )
388: RETURN VARCHAR2 IS
389:

Line 421: IF (p_col_name(i).prior_code <> poa_dbi_util_pkg.no_priors)

417: IF (p_col_name(i).to_date_type IN ('ITD','YTD'))
418: THEN
419: L_str := l_str ||',SUM(decode(cal.report_date,'|| c_date ||','|| p_col_name(i).column_name||')) c_'|| p_col_name(i).column_alias;
420:
421: IF (p_col_name(i).prior_code <> poa_dbi_util_pkg.no_priors)
422: THEN
423: L_str :=l_str||',SUM(decode(cal.report_date,'|| p_date ||','|| p_col_name(i).column_name||')) p_'|| p_col_name(i).column_alias;
424:
425: END IF;

Line 431: IF (p_col_name(i).prior_code <> poa_dbi_util_pkg.no_priors)

427: IF(p_trend <> 'Y')
428: THEN
429: L_str := l_str ||',TO_NUMBER(null) c_' || p_col_name(i).column_alias;
430: -- Prev column (based on prior_code)
431: IF (p_col_name(i).prior_code <> poa_dbi_util_pkg.no_priors)
432: THEN
433: L_str := l_str ||',TO_NUMBER(null) P_' || p_col_name(i).column_alias;
434: END IF;
435: END IF;

Line 453: IF (p_col_name(i).prior_code <> poa_dbi_util_pkg.no_priors)

449: L_str := l_str ||',sum(sum(decode(cal.report_date,'|| c_date ||','|| p_col_name(i).column_name||',null))) over() c_'|| p_col_name(i).column_alias || '_total
450:
451: ';
452: END IF;
453: IF (p_col_name(i).prior_code <> poa_dbi_util_pkg.no_priors)
454: THEN
455: L_str := l_str ||',SUM(decode(cal.report_date,'|| p_date ||','|| p_col_name(i).column_name||',null)) p_'|| p_col_name(i).column_alias
456:
457: || '

Line 920: , p_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl

916: , p_cur_suffix OUT NOCOPY VARCHAR2
917: , p_nested_pattern OUT NOCOPY NUMBER
918: , p_where_clause OUT NOCOPY VARCHAR2
919: , p_mv OUT NOCOPY VARCHAR2
920: , p_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
921: , p_period_type OUT NOCOPY VARCHAR2
922: , p_trend IN VARCHAR2
923: , p_func_area IN VARCHAR2 -- Renewals?
924: , p_version IN VARCHAR2

Line 929: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

925: , p_role IN VARCHAR2 --
926: , p_mv_set IN VARCHAR2
927: , p_rg_where IN VARCHAR2) -- SRM
928: IS
929: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
930: l_dim_bmap NUMBER;
931: l_rpt_where VARCHAR2(3000);
932: l_class VARCHAR2(3000);
933: l_eni_schema VARCHAR2(20);

Line 948: poa_dbi_util_pkg.get_parameter_values (p_param

944: init_dim_map (l_dim_map
945: , p_func_area
946: , p_version
947: , p_mv_set);
948: poa_dbi_util_pkg.get_parameter_values (p_param
949: , l_dim_map
950: , p_view_by
951: , p_comparison_type
952: , p_xtd

Line 961: -- l_dim_bmap := poa_dbi_util_pkg.bitor (l_dim_bmap

957: , l_dim_bmap);
958: g_view_by := p_view_by;
959: /* add in the security dimensions that must always be present in bmap */
960: --Ravi commented
961: -- l_dim_bmap := poa_dbi_util_pkg.bitor (l_dim_bmap
962: -- , g_oper_unit_bmap);
963: /* Change the Suffix */
964: p_cur_suffix := get_cur_suffix (p_cur_suffix);
965: /* Set period type */

Line 1255: p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map

1251: (1) Operating Unit
1252: (2) Resource Group
1253: ----------------------------------------------------------------------------- */
1254: FUNCTION get_security_where_clauses (
1255: p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map
1256: , p_func_area IN VARCHAR2
1257: , p_version IN VARCHAR2
1258: , p_role IN VARCHAR2
1259: , p_view_by IN VARCHAR2

Line 1275: l_ou_where := poa_dbi_util_pkg.get_ou_sec_where (p_dim_map ('ORGANIZATION+FII_OPERATING_UNITS').VALUE

1271: l_service_cat_where VARCHAR2 (1000);
1272: BEGIN
1273: l_sec_where_clause := '';
1274: /* l_org_col := 'authoring_org_id';
1275: l_ou_where := poa_dbi_util_pkg.get_ou_sec_where (p_dim_map ('ORGANIZATION+FII_OPERATING_UNITS').VALUE
1276: , p_dim_map ('ORGANIZATION+FII_OPERATING_UNITS').col_name);
1277:
1278: IF (l_ou_where IS NOT NULL)
1279: THEN

Line 1343: p_dim_map OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map

1339: /* -----------------------------------------------------------------------------
1340: init_dim_map: Initialize the dimension mapping
1341: ----------------------------------------------------------------------------- */
1342: PROCEDURE init_dim_map (
1343: p_dim_map OUT NOCOPY poa_dbi_util_pkg.poa_dbi_dim_map
1344: , p_func_area IN VARCHAR2
1345: , p_version IN VARCHAR2
1346: , p_mv_set IN VARCHAR2)
1347: IS

Line 1348: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;

1344: , p_func_area IN VARCHAR2
1345: , p_version IN VARCHAR2
1346: , p_mv_set IN VARCHAR2)
1347: IS
1348: l_dim_rec poa_dbi_util_pkg.poa_dbi_dim_rec;
1349: BEGIN
1350: -- Operating Unit
1351: l_dim_rec.generate_where_clause := 'Y';
1352: l_dim_rec.col_name := get_col_name (dim_name => g_oper_unit_dim

Line 1526: , p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map

1522: END get_table;
1523:
1524: PROCEDURE get_join_info (
1525: p_view_by IN VARCHAR2
1526: , p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map
1527: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
1528: , p_func_area IN VARCHAR2
1529: , p_version IN VARCHAR2)
1530: IS

Line 1527: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl

1523:
1524: PROCEDURE get_join_info (
1525: p_view_by IN VARCHAR2
1526: , p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map
1527: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
1528: , p_func_area IN VARCHAR2
1529: , p_version IN VARCHAR2)
1530: IS
1531: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

Line 1531: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

1527: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
1528: , p_func_area IN VARCHAR2
1529: , p_version IN VARCHAR2)
1530: IS
1531: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
1532: BEGIN
1533: x_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1534:
1535: IF (NOT p_dim_map.EXISTS (p_view_by))

Line 1533: x_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

1529: , p_version IN VARCHAR2)
1530: IS
1531: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
1532: BEGIN
1533: x_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1534:
1535: IF (NOT p_dim_map.EXISTS (p_view_by))
1536: THEN
1537: RETURN;

Line 1586: , p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map

1582: get_join_info:
1583: ----------------------------------------------------------------------------- */
1584: /* PROCEDURE get_join_info (
1585: p_view_by IN VARCHAR2
1586: , p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map
1587: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
1588: , p_func_area IN VARCHAR2
1589: , p_version IN VARCHAR2
1590: , p_rpt_type IN VARCHAR2 := 'SUMMARY')

Line 1587: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl

1583: ----------------------------------------------------------------------------- */
1584: /* PROCEDURE get_join_info (
1585: p_view_by IN VARCHAR2
1586: , p_dim_map IN poa_dbi_util_pkg.poa_dbi_dim_map
1587: , x_join_tbl OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
1588: , p_func_area IN VARCHAR2
1589: , p_version IN VARCHAR2
1590: , p_rpt_type IN VARCHAR2 := 'SUMMARY')
1591: IS

Line 1592: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

1588: , p_func_area IN VARCHAR2
1589: , p_version IN VARCHAR2
1590: , p_rpt_type IN VARCHAR2 := 'SUMMARY')
1591: IS
1592: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
1593: BEGIN
1594: x_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1595:
1596: --DBMS_OUTPUT.put_line ('p_rpt_type: [' || p_rpt_type || ']');

Line 1594: x_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

1590: , p_rpt_type IN VARCHAR2 := 'SUMMARY')
1591: IS
1592: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
1593: BEGIN
1594: x_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1595:
1596: --DBMS_OUTPUT.put_line ('p_rpt_type: [' || p_rpt_type || ']');
1597:
1598: IF (NOT p_dim_map.EXISTS (p_view_by))

Line 1900: p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map

1896: RETURN l_period_type_code;
1897: END get_period_type_code;
1898:
1899: FUNCTION get_where_clauses (
1900: p_dim_map poa_dbi_util_pkg.poa_dbi_dim_map
1901: , p_trend IN VARCHAR2
1902: , p_view_by IN VARCHAR2
1903: , p_mv_set IN VARCHAR2)
1904: RETURN VARCHAR2

Line 2010: p_join_tbl IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl

2006: RETURN l_where_clause;
2007: END get_where_clauses;
2008:
2009: PROCEDURE add_join_table (
2010: p_join_tbl IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
2011: , p_column_name IN VARCHAR2
2012: , p_table_name IN VARCHAR2
2013: , p_table_alias IN VARCHAR2
2014: , p_fact_column IN VARCHAR2

Line 2018: l_join_tbl_rec poa_dbi_util_pkg.poa_dbi_join_rec;

2014: , p_fact_column IN VARCHAR2
2015: , p_dim_outer_join IN VARCHAR2 := 'N'
2016: , p_additional_where_clause IN VARCHAR2)
2017: IS
2018: l_join_tbl_rec poa_dbi_util_pkg.poa_dbi_join_rec;
2019: BEGIN
2020: l_join_tbl_rec.column_name := p_column_name;
2021: l_join_tbl_rec.table_name := p_table_name;
2022: l_join_tbl_rec.table_alias := p_table_alias;

Line 2031: p_join_tbl IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl

2027: p_join_tbl (p_join_tbl.COUNT) := l_join_tbl_rec;
2028: END;
2029:
2030: PROCEDURE join_rpt_where (
2031: p_join_tbl IN OUT NOCOPY poa_dbi_util_pkg.poa_dbi_join_tbl
2032: , p_func_area IN VARCHAR2
2033: , p_version IN VARCHAR2
2034: , p_role IN VARCHAR2
2035: , p_mv_set IN VARCHAR2)

Line 2037: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

2033: , p_version IN VARCHAR2
2034: , p_role IN VARCHAR2
2035: , p_mv_set IN VARCHAR2)
2036: IS
2037: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
2038: BEGIN
2039: l_join_tbl := p_join_tbl;
2040:
2041: IF ( p_func_area = 'SRM_CUST' )

Line 2200: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => p_xtd

2196: IS
2197: l_custom_rec bis_query_attributes;
2198: BEGIN
2199: -- get binds that are common across applications
2200: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => p_xtd
2201: , p_comparison_type => p_comparison_type
2202: , x_custom_output => x_custom_output);
2203: -- get binds that are specific to OKI
2204: get_bind_vars (x_custom_output => x_custom_output);

Line 2213: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output => x_custom_output);

2209: IS
2210: l_custom_rec bis_query_attributes;
2211: BEGIN
2212: -- get binds that are common across applications
2213: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output => x_custom_output);
2214: -- get binds that are specific to OKI
2215: get_bind_vars (x_custom_output => x_custom_output);
2216: END get_custom_status_binds;
2217: