736: ,p_accounting_batch_id IN NUMBER) RETURN NUMBER IS
737:
738: l_log_module VARCHAR2(240);
739: l_request_id NUMBER;
740: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;
741: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;
742: l_ledger VARCHAR2(30);
743: l_process_category_name VARCHAR2(80);
744: l_create_accounting_flag VARCHAR2(80);
737:
738: l_log_module VARCHAR2(240);
739: l_request_id NUMBER;
740: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;
741: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;
742: l_ledger VARCHAR2(30);
743: l_process_category_name VARCHAR2(80);
744: l_create_accounting_flag VARCHAR2(80);
745: l_errors_only_flag VARCHAR2(80);
815:
816: IF p_source_application_id IS NOT NULL THEN
817: SELECT gjst.user_je_source_name
818: INTO l_source_application
819: FROM xla_subledgers xls, gl_je_sources_tl gjst
820: WHERE xls.application_id = p_source_application_id
821: AND xls.je_source_name = gjst.je_source_name
822: AND gjst.language = USERENV('LANG');
823: END IF;
823: END IF;
824:
825: SELECT gjst.user_je_source_name
826: INTO l_je_source
827: FROM xla_subledgers xls, gl_je_sources_tl gjst
828: WHERE xls.application_id = p_application_id
829: AND xls.je_source_name = gjst.je_source_name
830: AND gjst.language = USERENV('LANG');
831: