335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_oiev_rec IN OKC_OIE_PVT.oiev_rec_type) IS
337:
338: l_olev_tbl OKC_OPER_INST_PUB.olev_tbl_type;
339: l_mrdv_tbl OKC_MRD_PVT.mrdv_tbl_type;
340: i NUMBER := 0;
341: j NUMBER := 0;
342:
343: Cursor ole_csr Is
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:
612: Cursor ole_csr Is
613: SELECT object_chr_id, subject_chr_id, object_cle_id, subject_cle_id
781: p_init_msg_list IN VARCHAR2 ,
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN
782: x_return_status OUT NOCOPY VARCHAR2,
783: x_msg_count OUT NOCOPY NUMBER,
784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN
790: -- initialize return status
784: x_msg_data OUT NOCOPY VARCHAR2,
785: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
786: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
787:
788: l_mrdv_rec OKC_MRD_PVT.mrdv_rec_type := p_mrdv_rec;
789: BEGIN
790: -- initialize return status
791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
792:
789: BEGIN
790: -- initialize return status
791: x_return_status := OKC_API.G_RET_STS_SUCCESS;
792:
793: OKC_MRD_PVT.Insert_Row(
794: p_api_version => p_api_version,
795: p_init_msg_list => p_init_msg_list,
796: x_return_status => x_return_status,
797: x_msg_count => x_msg_count,
806: p_init_msg_list IN VARCHAR2 ,
807: x_return_status OUT NOCOPY VARCHAR2,
808: x_msg_count OUT NOCOPY NUMBER,
809: x_msg_data OUT NOCOPY VARCHAR2,
810: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
812:
813: BEGIN
814:
807: x_return_status OUT NOCOPY VARCHAR2,
808: x_msg_count OUT NOCOPY NUMBER,
809: x_msg_data OUT NOCOPY VARCHAR2,
810: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
812:
813: BEGIN
814:
815: OKC_MRD_PVT.Insert_Row(
811: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
812:
813: BEGIN
814:
815: OKC_MRD_PVT.Insert_Row(
816: p_api_version => p_api_version,
817: p_init_msg_list => p_init_msg_list,
818: x_return_status => x_return_status,
819: x_msg_count => x_msg_count,
828: p_init_msg_list IN VARCHAR2 ,
829: x_return_status OUT NOCOPY VARCHAR2,
830: x_msg_count OUT NOCOPY NUMBER,
831: x_msg_data OUT NOCOPY VARCHAR2,
832: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
834:
835: BEGIN
836:
829: x_return_status OUT NOCOPY VARCHAR2,
830: x_msg_count OUT NOCOPY NUMBER,
831: x_msg_data OUT NOCOPY VARCHAR2,
832: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type,
833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
834:
835: BEGIN
836:
837: OKC_MRD_PVT.Update_Row(
833: x_mrdv_rec OUT NOCOPY OKC_MRD_PVT.mrdv_rec_type) IS
834:
835: BEGIN
836:
837: OKC_MRD_PVT.Update_Row(
838: p_api_version => p_api_version,
839: p_init_msg_list => p_init_msg_list,
840: x_return_status => x_return_status,
841: x_msg_count => x_msg_count,
850: p_init_msg_list IN VARCHAR2 ,
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,
854: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
856:
857: BEGIN
858:
851: x_return_status OUT NOCOPY VARCHAR2,
852: x_msg_count OUT NOCOPY NUMBER,
853: x_msg_data OUT NOCOPY VARCHAR2,
854: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type,
855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
856:
857: BEGIN
858:
859: OKC_MRD_PVT.Update_Row(
855: x_mrdv_tbl OUT NOCOPY OKC_MRD_PVT.mrdv_tbl_type) IS
856:
857: BEGIN
858:
859: OKC_MRD_PVT.Update_Row(
860: p_api_version => p_api_version,
861: p_init_msg_list => p_init_msg_list,
862: x_return_status => x_return_status,
863: x_msg_count => x_msg_count,
872: p_init_msg_list IN VARCHAR2 ,
873: x_return_status OUT NOCOPY VARCHAR2,
874: x_msg_count OUT NOCOPY NUMBER,
875: x_msg_data OUT NOCOPY VARCHAR2,
876: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
877:
878: BEGIN
879: OKC_MRD_PVT.Delete_Row(
880: p_api_version => p_api_version,
875: x_msg_data OUT NOCOPY VARCHAR2,
876: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
877:
878: BEGIN
879: OKC_MRD_PVT.Delete_Row(
880: p_api_version => p_api_version,
881: p_init_msg_list => p_init_msg_list,
882: x_return_status => x_return_status,
883: x_msg_count => x_msg_count,
891: p_init_msg_list IN VARCHAR2 ,
892: x_return_status OUT NOCOPY VARCHAR2,
893: x_msg_count OUT NOCOPY NUMBER,
894: x_msg_data OUT NOCOPY VARCHAR2,
895: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
896:
897: BEGIN
898:
899: OKC_MRD_PVT.Delete_Row(
895: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
896:
897: BEGIN
898:
899: OKC_MRD_PVT.Delete_Row(
900: p_api_version => p_api_version,
901: p_init_msg_list => p_init_msg_list,
902: x_return_status => x_return_status,
903: x_msg_count => x_msg_count,
911: p_init_msg_list IN VARCHAR2 ,
912: x_return_status OUT NOCOPY VARCHAR2,
913: x_msg_count OUT NOCOPY NUMBER,
914: x_msg_data OUT NOCOPY VARCHAR2,
915: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
916:
917: BEGIN
918:
919: OKC_MRD_PVT.Lock_Row(
915: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
916:
917: BEGIN
918:
919: OKC_MRD_PVT.Lock_Row(
920: p_api_version => p_api_version,
921: p_init_msg_list => p_init_msg_list,
922: x_return_status => x_return_status,
923: x_msg_count => x_msg_count,
931: p_init_msg_list IN VARCHAR2 ,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
935: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
936:
937: BEGIN
938:
939: OKC_MRD_PVT.Lock_Row(
935: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
936:
937: BEGIN
938:
939: OKC_MRD_PVT.Lock_Row(
940: p_api_version => p_api_version,
941: p_init_msg_list => p_init_msg_list,
942: x_return_status => x_return_status,
943: x_msg_count => x_msg_count,
951: p_init_msg_list IN VARCHAR2 ,
952: x_return_status OUT NOCOPY VARCHAR2,
953: x_msg_count OUT NOCOPY NUMBER,
954: x_msg_data OUT NOCOPY VARCHAR2,
955: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
956:
957: BEGIN
958:
959: OKC_MRD_PVT.Validate_Row(
955: p_mrdv_rec IN OKC_MRD_PVT.mrdv_rec_type) IS
956:
957: BEGIN
958:
959: OKC_MRD_PVT.Validate_Row(
960: p_api_version => p_api_version,
961: p_init_msg_list => p_init_msg_list,
962: x_return_status => x_return_status,
963: x_msg_count => x_msg_count,
971: p_init_msg_list IN VARCHAR2 ,
972: x_return_status OUT NOCOPY VARCHAR2,
973: x_msg_count OUT NOCOPY NUMBER,
974: x_msg_data OUT NOCOPY VARCHAR2,
975: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
976:
977: BEGIN
978:
979: OKC_MRD_PVT.Validate_Row(
975: p_mrdv_tbl IN OKC_MRD_PVT.mrdv_tbl_type) IS
976:
977: BEGIN
978:
979: OKC_MRD_PVT.Validate_Row(
980: p_api_version => p_api_version,
981: p_init_msg_list => p_init_msg_list,
982: x_return_status => x_return_status,
983: x_msg_count => x_msg_count,