DBA Data[Home] [Help]

APPS.ISC_DEPOT_BACKLOG_PKG dependencies on FND_PROFILE

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

39: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
40: l_last_refresh_date DATE;
41:
42: BEGIN
43: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
44: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
45: l_comparison_type := 'Y';
46: l_last_refresh_date := bis_submit_requestset.get_last_refreshdate('REPORT','APPS','ISC_DEPOT_BACKLOG_TBL') ;
47:

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

40: l_last_refresh_date DATE;
41:
42: BEGIN
43: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
44: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
45: l_comparison_type := 'Y';
46: l_last_refresh_date := bis_submit_requestset.get_last_refreshdate('REPORT','APPS','ISC_DEPOT_BACKLOG_TBL') ;
47:
48: -- clear out the tables.

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

327: l_debug_mode VARCHAR2(1);
328: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
329:
330: BEGIN
331: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
332: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
333: l_comparison_type := 'Y';
334:
335: -- clear out the tables.

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

328: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
329:
330: BEGIN
331: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
332: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
333: l_comparison_type := 'Y';
334:
335: -- clear out the tables.
336: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

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

494: l_debug_mode VARCHAR2(1);
495: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
496:
497: BEGIN
498: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
499: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
500:
501: -- clear out the tables.
502: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

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

495: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
496:
497: BEGIN
498: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
499: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
500:
501: -- clear out the tables.
502: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
503: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

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

626: l_debug_mode VARCHAR2(1);
627: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
628:
629: BEGIN
630: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
631: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
632:
633: -- clear out the tables.
634: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

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

627: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
628:
629: BEGIN
630: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
631: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
632:
633: -- clear out the tables.
634: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
635: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

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

782: l_debug_mode VARCHAR2(1);
783: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
784:
785: BEGIN
786: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
787: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
788:
789: -- clear out the tables.
790: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

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

783: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
784:
785: BEGIN
786: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
787: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
788:
789: -- clear out the tables.
790: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
791: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

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

920: l_debug_mode VARCHAR2(1);
921: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
922:
923: BEGIN
924: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
925: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
926: l_agg_flag_1 := 0; -- for isc_dr_curr_02_mv
927: l_agg_flag_2 := 0; -- for isc_dr_bklg_01_mv,isc_dr_bklg_02_mv
928:

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

921: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
922:
923: BEGIN
924: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
925: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
926: l_agg_flag_1 := 0; -- for isc_dr_curr_02_mv
927: l_agg_flag_2 := 0; -- for isc_dr_bklg_01_mv,isc_dr_bklg_02_mv
928:
929: -- clear out the tables.