3541: p_init_msg_list IN VARCHAR2 ,
3542: x_return_status OUT NOCOPY VARCHAR2,
3543: x_msg_count OUT NOCOPY NUMBER,
3544: x_msg_data OUT NOCOPY VARCHAR2,
3545: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3546: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3547:
3548: BEGIN
3549: OKC_CPS_PVT.Insert_Row(
3542: x_return_status OUT NOCOPY VARCHAR2,
3543: x_msg_count OUT NOCOPY NUMBER,
3544: x_msg_data OUT NOCOPY VARCHAR2,
3545: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3546: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3547:
3548: BEGIN
3549: OKC_CPS_PVT.Insert_Row(
3550: p_api_version => p_api_version,
3545: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3546: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3547:
3548: BEGIN
3549: OKC_CPS_PVT.Insert_Row(
3550: p_api_version => p_api_version,
3551: p_init_msg_list => p_init_msg_list,
3552: x_return_status => x_return_status,
3553: x_msg_count => x_msg_count,
3569: p_init_msg_list IN VARCHAR2 ,
3570: x_return_status OUT NOCOPY VARCHAR2,
3571: x_msg_count OUT NOCOPY NUMBER,
3572: x_msg_data OUT NOCOPY VARCHAR2,
3573: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3574: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3575:
3576: BEGIN
3577: OKC_CPS_PVT.Insert_Row(
3570: x_return_status OUT NOCOPY VARCHAR2,
3571: x_msg_count OUT NOCOPY NUMBER,
3572: x_msg_data OUT NOCOPY VARCHAR2,
3573: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3574: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3575:
3576: BEGIN
3577: OKC_CPS_PVT.Insert_Row(
3578: p_api_version => p_api_version,
3573: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3574: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3575:
3576: BEGIN
3577: OKC_CPS_PVT.Insert_Row(
3578: p_api_version => p_api_version,
3579: p_init_msg_list => p_init_msg_list,
3580: x_return_status => x_return_status,
3581: x_msg_count => x_msg_count,
3589: p_init_msg_list IN VARCHAR2 ,
3590: x_return_status OUT NOCOPY VARCHAR2,
3591: x_msg_count OUT NOCOPY NUMBER,
3592: x_msg_data OUT NOCOPY VARCHAR2,
3593: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3594: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3595:
3596: l_process_active_yn VARCHAR2(1) := 'N';
3597: BEGIN
3590: x_return_status OUT NOCOPY VARCHAR2,
3591: x_msg_count OUT NOCOPY NUMBER,
3592: x_msg_data OUT NOCOPY VARCHAR2,
3593: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3594: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3595:
3596: l_process_active_yn VARCHAR2(1) := 'N';
3597: BEGIN
3598: -- check whether the process is active or not
3600: If (l_process_active_yn = 'Y') Then
3601: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
3602: End If;
3603:
3604: OKC_CPS_PVT.Update_Row(
3605: p_api_version => p_api_version,
3606: p_init_msg_list => p_init_msg_list,
3607: x_return_status => x_return_status,
3608: x_msg_count => x_msg_count,
3644: p_init_msg_list IN VARCHAR2 ,
3645: x_return_status OUT NOCOPY VARCHAR2,
3646: x_msg_count OUT NOCOPY NUMBER,
3647: x_msg_data OUT NOCOPY VARCHAR2,
3648: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3649: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3650:
3651: BEGIN
3652: OKC_CPS_PVT.Update_Row(
3645: x_return_status OUT NOCOPY VARCHAR2,
3646: x_msg_count OUT NOCOPY NUMBER,
3647: x_msg_data OUT NOCOPY VARCHAR2,
3648: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3649: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3650:
3651: BEGIN
3652: OKC_CPS_PVT.Update_Row(
3653: p_api_version => p_api_version,
3648: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3649: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3650:
3651: BEGIN
3652: OKC_CPS_PVT.Update_Row(
3653: p_api_version => p_api_version,
3654: p_init_msg_list => p_init_msg_list,
3655: x_return_status => x_return_status,
3656: x_msg_count => x_msg_count,
3664: p_init_msg_list IN VARCHAR2 ,
3665: x_return_status OUT NOCOPY VARCHAR2,
3666: x_msg_count OUT NOCOPY NUMBER,
3667: x_msg_data OUT NOCOPY VARCHAR2,
3668: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3669:
3670: l_process_active_yn VARCHAR2(1) := 'N';
3671: l_chr_id NUMBER;
3672: l_not_found BOOLEAN;
3696: p_token2 => g_sqlerrm_token,
3697: p_token2_value => sqlerrm);
3698: End If;
3699:
3700: OKC_CPS_PVT.Delete_Row(
3701: p_api_version => p_api_version,
3702: p_init_msg_list => p_init_msg_list,
3703: x_return_status => x_return_status,
3704: x_msg_count => x_msg_count,
3738: p_init_msg_list IN VARCHAR2 ,
3739: x_return_status OUT NOCOPY VARCHAR2,
3740: x_msg_count OUT NOCOPY NUMBER,
3741: x_msg_data OUT NOCOPY VARCHAR2,
3742: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3743:
3744: BEGIN
3745: OKC_CPS_PVT.Delete_Row(
3746: p_api_version => p_api_version,
3741: x_msg_data OUT NOCOPY VARCHAR2,
3742: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3743:
3744: BEGIN
3745: OKC_CPS_PVT.Delete_Row(
3746: p_api_version => p_api_version,
3747: p_init_msg_list => p_init_msg_list,
3748: x_return_status => x_return_status,
3749: x_msg_count => x_msg_count,
3756: p_init_msg_list IN VARCHAR2 ,
3757: x_return_status OUT NOCOPY VARCHAR2,
3758: x_msg_count OUT NOCOPY NUMBER,
3759: x_msg_data OUT NOCOPY VARCHAR2,
3760: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3761:
3762: BEGIN
3763: OKC_CPS_PVT.Lock_Row(
3764: p_api_version => p_api_version,
3759: x_msg_data OUT NOCOPY VARCHAR2,
3760: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3761:
3762: BEGIN
3763: OKC_CPS_PVT.Lock_Row(
3764: p_api_version => p_api_version,
3765: p_init_msg_list => p_init_msg_list,
3766: x_return_status => x_return_status,
3767: x_msg_count => x_msg_count,
3774: p_init_msg_list IN VARCHAR2 ,
3775: x_return_status OUT NOCOPY VARCHAR2,
3776: x_msg_count OUT NOCOPY NUMBER,
3777: x_msg_data OUT NOCOPY VARCHAR2,
3778: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3779:
3780: BEGIN
3781: OKC_CPS_PVT.Lock_Row(
3782: p_api_version => p_api_version,
3777: x_msg_data OUT NOCOPY VARCHAR2,
3778: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3779:
3780: BEGIN
3781: OKC_CPS_PVT.Lock_Row(
3782: p_api_version => p_api_version,
3783: p_init_msg_list => p_init_msg_list,
3784: x_return_status => x_return_status,
3785: x_msg_count => x_msg_count,
3792: p_init_msg_list IN VARCHAR2 ,
3793: x_return_status OUT NOCOPY VARCHAR2,
3794: x_msg_count OUT NOCOPY NUMBER,
3795: x_msg_data OUT NOCOPY VARCHAR2,
3796: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3797:
3798: BEGIN
3799: OKC_CPS_PVT.Validate_Row(
3800: p_api_version => p_api_version,
3795: x_msg_data OUT NOCOPY VARCHAR2,
3796: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3797:
3798: BEGIN
3799: OKC_CPS_PVT.Validate_Row(
3800: p_api_version => p_api_version,
3801: p_init_msg_list => p_init_msg_list,
3802: x_return_status => x_return_status,
3803: x_msg_count => x_msg_count,
3810: p_init_msg_list IN VARCHAR2 ,
3811: x_return_status OUT NOCOPY VARCHAR2,
3812: x_msg_count OUT NOCOPY NUMBER,
3813: x_msg_data OUT NOCOPY VARCHAR2,
3814: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3815:
3816: BEGIN
3817: OKC_CPS_PVT.Validate_Row(
3818: p_api_version => p_api_version,
3813: x_msg_data OUT NOCOPY VARCHAR2,
3814: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3815:
3816: BEGIN
3817: OKC_CPS_PVT.Validate_Row(
3818: p_api_version => p_api_version,
3819: p_init_msg_list => p_init_msg_list,
3820: x_return_status => x_return_status,
3821: x_msg_count => x_msg_count,