APPS.BIM_MARKET_FACTS_PKG dependencies on BIS_COMMON_PARAMETERS

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

2: /*$Header: bimmktfb.pls 120.8 2005/12/20 02:09:32 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_MARKET_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimmktfb.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: FUNCTION ret_max_date(p_sales_lead_id in number) return date is

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_MARKET_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimmktfb.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: FUNCTION ret_max_date(p_sales_lead_id in number) return date is
11: CURSOR get_max_date IS

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

4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_MARKET_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimmktfb.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: FUNCTION ret_max_date(p_sales_lead_id in number) return date is
11: CURSOR get_max_date IS
12: SELECT max(b.creation_date)

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

5: g_file_name CONSTANT VARCHAR2(20) := 'bimmktfb.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: FUNCTION ret_max_date(p_sales_lead_id in number) return date is
11: CURSOR get_max_date IS
12: SELECT max(b.creation_date)
13: FROM as_sales_leads a, as_sales_leads_log b

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

180: -- Debug Message
181: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');
182: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Facts load starts at:'||sysdate);
183:
184: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();
185:
186: /* THIS CODE REPLACES THE GET_LAST_REFRESH_PERIOD TO GET_LAST_REFRESH_DATES */
187:
188: bis_collection_utilities.get_last_refresh_dates('MARKETING_FACTS'

Line 383: l_global_currency_code := bis_common_parameters.get_currency_code;

379:
380: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
381:
382: --dbms_output.put_line('inside first load:'|| p_start_date || ' '|| p_end_date);
383: l_global_currency_code := bis_common_parameters.get_currency_code;
384:
385: -- Standard call to check for call compatibility.
386: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
387: p_api_version_number,