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 819: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code = xla_accounting_cache_pkg.g_primary_ledger_currency and

815: ALC, the calculate amts flag is set to 'N'
816: */
817: -- Bug 13636827 (14105252)
818: if(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code = 'ALC' and
819: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code = xla_accounting_cache_pkg.g_primary_ledger_currency and
820: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='N') then
821: g_rec_lines.array_calculate_acctd_flag(g_LineNumber) := 'N';
822: g_rec_lines.array_calculate_g_l_flag(g_LineNumber) := 'N';
823: elsif(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code = 'ALC' and

Line 824: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code = xla_accounting_cache_pkg.g_primary_ledger_currency and XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y') then

820: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='N') then
821: g_rec_lines.array_calculate_acctd_flag(g_LineNumber) := 'N';
822: g_rec_lines.array_calculate_g_l_flag(g_LineNumber) := 'N';
823: elsif(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code = 'ALC' and
824: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code = xla_accounting_cache_pkg.g_primary_ledger_currency and XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y') then
825: g_rec_lines.array_calculate_acctd_flag(g_LineNumber) := 'Y';
826: g_rec_lines.array_calculate_g_l_flag(g_LineNumber) := 'Y'; --Bug 13636827 (14105252)
827: elsIF((XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code = 'SECONDARY' or
828: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code = 'ALC') and

Line 2179: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar

2175: 'XLA_OWNER_TYPE'
2176: ,p_adr_type_code
2177: )
2178: ,p_token_3 => 'LEDGER_NAME'
2179: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar
2180: (
2181: p_source_code => 'XLA_LEDGER_NAME'
2182: , p_target_ledger_id =>
2183: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

Line 2621: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar

2617: 'XLA_OWNER_TYPE'
2618: ,p_adr_type_code
2619: )
2620: ,p_token_3 => 'LEDGER_NAME'
2621: ,p_value_3 => xla_accounting_cache_pkg.GetValueChar
2622: (
2623: p_source_code => 'XLA_LEDGER_NAME'
2624: , p_target_ledger_id =>
2625: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

Line 2664: l_coa_name := xla_accounting_cache_pkg.GetValueChar

2660: END CASE;
2661:
2662: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
2663:
2664: l_coa_name := xla_accounting_cache_pkg.GetValueChar
2665: (
2666: p_source_code => 'XLA_COA_NAME'
2667: , p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2668: );

Line 2795: l_coa_name := xla_accounting_cache_pkg.GetValueChar

2791: END CASE;
2792:
2793: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
2794:
2795: l_coa_name := xla_accounting_cache_pkg.GetValueChar
2796: (
2797: p_source_code => 'XLA_COA_NAME'
2798: , p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2799: );

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

3121: ,p_module => l_log_module);
3122: END IF;
3123:
3124: IF l_ledger_category_code = 'ALC' THEN
3125: IF (xla_accounting_cache_pkg.GetValueChar('XLA_ALC_ENABLED_FLAG')='N') THEN
3126: l_ledger_category_code :='PRIMARY';
3127: END IF;
3128: END IF;
3129:

Line 4285: l_ledger_attrs XLA_ACCOUNTING_CACHE_PKG.t_array_ledger_attrs; --7135700

4281: l_array_gl_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_date; -- 5189664
4282: l_array_accounting_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_date; -- 8505463
4283:
4284: l_default_switch_side_flag CHAR(1);
4285: l_ledger_attrs XLA_ACCOUNTING_CACHE_PKG.t_array_ledger_attrs; --7135700
4286: l_upgrade_check NUMBER DEFAULT 0; --7135700
4287: l_primary_ledger_id NUMBER; --7135700
4288: l_max_first_open_period DATE DEFAULT NULL; --7135700
4289: l_min_ref_event_date DATE DEFAULT NULL; --7135700

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

4309: ,p_level => C_LEVEL_STATEMENT
4310: ,p_module => l_log_module);
4311: END IF;
4312:
4313: l_application_id := xla_accounting_cache_pkg.getvaluenum('XLA_EVENT_APPL_ID');
4314:
4315: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4316: trace
4317: (p_msg => 'Application ID ='||to_char(l_application_id)

Line 6113: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);

6109: -- Note: This code may not, or may unnessecarily throw this warning for cash basis secondary legders also,
6110: -- that case has not been considered
6111:
6112: l_upgrade_check := 0;
6113: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);
6114:
6115: FOR i in 1..l_ledger_attrs.array_ledger_id.COUNT
6116: LOOP
6117: IF l_ledger_attrs.array_ledger_type(i) = 'PRIMARY' THEN

Line 7922: xla_accounting_cache_pkg.g_reversal_error := TRUE;

7918: l_error_count := l_error_count + 1;
7919: END LOOP;
7920:
7921: IF l_error_count > 0 THEN
7922: xla_accounting_cache_pkg.g_reversal_error := TRUE;
7923: --added bug 11687439
7924: print_logfile('***************************************************************************************************');
7925: -- end bug 11687439
7926: END IF;

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

8605:
8606: WHEN 'ENTERED_CURRENCY_CODE' THEN
8607: IF p_rec_acct_attrs.array_char_value.EXISTS(i) AND length(p_rec_acct_attrs.array_char_value(i)) <= 15 THEN
8608: g_rec_lines.array_currency_code(g_LineNumber) := p_rec_acct_attrs.array_char_value(i);
8609: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(p_rec_acct_attrs.array_char_value(i));
8610: ELSE
8611: -- 5162408
8612: g_rec_lines.array_currency_code(g_LineNumber) := ' '; -- otherwise insert NULL error in currency_code
8613: g_rec_lines.array_currency_mau(g_LineNumber) := 0.01; -- dummy MAU

Line 8765: AND xla_accounting_cache_pkg.g_primary_ledger_currency <> XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code

8761: END IF;
8762: -- Bug 7044870
8763: -- Bug 8238617 set g_override_acctd_amt_flag to null only if the currency_code of secondary,ALC is different from primary
8764: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code IN ('SECONDARY','ALC')
8765: AND xla_accounting_cache_pkg.g_primary_ledger_currency <> XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code
8766: THEN
8767: g_override_acctd_amt_flag := NULL;
8768: g_rec_lines.array_override_acctd_amt_flag(g_LineNumber) := NULL;
8769: END IF;

Line 8774: (p_msg => 'g_primary_ledger_currency : ' || xla_accounting_cache_pkg.g_primary_ledger_currency

8770: --
8771:
8772: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
8773: trace
8774: (p_msg => 'g_primary_ledger_currency : ' || xla_accounting_cache_pkg.g_primary_ledger_currency
8775: || 'Secondary Ledger Currency code : '|| XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.currency_code
8776: || 'g_override_acctd_amt_flag : ' || g_override_acctd_amt_flag
8777: ,p_level => C_LEVEL_STATEMENT
8778: ,p_module => l_log_module);

Line 9564: IF xla_accounting_cache_pkg.GetValueChar

9560: ,p_level => C_LEVEL_STATEMENT
9561: ,p_module => l_log_module);
9562: END IF;
9563:
9564: IF xla_accounting_cache_pkg.GetValueChar
9565: (p_source_code => 'LEDGER_CATEGORY_CODE'
9566: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('SECONDARY')
9567: OR (NVL(l_actual_upg_option,'N') = 'N' OR NVL(l_enc_upg_option,'N') = 'N')
9568: THEN

Line 9636: IF xla_accounting_cache_pkg.GetValueChar

9632: END IF;
9633: END IF;
9634:
9635:
9636: IF xla_accounting_cache_pkg.GetValueChar
9637: (p_source_code => 'LEDGER_CATEGORY_CODE'
9638: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
9639: AND (NVL(l_actual_upg_option,'N') = 'Y')
9640: THEN

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

9696: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9697: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9698:
9699: g_rec_lines.array_currency_mau(g_LineNumber) :=
9700: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9701:
9702: xla_ae_lines_pkg.set_ccid(
9703: p_code_combination_id => l_actual_upg_dr_ccid
9704: , p_value_type_code => 'S' --l_adr_value_type_code

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

9773: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9774: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9775:
9776: g_rec_lines.array_currency_mau(g_LineNumber) :=
9777: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9778:
9779: xla_ae_lines_pkg.set_ccid(
9780: p_code_combination_id => l_actual_upg_cr_ccid
9781: , p_value_type_code => 'S' --l_adr_value_type_code

Line 9805: IF xla_accounting_cache_pkg.GetValueChar

9801: -- g_rec_lines.array_reversal_code(g_LineNumber) := 'DUMMY_LR_ERROR';
9802: -- END IF;
9803: END IF;
9804:
9805: IF xla_accounting_cache_pkg.GetValueChar
9806: (p_source_code => 'LEDGER_CATEGORY_CODE'
9807: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
9808: AND (l_enc_upg_option = 'Y')
9809: THEN

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

9864: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9865: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9866:
9867: g_rec_lines.array_currency_mau(g_LineNumber) :=
9868: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9869:
9870: xla_ae_lines_pkg.set_ccid(
9871: p_code_combination_id => l_enc_upg_dr_ccid
9872: , p_value_type_code => 'S' --l_adr_value_type_code

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

9942: g_rec_lines.array_merge_duplicate_code(g_LineNumber) := 'N';
9943: g_rec_lines.array_gl_transfer_mode(g_LineNumber) := 'S';
9944:
9945: g_rec_lines.array_currency_mau(g_LineNumber) :=
9946: xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
9947:
9948: xla_ae_lines_pkg.set_ccid(
9949: p_code_combination_id => l_enc_upg_cr_ccid
9950: , p_value_type_code => 'S' --l_adr_value_type_code

Line 10049: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;

10045:
10046: PROCEDURE CalculateUnroundedAmounts
10047: is
10048: l_log_module VARCHAR2(240);
10049: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
10050: l_ledger_attrs1 xla_accounting_cache_pkg.t_array_ledger_attrs;
10051: l_primary_ledger_currency VARCHAR2(30):=null;
10052: l_primary_ledger_id NUMBER;
10053: l_secondary_ledger_currency VARCHAR2(30);

Line 10050: l_ledger_attrs1 xla_accounting_cache_pkg.t_array_ledger_attrs;

10046: PROCEDURE CalculateUnroundedAmounts
10047: is
10048: l_log_module VARCHAR2(240);
10049: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
10050: l_ledger_attrs1 xla_accounting_cache_pkg.t_array_ledger_attrs;
10051: l_primary_ledger_currency VARCHAR2(30):=null;
10052: l_primary_ledger_id NUMBER;
10053: l_secondary_ledger_currency VARCHAR2(30);
10054: l_secondary_ledger_id NUMBER;

Line 10149: xla_accounting_cache_pkg.BuildLedgerArray(l_ledger_attrs1);

10145: END IF;
10146:
10147: l_euro :='EUR';
10148:
10149: xla_accounting_cache_pkg.BuildLedgerArray(l_ledger_attrs1);
10150:
10151: l_max_ledger_index := l_ledger_attrs1.array_ledger_id.COUNT;
10152: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
10153: trace

Line 11170: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;

11166:
11167: PROCEDURE CalculateGainLossAmounts
11168: is
11169: l_log_module VARCHAR2(240);
11170: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
11171: l_ledger_currency xla_accounting_cache_pkg.t_array_varchar;
11172: --l_primary_ledger_id NUMBER;
11173: l_temp number;
11174:

Line 11171: l_ledger_currency xla_accounting_cache_pkg.t_array_varchar;

11167: PROCEDURE CalculateGainLossAmounts
11168: is
11169: l_log_module VARCHAR2(240);
11170: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
11171: l_ledger_currency xla_accounting_cache_pkg.t_array_varchar;
11172: --l_primary_ledger_id NUMBER;
11173: l_temp number;
11174:
11175: l_array_accounted_amount t_array_number;

Line 11437: l_ledger_ccy := xla_accounting_cache_pkg.GetValueChar(

11433: -------------------------------------------------
11434: -- Reset values for certain fields in g_rec_lines
11435: -------------------------------------------------
11436: /* 4482069 This will be set in xla_cmp_acct_line_type_pkg.GetAccountingSources
11437: l_ledger_ccy := xla_accounting_cache_pkg.GetValueChar(
11438: p_source_code => 'XLA_CURRENCY_CODE'
11439: ,p_target_ledger_id=> g_rec_lines.array_ledger_id(g_LineNumber));
11440: g_rec_lines.array_currency_code(g_LineNumber) := l_ledger_ccy;
11441: */

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

11439: ,p_target_ledger_id=> g_rec_lines.array_ledger_id(g_LineNumber));
11440: g_rec_lines.array_currency_code(g_LineNumber) := l_ledger_ccy;
11441: */
11442:
11443: --g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(l_ledger_ccy);
11444: g_rec_lines.array_curr_conversion_date(g_LineNumber) := NULL;
11445: g_rec_lines.array_curr_conversion_rate(g_LineNumber) := NULL;
11446: g_rec_lines.array_curr_conversion_type(g_LineNumber) := NULL;
11447: g_rec_lines.array_party_type_code(g_LineNumber) := NULL;

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

11564: ,(NVL(xal.merge_code_combination_id,xal.code_combination_id)) code_combination_id
11565: ,(DECODE(xalg.inherit_desc_flag, 'Y', xal.description, xalg.description)) description
11566: ,(xal.currency_code) currency_code
11567: ,(DECODE(xal.currency_code
11568: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11569: ,NULL
11570: ,xal.currency_conversion_rate)) currency_conversion_rate
11571: ,(DECODE(xal.currency_code
11572: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

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

11568: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11569: ,NULL
11570: ,xal.currency_conversion_rate)) currency_conversion_rate
11571: ,(DECODE(xal.currency_code
11572: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11573: ,NULL
11574: ,xal.currency_conversion_type)) currency_conversion_type
11575: ,(DECODE(xal.currency_code
11576: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

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

11572: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11573: ,NULL
11574: ,xal.currency_conversion_type)) currency_conversion_type
11575: ,(DECODE(xal.currency_code
11576: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11577: ,NULL
11578: ,xal.currency_conversion_date)) currency_conversion_date
11579: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau
11580: ,(DECODE(xdl.calculate_acctd_amts_flag

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

11575: ,(DECODE(xal.currency_code
11576: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11577: ,NULL
11578: ,xal.currency_conversion_date)) currency_conversion_date
11579: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau
11580: ,(DECODE(xdl.calculate_acctd_amts_flag
11581: ,'N', DECODE(xalg.currency_code
11582: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11583: ,NVL(xalg.unrounded_accounted_cr,xalg.unrounded_entered_cr)

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

11578: ,xal.currency_conversion_date)) currency_conversion_date
11579: ,(xla_accounting_cache_pkg.GetCurrencyMau(xal.currency_code)) entered_currency_mau
11580: ,(DECODE(xdl.calculate_acctd_amts_flag
11581: ,'N', DECODE(xalg.currency_code
11582: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11583: ,NVL(xalg.unrounded_accounted_cr,xalg.unrounded_entered_cr)
11584: ,xalg.unrounded_entered_cr)
11585: ,xalg.unrounded_entered_cr) ) unrounded_entered_cr
11586: ,(DECODE(xdl.calculate_acctd_amts_flag

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

11584: ,xalg.unrounded_entered_cr)
11585: ,xalg.unrounded_entered_cr) ) unrounded_entered_cr
11586: ,(DECODE(xdl.calculate_acctd_amts_flag
11587: ,'N', DECODE(xalg.currency_code
11588: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11589: ,NVL(xalg.unrounded_accounted_dr,xalg.unrounded_entered_dr)
11590: ,xalg.unrounded_entered_dr)
11591: ,xalg.unrounded_entered_dr)) unrounded_entered_dr
11592: ,(xal.party_type_code) party_type_code

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

11602: DECODE(xalg.bflow_applied_to_amount, NULL, 'X', xah.accounting_entry_status_code))) bflow_prior_entry_status_code
11603: ,(xah.entity_id) applied_to_entity_id
11604: --Added for 9352035
11605: ,(DECODE(xal.currency_code
11606: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
11607: ,NULL
11608: ,DECODE (xdl.unrounded_accounted_dr,NULL
11609: ,CASE WHEN nvl(xdl.unrounded_entered_cr,0) <> 0
11610: THEN

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

11675: -- AND xlr.ledger_id = xgl.ledger_id
11676: AND xte.application_id = xalg.bflow_application_id
11677: AND xte.entity_code = xalg.bflow_entity_code
11678: AND xte.ledger_id = p_ledger_id
11679: -- AND xte.ledger_id = DECODE(xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG'),
11680: -- 'N', xlr.primary_ledger_id,
11681: -- DECODE(xlr.ledger_category_code
11682: -- ,'ALC', xlr.primary_ledger_id
11683: -- ,DECODE(NVL(xlo.capture_event_flag,'N'),'N',xlr.primary_ledger_id

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

11852: (p_msg => 'p_bc_mode = '||p_bc_mode
11853: ,p_level => C_LEVEL_PROCEDURE
11854: ,p_module => l_log_module);
11855: trace
11856: (p_msg => 'method = '||xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG')
11857: ,p_level => C_LEVEL_PROCEDURE
11858: ,p_module => l_log_module);
11859: trace
11860: (p_msg => 'g_mpa_accrual_exists = '||xla_accounting_pkg.g_mpa_accrual_exists

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

12025: (SELECT MIN(NVL(xal3.merge_code_combination_id,xal3.code_combination_id)) -- 4967526
12026: ,MIN(DECODE(xalg.inherit_desc_flag, 'Y', xal3.description, xalg.description))
12027: ,MIN(xal3.currency_code)
12028: ,MIN(DECODE(xal3.currency_code
12029: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12030: ,NULL
12031: ,xal3.currency_conversion_rate))
12032: ,MIN(DECODE(xal3.currency_code
12033: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

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

12029: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12030: ,NULL
12031: ,xal3.currency_conversion_rate))
12032: ,MIN(DECODE(xal3.currency_code
12033: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12034: ,NULL
12035: ,xal3.currency_conversion_type))
12036: ,MIN(DECODE(xal3.currency_code
12037: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)

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

12033: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12034: ,NULL
12035: ,xal3.currency_conversion_type))
12036: ,MIN(DECODE(xal3.currency_code
12037: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12038: ,NULL
12039: ,xal3.currency_conversion_date))
12040: ---------------------------------------------------------------------------
12041: -- 4482069 error XLA_AP_INVALID_AMT_BASE

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

12042: -- Occurs when upstream is invalid so c_bflow_valid_lines
12043: -- is not found hence entered amounts will not calc.
12044: -- Upstream invalid need not prevent this value to be assigned.
12045: ---------------------------------------------------------------------------
12046: ,MIN(xla_accounting_cache_pkg.GetCurrencyMau(xal3.currency_code))
12047: ---------------------------------------------------------------------------
12048: -- 4482069 based on calculate_acctd_amts_flag and transaction currency
12049: -- Note: In theory, when calculate_acctd_amts_flag is 'No', entered and
12050: -- accounted amt should be the same (therefore we need not recalc

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

12052: -- make sure they will be the same.
12053: ---------------------------------------------------------------------------
12054: ,MIN(DECODE(calculate_acctd_amts_flag
12055: ,'N', DECODE(xalg.currency_code
12056: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12057: ,NVL(xalg.unrounded_accounted_cr,xalg.unrounded_entered_cr)
12058: ,xalg.unrounded_entered_cr)
12059: ,xalg.unrounded_entered_cr) )
12060: ---------------------------------------------------------------------------

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

12061: -- 4482069 based on calculate_acctd_amts_flag and transaction currency
12062: ---------------------------------------------------------------------------
12063: ,MIN(DECODE(calculate_acctd_amts_flag
12064: ,'N', DECODE(xalg.currency_code
12065: ,xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',xalg.ledger_id)
12066: ,NVL(xalg.unrounded_accounted_dr,xalg.unrounded_entered_dr)
12067: ,xalg.unrounded_entered_dr)
12068: ,xalg.unrounded_entered_dr))
12069: ,MIN(xal3.party_type_code)

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

12125: WHERE xgl.ledger_id = xalg.ledger_id -- 4478604
12126: AND xlr.ledger_id = xgl.ledger_id -- 4478604
12127: AND xte.application_id = xalg.bflow_application_id
12128: AND xte.entity_code = xalg.bflow_entity_code
12129: AND xte.ledger_id = DECODE(xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG'),
12130: 'N', xlr.primary_ledger_id,
12131: DECODE(xlr.ledger_category_code
12132: ,'ALC', xlr.primary_ledger_id
12133: ,DECODE(NVL(xlo.capture_event_flag,'N'),'N',xlr.primary_ledger_id

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

12279: FROM xla_ae_lines xal
12280: WHERE xal.application_id = xalg.bflow_application_id
12281: AND xal.ae_header_id = xalg.temp_ref_ae_header_id
12282: AND xal.ae_line_num = xalg.ref_ae_line_num),
12283: entered_currency_mau = xla_accounting_cache_pkg.GetCurrencyMau(temp_currency_code),
12284: (segment1, segment2, segment3, segment4, segment5, segment6, segment7, segment8, segment9, segment10
12285: ,segment11, segment12, segment13, segment14, segment15, segment16, segment17, segment18, segment19, segment20
12286: ,segment21, segment22, segment23, segment24, segment25, segment26, segment27, segment28, segment29, segment30) =
12287: (SELECT gcc.segment1, gcc.segment2, gcc.segment3, gcc.segment4, gcc.segment5

Line 12852: xla_accounting_cache_pkg.g_hist_bflow_error_exists := TRUE;

12848:
12849: ELSE
12850: l_array_bflow_historic (i) :='Y'; -- This line belongs to historic upgraded data.
12851: l_array_hist_bflow_err(l_array_event_id(i)) :=1;
12852: xla_accounting_cache_pkg.g_hist_bflow_error_exists := TRUE;
12853: END IF;
12854:
12855: END IF; -- for secondary
12856: END IF; -- 5132302

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

13978: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
13979:
13980: ELSE
13981:
13982: l_app_name := xla_accounting_cache_pkg.GetSessionValueChar('XLA_EVENT_APPL_NAME');
13983:
13984: ---------------------------------------------------------------------
13985: -- Verify applied-to system transaction ids
13986: ---------------------------------------------------------------------

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

14277: g_rec_lines.array_entered_cr(g_LineNumber) := g_rec_lines.array_entered_cr(p_line_num);
14278: g_rec_lines.array_accounted_dr(g_LineNumber) := g_rec_lines.array_accounted_dr(p_line_num);
14279: g_rec_lines.array_accounted_cr(g_LineNumber) := g_rec_lines.array_accounted_cr(p_line_num);
14280: g_rec_lines.array_currency_code(g_LineNumber) := g_rec_lines.array_currency_code(p_line_num);
14281: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
14282: g_rec_lines.array_curr_conversion_date(g_LineNumber) := g_rec_lines.array_curr_conversion_date(p_line_num);
14283: g_rec_lines.array_curr_conversion_rate(g_LineNumber) := g_rec_lines.array_curr_conversion_rate(p_line_num);
14284: g_rec_lines.array_curr_conversion_type(g_LineNumber) := g_rec_lines.array_curr_conversion_type(p_line_num);
14285: g_rec_lines.array_description(g_LineNumber) := g_rec_lines.array_description(p_line_num);

Line 14779: l_rec_lines.array_currency_mau(p_line_num) := xla_accounting_cache_pkg.GetCurrencyMau(p_rec_lines.array_currency_code(p_line_num));

14775: l_rec_lines.array_entered_cr(p_line_num) := p_rec_lines.array_entered_cr(p_line_num);
14776: l_rec_lines.array_accounted_dr(p_line_num) := p_rec_lines.array_accounted_dr(p_line_num);
14777: l_rec_lines.array_accounted_cr(p_line_num) := p_rec_lines.array_accounted_cr(p_line_num);
14778: l_rec_lines.array_currency_code(p_line_num) := p_rec_lines.array_currency_code(p_line_num);
14779: l_rec_lines.array_currency_mau(p_line_num) := xla_accounting_cache_pkg.GetCurrencyMau(p_rec_lines.array_currency_code(p_line_num));
14780: l_rec_lines.array_curr_conversion_date(p_line_num) := p_rec_lines.array_curr_conversion_date(p_line_num);
14781: l_rec_lines.array_curr_conversion_rate(p_line_num) := p_rec_lines.array_curr_conversion_rate(p_line_num);
14782: l_rec_lines.array_curr_conversion_type(p_line_num) := p_rec_lines.array_curr_conversion_type(p_line_num);
14783: l_rec_lines.array_description(p_line_num) := p_rec_lines.array_description(p_line_num);

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

15140: g_rec_lines.array_entered_cr(g_LineNumber) := l_rec_lines.array_entered_cr(p_line_num);
15141: g_rec_lines.array_accounted_dr(g_LineNumber) := l_rec_lines.array_accounted_dr(p_line_num);
15142: g_rec_lines.array_accounted_cr(g_LineNumber) := l_rec_lines.array_accounted_cr(p_line_num);
15143: g_rec_lines.array_currency_code(g_LineNumber) := l_rec_lines.array_currency_code(p_line_num);
15144: g_rec_lines.array_currency_mau(g_LineNumber) := xla_accounting_cache_pkg.GetCurrencyMau(g_rec_lines.array_currency_code(g_LineNumber));
15145: g_rec_lines.array_curr_conversion_date(g_LineNumber) := l_rec_lines.array_curr_conversion_date(p_line_num);
15146: g_rec_lines.array_curr_conversion_rate(g_LineNumber) := l_rec_lines.array_curr_conversion_rate(p_line_num);
15147: g_rec_lines.array_curr_conversion_type(g_LineNumber) := l_rec_lines.array_curr_conversion_type(p_line_num);
15148: g_rec_lines.array_description(g_LineNumber) := l_rec_lines.array_description(p_line_num);

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

16794: -- *********** Initialization routine **********
16795: --=============================================================================
16796:
16797: BEGIN
16798: g_application_id := xla_accounting_cache_pkg.GetValueNum('XLA_EVENT_APPL_ID');
16799:
16800: ----------------------------------------
16801: -- 4219869 Init Business Flow counts
16802: ----------------------------------------