[Home] [Help]
PACKAGE: APPS.OKL_STY_PVT
Source
1 Package OKL_STY_PVT AS
2 /* $Header: OKLSSTYS.pls 120.4 2008/01/29 17:08:54 gkadarka noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE sty_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 version OKL_STRM_TYPE_B.VERSION%TYPE := OKC_API.G_MISS_CHAR,
9 code OKL_STRM_TYPE_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
10 -- customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11 customization_level OKL_STRM_TYPE_B.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
12 -- stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
13 stream_type_scope OKL_STRM_TYPE_B.STREAM_TYPE_SCOPE%TYPE := 'BOTH',
14 object_version_number NUMBER := OKC_API.G_MISS_NUM,
15 accrual_yn OKL_STRM_TYPE_B.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
16 taxable_default_yn OKL_STRM_TYPE_B.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
17 -- stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
18 stream_type_class OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
19 stream_type_subclass OKL_STRM_TYPE_B.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
20 start_date OKL_STRM_TYPE_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
21 end_date OKL_STRM_TYPE_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
22 billable_yn OKL_STRM_TYPE_B.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
23 capitalize_yn OKL_STRM_TYPE_B.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
24 -- periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
25 periodic_yn OKL_STRM_TYPE_B.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
26 -- fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
27 fundable_yn OKL_STRM_TYPE_B.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
28 -- mvasudev , 05/13/2002
29 -- allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
30 allocation_factor OKL_STRM_TYPE_B.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
31 --
32 attribute_category OKL_STRM_TYPE_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
33 attribute1 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34 attribute2 OKL_STRM_TYPE_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
35 attribute3 OKL_STRM_TYPE_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
36 attribute4 OKL_STRM_TYPE_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
37 attribute5 OKL_STRM_TYPE_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
38 attribute6 OKL_STRM_TYPE_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
39 attribute7 OKL_STRM_TYPE_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
40 attribute8 OKL_STRM_TYPE_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
41 attribute9 OKL_STRM_TYPE_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
42 attribute10 OKL_STRM_TYPE_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
43 attribute11 OKL_STRM_TYPE_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
44 attribute12 OKL_STRM_TYPE_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
45 attribute13 OKL_STRM_TYPE_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
46 attribute14 OKL_STRM_TYPE_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
47 attribute15 OKL_STRM_TYPE_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
48 created_by NUMBER := OKC_API.G_MISS_NUM,
49 creation_date OKL_STRM_TYPE_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
50 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
51 last_update_date OKL_STRM_TYPE_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
52 last_update_login NUMBER := OKC_API.G_MISS_NUM,
53 -- Added by RGOOTY for ER 3935682: Start
54 stream_type_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE := OKC_API.G_MISS_CHAR,
55 contingency OKL_STRM_TYPE_B.CONTINGENCY%TYPE := OKC_API.G_MISS_CHAR,
56 -- Added by RGOOTY for ER 3935682: End
57
58 -- Added by SNANDIKO for Bug 6744584 Start
59 contingency_id OKL_STRM_TYPE_B.CONTINGENCY_ID%TYPE := OKC_API.G_MISS_NUM );
60 -- Added by SNANDIKO for Bug 6744584 End
61 g_miss_sty_rec sty_rec_type;
62 TYPE sty_tbl_type IS TABLE OF sty_rec_type
63 INDEX BY BINARY_INTEGER;
64 TYPE okl_strm_type_tl_rec_type IS RECORD (
65
66 id NUMBER := OKC_API.G_MISS_NUM,
67 language OKL_STRM_TYPE_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
68 source_lang OKL_STRM_TYPE_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
69 sfwt_flag OKL_STRM_TYPE_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
70 name OKL_STRM_TYPE_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
71 description OKL_STRM_TYPE_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72 created_by NUMBER := OKC_API.G_MISS_NUM,
73 creation_date OKL_STRM_TYPE_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75 last_update_date OKL_STRM_TYPE_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76 last_update_login NUMBER := OKC_API.G_MISS_NUM,
77 -- Added by RGOOTY for ER 3935682: Start
78 short_description OKL_STRM_TYPE_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR
79 -- Added by RGOOTY for ER 3935682: End
80 );
81 g_miss_okl_strm_type_tl_rec okl_strm_type_tl_rec_type;
82 TYPE okl_strm_type_tl_tbl_type IS TABLE OF okl_strm_type_tl_rec_type
83 INDEX BY BINARY_INTEGER;
84 TYPE styv_rec_type IS RECORD (
85 id NUMBER := OKC_API.G_MISS_NUM,
86 name OKL_STRM_TYPE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
87 version OKL_STRM_TYPE_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
88 object_version_number NUMBER := OKC_API.G_MISS_NUM,
89 code OKL_STRM_TYPE_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
90 sfwt_flag OKL_STRM_TYPE_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
91 -- stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := OKC_API.G_MISS_CHAR,
92 stream_type_scope OKL_STRM_TYPE_V.STREAM_TYPE_SCOPE%TYPE := 'BOTH', -- Modified by RGOOTY for ER 3935682
93 description OKL_STRM_TYPE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94 start_date OKL_STRM_TYPE_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95 end_date OKL_STRM_TYPE_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96 billable_yn OKL_STRM_TYPE_V.BILLABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
97 taxable_default_yn OKL_STRM_TYPE_V.TAXABLE_DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR,
98 -- customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
99 customization_level OKL_STRM_TYPE_V.CUSTOMIZATION_LEVEL%TYPE := 'S', -- Modified by RGOOTY for ER 3935682
100 -- stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
101 stream_type_class OKL_STRM_TYPE_V.STREAM_TYPE_CLASS%TYPE := 'GENERAL', -- Modified by RGOOTY for ER 3935682
102 stream_type_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE := OKC_API.G_MISS_CHAR,
103 accrual_yn OKL_STRM_TYPE_V.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
104 capitalize_yn OKL_STRM_TYPE_V.CAPITALIZE_YN%TYPE := OKC_API.G_MISS_CHAR,
105 -- periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := OKC_API.G_MISS_CHAR,
106 periodic_yn OKL_STRM_TYPE_V.PERIODIC_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
107 -- fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
108 fundable_yn OKL_STRM_TYPE_V.FUNDABLE_YN%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
109 -- mvasudev , 05/13/2002
110 -- allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := OKC_API.G_MISS_CHAR,
111 allocation_factor OKL_STRM_TYPE_V.ALLOCATION_FACTOR%TYPE := NULL, -- Modified by RGOOTY for ER 3935682
112 --
113 attribute_category OKL_STRM_TYPE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
114 attribute1 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
115 attribute2 OKL_STRM_TYPE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
116 attribute3 OKL_STRM_TYPE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
117 attribute4 OKL_STRM_TYPE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
118 attribute5 OKL_STRM_TYPE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
119 attribute6 OKL_STRM_TYPE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
120 attribute7 OKL_STRM_TYPE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
121 attribute8 OKL_STRM_TYPE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
122 attribute9 OKL_STRM_TYPE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
123 attribute10 OKL_STRM_TYPE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
124 attribute11 OKL_STRM_TYPE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
125 attribute12 OKL_STRM_TYPE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
126 attribute13 OKL_STRM_TYPE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
127 attribute14 OKL_STRM_TYPE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
128 attribute15 OKL_STRM_TYPE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
129 created_by NUMBER := OKC_API.G_MISS_NUM,
130 creation_date OKL_STRM_TYPE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132 last_update_date OKL_STRM_TYPE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133 last_update_login NUMBER := OKC_API.G_MISS_NUM,
134 -- Added by RGOOTY for ER 3935682: Start
135 stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE := OKC_API.G_MISS_CHAR,
136 contingency OKL_STRM_TYPE_V.contingency%TYPE := OKC_API.G_MISS_CHAR,
137 short_description OKL_STRM_TYPE_V.short_description%TYPE := OKC_API.G_MISS_CHAR,
138 -- Added by RGOOTY for ER 3935682: End
139
140 -- Added by SNANDIKO for Bug 6744584 Start
141 contingency_id OKL_STRM_TYPE_V.contingency_id%TYPE := OKC_API.G_MISS_NUM
142 );
143 -- Added by SNANDIKO for Bug 6744584 End
144 g_miss_styv_rec styv_rec_type;
145 TYPE styv_tbl_type IS TABLE OF styv_rec_type
146 INDEX BY BINARY_INTEGER;
147 ---------------------------------------------------------------------------
148 -- GLOBAL MESSAGE CONSTANTS
149 ---------------------------------------------------------------------------
150 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
151 G_OKC_APP CONSTANT VARCHAR2(200) := OKC_API.G_APP_NAME;
152 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
153 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
154 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
155 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
156 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
157 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
158 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
159 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
160 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
161 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_CONTRACTS_UNEXPECTED_ERROR';
162 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
163 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
164 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_STY_NOT_UNIQUE';
165
166 ---------------------------------------------------------------------------
167 -- GLOBAL VARIABLES
168 ---------------------------------------------------------------------------
169 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_STY_PVT';
170 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
171
172 ---------------------------------------------------------------------------
173 -- GLOBAL EXCEPTIONS
174 ---------------------------------------------------------------------------
175
176 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
177 ---------------------------------------------------------------------------
178
179 ---------------------------------------------------------------------------
180 -- Procedures and Functions
181 ---------------------------------------------------------------------------
182
183 PROCEDURE qc;
184 PROCEDURE change_version;
185 PROCEDURE api_copy;
186 PROCEDURE add_language;
187 PROCEDURE insert_row(
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_styv_rec IN styv_rec_type,
194 x_styv_rec OUT NOCOPY styv_rec_type);
195
196 PROCEDURE insert_row(
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_styv_tbl IN styv_tbl_type,
203 x_styv_tbl OUT NOCOPY styv_tbl_type);
204
205 PROCEDURE lock_row(
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_styv_rec IN styv_rec_type);
212
213 PROCEDURE lock_row(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_styv_tbl IN styv_tbl_type);
220
221 PROCEDURE update_row(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_styv_rec IN styv_rec_type,
228 x_styv_rec OUT NOCOPY styv_rec_type);
229
230 PROCEDURE update_row(
231 p_api_version IN NUMBER,
232 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_styv_tbl IN styv_tbl_type,
237 x_styv_tbl OUT NOCOPY styv_tbl_type);
238
239 PROCEDURE delete_row(
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_styv_rec IN styv_rec_type);
246
247 PROCEDURE delete_row(
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_styv_tbl IN styv_tbl_type);
254
255 PROCEDURE validate_row(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_styv_rec IN styv_rec_type);
262
263 PROCEDURE validate_row(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_styv_tbl IN styv_tbl_type);
270
271 PROCEDURE LOAD_SEED_ROW(
272 p_upload_mode IN VARCHAR2,
273 p_id IN VARCHAR2,
274 p_version IN VARCHAR2,
275 p_code IN VARCHAR2,
276 p_customization_level IN VARCHAR2,
277 p_stream_type_scope IN VARCHAR2,
278 p_object_version_number IN VARCHAR2,
279 p_accrual_yn IN VARCHAR2,
280 p_taxable_default_yn IN VARCHAR2,
281 p_stream_type_class IN VARCHAR2,
282 p_stream_type_subclass IN VARCHAR2,
283 p_start_date IN VARCHAR2,
284 p_end_date IN VARCHAR2,
285 p_billable_yn IN VARCHAR2,
286 p_capitalize_yn IN VARCHAR2,
287 p_periodic_yn IN VARCHAR2,
288 p_fundable_yn IN VARCHAR2,
289 p_allocation_factor IN VARCHAR2,
290 p_attribute_category IN VARCHAR2,
291 p_attribute1 IN VARCHAR2,
292 p_attribute2 IN VARCHAR2,
293 p_attribute3 IN VARCHAR2,
294 p_attribute4 IN VARCHAR2,
295 p_attribute5 IN VARCHAR2,
296 p_attribute6 IN VARCHAR2,
297 p_attribute7 IN VARCHAR2,
298 p_attribute8 IN VARCHAR2,
299 p_attribute9 IN VARCHAR2,
300 p_attribute10 IN VARCHAR2,
301 p_attribute11 IN VARCHAR2,
302 p_attribute12 IN VARCHAR2,
303 p_attribute13 IN VARCHAR2,
304 p_attribute14 IN VARCHAR2,
305 p_attribute15 IN VARCHAR2,
306 p_stream_type_purpose IN VARCHAR2,
307 p_contingency IN VARCHAR2,
308 p_name IN VARCHAR2,
309 p_description IN VARCHAR2,
310 p_owner IN VARCHAR2,
311 p_last_update_date IN VARCHAR2,
312 -- Added by SNANDIKO for Bug 6744584 Start
313 p_contingency_id IN VARCHAR2
314 -- Added by SNANDIKO for Bug 6744584 End
315 );
316
317 END OKL_STY_PVT;