1 PACKAGE GL_ADD_RECON_UPGRADE_PKG AS
2 /* $Header: glurcnus.pls 120.1 2005/09/30 22:56:17 djogg noship $ */
3 --
4 -- Package
5 -- gl_add_recon_upgrade_pkg
6 -- Purpose
7 -- To add rows into gl_je_lines_recon from lines in
8 -- gl_je_lines.
9 -- History
10 -- 08/26/2005 V Treiger Created
11
12 --
13 -- Procedure
14 -- upgrade_recon
15 -- Purpose
16 -- The main routine for the concurrent request: Submits child requests
17 -- to upgrade the gl_je_lines_recon table.
18 --
19 -- History
20 -- 08/26/2005 V Treiger Created
21 -- Arguments
22 -- x_errbuf Message when exiting a PL/SQL concurrent reequest
23 -- x_retcode Exit status for the concurrent request
24 -- x_batchsize Batch commit size
25 -- x_num_workers Number of workers to be used
26 --
27 PROCEDURE upgrade_recon(
28 x_errbuf OUT NOCOPY VARCHAR2,
29 x_retcode OUT NOCOPY VARCHAR2,
30 x_batch_size NUMBER,
31 x_num_workers NUMBER);
32
33 --
34 -- Procedure
35 -- update_gl_je_lines_recon_table
36 -- Purpose
37 -- Routine to add rows into gl_je_lines_recon from lines in
38 -- gl_je_lines.
39 -- History
40 -- 08/26/2005 V Treiger Created
41 -- Arguments
42 -- x_errbuf Message when exiting a PL/SQL concurrent reequest
43 -- x_retcode Exit status for the concurrent request
44 -- x_batchsize Batch commit size
45 -- x_worker_id ID for the worker, ranges from 1 to x_num_workers
46 -- x_num_workers Number of workers to be used
47 -- x_argument4 Additional argument: gl schema
48 --
49 PROCEDURE update_gl_je_lines_recon_table(
50 x_errbuf OUT NOCOPY VARCHAR2,
51 x_retcode OUT NOCOPY VARCHAR2,
52 x_batch_size NUMBER,
53 x_worker_Id NUMBER,
54 x_num_workers NUMBER,
55 x_argument4 VARCHAR2);
56
57 END GL_ADD_RECON_UPGRADE_PKG;