1 package pa_purge_billing as
2 /*$Header: PAXBIPRS.pls 120.1 2005/08/19 17:09:21 mwasowic noship $*/
3
4 -- Start of comments
5 -- API name : PA_Billing_Main_Purge
6 -- Type : Public
7 -- Pre-reqs : None
8 -- Function : Main purge procedure for billing tables.
9 -- Calls a seperate procedure to purge each billing table
10 -- Parameters :
11 -- l p_purge_batch_id -> Purge batch Id
12 -- p_project_id -> Project Id
13 -- p_purge_release -> The release during which it is
14 -- purged
15 -- p_archive_flag -> This flag will indicate if the
16 -- records need to be archived
17 -- before they are purged.
18 -- p_txn_to_date -> Date through which the transactions
19 -- need to be purged. This value will
20 -- be NULL if the purge batch is for
21 -- active projects.
22 -- p_commit_size -> The maximum number of records that
23 -- can be allowed to remain uncommited.
24 -- If the number of records processed
25 -- goes byond this number then the
26 -- process is commited.
27 -- End of comments
28 procedure pa_billing_main_purge ( p_purge_batch_id in NUMBER,
29 p_project_id in NUMBER,
30 p_purge_release in VARCHAR2,
31 p_txn_to_date in DATE,
32 p_archive_flag in VARCHAR2,
33 p_commit_size in NUMBER,
34 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
36 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
37
38 END pa_purge_billing;