[Home] [Help]
PACKAGE: APPS.PA_WORKPLAN_WORKFLOW
Source
1 package PA_WORKPLAN_WORKFLOW AUTHID CURRENT_USER as
2 /*$Header: PAXSTWWS.pls 120.1 2005/08/19 17:20:49 mwasowic noship $*/
3
4
5 procedure START_WORKFLOW
6 (
7 p_item_type IN VARCHAR2
8 ,p_process_name IN VARCHAR2
9 ,p_structure_version_id IN NUMBER
10 ,p_responsibility_id IN NUMBER
11 ,p_user_id IN NUMBER
12 ,x_item_key OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
13 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
14 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16 );
17
18 procedure cancel_workflow
19 (
20 p_item_type IN VARCHAR2
21 ,p_item_key IN VARCHAR2
22 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
23 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25 );
26
27 procedure check_workplan_status
28 (
29 itemtype IN VARCHAR2
30 ,itemkey IN VARCHAR2
31 ,actid IN NUMBER
32 ,funcmode IN VARCHAR2
33 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34 );
35
36 procedure change_status_working
37 (
38 itemtype IN VARCHAR2
39 ,itemkey IN VARCHAR2
40 ,actid IN NUMBER
41 ,funcmode IN VARCHAR2
42 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 );
44
45 procedure change_status_rejected
46 (
47 itemtype IN VARCHAR2
48 ,itemkey IN VARCHAR2
49 ,actid IN NUMBER
50 ,funcmode IN VARCHAR2
51 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 );
53
54 procedure change_status_approved
55 (
56 itemtype IN VARCHAR2
57 ,itemkey IN VARCHAR2
58 ,actid IN NUMBER
59 ,funcmode IN VARCHAR2
60 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61 );
62
63 procedure SELECT_ERROR_RECEIVER
64 (
65 p_item_type IN VARCHAR2
66 ,p_item_key IN VARCHAR2
67 ,actid IN NUMBER
68 ,funcmode IN VARCHAR2
69 ,resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70 );
71
72 procedure SHOW_WORKPLAN_PUB_ERR
73 (document_id IN VARCHAR2,
74 display_type IN VARCHAR2,
75 document IN OUT NOCOPY clob, --File.Sql.39 bug 4440895
76 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
77
78 -- FP M : 3491609 : Project Execution Workflow
79 PROCEDURE START_PROJECT_EXECUTION_WF
80 (
81 p_project_id IN pa_projects_all.project_id%TYPE --changed type from varchar to column type 3619185 Satish
82 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
83 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
84 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
85 ) ;
86
87 PROCEDURE CANCEL_PROJECT_EXECUTION_WF
88 (
89 p_project_id IN pa_projects_all.project_id%TYPE --changed type from varchar to column type 3619185 Satish
90 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
91 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
92 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
93 );
94
95 PROCEDURE START_TASK_EXECUTION_WF
96 ( itemtype in varchar2
97 ,itemkey in varchar2
98 ,actid in number
99 ,funcmode in varchar2
100 ,resultout out NOCOPY varchar2 --File.Sql.39 bug 4440895
101 ) ;
102
103 PROCEDURE CANCEL_TASK_EXECUTION_WF
104 (
105 p_task_id IN VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
107 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
109 );
110
111 PROCEDURE RESTART_TASK_EXECUTION_WF
112 ( p_task_id IN NUMBER
113 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116 ) ;
117
118 PROCEDURE IS_PROJECT_CLOSED
119 ( itemtype in varchar2
120 ,itemkey in varchar2
121 ,actid in number
122 ,funcmode in varchar2
123 ,resultout out NOCOPY varchar2 --File.Sql.39 bug 4440895
124 ) ;
125 -- FP M : 3491609 : Project Execution Workflow
126
127 end PA_WORKPLAN_WORKFLOW;