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_JOURNAL_ENTRY_PKG dependencies on XLA_ACCOUNTING_CACHE_PKG

Line 448: RETURN xla_accounting_cache_pkg.t_array_ledger_id

444: | |
445: +======================================================================*/
446: --
447: FUNCTION GetAlternateCurrencyLedger(p_base_ledger_id IN NUMBER )
448: RETURN xla_accounting_cache_pkg.t_array_ledger_id
449: IS
450: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
451: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
452: l_log_module VARCHAR2(240);

Line 450: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;

446: --
447: FUNCTION GetAlternateCurrencyLedger(p_base_ledger_id IN NUMBER )
448: RETURN xla_accounting_cache_pkg.t_array_ledger_id
449: IS
450: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
451: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
452: l_log_module VARCHAR2(240);
453: BEGIN
454: --

Line 451: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;

447: FUNCTION GetAlternateCurrencyLedger(p_base_ledger_id IN NUMBER )
448: RETURN xla_accounting_cache_pkg.t_array_ledger_id
449: IS
450: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
451: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
452: l_log_module VARCHAR2(240);
453: BEGIN
454: --
455: IF g_log_enabled THEN

Line 471: (p_msg =>'-> CALL xla_accounting_cache_pkg.GetAlcLedgers API'

467: ,p_level => C_LEVEL_PROCEDURE
468: ,p_module => l_log_module);
469:
470: trace
471: (p_msg =>'-> CALL xla_accounting_cache_pkg.GetAlcLedgers API'
472: ,p_level => C_LEVEL_PROCEDURE
473: ,p_module => l_log_module);
474:
475: END IF;

Line 479: l_array_alc_ledgers := xla_accounting_cache_pkg.GetAlcLedgers(

475: END IF;
476: --
477: l_array_ledgers(1) := p_base_ledger_id;
478: --
479: l_array_alc_ledgers := xla_accounting_cache_pkg.GetAlcLedgers(
480: p_primary_ledger_id => p_base_ledger_id
481: );
482:
483: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 514: ,p_value_1 => 'xla_accounting_cache_pkg.GetAlcLedgers'

510: xla_accounting_err_pkg.build_message
511: (p_appli_s_name => 'XLA'
512: ,p_msg_name => 'XLA_AP_ACCT_ENGINE_ERROR'
513: ,p_token_1 => 'PROCEDURE'
514: ,p_value_1 => 'xla_accounting_cache_pkg.GetAlcLedgers'
515: ,p_entity_id => g_cache_event.entity_id
516: ,p_event_id => g_cache_event.event_id
517: ,p_ledger_id => g_cache_event.target_ledger_id
518: );

Line 894: (p_msg => '-> CALL xla_accounting_cache_pkg.GetValueChar/Num/Date APIs'

890: ,p_level => C_LEVEL_PROCEDURE
891: ,p_module => l_log_module);
892:
893: trace
894: (p_msg => '-> CALL xla_accounting_cache_pkg.GetValueChar/Num/Date APIs'
895: ,p_level => C_LEVEL_PROCEDURE
896: ,p_module => l_log_module);
897:
898: END IF;

Line 929: g_cache_ledgers_info.description_language := xla_accounting_cache_pkg.GetValueChar(

925: --
926: -- target ledger language
927: --
928: l_api_name:= 'GetValueChar';
929: g_cache_ledgers_info.description_language := xla_accounting_cache_pkg.GetValueChar(
930: p_source_code => 'XLA_DESCRIPTION_LANGUAGE'
931: , p_target_ledger_id => p_target_ledger_id
932: );
933:

Line 961: g_cache_ledgers_info.minimum_accountable_unit:= xla_accounting_cache_pkg.GetValueNum(

957: --
958: -- target minimum accountable unit
959: --
960: l_api_name:= 'GetValueNum';
961: g_cache_ledgers_info.minimum_accountable_unit:= xla_accounting_cache_pkg.GetValueNum(
962: p_source_code => 'XLA_CURRENCY_MAU'
963: , p_target_ledger_id => p_target_ledger_id
964: );
965:

Line 992: g_cache_ledgers_info.rounding_rule_code:= xla_accounting_cache_pkg.GetValueChar(

988: --
989: -- Rounding rule code
990: --
991: l_api_name:= 'GetValueChar';
992: g_cache_ledgers_info.rounding_rule_code:= xla_accounting_cache_pkg.GetValueChar(
993: p_source_code => 'XLA_ROUNDING_RULE_CODE'
994: , p_target_ledger_id => p_target_ledger_id
995: );
996:

Line 1022: g_cache_ledgers_info.sla_ledger_id := xla_accounting_cache_pkg.GetValueNum(

1018: --
1019: -- SLA ledger id
1020: --
1021: l_api_name:= 'GetValueNum';
1022: g_cache_ledgers_info.sla_ledger_id := xla_accounting_cache_pkg.GetValueNum(
1023: p_source_code => 'SLA_LEDGER_ID'
1024: , p_target_ledger_id => p_target_ledger_id
1025: );
1026:

Line 1052: l_currency := xla_accounting_cache_pkg.GetValueChar(

1048: --
1049: -- target currency code
1050: --
1051: l_api_name:= 'GetValueChar';
1052: l_currency := xla_accounting_cache_pkg.GetValueChar(
1053: p_source_code => 'XLA_CURRENCY_CODE'
1054: , p_target_ledger_id => p_target_ledger_id
1055: );
1056: g_cache_ledgers_info.currency_code := l_currency;

Line 1083: g_cache_ledgers_info.source_coa_id := xla_accounting_cache_pkg.GetValueNum(

1079: --
1080: -- get primary coa id
1081: --
1082: l_api_name:= 'GetValueNum';
1083: g_cache_ledgers_info.source_coa_id := xla_accounting_cache_pkg.GetValueNum(
1084: p_source_code => 'XLA_COA_ID'
1085: , p_target_ledger_id => nvl(l_primary_ledger_id,p_primary_ledger_id) --Bug :11680489
1086: );
1087:

Line 1119: g_cache_ledgers_info.target_coa_id := xla_accounting_cache_pkg.GetValueNum(

1115: --
1116: -- target coa id, used to build the target code combination
1117: --
1118: l_api_name:= 'GetValueNum';
1119: g_cache_ledgers_info.target_coa_id := xla_accounting_cache_pkg.GetValueNum(
1120: p_source_code => 'XLA_COA_ID'
1121: , p_target_ledger_id => p_target_ledger_id
1122: );
1123:

Line 1156: g_cache_ledgers_info.sl_coa_mapping_name := xla_accounting_cache_pkg.GetValueChar(

1152: --
1153: -- Get multiple posting information
1154: --
1155: l_api_name:= 'GetValueChar';
1156: g_cache_ledgers_info.sl_coa_mapping_name := xla_accounting_cache_pkg.GetValueChar(
1157: p_source_code => 'GL_COA_MAPPING_NAME'
1158: , p_target_ledger_id => p_base_ledger_id
1159: );
1160:

Line 1166: l_sl_coa_mapping_id := xla_accounting_cache_pkg.GetValueNum(

1162: -- get SL coa mapping id
1163: --
1164: l_api_name:= 'GetValueNum';
1165:
1166: l_sl_coa_mapping_id := xla_accounting_cache_pkg.GetValueNum(
1167: p_source_code => 'SL_COA_MAPPING_ID'
1168: , p_target_ledger_id => p_base_ledger_id
1169: );
1170:

Line 1181: g_cache_ledgers_info.dynamic_insert_flag := xla_accounting_cache_pkg.GetValueChar(

1177: -- get coa dynamic insert flag
1178: --
1179: l_api_name:= 'GetValueChar';
1180:
1181: g_cache_ledgers_info.dynamic_insert_flag := xla_accounting_cache_pkg.GetValueChar(
1182: p_source_code => 'DYNAMIC_INSERTS_ALLOWED_FLAG'
1183: , p_target_ledger_id => p_base_ledger_id
1184: );
1185:

Line 1198: g_cache_ledgers_info.nls_desc_language := xla_accounting_cache_pkg.GetValueChar(

1194: --
1195: -- nls descriptions of target ledger
1196: --
1197: l_api_name:= 'GetValueChar';
1198: g_cache_ledgers_info.nls_desc_language := xla_accounting_cache_pkg.GetValueChar(
1199: p_source_code => 'XLA_NLS_DESC_LANGUAGE'
1200: , p_target_ledger_id => p_target_ledger_id
1201: );
1202:

Line 1229: g_cache_ledgers_info.ledger_reversal_option := xla_accounting_cache_pkg.GetValueChar(

1225: --
1226: -- target reversal option
1227: --
1228: l_api_name:= 'GetValueChar';
1229: g_cache_ledgers_info.ledger_reversal_option := xla_accounting_cache_pkg.GetValueChar(
1230: p_source_code => 'XLA_ACCT_REVERSAL_OPTION'
1231: , p_target_ledger_id => p_target_ledger_id
1232: );
1233:

Line 1266: l_category_code:= xla_accounting_cache_pkg.GetValueChar(

1262:
1263: -- ledger category code
1264: --
1265: l_api_name:= 'GetValueChar';
1266: l_category_code:= xla_accounting_cache_pkg.GetValueChar(
1267: p_source_code => 'LEDGER_CATEGORY_CODE'
1268: , p_target_ledger_id => p_target_ledger_id
1269: );
1270:

Line 1302: l_primary_currency:= xla_accounting_cache_pkg.GetValueChar(

1298:
1299: -- primary currency code
1300: --
1301: l_api_name:= 'GetValueChar';
1302: l_primary_currency:= xla_accounting_cache_pkg.GetValueChar(
1303: p_source_code => 'XLA_CURRENCY_CODE'
1304: , p_target_ledger_id => nvl(l_primary_ledger_id,p_primary_ledger_id)--Bug :11680489
1305: );
1306:

Line 1331: l_alc_enabled_flag :=xla_accounting_cache_pkg.GetValueChar('XLA_ALC_ENABLED_FLAG');

1327: IF l_primary_currency = l_currency THEN
1328: g_cache_ledgers_info.calculate_amts_flag:='N';
1329: END IF;
1330: ELSIF l_category_code= 'ALC' THEN
1331: l_alc_enabled_flag :=xla_accounting_cache_pkg.GetValueChar('XLA_ALC_ENABLED_FLAG');
1332: IF(l_alc_enabled_flag = 'N') THEN
1333: g_cache_ledgers_info.calculate_amts_flag:='N';
1334:
1335: /* -- else block to mark CalculateAmts as N for ALC with same currency of Primary bug 13636827

Line 1338: l_primary_currency:= xla_accounting_cache_pkg.GetValueChar(

1334:
1335: /* -- else block to mark CalculateAmts as N for ALC with same currency of Primary bug 13636827
1336: ELSE
1337: l_api_name:= 'GetValueChar';
1338: l_primary_currency:= xla_accounting_cache_pkg.GetValueChar(
1339: p_source_code => 'XLA_CURRENCY_CODE'
1340: , p_target_ledger_id => p_primary_ledger_id
1341: );
1342: IF l_primary_currency = l_currency THEN

Line 1405: ,p_value_1 => 'xla_accounting_cache_pkg.'||l_api_name

1401: xla_accounting_err_pkg.build_message
1402: (p_appli_s_name => 'XLA'
1403: ,p_msg_name => 'XLA_AP_ACCT_ENGINE_ERROR'
1404: ,p_token_1 => 'PROCEDURE'
1405: ,p_value_1 => 'xla_accounting_cache_pkg.'||l_api_name
1406: ,p_entity_id => g_cache_event.entity_id
1407: ,p_event_id => g_cache_event.event_id
1408: ,p_ledger_id => g_cache_event.target_ledger_id
1409: );

Line 1451: (p_msg => '-> CALL xla_accounting_cache_pkg.get_event_info API'

1447: ,p_level => C_LEVEL_PROCEDURE
1448: ,p_module => l_log_module);
1449:
1450: trace
1451: (p_msg => '-> CALL xla_accounting_cache_pkg.get_event_info API'
1452: ,p_level => C_LEVEL_PROCEDURE
1453: ,p_module => l_log_module);
1454: END IF;
1455:

Line 1456: xla_accounting_cache_pkg.get_event_info

1452: ,p_level => C_LEVEL_PROCEDURE
1453: ,p_module => l_log_module);
1454: END IF;
1455:
1456: xla_accounting_cache_pkg.get_event_info
1457: (p_ledger_id => g_cache_event.target_ledger_id
1458: ,p_event_class_code => g_cache_event.event_class
1459: ,p_event_type_code => g_cache_event.event_type
1460: ,p_ledger_event_class_name => g_cache_event_tl.event_class_name

Line 1481: ,p_value_1 => 'xla_accounting_cache_pkg.get_event_info'

1477: xla_accounting_err_pkg.build_message
1478: (p_appli_s_name => 'XLA'
1479: ,p_msg_name => 'XLA_AP_ACCT_ENGINE_ERROR'
1480: ,p_token_1 => 'PROCEDURE'
1481: ,p_value_1 => 'xla_accounting_cache_pkg.get_event_info'
1482: ,p_entity_id => g_cache_event.entity_id
1483: ,p_event_id => g_cache_event.event_id
1484: ,p_ledger_id => g_cache_event.target_ledger_id
1485: );

Line 1593: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;

1589: l_array_rounding_entd_amt1 t_array_Num;
1590: l_array_ledger_id t_array_ledger_id;
1591: l_array_header_id t_array_Num;
1592: /*
1593: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1594: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
1595: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
1596: */
1597: l_rounding_rule_code VARCHAR2(30);

Line 1594: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;

1590: l_array_ledger_id t_array_ledger_id;
1591: l_array_header_id t_array_Num;
1592: /*
1593: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1594: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
1595: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
1596: */
1597: l_rounding_rule_code VARCHAR2(30);
1598: l_array_rounding_offset t_array_Num;

Line 1595: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;

1591: l_array_header_id t_array_Num;
1592: /*
1593: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1594: l_array_alc_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
1595: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id ;
1596: */
1597: l_rounding_rule_code VARCHAR2(30);
1598: l_array_rounding_offset t_array_Num;
1599: l_array_mau t_array_Num;

Line 1635: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;

1631:
1632:
1633: l_count NUMBER :=1;
1634:
1635: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
1636:
1637: --CURSOR csr_rounding_lines is
1638: --SELECT max(xalg.rowid)
1639: -- ,rounding_class_code

Line 1671: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);

1667: ,p_level => C_LEVEL_PROCEDURE
1668: ,p_module => l_log_module);
1669: END IF;
1670:
1671: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);
1672:
1673: For i in 1..l_ledger_attrs.array_ledger_id.COUNT LOOP
1674: l_array_mau(l_ledger_attrs.array_ledger_id(i)) := l_ledger_attrs.array_mau(i);
1675: l_array_rounding_offset(l_ledger_attrs.array_ledger_id(i)) :=

Line 2019: bsv_segment_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',l_ledger_attrs.array_ledger_id(i));

2015:
2016: -- start changes for bug 14603435
2017:
2018: For i in 1..l_ledger_attrs.array_ledger_id.COUNT LOOP
2019: bsv_segment_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',l_ledger_attrs.array_ledger_id(i));
2020: l_case_sql := l_case_sql || ' WHEN ledger_id = ' || l_ledger_attrs.array_ledger_id(i) ||' THEN gcc.' || bsv_segment_name ;
2021: END LOOP ;
2022: l_case_sql := ' , CASE ' || l_case_sql || ' END ' ;
2023:

Line 3309: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;

3305: RETURN NUMBER
3306: IS
3307: l_log_module VARCHAR2(240);
3308: l_count number;
3309: l_ledger_attrs xla_accounting_cache_pkg.t_array_ledger_attrs;
3310: l_accounting_mode VARCHAR2(1);
3311:
3312: BEGIN
3313: --

Line 3344: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);

3340: ,p_level => C_LEVEL_STATEMENT
3341: ,p_module => l_log_module);
3342: END IF;
3343: --
3344: xla_accounting_cache_pkg.GetLedgerArray(l_ledger_attrs);
3345:
3346:
3347: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
3348: trace

Line 19960: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;

19956: procedure Insert_ANC_Inv_Canc
19957: is
19958: l_rowcount NUMBER;
19959: l_log_module VARCHAR2(240);
19960: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
19961: BEGIN
19962: IF g_log_enabled THEN
19963: l_log_module := C_DEFAULT_MODULE||'.InsertAnalyticalCriteria_Inv_canc';
19964: END IF;

Line 19975: l_array_base_ledgers := xla_accounting_cache_pkg.GetLedgers;

19971: ,p_module => l_log_module);
19972: END IF;
19973:
19974: l_rowcount := 0;
19975: l_array_base_ledgers := xla_accounting_cache_pkg.GetLedgers;
19976:
19977: for i in 1..l_array_base_ledgers.count loop
19978: insert into xla_ae_line_acs (
19979: ae_header_id,