PACKAGE: APPS.GCS_PURGE_PKG

Source

1 PACKAGE GCS_PURGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcs_purges.pls 120.1 2007/10/04 05:18:26 rthati noship $*/
3 -- Procedure
4 --   purge_cons_runs
5 -- Purpose
6 --   An API for master to submit request to worker
7 -- Arguments
8 --   x_retcode                   Return code
9 --   x_errbuf                    Buffer error
10 --   p_consolidation_hierarchy   Consolidation hierarchy
11 --   p_consolidation_entity      Consolidation entity
12 --   p_cal_period_id             Period
13 --   p_balance_type_code         Balance type code
14 -- Modification History
15 --   Person           Date        Comments
16 --   ramesh.thati    25-09-2007   Purge Program - Bug # 6447909
17 -- Notes
18 --
19 
20    PROCEDURE purge_cons_runs
21       (
22        x_retcode                 OUT NOCOPY VARCHAR2,
23        x_errbuf                  OUT NOCOPY VARCHAR2,
24        p_consolidation_hierarchy IN NUMBER,
25        p_consolidation_entity    IN NUMBER,
26        p_cal_period_id           IN NUMBER,
27        p_balance_type_code       IN VARCHAR2
28        );
29 
30 -- Procedure
31 --   purge_cons_runs_worker
32 -- Purpose
33 --   An API for worker to purge its own set of rows. Its to purge historical data
34 --   with regard to consolidation runs.It will not purge manual adjustments or
35 --   rules generated entries. It will purge only Automatically generated entries
36 -- Arguments
37 --   x_retcode                   Return code
38 --   x_errbuf                    Buffer error
39 --   p_batch_size                No of rows to process
40 --   p_Worker_Id                 Worker ID,
41 --   p_Num_Workers               total Number of workers
42 --   p_consolidation_hierarchy   Consolidation hierarchy
43 --   p_consolidation_entity      Consolidation entity
44 --   p_cal_period_id             Period
45 --   p_balance_type_code         Balance type code
46 -- Modification History
47 --   Person           Date        Comments
48 --   ramesh.thati    25-09-2007   Purge Program - Bug # 6447909
49 -- Notes
50 --
51 
52    PROCEDURE purge_cons_runs_worker
53       (
54        X_errbuf                  OUT NOCOPY VARCHAR2,
55        X_retcode                 OUT NOCOPY VARCHAR2,
56        p_batch_size              IN NUMBER,
57        p_Worker_Id               IN NUMBER,
58        p_Num_Workers             IN NUMBER,
59        p_consolidation_hierarchy IN NUMBER,
60        p_consolidation_entity    IN NUMBER,
61        p_cal_period_id           IN NUMBER,
62        p_balance_type_code       IN VARCHAR2
63        );
64 
65 END GCS_PURGE_PKG; -- Package spec
66