DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_ACCOUNTING_CACHE_PKG

Line 5751: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

5747: p_level => C_LEVEL_PROCEDURE);
5748: END IF;
5749:
5750: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
5751: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
5752: p_source_code => 'XLA_ROUNDING_RULE_CODE'
5753: , p_target_ledger_id => g_ledger_id
5754: );
5755: ELSE

Line 5918: l_mau:= xla_accounting_cache_pkg.GetValueNum(

5914: p_level => C_LEVEL_PROCEDURE);
5915: END IF;
5916:
5917: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
5918: l_mau:= xla_accounting_cache_pkg.GetValueNum(
5919: p_source_code => 'XLA_CURRENCY_MAU'
5920: , p_target_ledger_id => g_ledger_id);
5921:
5922: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

Line 5922: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

5918: l_mau:= xla_accounting_cache_pkg.GetValueNum(
5919: p_source_code => 'XLA_CURRENCY_MAU'
5920: , p_target_ledger_id => g_ledger_id);
5921:
5922: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
5923: p_source_code => 'XLA_ROUNDING_RULE_CODE'
5924: , p_target_ledger_id => g_ledger_id
5925: );
5926: ELSE

Line 6944: l_mau:= xla_accounting_cache_pkg.GetValueNum(

6940: p_level => C_LEVEL_EVENT);
6941: END IF;
6942:
6943: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
6944: l_mau:= xla_accounting_cache_pkg.GetValueNum(
6945: p_source_code => 'XLA_CURRENCY_MAU'
6946: , p_target_ledger_id => g_ledger_id);
6947:
6948: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

Line 6948: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

6944: l_mau:= xla_accounting_cache_pkg.GetValueNum(
6945: p_source_code => 'XLA_CURRENCY_MAU'
6946: , p_target_ledger_id => g_ledger_id);
6947:
6948: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
6949: p_source_code => 'XLA_ROUNDING_RULE_CODE'
6950: , p_target_ledger_id => g_ledger_id
6951: );
6952: ELSE

Line 7803: l_mau:= xla_accounting_cache_pkg.GetValueNum(

7799: p_level => C_LEVEL_PROCEDURE);
7800: END IF;
7801:
7802: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
7803: l_mau:= xla_accounting_cache_pkg.GetValueNum(
7804: p_source_code => 'XLA_CURRENCY_MAU'
7805: , p_target_ledger_id => g_ledger_id);
7806: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
7807: p_source_code => 'XLA_ROUNDING_RULE_CODE'

Line 7806: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

7802: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
7803: l_mau:= xla_accounting_cache_pkg.GetValueNum(
7804: p_source_code => 'XLA_CURRENCY_MAU'
7805: , p_target_ledger_id => g_ledger_id);
7806: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
7807: p_source_code => 'XLA_ROUNDING_RULE_CODE'
7808: , p_target_ledger_id => g_ledger_id
7809: );
7810: ELSE

Line 8373: l_mau:= xla_accounting_cache_pkg.GetValueNum(

8369: p_level => C_LEVEL_PROCEDURE);
8370: END IF;
8371:
8372: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
8373: l_mau:= xla_accounting_cache_pkg.GetValueNum(
8374: p_source_code => 'XLA_CURRENCY_MAU'
8375: , p_target_ledger_id => g_ledger_id);
8376: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
8377: p_source_code => 'XLA_ROUNDING_RULE_CODE'

Line 8376: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

8372: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
8373: l_mau:= xla_accounting_cache_pkg.GetValueNum(
8374: p_source_code => 'XLA_CURRENCY_MAU'
8375: , p_target_ledger_id => g_ledger_id);
8376: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
8377: p_source_code => 'XLA_ROUNDING_RULE_CODE'
8378: , p_target_ledger_id => g_ledger_id
8379: );
8380: ELSE

Line 9801: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);

9797: END IF;
9798:
9799: -- 4262811. Added in C_CALLER_MPA_PROGRAM.
9800: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
9801: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);

Line 9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);

9798:
9799: -- 4262811. Added in C_CALLER_MPA_PROGRAM.
9800: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
9801: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);

Line 9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);

9799: -- 4262811. Added in C_CALLER_MPA_PROGRAM.
9800: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
9801: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);

Line 9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);

9800: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
9801: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);

Line 9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);

9801: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);

Line 9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);

9802: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);

Line 9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);

9803: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);

Line 9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);

9804: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);

Line 9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);

9805: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);

Line 9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);

9806: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);

Line 9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);

9807: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);

Line 9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);

9808: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);

Line 9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);

9809: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);

Line 9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);

9810: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);

Line 9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);

9811: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
9819: /*

Line 9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);

9812: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
9819: /*
9820: SELECT suspense_allowed_flag

Line 9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);

9813: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
9819: /*
9820: SELECT suspense_allowed_flag
9821: INTO g_suspense_allowed_flag

Line 9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);

9814: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
9815: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
9816: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
9817: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
9818: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
9819: /*
9820: SELECT suspense_allowed_flag
9821: INTO g_suspense_allowed_flag
9822: FROM gl_ledgers

Line 10027: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id;

10023: ,p_budgetary_control_mode IN VARCHAR2
10024: ,p_accounting_mode IN VARCHAR2)
10025: RETURN INTEGER
10026: IS
10027: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
10028: l_ledger_id INTEGER;
10029: l_count INTEGER;
10030: l_result INTEGER := 0;
10031: l_log_module VARCHAR2(240);

Line 10053: l_array_ledgers := xla_accounting_cache_pkg.GetLedgers;

10049: ,p_balance_flag => TRUE
10050: ,p_accounting_mode => p_accounting_mode);
10051:
10052: -- Process Primary and Secondary ledgers
10053: l_array_ledgers := xla_accounting_cache_pkg.GetLedgers;
10054:
10055: IF l_array_ledgers.COUNT > 0 THEN
10056: FOR l_count IN 1 .. l_array_ledgers.COUNT LOOP
10057: delete from xla_validation_lines_gt;

Line 10066: l_array_ledgers := xla_accounting_cache_pkg.GetAlcLedgers(

10062: END LOOP;
10063: END IF;
10064:
10065: -- Process ALC ledgers
10066: l_array_ledgers := xla_accounting_cache_pkg.GetAlcLedgers(
10067: p_primary_ledger_id => g_trx_ledger_id);
10068:
10069: IF l_array_ledgers.COUNT > 0 THEN
10070: FOR l_count IN 1 .. l_array_ledgers.COUNT LOOP

Line 10133: ,p_ledger_array IN xla_accounting_cache_pkg.t_array_ledger_id

10129: --=============================================================================
10130: FUNCTION balance_tpm_amounts
10131: (p_application_id IN INTEGER
10132: ,p_ledger_id IN INTEGER
10133: ,p_ledger_array IN xla_accounting_cache_pkg.t_array_ledger_id
10134: ,p_accounting_mode IN VARCHAR2
10135: ) RETURN INTEGER
10136: IS
10137: l_ledger_id INTEGER;