34: l_debug_mode VARCHAR2(1);
35: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
36:
37: BEGIN
38: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
39: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
40: l_comparison_type := 'Y';
41:
42: -- clear out the tables.
35: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
36:
37: BEGIN
38: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
39: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
40: l_comparison_type := 'Y';
41:
42: -- clear out the tables.
43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
348: l_debug_mode VARCHAR2(1);
349: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
350:
351: BEGIN
352: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
353: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
354: l_comparison_type := 'Y';
355:
356: -- clear out the tables.
349: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
350:
351: BEGIN
352: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
353: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
354: l_comparison_type := 'Y';
355:
356: -- clear out the tables.
357: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
522: l_debug_mode VARCHAR2(1);
523: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
524:
525: BEGIN
526: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
527: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
528:
529: -- clear out the tables.
530: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
523: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
524:
525: BEGIN
526: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
527: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
528:
529: -- clear out the tables.
530: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
531: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
652: l_debug_mode VARCHAR2(1);
653: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
654:
655: BEGIN
656: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
657: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
658:
659: -- clear out the tables.
660: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
653: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
654:
655: BEGIN
656: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
657: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
658:
659: -- clear out the tables.
660: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
661: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
785: l_debug_mode VARCHAR2(1);
786: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
787:
788: BEGIN
789: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
790: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
791:
792: -- clear out the tables.
793: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
786: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
787:
788: BEGIN
789: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
790: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
791:
792: -- clear out the tables.
793: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
794: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();