1 Package PA_PURGE_UNASGN_FI AS
2 /* $Header: PAXUSGNS.pls 120.1.12000000.2 2007/03/06 14:01:39 rthumma ship $ */
3
4 -- Start of comments
5 -- API name : PA_FORECASTITEM
6 -- Type : Public
7 -- Pre-reqs : None
8 -- Function : Procedure for Purging records related to unassigned time forecast_items for resources
9 -- Parameters :
10 -- p_archive_flag -> This flag will indicate if the
11 -- records need to be archived
12 -- before they are purged.
13 -- p_txn_to_date -> Date through which the transactions
14 -- need to be purged. This value will
15 -- be NULL if the purge batch is for
16 -- active projects.
17 -- End of comments
18
19 Procedure PA_FORECASTITEM (
20 errbuf OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21 retcode OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
22 p_txn_to_date in VARCHAR2,
23 p_archive_flag in varchar2);
24
25
26 -- Start of comments
27 -- API name : DELETE_FI
28 -- Type : Public
29 -- Pre-reqs : None
30 -- Function : Archive/purge records for pa_forecast_items, pa_forecast_items_details and pa_fi_amount_details table.
31 -- Parameters :
32 -- records need to be archived
33 -- p_forecast_item_id_id_tab -> forecast items tab
34 -- End of comments
35
36 Procedure Delete_FI (p_forecast_item_id_tab in PA_PLSQL_DATATYPES.IdTabTyp,
37 p_project_id_tab in PA_PLSQL_DATATYPES.IdTabTyp, --Added for bug 5870223
38 p_archive_flag in VARCHAR2,
39 p_purge_batch_id in NUMBER,
40 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41 x_err_stage in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
42 x_err_code in OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
43
44 PROCEDURE arpr_log ( p_message IN VARCHAR2 );
45
46 PROCEDURE arpr_out ( p_txn_to_date in VARCHAR2,
47 p_archive_flag in varchar2,
48 p_purge_batch_id in number);
49
50
51 END PA_PURGE_UNASGN_FI;