DBA Data[Home] [Help]

APPS.ISC_DEPOT_MARGIN_RPT_PKG dependencies on FND_PROFILE

Line 65: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 66: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 299: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 300: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 447: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 448: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 655: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 656: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 800: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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.

Line 801: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 1007: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 1008: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 1152: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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.

Line 1153: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 1368: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 1369: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();

Line 1516: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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 ();

Line 1517: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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 ();