[Home] [Help]
PACKAGE: APPS.GL_ENT_FUNC_BAL_UPGRADE_PKG
Source
1 PACKAGE GL_ENT_FUNC_BAL_UPGRADE_PKG AUTHID CURRENT_USER AS
2 /* $Header: gluefbus.pls 120.1 2005/05/05 01:37:53 kvora noship $ */
3 --
4 -- Package
5 -- gl_ent_func_bal_upgrade_pkg
6 -- Purpose
7 -- To contain routines to upgrade the balances tables and move/merge
8 -- interim tables to support entered functional balances.
9 -- History
10 -- 03/10/2005 T Cheng Created
11
12
13 --
14 -- Procedure
15 -- upgrade_ent_func_bal
16 -- Purpose
17 -- The main routine for the concurrent request: Submits child requests
18 -- to upgrade the balances tables and calls routines to upgrade
19 -- move/merge interim tables.
20 -- History
21 -- 03/10/2005 T Cheng Created
22 -- Arguments
23 -- x_errbuf Message when exiting a PL/SQL concurrent reequest
24 -- x_retcode Exit status for the concurrent request
25 -- x_batchsize Batch commit size
26 -- x_num_workers Number of workers to be used
27 --
28 PROCEDURE upgrade_ent_func_bal(
29 x_errbuf OUT NOCOPY VARCHAR2,
30 x_retcode OUT NOCOPY VARCHAR2,
31 x_batch_size NUMBER,
32 x_num_workers NUMBER);
33
34 --
35 -- Procedure
36 -- upgrade_balance_tables
37 -- Purpose
38 -- Routine for the child requests that upgrade gl_balances and
39 -- gl_daily_balances.
40 -- History
41 -- 03/10/2005 T Cheng Created
42 -- Arguments
43 -- x_errbuf Message when exiting a PL/SQL concurrent reequest
44 -- x_retcode Exit status for the concurrent request
45 -- x_batchsize Batch commit size
46 -- x_worker_id ID for the worker, ranges from 1 to x_num_workers
47 -- x_num_workers Number of workers to be used
48 -- x_argument4 Additional argument: gl schema
49 --
50 PROCEDURE upgrade_balance_tables(
51 x_errbuf OUT NOCOPY VARCHAR2,
52 x_retcode OUT NOCOPY VARCHAR2,
53 x_batch_size NUMBER,
54 x_worker_Id NUMBER,
55 x_num_workers NUMBER,
56 x_argument4 VARCHAR2);
57
58 --
59 -- Procedure
60 -- upgrade_movemerge_int_tables
61 -- Purpose
62 -- Routine for the child request that Upgrades the move/merge
63 -- interim tables.
64 -- History
65 -- 03/10/2005 T Cheng Created
66 -- Arguments
67 -- x_errbuf Message when exiting a PL/SQL concurrent reequest
68 -- x_retcode Exit status for the concurrent request
69 -- x_gl_schema GL schema
70 -- x_applsys_schema FND schema
71 --
72 PROCEDURE upgrade_movemerge_int_tables(
73 x_errbuf OUT NOCOPY VARCHAR2,
74 x_retcode OUT NOCOPY VARCHAR2,
75 x_gl_schema VARCHAR2,
76 x_applsys_schema VARCHAR2);
77
78 END GL_ENT_FUNC_BAL_UPGRADE_PKG;