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
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:
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
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:
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.
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
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: