[Home] [Help]
PACKAGE: APPS.OKL_PROCESS_TMPT_SET_PVT
Source
1 PACKAGE OKL_PROCESS_TMPT_SET_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRTMSS.pls 120.3 2005/10/30 04:39:11 appldev noship $ */
3 -- Global Variables
4 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
5 G_DATES_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_DATES_MISMATCH';
6 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
7 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
8 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
9 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
10 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
11 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_SETUP_PRICEPARMS_PVT';
12 G_MISS_NUM CONSTANT NUMBER := OKL_API.G_MISS_NUM;
13 G_MISS_CHAR CONSTANT VARCHAR2(1) := OKL_API.G_MISS_CHAR;
14 G_MISS_DATE CONSTANT DATE := OKL_API.G_MISS_DATE;
15 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
16 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
17 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
18 G_EXC_NAME_RET_STS_ERR CONSTANT VARCHAR(25) := 'OKL_API.G_RET_STS_ERROR';
19 G_EXC_NAME_RET_STS_UNEXP_ERR CONSTANT VARCHAR(30) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
20 G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
21 G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
22 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
23 G_START_DATE CONSTANT VARCHAR2(200) := 'OKL_START_DATE';
24 G_END_DATE CONSTANT VARCHAR2(200) := 'OKL_END_DATE';
25 G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
26 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27
28 G_EXCEPTION_HALT_PROCESSING EXCEPTION;
29 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
30 G_EXCEPTION_ERROR EXCEPTION;
31
32 G_PAST_RECORDS CONSTANT VARCHAR2(200) := 'OKL_PAST_RECORDS';
33 G_TRUE CONSTANT VARCHAR2(1) := OKL_API.G_TRUE;
34 G_FALSE CONSTANT VARCHAR2(1) := OKL_API.G_FALSE;
35
36 SUBTYPE aesv_rec_type IS okl_tmpt_set_pub.aesv_rec_type;
37 SUBTYPE aesv_tbl_type IS okl_tmpt_set_pub.aesv_tbl_type;
38 SUBTYPE avlv_rec_type IS okl_tmpt_set_pub.avlv_rec_type;
39 SUBTYPE avlv_tbl_type IS okl_tmpt_set_pub.avlv_tbl_type;
40 SUBTYPE atlv_rec_type IS okl_tmpt_set_pub.atlv_rec_type;
41 SUBTYPE atlv_tbl_type IS okl_tmpt_set_pub.atlv_tbl_type;
42
43
44 PROCEDURE create_tmpt_set(
45 p_api_version IN NUMBER
46 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 ,p_aesv_rec IN aesv_rec_type
51 ,p_avlv_tbl IN avlv_tbl_type
52 ,p_atlv_tbl IN atlv_tbl_type
53 ,x_aesv_rec OUT NOCOPY aesv_rec_type
54 ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
55 ,x_atlv_tbl OUT NOCOPY atlv_tbl_type );
56
57 --Object type procedure for update
58 PROCEDURE update_tmpt_set(
59 p_api_version IN NUMBER
60 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 ,p_aesv_rec IN aesv_rec_type
65 ,p_avlv_tbl IN avlv_tbl_type
66 ,p_atlv_tbl IN atlv_tbl_type
67 ,x_aesv_rec OUT NOCOPY aesv_rec_type
68 ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
69 ,x_atlv_tbl OUT NOCOPY atlv_tbl_type );
70
71 PROCEDURE create_tmpt_set(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_aesv_tbl IN aesv_tbl_type,
78 x_aesv_tbl OUT NOCOPY aesv_tbl_type);
79
80 PROCEDURE create_tmpt_set(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_aesv_rec IN aesv_rec_type,
87 x_aesv_rec OUT NOCOPY aesv_rec_type,
88 p_aes_source_id IN OKL_AE_TMPT_SETS.id%TYPE DEFAULT NULL);
89
90 PROCEDURE update_tmpt_set(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_aesv_tbl IN aesv_tbl_type,
97 x_aesv_tbl OUT NOCOPY aesv_tbl_type);
98
99 PROCEDURE update_tmpt_set(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_aesv_rec IN aesv_rec_type,
106 x_aesv_rec OUT NOCOPY aesv_rec_type);
107
108 PROCEDURE delete_tmpt_set(
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_aesv_tbl IN aesv_tbl_type);
115
116 PROCEDURE delete_tmpt_set(
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_aesv_rec IN aesv_rec_type);
123
124 PROCEDURE create_template(
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_avlv_tbl IN avlv_tbl_type,
131 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
132
133 PROCEDURE create_template(
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_avlv_rec IN avlv_rec_type,
140 x_avlv_rec OUT NOCOPY avlv_rec_type);
141
142 PROCEDURE update_template(
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_avlv_tbl IN avlv_tbl_type,
149 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
150
151 PROCEDURE update_template(
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_avlv_rec IN avlv_rec_type,
158 x_avlv_rec OUT NOCOPY avlv_rec_type);
159
160 PROCEDURE delete_template(
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_avlv_tbl IN avlv_tbl_type);
167
168 PROCEDURE delete_template(
169 p_api_version IN NUMBER,
170 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171 x_return_status OUT NOCOPY VARCHAR2,
172 x_msg_count OUT NOCOPY NUMBER,
173 x_msg_data OUT NOCOPY VARCHAR2,
174 p_avlv_rec IN avlv_rec_type);
175
176 PROCEDURE create_tmpt_lines(
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_atlv_tbl IN atlv_tbl_type,
183 x_atlv_tbl OUT NOCOPY atlv_tbl_type);
184
185 PROCEDURE create_tmpt_lines(
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_atlv_rec IN atlv_rec_type,
192 x_atlv_rec OUT NOCOPY atlv_rec_type);
193
194 PROCEDURE update_tmpt_lines(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_atlv_tbl IN atlv_tbl_type,
201 x_atlv_tbl OUT NOCOPY atlv_tbl_type);
202
203 PROCEDURE update_tmpt_lines(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_atlv_rec IN atlv_rec_type,
210 x_atlv_rec OUT NOCOPY atlv_rec_type);
211
212 PROCEDURE delete_tmpt_lines(
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_atlv_tbl IN atlv_tbl_type);
219
220 PROCEDURE delete_tmpt_lines(
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_atlv_rec IN atlv_rec_type);
227
228 -- mvasudev -- 02/13/2002
229 PROCEDURE copy_tmpl_set(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_aes_id_from IN NUMBER,
236 p_aes_id_to IN NUMBER);
237
238
239 PROCEDURE copy_template(
240 p_api_version IN NUMBER,
241 p_init_msg_list IN VARCHAR2,
242 x_return_status OUT NOCOPY VARCHAR2,
243 x_msg_count OUT NOCOPY NUMBER,
244 x_msg_data OUT NOCOPY VARCHAR2,
245 p_avlv_rec IN avlv_rec_type,
246 p_source_tmpl_id IN NUMBER,
247 x_avlv_rec OUT NOCOPY avlv_rec_type);
248 --end, mvasudev -- 02/13/2002
249
250 --kmotepal ER# 3944429
251 PROCEDURE validate_gts_id (p_gts_id IN NUMBER
252 ,x_return_status OUT NOCOPY VARCHAR2);
253
254 END OKL_PROCESS_TMPT_SET_PVT;