DBA Data[Home] [Help]

APPS.BIM_I_BGT_FACTS_PKG dependencies on BIS_COMMON_PARAMETERS

Line 6: l_global_currency_code CONSTANT varchar2(20) := bis_common_parameters.get_currency_code;

2: /*$Header: bimibgfb.pls 120.3 2005/10/14 06:11:40 sbassi noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_BGT_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimibgfb.pls';
6: l_global_currency_code CONSTANT varchar2(20) := bis_common_parameters.get_currency_code;
7: l_secondary_currency_code CONSTANT VARCHAR2(20) :=bis_common_parameters.get_secondary_currency_code;
8: l_pgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_Rate_Type;
9: l_sgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_secondary_Rate_Type;
10: -- Checks for any missing currency from budget facts table

Line 7: l_secondary_currency_code CONSTANT VARCHAR2(20) :=bis_common_parameters.get_secondary_currency_code;

3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_BGT_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimibgfb.pls';
6: l_global_currency_code CONSTANT varchar2(20) := bis_common_parameters.get_currency_code;
7: l_secondary_currency_code CONSTANT VARCHAR2(20) :=bis_common_parameters.get_secondary_currency_code;
8: l_pgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_Rate_Type;
9: l_sgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_secondary_Rate_Type;
10: -- Checks for any missing currency from budget facts table
11:

Line 8: l_pgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_Rate_Type;

4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_BGT_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimibgfb.pls';
6: l_global_currency_code CONSTANT varchar2(20) := bis_common_parameters.get_currency_code;
7: l_secondary_currency_code CONSTANT VARCHAR2(20) :=bis_common_parameters.get_secondary_currency_code;
8: l_pgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_Rate_Type;
9: l_sgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_secondary_Rate_Type;
10: -- Checks for any missing currency from budget facts table
11:
12: FUNCTION Check_Missing_Rates (p_start_date IN Date)

Line 9: l_sgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_secondary_Rate_Type;

5: g_file_name CONSTANT VARCHAR2(20) := 'bimibgfb.pls';
6: l_global_currency_code CONSTANT varchar2(20) := bis_common_parameters.get_currency_code;
7: l_secondary_currency_code CONSTANT VARCHAR2(20) :=bis_common_parameters.get_secondary_currency_code;
8: l_pgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_Rate_Type;
9: l_sgc_rate_type CONSTANT VARCHAR2(20) :=bis_common_parameters.Get_secondary_Rate_Type;
10: -- Checks for any missing currency from budget facts table
11:
12: FUNCTION Check_Missing_Rates (p_start_date IN Date)
13: Return NUMBER

Line 166: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();

162: -- Debug Message
163: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');
164: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Facts load starts at:'||sysdate);
165:
166: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();
167:
168: /* THIS CODE REPLACES THE GET_LAST_REFRESH_PERIOD TO GET_LAST_REFRESH_DATES */
169:
170: bis_collection_utilities.get_last_refresh_dates('BUDGET_FACTS'