APPS.OPI_DBI_RPT_UTIL_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 1: PACKAGE BODY OPI_DBI_RPT_UTIL_PKG AS

1: PACKAGE BODY OPI_DBI_RPT_UTIL_PKG AS
2: /*$Header: OPIDRMFGUTB.pls 120.9 2006/02/24 03:23:27 achandak noship $ */
3:
4: s_pkg_name CONSTANT VARCHAR2 (50) := 'opi_dbi_rpt_util_pkg';
5:

Line 4: s_pkg_name CONSTANT VARCHAR2 (50) := 'opi_dbi_rpt_util_pkg';

1: PACKAGE BODY OPI_DBI_RPT_UTIL_PKG AS
2: /*$Header: OPIDRMFGUTB.pls 120.9 2006/02/24 03:23:27 achandak noship $ */
3:
4: s_pkg_name CONSTANT VARCHAR2 (50) := 'opi_dbi_rpt_util_pkg';
5:
6: /*++++++++++++++++++++++++++++++++++++++++*/
7: /* Local Functions
8: /*++++++++++++++++++++++++++++++++++++++++*/

Line 188: FUNCTION get_agg_level (p_mv_lvl_tbl IN opi_dbi_rpt_util_pkg.MV_AGG_LVL_TBL,

184: p_dim_map IN
185: poa_dbi_util_pkg.poa_dbi_dim_map)
186: RETURN VARCHAR2;
187:
188: FUNCTION get_agg_level (p_mv_lvl_tbl IN opi_dbi_rpt_util_pkg.MV_AGG_LVL_TBL,
189: p_dim_bmap IN NUMBER)
190: RETURN NUMBER;
191:
192: /*

Line 3474: FUNCTION get_agg_level (p_mv_lvl_tbl IN opi_dbi_rpt_util_pkg.MV_AGG_LVL_TBL,

3470: If no record satisfies the check, return the most granular level
3471:
3472: If p_mv_lvl_tbl is not initialized return -1 to signal error
3473: -----------------------------------------------------------------------*/
3474: FUNCTION get_agg_level (p_mv_lvl_tbl IN opi_dbi_rpt_util_pkg.MV_AGG_LVL_TBL,
3475: p_dim_bmap IN NUMBER)
3476: RETURN NUMBER
3477: IS
3478: NO_INITIALIZE EXCEPTION; /* raise exception when table is not initialized */

Line 3902: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 0;

3898:
3899: inv_convert.inv_um_conversion(p_from_unit , p_to_unit , p_item_id, l_uom_rate);
3900: if ( l_uom_rate = -99999 ) then
3901: --RAISE UOM_CONV_ERROR;
3902: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 0;
3903: l_debug_msg := 'Conversion not found from unit '|| p_from_unit || 'to unit' || p_to_unit || 'for item id ' || p_item_id ;
3904: OPI_DBI_BOUNDS_PKG.write(s_pkg_name,l_proc_name,l_stmt_num,l_debug_msg);
3905: end if;
3906: else

Line 3927: END OPI_DBI_RPT_UTIL_PKG;

3923: RAISE;
3924:
3925: END OPI_UM_CONVERT;
3926:
3927: END OPI_DBI_RPT_UTIL_PKG;