DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_CACHE_PKG dependencies on XLA_ACCOUNTING_CACHE_PKG

Line 1: PACKAGE BODY xla_accounting_cache_pkg AS

1: PACKAGE BODY xla_accounting_cache_pkg AS
2: -- $Header: xlaapche.pkb 120.61.12020000.3 2012/09/07 04:58:23 nmikkili ship $
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 12: | xla_accounting_cache_pkg |

8: | FILENAME |
9: | xlaapche.pkb |
10: | |
11: | PACKAGE NAME |
12: | xla_accounting_cache_pkg |
13: | |
14: | DESCRIPTION |
15: | This package is defined to cache the frequently used data during |
16: | execution of Accounting Program. This is to improve performance and |

Line 286: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_accounting_cache_pkg';

282: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
283: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
284:
285: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
286: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_accounting_cache_pkg';
287:
288: --g_log_module VARCHAR2(240);
289: g_log_level NUMBER;
290: g_log_enabled BOOLEAN;

Line 309: (p_location => 'xla_accounting_cache_pkg.trace');

305: WHEN xla_exceptions_pkg.application_exception THEN
306: RAISE;
307: WHEN OTHERS THEN
308: xla_exceptions_pkg.raise_message
309: (p_location => 'xla_accounting_cache_pkg.trace');
310: END trace;
311:
312:
313: --=============================================================================

Line 1726: ,p_value_2 => 'xla_accounting_cache_pkg.load_application_ledgers');

1722: ,p_value_1 => 'ERROR: Problem getting ledger information for application '||p_application_id||'. '||
1723: 'Subledger Accounting Options are not defined for this ledger and application.
1724: Please run Update Subledger Accounting Options program for your application.'
1725: ,p_token_2 => 'LOCATION'
1726: ,p_value_2 => 'xla_accounting_cache_pkg.load_application_ledgers');
1727: END IF;
1728: WHEN xla_exceptions_pkg.application_exception THEN
1729: RAISE;
1730: WHEN OTHERS THEN

Line 2599: ,p_value_2 => 'xla_accounting_cache_pkg.get_je_category');

2595: 'Subledger Accounting Options are not defined for the ledger and your application.'||
2596: 'Please run Update Subledger Accounting Options program for your application.'
2597:
2598: ,p_token_2 => 'LOCATION'
2599: ,p_value_2 => 'xla_accounting_cache_pkg.get_je_category');
2600:
2601: WHEN xla_exceptions_pkg.application_exception THEN
2602: RAISE;
2603: WHEN OTHERS THEN

Line 3043: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

3039: END IF;
3040:
3041: FOR Idx IN g_base_ledger_ids.FIRST .. g_base_ledger_ids.LAST LOOP
3042:
3043: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
3044: p_source_code => 'XLA_ROUNDING_RULE_CODE'
3045: , p_target_ledger_id => g_base_ledger_ids(Idx)
3046: );
3047: IF l_rounding_rule_code = 'NEAREST' THEN

Line 3060: xla_accounting_cache_pkg.GetValueChar(

3056:
3057: l_count:=l_count+1;
3058:
3059: g_array_ledger_attrs.array_default_rate_type(l_count) :=
3060: xla_accounting_cache_pkg.GetValueChar(
3061: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
3062: , p_target_ledger_id => g_base_ledger_ids(Idx)
3063: );
3064: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=

Line 3065: xla_accounting_cache_pkg.GetValueChar(

3061: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
3062: , p_target_ledger_id => g_base_ledger_ids(Idx)
3063: );
3064: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=
3065: xla_accounting_cache_pkg.GetValueChar(
3066: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
3067: , p_target_ledger_id => g_base_ledger_ids(Idx)
3068: );
3069: g_array_ledger_attrs.array_max_roll_date(l_count) :=

Line 3070: xla_accounting_cache_pkg.GetValueNum(

3066: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
3067: , p_target_ledger_id => g_base_ledger_ids(Idx)
3068: );
3069: g_array_ledger_attrs.array_max_roll_date(l_count) :=
3070: xla_accounting_cache_pkg.GetValueNum(
3071: p_source_code => 'XLA_MAX_DAYS_ROLL_RATE'
3072: , p_target_ledger_id => g_base_ledger_ids(Idx)
3073: );
3074: g_array_ledger_attrs.array_ledger_id(l_count) := g_base_ledger_ids(Idx);

Line 3076: xla_accounting_cache_pkg.GetValueChar(

3072: , p_target_ledger_id => g_base_ledger_ids(Idx)
3073: );
3074: g_array_ledger_attrs.array_ledger_id(l_count) := g_base_ledger_ids(Idx);
3075: g_array_ledger_attrs.array_ledger_currency_code(l_count):=
3076: xla_accounting_cache_pkg.GetValueChar(
3077: p_source_code => 'XLA_CURRENCY_CODE'
3078: , p_target_ledger_id => g_base_ledger_ids(Idx));
3079: g_array_ledger_attrs.array_mau(l_count):=
3080: xla_accounting_cache_pkg.GetValueNum(

Line 3080: xla_accounting_cache_pkg.GetValueNum(

3076: xla_accounting_cache_pkg.GetValueChar(
3077: p_source_code => 'XLA_CURRENCY_CODE'
3078: , p_target_ledger_id => g_base_ledger_ids(Idx));
3079: g_array_ledger_attrs.array_mau(l_count):=
3080: xla_accounting_cache_pkg.GetValueNum(
3081: p_source_code => 'XLA_CURRENCY_MAU'
3082: , p_target_ledger_id => g_base_ledger_ids(Idx));
3083: g_array_ledger_attrs.array_rounding_rule_code(l_count):=
3084: l_rounding_rule_code;

Line 3102: xla_accounting_cache_pkg.GetValueChar(

3098: FOR Idx1 IN g_alc_ledger_ids.FIRST .. g_alc_ledger_ids.LAST LOOP
3099: l_count:=l_count+1;
3100: g_array_ledger_attrs.array_ledger_id(l_count) := g_alc_ledger_ids(Idx1);
3101: g_array_ledger_attrs.array_ledger_currency_code(l_count):=
3102: xla_accounting_cache_pkg.GetValueChar(
3103: p_source_code => 'XLA_CURRENCY_CODE'
3104: , p_target_ledger_id => g_alc_ledger_ids(Idx1));
3105: g_array_ledger_attrs.array_mau(l_count):=
3106: xla_accounting_cache_pkg.GetValueNum(

Line 3106: xla_accounting_cache_pkg.GetValueNum(

3102: xla_accounting_cache_pkg.GetValueChar(
3103: p_source_code => 'XLA_CURRENCY_CODE'
3104: , p_target_ledger_id => g_alc_ledger_ids(Idx1));
3105: g_array_ledger_attrs.array_mau(l_count):=
3106: xla_accounting_cache_pkg.GetValueNum(
3107: p_source_code => 'XLA_CURRENCY_MAU'
3108: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
3109: );
3110: g_array_ledger_attrs.array_rounding_rule_code(l_count):= l_pri_rounding_rule_code;

Line 3114: xla_accounting_cache_pkg.GetValueChar(

3110: g_array_ledger_attrs.array_rounding_rule_code(l_count):= l_pri_rounding_rule_code;
3111: g_array_ledger_attrs.array_rounding_offset(l_count) := l_pri_rounding_offset;
3112: g_array_ledger_attrs.array_ledger_type(l_count) := 'ALC';
3113: g_array_ledger_attrs.array_default_rate_type(l_count) :=
3114: xla_accounting_cache_pkg.GetValueChar(
3115: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
3116: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
3117: );
3118: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=

Line 3119: xla_accounting_cache_pkg.GetValueChar(

3115: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
3116: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
3117: );
3118: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=
3119: xla_accounting_cache_pkg.GetValueChar(
3120: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
3121: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
3122: );
3123: g_array_ledger_attrs.array_max_roll_date(l_count) :=

Line 3124: xla_accounting_cache_pkg.GetValueNum(

3120: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
3121: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
3122: );
3123: g_array_ledger_attrs.array_max_roll_date(l_count) :=
3124: xla_accounting_cache_pkg.GetValueNum(
3125: p_source_code => 'XLA_MAX_DAYS_ROLL_RATE'
3126: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
3127: );
3128: END LOOP;

Line 3300: END xla_accounting_cache_pkg;

3296:
3297: IF NOT g_log_enabled THEN
3298: g_log_level := C_LEVEL_LOG_DISABLED;
3299: END IF;
3300: END xla_accounting_cache_pkg;