DBA Data[Home] [Help]

PACKAGE: APPS.PA_PROJECT_WF

Source


1 PACKAGE pa_project_wf AUTHID CURRENT_USER as
2 /* $Header: PAWFPRVS.pls 120.1 2005/08/19 17:07:55 mwasowic noship $ */
3 
4 PROCEDURE select_project_approver ( 	itemtype	in varchar2,
5 					itemkey  	in varchar2,
6 					actid		in number,
7 					funcmode	in varchar2,
8 					resultout	out NOCOPY varchar2	); --File.Sql.39 bug 4440895
9 
10 PROCEDURE Start_Project_Wf (p_project_id  IN NUMBER,
11                             p_err_stack  IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
12                             p_err_stage  IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13                             p_err_code   OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895
14 
15 PROCEDURE Set_Success_status
16   (itemtype                      IN      VARCHAR2
17   ,itemkey                       IN      VARCHAR2
18   ,actid                         IN      NUMBER
19   ,funcmode                      IN      VARCHAR2
20   ,resultout                     OUT     NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
21 
22 PROCEDURE Set_Failure_status
23   (itemtype                      IN      VARCHAR2
24   ,itemkey                       IN      VARCHAR2
25   ,actid                         IN      NUMBER
26   ,funcmode                      IN      VARCHAR2
27   ,resultout                     OUT     NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
28 
29 PROCEDURE Verify_status_change_rules
30   (itemtype                      IN      VARCHAR2
31   ,itemkey                       IN      VARCHAR2
32   ,actid                         IN      NUMBER
33   ,funcmode                      IN      VARCHAR2
34   ,resultout                     OUT     NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
35 
36 PROCEDURE Wf_Status_failure (x_project_id IN NUMBER,
37                              x_failure_status_code IN VARCHAR2,
38                              x_item_type IN VARCHAR2,
39                              x_item_key  IN VARCHAR2,
40                              x_populate_msg_yn IN VARCHAR2,
41 			     x_update_db_yn IN VARCHAR2,
42                              x_err_code  OUT NOCOPY NUMBER ); --File.Sql.39 bug 4440895
43 
44 
45 PROCEDURE Get_proj_status_attributes (x_item_type IN VARCHAR2,
46                                       x_item_key  IN VARCHAR2,
47                                       x_success_proj_stus_code OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48                                       x_failure_proj_stus_code OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49                                       x_err_code  OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
50                                       x_err_stage OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
51 
52 
53 PROCEDURE  validate_changes  (x_project_id            IN NUMBER,
54                               x_success_status_code   IN VARCHAR2,
55                               x_err_code             OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
56                               x_err_stage            OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57                               x_wf_enabled_flag      OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58                               x_verify_ok_flag       OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
59 
60 end pa_project_wf;