[Home] [Help]
PACKAGE: APPS.OKC_ACTIONS_PUB
Source
1 PACKAGE OKC_ACTIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPACNS.pls 120.0 2005/05/25 22:49:16 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_MESSAGE_CONSTANTS
12 ---------------------------------------------------------------------------
13 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
14 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
15 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
16 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
17 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
18 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
19 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
21 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
22 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
23 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
27 ---------------------------------------------------------------------------
28
29 -- GLOBAL EXCEPTION
30 ---------------------------------------------------------------------------
31 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32 ---------------------------------------------------------------------------
33
34 -- GLOBAL VARIABLES
35 ---------------------------------------------------------------------------
36 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ACTIONS_PUB';
37 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
38
39 g_acnv_rec acnv_rec_type;
40 g_aaev_rec aaev_rec_type;
41 ---------------------------------------------------------------------------
42
43 PROCEDURE add_language;
44
45 PROCEDURE create_actions(
46 p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_acnv_rec IN acnv_rec_type,
52 p_aaev_tbl IN aaev_tbl_type,
53 x_acnv_rec OUT NOCOPY acnv_rec_type,
54 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
55
56 PROCEDURE create_actions(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_acnv_tbl IN acnv_tbl_type,
63 p_aaev_tbl IN aaev_tbl_type,
64 x_acnv_tbl OUT NOCOPY acnv_tbl_type,
65 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
66
67 PROCEDURE update_actions(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_acnv_rec IN acnv_rec_type,
74 p_aaev_tbl IN aaev_tbl_type,
75 x_acnv_rec OUT NOCOPY acnv_rec_type,
76 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
77
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 PROCEDURE create_actions(
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 p_acnv_tbl IN acnv_tbl_type,
94 x_acnv_tbl OUT NOCOPY acnv_tbl_type);
95
96 PROCEDURE create_actions(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 p_acnv_rec IN acnv_rec_type,
103 x_acnv_rec OUT NOCOPY acnv_rec_type);
104
105 PROCEDURE lock_actions(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_acnv_tbl IN acnv_tbl_type);
112
113 PROCEDURE lock_actions(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_acnv_rec IN acnv_rec_type);
120
121 PROCEDURE update_actions(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_acnv_tbl IN acnv_tbl_type,
128 x_acnv_tbl OUT NOCOPY acnv_tbl_type);
129
130 PROCEDURE update_actions(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_acnv_rec IN acnv_rec_type,
137 x_acnv_rec OUT NOCOPY acnv_rec_type);
138
139 PROCEDURE delete_actions(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_acnv_tbl IN acnv_tbl_type);
146
147 PROCEDURE delete_actions(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_acnv_rec IN acnv_rec_type);
154
155 PROCEDURE validate_actions(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_acnv_tbl IN acnv_tbl_type);
162
163 PROCEDURE validate_actions(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_acnv_rec IN acnv_rec_type);
170
171 PROCEDURE create_act_atts(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_aaev_tbl IN aaev_tbl_type,
178 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
179
180 PROCEDURE create_act_atts(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_aaev_rec IN aaev_rec_type,
187 x_aaev_rec OUT NOCOPY aaev_rec_type);
188
189 PROCEDURE lock_act_atts(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_aaev_tbl IN aaev_tbl_type);
196
197 PROCEDURE lock_act_atts(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_aaev_rec IN aaev_rec_type);
204
205 PROCEDURE update_act_atts(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_aaev_tbl IN aaev_tbl_type,
212 x_aaev_tbl OUT NOCOPY aaev_tbl_type);
213
214 PROCEDURE update_act_atts(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_aaev_rec IN aaev_rec_type,
221 x_aaev_rec OUT NOCOPY aaev_rec_type);
222
223 PROCEDURE delete_act_atts(
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
226 x_return_status OUT NOCOPY VARCHAR2,
227 x_msg_count OUT NOCOPY NUMBER,
228 x_msg_data OUT NOCOPY VARCHAR2,
229 p_aaev_tbl IN aaev_tbl_type);
230
231 PROCEDURE delete_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 PROCEDURE validate_act_atts(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_aaev_tbl IN aaev_tbl_type);
246
247 PROCEDURE validate_act_atts(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_aaev_rec IN aaev_rec_type);
254
255 END OKC_ACTIONS_PUB;