[Home] [Help]
PACKAGE: APPS.OKC_IMP_TERMS_TEMPLATES_PVT
Source
1 PACKAGE okc_imp_terms_templates_pvt AUTHID CURRENT_USER AS
2 /*$Header: OKCVITTS.pls 120.2.12020000.3 2013/02/11 14:45:33 nbingi ship $*/
3 ------------------------------------------------------------------------------
4 -- GLOBAL VARIABLES
5 ------------------------------------------------------------------------------
6 g_pkg_name CONSTANT VARCHAR2 (200)
7 := 'OKC_IMP_TERMS_TEMPLATES_PVT';
8 g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
9 ------------------------------------------------------------------------------
10 -- GLOBAL CONSTANTS
11 ------------------------------------------------------------------------------
12 g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
13 g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
14 g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
15 g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
16 g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
17 := fnd_api.g_ret_sts_unexp_error;
18
19 TYPE terms_template_rec_type IS RECORD (
20 template_id okc_terms_templates_all.template_id%TYPE
21 := okc_api.g_miss_num,
22 template_name okc_terms_templates_all.template_name%TYPE
23 := okc_api.g_miss_char,
24 intent okc_terms_templates_all.intent%TYPE
25 := okc_api.g_miss_char,
26 status_code okc_terms_templates_all.status_code%TYPE
27 := okc_api.g_miss_char,
28 start_date okc_terms_templates_all.start_date%TYPE
29 := okc_api.g_miss_date,
30 end_date okc_terms_templates_all.end_date%TYPE
31 := okc_api.g_miss_date,
32 global_flag okc_terms_templates_all.global_flag%TYPE
33 := okc_api.g_miss_char,
34 instruction_text okc_terms_templates_all.instruction_text%TYPE
35 := okc_api.g_miss_char,
36 description okc_terms_templates_all.description%TYPE
37 := okc_api.g_miss_char,
38 working_copy_flag okc_terms_templates_all.working_copy_flag%TYPE
39 := okc_api.g_miss_char,
40 parent_template_id okc_terms_templates_all.parent_template_id%TYPE
41 := okc_api.g_miss_num,
42 contract_expert_enabled okc_terms_templates_all.contract_expert_enabled%TYPE
43 := okc_api.g_miss_char,
44 template_model_id okc_terms_templates_all.template_model_id%TYPE
45 := okc_api.g_miss_num,
46 tmpl_numbering_scheme okc_terms_templates_all.tmpl_numbering_scheme%TYPE
47 := okc_api.g_miss_num,
48 print_template_id okc_terms_templates_all.print_template_id%TYPE
49 := okc_api.g_miss_num,
50 approval_wf_key okc_terms_templates_all.approval_wf_key%TYPE
51 := okc_api.g_miss_char,
52 cz_export_wf_key okc_terms_templates_all.cz_export_wf_key%TYPE
53 := okc_api.g_miss_char,
54 last_update_login NUMBER := okc_api.g_miss_num,
55 creation_date DATE := okc_api.g_miss_date,
56 created_by NUMBER := okc_api.g_miss_num,
57 last_updated_by NUMBER := okc_api.g_miss_num,
58 last_update_date DATE := okc_api.g_miss_date,
59 org_id okc_terms_templates_all.org_id%TYPE
60 := okc_api.g_miss_num,
61 orig_system_reference_code okc_terms_templates_all.orig_system_reference_code%TYPE
62 := okc_api.g_miss_char,
63 orig_system_reference_id1 okc_terms_templates_all.orig_system_reference_id1%TYPE
64 := okc_api.g_miss_num,
65 orig_system_reference_id2 okc_terms_templates_all.orig_system_reference_id2%TYPE
66 := okc_api.g_miss_num,
67 object_version_number NUMBER := okc_api.g_miss_num,
68 hide_yn okc_terms_templates_all.hide_yn%TYPE
69 := okc_api.g_miss_char,
70 attribute_category okc_terms_templates_all.attribute_category%TYPE
71 := okc_api.g_miss_char,
72 attribute1 okc_terms_templates_all.attribute1%TYPE
73 := okc_api.g_miss_char,
74 attribute2 okc_terms_templates_all.attribute2%TYPE
75 := okc_api.g_miss_char,
76 attribute3 okc_terms_templates_all.attribute3%TYPE
77 := okc_api.g_miss_char,
78 attribute4 okc_terms_templates_all.attribute4%TYPE
79 := okc_api.g_miss_char,
80 attribute5 okc_terms_templates_all.attribute5%TYPE
81 := okc_api.g_miss_char,
82 attribute6 okc_terms_templates_all.attribute6%TYPE
83 := okc_api.g_miss_char,
84 attribute7 okc_terms_templates_all.attribute7%TYPE
85 := okc_api.g_miss_char,
86 attribute8 okc_terms_templates_all.attribute8%TYPE
87 := okc_api.g_miss_char,
88 attribute9 okc_terms_templates_all.attribute9%TYPE
89 := okc_api.g_miss_char,
90 attribute10 okc_terms_templates_all.attribute10%TYPE
91 := okc_api.g_miss_char,
92 attribute11 okc_terms_templates_all.attribute11%TYPE
93 := okc_api.g_miss_char,
94 attribute12 okc_terms_templates_all.attribute12%TYPE
95 := okc_api.g_miss_char,
96 attribute13 okc_terms_templates_all.attribute13%TYPE
97 := okc_api.g_miss_char,
98 attribute14 okc_terms_templates_all.attribute14%TYPE
99 := okc_api.g_miss_char,
100 attribute15 okc_terms_templates_all.attribute15%TYPE
101 := okc_api.g_miss_char,
102 xprt_request_id NUMBER := okc_api.g_miss_num,
103 xprt_clause_mandatory_flag okc_terms_templates_all.xprt_clause_mandatory_flag%TYPE
104 := okc_api.g_miss_char,
105 xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE
106 := okc_api.g_miss_char,
107 LANGUAGE okc_terms_templates_all.LANGUAGE%TYPE
108 := okc_api.g_miss_char,
109 translated_from_tmpl_id okc_terms_templates_all.translated_from_tmpl_id%TYPE
110 := okc_api.g_miss_num,
111 status VARCHAR2 (1),
112 errmsg VARCHAR2 (2500)
113 );
114
115 TYPE terms_template_tbl_type IS TABLE OF terms_template_rec_type
116 INDEX BY PLS_INTEGER;
117
118 TYPE tmpl_usage_rec_type IS RECORD (
119 allowed_tmpl_usages_id okc_allowed_tmpl_usages.allowed_tmpl_usages_id%TYPE
120 := okc_api.g_miss_num,
121
122 document_type okc_allowed_tmpl_usages.document_type%TYPE
123 := okc_api.g_miss_char,
124 default_yn okc_allowed_tmpl_usages.default_yn%TYPE
125 := okc_api.g_miss_char,
126 last_update_login NUMBER := okc_api.g_miss_num,
127 creation_date DATE := okc_api.g_miss_date,
128 created_by NUMBER := okc_api.g_miss_num,
129 last_updated_by NUMBER := okc_api.g_miss_num,
130 last_update_date DATE := okc_api.g_miss_date,
131 object_version_number NUMBER := okc_api.g_miss_num,
132 attribute_category okc_allowed_tmpl_usages.attribute_category%TYPE
133 := okc_api.g_miss_char,
134 attribute1 okc_allowed_tmpl_usages.attribute1%TYPE
135 := okc_api.g_miss_char,
136 attribute2 okc_allowed_tmpl_usages.attribute2%TYPE
137 := okc_api.g_miss_char,
138 attribute3 okc_allowed_tmpl_usages.attribute3%TYPE
139 := okc_api.g_miss_char,
140 attribute4 okc_allowed_tmpl_usages.attribute4%TYPE
141 := okc_api.g_miss_char,
142 attribute5 okc_allowed_tmpl_usages.attribute5%TYPE
143 := okc_api.g_miss_char,
144 attribute6 okc_allowed_tmpl_usages.attribute6%TYPE
145 := okc_api.g_miss_char,
146 attribute7 okc_allowed_tmpl_usages.attribute7%TYPE
147 := okc_api.g_miss_char,
148 attribute8 okc_allowed_tmpl_usages.attribute8%TYPE
149 := okc_api.g_miss_char,
150 attribute9 okc_allowed_tmpl_usages.attribute9%TYPE
151 := okc_api.g_miss_char,
152 attribute10 okc_allowed_tmpl_usages.attribute10%TYPE
153 := okc_api.g_miss_char,
154 attribute11 okc_allowed_tmpl_usages.attribute11%TYPE
155 := okc_api.g_miss_char,
156 attribute12 okc_allowed_tmpl_usages.attribute12%TYPE
157 := okc_api.g_miss_char,
158 attribute13 okc_allowed_tmpl_usages.attribute13%TYPE
159 := okc_api.g_miss_char,
160 attribute14 okc_allowed_tmpl_usages.attribute14%TYPE
161 := okc_api.g_miss_char,
162 attribute15 okc_allowed_tmpl_usages.attribute15%TYPE
163 := okc_api.g_miss_char,
164 status VARCHAR2 (1),
165 errmsg VARCHAR2 (2500)
166 );
167
168 TYPE tmpl_usage_tbl_type IS TABLE OF tmpl_usage_rec_type
169 INDEX BY PLS_INTEGER;
170
171 TYPE section_rec_type IS RECORD (
172 ID okc_sections_b.ID%TYPE
173 := okc_api.g_miss_num,
174 scn_type okc_sections_b.scn_type%TYPE
175 := okc_api.g_miss_char,
176 chr_id okc_sections_b.chr_id%TYPE
177 := okc_api.g_miss_num,
178 sat_code okc_sections_b.sat_code%TYPE
179 := okc_api.g_miss_char,
180 section_sequence okc_sections_b.section_sequence%TYPE
181 := okc_api.g_miss_num,
182 object_version_number NUMBER := okc_api.g_miss_num,
183 created_by NUMBER := okc_api.g_miss_num,
184 creation_date okc_sections_b.creation_date%TYPE
185 := okc_api.g_miss_date,
186 last_updated_by NUMBER := okc_api.g_miss_num,
187 last_update_date okc_sections_b.last_update_date%TYPE
188 := okc_api.g_miss_date,
189 last_update_login NUMBER := okc_api.g_miss_num,
190 label okc_sections_b.label%TYPE
191 := okc_api.g_miss_char,
192 scn_id okc_sections_b.scn_id%TYPE
193 := okc_api.g_miss_num,
194 attribute_category okc_sections_b.attribute_category%TYPE
195 := okc_api.g_miss_char,
196 attribute1 okc_sections_b.attribute1%TYPE
197 := okc_api.g_miss_char,
198 attribute2 okc_sections_b.attribute2%TYPE
199 := okc_api.g_miss_char,
200 attribute3 okc_sections_b.attribute3%TYPE
201 := okc_api.g_miss_char,
202 attribute4 okc_sections_b.attribute4%TYPE
203 := okc_api.g_miss_char,
204 attribute5 okc_sections_b.attribute5%TYPE
205 := okc_api.g_miss_char,
206 attribute6 okc_sections_b.attribute6%TYPE
207 := okc_api.g_miss_char,
208 attribute7 okc_sections_b.attribute7%TYPE
209 := okc_api.g_miss_char,
210 attribute8 okc_sections_b.attribute8%TYPE
211 := okc_api.g_miss_char,
212 attribute9 okc_sections_b.attribute9%TYPE
213 := okc_api.g_miss_char,
214 attribute10 okc_sections_b.attribute10%TYPE
215 := okc_api.g_miss_char,
216 attribute11 okc_sections_b.attribute11%TYPE
217 := okc_api.g_miss_char,
218 attribute12 okc_sections_b.attribute12%TYPE
219 := okc_api.g_miss_char,
220 attribute13 okc_sections_b.attribute13%TYPE
221 := okc_api.g_miss_char,
222 attribute14 okc_sections_b.attribute14%TYPE
223 := okc_api.g_miss_char,
224 attribute15 okc_sections_b.attribute15%TYPE
225 := okc_api.g_miss_char,
226 security_group_id okc_sections_b.security_group_id%TYPE
227 := okc_api.g_miss_num,
228 old_id okc_sections_b.old_id%TYPE
229 := okc_api.g_miss_num,
230 document_type okc_sections_b.document_type%TYPE
231 := okc_api.g_miss_char,
232 document_id okc_sections_b.document_id%TYPE
233 := okc_api.g_miss_num,
234 scn_code okc_sections_b.scn_code%TYPE
235 := okc_api.g_miss_char,
236 description okc_sections_b.description%TYPE
237 := okc_api.g_miss_char,
238 amendment_description okc_sections_b.amendment_description%TYPE
239 := okc_api.g_miss_char,
240 amendment_operation_code okc_sections_b.amendment_operation_code%TYPE
241 := okc_api.g_miss_char,
242 orig_system_reference_code okc_sections_b.orig_system_reference_code%TYPE
243 := okc_api.g_miss_char,
244 orig_system_reference_id1 okc_sections_b.orig_system_reference_id1%TYPE
245 := okc_api.g_miss_num,
246 orig_system_reference_id2 okc_sections_b.orig_system_reference_id2%TYPE
250 summary_amend_operation_code okc_sections_b.summary_amend_operation_code%TYPE
247 := okc_api.g_miss_num,
248 print_yn okc_sections_b.print_yn%TYPE
249 := okc_api.g_miss_char,
251 := okc_api.g_miss_char,
252 heading okc_sections_b.heading%TYPE
253 := okc_api.g_miss_char,
254 last_amended_by okc_sections_b.last_amended_by%TYPE
255 := okc_api.g_miss_num,
256 last_amendment_date okc_sections_b.last_amendment_date%TYPE
257 := okc_api.g_miss_date,
258 status VARCHAR2 (1),
259 errmsg VARCHAR2 (2500)
260 );
261
262 TYPE section_tbl_type IS TABLE OF section_rec_type
263 INDEX BY PLS_INTEGER;
264
265 TYPE k_article_rec_type IS RECORD (
266 ID okc_k_articles_b.ID%TYPE
267 := okc_api.g_miss_num,
268 sav_sae_id okc_k_articles_b.sav_sae_id%TYPE
269 := okc_api.g_miss_num,
270 sav_sav_release okc_k_articles_b.sav_sav_release%TYPE
271 := okc_api.g_miss_char,
272 sbt_code okc_k_articles_b.sbt_code%TYPE
273 := okc_api.g_miss_char,
274 cat_type okc_k_articles_b.cat_type%TYPE
275 := okc_api.g_miss_char,
276 chr_id okc_k_articles_b.chr_id%TYPE
277 := okc_api.g_miss_num,
278 cle_id okc_k_articles_b.cle_id%TYPE
279 := okc_api.g_miss_num,
280 cat_id okc_k_articles_b.cat_id%TYPE
281 := okc_api.g_miss_num,
282 dnz_chr_id okc_k_articles_b.dnz_chr_id%TYPE
283 := okc_api.g_miss_num,
284 object_version_number NUMBER := okc_api.g_miss_num,
285 created_by NUMBER := okc_api.g_miss_num,
286 creation_date okc_k_articles_b.creation_date%TYPE
287 := okc_api.g_miss_date,
288 last_updated_by NUMBER := okc_api.g_miss_num,
289 last_update_date okc_k_articles_b.last_update_date%TYPE
290 := okc_api.g_miss_date,
291 fulltext_yn okc_k_articles_b.fulltext_yn%TYPE
292 := okc_api.g_miss_char,
293 last_update_login NUMBER := okc_api.g_miss_num,
294 attribute_category okc_k_articles_b.attribute_category%TYPE
295 := okc_api.g_miss_char,
296 attribute1 okc_k_articles_b.attribute1%TYPE
297 := okc_api.g_miss_char,
298 attribute2 okc_k_articles_b.attribute2%TYPE
299 := okc_api.g_miss_char,
300 attribute3 okc_k_articles_b.attribute3%TYPE
301 := okc_api.g_miss_char,
302 attribute4 okc_k_articles_b.attribute4%TYPE
303 := okc_api.g_miss_char,
304 attribute5 okc_k_articles_b.attribute5%TYPE
305 := okc_api.g_miss_char,
306 attribute6 okc_k_articles_b.attribute6%TYPE
307 := okc_api.g_miss_char,
308 attribute7 okc_k_articles_b.attribute7%TYPE
309 := okc_api.g_miss_char,
310 attribute8 okc_k_articles_b.attribute8%TYPE
311 := okc_api.g_miss_char,
312 attribute9 okc_k_articles_b.attribute9%TYPE
313 := okc_api.g_miss_char,
314 attribute10 okc_k_articles_b.attribute10%TYPE
315 := okc_api.g_miss_char,
316 attribute11 okc_k_articles_b.attribute11%TYPE
317 := okc_api.g_miss_char,
318 attribute12 okc_k_articles_b.attribute12%TYPE
319 := okc_api.g_miss_char,
320 attribute13 okc_k_articles_b.attribute13%TYPE
321 := okc_api.g_miss_char,
322 attribute14 okc_k_articles_b.attribute14%TYPE
323 := okc_api.g_miss_char,
324 attribute15 okc_k_articles_b.attribute15%TYPE
325 := okc_api.g_miss_char,
326 security_group_id okc_k_articles_b.security_group_id%TYPE
327 := okc_api.g_miss_num,
328 old_id okc_k_articles_b.old_id%TYPE
329 := okc_api.g_miss_num,
330 document_type okc_k_articles_b.document_type%TYPE
334 source_flag okc_k_articles_b.source_flag%TYPE
331 := okc_api.g_miss_char,
332 document_id okc_k_articles_b.document_id%TYPE
333 := okc_api.g_miss_num,
335 := okc_api.g_miss_char,
336 mandatory_yn okc_k_articles_b.mandatory_yn%TYPE
337 := okc_api.g_miss_char,
338 scn_id okc_k_articles_b.scn_id%TYPE
339 := okc_api.g_miss_num,
340 label okc_k_articles_b.label%TYPE
341 := okc_api.g_miss_char,
342 display_sequence okc_k_articles_b.display_sequence%TYPE
343 := okc_api.g_miss_num,
344 amendment_description okc_k_articles_b.amendment_description%TYPE
345 := okc_api.g_miss_char,
346 article_version_id okc_k_articles_b.article_version_id%TYPE
347 := okc_api.g_miss_num,
348 orig_system_reference_code okc_k_articles_b.orig_system_reference_code%TYPE
349 := okc_api.g_miss_char,
350 orig_system_reference_id1 okc_k_articles_b.orig_system_reference_id1%TYPE
351 := okc_api.g_miss_num,
352 orig_system_reference_id2 okc_k_articles_b.orig_system_reference_id2%TYPE
353 := okc_api.g_miss_num,
354 amendment_operation_code okc_k_articles_b.amendment_operation_code%TYPE
355 := okc_api.g_miss_char,
356 summary_amend_operation_code okc_k_articles_b.summary_amend_operation_code%TYPE
357 := okc_api.g_miss_char,
358 change_nonstd_yn okc_k_articles_b.change_nonstd_yn%TYPE
359 := okc_api.g_miss_char,
360 print_text_yn okc_k_articles_b.print_text_yn%TYPE
361 := okc_api.g_miss_char,
362 ref_article_id okc_k_articles_b.ref_article_id%TYPE
363 := okc_api.g_miss_num,
364 ref_article_version_id okc_k_articles_b.ref_article_version_id%TYPE
365 := okc_api.g_miss_num,
366 orig_article_id okc_k_articles_b.orig_article_id%TYPE
367 := okc_api.g_miss_num,
368 last_amended_by okc_k_articles_b.last_amended_by%TYPE
369 := okc_api.g_miss_num,
370 last_amendment_date okc_k_articles_b.last_amendment_date%TYPE
371 := okc_api.g_miss_date,
372 mandatory_rwa okc_k_articles_b.mandatory_rwa%TYPE
373 := okc_api.g_miss_char,
374 status VARCHAR2 (1),
375 errmsg VARCHAR2 (2500)
376 );
377
378 TYPE k_article_tbl_type IS TABLE OF k_article_rec_type
379 INDEX BY PLS_INTEGER;
380
381 TYPE deliverable_rec_type IS RECORD (
382 deliverable_id okc_deliverables.deliverable_id%TYPE
383 := okc_api.g_miss_num,
384 business_document_type okc_deliverables.business_document_type%TYPE
385 := okc_api.g_miss_char,
386 business_document_id okc_deliverables.business_document_id%TYPE
387 := okc_api.g_miss_num,
388 business_document_number okc_deliverables.business_document_number%TYPE
389 := okc_api.g_miss_char,
390 deliverable_type okc_deliverables.deliverable_type%TYPE
391 := okc_api.g_miss_char,
392 responsible_party okc_deliverables.responsible_party%TYPE
393 := okc_api.g_miss_char,
394 internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
395 := okc_api.g_miss_num,
396 external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
397 := okc_api.g_miss_num,
398 deliverable_name okc_deliverables.deliverable_name%TYPE
399 := okc_api.g_miss_char,
400 description okc_deliverables.description%TYPE
401 := okc_api.g_miss_char,
402 comments okc_deliverables.comments%TYPE
403 := okc_api.g_miss_char,
404 display_sequence okc_deliverables.display_sequence%TYPE
405 := okc_api.g_miss_num,
406 fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
407 := okc_api.g_miss_char,
408 actual_due_date okc_deliverables.actual_due_date%TYPE
409 := okc_api.g_miss_date,
410 print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
411 := okc_api.g_miss_char,
412 recurring_yn okc_deliverables.recurring_yn%TYPE
416 notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
413 := okc_api.g_miss_char,
414 notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
415 := okc_api.g_miss_num,
417 := okc_api.g_miss_char,
418 notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
419 := okc_api.g_miss_char,
420 notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
421 := okc_api.g_miss_char,
422 notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
423 := okc_api.g_miss_char,
424 notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
425 := okc_api.g_miss_char,
426 notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
427 := okc_api.g_miss_num,
428 notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
429 := okc_api.g_miss_char,
430 escalation_assignee okc_deliverables.escalation_assignee%TYPE
431 := okc_api.g_miss_num,
432 amendment_operation okc_deliverables.amendment_operation%TYPE
433 := okc_api.g_miss_char,
434 prior_notification_id okc_deliverables.prior_notification_id%TYPE
435 := okc_api.g_miss_num,
436 amendment_notes okc_deliverables.amendment_notes%TYPE
437 := okc_api.g_miss_char,
438 completed_notification_id okc_deliverables.completed_notification_id%TYPE
439 := okc_api.g_miss_num,
440 overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
441 := okc_api.g_miss_num,
442 escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
443 := okc_api.g_miss_num,
444 LANGUAGE okc_deliverables.LANGUAGE%TYPE
445 := okc_api.g_miss_char,
446 original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
447 := okc_api.g_miss_num,
448 requester_id okc_deliverables.requester_id%TYPE
449 := okc_api.g_miss_num,
450 external_party_id okc_deliverables.external_party_id%TYPE
451 := okc_api.g_miss_num,
452 recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
453 := okc_api.g_miss_num,
454 business_document_version okc_deliverables.business_document_version%TYPE
455 := okc_api.g_miss_num,
456 relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
457 := okc_api.g_miss_num,
458 relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
459 := okc_api.g_miss_char,
460 relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
461 := okc_api.g_miss_num,
462 relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
463 := okc_api.g_miss_num,
464 relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
465 := okc_api.g_miss_char,
466 relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
467 := okc_api.g_miss_num,
468 repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
469 := okc_api.g_miss_char,
470 repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
471 := okc_api.g_miss_char,
472 repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
473 := okc_api.g_miss_char,
474 repeating_duration okc_deliverables.repeating_duration%TYPE
475 := okc_api.g_miss_num,
476 fixed_start_date okc_deliverables.fixed_start_date%TYPE
477 := okc_api.g_miss_date,
478 fixed_end_date okc_deliverables.fixed_end_date%TYPE
479 := okc_api.g_miss_date,
480 manage_yn okc_deliverables.manage_yn%TYPE
481 := okc_api.g_miss_char,
482 internal_party_id okc_deliverables.internal_party_id%TYPE
483 := okc_api.g_miss_num,
484 deliverable_status okc_deliverables.deliverable_status%TYPE
485 := okc_api.g_miss_char,
486 status_change_notes okc_deliverables.status_change_notes%TYPE
487 := okc_api.g_miss_char,
488 created_by NUMBER := okc_api.g_miss_num,
492 last_update_date okc_deliverables.last_update_date%TYPE
489 creation_date okc_deliverables.creation_date%TYPE
490 := okc_api.g_miss_date,
491 last_updated_by NUMBER := okc_api.g_miss_num,
493 := okc_api.g_miss_date,
494 last_update_login NUMBER := okc_api.g_miss_num,
495 object_version_number NUMBER := okc_api.g_miss_num,
496 attribute_category okc_deliverables.attribute_category%TYPE
497 := okc_api.g_miss_char,
498 attribute1 okc_deliverables.attribute1%TYPE
499 := okc_api.g_miss_char,
500 attribute2 okc_deliverables.attribute2%TYPE
501 := okc_api.g_miss_char,
502 attribute3 okc_deliverables.attribute3%TYPE
503 := okc_api.g_miss_char,
504 attribute4 okc_deliverables.attribute4%TYPE
505 := okc_api.g_miss_char,
506 attribute5 okc_deliverables.attribute5%TYPE
507 := okc_api.g_miss_char,
508 attribute6 okc_deliverables.attribute6%TYPE
509 := okc_api.g_miss_char,
510 attribute7 okc_deliverables.attribute7%TYPE
511 := okc_api.g_miss_char,
512 attribute8 okc_deliverables.attribute8%TYPE
513 := okc_api.g_miss_char,
514 attribute9 okc_deliverables.attribute9%TYPE
515 := okc_api.g_miss_char,
516 attribute10 okc_deliverables.attribute10%TYPE
517 := okc_api.g_miss_char,
518 attribute11 okc_deliverables.attribute11%TYPE
519 := okc_api.g_miss_char,
520 attribute12 okc_deliverables.attribute12%TYPE
521 := okc_api.g_miss_char,
522 attribute13 okc_deliverables.attribute13%TYPE
523 := okc_api.g_miss_char,
524 attribute14 okc_deliverables.attribute14%TYPE
525 := okc_api.g_miss_char,
526 attribute15 okc_deliverables.attribute15%TYPE
527 := okc_api.g_miss_char,
528 disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
529 := okc_api.g_miss_char,
530 last_amendment_date okc_deliverables.last_amendment_date%TYPE
531 := okc_api.g_miss_date,
532 business_document_line_id okc_deliverables.business_document_line_id%TYPE
533 := okc_api.g_miss_num,
534 external_party_site_id okc_deliverables.external_party_site_id%TYPE
535 := okc_api.g_miss_num,
536 start_event_date okc_deliverables.start_event_date%TYPE
537 := okc_api.g_miss_date,
538 end_event_date okc_deliverables.end_event_date%TYPE
539 := okc_api.g_miss_date,
540 summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
541 := okc_api.g_miss_char,
542 external_party_role okc_deliverables.external_party_role%TYPE
543 := okc_api.g_miss_char,
544 pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
545 := okc_api.g_miss_char,
546 pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
547 := okc_api.g_miss_num,
548 pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
549 := okc_api.g_miss_char,
550 pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
551 := okc_api.g_miss_char,
552 raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE
553 := okc_api.g_miss_char,
554 status VARCHAR2 (1),
555 errmsg VARCHAR2 (2500)
556 );
557
558 TYPE deliverable_tbl_type IS TABLE OF deliverable_rec_type
559 INDEX BY PLS_INTEGER;
560
561 TYPE k_article_id_tbl_type IS TABLE OF NUMBER
562 INDEX BY PLS_INTEGER;
563
564 TYPE section_id_tbl_type IS TABLE OF NUMBER
565 INDEX BY PLS_INTEGER;
566
567 TYPE deliverable_id_tbl_type IS TABLE OF NUMBER
568 INDEX BY PLS_INTEGER;
569
570 PROCEDURE create_template (
571 p_template_tbl IN OUT NOCOPY terms_template_tbl_type,
572 p_commit IN VARCHAR2 := fnd_api.g_false
573 );
574
575 PROCEDURE create_tmpl_usage (
576 p_template_id IN NUMBER,
577 p_tmpl_usage_tbl IN OUT NOCOPY tmpl_usage_tbl_type,
578 p_commit IN VARCHAR2 := fnd_api.g_false
579 );
580
584 p_commit IN VARCHAR2 := fnd_api.g_false
581 PROCEDURE update_tmpl_usage(
582 p_template_id IN NUMBER ,
583 p_tmpl_usage_tbl IN OUT NOCOPY tmpl_usage_tbl_type,
585 );
586
587 PROCEDURE delete_tmpl_usage (
588 p_template_id IN NUMBER ,
589 p_tmpl_usage_tbl IN OUT NOCOPY tmpl_usage_tbl_type,
590 p_commit IN VARCHAR2 := fnd_api.g_false
591 );
592
593 PROCEDURE create_article (
594 p_article_tbl IN OUT NOCOPY k_article_tbl_type,
595 p_commit IN VARCHAR2 := fnd_api.g_false
596 );
597
598 PROCEDURE create_section (
599 p_section_tbl IN OUT NOCOPY section_tbl_type,
600 p_commit IN VARCHAR2 := fnd_api.g_false
601 );
602
603 PROCEDURE create_deliverable (
604 p_deliverable_tbl IN OUT NOCOPY deliverable_tbl_type,
605 p_commit IN VARCHAR2 := fnd_api.g_false
606 );
607
608 PROCEDURE create_template_revision (
609 p_template_id IN NUMBER,
610 p_copy_deliverables IN VARCHAR2 DEFAULT 'Y',
611 p_commit IN VARCHAR2 := fnd_api.g_false,
612 x_new_template_id OUT NOCOPY NUMBER,
613 x_return_status OUT NOCOPY VARCHAR2,
614 x_msg_data OUT NOCOPY VARCHAR2,
615 x_msg_count OUT NOCOPY NUMBER
616 );
617
618 PROCEDURE update_template (
619 p_template_tbl IN OUT NOCOPY okc_imp_terms_templates_pvt.terms_template_tbl_type,
620 p_commit IN VARCHAR2 := fnd_api.g_false
621 );
622
623 PROCEDURE delete_articles (
624 p_template_id IN NUMBER,
625 p_k_article_id_tbl IN k_article_id_tbl_type,
626 p_commit IN VARCHAR2 := fnd_api.g_false,
627 x_k_article_id_tbl OUT NOCOPY k_article_id_tbl_type,
628 x_return_status OUT NOCOPY VARCHAR2,
629 x_msg_data OUT NOCOPY VARCHAR2
630 );
631
632 PROCEDURE delete_sections (
633 p_template_id IN NUMBER,
634 p_section_id_tbl IN section_id_tbl_type,
635 p_commit IN VARCHAR2 := fnd_api.g_false,
636 x_section_id_tbl OUT NOCOPY section_id_tbl_type,
637 x_return_status OUT NOCOPY VARCHAR2,
638 x_msg_data OUT NOCOPY VARCHAR2
639 );
640
641 PROCEDURE delete_deliverables (
642 p_template_id IN NUMBER,
643 p_deliverable_id_tbl IN deliverable_id_tbl_type,
644 p_commit IN VARCHAR2 := fnd_api.g_false,
645 x_deliverable_id_tbl OUT NOCOPY deliverable_id_tbl_type,
646 x_return_status OUT NOCOPY VARCHAR2,
647 x_msg_data OUT NOCOPY VARCHAR2
648 );
649 END okc_imp_terms_templates_pvt;