3828: p_init_msg_list IN VARCHAR2 ,
3829: x_return_status OUT NOCOPY VARCHAR2,
3830: x_msg_count OUT NOCOPY NUMBER,
3831: x_msg_data OUT NOCOPY VARCHAR2,
3832: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
3833: x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type) IS
3834:
3835: BEGIN
3836: OKC_CAC_PVT.Insert_Row(
3829: x_return_status OUT NOCOPY VARCHAR2,
3830: x_msg_count OUT NOCOPY NUMBER,
3831: x_msg_data OUT NOCOPY VARCHAR2,
3832: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
3833: x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type) IS
3834:
3835: BEGIN
3836: OKC_CAC_PVT.Insert_Row(
3837: p_api_version => p_api_version,
3832: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
3833: x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type) IS
3834:
3835: BEGIN
3836: OKC_CAC_PVT.Insert_Row(
3837: p_api_version => p_api_version,
3838: p_init_msg_list => p_init_msg_list,
3839: x_return_status => x_return_status,
3840: x_msg_count => x_msg_count,
3853: p_init_msg_list IN VARCHAR2 ,
3854: x_return_status OUT NOCOPY VARCHAR2,
3855: x_msg_count OUT NOCOPY NUMBER,
3856: x_msg_data OUT NOCOPY VARCHAR2,
3857: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
3858: x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type) IS
3859:
3860: BEGIN
3861: OKC_CAC_PVT.Insert_Row(
3854: x_return_status OUT NOCOPY VARCHAR2,
3855: x_msg_count OUT NOCOPY NUMBER,
3856: x_msg_data OUT NOCOPY VARCHAR2,
3857: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
3858: x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type) IS
3859:
3860: BEGIN
3861: OKC_CAC_PVT.Insert_Row(
3862: p_api_version => p_api_version,
3857: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
3858: x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type) IS
3859:
3860: BEGIN
3861: OKC_CAC_PVT.Insert_Row(
3862: p_api_version => p_api_version,
3863: p_init_msg_list => p_init_msg_list,
3864: x_return_status => x_return_status,
3865: x_msg_count => x_msg_count,
3873: p_init_msg_list IN VARCHAR2 ,
3874: x_return_status OUT NOCOPY VARCHAR2,
3875: x_msg_count OUT NOCOPY NUMBER,
3876: x_msg_data OUT NOCOPY VARCHAR2,
3877: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
3878: x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type) IS
3879:
3880: BEGIN
3881: OKC_CAC_PVT.Update_Row(
3874: x_return_status OUT NOCOPY VARCHAR2,
3875: x_msg_count OUT NOCOPY NUMBER,
3876: x_msg_data OUT NOCOPY VARCHAR2,
3877: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
3878: x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type) IS
3879:
3880: BEGIN
3881: OKC_CAC_PVT.Update_Row(
3882: p_api_version => p_api_version,
3877: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
3878: x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type) IS
3879:
3880: BEGIN
3881: OKC_CAC_PVT.Update_Row(
3882: p_api_version => p_api_version,
3883: p_init_msg_list => p_init_msg_list,
3884: x_return_status => x_return_status,
3885: x_msg_count => x_msg_count,
3898: p_init_msg_list IN VARCHAR2 ,
3899: x_return_status OUT NOCOPY VARCHAR2,
3900: x_msg_count OUT NOCOPY NUMBER,
3901: x_msg_data OUT NOCOPY VARCHAR2,
3902: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
3903: x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type) IS
3904:
3905: BEGIN
3906: OKC_CAC_PVT.Update_Row(
3899: x_return_status OUT NOCOPY VARCHAR2,
3900: x_msg_count OUT NOCOPY NUMBER,
3901: x_msg_data OUT NOCOPY VARCHAR2,
3902: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
3903: x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type) IS
3904:
3905: BEGIN
3906: OKC_CAC_PVT.Update_Row(
3907: p_api_version => p_api_version,
3902: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
3903: x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type) IS
3904:
3905: BEGIN
3906: OKC_CAC_PVT.Update_Row(
3907: p_api_version => p_api_version,
3908: p_init_msg_list => p_init_msg_list,
3909: x_return_status => x_return_status,
3910: x_msg_count => x_msg_count,
3918: p_init_msg_list IN VARCHAR2 ,
3919: x_return_status OUT NOCOPY VARCHAR2,
3920: x_msg_count OUT NOCOPY NUMBER,
3921: x_msg_data OUT NOCOPY VARCHAR2,
3922: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type) IS
3923:
3924: l_chr_id NUMBER;
3925: l_not_found BOOLEAN;
3926: Cursor l_cacv_csr Is
3945: p_token2_value => sqlerrm);
3946: return;
3947: End If;
3948:
3949: OKC_CAC_PVT.Delete_Row(
3950: p_api_version => p_api_version,
3951: p_init_msg_list => p_init_msg_list,
3952: x_return_status => x_return_status,
3953: x_msg_count => x_msg_count,
3965: p_init_msg_list IN VARCHAR2 ,
3966: x_return_status OUT NOCOPY VARCHAR2,
3967: x_msg_count OUT NOCOPY NUMBER,
3968: x_msg_data OUT NOCOPY VARCHAR2,
3969: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type) IS
3970:
3971: BEGIN
3972: OKC_CAC_PVT.Delete_Row(
3973: p_api_version => p_api_version,
3968: x_msg_data OUT NOCOPY VARCHAR2,
3969: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type) IS
3970:
3971: BEGIN
3972: OKC_CAC_PVT.Delete_Row(
3973: p_api_version => p_api_version,
3974: p_init_msg_list => p_init_msg_list,
3975: x_return_status => x_return_status,
3976: x_msg_count => x_msg_count,
3983: p_init_msg_list IN VARCHAR2 ,
3984: x_return_status OUT NOCOPY VARCHAR2,
3985: x_msg_count OUT NOCOPY NUMBER,
3986: x_msg_data OUT NOCOPY VARCHAR2,
3987: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type) IS
3988:
3989: BEGIN
3990: OKC_CAC_PVT.Lock_Row(
3991: p_api_version => p_api_version,
3986: x_msg_data OUT NOCOPY VARCHAR2,
3987: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type) IS
3988:
3989: BEGIN
3990: OKC_CAC_PVT.Lock_Row(
3991: p_api_version => p_api_version,
3992: p_init_msg_list => p_init_msg_list,
3993: x_return_status => x_return_status,
3994: x_msg_count => x_msg_count,
4001: p_init_msg_list IN VARCHAR2 ,
4002: x_return_status OUT NOCOPY VARCHAR2,
4003: x_msg_count OUT NOCOPY NUMBER,
4004: x_msg_data OUT NOCOPY VARCHAR2,
4005: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type) IS
4006:
4007: BEGIN
4008: OKC_CAC_PVT.Lock_Row(
4009: p_api_version => p_api_version,
4004: x_msg_data OUT NOCOPY VARCHAR2,
4005: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type) IS
4006:
4007: BEGIN
4008: OKC_CAC_PVT.Lock_Row(
4009: p_api_version => p_api_version,
4010: p_init_msg_list => p_init_msg_list,
4011: x_return_status => x_return_status,
4012: x_msg_count => x_msg_count,
4019: p_init_msg_list IN VARCHAR2 ,
4020: x_return_status OUT NOCOPY VARCHAR2,
4021: x_msg_count OUT NOCOPY NUMBER,
4022: x_msg_data OUT NOCOPY VARCHAR2,
4023: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type) IS
4024:
4025: BEGIN
4026: OKC_CAC_PVT.Validate_Row(
4027: p_api_version => p_api_version,
4022: x_msg_data OUT NOCOPY VARCHAR2,
4023: p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type) IS
4024:
4025: BEGIN
4026: OKC_CAC_PVT.Validate_Row(
4027: p_api_version => p_api_version,
4028: p_init_msg_list => p_init_msg_list,
4029: x_return_status => x_return_status,
4030: x_msg_count => x_msg_count,
4037: p_init_msg_list IN VARCHAR2 ,
4038: x_return_status OUT NOCOPY VARCHAR2,
4039: x_msg_count OUT NOCOPY NUMBER,
4040: x_msg_data OUT NOCOPY VARCHAR2,
4041: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type) IS
4042:
4043: BEGIN
4044: OKC_CAC_PVT.Validate_Row(
4045: p_api_version => p_api_version,
4040: x_msg_data OUT NOCOPY VARCHAR2,
4041: p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type) IS
4042:
4043: BEGIN
4044: OKC_CAC_PVT.Validate_Row(
4045: p_api_version => p_api_version,
4046: p_init_msg_list => p_init_msg_list,
4047: x_return_status => x_return_status,
4048: x_msg_count => x_msg_count,