PACKAGE: APPS.PA_CLIENT_EXTN_PROJECT_WF

Source

1 PACKAGE pa_client_extn_project_wf AUTHID CURRENT_USER as
2 /* $Header: PAWFPCES.pls 120.2 2006/06/19 05:56:53 sunkalya noship $ */
3 /*#
4  * This extension is used as the basis of your project workflow extension.
5  * @rep:scope public
6  * @rep:product PA
7  * @rep:lifecycle active
8  * @rep:displayname Project Workflow.
9  * @rep:compatibility S
10  * @rep:category BUSINESS_ENTITY PA_PROJECT
11  * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
12 */
13 
14 /*#
15  * This API is used to return the project approver ID to the calling workflow process.
16  * @param  p_project_id  Identifier of the project.
17  * @rep:paraminfo {@rep:required}
18  * @param p_workflow_started_by_id Identifier of the person who submitted the project status change.
19  * @rep:paraminfo {@rep:required}
20  * @param p_project_approver_id Identifier of the project approver.
21  * @rep:paraminfo {@rep:required}
22  * @rep:scope public
23  * @rep:lifecycle active
24  * @rep:displayname Select project approver.
25  * @rep:compatibility S
26 */
27 
28 PROCEDURE select_project_approver (p_project_id	            IN NUMBER
29 				  ,p_workflow_started_by_id IN NUMBER
30 				  ,p_project_approver_id   OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
31 
32 
33 
34 /*#
35  * This API is used to starts the workflow process for project status changes.
36  * @param p_project_id  Identifier of the project.
37  * @rep:paraminfo {@rep:required}
38  * @param p_item_type The workflow item type.
39  * @rep:paraminfo {@rep:required}
40  * @param p_process Name of the workflow process.
41  * @rep:paraminfo {@rep:required}
42  * @param p_out_item_key The workflow item key.
43  * @rep:paraminfo {@rep:required}
44  * @param p_err_stack Error handling stack.
45  * @rep:paraminfo {@rep:required}
46  * @param p_err_stage Error handling stage.
47  * @rep:paraminfo {@rep:required}
48  * @param p_err_code Error handling code.
49  * @rep:paraminfo {@rep:required}
50  * @param p_status_type Project status type.
51  * @rep:paraminfo {@rep:required}
52  * @rep:scope public
53  * @rep:lifecycle active
54  * @rep:displayname Start project workflow.
55  * @rep:compatibility S
56 */
57 
58 PROCEDURE Start_Project_Wf (p_project_id    IN NUMBER
59                           , p_item_type     IN VARCHAR2
60                           , p_process       IN VARCHAR2
61                           , p_out_item_key OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
62                           , p_err_stack    OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63                           , p_err_stage    OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64                           , p_err_code     OUT NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
65                           , p_status_type  IN  VARCHAR2 DEFAULT 'PROJECT');
66 
67 
68 end pa_client_extn_project_wf;