[Home] [Help]
PACKAGE: APPS.OKC_TERMS_MIGRATE_GRP
Source
1 PACKAGE OKC_TERMS_MIGRATE_GRP AUTHID CURRENT_USER AS
2 /* $Header: OKCGTMGS.pls 120.4.12020000.4 2013/02/08 14:35:19 nbingi ship $ */
3
4 /*
5 */
6
7 TYPE deliverable_rec_type IS RECORD (
8 deliverable_id okc_deliverables.deliverable_id%TYPE
9 := okc_api.g_miss_num,
10 business_document_type okc_deliverables.business_document_type%TYPE
11 := okc_api.g_miss_char,
12 business_document_id okc_deliverables.business_document_id%TYPE
13 := okc_api.g_miss_num,
14 business_document_number okc_deliverables.business_document_number%TYPE
15 := okc_api.g_miss_char,
16 deliverable_type okc_deliverables.deliverable_type%TYPE
17 := okc_api.g_miss_char,
18 responsible_party okc_deliverables.responsible_party%TYPE
19 := okc_api.g_miss_char,
20 internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
21 := okc_api.g_miss_num,
22 external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
23 := okc_api.g_miss_num,
24 deliverable_name okc_deliverables.deliverable_name%TYPE
25 := okc_api.g_miss_char,
26 description okc_deliverables.description%TYPE
27 := okc_api.g_miss_char,
28 comments okc_deliverables.comments%TYPE
29 := okc_api.g_miss_char,
30 display_sequence okc_deliverables.display_sequence%TYPE
31 := okc_api.g_miss_num,
32 fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
33 := okc_api.g_miss_char,
34 actual_due_date okc_deliverables.actual_due_date%TYPE
35 := okc_api.g_miss_date,
36 print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
37 := okc_api.g_miss_char,
38 recurring_yn okc_deliverables.recurring_yn%TYPE
39 := okc_api.g_miss_char,
40 notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
41 := okc_api.g_miss_num,
42 notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
43 := okc_api.g_miss_char,
44 notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
45 := okc_api.g_miss_char,
46 notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
47 := okc_api.g_miss_char,
48 notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
49 := okc_api.g_miss_char,
50 notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
51 := okc_api.g_miss_char,
52 notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
53 := okc_api.g_miss_num,
54 notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
55 := okc_api.g_miss_char,
56 escalation_assignee okc_deliverables.escalation_assignee%TYPE
57 := okc_api.g_miss_num,
58 amendment_operation okc_deliverables.amendment_operation%TYPE
59 := okc_api.g_miss_char,
60 prior_notification_id okc_deliverables.prior_notification_id%TYPE
61 := okc_api.g_miss_num,
62 amendment_notes okc_deliverables.amendment_notes%TYPE
63 := okc_api.g_miss_char,
64 completed_notification_id okc_deliverables.completed_notification_id%TYPE
65 := okc_api.g_miss_num,
66 overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
67 := okc_api.g_miss_num,
68 escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
69 := okc_api.g_miss_num,
70 LANGUAGE okc_deliverables.LANGUAGE%TYPE
71 := okc_api.g_miss_char,
72 original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
73 := okc_api.g_miss_num,
74 requester_id okc_deliverables.requester_id%TYPE
75 := okc_api.g_miss_num,
76 external_party_id okc_deliverables.external_party_id%TYPE
77 := okc_api.g_miss_num,
78 recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
79 := okc_api.g_miss_num,
80 business_document_version okc_deliverables.business_document_version%TYPE
81 := okc_api.g_miss_num,
82 relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
83 := okc_api.g_miss_num,
84 relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
85 := okc_api.g_miss_char,
86 relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
87 := okc_api.g_miss_num,
88 relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
89 := okc_api.g_miss_num,
90 relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
91 := okc_api.g_miss_char,
92 relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
93 := okc_api.g_miss_num,
94 repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
95 := okc_api.g_miss_char,
96 repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
97 := okc_api.g_miss_char,
98 repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
99 := okc_api.g_miss_char,
100 repeating_duration okc_deliverables.repeating_duration%TYPE
101 := okc_api.g_miss_num,
102 fixed_start_date okc_deliverables.fixed_start_date%TYPE
103 := okc_api.g_miss_date,
104 fixed_end_date okc_deliverables.fixed_end_date%TYPE
105 := okc_api.g_miss_date,
106 manage_yn okc_deliverables.manage_yn%TYPE
107 := okc_api.g_miss_char,
108 internal_party_id okc_deliverables.internal_party_id%TYPE
109 := okc_api.g_miss_num,
110 deliverable_status okc_deliverables.deliverable_status%TYPE
111 := okc_api.g_miss_char,
112 status_change_notes okc_deliverables.status_change_notes%TYPE
113 := okc_api.g_miss_char,
114 created_by NUMBER := okc_api.g_miss_num,
115 creation_date okc_deliverables.creation_date%TYPE
116 := okc_api.g_miss_date,
117 last_updated_by NUMBER := okc_api.g_miss_num,
118 last_update_date okc_deliverables.last_update_date%TYPE
119 := okc_api.g_miss_date,
120 last_update_login NUMBER := okc_api.g_miss_num,
121 object_version_number NUMBER := okc_api.g_miss_num,
122 attribute_category okc_deliverables.attribute_category%TYPE
123 := okc_api.g_miss_char,
124 attribute1 okc_deliverables.attribute1%TYPE
125 := okc_api.g_miss_char,
126 attribute2 okc_deliverables.attribute2%TYPE
127 := okc_api.g_miss_char,
128 attribute3 okc_deliverables.attribute3%TYPE
129 := okc_api.g_miss_char,
130 attribute4 okc_deliverables.attribute4%TYPE
131 := okc_api.g_miss_char,
132 attribute5 okc_deliverables.attribute5%TYPE
133 := okc_api.g_miss_char,
134 attribute6 okc_deliverables.attribute6%TYPE
135 := okc_api.g_miss_char,
136 attribute7 okc_deliverables.attribute7%TYPE
137 := okc_api.g_miss_char,
138 attribute8 okc_deliverables.attribute8%TYPE
139 := okc_api.g_miss_char,
140 attribute9 okc_deliverables.attribute9%TYPE
141 := okc_api.g_miss_char,
142 attribute10 okc_deliverables.attribute10%TYPE
143 := okc_api.g_miss_char,
144 attribute11 okc_deliverables.attribute11%TYPE
145 := okc_api.g_miss_char,
146 attribute12 okc_deliverables.attribute12%TYPE
147 := okc_api.g_miss_char,
148 attribute13 okc_deliverables.attribute13%TYPE
149 := okc_api.g_miss_char,
150 attribute14 okc_deliverables.attribute14%TYPE
151 := okc_api.g_miss_char,
152 attribute15 okc_deliverables.attribute15%TYPE
153 := okc_api.g_miss_char,
154 disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
155 := okc_api.g_miss_char,
156 last_amendment_date okc_deliverables.last_amendment_date%TYPE
157 := okc_api.g_miss_date,
158 business_document_line_id okc_deliverables.business_document_line_id%TYPE
159 := okc_api.g_miss_num,
160 external_party_site_id okc_deliverables.external_party_site_id%TYPE
161 := okc_api.g_miss_num,
162 start_event_date okc_deliverables.start_event_date%TYPE
163 := okc_api.g_miss_date,
164 end_event_date okc_deliverables.end_event_date%TYPE
165 := okc_api.g_miss_date,
166 summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
167 := okc_api.g_miss_char,
168 external_party_role okc_deliverables.external_party_role%TYPE
169 := okc_api.g_miss_char,
170 pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
171 := okc_api.g_miss_char,
172 pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
173 := okc_api.g_miss_num,
174 pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
175 := okc_api.g_miss_char,
176 pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177 := okc_api.g_miss_char,
178 orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179 orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
180 orig_system_reference_id2 okc_deliverables.orig_system_reference_id2%TYPE := okc_api.g_miss_num,
181 raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE := okc_api.g_miss_char,
182 status VARCHAR2 (1),
183 errmsg VARCHAR2 (2500)
184 );
185
186 Procedure Create_Contract_Terms
187 ( p_api_version IN Number,
188 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
189 p_commit IN Varchar2 default FND_API.G_FALSE,
190 x_return_status OUT NOCOPY Varchar2,
191 x_msg_data OUT NOCOPY Varchar2,
192 x_msg_count OUT NOCOPY Number,
193 p_document_type IN Varchar2,
194 p_document_id IN Number,
195 p_contract_source IN VARCHAR2,
196 p_contract_tmpl_id IN Number default NULL,
197 p_contract_tmpl_name IN Varchar2 default NULL,
198 p_attachment_file_loc IN Varchar2 default NULL,
199 p_attachment_file_name IN Varchar2 default NULL,
200 p_attachment_file_desc IN Varchar2 default NULL
201 );
202
203 Procedure Add_Contract_Doc
204 ( p_api_version IN Number,
205 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
206 p_commit IN Varchar2 default FND_API.G_FALSE,
207 x_return_status OUT NOCOPY Varchar2,
208 x_msg_data OUT NOCOPY Varchar2,
209 x_msg_count OUT NOCOPY Number,
210 p_document_type IN Varchar2,
211 p_document_id IN Number,
212 p_contract_category IN Varchar2,
213 p_contract_doc_type IN Varchar2,
214 p_url IN varchar2,
215 p_attachment_file_loc IN Varchar2 ,
216 p_attachment_file_name IN Varchar2 ,
217 p_description IN Varchar2
218 );
219
220 Procedure Add_Standard_Clause
221 ( p_api_version IN Number,
222 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
223 p_commit IN Varchar2 default FND_API.G_FALSE,
224 x_return_status OUT NOCOPY Varchar2,
225 x_msg_data OUT NOCOPY Varchar2,
226 x_msg_count OUT NOCOPY Number,
227 p_document_type IN Varchar2,
228 p_document_id IN Number,
229 p_section_id IN NUMBER DEFAULT null,
230 p_section_name IN Varchar2 default null,
231 p_clause_version_id IN Number default null,
232 p_clause_title IN Varchar2 default null,
233 p_clause_version_num IN Number default null,
234 p_renumber_terms IN Varchar2 default FND_API.G_FALSE,
235 x_Contract_clause_id OUT NOCOPY Number,
236 p_display_sequence IN NUMBER DEFAULT NULL,
237 p_mode IN VARCHAR2 := 'NORMAL' -- Other value 'AMEND'
238 );
239
240 Procedure Add_Non_Standard_Clause
241 ( p_api_version IN Number,
242 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
243 p_commit IN Varchar2 default FND_API.G_FALSE,
244 x_return_status OUT NOCOPY Varchar2,
245 x_msg_data OUT NOCOPY Varchar2,
246 x_msg_count OUT NOCOPY Number,
247 p_document_type IN Varchar2,
248 p_document_id IN Number,
249 p_section_id IN NUMBER DEFAULT null,
250 p_section_name IN Varchar2 default null,
251 p_clause_title IN Varchar2,
252 p_clause_text IN CLOB DEFAULT null,
253 p_clause_type IN Varchar2 default 'OTHER',
254 p_clause_disp_name IN Varchar2 default null,
255 p_clause_description IN Varchar2 default null,
256 p_renumber_terms IN Varchar2 default FND_API.G_FALSE,
257 p_edited_in_word IN VARCHAR2 DEFAULT 'N',
258 p_clause_text_in_word IN BLOB DEFAULT NULL,
259 x_contract_clause_id OUT NOCOPY Number,
260 x_clause_version_id OUT NOCOPY Number
261 );
262
263 Procedure Add_Section
264 ( p_api_version IN Number,
265 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
266 p_commit IN Varchar2 default FND_API.G_FALSE,
267 x_return_status OUT NOCOPY Varchar2,
268 x_msg_data OUT NOCOPY Varchar2,
269 x_msg_count OUT NOCOPY Number,
270 p_document_type IN Varchar2,
271 p_document_id IN Number,
272 p_section_source IN Varchar2,
273 p_section_name IN Varchar2,
274 p_section_description IN Varchar2 default null,
275 p_renumber_terms IN Varchar2 default FND_API.G_FALSE,
276 p_orig_system_reference_code IN VARCHAR2 default NULL,
277 p_orig_system_reference_id1 IN NUMBER default NULL,
278 p_orig_system_reference_id2 IN NUMBER default NULL,
279 x_section_id OUT NOCOPY Number
280 );
281
282 PROCEDURE Apps_Initialize(p_api_version IN NUMBER,
283 p_user_name IN VARCHAR2,
284 p_resp_name IN VARCHAR2,
285 p_org_id IN number);
286
287 FUNCTION get_valueset_id (
288 p_value_set_id IN NUMBER,
289 p_var_value IN VARCHAR2,
290 p_validation_type IN VARCHAR2) RETURN NUMBER ;
291
292 PROCEDURE update_variable_values(p_api_version IN NUMBER,
293 p_doc_type IN VARCHAR2,
294 p_doc_id IN NUMBER,
295 p_k_clause_id IN NUMBER DEFAULT NULL,
296 p_clause_title IN VARCHAR2 DEFAULT NULL,
297 p_clause_version IN NUMBER DEFAULT NULL,
298 p_variable_name IN VARCHAR2,
299 p_variable_value IN VARCHAR2,
300 p_override_global_yn IN VARCHAR2,
301 p_global_variable_value IN VARCHAR2 := NULL,
302 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
303 p_commit IN Varchar2 default FND_API.G_FALSE,
304 x_return_status OUT NOCOPY Varchar2,
305 x_msg_data OUT NOCOPY Varchar2,
306 x_msg_count OUT NOCOPY Number
307 );
308
309 PROCEDURE Create_template_usages(p_api_version IN NUMBER,
310 p_document_type IN VARCHAR2,
311 p_document_id IN NUMBER,
312 p_contract_source IN VARCHAR2,
313 p_contract_tmpl_id IN Number := NULL,
314 p_contract_tmpl_name IN Varchar2 default NULL,
315 p_authoring_party_code IN VARCHAR2 := NULL,
316 p_autogen_deviations_flag IN VARCHAR2 := NULL,
317 p_lock_terms_flag IN VARCHAR2 := NULL,
318 p_enable_reporting_flag IN VARCHAR2 := NULL,
319 p_approval_abstract_text IN CLOB := NULL,
320 p_locked_by_user_name IN VARCHAR2 DEFAULT NULL,
321 p_legal_contact_name IN VARCHAR2 DEFAULT NULL,
322 p_contract_admin_name IN VARCHAR2 DEFAULT NULL,
323 p_primary_template IN VARCHAR2 DEFAULT 'Y',
324 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
325 p_commit IN Varchar2 default FND_API.G_FALSE,
326 x_return_status OUT NOCOPY Varchar2,
327 x_msg_data OUT NOCOPY Varchar2,
328 x_msg_count OUT NOCOPY Number);
329
330 PROCEDURE create_deliverables(p_api_version IN NUMBER,
331 p_document_type IN VARCHAR2,
332 p_document_id IN NUMBER,
333 p_deliverable_rec IN deliverable_rec_type,
334 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
335 p_commit IN Varchar2 default FND_API.G_FALSE,
336 x_return_status OUT NOCOPY Varchar2,
337 x_msg_data OUT NOCOPY Varchar2,
338 x_msg_count OUT NOCOPY Number
339 );
340
341 PROCEDURE remove_std_clause_from_doc(p_api_version IN Number,
342 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
343 p_commit IN Varchar2 default FND_API.G_FALSE,
344 p_mode IN VARCHAR2 default'NORMAL',
345 p_document_type IN Varchar2,
346 p_document_id IN Number,
347 p_clause_version_id IN Number default null,
348 p_clause_title IN Varchar2 default null,
349 p_clause_version_num IN Number default null,
350 p_renumber_terms IN Varchar2 default FND_API.G_FALSE,
351 x_return_status OUT NOCOPY Varchar2,
352 x_msg_data OUT NOCOPY Varchar2,
353 x_msg_count OUT NOCOPY Number);
354
355 PROCEDURE remove_clause_id_from_doc(p_api_version IN Number,
356 p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
357 p_commit IN Varchar2 default FND_API.G_FALSE,
358 p_mode IN VARCHAR2 default'NORMAL',
359 p_document_type IN Varchar2,
360 p_document_id IN Number,
361 p_clause_id IN Number default null,
362 p_renumber_terms IN Varchar2 default FND_API.G_FALSE,
363 x_return_status OUT NOCOPY Varchar2,
364 x_msg_data OUT NOCOPY Varchar2,
365 x_msg_count OUT NOCOPY NUMBER
366 ,p_locking_enabled_yn IN VARCHAR2 DEFAULT 'N'
367 );
368
369 END OKC_TERMS_MIGRATE_GRP;