DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_ACCOUNTING_CACHE_PKG

Line 6063: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

6059: p_level => C_LEVEL_PROCEDURE);
6060: END IF;
6061:
6062: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
6063: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
6064: p_source_code => 'XLA_ROUNDING_RULE_CODE'
6065: , p_target_ledger_id => g_ledger_id
6066: );
6067: ELSE

Line 6230: l_mau:= xla_accounting_cache_pkg.GetValueNum(

6226: p_level => C_LEVEL_PROCEDURE);
6227: END IF;
6228:
6229: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
6230: l_mau:= xla_accounting_cache_pkg.GetValueNum(
6231: p_source_code => 'XLA_CURRENCY_MAU'
6232: , p_target_ledger_id => g_ledger_id);
6233:
6234: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

Line 6234: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

6230: l_mau:= xla_accounting_cache_pkg.GetValueNum(
6231: p_source_code => 'XLA_CURRENCY_MAU'
6232: , p_target_ledger_id => g_ledger_id);
6233:
6234: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
6235: p_source_code => 'XLA_ROUNDING_RULE_CODE'
6236: , p_target_ledger_id => g_ledger_id
6237: );
6238: ELSE

Line 7327: l_mau:= xla_accounting_cache_pkg.GetValueNum(

7323: p_level => C_LEVEL_EVENT);
7324: END IF;
7325:
7326: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
7327: l_mau:= xla_accounting_cache_pkg.GetValueNum(
7328: p_source_code => 'XLA_CURRENCY_MAU'
7329: , p_target_ledger_id => g_ledger_id);
7330:
7331: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

Line 7331: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

7327: l_mau:= xla_accounting_cache_pkg.GetValueNum(
7328: p_source_code => 'XLA_CURRENCY_MAU'
7329: , p_target_ledger_id => g_ledger_id);
7330:
7331: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
7332: p_source_code => 'XLA_ROUNDING_RULE_CODE'
7333: , p_target_ledger_id => g_ledger_id
7334: );
7335: ELSE

Line 8255: l_mau:= xla_accounting_cache_pkg.GetValueNum(

8251: p_level => C_LEVEL_PROCEDURE);
8252: END IF;
8253:
8254: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
8255: l_mau:= xla_accounting_cache_pkg.GetValueNum(
8256: p_source_code => 'XLA_CURRENCY_MAU'
8257: , p_target_ledger_id => g_ledger_id);
8258: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
8259: p_source_code => 'XLA_ROUNDING_RULE_CODE'

Line 8258: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

8254: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
8255: l_mau:= xla_accounting_cache_pkg.GetValueNum(
8256: p_source_code => 'XLA_CURRENCY_MAU'
8257: , p_target_ledger_id => g_ledger_id);
8258: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
8259: p_source_code => 'XLA_ROUNDING_RULE_CODE'
8260: , p_target_ledger_id => g_ledger_id
8261: );
8262: ELSE

Line 8975: l_mau:= xla_accounting_cache_pkg.GetValueNum(

8971: p_level => C_LEVEL_PROCEDURE);
8972: END IF;
8973:
8974: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
8975: l_mau:= xla_accounting_cache_pkg.GetValueNum(
8976: p_source_code => 'XLA_CURRENCY_MAU'
8977: , p_target_ledger_id => g_ledger_id);
8978: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
8979: p_source_code => 'XLA_ROUNDING_RULE_CODE'

Line 8978: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(

8974: IF (g_caller = C_CALLER_ACCT_PROGRAM) THEN
8975: l_mau:= xla_accounting_cache_pkg.GetValueNum(
8976: p_source_code => 'XLA_CURRENCY_MAU'
8977: , p_target_ledger_id => g_ledger_id);
8978: l_rounding_rule_code :=xla_accounting_cache_pkg.GetValueChar(
8979: p_source_code => 'XLA_ROUNDING_RULE_CODE'
8980: , p_target_ledger_id => g_ledger_id
8981: );
8982: ELSE

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

10482: END IF;
10483:
10484: -- 4262811. Added in C_CALLER_MPA_PROGRAM.
10485: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
10486: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
10487: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);

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

10483:
10484: -- 4262811. Added in C_CALLER_MPA_PROGRAM.
10485: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
10486: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
10487: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);

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

10484: -- 4262811. Added in C_CALLER_MPA_PROGRAM.
10485: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
10486: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
10487: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);

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

10485: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_MPA_PROGRAM)) THEN
10486: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
10487: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);

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

10486: g_ledger_name := xla_accounting_cache_pkg.GetValueChar('XLA_LEDGER_NAME',g_ledger_id);
10487: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);

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

10487: g_ledger_currency_code := xla_accounting_cache_pkg.GetValueChar('XLA_CURRENCY_CODE',g_ledger_id);
10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);

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

10488: g_ledger_coa_id := xla_accounting_cache_pkg.GetValueNum('XLA_COA_ID',g_ledger_id);
10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);

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

10489: g_bal_seg_column_name := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_COLUMN_NAME',g_ledger_id);
10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);

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

10490: g_mgt_seg_column_name := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_COLUMN_NAME',g_ledger_id);
10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);

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

10491: g_allow_intercompany_post_flag := xla_accounting_cache_pkg.GetValueChar('ALLOW_INTERCOMPANY_POST_FLAG',g_ledger_id);
10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);

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

10492: g_bal_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('BAL_SEG_VALUE_OPTION_CODE',g_ledger_id);
10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);

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

10493: g_mgt_seg_value_option_code := xla_accounting_cache_pkg.GetValueChar('MGT_SEG_VALUE_OPTION_CODE',g_ledger_id);
10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);

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

10494: g_sla_bal_by_ledger_curr_flag := xla_accounting_cache_pkg.GetValueChar('SLA_BAL_BY_LEDGER_CURR_FLAG',g_ledger_id);
10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
10502: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);

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

10495: g_sla_ledger_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_LEDGER_CUR_BAL_SUS_CCID',g_ledger_id);
10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
10502: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
10503: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);

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

10496: g_sla_entered_cur_bal_sus_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ENTERED_CUR_BAL_SUS_CCID',g_ledger_id);
10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
10502: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
10503: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
10504: /*

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

10497: g_sla_rounding_ccid := xla_accounting_cache_pkg.GetValueNum('XLA_ROUNDING_CCID',g_ledger_id);
10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
10502: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
10503: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
10504: /*
10505: SELECT suspense_allowed_flag

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

10498: g_latest_encumbrance_year := xla_accounting_cache_pkg.GetValueNum('LATEST_ENCUMBRANCE_YEAR',g_ledger_id);
10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
10502: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
10503: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
10504: /*
10505: SELECT suspense_allowed_flag
10506: INTO g_suspense_allowed_flag

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

10499: g_transaction_calendar_id := xla_accounting_cache_pkg.GetValueNum('TRANSACTION_CALENDAR_ID',g_ledger_id);
10500: g_enable_average_balances_flag := xla_accounting_cache_pkg.GetValueChar('ENABLE_AVERAGE_BALANCES_FLAG',g_ledger_id);
10501: g_res_encumb_ccid := xla_accounting_cache_pkg.GetValueNum('RES_ENCUMB_CODE_COMBINATION_ID',g_ledger_id);
10502: g_ledger_category_code := xla_accounting_cache_pkg.GetValueChar('LEDGER_CATEGORY_CODE',g_ledger_id);
10503: g_suspense_allowed_flag := xla_accounting_cache_pkg.GetValueChar('SUSPENSE_ALLOWED_FLAG',g_ledger_id);
10504: /*
10505: SELECT suspense_allowed_flag
10506: INTO g_suspense_allowed_flag
10507: FROM gl_ledgers

Line 10712: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id;

10708: ,p_budgetary_control_mode IN VARCHAR2
10709: ,p_accounting_mode IN VARCHAR2)
10710: RETURN INTEGER
10711: IS
10712: l_array_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
10713: l_ledger_id INTEGER;
10714: l_count INTEGER;
10715: l_result INTEGER := 0;
10716: l_log_module VARCHAR2(240);

Line 10738: l_array_ledgers := xla_accounting_cache_pkg.GetLedgers;

10734: ,p_balance_flag => TRUE
10735: ,p_accounting_mode => p_accounting_mode);
10736:
10737: -- Process Primary and Secondary ledgers
10738: l_array_ledgers := xla_accounting_cache_pkg.GetLedgers;
10739:
10740: IF l_array_ledgers.COUNT > 0 THEN
10741: FOR l_count IN 1 .. l_array_ledgers.COUNT LOOP
10742:

Line 10758: l_array_ledgers := xla_accounting_cache_pkg.GetAlcLedgers(

10754: END LOOP;
10755: END IF;
10756:
10757: -- Process ALC ledgers
10758: l_array_ledgers := xla_accounting_cache_pkg.GetAlcLedgers(
10759: p_primary_ledger_id => g_trx_ledger_id);
10760:
10761: IF l_array_ledgers.COUNT > 0 THEN
10762: FOR l_count IN 1 .. l_array_ledgers.COUNT LOOP

Line 10831: ,p_ledger_array IN xla_accounting_cache_pkg.t_array_ledger_id

10827: --=============================================================================
10828: FUNCTION balance_tpm_amounts
10829: (p_application_id IN INTEGER
10830: ,p_ledger_id IN INTEGER
10831: ,p_ledger_array IN xla_accounting_cache_pkg.t_array_ledger_id
10832: ,p_accounting_mode IN VARCHAR2
10833: ) RETURN INTEGER
10834: IS
10835: l_ledger_id INTEGER;