[Home] [Help]
PACKAGE: APPS.OKC_ACTIONS_PVT
Source
1 PACKAGE OKC_ACTIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCCACNS.pls 120.0 2005/05/30 04:11:44 appldev noship $ */
3
4 /*********************** HAND-CODED ***************************************/
5
6 SUBTYPE acnv_rec_type IS okc_acn_pvt.acnv_rec_type;
7 SUBTYPE acnv_tbl_type IS okc_acn_pvt.acnv_tbl_type;
8 SUBTYPE aaev_rec_type IS okc_aae_pvt.aaev_rec_type;
9 SUBTYPE aaev_tbl_type IS okc_aae_pvt.aaev_tbl_type;
10
11 -- GLOBAL VARIABLES
12 ---------------------------------------------------------------------------
13 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ACTIONS_PVT';
14 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
16 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18 ---------------------------------------------------------------------------
19
20 -- GLOBAL EXCEPTION
21 ---------------------------------------------------------------------------
22 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
23 ---------------------------------------------------------------------------
24
25 -- Public procedure declarations
26
27 -- This procedure calls each of the simple API add_languauge
28 -- in order - Action , Action Attributes
29
30 PROCEDURE add_language;
31
32 -- Object type procedure for Create
33 PROCEDURE create_actions(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 p_acnv_rec IN acnv_rec_type,
40 p_aaev_tbl IN aaev_tbl_type,
41 x_acnv_rec OUT NOCOPY acnv_rec_type,
42 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
43
44 -- It first calls create_actions(record version), then calls create_act_atts
45 -- (table version)
46
47 PROCEDURE create_actions(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_acnv_tbl IN acnv_tbl_type,
54 p_aaev_tbl IN aaev_tbl_type,
55 x_acnv_tbl OUT NOCOPY acnv_tbl_type,
56 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
57
58 -- It first calls create_actions(table version), then calls create_act_atts
59 -- (table version)
60
61
62 -- Object type procedure for Update
63 PROCEDURE update_actions(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_acnv_rec IN acnv_rec_type,
70 p_aaev_tbl IN aaev_tbl_type,
71 x_acnv_rec OUT NOCOPY acnv_rec_type,
72 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
73
74 -- It first calls update_actions(record version), then calls update_act_atts
75 -- (table version)
76
77 -- Object type procedure for Validate
78 PROCEDURE validate_actions(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_acnv_rec IN acnv_rec_type,
85 p_aaev_tbl IN aaev_tbl_type);
86
87 -- It first calls validate_actions(record version), then calls
88 -- validate_act_atts (table version)
89
90 -- Routines to manage Actions
91
92 PROCEDURE create_actions(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_acnv_tbl IN acnv_tbl_type,
99 x_acnv_tbl OUT NOCOPY acnv_tbl_type);
100
101 -- It calls OKC_ACN_PVT.insert_row
102
103 PROCEDURE create_actions(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_acnv_rec IN acnv_rec_type,
110 x_acnv_rec OUT NOCOPY acnv_rec_type);
111
112 -- It calls OKC_ACN_PVT.insert_row
113
114 PROCEDURE lock_actions(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_acnv_tbl IN acnv_tbl_type);
121
122 -- It calls OKC_ACN_PVT.lock_row
123
124 PROCEDURE lock_actions(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_acnv_rec IN acnv_rec_type);
131
132 -- It calls OKC_ACN_PVT.lock_row
133
134 PROCEDURE update_actions(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_acnv_tbl IN acnv_tbl_type,
141 x_acnv_tbl OUT NOCOPY acnv_tbl_type);
142
143 -- It calls OKC_ACN_PVT.update_row
144
145 PROCEDURE update_actions(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_acnv_rec IN acnv_rec_type,
152 x_acnv_rec OUT NOCOPY acnv_rec_type);
153
154 -- It calls OKC_ACN_PVT.update_row
155
156 PROCEDURE delete_actions(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_acnv_tbl IN acnv_tbl_type);
163
164 -- Calls the record version due to business rule enforcement
165
166 PROCEDURE delete_actions(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_acnv_rec IN acnv_rec_type);
173
174 -- It calls OKC_ACN_PVT.delete_row
175
176 PROCEDURE validate_actions(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_acnv_tbl IN acnv_tbl_type);
183
184 -- It calls OKC_ACN_PVT.validate_row
185
186 PROCEDURE validate_actions(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_acnv_rec IN acnv_rec_type);
193
194 -- It calls OKC_ACN_PVT.validate_row
195
196 -- Routines to manage Action Attributes
197
198 PROCEDURE create_act_atts(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_aaev_tbl IN aaev_tbl_type,
205 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
206
207 -- It calls the next routine, the record version, because of business
208 -- rule enforcement
209
210 PROCEDURE create_act_atts(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_aaev_rec IN aaev_rec_type,
217 x_aaev_rec OUT NOCOPY aaev_rec_type);
218
219 -- It calls the OKC_AAE_PVT.insert_row
220
221 PROCEDURE lock_act_atts(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_aaev_tbl IN aaev_tbl_type);
228
229 -- It calls the OKC_AAE_PVT.lock_row
230
231 PROCEDURE lock_act_atts(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2,
237 p_aaev_rec IN aaev_rec_type);
238
239 -- It calls the OKC_AAE_PVT.lock_row
240
241 PROCEDURE update_act_atts(
242 p_api_version IN NUMBER,
243 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2,
247 p_aaev_tbl IN aaev_tbl_type,
248 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
249
250 -- It calls the OKC_AAE_PVT.update_row
251
252 PROCEDURE update_act_atts(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_aaev_rec IN aaev_rec_type,
259 x_aaev_rec OUT NOCOPY aaev_rec_type);
260
261 -- It calls the OKC_AAE_PVT.update_row
262
263 PROCEDURE delete_act_atts(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_aaev_tbl IN aaev_tbl_type);
270
271 -- It calls the OKC_AAE_PVT.delete_row
272
273 PROCEDURE delete_act_atts(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_aaev_rec IN aaev_rec_type);
280
281 -- It calls the OKC_AAE_PVT.delete_row
282
283 PROCEDURE validate_act_atts(
284 p_api_version IN NUMBER,
285 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2,
289 p_aaev_tbl IN aaev_tbl_type);
290
291 -- It calls the OKC_AAE_PVT.validate_row
292
293 PROCEDURE validate_act_atts(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_aaev_rec IN aaev_rec_type);
300
301 -- It calls the OKC_AAE_PVT.validate_row
302
303 END OKC_ACTIONS_PVT;