APPS.MTH_UTIL_PKG dependencies on MTH_UTIL_PKG

Line 1: PACKAGE BODY mth_util_pkg AS

1: PACKAGE BODY mth_util_pkg AS
2: /*$Header: mthutilb.pls 120.8.12010000.6 2008/11/06 01:37:01 tkan ship $ */
3:
4:
5: /* *****************************************************************************

Line 476: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL

472: decode(level2_fk_key,NULL,0,1) +
473: decode(level1_fk_key,NULL,0,1)) over(PARTITION BY hierarchy_id)
474: max_level--maximum level in the hierarchy
475: FROM mth_item_denorm_d
476: WHERE item_fk_key != MTH_UTIL_PKG.MTH_UA_GET_VAL
477: )
478: WHERE c_level 479: AND level9_fk_key IS NOT NULL
480: )';

Line 1154: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);

1150: IS
1151: v_bneed_refresh BOOLEAN := FALSE;
1152: v_last_refresh_date DATE;
1153: v_refresh_date_required DATE;
1154: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);
1155: v_mv_name varchar2(30);
1156: cursor getRefreshDate (p_mv_name in varchar2) is
1157: SELECT last_refresh_date
1158: FROM user_mviews

Line 1576: END mth_util_pkg;

1572: EXECUTE IMMEDIATE v_stmt;
1573: END truncate_table_partition;
1574:
1575:
1576: END mth_util_pkg;