APPS.ISC_DEPOT_RPT_UTIL_PKG dependencies on ISC_DEPOT_RPT_UTIL_PKG

Line 1: PACKAGE BODY ISC_DEPOT_RPT_UTIL_PKG AS

1: PACKAGE BODY ISC_DEPOT_RPT_UTIL_PKG AS
2: -- $Header: iscdepotutilb.pls 120.1 2006/01/26 19:22:21 kreardon noship $
3:
4: -- List of mv sets and their corresponding reports.
5: -- 'BKLG' - Repair Order Backlog,Repair Order Backlog Trend,Repair Order Completion,

Line 94: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

90: l_additional_where_clause VARCHAR2(10000);
91: l_err_stage VARCHAR2(32767);
92: l_repair_type VARCHAR2(100);
93: l_debug_mode VARCHAR2(1);
94: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
95:
96: BEGIN
97: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
98: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 379: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

375: IS
376: l_where_clause VARCHAR2 (150);
377: l_err_stage VARCHAR2(3001);
378: l_debug_mode VARCHAR2(1);
379: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
380:
381: BEGIN
382:
383: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN

Line 486: l_mv_agg_tbl ISC_DEPOT_RPT_UTIL_PKG.mv_agg_tbl_typ;

482: FUNCTION get_agg_flag (p_mv_set IN VARCHAR2,p_dim_bmap IN NUMBER
483: ,p_mv_type IN VARCHAR2)
484: RETURN NUMBER
485: IS
486: l_mv_agg_tbl ISC_DEPOT_RPT_UTIL_PKG.mv_agg_tbl_typ;
487: BEGIN
488:
489: IF (p_mv_type = 'ROOT') THEN
490: l_mv_agg_tbl(1) := 4;

Line 816: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

812: IS
813: l_stmt_id VARCHAR2(3999);
814: l_log_level NUMBER;
815: l_debug_mode VARCHAR2(1);
816: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
817:
818: BEGIN
819:
820: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 854: END ISC_DEPOT_RPT_UTIL_PKG;

850: RETURN l_service_request_url;
851: END get_service_request_url ;
852:
853:
854: END ISC_DEPOT_RPT_UTIL_PKG;