DBA Data[Home] [Help]

APPS.XLA_EVENTS_PKG dependencies on GL_LEDGERS

Line 9755: l_primary_ledger_id GL_LEDGERS.ledger_id%TYPE;

9751: l_unprocessed NUMBER(2) := 0;
9752: l_log_module VARCHAR2(240);
9753: l_request_id NUMBER(10);
9754: l_check_events NUMBER(2) := 0;
9755: l_primary_ledger_id GL_LEDGERS.ledger_id%TYPE;
9756: l_ledger_id GL_LEDGERS.ledger_id%TYPE;
9757: l_user_id NUMBER;
9758: l_resp_id NUMBER;
9759: l_resp_appl_id NUMBER;

Line 9756: l_ledger_id GL_LEDGERS.ledger_id%TYPE;

9752: l_log_module VARCHAR2(240);
9753: l_request_id NUMBER(10);
9754: l_check_events NUMBER(2) := 0;
9755: l_primary_ledger_id GL_LEDGERS.ledger_id%TYPE;
9756: l_ledger_id GL_LEDGERS.ledger_id%TYPE;
9757: l_user_id NUMBER;
9758: l_resp_id NUMBER;
9759: l_resp_appl_id NUMBER;
9760: l_xml_output BOOLEAN;

Line 9764: l_ledger_name GL_LEDGERS.name%TYPE;

9760: l_xml_output BOOLEAN;
9761: l_iso_language FND_LANGUAGES.iso_language%TYPE;
9762: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
9763: l_user_je_source_name XLA_LOOKUPS.meaning%TYPE;
9764: l_ledger_name GL_LEDGERS.name%TYPE;
9765: BEGIN
9766: IF g_log_enabled THEN
9767: l_log_module := C_DEFAULT_MODULE||'.period_close';
9768: END IF;

Line 9832: FROM gl_ledgers

9828: AND lookup_code = 'ALL';
9829:
9830: SELECT name
9831: INTO l_ledger_name
9832: FROM gl_ledgers
9833: WHERE ledger_id = p_ledger_id;
9834:
9835: EXCEPTION
9836: WHEN NO_DATA_FOUND THEN

Line 9984: FROM gl_ledgers

9980: END IF;
9981:
9982: SELECT name
9983: INTO l_ledger_name
9984: FROM gl_ledgers
9985: WHERE ledger_id = p_ledger_id;
9986:
9987:
9988: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN