DBA Data[Home] [Help]

APPS.XLA_REPORT_UTILITY_PKG dependencies on GL_LEDGERS

Line 740: l_ledger_id gl_ledgers.ledger_id%type;

736: --=============================================================================
737: FUNCTION is_primary_ledger (p_ledger_id IN NUMBER)
738: RETURN NUMBER IS
739:
740: l_ledger_id gl_ledgers.ledger_id%type;
741:
742: BEGIN
743:
744: select ledger_id

Line 746: from gl_ledgers

742: BEGIN
743:
744: select ledger_id
745: into l_ledger_id
746: from gl_ledgers
747: where ledger_category_code = 'PRIMARY'
748: and ledger_id = p_ledger_id
749: and rownum = 1;
750:

Line 770: l_object_type_code gl_ledgers.object_type_code%TYPE;

766: --=============================================================================
767: FUNCTION get_ledger_id (p_ledger_id IN NUMBER)
768: RETURN NUMBER IS
769:
770: l_object_type_code gl_ledgers.object_type_code%TYPE;
771: l_ledger_id gl_ledgers.ledger_id%TYPE;
772: l_ledger_id_out gl_ledgers.ledger_id%TYPE;
773:
774: BEGIN

Line 771: l_ledger_id gl_ledgers.ledger_id%TYPE;

767: FUNCTION get_ledger_id (p_ledger_id IN NUMBER)
768: RETURN NUMBER IS
769:
770: l_object_type_code gl_ledgers.object_type_code%TYPE;
771: l_ledger_id gl_ledgers.ledger_id%TYPE;
772: l_ledger_id_out gl_ledgers.ledger_id%TYPE;
773:
774: BEGIN
775:

Line 772: l_ledger_id_out gl_ledgers.ledger_id%TYPE;

768: RETURN NUMBER IS
769:
770: l_object_type_code gl_ledgers.object_type_code%TYPE;
771: l_ledger_id gl_ledgers.ledger_id%TYPE;
772: l_ledger_id_out gl_ledgers.ledger_id%TYPE;
773:
774: BEGIN
775:
776: l_object_type_code := xla_report_utility_pkg.

Line 820: l_object_type_code gl_ledgers.object_type_code%TYPE;

816: --=============================================================================
817: FUNCTION get_ledger_object_type (p_ledger_id IN NUMBER)
818: RETURN VARCHAR2 IS
819:
820: l_object_type_code gl_ledgers.object_type_code%TYPE;
821:
822: BEGIN
823:
824: SELECT object_type_code

Line 826: FROM gl_ledgers

822: BEGIN
823:
824: SELECT object_type_code
825: INTO l_object_type_code
826: FROM gl_ledgers
827: WHERE ledger_id = p_ledger_id;
828:
829: RETURN l_object_type_code;
830: