512: p_init_msg_list IN VARCHAR2 ,
513: x_return_status OUT NOCOPY VARCHAR2,
514: x_msg_count OUT NOCOPY NUMBER,
515: x_msg_data OUT NOCOPY VARCHAR2,
516: p_olev_rec IN OKC_OLE_PVT.olev_rec_type,
517: x_olev_rec OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS
518:
519: l_olev_rec OKC_OLE_PVT.olev_rec_type := p_olev_rec;
520: BEGIN
513: x_return_status OUT NOCOPY VARCHAR2,
514: x_msg_count OUT NOCOPY NUMBER,
515: x_msg_data OUT NOCOPY VARCHAR2,
516: p_olev_rec IN OKC_OLE_PVT.olev_rec_type,
517: x_olev_rec OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS
518:
519: l_olev_rec OKC_OLE_PVT.olev_rec_type := p_olev_rec;
520: BEGIN
521: -- initialize return status
515: x_msg_data OUT NOCOPY VARCHAR2,
516: p_olev_rec IN OKC_OLE_PVT.olev_rec_type,
517: x_olev_rec OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS
518:
519: l_olev_rec OKC_OLE_PVT.olev_rec_type := p_olev_rec;
520: BEGIN
521: -- initialize return status
522: x_return_status := OKC_API.G_RET_STS_SUCCESS;
523:
520: BEGIN
521: -- initialize return status
522: x_return_status := OKC_API.G_RET_STS_SUCCESS;
523:
524: OKC_OLE_PVT.Insert_Row(
525: p_api_version => p_api_version,
526: p_init_msg_list => p_init_msg_list,
527: x_return_status => x_return_status,
528: x_msg_count => x_msg_count,
537: p_init_msg_list IN VARCHAR2 ,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type,
542: x_olev_tbl OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS
543:
544: BEGIN
545:
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type,
542: x_olev_tbl OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS
543:
544: BEGIN
545:
546: OKC_OLE_PVT.Insert_Row(
542: x_olev_tbl OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS
543:
544: BEGIN
545:
546: OKC_OLE_PVT.Insert_Row(
547: p_api_version => p_api_version,
548: p_init_msg_list => p_init_msg_list,
549: x_return_status => x_return_status,
550: x_msg_count => x_msg_count,
559: p_init_msg_list IN VARCHAR2 ,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_olev_rec IN OKC_OLE_PVT.olev_rec_type,
564: x_olev_rec OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS
565:
566: BEGIN
567:
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2,
563: p_olev_rec IN OKC_OLE_PVT.olev_rec_type,
564: x_olev_rec OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS
565:
566: BEGIN
567:
568: OKC_OLE_PVT.Update_Row(
564: x_olev_rec OUT NOCOPY OKC_OLE_PVT.olev_rec_type) IS
565:
566: BEGIN
567:
568: OKC_OLE_PVT.Update_Row(
569: p_api_version => p_api_version,
570: p_init_msg_list => p_init_msg_list,
571: x_return_status => x_return_status,
572: x_msg_count => x_msg_count,
581: p_init_msg_list IN VARCHAR2 ,
582: x_return_status OUT NOCOPY VARCHAR2,
583: x_msg_count OUT NOCOPY NUMBER,
584: x_msg_data OUT NOCOPY VARCHAR2,
585: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type,
586: x_olev_tbl OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS
587:
588: BEGIN
589:
582: x_return_status OUT NOCOPY VARCHAR2,
583: x_msg_count OUT NOCOPY NUMBER,
584: x_msg_data OUT NOCOPY VARCHAR2,
585: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type,
586: x_olev_tbl OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS
587:
588: BEGIN
589:
590: OKC_OLE_PVT.Update_Row(
586: x_olev_tbl OUT NOCOPY OKC_OLE_PVT.olev_tbl_type) IS
587:
588: BEGIN
589:
590: OKC_OLE_PVT.Update_Row(
591: p_api_version => p_api_version,
592: p_init_msg_list => p_init_msg_list,
593: x_return_status => x_return_status,
594: x_msg_count => x_msg_count,
603: p_init_msg_list IN VARCHAR2 ,
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_olev_rec IN OKC_OLE_PVT.olev_rec_type) IS
608:
609: l_mrdv_tbl OKC_MRD_PVT.mrdv_tbl_type;
610: j NUMBER := 0;
611:
665: End if;
666:
667: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
668:
669: OKC_OLE_PVT.Delete_Row(
670: p_api_version => p_api_version,
671: p_init_msg_list => p_init_msg_list,
672: x_return_status => x_return_status,
673: x_msg_count => x_msg_count,
681: p_init_msg_list IN VARCHAR2 ,
682: x_return_status OUT NOCOPY VARCHAR2,
683: x_msg_count OUT NOCOPY NUMBER,
684: x_msg_data OUT NOCOPY VARCHAR2,
685: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type) IS
686:
687: BEGIN
688:
689: OKC_OLE_PVT.Delete_Row(
685: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type) IS
686:
687: BEGIN
688:
689: OKC_OLE_PVT.Delete_Row(
690: p_api_version => p_api_version,
691: p_init_msg_list => p_init_msg_list,
692: x_return_status => x_return_status,
693: x_msg_count => x_msg_count,
701: p_init_msg_list IN VARCHAR2 ,
702: x_return_status OUT NOCOPY VARCHAR2,
703: x_msg_count OUT NOCOPY NUMBER,
704: x_msg_data OUT NOCOPY VARCHAR2,
705: p_olev_rec IN OKC_OLE_PVT.olev_rec_type) IS
706:
707: BEGIN
708:
709: OKC_OLE_PVT.Lock_Row(
705: p_olev_rec IN OKC_OLE_PVT.olev_rec_type) IS
706:
707: BEGIN
708:
709: OKC_OLE_PVT.Lock_Row(
710: p_api_version => p_api_version,
711: p_init_msg_list => p_init_msg_list,
712: x_return_status => x_return_status,
713: x_msg_count => x_msg_count,
721: p_init_msg_list IN VARCHAR2 ,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,
725: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type) IS
726:
727: BEGIN
728:
729: OKC_OLE_PVT.Lock_Row(
725: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type) IS
726:
727: BEGIN
728:
729: OKC_OLE_PVT.Lock_Row(
730: p_api_version => p_api_version,
731: p_init_msg_list => p_init_msg_list,
732: x_return_status => x_return_status,
733: x_msg_count => x_msg_count,
741: p_init_msg_list IN VARCHAR2 ,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_olev_rec IN OKC_OLE_PVT.olev_rec_type) IS
746:
747: BEGIN
748:
749: OKC_OLE_PVT.Validate_Row(
745: p_olev_rec IN OKC_OLE_PVT.olev_rec_type) IS
746:
747: BEGIN
748:
749: OKC_OLE_PVT.Validate_Row(
750: p_api_version => p_api_version,
751: p_init_msg_list => p_init_msg_list,
752: x_return_status => x_return_status,
753: x_msg_count => x_msg_count,
761: p_init_msg_list IN VARCHAR2 ,
762: x_return_status OUT NOCOPY VARCHAR2,
763: x_msg_count OUT NOCOPY NUMBER,
764: x_msg_data OUT NOCOPY VARCHAR2,
765: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type) IS
766:
767: BEGIN
768:
769: OKC_OLE_PVT.Validate_Row(
765: p_olev_tbl IN OKC_OLE_PVT.olev_tbl_type) IS
766:
767: BEGIN
768:
769: OKC_OLE_PVT.Validate_Row(
770: p_api_version => p_api_version,
771: p_init_msg_list => p_init_msg_list,
772: x_return_status => x_return_status,
773: x_msg_count => x_msg_count,