DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CPS_PVT

Line 3545: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,

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(

Line 3546: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS

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,

Line 3549: OKC_CPS_PVT.Insert_Row(

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,

Line 3573: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,

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(

Line 3574: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS

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,

Line 3577: OKC_CPS_PVT.Insert_Row(

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,

Line 3593: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,

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

Line 3594: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS

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

Line 3604: OKC_CPS_PVT.Update_Row(

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,

Line 3648: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,

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(

Line 3649: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS

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,

Line 3652: OKC_CPS_PVT.Update_Row(

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,

Line 3668: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS

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;

Line 3700: OKC_CPS_PVT.Delete_Row(

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,

Line 3742: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS

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,

Line 3745: OKC_CPS_PVT.Delete_Row(

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,

Line 3760: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS

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,

Line 3763: OKC_CPS_PVT.Lock_Row(

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,

Line 3778: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS

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,

Line 3781: OKC_CPS_PVT.Lock_Row(

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,

Line 3796: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS

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,

Line 3799: OKC_CPS_PVT.Validate_Row(

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,

Line 3814: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS

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,

Line 3817: OKC_CPS_PVT.Validate_Row(

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,