1 package pa_purge_projects_pkg as
2 /* $Header: PAXARPPS.pls 120.1 2005/08/05 00:48:56 rgandhi noship $ */
3 procedure insert_row (x_rowid in out NOCOPY VARCHAR2,/*File.sql.39*/
4 x_purge_batch_id in out NOCOPY NUMBER,/*File.sql.39*/
5 x_project_id in NUMBER,
6 x_last_project_status_code in VARCHAR2,
7 x_purge_summary_flag in VARCHAR2,
8 x_archive_summary_flag in VARCHAR2,
9 x_purge_budgets_flag in VARCHAR2,
10 x_archive_budgets_flag in VARCHAR2,
11 x_purge_capital_flag in VARCHAR2,
12 x_archive_capital_flag in VARCHAR2,
13 x_purge_actuals_flag in VARCHAR2,
14 x_archive_actuals_flag in VARCHAR2,
15 x_txn_to_date in DATE,
16 x_purge_project_status_code in VARCHAR2,
17 x_next_pp_project_status_code in VARCHAR2,
18 x_next_p_project_status_code in VARCHAR2,
19 x_purged_date in DATE,
20 x_user_id in NUMBER ) ;
21
22 procedure update_row (x_rowid in VARCHAR2,
23 x_purge_batch_id in NUMBER,
24 x_project_id in NUMBER,
25 x_last_project_status_code in VARCHAR2,
26 x_purge_summary_flag in VARCHAR2,
27 x_archive_summary_flag in VARCHAR2,
28 x_purge_budgets_flag in VARCHAR2,
29 x_archive_budgets_flag in VARCHAR2,
30 x_purge_capital_flag in VARCHAR2,
31 x_archive_capital_flag in VARCHAR2,
32 x_purge_actuals_flag in VARCHAR2,
33 x_archive_actuals_flag in VARCHAR2,
34 x_txn_to_date in DATE,
35 x_purge_project_status_code in VARCHAR2,
36 x_next_pp_project_status_code in VARCHAR2,
37 x_next_p_project_status_code in VARCHAR2,
38 x_purged_date in DATE,
39 x_user_id in NUMBER ) ;
40
41 procedure delete_row (x_rowid in VARCHAR2) ;
42
43 procedure lock_row (x_rowid in VARCHAR2,
44 x_purge_batch_id in NUMBER,
45 x_project_id in NUMBER,
46 x_last_project_status_code in VARCHAR2,
47 x_purge_summary_flag in VARCHAR2,
48 x_archive_summary_flag in VARCHAR2,
49 x_purge_budgets_flag in VARCHAR2,
50 x_archive_budgets_flag in VARCHAR2,
51 x_purge_capital_flag in VARCHAR2,
52 x_archive_capital_flag in VARCHAR2,
53 x_purge_actuals_flag in VARCHAR2,
54 x_archive_actuals_flag in VARCHAR2,
55 x_txn_to_date in DATE,
56 x_purge_project_status_code in VARCHAR2,
57 x_next_pp_project_status_code in VARCHAR2,
58 x_next_p_project_status_code in VARCHAR2,
59 x_purged_date in DATE) ;
60
61 END pa_purge_projects_pkg;