1 PACKAGE OKC_OC_INT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPORDS.pls 120.0 2005/05/26 09:57:17 appldev noship $ */
3
4 -------------------------------------------------------------------------------
5 --
6 -- APIs: K->Q
7 --
8 -------------------------------------------------------------------------------
9
10 -- Procedure: create_quote_for_renewal
11 -- Version: 1.0
12 -- Purpose: Overloaded version designed to be called as an
13 -- outcome from Events
14 -- Hence input parameters need to be simpler,
15 -- and no output parameters needed or useful
16 -- In Parameters: p_contract_id Contract for which to create quote
17 -- Out Parameters: None
18
19 PROCEDURE create_quote_for_renewal(p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2
23 ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
24 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
25 );
26
27
28 -------------------------------------------------------------------------------
29 -- Procedure: create_quote_from_k
30 -- Version: 1.0
31 -- Purpose: The first one is planned to be called by a Conc. Prog.
32 -- and calls itself the second one
33 -- Create a quote from a contract as the initial
34 -- stage in the renewal, or just as a copy of thew contract
35 -- process. Provides process 2.1 in data flow diagram in HLD.
36 -- Create relationships from renewing contract to quote
37 -- May also create subject-to relationship from quote
38 -- to master contract if renewing contract is subject
39 -- to a master contract
40 -- Calls ASO_QUOTE_PUB.CREATE_QUOTE to create the quote
41 -- In Parameters: p_contract_id Contract for which to create quote
42 -- p_rel_typ Relation type to be created
43 -- Out Parameters: x_quote_id Id of created quote
44
45 PROCEDURE create_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
46 ,RETCODE OUT NOCOPY NUMBER
47 ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
48 ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
49 --p_contract_number is in fact equal to contract ID
50 ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
51 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
52 );
53
54
55 PROCEDURE create_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
56 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
57 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58 ,x_return_status OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER
60 ,x_msg_data OUT NOCOPY VARCHAR2
61 ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
62 ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
63 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
64 ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE
65 );
66
67 -------------------------------------------------------------------------------
68 -- Procedure: update_quote_from_k
69 -- Version: 1.0
70 -- Purpose: The first one is planned to be called by a Conc. Prog.
71 -- and calls itself the second one
72 -- Update a quote from a contract as the initial
73 -- stage in the renewal, or just as a copy of the contract
74 -- process. Provides process 2.1 in data flow diagram in HLD.
75 -- Create relationships from renewing contract to quote
76 -- May also create subject-to relationship from quote
77 -- to master contract if renewing contract is subject
78 -- to a master contract
79 -- Calls ASO_QUOTE_PUB.UPDATE_QUOTE to update the quote
80 --
81 -- In Parameters: p_contract_id Contract for which the quote is to be renewed
82 -- p_quote_id Quote id of the quote to b renewed
83 --
84 PROCEDURE update_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
85 ,RETCODE OUT NOCOPY NUMBER
86 --
87 ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
88 -- p_contract_number is in fact equal to contract ID
89 --
90 ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
91 -- p_quote_number is in fact equal to quote ID
92 --
93 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
94 );
95
96
97 PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
98 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100 ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101 ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
102 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
103 ,x_return_status OUT NOCOPY VARCHAR2
104 ,x_msg_count OUT NOCOPY NUMBER
105 ,x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108
109 -------------------------------------------------------------------------------
110 --
111 -- APIs: K->O
112 --
113 -------------------------------------------------------------------------------
114
115 -- Procedure: create_order_from_k
116 -- Version: 1.0
117 -- Purpose: Create an order from a contract.
118 -- The first one is planned to be called by a Conc. Prog.
119 -- and calls itself the second one
120 -- Provides process 7 in data flow diagram in HLD.
121 -- Create relationships from contract to order
122 -- May also create subject-to relationship from order
123 -- to master contract if ordering contract is subject to
124 -- a master contract
125 -- Calls ASO_ORDER_PUB.CREATE_ORDER to create the order
126 -- In Parameters: p_contract_id Contract for which to create order
127 -- p_rel_typ Relation type to be created
128 -- Out Parameters: x_order_id Id of created order
129 --
130 -------------------------------------------------------------------------------
131
132 PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
133 ,RETCODE OUT NOCOPY NUMBER
134 ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
135 ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
136 --
137 -- p_contract_number is in fact equal to contract ID
138 --
139 ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
140 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
141 );
142
143
144 PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
145 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
146 ,p_commit 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_contract_id IN OKC_K_HEADERS_B.ID%TYPE
151 ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
152 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
153 ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
154 );
155
156 -------------------------------------------------------------------------------
157 --
158 -- APIs: Q->K
159 --
160 -------------------------------------------------------------------------------
161
162
163 TYPE OKC_QUOTE_LINE_TAB IS TABLE OF OKX_QUOTE_LINES_V.ID1%TYPE INDEX BY BINARY_INTEGER;
164 G_MISS_QL_TAB OKC_QUOTE_LINE_TAB;
165
166 TYPE OKC_ORDER_LINE_TAB IS TABLE OF OKX_ORDER_LINES_V.ID1%TYPE INDEX BY BINARY_INTEGER;
167 G_MISS_OL_TAB OKC_ORDER_LINE_TAB;
168
169
170 -- Procedure: create_k_from_quote
171 -- Version: 1.0
172 -- Purpose: Create a contract from a quote.
173 -- Provides process 3.2.2 in data flow diagram in HLD.
174 -- Create relationships from quote to contract
175 -- The first one is planned to be called by a Conc. Prog.
176 -- and calls itself the second one
177 -- In Parameters: p_quote_id Quote for which to create contract
178 -- p_template_id Template contract to use in creating
179 -- contract
180 -- p_template_version Template contract current version to use in creating
181 -- contract
182 -- p_template_previous_version Template contract previous version to use in creating
183 -- contract
184 -- Out Parameters: x_contract_id Id of created contract
185 -- x_contract_number contract number of newly created contract
186
187 -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
188 PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
189 ,RETCODE OUT NOCOPY NUMBER
190 ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
191 ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192 ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193 ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194 ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
196 );
197
198
199 PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
200 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202 ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203 ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204 ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206 ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208 ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
209 ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
210 ,x_return_status OUT NOCOPY VARCHAR2
211 ,x_msg_count OUT NOCOPY NUMBER
212 ,x_msg_data OUT NOCOPY VARCHAR2
213 );
214
215
216 -- Procedure: create_k_from_quote
217 -- Version: 1.0
218 -- Purpose: Create a contract from a quote. Overloaded Procedure
219 -- of the previous one for backward compatibility
220 -- Does NOT return contract number
221 -- Provides process 3.2.2 in data flow diagram in HLD.
222 -- Create relationships from quote to contract
223 -- In Parameters: p_quote_id Quote for which to create contract
224 -- p_template_id Template contract to use in creating
225 -- contract
226 -- p_template_version Template contract current version to use in creating
227 -- contract
228 -- p_template_previous_version Template contract previous version to use in creating
229 -- contract
230 -- Out Parameters: x_contract_id Id of created contract
231
232 PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
233 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235 ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236 ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237 ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240 ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
241 ,x_return_status OUT NOCOPY VARCHAR2
242 ,x_msg_count OUT NOCOPY NUMBER
243 ,x_msg_data OUT NOCOPY VARCHAR2
244 );
245
246
247 -- Procedure: create_k_relationships
248 -- Version: 1.0
249 -- Purpose: 1. Creates a relationship between the related sales
250 -- contract and the new order.
251 -- This is done at the header and line levels.
252 -- 2. Create the relationships between the related sales
253 -- contract and the
254 -- new service contract (created from the original order).
255 -- This is done at the header and line levels.
256 --
257 -- In Parameters: p_api_version API version (to be initialized to 1)
258 -- p_init_msg_list Flag to reset the error message stack
259 -- p_commit Commit flag for the transaction
260 -- p_sales_contract_id Sales Contract header id as
261 -- created from Quote header id
262 -- p_service_contract_id Service Contract header id as
263 -- created from Order header id
264 -- p_quote_id Quote header id
265 -- p_quote_line_tab Quote line ids (PL/SQL table)
266 -- p_order_id Order header id as created from
267 -- Quote header id
268 -- p_order_line_tab Order line ids (PL/SQL table)
269 -- p_trace_mode Trace mode option to generate
270 -- a trace file
271 --
272 -- Out Parameters: x_return_status Final status of the O-K relationship
273 -- creation API:
274 -- -OKC_API.G_RET_STS_SUCCESS
275 -- -OKC_API.G_RET_STS_ERROR
276 -- -OKC_API.G_RET_STS_UNEXP_ERROR
277 -- THIS IS A WRAPPER FOR OKC_OC_INT_KTO_PVT.create_k_relationships
278
279 PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282 ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283 ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284 ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285 ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286 ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
287 ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
288 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
289 ,x_return_status OUT NOCOPY VARCHAR2
290 ,x_msg_count OUT NOCOPY NUMBER
291 ,x_msg_data OUT NOCOPY VARCHAR2);
292
293
294 -- Procedure: create_interaction_history
295 -- Version: 1.0
296 -- Purpose: 1. In the event of a new contract's terms and conditions
297 -- not being approved by the customer, fresh negotiations
298 -- of the terms and conditions is undertaken and the
299 -- contract administrator notified.
300 -- Following the fresh negotiations, the customer may or
301 -- may not approve. If the customer still does not approve,
302 -- the contract has to be set back to an ENTERED state.
303 --
304 -- This procedure records the information used for the
305 -- these negotiations.
306 --
307 -- In Parameters: p_api_version API version (to be initialized to 1)
308 -- p_init_msg_list Flag to reset the error message stack
309 -- p_commit Commit flag for the transaction
310 -- p_contract_id Contract header id of the contract
311 -- whose TsandCs need to be negotiated
312 -- p_party_id Initiator of the Interaction
313 -- history as party id of person type
314 -- or as party id of a 'contact of' or
315 -- 'employee of' relationship between
316 -- the customer and his contact or his
317 -- employee
318 -- p_interaction_subject Short message to introduce the
319 -- interaction, like
320 -- Terms and conditions of a contract
321 -- p_interaction_body Message body to be used to build
322 -- the interaction
323 -- p_trace_mode Trace mode option to generate a
324 -- trace file
325 --
326 -- Out Parameters: x_return_status Final status of notification
327 -- sending API:
328 -- -OKC_API.G_RET_STS_SUCCESS
329 -- -OKC_API.G_RET_STS_ERROR
330 -- -OKC_API.G_RET_STS_UNEXP_ERROR
331 -- x_msg_count Number of messages set on the stack
332 -- x_msg_data Message info id x_msg_count = 1
333 -- THIS IS A WRAPPER FOR OKC_OC_INT_QTK_PVT.create_interaction_history
334
335 PROCEDURE create_interaction_history(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
336 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
338 ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
339 ,p_party_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
340 ,p_interaction_subject IN VARCHAR2
341 ,p_interaction_body IN VARCHAR2
342 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
343 ,x_return_status OUT NOCOPY VARCHAR2
344 ,x_msg_count OUT NOCOPY NUMBER
345 ,x_msg_data OUT NOCOPY VARCHAR2);
346
347
348 -- Procedure: notify_k_admin
349 -- Version: 1.0
350 -- ...
351
352 -- Modified by Igor Filimonov 10-04-2001
353 -- Bug : 1905226 OKC, ISTORE TESTING: K ALERT RESULTS GRID SHOULD POPULATE K# FIELD
354 -- Problem : Notifications in Launchpad's Inbox don't show KNUMBER in subject
355 -- and 'Contract Number' column
356 -- Fix: p_contract_id was added into parameter list of notify_k_adm procedure
357
358 PROCEDURE notify_k_adm(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
359 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
360 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
361 ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
362 ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
363 ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
364 ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
365 ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
366 ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
367 ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368 ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369 ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371 ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
372 ,x_k_admin_user_name OUT NOCOPY VARCHAR2
373 ,x_return_status OUT NOCOPY VARCHAR2
374 ,x_msg_count OUT NOCOPY NUMBER
375 ,x_msg_data OUT NOCOPY VARCHAR2
376 );
377
378
379 -- Added by Igor Filimonov 03-15-2002
380 -------------------------------------------------------------------------------
381 -- Procedure: notify_sales_rep
382 -- Version: 1.0
383 -- Purpose: API is used to retrive Quotation , contract status
384 -- (If required) and generate notification to Order Capture
385 -- and Istore
386 -- THIS API IS CALLED FROM OKC_WF_K_APPROVE.NOTIFY_SALES_REP_W
387 -- IN Parameters : p_contract_id, p_contract_status, p_trace_mode
388 --
389 -- OUT Parameters : x_return_status
390 -------------------------------------------------------------------------------
391
392 PROCEDURE notify_sales_rep (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
393 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
394 ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
395 ,p_contract_status IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
396 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
397 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
398 ,x_return_status OUT NOCOPY VARCHAR2
399 ,x_msg_count OUT NOCOPY NUMBER
400 ,x_msg_data OUT NOCOPY VARCHAR2
401 );
402
403 -- Procedure: get_k_number
404 -- Version: 1.0
405 -- ...
406
407 PROCEDURE get_k_number(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
408 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
409 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410 ,p_contract_id IN NUMBER
411 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412 ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
413 ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
414 ,x_return_status OUT NOCOPY VARCHAR2
415 ,x_msg_count OUT NOCOPY NUMBER
416 ,x_msg_data OUT NOCOPY VARCHAR2);
417
418
419 -- Procedure: k_signed
420 -- Version: 1.0
421 -- Purpose: While creating a contract from a quote, the contract is
422 -- set within an ENTERED status. If the customer agrees
423 -- with the standard TsandCs, this status has to be
424 -- changed at its creation time from ENTERED to SIGNED.
425 --
426 -- This procedure changes the status of the contract,
427 -- either from an ENTERED status to a SIGNED status, or
428 -- from an APPROVED status to a SIGNED status.
429 --
430 -- This API will be called either directly from the creation
431 -- contract API (ENTERED to SIGNED), or later by Order
432 -- Capture/iStore (APPROVED to SIGNED)
433 --
434 --
435 -- In Parameters: p_party_id Contract header id
436 -- p_date_signed Signing date of the contract
437 --
438 -- Out Parameters: x_return_status Final status of the contract status update
439 -- -OKC_API.G_RET_STS_SUCCESS
440 -- -OKC_API.G_RET_STS_ERROR
441 -- -OKC_API.G_RET_STS_UNEXP_ERROR
442 -- THIS IS A PLAIN BARE-BONES WRAPPER FOR OKC_CONTRACT_APPROVAL_PUB.k_signed
443
444 PROCEDURE k_signed(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
445 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
446 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
447 ,p_contract_id IN NUMBER
448 ,p_date_signed IN DATE DEFAULT SYSDATE
449 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
450 ,x_return_status OUT NOCOPY VARCHAR2
451 ,x_msg_count OUT NOCOPY NUMBER
452 ,x_msg_data OUT NOCOPY VARCHAR2);
453
454
455 -- Procedure: k_erase_approved
456 -- Version: 1.0
457 -- ...
458
459 PROCEDURE k_erase_approved(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
460 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
461 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
462 ,p_contract_id IN NUMBER
463 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
464 ,x_return_status OUT NOCOPY VARCHAR2
465 ,x_msg_count OUT NOCOPY NUMBER
466 ,x_msg_data OUT NOCOPY VARCHAR2);
467
468
469 -- Procedure: get_articles
470 -- Version: 1.0
471 -- Purpose: This is the public API which intent to call private API
472 -- to select all articles for the contract.
473 -- In Parameters : P_contract_id Id of the contract
474 -- Out Parameters: x_articles contract articles (clob datatype)
475
476 PROCEDURE get_articles (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
477 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
478 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
479 ,p_contract_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
480 ,p_release_id IN NUMBER DEFAULT NULL
481 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
482 ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
483 ,x_return_status OUT NOCOPY VARCHAR2
484 ,x_msg_count OUT NOCOPY NUMBER
485 ,x_msg_data OUT NOCOPY VARCHAR2);
486
487
488 -- Procedure: Submit_Request
489 -- Version: 1.0
490 -- Purpose: Outcome to submit concurrent requests
491 -- Arguments
492 -- application - Short name of application under which the program
493 -- - is registered
494 -- program - concurrent program name for which the request has
495 -- - to be submitted
496 -- description - Optional. Will be displayed along with user
497 -- - concurrent program name
498 -- start_time - Optional. Time at which the request has to start
499 -- - running
500 -- sub_request - Optional. Set to TRUE if the request is submitted
501 -- - from another running request and has to be treated
502 -- - as a sub request. Default is FALSE
503 -- argument1..100 - Optional. Arguments for the concurrent request
504 --
505
506 PROCEDURE submit_request (
507 application IN varchar2 default NULL,
508 program IN varchar2 default NULL,
509 description IN varchar2 default NULL,
510 start_time IN varchar2 default NULL,
511 sub_request IN boolean default FALSE,
512 argument1 IN varchar2 default OKC_API.G_MISS_CHAR,
513 argument2 IN varchar2 default OKC_API.G_MISS_CHAR,
514 argument3 IN varchar2 default OKC_API.G_MISS_CHAR,
515 argument4 IN varchar2 default OKC_API.G_MISS_CHAR,
516 argument5 IN varchar2 default OKC_API.G_MISS_CHAR,
517 argument6 IN varchar2 default OKC_API.G_MISS_CHAR,
518 argument7 IN varchar2 default OKC_API.G_MISS_CHAR,
519 argument8 IN varchar2 default OKC_API.G_MISS_CHAR,
520 argument9 IN varchar2 default OKC_API.G_MISS_CHAR,
521 argument10 IN varchar2 default OKC_API.G_MISS_CHAR,
522 argument11 IN varchar2 default OKC_API.G_MISS_CHAR,
523 argument12 IN varchar2 default OKC_API.G_MISS_CHAR,
524 argument13 IN varchar2 default OKC_API.G_MISS_CHAR,
525 argument14 IN varchar2 default OKC_API.G_MISS_CHAR,
526 argument15 IN varchar2 default OKC_API.G_MISS_CHAR,
527 argument16 IN varchar2 default OKC_API.G_MISS_CHAR,
528 argument17 IN varchar2 default OKC_API.G_MISS_CHAR,
529 argument18 IN varchar2 default OKC_API.G_MISS_CHAR,
530 argument19 IN varchar2 default OKC_API.G_MISS_CHAR,
531 argument20 IN varchar2 default OKC_API.G_MISS_CHAR,
532 argument21 IN varchar2 default OKC_API.G_MISS_CHAR,
533 argument22 IN varchar2 default OKC_API.G_MISS_CHAR,
534 argument23 IN varchar2 default OKC_API.G_MISS_CHAR,
535 argument24 IN varchar2 default OKC_API.G_MISS_CHAR,
536 argument25 IN varchar2 default OKC_API.G_MISS_CHAR,
537 argument26 IN varchar2 default OKC_API.G_MISS_CHAR,
538 argument27 IN varchar2 default OKC_API.G_MISS_CHAR,
539 argument28 IN varchar2 default OKC_API.G_MISS_CHAR,
540 argument29 IN varchar2 default OKC_API.G_MISS_CHAR,
541 argument30 IN varchar2 default OKC_API.G_MISS_CHAR,
542 argument31 IN varchar2 default OKC_API.G_MISS_CHAR,
543 argument32 IN varchar2 default OKC_API.G_MISS_CHAR,
544 argument33 IN varchar2 default OKC_API.G_MISS_CHAR,
545 argument34 IN varchar2 default OKC_API.G_MISS_CHAR,
546 argument35 IN varchar2 default OKC_API.G_MISS_CHAR,
547 argument36 IN varchar2 default OKC_API.G_MISS_CHAR,
548 argument37 IN varchar2 default OKC_API.G_MISS_CHAR,
549 argument38 IN varchar2 default OKC_API.G_MISS_CHAR,
550 argument39 IN varchar2 default OKC_API.G_MISS_CHAR,
551 argument40 IN varchar2 default OKC_API.G_MISS_CHAR,
552 argument41 IN varchar2 default OKC_API.G_MISS_CHAR,
553 argument42 IN varchar2 default OKC_API.G_MISS_CHAR,
554 argument43 IN varchar2 default OKC_API.G_MISS_CHAR,
555 argument44 IN varchar2 default OKC_API.G_MISS_CHAR,
556 argument45 IN varchar2 default OKC_API.G_MISS_CHAR,
557 argument46 IN varchar2 default OKC_API.G_MISS_CHAR,
558 argument47 IN varchar2 default OKC_API.G_MISS_CHAR,
559 argument48 IN varchar2 default OKC_API.G_MISS_CHAR,
560 argument49 IN varchar2 default OKC_API.G_MISS_CHAR,
561 argument50 IN varchar2 default OKC_API.G_MISS_CHAR,
562 argument51 IN varchar2 default OKC_API.G_MISS_CHAR,
563 argument52 IN varchar2 default OKC_API.G_MISS_CHAR,
564 argument53 IN varchar2 default OKC_API.G_MISS_CHAR,
565 argument54 IN varchar2 default OKC_API.G_MISS_CHAR,
566 argument55 IN varchar2 default OKC_API.G_MISS_CHAR,
567 argument56 IN varchar2 default OKC_API.G_MISS_CHAR,
568 argument57 IN varchar2 default OKC_API.G_MISS_CHAR,
569 argument58 IN varchar2 default OKC_API.G_MISS_CHAR,
570 argument59 IN varchar2 default OKC_API.G_MISS_CHAR,
571 argument60 IN varchar2 default OKC_API.G_MISS_CHAR,
572 argument61 IN varchar2 default OKC_API.G_MISS_CHAR,
573 argument62 IN varchar2 default OKC_API.G_MISS_CHAR,
574 argument63 IN varchar2 default OKC_API.G_MISS_CHAR,
575 argument64 IN varchar2 default OKC_API.G_MISS_CHAR,
576 argument65 IN varchar2 default OKC_API.G_MISS_CHAR,
577 argument66 IN varchar2 default OKC_API.G_MISS_CHAR,
578 argument67 IN varchar2 default OKC_API.G_MISS_CHAR,
579 argument68 IN varchar2 default OKC_API.G_MISS_CHAR,
580 argument69 IN varchar2 default OKC_API.G_MISS_CHAR,
581 argument70 IN varchar2 default OKC_API.G_MISS_CHAR,
582 argument71 IN varchar2 default OKC_API.G_MISS_CHAR,
583 argument72 IN varchar2 default OKC_API.G_MISS_CHAR,
584 argument73 IN varchar2 default OKC_API.G_MISS_CHAR,
585 argument74 IN varchar2 default OKC_API.G_MISS_CHAR,
586 argument75 IN varchar2 default OKC_API.G_MISS_CHAR,
587 argument76 IN varchar2 default OKC_API.G_MISS_CHAR,
588 argument77 IN varchar2 default OKC_API.G_MISS_CHAR,
589 argument78 IN varchar2 default OKC_API.G_MISS_CHAR,
590 argument79 IN varchar2 default OKC_API.G_MISS_CHAR,
591 argument80 IN varchar2 default OKC_API.G_MISS_CHAR,
592 argument81 IN varchar2 default OKC_API.G_MISS_CHAR,
593 argument82 IN varchar2 default OKC_API.G_MISS_CHAR,
594 argument83 IN varchar2 default OKC_API.G_MISS_CHAR,
595 argument84 IN varchar2 default OKC_API.G_MISS_CHAR,
596 argument85 IN varchar2 default OKC_API.G_MISS_CHAR,
597 argument86 IN varchar2 default OKC_API.G_MISS_CHAR,
598 argument87 IN varchar2 default OKC_API.G_MISS_CHAR,
599 argument88 IN varchar2 default OKC_API.G_MISS_CHAR,
600 argument89 IN varchar2 default OKC_API.G_MISS_CHAR,
601 argument90 IN varchar2 default OKC_API.G_MISS_CHAR,
602 argument91 IN varchar2 default OKC_API.G_MISS_CHAR,
603 argument92 IN varchar2 default OKC_API.G_MISS_CHAR,
604 argument93 IN varchar2 default OKC_API.G_MISS_CHAR,
605 argument94 IN varchar2 default OKC_API.G_MISS_CHAR,
606 argument95 IN varchar2 default OKC_API.G_MISS_CHAR,
607 argument96 IN varchar2 default OKC_API.G_MISS_CHAR,
608 argument97 IN varchar2 default OKC_API.G_MISS_CHAR,
609 argument98 IN varchar2 default OKC_API.G_MISS_CHAR,
610 argument99 IN varchar2 default OKC_API.G_MISS_CHAR,
611 argument100 IN varchar2 default OKC_API.G_MISS_CHAR,
612 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
613 ,x_return_status OUT NOCOPY VARCHAR2
614 ,x_msg_count OUT NOCOPY NUMBER
615 ,x_msg_data OUT NOCOPY VARCHAR2);
616 END OKC_OC_INT_PUB;