PACKAGE: APPS.GL_ENT_FUNC_BAL_UPGRADE_PKG

Source

1 PACKAGE GL_ENT_FUNC_BAL_UPGRADE_PKG 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;