DBA Data[Home] [Help]

APPS.XLA_REPORT_UTILITY_PKG dependencies on GL_LEDGERS

Line 1443: l_ledger_id gl_ledgers.ledger_id%type;

1439: --=============================================================================
1440: FUNCTION is_primary_ledger (p_ledger_id IN NUMBER)
1441: RETURN NUMBER IS
1442:
1443: l_ledger_id gl_ledgers.ledger_id%type;
1444:
1445: BEGIN
1446:
1447: select ledger_id

Line 1449: from gl_ledgers

1445: BEGIN
1446:
1447: select ledger_id
1448: into l_ledger_id
1449: from gl_ledgers
1450: where ledger_category_code = 'PRIMARY'
1451: and ledger_id = p_ledger_id
1452: and rownum = 1;
1453:

Line 1473: l_object_type_code gl_ledgers.object_type_code%TYPE;

1469: --=============================================================================
1470: FUNCTION get_ledger_id (p_ledger_id IN NUMBER)
1471: RETURN NUMBER IS
1472:
1473: l_object_type_code gl_ledgers.object_type_code%TYPE;
1474: l_ledger_id gl_ledgers.ledger_id%TYPE;
1475: l_ledger_id_out gl_ledgers.ledger_id%TYPE;
1476:
1477: BEGIN

Line 1474: l_ledger_id gl_ledgers.ledger_id%TYPE;

1470: FUNCTION get_ledger_id (p_ledger_id IN NUMBER)
1471: RETURN NUMBER IS
1472:
1473: l_object_type_code gl_ledgers.object_type_code%TYPE;
1474: l_ledger_id gl_ledgers.ledger_id%TYPE;
1475: l_ledger_id_out gl_ledgers.ledger_id%TYPE;
1476:
1477: BEGIN
1478:

Line 1475: l_ledger_id_out gl_ledgers.ledger_id%TYPE;

1471: RETURN NUMBER IS
1472:
1473: l_object_type_code gl_ledgers.object_type_code%TYPE;
1474: l_ledger_id gl_ledgers.ledger_id%TYPE;
1475: l_ledger_id_out gl_ledgers.ledger_id%TYPE;
1476:
1477: BEGIN
1478:
1479: l_object_type_code := xla_report_utility_pkg.

Line 1523: l_object_type_code gl_ledgers.object_type_code%TYPE;

1519: --=============================================================================
1520: FUNCTION get_ledger_object_type (p_ledger_id IN NUMBER)
1521: RETURN VARCHAR2 IS
1522:
1523: l_object_type_code gl_ledgers.object_type_code%TYPE;
1524:
1525: BEGIN
1526:
1527: SELECT object_type_code

Line 1529: FROM gl_ledgers

1525: BEGIN
1526:
1527: SELECT object_type_code
1528: INTO l_object_type_code
1529: FROM gl_ledgers
1530: WHERE ledger_id = p_ledger_id;
1531:
1532: RETURN l_object_type_code;
1533: