8: END ADD_LANGUAGE;
9:
10: --Object type procedure for insert
11: PROCEDURE create_ext_csh_txns( p_api_version IN NUMBER
12: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,x_msg_count OUT NOCOPY NUMBER
15: ,x_msg_data OUT NOCOPY VARCHAR2
16: ,p_xcrv_rec IN xcrv_rec_type
18: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
19: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
20: ) IS
21:
22: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
23: l_xcrv_rec xcrv_rec_type := p_xcrv_rec;
24: l_xcav_tbl xcav_tbl_type := p_xcav_tbl;
25: i NUMBER;
26: j NUMBER;
36: ,l_xcrv_rec
37: ,x_xcrv_rec
38: );
39:
40: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
41: RAISE G_EXCEPTION_HALT_VALIDATION;
42: ELSE
43: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
44: l_return_status := x_return_status;
39:
40: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
41: RAISE G_EXCEPTION_HALT_VALIDATION;
42: ELSE
43: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
44: l_return_status := x_return_status;
45: END IF;
46: END IF;
47:
64: ,l_xcav_tbl
65: ,x_xcav_tbl
66: );
67:
68: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
69: RAISE G_EXCEPTION_HALT_VALIDATION;
70: ELSE
71: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
72: l_return_status := x_return_status;
67:
68: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
69: RAISE G_EXCEPTION_HALT_VALIDATION;
70: ELSE
71: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
72: l_return_status := x_return_status;
73: END IF;
74: END IF;
75:
74: END IF;
75:
76: EXCEPTION
77: WHEN G_EXCEPTION_HALT_VALIDATION THEN
78: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
79:
80: WHEN OTHERS THEN
81: Okl_Api.set_message(p_app_name => g_app_name,
82: p_msg_name => g_unexpected_error,
77: WHEN G_EXCEPTION_HALT_VALIDATION THEN
78: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
79:
80: WHEN OTHERS THEN
81: Okl_Api.set_message(p_app_name => g_app_name,
82: p_msg_name => g_unexpected_error,
83: p_token1 => g_sqlcode_token,
84: p_token1_value => SQLCODE,
85: p_token2 => g_sqlerrm_token,
83: p_token1 => g_sqlcode_token,
84: p_token1_value => SQLCODE,
85: p_token2 => g_sqlerrm_token,
86: p_token2_value => SQLERRM);
87: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
88: END create_ext_csh_txns;
89:
90: --Object type procedure for update
91: PROCEDURE update_ext_csh_txns( p_api_version IN NUMBER
88: END create_ext_csh_txns;
89:
90: --Object type procedure for update
91: PROCEDURE update_ext_csh_txns( p_api_version IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
93: ,x_return_status OUT NOCOPY VARCHAR2
94: ,x_msg_count OUT NOCOPY NUMBER
95: ,x_msg_data OUT NOCOPY VARCHAR2
96: ,p_xcrv_rec IN xcrv_rec_type
98: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
99: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
100: ) IS
101:
102: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
103:
104: BEGIN
105:
106: --Update the master
112: ,p_xcrv_rec
113: ,x_xcrv_rec
114: );
115:
116: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
117: RAISE G_EXCEPTION_HALT_VALIDATION;
118: ELSE
119: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
120: l_return_status := x_return_status;
115:
116: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
117: RAISE G_EXCEPTION_HALT_VALIDATION;
118: ELSE
119: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
120: l_return_status := x_return_status;
121: END IF;
122: END IF;
123:
130: ,p_xcav_tbl
131: ,x_xcav_tbl
132: );
133:
134: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
135: RAISE G_EXCEPTION_HALT_VALIDATION;
136: ELSE
137: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
138: l_return_status := x_return_status;
133:
134: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
135: RAISE G_EXCEPTION_HALT_VALIDATION;
136: ELSE
137: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
138: l_return_status := x_return_status;
139: END IF;
140: END IF;
141:
140: END IF;
141:
142: EXCEPTION
143: WHEN G_EXCEPTION_HALT_VALIDATION THEN
144: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
145:
146: WHEN OTHERS THEN
147: Okl_Api.set_message( p_app_name => g_app_name
148: ,p_msg_name => g_unexpected_error
143: WHEN G_EXCEPTION_HALT_VALIDATION THEN
144: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
145:
146: WHEN OTHERS THEN
147: Okl_Api.set_message( p_app_name => g_app_name
148: ,p_msg_name => g_unexpected_error
149: ,p_token1 => g_sqlcode_token
150: ,p_token1_value => SQLCODE
151: ,p_token2 => g_sqlerrm_token
151: ,p_token2 => g_sqlerrm_token
152: ,p_token2_value => SQLERRM
153: );
154:
155: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
156:
157: END update_ext_csh_txns;
158:
159: --Object type procedure for update
157: END update_ext_csh_txns;
158:
159: --Object type procedure for update
160: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
161: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
165: ,p_xcrv_rec IN xcrv_rec_type
167: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
168: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
169: ) IS
170:
171: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
172:
173: BEGIN
174:
175: --Update the master
181: ,p_xcrv_rec
182: );
183:
184:
185: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
186: RAISE G_EXCEPTION_HALT_VALIDATION;
187: ELSE
188: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
189: l_return_status := x_return_status;
184:
185: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
186: RAISE G_EXCEPTION_HALT_VALIDATION;
187: ELSE
188: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
189: l_return_status := x_return_status;
190: END IF;
191: END IF;
192:
198: ,x_msg_data
199: ,p_xcav_tbl
200: );
201:
202: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
203: RAISE G_EXCEPTION_HALT_VALIDATION;
204: ELSE
205: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
206: l_return_status := x_return_status;
201:
202: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
203: RAISE G_EXCEPTION_HALT_VALIDATION;
204: ELSE
205: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
206: l_return_status := x_return_status;
207: END IF;
208: END IF;
209:
208: END IF;
209:
210: EXCEPTION
211: WHEN G_EXCEPTION_HALT_VALIDATION THEN
212: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
213:
214: WHEN OTHERS THEN
215: Okl_Api.set_message( p_app_name => g_app_name
216: ,p_msg_name => g_unexpected_error
211: WHEN G_EXCEPTION_HALT_VALIDATION THEN
212: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
213:
214: WHEN OTHERS THEN
215: Okl_Api.set_message( p_app_name => g_app_name
216: ,p_msg_name => g_unexpected_error
217: ,p_token1 => g_sqlcode_token
218: ,p_token1_value => SQLCODE
219: ,p_token2 => g_sqlerrm_token
219: ,p_token2 => g_sqlerrm_token
220: ,p_token2_value => SQLERRM
221: );
222:
223: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
224:
225: END delete_ext_csh_txns;
226:
227: --Object type procedure for validate
225: END delete_ext_csh_txns;
226:
227: --Object type procedure for validate
228: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
229: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
230: ,x_return_status OUT NOCOPY VARCHAR2
231: ,x_msg_count OUT NOCOPY NUMBER
232: ,x_msg_data OUT NOCOPY VARCHAR2
233: ,p_xcrv_rec IN xcrv_rec_type
233: ,p_xcrv_rec IN xcrv_rec_type
234: ,p_xcav_tbl IN xcav_tbl_type
235: ) IS
236:
237: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
238:
239: BEGIN
240:
241: --Validate the Master
246: ,x_msg_data
247: ,p_xcrv_rec
248: );
249:
250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
251: RAISE G_EXCEPTION_HALT_VALIDATION;
252: ELSE
253: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
254: l_return_status := x_return_status;
249:
250: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
251: RAISE G_EXCEPTION_HALT_VALIDATION;
252: ELSE
253: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
254: l_return_status := x_return_status;
255: END IF;
256: END IF;
257:
263: ,x_msg_data
264: ,p_xcav_tbl
265: );
266:
267: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
268: RAISE G_EXCEPTION_HALT_VALIDATION;
269: ELSE
270: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
271: l_return_status := x_return_status;
266:
267: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
268: RAISE G_EXCEPTION_HALT_VALIDATION;
269: ELSE
270: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
271: l_return_status := x_return_status;
272: END IF;
273: END IF;
274:
273: END IF;
274:
275: EXCEPTION
276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
277: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
278:
279: WHEN OTHERS THEN
280: Okl_Api.set_message(p_app_name => g_app_name,
281: p_msg_name => g_unexpected_error,
276: WHEN G_EXCEPTION_HALT_VALIDATION THEN
277: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
278:
279: WHEN OTHERS THEN
280: Okl_Api.set_message(p_app_name => g_app_name,
281: p_msg_name => g_unexpected_error,
282: p_token1 => g_sqlcode_token,
283: p_token1_value => SQLCODE,
284: p_token2 => g_sqlerrm_token,
282: p_token1 => g_sqlcode_token,
283: p_token1_value => SQLCODE,
284: p_token2 => g_sqlerrm_token,
285: p_token2_value => SQLERRM);
286: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
287: END validate_ext_csh_txns;
288:
289: PROCEDURE create_ext_csh_txns( p_api_version IN NUMBER
290: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
286: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
287: END validate_ext_csh_txns;
288:
289: PROCEDURE create_ext_csh_txns( p_api_version IN NUMBER
290: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
293: ,x_msg_data OUT NOCOPY VARCHAR2
294: ,p_xcrv_rec IN xcrv_rec_type
303: ,p_xcrv_rec
304: ,x_xcrv_rec
305: );
306:
307: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
308: NULL;
309: -- Custom code by developer Update_Minor_Version(p_xcrv_rec.dnz_chr_id);
310: END IF;
311:
311:
312: END create_ext_csh_txns;
313:
314: PROCEDURE create_ext_csh_txns( p_api_version IN NUMBER
315: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,p_xcrv_tbl IN xcrv_tbl_type
331:
332: END create_ext_csh_txns;
333:
334: PROCEDURE lock_ext_csh_txns( p_api_version IN NUMBER
335: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
336: ,x_return_status OUT NOCOPY VARCHAR2
337: ,x_msg_count OUT NOCOPY NUMBER
338: ,x_msg_data OUT NOCOPY VARCHAR2
339: ,p_xcrv_rec IN xcrv_rec_type
348: );
349: END lock_ext_csh_txns;
350:
351: PROCEDURE lock_ext_csh_txns( p_api_version IN NUMBER
352: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
355: ,x_msg_data OUT NOCOPY VARCHAR2
356: ,p_xcrv_tbl IN xcrv_tbl_type
365: );
366: END lock_ext_csh_txns;
367:
368: PROCEDURE update_ext_csh_txns( p_api_version IN NUMBER
369: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
370: ,x_return_status OUT NOCOPY VARCHAR2
371: ,x_msg_count OUT NOCOPY NUMBER
372: ,x_msg_data OUT NOCOPY VARCHAR2
373: ,p_xcrv_rec IN xcrv_rec_type
383: ,p_xcrv_rec
384: ,x_xcrv_rec
385: );
386:
387: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
388: NULL;
389: -- Custom code by developer Update_Minor_Version(p_xcrv_rec.dnz_chr_id);
390: END IF;
391: END update_ext_csh_txns;
390: END IF;
391: END update_ext_csh_txns;
392:
393: PROCEDURE update_ext_csh_txns( p_api_version IN NUMBER
394: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
395: ,x_return_status OUT NOCOPY VARCHAR2
396: ,x_msg_count OUT NOCOPY NUMBER
397: ,x_msg_data OUT NOCOPY VARCHAR2
398: ,p_xcrv_tbl IN xcrv_tbl_type
410: END update_ext_csh_txns;
411:
412: --Put custom code for cascade delete by developer
413: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
414: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
415: ,x_return_status OUT NOCOPY VARCHAR2
416: ,x_msg_count OUT NOCOPY NUMBER
417: ,x_msg_data OUT NOCOPY VARCHAR2
418: ,p_xcrv_rec IN xcrv_rec_type
418: ,p_xcrv_rec IN xcrv_rec_type
419: ) IS
420:
421: i NUMBER :=0;
422: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
423: BEGIN
424: --Delete the Master
425: Okl_Xcr_Pvt.delete_row( p_api_version
426: ,p_init_msg_list
429: ,x_msg_data
430: ,p_xcrv_rec
431: );
432:
433: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
434: RAISE G_EXCEPTION_HALT_VALIDATION;
435: ELSE
436: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
437: l_return_status := x_return_status;
432:
433: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
434: RAISE G_EXCEPTION_HALT_VALIDATION;
435: ELSE
436: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
437: l_return_status := x_return_status;
438: END IF;
439: END IF;
440: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
436: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
437: l_return_status := x_return_status;
438: END IF;
439: END IF;
440: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
441: NULL;
442: -- Custom Code by developer Update_Minor_Version(p_xcrv_rec.dnz_chr_id);
443: END IF;
444:
446: WHEN G_EXCEPTION_HALT_VALIDATION THEN
447: NULL;
448:
449: WHEN OTHERS THEN
450: Okl_Api.set_message(p_app_name => g_app_name,
451: p_msg_name => g_unexpected_error,
452: p_token1 => g_sqlcode_token,
453: p_token1_value => SQLCODE,
454: p_token2 => g_sqlerrm_token,
452: p_token1 => g_sqlcode_token,
453: p_token1_value => SQLCODE,
454: p_token2 => g_sqlerrm_token,
455: p_token2_value => SQLERRM);
456: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
457: END delete_ext_csh_txns;
458:
459: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
460: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
456: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
457: END delete_ext_csh_txns;
458:
459: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
460: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
461: ,x_return_status OUT NOCOPY VARCHAR2
462: ,x_msg_count OUT NOCOPY NUMBER
463: ,x_msg_data OUT NOCOPY VARCHAR2
464: ,p_xcrv_tbl IN xcrv_tbl_type
464: ,p_xcrv_tbl IN xcrv_tbl_type
465: ) IS
466:
467: i NUMBER :=0;
468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
469:
470: BEGIN
471: --Initialize the return status
472: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
468: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
469:
470: BEGIN
471: --Initialize the return status
472: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
473:
474: IF (p_xcrv_tbl.COUNT > 0) THEN
475: i := p_xcrv_tbl.FIRST;
476: LOOP
484: EXIT WHEN (i = p_xcrv_tbl.LAST);
485: i := p_xcrv_tbl.NEXT(i);
486: END LOOP;
487: END IF;
488: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
489: RAISE G_EXCEPTION_HALT_VALIDATION;
490: ELSE
491: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
492: l_return_status := x_return_status;
487: END IF;
488: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
489: RAISE G_EXCEPTION_HALT_VALIDATION;
490: ELSE
491: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
492: l_return_status := x_return_status;
493: END IF;
494: END IF;
495: EXCEPTION
496: WHEN G_EXCEPTION_HALT_VALIDATION THEN
497: NULL;
498:
499: WHEN OTHERS THEN
500: Okl_Api.set_message(p_app_name => g_app_name,
501: p_msg_name => g_unexpected_error,
502: p_token1 => g_sqlcode_token,
503: p_token1_value => SQLCODE,
504: p_token2 => g_sqlerrm_token,
502: p_token1 => g_sqlcode_token,
503: p_token1_value => SQLCODE,
504: p_token2 => g_sqlerrm_token,
505: p_token2_value => SQLERRM);
506: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
507: END delete_ext_csh_txns;
508:
509: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
510: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
506: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
507: END delete_ext_csh_txns;
508:
509: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
510: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
511: ,x_return_status OUT NOCOPY VARCHAR2
512: ,x_msg_count OUT NOCOPY NUMBER
513: ,x_msg_data OUT NOCOPY VARCHAR2
514: ,p_xcrv_rec IN xcrv_rec_type
524: );
525: END validate_ext_csh_txns;
526:
527: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
528: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
529: ,x_return_status OUT NOCOPY VARCHAR2
530: ,x_msg_count OUT NOCOPY NUMBER
531: ,x_msg_data OUT NOCOPY VARCHAR2
532: ,p_xcrv_tbl IN xcrv_tbl_type
541: );
542: END validate_ext_csh_txns;
543:
544: PROCEDURE create_ext_csh_txns( p_api_version IN NUMBER
545: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
546: ,x_return_status OUT NOCOPY VARCHAR2
547: ,x_msg_count OUT NOCOPY NUMBER
548: ,x_msg_data OUT NOCOPY VARCHAR2
549: ,p_xcav_rec IN xcav_rec_type
558: ,p_xcav_rec
559: ,x_xcav_rec
560: );
561:
562: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
563: NULL;
564: -- Custom code by developer Update_Minor_Version(p_xcav_rec.dnz_chr_id);
565: END IF;
566:
566:
567: END create_ext_csh_txns;
568:
569: PROCEDURE create_ext_csh_txns( p_api_version IN NUMBER
570: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
571: ,x_return_status OUT NOCOPY VARCHAR2
572: ,x_msg_count OUT NOCOPY NUMBER
573: ,x_msg_data OUT NOCOPY VARCHAR2
574: ,p_xcav_tbl IN xcav_tbl_type
585: );
586: END create_ext_csh_txns;
587:
588: PROCEDURE lock_ext_csh_txns( p_api_version IN NUMBER
589: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
590: ,x_return_status OUT NOCOPY VARCHAR2
591: ,x_msg_count OUT NOCOPY NUMBER
592: ,x_msg_data OUT NOCOPY VARCHAR2
593: ,p_xcav_rec IN xcav_rec_type
602: );
603: END lock_ext_csh_txns;
604:
605: PROCEDURE lock_ext_csh_txns( p_api_version IN NUMBER
606: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
607: ,x_return_status OUT NOCOPY VARCHAR2
608: ,x_msg_count OUT NOCOPY NUMBER
609: ,x_msg_data OUT NOCOPY VARCHAR2
610: ,p_xcav_tbl IN xcav_tbl_type
619: );
620: END lock_ext_csh_txns;
621:
622: PROCEDURE update_ext_csh_txns( p_api_version IN NUMBER
623: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
624: ,x_return_status OUT NOCOPY VARCHAR2
625: ,x_msg_count OUT NOCOPY NUMBER
626: ,x_msg_data OUT NOCOPY VARCHAR2
627: ,p_xcav_rec IN xcav_rec_type
636: ,p_xcav_rec
637: ,x_xcav_rec
638: );
639:
640: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
641: NULL;
642: -- Custom code by developer Update_Minor_Version(p_xcav_rec.id);
643: END IF;
644: END update_ext_csh_txns;
643: END IF;
644: END update_ext_csh_txns;
645:
646: PROCEDURE update_ext_csh_txns( p_api_version IN NUMBER
647: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
648: ,x_return_status OUT NOCOPY VARCHAR2
649: ,x_msg_count OUT NOCOPY NUMBER
650: ,x_msg_data OUT NOCOPY VARCHAR2
651: ,p_xcav_tbl IN xcav_tbl_type
663: END update_ext_csh_txns;
664:
665: --Put custom code for cascade delete by developer
666: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
667: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
668: ,x_return_status OUT NOCOPY VARCHAR2
669: ,x_msg_count OUT NOCOPY NUMBER
670: ,x_msg_data OUT NOCOPY VARCHAR2
671: ,p_xcav_rec IN xcav_rec_type
670: ,x_msg_data OUT NOCOPY VARCHAR2
671: ,p_xcav_rec IN xcav_rec_type
672: ) IS
673: i NUMBER :=0;
674: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
675: BEGIN
676: --Delete the Master
677: Okl_Xca_Pvt.delete_row( p_api_version
678: ,p_init_msg_list
681: ,x_msg_data
682: ,p_xcav_rec
683: );
684:
685: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
686: RAISE G_EXCEPTION_HALT_VALIDATION;
687: ELSE
688: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
689: l_return_status := x_return_status;
684:
685: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
686: RAISE G_EXCEPTION_HALT_VALIDATION;
687: ELSE
688: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
689: l_return_status := x_return_status;
690: END IF;
691: END IF;
692: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
688: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
689: l_return_status := x_return_status;
690: END IF;
691: END IF;
692: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
693: NULL;
694: -- Custom Code by developer Update_Minor_Version(p_xcav_rec.dnz_chr_id);
695: END IF;
696:
698: WHEN G_EXCEPTION_HALT_VALIDATION THEN
699: NULL;
700:
701: WHEN OTHERS THEN
702: Okl_Api.set_message(p_app_name => g_app_name,
703: p_msg_name => g_unexpected_error,
704: p_token1 => g_sqlcode_token,
705: p_token1_value => SQLCODE,
706: p_token2 => g_sqlerrm_token,
704: p_token1 => g_sqlcode_token,
705: p_token1_value => SQLCODE,
706: p_token2 => g_sqlerrm_token,
707: p_token2_value => SQLERRM);
708: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
709: END delete_ext_csh_txns;
710:
711: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
712: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
708: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
709: END delete_ext_csh_txns;
710:
711: PROCEDURE delete_ext_csh_txns( p_api_version IN NUMBER
712: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
713: ,x_return_status OUT NOCOPY VARCHAR2
714: ,x_msg_count OUT NOCOPY NUMBER
715: ,x_msg_data OUT NOCOPY VARCHAR2
716: ,p_xcav_tbl IN xcav_tbl_type
716: ,p_xcav_tbl IN xcav_tbl_type
717: ) IS
718:
719: i NUMBER :=0;
720: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
721: BEGIN
722: --Initialize the return status
723: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
724:
719: i NUMBER :=0;
720: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
721: BEGIN
722: --Initialize the return status
723: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
724:
725: IF (p_xcav_tbl.COUNT > 0) THEN
726: i := p_xcav_tbl.FIRST;
727: LOOP
736: EXIT WHEN (i = p_xcav_tbl.LAST);
737: i := p_xcav_tbl.NEXT(i);
738: END LOOP;
739: END IF;
740: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
741: RAISE G_EXCEPTION_HALT_VALIDATION;
742: ELSE
743: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
744: l_return_status := x_return_status;
739: END IF;
740: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
741: RAISE G_EXCEPTION_HALT_VALIDATION;
742: ELSE
743: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
744: l_return_status := x_return_status;
745: END IF;
746: END IF;
747: EXCEPTION
748: WHEN G_EXCEPTION_HALT_VALIDATION THEN
749: NULL;
750:
751: WHEN OTHERS THEN
752: Okl_Api.set_message(p_app_name => g_app_name,
753: p_msg_name => g_unexpected_error,
754: p_token1 => g_sqlcode_token,
755: p_token1_value => SQLCODE,
756: p_token2 => g_sqlerrm_token,
754: p_token1 => g_sqlcode_token,
755: p_token1_value => SQLCODE,
756: p_token2 => g_sqlerrm_token,
757: p_token2_value => SQLERRM);
758: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
759: END delete_ext_csh_txns;
760:
761: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
762: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
758: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
759: END delete_ext_csh_txns;
760:
761: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
762: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
763: ,x_return_status OUT NOCOPY VARCHAR2
764: ,x_msg_count OUT NOCOPY NUMBER
765: ,x_msg_data OUT NOCOPY VARCHAR2
766: ,p_xcav_rec IN xcav_rec_type
776: );
777: END validate_ext_csh_txns;
778:
779: PROCEDURE validate_ext_csh_txns( p_api_version IN NUMBER
780: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
781: ,x_return_status OUT NOCOPY VARCHAR2
782: ,x_msg_count OUT NOCOPY NUMBER
783: ,x_msg_data OUT NOCOPY VARCHAR2
784: ,p_xcav_tbl IN xcav_tbl_type