eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AE_LINES_PKG dependencies on XLA_ACCOUNTING_CACHE_PKG

Line 2091: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar

2087: 'XLA_OWNER_TYPE'
2088: ,p_adr_type_code
2089: )
2090: ,p_token_3 => 'LEDGER_NAME'
2091: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar
2092: (
2093: p_source_code => 'XLA_LEDGER_NAME'
2094: , p_target_ledger_id =>
2095: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

Line 2533: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar

2529: 'XLA_OWNER_TYPE'
2530: ,p_adr_type_code
2531: )
2532: ,p_token_3 => 'LEDGER_NAME'
2533: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar
2534: (
2535: p_source_code => 'XLA_LEDGER_NAME'
2536: , p_target_ledger_id =>
2537: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

Line 2576: l_coa_name := xla_accounting_cache_pkg.GetValueChar

2572: END CASE;
2573:
2574: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
2575:
2576: l_coa_name := xla_accounting_cache_pkg.GetValueChar
2577: (
2578: p_source_code => 'XLA_COA_NAME'
2579: , p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2580: );

Line 2707: l_coa_name := xla_accounting_cache_pkg.GetValueChar

2703: END CASE;
2704:
2705: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
2706:
2707: l_coa_name := xla_accounting_cache_pkg.GetValueChar
2708: (
2709: p_source_code => 'XLA_COA_NAME'
2710: , p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2711: );

Line 3037: IF (xla_accounting_cache_pkg.GetValueChar('XLA_ALC_ENABLED_FLAG')='N') THEN

3033: ,p_module => l_log_module);
3034: END IF;
3035:
3036: IF l_ledger_category_code = 'ALC' THEN
3037: IF (xla_accounting_cache_pkg.GetValueChar('XLA_ALC_ENABLED_FLAG')='N') THEN
3038: l_ledger_category_code :='PRIMARY';
3039: END IF;
3040: END IF;
3041:

Line 4187: l_ledger_attrs XLA_ACCOUNTING_CACHE_PKG.t_array_ledger_attrs; --7135700

4183:
4184: l_array_gl_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_date; -- 5189664
4185:
4186: l_default_switch_side_flag CHAR(1);
4187: l_ledger_attrs XLA_ACCOUNTING_CACHE_PKG.t_array_ledger_attrs; --7135700
4188: l_upgrade_check NUMBER DEFAULT 0; --7135700
4189: l_primary_ledger_id NUMBER; --7135700
4190: l_max_first_open_period DATE DEFAULT NULL; --7135700
4191: l_min_ref_event_date DATE DEFAULT NULL; --7135700

Line 4215: l_application_id := xla_accounting_cache_pkg.getvaluenum('XLA_EVENT_APPL_ID');

4211: ,p_level => C_LEVEL_STATEMENT
4212: ,p_module => l_log_module);
4213: END IF;
4214:
4215: l_application_id := xla_accounting_cache_pkg.getvaluenum('XLA_EVENT_APPL_ID');
4216:
4217: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4218: trace
4219: (p_msg => 'Application ID ='||to_char(l_application_id)

Line 5981: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);

5977: -- Note: This code may not, or may unnessecarily throw this warning for cash basis secondary legders also,
5978: -- that case has not been considered
5979:
5980: l_upgrade_check := 0;
5981: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);
5982:
5983: FOR i in 1..l_ledger_attrs.array_ledger_id.COUNT
5984: LOOP
5985: IF l_ledger_attrs.array_ledger_type(i) = 'PRIMARY' THEN

Line 7510: xla_accounting_cache_pkg.g_reversal_error := TRUE;

7506: l_error_count := l_error_count + 1;
7507: END LOOP;
7508:
7509: IF l_error_count > 0 THEN
7510: xla_accounting_cache_pkg.g_reversal_error := TRUE;
7511: END IF;
7512:
7513: IF l_error_count = 0 THEN
7514: print_logfile('-------NO SUCH EVENTS-----------');

Line 8191: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(p_rec_acct_attrs.array_char_value(i));

8187:
8188: WHEN 'ENTERED_CURRENCY_CODE' THEN
8189: IF p_rec_acct_attrs.array_char_value.EXISTS(i) AND length(p_rec_acct_attrs.array_char_value(i)) <= 15 THEN
8190: g_rec_lines.array_currency_code(g_LineNumber) := p_rec_acct_attrs.array_char_value(i);
8191: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(p_rec_acct_attrs.array_char_value(i));
8192: ELSE
8193: -- 5162408
8194: g_rec_lines.array_currency_code(g_LineNumber) := ' '; -- otherwise insert NULL error in currency_code
8195: g_rec_lines.array_currency_mau(g_LineNumber) := 0.01; -- dummy MAU

Line 9133: IF xla_accounting_cache_pkg.GetValueChar

9129: ,p_level => C_LEVEL_STATEMENT
9130: ,p_module => l_log_module);
9131: END IF;
9132:
9133: IF xla_accounting_cache_pkg.GetValueChar
9134: (p_source_code => 'LEDGER_CATEGORY_CODE'
9135: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('SECONDARY')
9136: OR (NVL(l_actual_upg_option,'N') = 'N' OR NVL(l_enc_upg_option,'N') = 'N')
9137: THEN

Line 9205: IF xla_accounting_cache_pkg.GetValueChar

9201: END IF;
9202: END IF;
9203:
9204:
9205: IF xla_accounting_cache_pkg.GetValueChar
9206: (p_source_code => 'LEDGER_CATEGORY_CODE'
9207: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
9208: AND (NVL(l_actual_upg_option,'N') = 'Y')
9209: THEN

Line 9269: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));

9265: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9266: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9267:
9268: g_rec_lines.array_currency_mau(g_LineNumber) :=
9269: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9270:
9271: xla_ae_lines_pkg.set_ccid(
9272: p_code_combination_id => l_actual_upg_dr_ccid
9273: , p_value_type_code => 'S' --l_adr_value_type_code

Line 9346: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));

9342: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9343: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9344:
9345: g_rec_lines.array_currency_mau(g_LineNumber) :=
9346: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9347:
9348: xla_ae_lines_pkg.set_ccid(
9349: p_code_combination_id => l_actual_upg_cr_ccid
9350: , p_value_type_code => 'S' --l_adr_value_type_code

Line 9374: IF xla_accounting_cache_pkg.GetValueChar

9370: -- g_rec_lines.array_reversal_code(g_LineNumber) := 'DUMMY_LR_ERROR';
9371: -- END IF;
9372: END IF;
9373:
9374: IF xla_accounting_cache_pkg.GetValueChar
9375: (p_source_code => 'LEDGER_CATEGORY_CODE'
9376: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
9377: AND (l_enc_upg_option = 'Y')
9378: THEN

Line 9437: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));

9433: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9434: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9435:
9436: g_rec_lines.array_currency_mau(g_LineNumber) :=
9437: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9438:
9439: xla_ae_lines_pkg.set_ccid(
9440: p_code_combination_id => l_enc_upg_dr_ccid
9441: , p_value_type_code => 'S' --l_adr_value_type_code

Line 9515: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));

9511: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9512: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9513:
9514: g_rec_lines.array_currency_mau(g_LineNumber) :=
9515: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9516:
9517: xla_ae_lines_pkg.set_ccid(
9518: p_code_combination_id => l_enc_upg_cr_ccid
9519: , p_value_type_code => 'S' --l_adr_value_type_code

Line 9618: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;

9614:
9615: PROCEDURE CalculateUnroundedAmounts
9616: is
9617: l_log_module VARCHAR2(240);
9618: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
9619: l_ledger_attrs1 xla_accounting_cache_pkg.t_array_ledger_attrs;
9620: l_primary_ledger_currency VARCHAR2(30):=null;
9621: l_primary_ledger_id NUMBER;
9622: l_secondary_ledger_currency VARCHAR2(30);

Line 9619: l_ledger_attrs1 xla_accounting_cache_pkg.t_array_ledger_attrs;

9615: PROCEDURE CalculateUnroundedAmounts
9616: is
9617: l_log_module VARCHAR2(240);
9618: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
9619: l_ledger_attrs1 xla_accounting_cache_pkg.t_array_ledger_attrs;
9620: l_primary_ledger_currency VARCHAR2(30):=null;
9621: l_primary_ledger_id NUMBER;
9622: l_secondary_ledger_currency VARCHAR2(30);
9623: l_secondary_ledger_id NUMBER;

Line 9718: xla_accounting_cache_pkg.BuildLedgerArray(l_ledger_attrs1);

9714: END IF;
9715:
9716: l_euro :='EUR';
9717:
9718: xla_accounting_cache_pkg.BuildLedgerArray(l_ledger_attrs1);
9719:
9720: l_max_ledger_index := l_ledger_attrs1.array_ledger_id.COUNT;
9721: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
9722: trace

Line 10731: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;

10727:
10728: PROCEDURE CalculateGainLossAmounts
10729: is
10730: l_log_module VARCHAR2(240);
10731: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
10732: l_ledger_currency xla_accounting_cache_pkg.t_array_varchar;
10733: --l_primary_ledger_id NUMBER;
10734: l_temp number;
10735:

Line 10732: l_ledger_currency xla_accounting_cache_pkg.t_array_varchar;

10728: PROCEDURE CalculateGainLossAmounts
10729: is
10730: l_log_module VARCHAR2(240);
10731: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
10732: l_ledger_currency xla_accounting_cache_pkg.t_array_varchar;
10733: --l_primary_ledger_id NUMBER;
10734: l_temp number;
10735:
10736: l_array_accounted_amount t_array_number;

Line 10799: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);

10795: ,p_module => l_log_module);
10796: END IF;
10797:
10798: /*
10799: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);
10800: For i in 1..l_ledger_attrs.array_ledger_id.COUNT LOOP
10801: l_ledger_currency(l_ledger_attrs.array_ledger_id(i)) := l_ledger_attrs.array_ledger_currency_code(i);
10802: END LOOP;
10803: */

Line 11040: l_ledger_ccy := xla_accounting_cache_pkg.GetValueChar(

11036: -------------------------------------------------
11037: -- Reset values for certain fields in g_rec_lines
11038: -------------------------------------------------
11039: /* 4482069 This will be set in xla_cmp_acct_line_type_pkg.GetAccountingSources
11040: l_ledger_ccy := xla_accounting_cache_pkg.GetValueChar(
11041: p_source_code => 'XLA_CURRENCY_CODE'
11042: ,p_target_ledger_id=> g_rec_lines.array_ledger_id(g_LineNumber));
11043: g_rec_lines.array_currency_code(g_LineNumber) := l_ledger_ccy;
11044: */

Line 11046: --g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(l_ledger_ccy);

11042: ,p_target_ledger_id=> g_rec_lines.array_ledger_id(g_LineNumber));
11043: g_rec_lines.array_currency_code(g_LineNumber) := l_ledger_ccy;
11044: */
11045:
11046: --g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(l_ledger_ccy);
11047: g_rec_lines.array_curr_conversion_date(g_LineNumber) := NULL;
11048: g_rec_lines.array_curr_conversion_rate(g_LineNumber) := NULL;
11049: g_rec_lines.array_curr_conversion_type(g_LineNumber) := NULL;
11050: g_rec_lines.array_party_type_code(g_LineNumber) := NULL;

Line 11164: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11160: ,(NVL(xal.merge_code_combination_id,xal.code_combination_id)) code_combination_id
11161: ,(DECODE(xalg.inherit_desc_flag, 'Y', xal.description, xalg.description)) description
11162: ,(xal.currency_code) currency_code
11163: ,(DECODE(xal.currency_code
11164: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11165: ,NULL
11166: ,xal.currency_conversion_rate)) currency_conversion_rate
11167: ,(DECODE(xal.currency_code
11168: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

Line 11168: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11164: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11165: ,NULL
11166: ,xal.currency_conversion_rate)) currency_conversion_rate
11167: ,(DECODE(xal.currency_code
11168: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11169: ,NULL
11170: ,xal.currency_conversion_type)) currency_conversion_type
11171: ,(DECODE(xal.currency_code
11172: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

Line 11172: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11168: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11169: ,NULL
11170: ,xal.currency_conversion_type)) currency_conversion_type
11171: ,(DECODE(xal.currency_code
11172: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11173: ,NULL
11174: ,xal.currency_conversion_date)) currency_conversion_date
11175: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau
11176: ,(DECODE(xdl.calculate_acctd_amts_flag

Line 11175: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau

11171: ,(DECODE(xal.currency_code
11172: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11173: ,NULL
11174: ,xal.currency_conversion_date)) currency_conversion_date
11175: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau
11176: ,(DECODE(xdl.calculate_acctd_amts_flag
11177: ,'N', DECODE(xalg.currency_code
11178: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11179: ,NVL(xalg.unrounded_accounted_cr,xalg.unrounded_entered_cr)

Line 11178: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11174: ,xal.currency_conversion_date)) currency_conversion_date
11175: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau
11176: ,(DECODE(xdl.calculate_acctd_amts_flag
11177: ,'N', DECODE(xalg.currency_code
11178: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11179: ,NVL(xalg.unrounded_accounted_cr,xalg.unrounded_entered_cr)
11180: ,xalg.unrounded_entered_cr)
11181: ,xalg.unrounded_entered_cr) ) unrounded_entered_cr
11182: ,(DECODE(xdl.calculate_acctd_amts_flag

Line 11184: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11180: ,xalg.unrounded_entered_cr)
11181: ,xalg.unrounded_entered_cr) ) unrounded_entered_cr
11182: ,(DECODE(xdl.calculate_acctd_amts_flag
11183: ,'N', DECODE(xalg.currency_code
11184: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11185: ,NVL(xalg.unrounded_accounted_dr,xalg.unrounded_entered_dr)
11186: ,xalg.unrounded_entered_dr)
11187: ,xalg.unrounded_entered_dr)) unrounded_entered_dr
11188: ,(xal.party_type_code) party_type_code

Line 11251: -- AND xte.ledger_id = DECODE(xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG'),

11247: -- AND xlr.ledger_id = xgl.ledger_id
11248: AND xte.application_id = xalg.bflow_application_id
11249: AND xte.entity_code = xalg.bflow_entity_code
11250: AND xte.ledger_id = p_ledger_id
11251: -- AND xte.ledger_id = DECODE(xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG'),
11252: -- 'N', xlr.primary_ledger_id,
11253: -- DECODE(xlr.ledger_category_code
11254: -- ,'ALC', xlr.primary_ledger_id
11255: -- ,DECODE(NVL(xlo.capture_event_flag,'N'),'N',xlr.primary_ledger_id

Line 11412: (p_msg => 'method = '||xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG')

11408: (p_msg => 'p_bc_mode = '||p_bc_mode
11409: ,p_level => C_LEVEL_PROCEDURE
11410: ,p_module => l_log_module);
11411: trace
11412: (p_msg => 'method = '||xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG')
11413: ,p_level => C_LEVEL_PROCEDURE
11414: ,p_module => l_log_module);
11415: trace
11416: (p_msg => 'g_mpa_accrual_exists = '||xla_accounting_pkg.g_mpa_accrual_exists

Line 11583: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11579: (SELECT MIN(NVL(xal3.merge_code_combination_id,xal3.code_combination_id)) -- 4967526
11580: ,MIN(DECODE(xalg.inherit_desc_flag, 'Y', xal3.description, xalg.description))
11581: ,MIN(xal3.currency_code)
11582: ,MIN(DECODE(xal3.currency_code
11583: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11584: ,NULL
11585: ,xal3.currency_conversion_rate))
11586: ,MIN(DECODE(xal3.currency_code
11587: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

Line 11587: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11583: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11584: ,NULL
11585: ,xal3.currency_conversion_rate))
11586: ,MIN(DECODE(xal3.currency_code
11587: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11588: ,NULL
11589: ,xal3.currency_conversion_type))
11590: ,MIN(DECODE(xal3.currency_code
11591: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

Line 11591: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11587: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11588: ,NULL
11589: ,xal3.currency_conversion_type))
11590: ,MIN(DECODE(xal3.currency_code
11591: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11592: ,NULL
11593: ,xal3.currency_conversion_date))
11594: ---------------------------------------------------------------------------
11595: -- 4482069 error XLA_AP_INVALID_AMT_BASE

Line 11600: ,MIN(xla_accounting_cache_pkg.GetCurrencyMau(xal3.currency_code))

11596: -- Occurs when upstream is invalid so c_bflow_valid_lines
11597: -- is not found hence entered amounts will not calc.
11598: -- Upstream invalid need not prevent this value to be assigned.
11599: ---------------------------------------------------------------------------
11600: ,MIN(xla_accounting_cache_pkg.GetCurrencyMau(xal3.currency_code))
11601: ---------------------------------------------------------------------------
11602: -- 4482069 based on calculate_acctd_amts_flag and transaction currency
11603: -- Note: In theory, when calculate_acctd_amts_flag is 'No', entered and
11604: -- accounted amt should be the same (therefore we need not recalc

Line 11610: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11606: -- make sure they will be the same.
11607: ---------------------------------------------------------------------------
11608: ,MIN(DECODE(calculate_acctd_amts_flag
11609: ,'N', DECODE(xalg.currency_code
11610: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11611: ,NVL(xalg.unrounded_accounted_cr,xalg.unrounded_entered_cr)
11612: ,xalg.unrounded_entered_cr)
11613: ,xalg.unrounded_entered_cr) )
11614: ---------------------------------------------------------------------------

Line 11619: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

11615: -- 4482069 based on calculate_acctd_amts_flag and transaction currency
11616: ---------------------------------------------------------------------------
11617: ,MIN(DECODE(calculate_acctd_amts_flag
11618: ,'N', DECODE(xalg.currency_code
11619: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11620: ,NVL(xalg.unrounded_accounted_dr,xalg.unrounded_entered_dr)
11621: ,xalg.unrounded_entered_dr)
11622: ,xalg.unrounded_entered_dr))
11623: ,MIN(xal3.party_type_code)

Line 11683: AND xte.ledger_id = DECODE(xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG'),

11679: WHERE xgl.ledger_id = xalg.ledger_id -- 4478604
11680: AND xlr.ledger_id = xgl.ledger_id -- 4478604
11681: AND xte.application_id = xalg.bflow_application_id
11682: AND xte.entity_code = xalg.bflow_entity_code
11683: AND xte.ledger_id = DECODE(xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG'),
11684: 'N', xlr.primary_ledger_id,
11685: DECODE(xlr.ledger_category_code
11686: ,'ALC', xlr.primary_ledger_id
11687: ,DECODE(NVL(xlo.capture_event_flag,'N'),'N',xlr.primary_ledger_id

Line 11827: entered_currency_mau = xla_accounting_cache_pkg.GetCurrencyMau(temp_currency_code),

11823: FROM xla_ae_lines xal
11824: WHERE xal.application_id = xalg.bflow_application_id
11825: AND xal.ae_header_id = xalg.temp_ref_ae_header_id
11826: AND xal.ae_line_num = xalg.ref_ae_line_num),
11827: entered_currency_mau = xla_accounting_cache_pkg.GetCurrencyMau(temp_currency_code),
11828: (segment1, segment2, segment3, segment4, segment5, segment6, segment7, segment8, segment9, segment10
11829: ,segment11, segment12, segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20
11830: ,segment21, segment22, segment23, segment24, segment25, segment26, segment27, segment28, segment29, segment30) =
11831: (SELECT gcc.segment1, gcc.segment2, gcc.segment3, gcc.segment4, gcc.segment5

Line 12331: xla_accounting_cache_pkg.g_hist_bflow_error_exists := TRUE;

12327:
12328: ELSE
12329: l_array_bflow_historic (i) :='Y'; -- This line belongs to historic upgraded data.
12330: l_array_hist_bflow_err(l_array_event_id(i)) :=1;
12331: xla_accounting_cache_pkg.g_hist_bflow_error_exists := TRUE;
12332: END IF;
12333:
12334: END IF; -- for secondary
12335: END IF; -- 5132302

Line 13406: l_app_name := xla_accounting_cache_pkg.GetSessionValueChar('XLA_EVENT_APPL_NAME');

13402: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
13403:
13404: ELSE
13405:
13406: l_app_name := xla_accounting_cache_pkg.GetSessionValueChar('XLA_EVENT_APPL_NAME');
13407:
13408: ---------------------------------------------------------------------
13409: -- Verify applied-to system transaction ids
13410: ---------------------------------------------------------------------

Line 13700: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));

13696: g_rec_lines.array_entered_cr(g_LineNumber) := g_rec_lines.array_entered_cr(p_line_num);
13697: g_rec_lines.array_accounted_dr(g_LineNumber) := g_rec_lines.array_accounted_dr(p_line_num);
13698: g_rec_lines.array_accounted_cr(g_LineNumber) := g_rec_lines.array_accounted_cr(p_line_num);
13699: g_rec_lines.array_currency_code(g_LineNumber) := g_rec_lines.array_currency_code(p_line_num);
13700: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
13701: g_rec_lines.array_curr_conversion_date(g_LineNumber) := g_rec_lines.array_curr_conversion_date(p_line_num);
13702: g_rec_lines.array_curr_conversion_rate(g_LineNumber) := g_rec_lines.array_curr_conversion_rate(p_line_num);
13703: g_rec_lines.array_curr_conversion_type(g_LineNumber) := g_rec_lines.array_curr_conversion_type(p_line_num);
13704: g_rec_lines.array_description(g_LineNumber) := g_rec_lines.array_description(p_line_num);

Line 14562: g_application_id := xla_accounting_cache_pkg.GetValueNum('XLA_EVENT_APPL_ID');

14558: -- *********** Initialization routine **********
14559: --=============================================================================
14560:
14561: BEGIN
14562: g_application_id := xla_accounting_cache_pkg.GetValueNum('XLA_EVENT_APPL_ID');
14563:
14564: ----------------------------------------
14565: -- 4219869 Init Business Flow counts
14566: ----------------------------------------