[Home] [Help]
PACKAGE: APPS.OKC_ASSENT_PUB
Source
1 Package OKC_ASSENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPASTS.pls 120.0 2005/05/25 19:44:51 appldev noship $ */
3
4 subtype astv_rec_type is okc_assent_pvt.astv_rec_type;
5 subtype astv_tbl_type is okc_assent_pvt.astv_tbl_type;
6 subtype stsv_rec_type is okc_assent_pvt.stsv_rec_type;
7 subtype stsv_tbl_type is okc_assent_pvt.stsv_tbl_type;
8
9 ---------------------------------------------------------------------------
10 -- GLOBAL MESSAGE CONSTANTS
11 ---------------------------------------------------------------------------
12 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
15 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
16 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
17 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
18 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
19 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
20 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
21 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
24 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
25 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
26
27 ------------------------------------------------------------------------------------
28 -- GLOBAL EXCEPTION
29 ---------------------------------------------------------------------------
30 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
31
32 -- GLOBAL VARIABLES
33 ---------------------------------------------------------------------------
34 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASSENT_PUB';
35 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
36
37 g_astv_rec astv_rec_type;
38 g_stsv_rec stsv_rec_type;
39
40 ---------------------------------------------------------------------------
41 PROCEDURE add_language;
42
43 PROCEDURE create_assent(
44 p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_astv_rec IN astv_rec_type,
50 x_astv_rec OUT NOCOPY astv_rec_type);
51
52 PROCEDURE create_assent(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_astv_tbl IN astv_tbl_type,
59 x_astv_tbl OUT NOCOPY astv_tbl_type);
60
61 PROCEDURE update_assent(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_astv_rec IN astv_rec_type,
68 x_astv_rec OUT NOCOPY astv_rec_type);
69
70 PROCEDURE update_assent(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_astv_tbl IN astv_tbl_type,
77 x_astv_tbl OUT NOCOPY astv_tbl_type);
78
79 PROCEDURE delete_assent(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_astv_rec IN astv_rec_type);
86
87 PROCEDURE delete_assent(
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_astv_tbl IN astv_tbl_type);
94
95 PROCEDURE lock_assent(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_astv_rec IN astv_rec_type);
102
103 PROCEDURE lock_assent(
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_astv_tbl IN astv_tbl_type);
110
111 PROCEDURE validate_assent(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_astv_rec IN astv_rec_type);
118
119 PROCEDURE validate_assent(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_astv_tbl IN astv_tbl_type);
126
127 FUNCTION header_operation_allowed(
128 p_header_id IN NUMBER,
129 p_opn_code IN VARCHAR2,
130 p_crt_id IN NUMBER DEFAULT NULL) return varchar2;
131
132 FUNCTION line_operation_allowed(
133 p_line_id IN NUMBER,
134 p_opn_code IN VARCHAR2) return varchar2;
135
136 PROCEDURE create_status(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_stsv_rec IN stsv_rec_type,
143 x_stsv_rec OUT NOCOPY stsv_rec_type);
144
145 PROCEDURE create_status(
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_stsv_tbl IN stsv_tbl_type,
152 x_stsv_tbl OUT NOCOPY stsv_tbl_type);
153
154 PROCEDURE update_status(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_stsv_rec IN stsv_rec_type,
161 x_stsv_rec OUT NOCOPY stsv_rec_type);
162
163 PROCEDURE update_status(
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_stsv_tbl IN stsv_tbl_type,
170 x_stsv_tbl OUT NOCOPY stsv_tbl_type);
171
172 PROCEDURE delete_status(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_stsv_rec IN stsv_rec_type);
179
180 PROCEDURE delete_status(
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_stsv_tbl IN stsv_tbl_type);
187
188 PROCEDURE lock_status(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_stsv_rec IN stsv_rec_type);
195
196 PROCEDURE lock_status(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_stsv_tbl IN stsv_tbl_type);
203
204 PROCEDURE validate_status(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_stsv_rec IN stsv_rec_type);
211
212 PROCEDURE validate_status(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_stsv_tbl IN stsv_tbl_type);
219
220 PROCEDURE get_default_status(
221 x_return_status OUT NOCOPY VARCHAR2,
222 p_status_type IN VARCHAR2,
223 x_status_code OUT NOCOPY VARCHAR2);
224
225 PROCEDURE validate_unique_code(
226 x_return_status OUT NOCOPY VARCHAR2,
227 p_stsv_tbl IN stsv_tbl_type);
228
229 PROCEDURE validate_unique_meaning(
230 x_return_status OUT NOCOPY VARCHAR2,
231 p_stsv_tbl IN stsv_tbl_type);
232
233 END okc_assent_pub;