DBA Data[Home] [Help]

PACKAGE: APPS.PA_PURGE_PROJECTS_PKG

Source


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;