8:
9: --Object type procedure for insert
10: PROCEDURE create_ext_ar_txns(
11: 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:
24: l_api_version NUMBER;
25: l_init_msg_list VARCHAR2(1);
26:
61: ,x_xcav_tbl
62: );
63:
64:
65: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
66: RAISE G_EXCEPTION_HALT_VALIDATION;
67: END IF;
68:
69: -- customer post-processing
112:
113: --Object type procedure for update
114: PROCEDURE update_ext_ar_txns(
115: p_api_version IN NUMBER
116: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
119: ,x_msg_data OUT NOCOPY VARCHAR2
120: ,p_xcrv_rec IN xcrv_rec_type
122: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
123: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
124: ) IS
125:
126: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
127:
128: l_api_version NUMBER;
129: l_init_msg_list VARCHAR2(1);
130:
163: ,p_xcav_tbl
164: ,x_xcrv_rec
165: ,x_xcav_tbl
166: );
167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
168: RAISE G_EXCEPTION_HALT_VALIDATION;
169: END IF;
170:
171: -- customer post-processing
212: END update_ext_ar_txns;
213:
214: PROCEDURE update_ext_csh_txns(
215: p_api_version IN NUMBER
216: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
217: ,x_return_status OUT NOCOPY VARCHAR2
218: ,x_msg_count OUT NOCOPY NUMBER
219: ,x_msg_data OUT NOCOPY VARCHAR2
220: ,p_xcrv_rec IN xcrv_rec_type
220: ,p_xcrv_rec IN xcrv_rec_type
221: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
222: ) IS
223:
224: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
225:
226: l_api_version NUMBER;
227: l_init_msg_list VARCHAR2(1);
228:
256: ,p_xcrv_rec
257: ,x_xcrv_rec
258: );
259:
260: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
261: RAISE G_EXCEPTION_HALT_VALIDATION;
262: END IF;
263:
264: -- customer post-processing
305:
306: --Object type procedure for update
307: PROCEDURE delete_ext_ar_txns(
308: p_api_version IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
310: ,x_return_status OUT NOCOPY VARCHAR2
311: ,x_msg_count OUT NOCOPY NUMBER
312: ,x_msg_data OUT NOCOPY VARCHAR2
313: ,p_xcrv_rec IN xcrv_rec_type
315: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
316: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
317: ) IS
318:
319: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
320:
321: l_api_version NUMBER;
322: l_init_msg_list VARCHAR2(1);
323:
356: ,p_xcav_tbl
357: ,x_xcrv_rec
358: ,x_xcav_tbl
359: );
360: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
361: RAISE G_EXCEPTION_HALT_VALIDATION;
362: END IF;
363:
364: -- customer post-processing
406:
407: --Object type procedure for validate
408: PROCEDURE validate_ext_ar_txns(
409: p_api_version IN NUMBER
410: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
411: ,x_return_status OUT NOCOPY VARCHAR2
412: ,x_msg_count OUT NOCOPY NUMBER
413: ,x_msg_data OUT NOCOPY VARCHAR2
414: ,p_xcrv_rec IN xcrv_rec_type
414: ,p_xcrv_rec IN xcrv_rec_type
415: ,p_xcav_tbl IN xcav_tbl_type
416: ) IS
417:
418: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
419:
420: l_api_version NUMBER;
421: l_init_msg_list VARCHAR2(1);
422:
454: ,p_xcrv_rec
455: ,p_xcav_tbl
456: );
457:
458: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
459: RAISE G_EXCEPTION_HALT_VALIDATION;
460: END IF;
461:
462: -- customer post-processing
502:
503: --Object type procedure for lock
504: PROCEDURE lock_ext_ar_txns(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER
509: ,x_msg_data OUT NOCOPY VARCHAR2
510: ,p_xcrv_rec IN xcrv_rec_type
518: ,x_msg_data
519: ,p_xcrv_rec
520: );
521:
522: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
523: RAISE G_EXCEPTION_HALT_VALIDATION;
524: END IF;
525:
526: EXCEPTION
524: END IF;
525:
526: EXCEPTION
527: WHEN G_EXCEPTION_HALT_VALIDATION THEN
528: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN
531: Okl_Api.set_message(p_app_name => g_app_name,
532: p_msg_name => g_unexpected_error,
527: WHEN G_EXCEPTION_HALT_VALIDATION THEN
528: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN
531: Okl_Api.set_message(p_app_name => g_app_name,
532: p_msg_name => g_unexpected_error,
533: p_token1 => g_sqlcode_token,
534: p_token1_value => SQLCODE,
535: p_token2 => g_sqlerrm_token,
533: p_token1 => g_sqlcode_token,
534: p_token1_value => SQLCODE,
535: p_token2 => g_sqlerrm_token,
536: p_token2_value => SQLERRM);
537: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
538: END lock_ext_ar_txns;
539:
540: --Object type procedure for lock
541: PROCEDURE lock_ext_ar_txns(
539:
540: --Object type procedure for lock
541: PROCEDURE lock_ext_ar_txns(
542: p_api_version IN NUMBER
543: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER
546: ,x_msg_data OUT NOCOPY VARCHAR2
547: ,p_xcrv_tbl IN xcrv_tbl_type
555: ,x_msg_data
556: ,p_xcrv_tbl
557: );
558:
559: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
560: RAISE G_EXCEPTION_HALT_VALIDATION;
561: END IF;
562:
563: EXCEPTION
561: END IF;
562:
563: EXCEPTION
564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
565: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
566:
567: WHEN OTHERS THEN
568: Okl_Api.set_message(p_app_name => g_app_name,
569: p_msg_name => g_unexpected_error,
564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
565: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
566:
567: WHEN OTHERS THEN
568: Okl_Api.set_message(p_app_name => g_app_name,
569: p_msg_name => g_unexpected_error,
570: p_token1 => g_sqlcode_token,
571: p_token1_value => SQLCODE,
572: p_token2 => g_sqlerrm_token,
570: p_token1 => g_sqlcode_token,
571: p_token1_value => SQLCODE,
572: p_token2 => g_sqlerrm_token,
573: p_token2_value => SQLERRM);
574: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
575: END lock_ext_ar_txns;
576:
577: --Object type procedure for lock
578: PROCEDURE lock_ext_ar_txns(
576:
577: --Object type procedure for lock
578: PROCEDURE lock_ext_ar_txns(
579: p_api_version IN NUMBER
580: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
581: ,x_return_status OUT NOCOPY VARCHAR2
582: ,x_msg_count OUT NOCOPY NUMBER
583: ,x_msg_data OUT NOCOPY VARCHAR2
584: ,p_xcav_rec IN xcav_rec_type
592: ,x_msg_data
593: ,p_xcav_rec
594: );
595:
596: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
597: RAISE G_EXCEPTION_HALT_VALIDATION;
598: END IF;
599:
600: EXCEPTION
598: END IF;
599:
600: EXCEPTION
601: WHEN G_EXCEPTION_HALT_VALIDATION THEN
602: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
603:
604: WHEN OTHERS THEN
605: Okl_Api.set_message(p_app_name => g_app_name,
606: p_msg_name => g_unexpected_error,
601: WHEN G_EXCEPTION_HALT_VALIDATION THEN
602: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
603:
604: WHEN OTHERS THEN
605: Okl_Api.set_message(p_app_name => g_app_name,
606: p_msg_name => g_unexpected_error,
607: p_token1 => g_sqlcode_token,
608: p_token1_value => SQLCODE,
609: p_token2 => g_sqlerrm_token,
607: p_token1 => g_sqlcode_token,
608: p_token1_value => SQLCODE,
609: p_token2 => g_sqlerrm_token,
610: p_token2_value => SQLERRM);
611: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
612: END lock_ext_ar_txns;
613:
614: --Object type procedure for lock
615: PROCEDURE lock_ext_ar_txns(
613:
614: --Object type procedure for lock
615: PROCEDURE lock_ext_ar_txns(
616: p_api_version IN NUMBER
617: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
618: ,x_return_status OUT NOCOPY VARCHAR2
619: ,x_msg_count OUT NOCOPY NUMBER
620: ,x_msg_data OUT NOCOPY VARCHAR2
621: ,p_xcav_tbl IN xcav_tbl_type
629: ,x_msg_data
630: ,p_xcav_tbl
631: );
632:
633: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
634: RAISE G_EXCEPTION_HALT_VALIDATION;
635: END IF;
636:
637: EXCEPTION
635: END IF;
636:
637: EXCEPTION
638: WHEN G_EXCEPTION_HALT_VALIDATION THEN
639: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
640:
641: WHEN OTHERS THEN
642: Okl_Api.set_message(p_app_name => g_app_name,
643: p_msg_name => g_unexpected_error,
638: WHEN G_EXCEPTION_HALT_VALIDATION THEN
639: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
640:
641: WHEN OTHERS THEN
642: Okl_Api.set_message(p_app_name => g_app_name,
643: p_msg_name => g_unexpected_error,
644: p_token1 => g_sqlcode_token,
645: p_token1_value => SQLCODE,
646: p_token2 => g_sqlerrm_token,
644: p_token1 => g_sqlcode_token,
645: p_token1_value => SQLCODE,
646: p_token2 => g_sqlerrm_token,
647: p_token2_value => SQLERRM);
648: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
649: END lock_ext_ar_txns;
650:
651: END Okl_Xcr_Pub;