1 package pa_purge_extn_validate as
2 /* $Header: PAXAPVXS.pls 120.3 2006/07/05 10:03:34 vgottimu noship $ */
3 /*#
4 * This extension can be used to define additional business rules for validating projects for purging. By default, the extension
5 * returns NULL to the calling program.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Archive Project Validation
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14 -- forward declarations
15 /*#
16 * This procedure is used for validating projects for purging.
17 * @param p_project_id Identifier of the project to be purged
18 * @rep:paraminfo {@rep:required}
19 * @param p_txn_through_date For open projects, the date through which the transactions are to be purged
20 * @rep:paraminfo {@rep:required}
21 * @param p_active_flag Flag indicating whether the batch is created for open (active) projects.
22 * @rep:paraminfo {@rep:required}
23 * @param x_err_stack The stack containing all the errors
24 * @rep:paraminfo {@rep:required}
25 * @param x_err_stage The point of occurrence of an error
26 * @rep:paraminfo {@rep:required}
27 * @param x_err_code Error handling code
28 * @rep:paraminfo {@rep:required}
29 * @rep:scope public
30 * @rep:lifecycle active
31 * @rep:displayname Vaildate Extension
32 * @rep:compatibility S
33 */
34 procedure validate_extn ( p_project_id in NUMBER,
35 p_txn_through_date in DATE,
36 p_active_flag in VARCHAR2,
37 x_err_code in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_err_stack in OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39 x_err_stage in OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
40
41
42
43 END pa_purge_extn_validate;