[Home] [Help]
PACKAGE: APPS.OKL_INDICES_PVT
Source
1 PACKAGE OKL_INDICES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCIDXS.pls 115.1 2002/02/06 11:26:46 pkm ship $ */
3
4 SUBTYPE idxv_rec_type IS okl_idx_pvt.idxv_rec_type;
5 SUBTYPE idxv_tbl_type IS okl_idx_pvt.idxv_tbl_type;
6
7 SUBTYPE ivev_rec_type IS okl_ive_pvt.ivev_rec_type;
8 SUBTYPE ivev_tbl_type IS okl_ive_pvt.ivev_tbl_type;
9 ------------------------------------------------------------------------------
10 -- Global Variables
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INDICES_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
14 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
15 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
16 ------------------------------------------------------------------------------
17 --Global Exception
18 ------------------------------------------------------------------------------
19 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
20 ------------------------------------------------------------------------------
21
22 --Object type procedure for insert
23 PROCEDURE create_indices(
24 p_api_version IN NUMBER
25 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
26 ,x_return_status OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY NUMBER
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 ,p_idxv_rec IN idxv_rec_type
30 ,p_ivev_tbl IN ivev_tbl_type
31 ,x_idxv_rec OUT NOCOPY idxv_rec_type
32 ,x_ivev_tbl OUT NOCOPY ivev_tbl_type
33 );
34
35 --Object type procedure for update
36 PROCEDURE update_indices(
37 p_api_version IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,p_idxv_rec IN idxv_rec_type
43 ,p_ivev_tbl IN ivev_tbl_type
44 ,x_idxv_rec OUT NOCOPY idxv_rec_type
45 ,x_ivev_tbl OUT NOCOPY ivev_tbl_type
46 );
47
48 --Object type procedure for validate
49 PROCEDURE validate_indices(
50 p_api_version IN NUMBER
51 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 ,p_idxv_rec IN idxv_rec_type
56 ,p_ivev_tbl IN ivev_tbl_type
57 );
58
59 PROCEDURE create_indices(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_idxv_tbl IN idxv_tbl_type,
66 x_idxv_tbl OUT NOCOPY idxv_tbl_type);
67
68 PROCEDURE create_indices(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_idxv_rec IN idxv_rec_type,
75 x_idxv_rec OUT NOCOPY idxv_rec_type);
76
77 PROCEDURE lock_indices(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_idxv_tbl IN idxv_tbl_type);
84
85 PROCEDURE lock_indices(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_idxv_rec IN idxv_rec_type);
92
93 PROCEDURE update_indices(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_idxv_tbl IN idxv_tbl_type,
100 x_idxv_tbl OUT NOCOPY idxv_tbl_type);
101
102 PROCEDURE update_indices(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_idxv_rec IN idxv_rec_type,
109 x_idxv_rec OUT NOCOPY idxv_rec_type);
110
111 PROCEDURE delete_indices(
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_idxv_tbl IN idxv_tbl_type);
118
119 PROCEDURE delete_indices(
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_idxv_rec IN idxv_rec_type);
126
127 PROCEDURE validate_indices(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_idxv_tbl IN idxv_tbl_type);
134
135 PROCEDURE validate_indices(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_idxv_rec IN idxv_rec_type);
142
143
144 PROCEDURE create_index_values(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_ivev_tbl IN ivev_tbl_type,
151 x_ivev_tbl OUT NOCOPY ivev_tbl_type);
152
153 PROCEDURE create_index_values(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_ivev_rec IN ivev_rec_type,
160 x_ivev_rec OUT NOCOPY ivev_rec_type);
161
162 PROCEDURE lock_index_values(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_ivev_tbl IN ivev_tbl_type);
169
170 PROCEDURE lock_index_values(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_ivev_rec IN ivev_rec_type);
177
178 PROCEDURE update_index_values(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_ivev_tbl IN ivev_tbl_type,
185 x_ivev_tbl OUT NOCOPY ivev_tbl_type);
186
187 PROCEDURE update_index_values(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_ivev_rec IN ivev_rec_type,
194 x_ivev_rec OUT NOCOPY ivev_rec_type);
195
196 PROCEDURE delete_index_values(
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_ivev_tbl IN ivev_tbl_type);
203
204 PROCEDURE delete_index_values(
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_ivev_rec IN ivev_rec_type);
211
212 PROCEDURE validate_index_values(
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_ivev_tbl IN ivev_tbl_type);
219
220 PROCEDURE validate_index_values(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_ivev_rec IN ivev_rec_type);
227
228 END OKL_INDICES_PVT;