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_DEPOT_MTTR_PKG dependencies on BIS_BUCKET_PUB

Line 4: FUNCTION GET_MTTR_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

1: PACKAGE BODY ISC_DEPOT_MTTR_PKG AS
2: --$Header: iscdepotmttrrqb.pls 120.0 2005/05/25 17:41:39 appldev noship $
3:
4: FUNCTION GET_MTTR_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
5: RETURN VARCHAR2;
6:
7: FUNCTION get_drill_down (p_view_by_dim IN VARCHAR2,p_function_name IN VARCHAR2)
8: RETURN VARCHAR2;

Line 10: FUNCTION GET_MTTR_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

6:
7: FUNCTION get_drill_down (p_view_by_dim IN VARCHAR2,p_function_name IN VARCHAR2)
8: RETURN VARCHAR2;
9:
10: FUNCTION GET_MTTR_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
11: RETURN VARCHAR2;
12:
13: FUNCTION GET_MTTR_DIST_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
14: RETURN VARCHAR2;

Line 13: FUNCTION GET_MTTR_DIST_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

9:
10: FUNCTION GET_MTTR_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
11: RETURN VARCHAR2;
12:
13: FUNCTION GET_MTTR_DIST_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
14: RETURN VARCHAR2;
15:
16: FUNCTION GET_MTTR_DIST_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
17: RETURN VARCHAR2;

Line 16: FUNCTION GET_MTTR_DIST_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

12:
13: FUNCTION GET_MTTR_DIST_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
14: RETURN VARCHAR2;
15:
16: FUNCTION GET_MTTR_DIST_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
17: RETURN VARCHAR2;
18:
19: FUNCTION GET_MTTR_DTL_SEL_CLAUSE(l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type ,l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type)
20: RETURN VARCHAR2;

Line 49: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

45: l_aggregation_flag NUMBER;
46: l_custom_rec BIS_QUERY_ATTRIBUTES;
47: l_mv_type VARCHAR2(10);
48: l_err_stage VARCHAR2(32767);
49: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
50: l_debug_mode VARCHAR2(1);
51: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
52:
53: BEGIN

Line 153: FUNCTION GET_MTTR_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_view_by_col IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

149:
150: END GET_MTTR_TBL_SQL;
151:
152:
153: FUNCTION GET_MTTR_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_view_by_col IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
154: RETURN VARCHAR2
155: IS
156:
157: l_sel_clause VARCHAR2(8000);

Line 362: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

358: l_aggregation_flag NUMBER;
359: l_custom_rec BIS_QUERY_ATTRIBUTES;
360: l_mv_type VARCHAR2(10);
361: l_err_stage VARCHAR2(32767);
362: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
363: l_debug_mode VARCHAR2(1);
364: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
365:
366: BEGIN

Line 465: FUNCTION GET_MTTR_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

461: END IF;
462:
463: END GET_MTTR_TRD_SQL;
464:
465: FUNCTION GET_MTTR_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
466: RETURN VARCHAR2
467: IS
468:
469: l_sel_clause VARCHAR2(8000);

Line 676: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

672: l_aggregation_flag NUMBER;
673: l_custom_rec BIS_QUERY_ATTRIBUTES;
674: l_mv_type VARCHAR2(10);
675: l_err_stage VARCHAR2(32767);
676: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
677: l_debug_mode VARCHAR2(1);
678: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
679:
680: BEGIN

Line 780: FUNCTION GET_MTTR_DIST_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

776: END IF;
777:
778: END GET_MTTR_DIST_TBL_SQL;
779:
780: FUNCTION GET_MTTR_DIST_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2,p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
781: RETURN VARCHAR2
782: IS
783: l_sel_clause VARCHAR2(8000);
784: l_view_by_col_name VARCHAR2(120);

Line 930: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;

926: l_aggregation_flag NUMBER;
927: l_custom_rec BIS_QUERY_ATTRIBUTES;
928: l_mv_type VARCHAR2(10);
929: l_err_stage VARCHAR2(32767);
930: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
931: l_debug_mode VARCHAR2(1);
932: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
933:
934: BEGIN

Line 1032: FUNCTION GET_MTTR_DIST_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)

1028:
1029:
1030: END GET_MTTR_DIST_TRD_SQL;
1031:
1032: FUNCTION GET_MTTR_DIST_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
1033: RETURN VARCHAR2
1034: IS
1035:
1036: l_sel_clause VARCHAR2(8000);