61: l_debug_mode VARCHAR2(1);
62: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
63:
64: BEGIN
65: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
66: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
67: l_comparison_type := 'Y';
68: -- clear out the tables.
69: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
62: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
63:
64: BEGIN
65: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
66: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
67: l_comparison_type := 'Y';
68: -- clear out the tables.
69: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
70: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
295: l_debug_mode VARCHAR2(1);
296: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
297:
298: BEGIN
299: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
300: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
301: l_comparison_type := 'Y';
302: -- clear out the tables.
303: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
296: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
297:
298: BEGIN
299: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
300: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
301: l_comparison_type := 'Y';
302: -- clear out the tables.
303: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
304: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
443: l_debug_mode VARCHAR2(1);
444: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
445:
446: BEGIN
447: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
448: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
449: l_comparison_type := 'Y';
450: -- clear out the tables.
451: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
444: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
445:
446: BEGIN
447: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
448: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
449: l_comparison_type := 'Y';
450: -- clear out the tables.
451: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
452: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
651: l_debug_mode VARCHAR2(1);
652: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
653:
654: BEGIN
655: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
656: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
657: l_comparison_type := 'Y';
658: -- clear out the tables.
659: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
652: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
653:
654: BEGIN
655: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
656: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
657: l_comparison_type := 'Y';
658: -- clear out the tables.
659: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
660: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
796: l_debug_mode VARCHAR2(1);
797: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
798:
799: BEGIN
800: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
801: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
802: l_comparison_type := 'Y';
803:
804: -- clear out the tables.
797: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
798:
799: BEGIN
800: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
801: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
802: l_comparison_type := 'Y';
803:
804: -- clear out the tables.
805: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1003: l_debug_mode VARCHAR2(1);
1004: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1005:
1006: BEGIN
1007: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1008: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1009: l_comparison_type := 'Y';
1010: -- clear out the tables.
1011: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1004: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1005:
1006: BEGIN
1007: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1008: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1009: l_comparison_type := 'Y';
1010: -- clear out the tables.
1011: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1012: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1148: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1149: l_supress VARCHAR2 (200);
1150:
1151: BEGIN
1152: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1153: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1154: l_comparison_type := 'Y';
1155:
1156: -- clear out the tables.
1149: l_supress VARCHAR2 (200);
1150:
1151: BEGIN
1152: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1153: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1154: l_comparison_type := 'Y';
1155:
1156: -- clear out the tables.
1157: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1364: l_debug_mode VARCHAR2(1);
1365: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1366:
1367: BEGIN
1368: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1369: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1370: l_comparison_type := 'Y';
1371: -- clear out the tables.
1372: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1365: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1366:
1367: BEGIN
1368: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1369: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1370: l_comparison_type := 'Y';
1371: -- clear out the tables.
1372: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1373: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1512: l_debug_mode VARCHAR2(1);
1513: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1514:
1515: BEGIN
1516: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1517: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1518: l_comparison_type := 'Y';
1519: -- clear out the tables.
1520: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1513: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1514:
1515: BEGIN
1516: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1517: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1518: l_comparison_type := 'Y';
1519: -- clear out the tables.
1520: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1521: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();