DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CPS_PVT

Line 3603: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,

3599: p_init_msg_list IN VARCHAR2 ,
3600: x_return_status OUT NOCOPY VARCHAR2,
3601: x_msg_count OUT NOCOPY NUMBER,
3602: x_msg_data OUT NOCOPY VARCHAR2,
3603: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3604: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3605:
3606: BEGIN
3607: OKC_CPS_PVT.Insert_Row(

Line 3604: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS

3600: x_return_status OUT NOCOPY VARCHAR2,
3601: x_msg_count OUT NOCOPY NUMBER,
3602: x_msg_data OUT NOCOPY VARCHAR2,
3603: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3604: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3605:
3606: BEGIN
3607: OKC_CPS_PVT.Insert_Row(
3608: p_api_version => p_api_version,

Line 3607: OKC_CPS_PVT.Insert_Row(

3603: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3604: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3605:
3606: BEGIN
3607: OKC_CPS_PVT.Insert_Row(
3608: p_api_version => p_api_version,
3609: p_init_msg_list => p_init_msg_list,
3610: x_return_status => x_return_status,
3611: x_msg_count => x_msg_count,

Line 3631: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,

3627: p_init_msg_list IN VARCHAR2 ,
3628: x_return_status OUT NOCOPY VARCHAR2,
3629: x_msg_count OUT NOCOPY NUMBER,
3630: x_msg_data OUT NOCOPY VARCHAR2,
3631: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3632: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3633:
3634: BEGIN
3635: OKC_CPS_PVT.Insert_Row(

Line 3632: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS

3628: x_return_status OUT NOCOPY VARCHAR2,
3629: x_msg_count OUT NOCOPY NUMBER,
3630: x_msg_data OUT NOCOPY VARCHAR2,
3631: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3632: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3633:
3634: BEGIN
3635: OKC_CPS_PVT.Insert_Row(
3636: p_api_version => p_api_version,

Line 3635: OKC_CPS_PVT.Insert_Row(

3631: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3632: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3633:
3634: BEGIN
3635: OKC_CPS_PVT.Insert_Row(
3636: p_api_version => p_api_version,
3637: p_init_msg_list => p_init_msg_list,
3638: x_return_status => x_return_status,
3639: x_msg_count => x_msg_count,

Line 3651: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,

3647: p_init_msg_list IN VARCHAR2 ,
3648: x_return_status OUT NOCOPY VARCHAR2,
3649: x_msg_count OUT NOCOPY NUMBER,
3650: x_msg_data OUT NOCOPY VARCHAR2,
3651: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3652: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3653:
3654: l_process_active_yn VARCHAR2(1) := 'N';
3655: BEGIN

Line 3652: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS

3648: x_return_status OUT NOCOPY VARCHAR2,
3649: x_msg_count OUT NOCOPY NUMBER,
3650: x_msg_data OUT NOCOPY VARCHAR2,
3651: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
3652: x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type) IS
3653:
3654: l_process_active_yn VARCHAR2(1) := 'N';
3655: BEGIN
3656: -- check whether the process is active or not

Line 3662: OKC_CPS_PVT.Update_Row(

3658: If (l_process_active_yn = 'Y') Then
3659: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
3660: End If;
3661:
3662: OKC_CPS_PVT.Update_Row(
3663: p_api_version => p_api_version,
3664: p_init_msg_list => p_init_msg_list,
3665: x_return_status => x_return_status,
3666: x_msg_count => x_msg_count,

Line 3706: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,

3702: p_init_msg_list IN VARCHAR2 ,
3703: x_return_status OUT NOCOPY VARCHAR2,
3704: x_msg_count OUT NOCOPY NUMBER,
3705: x_msg_data OUT NOCOPY VARCHAR2,
3706: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3707: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3708:
3709: BEGIN
3710: OKC_CPS_PVT.Update_Row(

Line 3707: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS

3703: x_return_status OUT NOCOPY VARCHAR2,
3704: x_msg_count OUT NOCOPY NUMBER,
3705: x_msg_data OUT NOCOPY VARCHAR2,
3706: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3707: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3708:
3709: BEGIN
3710: OKC_CPS_PVT.Update_Row(
3711: p_api_version => p_api_version,

Line 3710: OKC_CPS_PVT.Update_Row(

3706: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
3707: x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type) IS
3708:
3709: BEGIN
3710: OKC_CPS_PVT.Update_Row(
3711: p_api_version => p_api_version,
3712: p_init_msg_list => p_init_msg_list,
3713: x_return_status => x_return_status,
3714: x_msg_count => x_msg_count,

Line 3726: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS

3722: p_init_msg_list IN VARCHAR2 ,
3723: x_return_status OUT NOCOPY VARCHAR2,
3724: x_msg_count OUT NOCOPY NUMBER,
3725: x_msg_data OUT NOCOPY VARCHAR2,
3726: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3727:
3728: l_process_active_yn VARCHAR2(1) := 'N';
3729: l_chr_id NUMBER;
3730: l_not_found BOOLEAN;

Line 3758: OKC_CPS_PVT.Delete_Row(

3754: p_token2 => g_sqlerrm_token,
3755: p_token2_value => sqlerrm);
3756: End If;
3757:
3758: OKC_CPS_PVT.Delete_Row(
3759: p_api_version => p_api_version,
3760: p_init_msg_list => p_init_msg_list,
3761: x_return_status => x_return_status,
3762: x_msg_count => x_msg_count,

Line 3800: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS

3796: p_init_msg_list IN VARCHAR2 ,
3797: x_return_status OUT NOCOPY VARCHAR2,
3798: x_msg_count OUT NOCOPY NUMBER,
3799: x_msg_data OUT NOCOPY VARCHAR2,
3800: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3801:
3802: BEGIN
3803: OKC_CPS_PVT.Delete_Row(
3804: p_api_version => p_api_version,

Line 3803: OKC_CPS_PVT.Delete_Row(

3799: x_msg_data OUT NOCOPY VARCHAR2,
3800: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3801:
3802: BEGIN
3803: OKC_CPS_PVT.Delete_Row(
3804: p_api_version => p_api_version,
3805: p_init_msg_list => p_init_msg_list,
3806: x_return_status => x_return_status,
3807: x_msg_count => x_msg_count,

Line 3818: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS

3814: p_init_msg_list IN VARCHAR2 ,
3815: x_return_status OUT NOCOPY VARCHAR2,
3816: x_msg_count OUT NOCOPY NUMBER,
3817: x_msg_data OUT NOCOPY VARCHAR2,
3818: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3819:
3820: BEGIN
3821: OKC_CPS_PVT.Lock_Row(
3822: p_api_version => p_api_version,

Line 3821: OKC_CPS_PVT.Lock_Row(

3817: x_msg_data OUT NOCOPY VARCHAR2,
3818: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3819:
3820: BEGIN
3821: OKC_CPS_PVT.Lock_Row(
3822: p_api_version => p_api_version,
3823: p_init_msg_list => p_init_msg_list,
3824: x_return_status => x_return_status,
3825: x_msg_count => x_msg_count,

Line 3836: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS

3832: p_init_msg_list IN VARCHAR2 ,
3833: x_return_status OUT NOCOPY VARCHAR2,
3834: x_msg_count OUT NOCOPY NUMBER,
3835: x_msg_data OUT NOCOPY VARCHAR2,
3836: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3837:
3838: BEGIN
3839: OKC_CPS_PVT.Lock_Row(
3840: p_api_version => p_api_version,

Line 3839: OKC_CPS_PVT.Lock_Row(

3835: x_msg_data OUT NOCOPY VARCHAR2,
3836: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3837:
3838: BEGIN
3839: OKC_CPS_PVT.Lock_Row(
3840: p_api_version => p_api_version,
3841: p_init_msg_list => p_init_msg_list,
3842: x_return_status => x_return_status,
3843: x_msg_count => x_msg_count,

Line 3854: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS

3850: p_init_msg_list IN VARCHAR2 ,
3851: x_return_status OUT NOCOPY VARCHAR2,
3852: x_msg_count OUT NOCOPY NUMBER,
3853: x_msg_data OUT NOCOPY VARCHAR2,
3854: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3855:
3856: BEGIN
3857: OKC_CPS_PVT.Validate_Row(
3858: p_api_version => p_api_version,

Line 3857: OKC_CPS_PVT.Validate_Row(

3853: x_msg_data OUT NOCOPY VARCHAR2,
3854: p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type) IS
3855:
3856: BEGIN
3857: OKC_CPS_PVT.Validate_Row(
3858: p_api_version => p_api_version,
3859: p_init_msg_list => p_init_msg_list,
3860: x_return_status => x_return_status,
3861: x_msg_count => x_msg_count,

Line 3872: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS

3868: p_init_msg_list IN VARCHAR2 ,
3869: x_return_status OUT NOCOPY VARCHAR2,
3870: x_msg_count OUT NOCOPY NUMBER,
3871: x_msg_data OUT NOCOPY VARCHAR2,
3872: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3873:
3874: BEGIN
3875: OKC_CPS_PVT.Validate_Row(
3876: p_api_version => p_api_version,

Line 3875: OKC_CPS_PVT.Validate_Row(

3871: x_msg_data OUT NOCOPY VARCHAR2,
3872: p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type) IS
3873:
3874: BEGIN
3875: OKC_CPS_PVT.Validate_Row(
3876: p_api_version => p_api_version,
3877: p_init_msg_list => p_init_msg_list,
3878: x_return_status => x_return_status,
3879: x_msg_count => x_msg_count,