[Home] [Help]
PACKAGE: APPS.OKC_ASSENT_PVT
Source
1 Package OKC_ASSENT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCCASTS.pls 120.0 2005/05/25 18:24:28 appldev noship $ */
3
4 subtype astv_rec_type is okc_ast_pvt.astv_rec_type;
5 subtype astv_tbl_type is okc_ast_pvt.astv_tbl_type;
6 subtype stsv_rec_type is okc_sts_pvt.stsv_rec_type;
7 subtype stsv_tbl_type is okc_sts_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_PVT';
35 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
36 ---------------------------------------------------------------------------
37 PROCEDURE add_language;
38
39 PROCEDURE create_assent(
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2,
45 p_astv_rec IN astv_rec_type,
46 x_astv_rec OUT NOCOPY astv_rec_type);
47
48 PROCEDURE create_assent(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_astv_tbl IN astv_tbl_type,
55 x_astv_tbl OUT NOCOPY astv_tbl_type);
56
57 PROCEDURE update_assent(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_astv_rec IN astv_rec_type,
64 x_astv_rec OUT NOCOPY astv_rec_type);
65
66 PROCEDURE update_assent(
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72 p_astv_tbl IN astv_tbl_type,
73 x_astv_tbl OUT NOCOPY astv_tbl_type);
74
75
76 PROCEDURE delete_assent(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_astv_rec IN astv_rec_type);
83
84 PROCEDURE delete_assent(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_astv_tbl IN astv_tbl_type);
91
92 PROCEDURE lock_assent(
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_astv_rec IN astv_rec_type);
99
100 PROCEDURE lock_assent(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_astv_tbl IN astv_tbl_type);
107
108 PROCEDURE validate_assent(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_astv_rec IN astv_rec_type);
115
116 PROCEDURE validate_assent(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_astv_tbl IN astv_tbl_type);
123
124 FUNCTION header_operation_allowed(
125 p_header_id IN NUMBER,
126 p_opn_code IN VARCHAR2,
127 p_crt_id IN NUMBER DEFAULT NULL) return varchar2;
128
129 FUNCTION line_operation_allowed(
130 p_line_id IN NUMBER,
131 p_opn_code IN VARCHAR2) return varchar2;
132
133 PROCEDURE create_status(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_stsv_rec IN stsv_rec_type,
140 x_stsv_rec OUT NOCOPY stsv_rec_type);
141
142 PROCEDURE create_status(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_stsv_tbl IN stsv_tbl_type,
149 x_stsv_tbl OUT NOCOPY stsv_tbl_type);
150
151 PROCEDURE update_status(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_stsv_rec IN stsv_rec_type,
158 x_stsv_rec OUT NOCOPY stsv_rec_type);
159
160 PROCEDURE update_status(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_stsv_tbl IN stsv_tbl_type,
167 x_stsv_tbl OUT NOCOPY stsv_tbl_type);
168
169 PROCEDURE delete_status(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_stsv_rec IN stsv_rec_type);
176
177 PROCEDURE delete_status(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_stsv_tbl IN stsv_tbl_type);
184
185 PROCEDURE lock_status(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188 x_return_status OUT NOCOPY VARCHAR2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2,
191 p_stsv_rec IN stsv_rec_type);
192
193 PROCEDURE lock_status(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2,
199 p_stsv_tbl IN stsv_tbl_type);
200
201 PROCEDURE validate_status(
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2,
207 p_stsv_rec IN stsv_rec_type);
208
209 PROCEDURE validate_status(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_stsv_tbl IN stsv_tbl_type);
216
217 PROCEDURE get_default_status(
218 x_return_status OUT NOCOPY VARCHAR2,
219 p_status_type IN VARCHAR2,
220 x_status_code OUT NOCOPY VARCHAR2);
221
222 PROCEDURE validate_unique_meaning(
223 p_stsv_rec IN stsv_rec_type,
224 x_return_status OUT NOCOPY VARCHAR2);
225
226 PROCEDURE validate_unique_code(
227 p_stsv_rec IN stsv_rec_type,
228 x_return_status OUT NOCOPY VARCHAR2);
229
230 END okc_assent_pvt;