1 package pa_purge_projects_gen_pkg as
2 /* $Header: PAXPRGNS.pls 120.1 2005/08/19 17:17:30 mwasowic noship $ */
3 procedure gen_projects ( x_purge_batch_id in NUMBER,
4 x_active_closed_flag in VARCHAR2,
5 x_closed_thru_date in DATE,
6 x_organization_id in NUMBER,
7 x_project_type in VARCHAR2,
8 x_project_status_code in VARCHAR2,
9 x_purge_summary_flag in VARCHAR2,
10 x_archive_summary_flag in VARCHAR2,
11 x_purge_budgets_flag in VARCHAR2,
12 x_archive_budgets_flag in VARCHAR2,
13 x_purge_capital_flag in VARCHAR2,
14 x_archive_capital_flag in VARCHAR2,
15 x_purge_actuals_flag in VARCHAR2,
16 x_archive_actuals_flag in VARCHAR2,
17 x_admin_proj_flag in VARCHAR2,
18 x_txn_to_date in DATE,
19 x_next_pp_project_status_code in VARCHAR2,
20 x_next_p_project_status_code in VARCHAR2,
21 x_user_id in NUMBER,
22 x_no_recs in OUT NOCOPY NUMBER) ; --File.Sql.39 bug 4440895
23
24 Procedure Get_Purge_Options(p_project_id IN NUMBER,
25 p_active_closed_flag IN VARCHAR2,
26 x_txn_to_date IN OUT NOCOPY DATE, --File.Sql.39 bug 4440895
27 x_purge_actuals_flag IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28 x_purge_budgets_flag IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 x_purge_capital_flag IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30 x_purge_summary_flag IN OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
31 END pa_purge_projects_gen_pkg ;