CREATE OR REPLACE PACKAGE BODY APPS.gl_import_hook_pkg AS /* $Header: glujihkb.pls 115.4 2002/11/13 20:08:17 djogg ship $ */ -- -- PUBLIC FUNCTIONS -- -- -- Procedure -- pre_module_hook -- Purpose -- Hook into journal import for other products. -- This procedure is called after journal import has selected -- the sources to process, but before it has started processing the data. -- If you need to use this hook, please add a call to your own -- package before the return statement. Please do NOT commit -- your changes in your package. -- Returns -- TRUE - upon success (allows journal import to continue) -- FALSE - upon failure (causes journal import to abort and display the -- error in errbuf) -- History -- 19-JUN-95 D. J. Ogg Created -- Arguments -- sob_id The set of books id -- run_id The import run id -- errbuf The error message printed upon error -- Example -- gl_import_hook_pkg.pre_module_hook(2, 100, errbuf); -- Notes -- FUNCTION pre_module_hook(sob_id IN NUMBER, run_id IN NUMBER, errbuf IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS BEGIN -- AX section IF ax_setup_pkg.ax_installed THEN IF NOT ax_ezl_filter_pkg.EZLFilter(sob_id, run_id, errbuf) THEN RETURN FALSE; END IF; END IF; -- Please put your function call here. Make it the following format: -- IF (NOT dummy(sob_id, run_id, errbuf)) THEN -- RETURN(FALSE); -- END IF; IF (NOT test_je_import_hook.update_gl_interface(sob_id, run_id, errbuf)) THEN RETURN(FALSE); END IF; RETURN(TRUE); END pre_module_hook; -- -- Procedure -- post_module_hook -- Purpose -- Hook into journal import for other products. -- This procedure is called after journal import has inserted all of the -- data into gl_je_batches, gl_je_headers, and gl_je_lines, but before -- it does the final commit. -- This routine is called once per 100 batches. -- If you need to use this hook, please add a call to your own -- package before the return statement. Please do NOT commit -- your changes in your package. -- Returns -- TRUE - upon success (allows journal import to continue) -- FALSE - upon failure (causes journal import to abort and display the -- error in errbuf) -- History -- 28-FEB-00 D. J. Ogg Created -- Arguments -- batch_ids A list of batch ids, separated by the separator -- separator The separator -- last_set Indicates whether or not this is the last set -- errbuf The error message printed upon error -- Example -- gl_import_hook_pkg.post_module_hook(2, 100, errbuf); -- Notes -- FUNCTION post_module_hook(batch_ids IN VARCHAR2, separator IN VARCHAR2, last_set IN BOOLEAN, errbuf IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS BEGIN gl_ip_process_batches_pkg.process_batches(batch_ids, separator, last_set); -- Please put your function call here. Make it the following format: -- IF (NOT dummy(sob_id, run_id, errbuf)) THEN -- RETURN(FALSE); -- END IF; RETURN(TRUE); END post_module_hook; END gl_import_hook_pkg; /