[Home] [Help]
10: x_msg_data OUT NOCOPY VARCHAR2,
11: p_ksqv_rec IN ksqv_rec_type,
12: x_ksqv_rec OUT NOCOPY ksqv_rec_type) IS
13: BEGIN
14: okc_contract_seq_pvt.create_seq_header(
15: p_api_version,
16: p_init_msg_list,
17: x_return_status,
18: x_msg_count,
29: x_msg_data OUT NOCOPY VARCHAR2,
30: p_ksqv_tbl IN ksqv_tbl_type,
31: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type) IS
32: BEGIN
33: okc_contract_seq_pvt.create_seq_header(
34: p_api_version,
35: p_init_msg_list,
36: x_return_status,
37: x_msg_count,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_ksqv_rec IN ksqv_rec_type,
50: x_ksqv_rec OUT NOCOPY ksqv_rec_type) IS
51: BEGIN
52: okc_contract_seq_pvt.update_seq_header(
53: p_api_version,
54: p_init_msg_list,
55: x_return_status,
56: x_msg_count,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_ksqv_tbl IN ksqv_tbl_type,
69: x_ksqv_tbl OUT NOCOPY ksqv_tbl_type) IS
70: BEGIN
71: okc_contract_seq_pvt.update_seq_header(
72: p_api_version,
73: p_init_msg_list,
74: x_return_status,
75: x_msg_count,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: p_ksqv_rec IN ksqv_rec_type) IS
88: BEGIN
89: okc_contract_seq_pvt.delete_seq_header(
90: p_api_version,
91: p_init_msg_list,
92: x_return_status,
93: x_msg_count,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_ksqv_tbl IN ksqv_tbl_type) IS
105: BEGIN
106: okc_contract_seq_pvt.delete_seq_header(
107: p_api_version,
108: p_init_msg_list,
109: x_return_status,
110: x_msg_count,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: p_ksqv_rec IN ksqv_rec_type) IS
122: BEGIN
123: okc_contract_seq_pvt.lock_seq_header(
124: p_api_version,
125: p_init_msg_list,
126: x_return_status,
127: x_msg_count,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_ksqv_tbl IN ksqv_tbl_type) IS
139: BEGIN
140: okc_contract_seq_pvt.lock_seq_header(
141: p_api_version,
142: p_init_msg_list,
143: x_return_status,
144: x_msg_count,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_ksqv_rec IN ksqv_rec_type) IS
156: BEGIN
157: okc_contract_seq_pvt.validate_seq_header(
158: p_api_version,
159: p_init_msg_list,
160: x_return_status,
161: x_msg_count,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2,
172: p_ksqv_tbl IN ksqv_tbl_type) IS
173: BEGIN
174: okc_contract_seq_pvt.validate_seq_header(
175: p_api_version,
176: p_init_msg_list,
177: x_return_status,
178: x_msg_count,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_lsqv_rec IN lsqv_rec_type,
190: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
191: BEGIN
192: okc_contract_seq_pvt.create_seq_lines(
193: p_api_version,
194: p_init_msg_list,
195: x_return_status,
196: x_msg_count,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_lsqv_tbl IN lsqv_tbl_type,
209: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type) IS
210: BEGIN
211: okc_contract_seq_pvt.create_seq_lines(
212: p_api_version,
213: p_init_msg_list,
214: x_return_status,
215: x_msg_count,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_lsqv_rec IN lsqv_rec_type,
228: x_lsqv_rec OUT NOCOPY lsqv_rec_type) IS
229: BEGIN
230: okc_contract_seq_pvt.update_seq_lines(
231: p_api_version,
232: p_init_msg_list,
233: x_return_status,
234: x_msg_count,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_lsqv_tbl IN lsqv_tbl_type,
247: x_lsqv_tbl OUT NOCOPY lsqv_tbl_type) IS
248: BEGIN
249: okc_contract_seq_pvt.update_seq_lines(
250: p_api_version,
251: p_init_msg_list,
252: x_return_status,
253: x_msg_count,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_lsqv_rec IN lsqv_rec_type) IS
266: BEGIN
267: okc_contract_seq_pvt.delete_seq_lines(
268: p_api_version,
269: p_init_msg_list,
270: x_return_status,
271: x_msg_count,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_lsqv_tbl IN lsqv_tbl_type) IS
283: BEGIN
284: okc_contract_seq_pvt.delete_seq_lines(
285: p_api_version,
286: p_init_msg_list,
287: x_return_status,
288: x_msg_count,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_lsqv_rec IN lsqv_rec_type) IS
300: BEGIN
301: okc_contract_seq_pvt.lock_seq_lines(
302: p_api_version,
303: p_init_msg_list,
304: x_return_status,
305: x_msg_count,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: p_lsqv_tbl IN lsqv_tbl_type) IS
317: BEGIN
318: okc_contract_seq_pvt.lock_seq_lines(
319: p_api_version,
320: p_init_msg_list,
321: x_return_status,
322: x_msg_count,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_lsqv_rec IN lsqv_rec_type) IS
334: BEGIN
335: okc_contract_seq_pvt.validate_seq_lines(
336: p_api_version,
337: p_init_msg_list,
338: x_return_status,
339: x_msg_count,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2,
350: p_lsqv_tbl IN lsqv_tbl_type) IS
351: BEGIN
352: okc_contract_seq_pvt.validate_seq_lines(
353: p_api_version,
354: p_init_msg_list,
355: x_return_status,
356: x_msg_count,
361: PROCEDURE Is_K_Autogenerated(
362: p_scs_code Varchar2,
363: x_return_status OUT NOCOPY Varchar2) IS
364: BEGIN
365: okc_contract_seq_pvt.Is_K_Autogenerated(
366: p_scs_code,
367: x_return_status);
368: END Is_K_Autogenerated;
369:
372: p_contract_number_modifier IN VARCHAR2,
373: x_contract_number OUT NOCOPY VARCHAR2,
374: x_return_status OUT NOCOPY VARCHAR2) IS
375: BEGIN
376: okc_contract_seq_pvt.Get_K_Number(
377: p_scs_code,
378: p_contract_number_modifier,
379: x_contract_number,
380: x_return_status);