721: o.representation_code,
722: o.representation_name,
723: o.representation_type
724: FROM okl_representations_v o,
725: fa_book_controls f
726: WHERE o.ledger_id = f.set_of_books_id
727: AND f.book_type_name = p_book_type_name;
728:
729: -- get the representations based on book_type_code .. MG uptake
732: o.representation_code,
733: o.representation_name,
734: o.representation_type
735: FROM okl_representations_v o,
736: fa_book_controls f
737: WHERE o.ledger_id = f.set_of_books_id
738: AND f.book_type_code = p_book_type_code;
739:
740: -- get the reporting product based on the contract product .. MG uptake
745:
746: -- get the book_type_name for asset book type code .. MG uptake
747: CURSOR get_book_type_name(p_book_type_code varchar2) IS
748: SELECT book_type_name
749: FROM fa_book_controls
750: WHERE book_type_code = p_book_type_code;
751:
752: PROCEDURE write_to_log(
753: p_level IN VARCHAR2,