DBA Data[Home] [Help]

APPS.IBE_REPORTING_PVT dependencies on FND_PROFILE

Line 8: g_conversionType FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

4: l_debug_profile VARCHAR2(1) := 'N';
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_REPORTING_PKG';
7:
8: g_conversionType FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
9: g_CurrencyCode FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
10: g_periodSetName FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
11: g_ForceRefreshFlag Varchar2(1);
12: g_QuarterBeginFlag Varchar2(1);

Line 9: g_CurrencyCode FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_REPORTING_PKG';
7:
8: g_conversionType FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
9: g_CurrencyCode FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
10: g_periodSetName FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
11: g_ForceRefreshFlag Varchar2(1);
12: g_QuarterBeginFlag Varchar2(1);
13: g_YearlyDataFlag Varchar2(1);

Line 10: g_periodSetName FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_REPORTING_PKG';
7:
8: g_conversionType FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
9: g_CurrencyCode FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
10: g_periodSetName FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
11: g_ForceRefreshFlag Varchar2(1);
12: g_QuarterBeginFlag Varchar2(1);
13: g_YearlyDataFlag Varchar2(1);
14: g_ParallelFlag Varchar2(1);

Line 676: g_conversionType := fnd_profile.Value_Specific('IBE_GL_CONVERSION_TYPE',null,null,671);

672: printDebugLog('getProfileValues(+)');
673: printDebugLog(fnd_global.tab||'No IN Parameters');
674: END IF;
675:
676: g_conversionType := fnd_profile.Value_Specific('IBE_GL_CONVERSION_TYPE',null,null,671);
677:
678: If g_conversionType is null Then
679: g_setupErrorCount := g_setupErrorCount + 1;
680: End If;

Line 682: g_currencyCode := fnd_profile.Value_Specific('IBE_CURRENCY_CODE',null,null,671);

678: If g_conversionType is null Then
679: g_setupErrorCount := g_setupErrorCount + 1;
680: End If;
681:
682: g_currencyCode := fnd_profile.Value_Specific('IBE_CURRENCY_CODE',null,null,671);
683:
684:
685: If g_currencyCode is null Then
686: g_setupErrorCount := g_setupErrorCount + 1;

Line 689: g_PeriodSetName := fnd_profile.Value_Specific('IBE_ECR_PERIOD_SET_NAME',null,null,671);

685: If g_currencyCode is null Then
686: g_setupErrorCount := g_setupErrorCount + 1;
687: End If;
688:
689: g_PeriodSetName := fnd_profile.Value_Specific('IBE_ECR_PERIOD_SET_NAME',null,null,671);
690:
691: If g_PeriodSetName is null Then
692: g_setupErrorCount := g_setupErrorCount + 1;
693: End If;

Line 695: g_ForceRefreshFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_FORCE_REFRESH',null,null,671),'Y');

691: If g_PeriodSetName is null Then
692: g_setupErrorCount := g_setupErrorCount + 1;
693: End If;
694:
695: g_ForceRefreshFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_FORCE_REFRESH',null,null,671),'Y');
696: g_parallelFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_PARALLEL_PROCESSING',null,null,671),'N');
697: g_QuarterBeginFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_QUARTER_BEGIN_DATA',null,null,671),'Y');
698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');
699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');

Line 696: g_parallelFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_PARALLEL_PROCESSING',null,null,671),'N');

692: g_setupErrorCount := g_setupErrorCount + 1;
693: End If;
694:
695: g_ForceRefreshFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_FORCE_REFRESH',null,null,671),'Y');
696: g_parallelFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_PARALLEL_PROCESSING',null,null,671),'N');
697: g_QuarterBeginFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_QUARTER_BEGIN_DATA',null,null,671),'Y');
698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');
699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');
700:

Line 697: g_QuarterBeginFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_QUARTER_BEGIN_DATA',null,null,671),'Y');

693: End If;
694:
695: g_ForceRefreshFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_FORCE_REFRESH',null,null,671),'Y');
696: g_parallelFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_PARALLEL_PROCESSING',null,null,671),'N');
697: g_QuarterBeginFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_QUARTER_BEGIN_DATA',null,null,671),'Y');
698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');
699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');
700:
701: IF (l_debug = 'Y') THEN

Line 698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');

694:
695: g_ForceRefreshFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_FORCE_REFRESH',null,null,671),'Y');
696: g_parallelFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_PARALLEL_PROCESSING',null,null,671),'N');
697: g_QuarterBeginFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_QUARTER_BEGIN_DATA',null,null,671),'Y');
698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');
699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');
700:
701: IF (l_debug = 'Y') THEN
702: printDebugLog(fnd_global.tab||'No OUT Parameters');

Line 699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');

695: g_ForceRefreshFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_FORCE_REFRESH',null,null,671),'Y');
696: g_parallelFlag := nvl(fnd_profile.value_specific('IBE_ENABLE_PARALLEL_PROCESSING',null,null,671),'N');
697: g_QuarterBeginFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_QUARTER_BEGIN_DATA',null,null,671),'Y');
698: g_YearlyDataFlag := nvl(fnd_profile.Value_Specific('IBE_ECR_YEARLY_DATA',null,null,671),'Y');
699: g_TruncateFlag := nvl(fnd_profile.Value_Specific('IBE_TRUNC_RECORDS',null,null,671),'Y');
700:
701: IF (l_debug = 'Y') THEN
702: printDebugLog(fnd_global.tab||'No OUT Parameters');
703: printDebugLog('getProfileValues(-)');

Line 1385: l_debug_profile := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

1381: l_MissingCount Number;
1382:
1383: Begin
1384:
1385: l_debug_profile := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1386: if ( l_debug_profile = 'Y' OR pDebugFlag = 'Y') then
1387: l_debug := 'Y';
1388: else
1389: l_debug := 'N';

Line 1733: l_debug_profile := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

1729: l_tablespace Varchar2(30);
1730: l_mvlogStatus Number;
1731:
1732: BEGIN
1733: l_debug_profile := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1734: if ( l_debug_profile = 'Y' OR pDebugFlag = 'Y') then
1735: l_debug := 'Y';
1736: else
1737: l_debug := 'N';