APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on GL_LEDGERS

Line 604: FROM gl_ledgers

600: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
601: IS
602: CURSOR c IS
603: SELECT enable_budgetary_control_flag
604: FROM gl_ledgers
605: WHERE ledger_id = p_ledger_id;
606:
607: l_bc_flag VARCHAR2(1);
608: l_log_module VARCHAR2(240);

Line 3791: FROM gl_ledgers

3787: RETURN BOOLEAN
3788: IS
3789: CURSOR c_bc_enabled IS
3790: SELECT ledger_id, nvl(enable_budgetary_control_flag, 'N')
3791: FROM gl_ledgers
3792: WHERE ledger_id = p_ledger_id;
3793:
3794: l_bc_enabled VARCHAR2(30);
3795: l_ledger_id INTEGER;

Line 5138: FROM gl_ledgers gl, xla_ledger_options xlo

5134: RETURN VARCHAR2
5135: IS
5136: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS
5137: SELECT gl.name, gl.currency_code, gl.ledger_category_code, xlo.rounding_rule_code
5138: FROM gl_ledgers gl, xla_ledger_options xlo
5139: WHERE gl.ledger_id = p_trx_ledger_id
5140: AND xlo.application_id = p_application_id
5141: AND xlo.ledger_id = p_trx_ledger_id;
5142:

Line 6774: FROM gl_ledgers gl,

6770: 'SEGMENT27', ccid.segment27,
6771: 'SEGMENT28', ccid.segment28,
6772: 'SEGMENT29', ccid.segment29,
6773: 'SEGMENT30', ccid.segment30)
6774: FROM gl_ledgers gl,
6775: gl_code_combinations ccid,
6776: xla_ledger_options xlo
6777: WHERE ccid.code_combination_id = p_code_combination_id
6778: AND gl.ledger_id = p_ledger_id

Line 7091: FROM gl_ledgers

7087: ,p_budgetary_control_flag IN VARCHAR2)
7088: IS
7089: CURSOR c IS
7090: SELECT name, ledger_category_code, latest_encumbrance_year, enable_budgetary_control_flag
7091: FROM gl_ledgers
7092: WHERE ledger_id = p_ledger_id;
7093:
7094: l_ledger_name gl_ledgers.name%TYPE;
7095: l_classification_code gl_ledgers.ledger_category_code%TYPE;

Line 7094: l_ledger_name gl_ledgers.name%TYPE;

7090: SELECT name, ledger_category_code, latest_encumbrance_year, enable_budgetary_control_flag
7091: FROM gl_ledgers
7092: WHERE ledger_id = p_ledger_id;
7093:
7094: l_ledger_name gl_ledgers.name%TYPE;
7095: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7096: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7097: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7098: l_log_module VARCHAR2(240);

Line 7095: l_classification_code gl_ledgers.ledger_category_code%TYPE;

7091: FROM gl_ledgers
7092: WHERE ledger_id = p_ledger_id;
7093:
7094: l_ledger_name gl_ledgers.name%TYPE;
7095: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7096: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7097: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7098: l_log_module VARCHAR2(240);
7099: BEGIN

Line 7096: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;

7092: WHERE ledger_id = p_ledger_id;
7093:
7094: l_ledger_name gl_ledgers.name%TYPE;
7095: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7096: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7097: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7098: l_log_module VARCHAR2(240);
7099: BEGIN
7100: IF g_log_enabled THEN

Line 7097: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;

7093:
7094: l_ledger_name gl_ledgers.name%TYPE;
7095: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7096: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7097: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7098: l_log_module VARCHAR2(240);
7099: BEGIN
7100: IF g_log_enabled THEN
7101: l_log_module := C_DEFAULT_MODULE||'.validate_ledger';