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.54.12010000.1 2008/07/29 09:58:50 appldev 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 275: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_accounting_cache_pkg';

271: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
272: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
273:
274: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
275: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_accounting_cache_pkg';
276:
277: --g_log_module VARCHAR2(240);
278: g_log_level NUMBER;
279: g_log_enabled BOOLEAN;

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

294: WHEN xla_exceptions_pkg.application_exception THEN
295: RAISE;
296: WHEN OTHERS THEN
297: xla_exceptions_pkg.raise_message
298: (p_location => 'xla_accounting_cache_pkg.trace');
299: END trace;
300:
301:
302: --=============================================================================

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

1226: ,p_value_1 => 'ERROR: Problem getting ledger information for application '||p_application_id||'. '||
1227: 'Subledger Accounting Options are not defined for this ledger and application.
1228: Please run Update Subledger Accounting Options program for your application.'
1229: ,p_token_2 => 'LOCATION'
1230: ,p_value_2 => 'xla_accounting_cache_pkg.load_application_ledgers');
1231: END IF;
1232: WHEN xla_exceptions_pkg.application_exception THEN
1233: RAISE;
1234: WHEN OTHERS THEN

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

2099: 'Subledger Accounting Options are not defined for the ledger and your application.'||
2100: 'Please run Update Subledger Accounting Options program for your application.'
2101:
2102: ,p_token_2 => 'LOCATION'
2103: ,p_value_2 => 'xla_accounting_cache_pkg.get_je_category');
2104:
2105: WHEN xla_exceptions_pkg.application_exception THEN
2106: RAISE;
2107: WHEN OTHERS THEN

Line 2547: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

2543: END IF;
2544:
2545: FOR Idx IN g_base_ledger_ids.FIRST .. g_base_ledger_ids.LAST LOOP
2546:
2547: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
2548: p_source_code => 'XLA_ROUNDING_RULE_CODE'
2549: , p_target_ledger_id => g_base_ledger_ids(Idx)
2550: );
2551: IF l_rounding_rule_code = 'NEAREST' THEN

Line 2564: xla_accounting_cache_pkg.GetValueChar(

2560:
2561: l_count:=l_count+1;
2562:
2563: g_array_ledger_attrs.array_default_rate_type(l_count) :=
2564: xla_accounting_cache_pkg.GetValueChar(
2565: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
2566: , p_target_ledger_id => g_base_ledger_ids(Idx)
2567: );
2568: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=

Line 2569: xla_accounting_cache_pkg.GetValueChar(

2565: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
2566: , p_target_ledger_id => g_base_ledger_ids(Idx)
2567: );
2568: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=
2569: xla_accounting_cache_pkg.GetValueChar(
2570: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
2571: , p_target_ledger_id => g_base_ledger_ids(Idx)
2572: );
2573: g_array_ledger_attrs.array_max_roll_date(l_count) :=

Line 2574: xla_accounting_cache_pkg.GetValueNum(

2570: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
2571: , p_target_ledger_id => g_base_ledger_ids(Idx)
2572: );
2573: g_array_ledger_attrs.array_max_roll_date(l_count) :=
2574: xla_accounting_cache_pkg.GetValueNum(
2575: p_source_code => 'XLA_MAX_DAYS_ROLL_RATE'
2576: , p_target_ledger_id => g_base_ledger_ids(Idx)
2577: );
2578: g_array_ledger_attrs.array_ledger_id(l_count) := g_base_ledger_ids(Idx);

Line 2580: xla_accounting_cache_pkg.GetValueChar(

2576: , p_target_ledger_id => g_base_ledger_ids(Idx)
2577: );
2578: g_array_ledger_attrs.array_ledger_id(l_count) := g_base_ledger_ids(Idx);
2579: g_array_ledger_attrs.array_ledger_currency_code(l_count):=
2580: xla_accounting_cache_pkg.GetValueChar(
2581: p_source_code => 'XLA_CURRENCY_CODE'
2582: , p_target_ledger_id => g_base_ledger_ids(Idx));
2583: g_array_ledger_attrs.array_mau(l_count):=
2584: xla_accounting_cache_pkg.GetValueNum(

Line 2584: xla_accounting_cache_pkg.GetValueNum(

2580: xla_accounting_cache_pkg.GetValueChar(
2581: p_source_code => 'XLA_CURRENCY_CODE'
2582: , p_target_ledger_id => g_base_ledger_ids(Idx));
2583: g_array_ledger_attrs.array_mau(l_count):=
2584: xla_accounting_cache_pkg.GetValueNum(
2585: p_source_code => 'XLA_CURRENCY_MAU'
2586: , p_target_ledger_id => g_base_ledger_ids(Idx));
2587: g_array_ledger_attrs.array_rounding_rule_code(l_count):=
2588: l_rounding_rule_code;

Line 2606: xla_accounting_cache_pkg.GetValueChar(

2602: FOR Idx1 IN g_alc_ledger_ids.FIRST .. g_alc_ledger_ids.LAST LOOP
2603: l_count:=l_count+1;
2604: g_array_ledger_attrs.array_ledger_id(l_count) := g_alc_ledger_ids(Idx1);
2605: g_array_ledger_attrs.array_ledger_currency_code(l_count):=
2606: xla_accounting_cache_pkg.GetValueChar(
2607: p_source_code => 'XLA_CURRENCY_CODE'
2608: , p_target_ledger_id => g_alc_ledger_ids(Idx1));
2609: g_array_ledger_attrs.array_mau(l_count):=
2610: xla_accounting_cache_pkg.GetValueNum(

Line 2610: xla_accounting_cache_pkg.GetValueNum(

2606: xla_accounting_cache_pkg.GetValueChar(
2607: p_source_code => 'XLA_CURRENCY_CODE'
2608: , p_target_ledger_id => g_alc_ledger_ids(Idx1));
2609: g_array_ledger_attrs.array_mau(l_count):=
2610: xla_accounting_cache_pkg.GetValueNum(
2611: p_source_code => 'XLA_CURRENCY_MAU'
2612: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
2613: );
2614: g_array_ledger_attrs.array_rounding_rule_code(l_count):= l_pri_rounding_rule_code;

Line 2618: xla_accounting_cache_pkg.GetValueChar(

2614: g_array_ledger_attrs.array_rounding_rule_code(l_count):= l_pri_rounding_rule_code;
2615: g_array_ledger_attrs.array_rounding_offset(l_count) := l_pri_rounding_offset;
2616: g_array_ledger_attrs.array_ledger_type(l_count) := 'ALC';
2617: g_array_ledger_attrs.array_default_rate_type(l_count) :=
2618: xla_accounting_cache_pkg.GetValueChar(
2619: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
2620: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
2621: );
2622: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=

Line 2623: xla_accounting_cache_pkg.GetValueChar(

2619: p_source_code => 'XLA_DEFAULT_CONV_RATE_TYPE'
2620: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
2621: );
2622: g_array_ledger_attrs.array_inhert_type_flag(l_count) :=
2623: xla_accounting_cache_pkg.GetValueChar(
2624: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
2625: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
2626: );
2627: g_array_ledger_attrs.array_max_roll_date(l_count) :=

Line 2628: xla_accounting_cache_pkg.GetValueNum(

2624: p_source_code => 'XLA_INHERIT_CONVERSION_TYPE'
2625: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
2626: );
2627: g_array_ledger_attrs.array_max_roll_date(l_count) :=
2628: xla_accounting_cache_pkg.GetValueNum(
2629: p_source_code => 'XLA_MAX_DAYS_ROLL_RATE'
2630: , p_target_ledger_id => g_alc_ledger_ids(Idx1)
2631: );
2632: END LOOP;

Line 2797: END xla_accounting_cache_pkg;

2793:
2794: IF NOT g_log_enabled THEN
2795: g_log_level := C_LEVEL_LOG_DISABLED;
2796: END IF;
2797: END xla_accounting_cache_pkg;