1 PACKAGE BODY gl_import_hook_pkg AS
2 /* $Header: glujihkb.pls 120.5 2005/05/05 01:39:55 kvora ship $ */
3
4 --
5 -- PUBLIC FUNCTIONS
6 --
7
8 --
9 -- Procedure
10 -- pre_module_hook
11 -- Purpose
12 -- Hook into journal import for other products.
13 -- This procedure is called after journal import has selected
14 -- the sources to process, but before it has started processing the data.
15 -- If you need to use this hook, please add a call to your own
16 -- package before the return statement. Please do NOT commit
17 -- your changes in your package.
18 -- Returns
19 -- TRUE - upon success (allows journal import to continue)
20 -- FALSE - upon failure (causes journal import to abort and display the
21 -- error in errbuf)
22 -- History
23 -- 19-JUN-95 D. J. Ogg Created
24 -- Arguments
25 -- run_id The import run id
26 -- errbuf The error message printed upon error
27 -- Example
28 -- gl_import_hook_pkg.pre_module_hook(2, 100, errbuf);
29 -- Notes
30 --
31 FUNCTION pre_module_hook(run_id IN NUMBER,
32 errbuf IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
33 BEGIN
34 -- Please put your function call here. Make it the following format:
35 -- IF (NOT dummy(sob_id, run_id, errbuf)) THEN
36 -- RETURN(FALSE);
37 -- END IF;
38
39 RETURN(TRUE);
40 END pre_module_hook;
41
42
43 --
44 -- Procedure
45 -- post_module_hook
46 -- Purpose
47 -- Hook into journal import for other products.
48 -- This procedure is called after journal import has inserted all of the
49 -- data into gl_je_batches, gl_je_headers, and gl_je_lines, but before
50 -- it does the final commit.
51 -- This routine is called once per 100 batches.
52 -- If you need to use this hook, please add a call to your own
53 -- package before the return statement. Please do NOT commit
54 -- your changes in your package.
55 -- Returns
56 -- TRUE - upon success (allows journal import to continue)
57 -- FALSE - upon failure (causes journal import to abort and display the
58 -- error in errbuf)
59 -- History
60 -- 28-FEB-00 D. J. Ogg Created
61 -- Arguments
62 -- batch_ids A list of batch ids, separated by the separator
63 -- separator The separator
64 -- last_set Indicates whether or not this is the last set
65 -- errbuf The error message printed upon error
66 -- Example
67 -- gl_import_hook_pkg.post_module_hook(2, 100, errbuf);
68 -- Notes
69 --
70 FUNCTION post_module_hook(batch_ids IN VARCHAR2,
71 separator IN VARCHAR2,
72 last_set IN BOOLEAN,
73 errbuf IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
74 BEGIN
75
76 -- gl_ip_process_batches_pkg.process_batches(batch_ids, separator, last_set);
77
78 -- Please put your function call here. Make it the following format:
79 -- IF (NOT dummy(sob_id, run_id, errbuf)) THEN
80 -- RETURN(FALSE);
81 -- END IF;
82
83 RETURN(TRUE);
84 END post_module_hook;
85 END gl_import_hook_pkg;