222: END; return (TRUE);
223: end;
224:
225: FUNCTION get_company_name RETURN BOOLEAN IS
226: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
227: l_name gl_sets_of_books.name%TYPE;
228: l_sob_id NUMBER;
229: l_report_start_date DATE;
230: BEGIN
223: end;
224:
225: FUNCTION get_company_name RETURN BOOLEAN IS
226: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
227: l_name gl_sets_of_books.name%TYPE;
228: l_sob_id NUMBER;
229: l_report_start_date DATE;
230: BEGIN
231: l_report_start_date := sysdate; l_sob_id := p_set_of_books_id;
232: SELECT name,
233: chart_of_accounts_id
234: INTO l_name,
235: l_chart_of_accounts_id
236: FROM gl_sets_of_books
237: WHERE set_of_books_id = l_sob_id;
238:
239: c_company_name_header := l_name;
240: c_chart_of_accounts_id := l_chart_of_accounts_id;