APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on GL_LEDGERS

Line 606: FROM gl_ledgers

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

Line 3893: FROM gl_ledgers

3889: RETURN BOOLEAN
3890: IS
3891: CURSOR c_bc_enabled IS
3892: SELECT ledger_id, nvl(enable_budgetary_control_flag, 'N')
3893: FROM gl_ledgers
3894: WHERE ledger_id = p_ledger_id;
3895:
3896: l_bc_enabled VARCHAR2(30);
3897: l_ledger_id INTEGER;

Line 5334: FROM gl_ledgers gl, xla_ledger_options xlo

5330: RETURN VARCHAR2
5331: IS
5332: CURSOR c_trx_ledger (p_trx_ledger_id INTEGER, p_application_id INTEGER) IS
5333: SELECT gl.name, gl.currency_code, gl.ledger_category_code, xlo.rounding_rule_code
5334: FROM gl_ledgers gl, xla_ledger_options xlo
5335: WHERE gl.ledger_id = p_trx_ledger_id
5336: AND xlo.application_id = p_application_id
5337: AND xlo.ledger_id = p_trx_ledger_id;
5338:

Line 6994: FROM gl_ledgers gl,

6990: 'SEGMENT27', ccid.segment27,
6991: 'SEGMENT28', ccid.segment28,
6992: 'SEGMENT29', ccid.segment29,
6993: 'SEGMENT30', ccid.segment30)
6994: FROM gl_ledgers gl,
6995: gl_code_combinations ccid,
6996: xla_ledger_options xlo
6997: WHERE ccid.code_combination_id = p_code_combination_id
6998: AND gl.ledger_id = p_ledger_id

Line 7311: FROM gl_ledgers

7307: ,p_budgetary_control_flag IN VARCHAR2)
7308: IS
7309: CURSOR c IS
7310: SELECT name, ledger_category_code, latest_encumbrance_year, enable_budgetary_control_flag
7311: FROM gl_ledgers
7312: WHERE ledger_id = p_ledger_id;
7313:
7314: l_ledger_name gl_ledgers.name%TYPE;
7315: l_classification_code gl_ledgers.ledger_category_code%TYPE;

Line 7314: l_ledger_name gl_ledgers.name%TYPE;

7310: SELECT name, ledger_category_code, latest_encumbrance_year, enable_budgetary_control_flag
7311: FROM gl_ledgers
7312: WHERE ledger_id = p_ledger_id;
7313:
7314: l_ledger_name gl_ledgers.name%TYPE;
7315: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7316: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7317: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7318: l_log_module VARCHAR2(240);

Line 7315: l_classification_code gl_ledgers.ledger_category_code%TYPE;

7311: FROM gl_ledgers
7312: WHERE ledger_id = p_ledger_id;
7313:
7314: l_ledger_name gl_ledgers.name%TYPE;
7315: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7316: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7317: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7318: l_log_module VARCHAR2(240);
7319: BEGIN

Line 7316: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;

7312: WHERE ledger_id = p_ledger_id;
7313:
7314: l_ledger_name gl_ledgers.name%TYPE;
7315: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7316: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7317: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7318: l_log_module VARCHAR2(240);
7319: BEGIN
7320: IF g_log_enabled THEN

Line 7317: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;

7313:
7314: l_ledger_name gl_ledgers.name%TYPE;
7315: l_classification_code gl_ledgers.ledger_category_code%TYPE;
7316: l_latest_encumbrance_year gl_ledgers.latest_encumbrance_year%TYPE;
7317: l_bc_enabled_flag gl_ledgers.enable_budgetary_control_flag%TYPE;
7318: l_log_module VARCHAR2(240);
7319: BEGIN
7320: IF g_log_enabled THEN
7321: l_log_module := C_DEFAULT_MODULE||'.validate_ledger';