FIN.PKG_GL_POSTING (package, 14 procedures, package state)
Converted by AI · reviewed and edited by Marcus Reed
CREATE OR REPLACE PACKAGE BODY fin.pkg_gl_posting AS g_batch_id NUMBER; PROCEDURE post_journal(p_journal_id IN NUMBER) IS v_total NUMBER; BEGIN SELECT NVL(SUM(amount), 0) INTO v_total FROM fin.gl_journal_lines WHERE journal_id = p_journal_id; INSERT INTO fin.gl_postings (batch_id, journal_id, total) VALUES (g_batch_id, p_journal_id, v_total); END post_journal;END pkg_gl_posting;CREATE OR REPLACE FUNCTION fin_pkg_gl_posting.post_journal( p_journal_id numeric(38,10))RETURNS void LANGUAGE plpgsql AS $$DECLARE v_total numeric(38,10); v_batch_id numeric(38,10);BEGIN SELECT batch_id INTO v_batch_id FROM fin_pkg_gl_posting.session_settings WHERE session_id = pg_backend_pid(); SELECT COALESCE(SUM(amount), 0) INTO v_total FROM fin.gl_journal_lines WHERE journal_id = p_journal_id; INSERT INTO fin.gl_postings (batch_id, journal_id, total) VALUES (v_batch_id, p_journal_id, v_total);END;$$;Becomes schema fin_pkg_gl_posting with functions and a session settings table.

