1 package pa_purge_summary AUTHID CURRENT_USER as
2 /* $Header: PAXSUPRS.pls 120.1 2005/08/19 17:21:07 mwasowic noship $ */
3
4 -- Start of comments
5 -- API name : PA_Summary_Main_Purge
6 -- Type : Public
7 -- Pre-reqs : None
8 -- Function : Main purge procedure for summarization tables.
9 -- Calls a seperate procedure to purge each table
10 -- Parameters :
11 -- 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 -> set to 'Y' if summary data
16 -- is to be archived
17 -- p_txn_to_date -> Date through which the transactions
18 -- need to be purged. This value will
19 -- be NULL if the purge batch is for
20 -- active projects.
21 -- p_commit_size -> The maximum number of records that
22 -- can be allowed to remain uncommited.
23 -- If the number of records processed
24 -- goes byond this number then the
25 -- process is commited.
26 -- End of comments
27 procedure pa_summary_main_purge ( p_purge_batch_id in NUMBER,
28 p_project_id in NUMBER,
29 p_purge_release in VARCHAR2,
30 p_txn_to_date in DATE,
31 p_archive_flag in VARCHAR2,
32 p_commit_size in NUMBER,
33 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
36
37 END pa_purge_summary;