DBA Data[Home] [Help]

APPS.AS_SC_DENORM dependencies on FND_PROFILE

Line 26: G_PREFERRED_CURRENCY as_period_rates.TO_CURRENCY%Type := FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY');

22:
23: -- Global variables
24: G_Debug Boolean := True;
25: G_LANG VARCHAR2(10) := userenv('LANG');
26: G_PREFERRED_CURRENCY as_period_rates.TO_CURRENCY%Type := FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY');
27: G_CONVERSION_TYPE as_period_rates.conversion_type%Type :=FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE');
28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');
29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;

Line 27: G_CONVERSION_TYPE as_period_rates.conversion_type%Type :=FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE');

23: -- Global variables
24: G_Debug Boolean := True;
25: G_LANG VARCHAR2(10) := userenv('LANG');
26: G_PREFERRED_CURRENCY as_period_rates.TO_CURRENCY%Type := FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY');
27: G_CONVERSION_TYPE as_period_rates.conversion_type%Type :=FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE');
28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');
29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;

Line 28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');

24: G_Debug Boolean := True;
25: G_LANG VARCHAR2(10) := userenv('LANG');
26: G_PREFERRED_CURRENCY as_period_rates.TO_CURRENCY%Type := FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY');
27: G_CONVERSION_TYPE as_period_rates.conversion_type%Type :=FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE');
28: G_PERIOD_TYPE as_period_rates.PERIOD_TYPE%Type := FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE');
29:
30: Type sales_credit_id_list is Table of as_sales_credits_denorm.sales_credit_id%type Index by Binary_integer;
31: Type sales_group_name_list is Table of as_sales_credits_denorm.sales_group_name%type Index by Binary_integer;
32: Type sales_rep_name_list is Table of as_sales_credits_denorm.sales_rep_name%type Index by Binary_integer;