[Home] [Help]
PACKAGE: APPS.CS_KB_WF_PKG
Source
1 PACKAGE CS_KB_WF_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbwfs.pls 120.1 2005/08/12 16:24:05 mkettle noship $ */
3
4
5 FUNCTION getActionName(
6 g_action IN VARCHAR2
7 )
8 RETURN VARCHAR2;
9
10 FUNCTION getFlowId(
11 g_flow_details_id IN NUMBER
12 )
13 RETURN NUMBER;
14
15 FUNCTION getStatus(
16 g_setId IN NUMBER
17 )
18 RETURN VARCHAR2;
19
20 FUNCTION getStepGroup(
21 g_flow_details_id IN NUMBER
22 )
23 RETURN NUMBER;
24
25 FUNCTION hasPermission(
26 h_flow_details_id IN NUMBER,
27 h_user_id IN NUMBER
28 )
29 RETURN NUMBER;
30
31 FUNCTION inCategory(
32 c_user_id IN NUMBER,
33 c_set_id IN NUMBER
34 )
35 RETURN NUMBER;
36
37 FUNCTION inProduct(
38 c_user_id IN NUMBER,
39 c_set_id IN NUMBER
40 )
41 RETURN NUMBER;
42
43 FUNCTION isMember(
44 m_user_id IN NUMBER,
45 m_group_id IN NUMBER
46 )
47 RETURN NUMBER;
48
49 PROCEDURE End_Wf(
50 p_itemtype IN VARCHAR2,
51 p_itemkey IN VARCHAR2,
52 p_actid IN NUMBER,
53 p_funcmode IN VARCHAR2,
54 p_result OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE Expire_Detail(
58 p_flow_details_id IN NUMBER,
59 p_result OUT NOCOPY NUMBER
60 );
61
62 PROCEDURE Expire_Flow(
63 p_flow_id IN NUMBER,
64 p_result OUT NOCOPY NUMBER
65 );
66
67 PROCEDURE Enable_Flow(
68 p_flow_id IN NUMBER,
69 p_result OUT NOCOPY NUMBER
70 );
71
72 PROCEDURE Get_Actions(
73 p_action_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
74 p_action_name OUT NOCOPY JTF_VARCHAR2_TABLE_100
75 );
76
77 PROCEDURE Get_All_Groups(
78 p_group_id OUT NOCOPY JTF_NUMBER_TABLE,
79 p_group_name OUT NOCOPY JTF_VARCHAR2_TABLE_100
80 );
81
82 PROCEDURE Get_All_Steps(
83 p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
84 p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
85 );
86
87 PROCEDURE Get_Flow_Details(
88 p_flow_id IN NUMBER,
89 p_flow_details_id OUT NOCOPY JTF_NUMBER_TABLE,
90 p_order_num OUT NOCOPY JTF_NUMBER_TABLE,
91 p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
92 p_group_id OUT NOCOPY JTF_NUMBER_TABLE,
93 p_action OUT NOCOPY JTF_VARCHAR2_TABLE_100
94 );
95
96 PROCEDURE Get_Flows(
97 p_flow_id OUT NOCOPY JTF_NUMBER_TABLE,
98 p_flow_name OUT NOCOPY JTF_VARCHAR2_TABLE_100
99 );
100
101 PROCEDURE Get_Permissions(
102 p_set_id IN NUMBER,
103 p_user_id IN NUMBER,
104 p_results OUT NOCOPY NUMBER
105 );
106
107 PROCEDURE Get_Permissions_for_PUB_soln(
108 p_set_number IN VARCHAR2,
109 p_user_id IN NUMBER,
110 p_results OUT NOCOPY NUMBER
111 );
112
113 PROCEDURE Get_Step_List(
114 p_restriction IN NUMBER DEFAULT 0,
115 p_step OUT NOCOPY JTF_VARCHAR2_TABLE_100,
116 p_step_names OUT NOCOPY JTF_VARCHAR2_TABLE_100
117 );
118
119 PROCEDURE Get_Next_Step(
120 p_flow_details_id IN NUMBER,
121 p_next_details_id OUT NOCOPY NUMBER
122 );
123
124 PROCEDURE Get_Prev_Step(
125 p_flow_details_id IN NUMBER,
126 p_next_details_id OUT NOCOPY NUMBER
127 );
128
129 PROCEDURE Insert_Flow(
130 p_flow_name IN VARCHAR2,
131 p_flow_id OUT NOCOPY NUMBER
132 );
133
134 PROCEDURE Insert_Detail(
135 p_flow_id IN NUMBER,
136 p_order_num IN NUMBER,
137 p_step IN VARCHAR2,
138 p_group_id IN NUMBER,
139 p_action IN VARCHAR2,
140 p_flow_details_id OUT NOCOPY NUMBER
141 );
142
143 PROCEDURE Start_wf(
144 p_set_number IN VARCHAR2,
145 p_set_id IN NUMBER ,
146 p_new_step IN NUMBER ,
147 p_results OUT NOCOPY NUMBER,
148 p_errormsg OUT NOCOPY VARCHAR2
149 );
150
151 PROCEDURE Start_wf_processing(
152 p_itemtype IN VARCHAR2,
153 p_itemkey IN VARCHAR2,
154 p_actid IN NUMBER,
155 p_funcmode IN VARCHAR2,
156 p_result OUT NOCOPY VARCHAR2
157 );
158
159 PROCEDURE Create_Wf_Process(
160 p_set_id IN NUMBER,
161 p_set_number IN VARCHAR2,
162 p_command IN VARCHAR2,
163 p_flow_details_id IN NUMBER,
164 p_group_id IN NUMBER,
165 p_solution_title IN VARCHAR2
166 );
167
168 PROCEDURE Update_Detail(
169 p_flow_details_id IN NUMBER,
170 p_order_num IN NUMBER,
171 p_step IN VARCHAR2,
172 p_group_id IN NUMBER,
173 p_action IN VARCHAR2,
174 p_result OUT NOCOPY NUMBER
175 );
176
177
178 PROCEDURE Update_Flow(
179 p_flow_id IN NUMBER,
180 p_flow_name IN VARCHAR2,
181 p_result OUT NOCOPY NUMBER
182 );
183
184 PROCEDURE Update_Flow_Admin(
185 p_flow_id IN NUMBER DEFAULT NULL,
186 p_flow_name IN VARCHAR2,
187 p_result OUT NOCOPY NUMBER
188 );
189
190 /* This one calls Update_Detail_Admin (which deals with update/insert)
191 Plus, it does Delete */
192 PROCEDURE Update_Detail_Admin(
193 p_flow_details_id IN NUMBER DEFAULT NULL,
194 p_flow_id IN NUMBER,
195 p_order_num IN NUMBER,
196 p_step IN VARCHAR2,
197 p_group_id IN NUMBER,
198 p_action IN VARCHAR2,
199 p_flag IN VARCHAR2,
200 p_result OUT NOCOPY NUMBER
201 );
202
203 PROCEDURE Add_Language;
204
205 FUNCTION IS_STEP_DISABLED ( P_FLOW_ID NUMBER,
206 P_FLOW_DETAILS_ID NUMBER,
207 P_FLOW_DETAILS_ORDER NUMBER,
208 P_CURRENT_FLOW_DETAILS_ID NUMBER) RETURN VARCHAR2;
209
210 -- Package Specification CS_KB_WF_PKG
211 END;