DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_GVE_PVT

Line 1813: l_gvev_rec OKC_GVE_PVT.gvev_rec_type;

1809: l_lse_id NUMBER; --linestyle
1810: l_dnz_chr_id NUMBER;
1811: l_ph_pricing_type VARCHAR2(30);
1812:
1813: l_gvev_rec OKC_GVE_PVT.gvev_rec_type;
1814:
1815:
1816: BEGIN
1817: -- check whether the contract is updateable or not

Line 1980: OKC_GVE_PVT.Delete_Row(

1976:
1977: l_gvev_rec.id := c.id;
1978: l_gvev_rec.object_version_number := c.object_version_number;
1979:
1980: OKC_GVE_PVT.Delete_Row(
1981: p_api_version => p_api_version,
1982: p_init_msg_list => p_init_msg_list,
1983: x_return_status => x_return_status,
1984: x_msg_count => x_msg_count,

Line 3391: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,

3387: p_init_msg_list IN VARCHAR2 ,
3388: x_return_status OUT NOCOPY VARCHAR2,
3389: x_msg_count OUT NOCOPY NUMBER,
3390: x_msg_data OUT NOCOPY VARCHAR2,
3391: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3392: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3393:
3394: BEGIN
3395: OKC_GVE_PVT.Insert_Row(

Line 3392: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS

3388: x_return_status OUT NOCOPY VARCHAR2,
3389: x_msg_count OUT NOCOPY NUMBER,
3390: x_msg_data OUT NOCOPY VARCHAR2,
3391: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3392: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3393:
3394: BEGIN
3395: OKC_GVE_PVT.Insert_Row(
3396: p_api_version => p_api_version,

Line 3395: OKC_GVE_PVT.Insert_Row(

3391: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3392: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3393:
3394: BEGIN
3395: OKC_GVE_PVT.Insert_Row(
3396: p_api_version => p_api_version,
3397: p_init_msg_list => p_init_msg_list,
3398: x_return_status => x_return_status,
3399: x_msg_count => x_msg_count,

Line 3416: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,

3412: p_init_msg_list IN VARCHAR2 ,
3413: x_return_status OUT NOCOPY VARCHAR2,
3414: x_msg_count OUT NOCOPY NUMBER,
3415: x_msg_data OUT NOCOPY VARCHAR2,
3416: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3417: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3418:
3419: BEGIN
3420: OKC_GVE_PVT.Insert_Row(

Line 3417: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS

3413: x_return_status OUT NOCOPY VARCHAR2,
3414: x_msg_count OUT NOCOPY NUMBER,
3415: x_msg_data OUT NOCOPY VARCHAR2,
3416: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3417: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3418:
3419: BEGIN
3420: OKC_GVE_PVT.Insert_Row(
3421: p_api_version => p_api_version,

Line 3420: OKC_GVE_PVT.Insert_Row(

3416: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3417: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3418:
3419: BEGIN
3420: OKC_GVE_PVT.Insert_Row(
3421: p_api_version => p_api_version,
3422: p_init_msg_list => p_init_msg_list,
3423: x_return_status => x_return_status,
3424: x_msg_count => x_msg_count,

Line 3436: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,

3432: p_init_msg_list IN VARCHAR2 ,
3433: x_return_status OUT NOCOPY VARCHAR2,
3434: x_msg_count OUT NOCOPY NUMBER,
3435: x_msg_data OUT NOCOPY VARCHAR2,
3436: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3437: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3438:
3439: BEGIN
3440: OKC_GVE_PVT.Update_Row(

Line 3437: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS

3433: x_return_status OUT NOCOPY VARCHAR2,
3434: x_msg_count OUT NOCOPY NUMBER,
3435: x_msg_data OUT NOCOPY VARCHAR2,
3436: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3437: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3438:
3439: BEGIN
3440: OKC_GVE_PVT.Update_Row(
3441: p_api_version => p_api_version,

Line 3440: OKC_GVE_PVT.Update_Row(

3436: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3437: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3438:
3439: BEGIN
3440: OKC_GVE_PVT.Update_Row(
3441: p_api_version => p_api_version,
3442: p_init_msg_list => p_init_msg_list,
3443: x_return_status => x_return_status,
3444: x_msg_count => x_msg_count,

Line 3461: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,

3457: p_init_msg_list IN VARCHAR2 ,
3458: x_return_status OUT NOCOPY VARCHAR2,
3459: x_msg_count OUT NOCOPY NUMBER,
3460: x_msg_data OUT NOCOPY VARCHAR2,
3461: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3462: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3463:
3464: BEGIN
3465: OKC_GVE_PVT.Update_Row(

Line 3462: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS

3458: x_return_status OUT NOCOPY VARCHAR2,
3459: x_msg_count OUT NOCOPY NUMBER,
3460: x_msg_data OUT NOCOPY VARCHAR2,
3461: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3462: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3463:
3464: BEGIN
3465: OKC_GVE_PVT.Update_Row(
3466: p_api_version => p_api_version,

Line 3465: OKC_GVE_PVT.Update_Row(

3461: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3462: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3463:
3464: BEGIN
3465: OKC_GVE_PVT.Update_Row(
3466: p_api_version => p_api_version,
3467: p_init_msg_list => p_init_msg_list,
3468: x_return_status => x_return_status,
3469: x_msg_count => x_msg_count,

Line 3481: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS

3477: p_init_msg_list IN VARCHAR2 ,
3478: x_return_status OUT NOCOPY VARCHAR2,
3479: x_msg_count OUT NOCOPY NUMBER,
3480: x_msg_data OUT NOCOPY VARCHAR2,
3481: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3482:
3483: l_chr_id NUMBER;
3484: Cursor l_gvev_csr Is
3485: SELECT dnz_chr_id

Line 3493: OKC_GVE_PVT.Delete_Row(

3489: Open l_gvev_csr;
3490: Fetch l_gvev_csr into l_chr_id;
3491: Close l_gvev_csr;
3492:
3493: OKC_GVE_PVT.Delete_Row(
3494: p_api_version => p_api_version,
3495: p_init_msg_list => p_init_msg_list,
3496: x_return_status => x_return_status,
3497: x_msg_count => x_msg_count,

Line 3513: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS

3509: p_init_msg_list IN VARCHAR2 ,
3510: x_return_status OUT NOCOPY VARCHAR2,
3511: x_msg_count OUT NOCOPY NUMBER,
3512: x_msg_data OUT NOCOPY VARCHAR2,
3513: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3514:
3515: BEGIN
3516: OKC_GVE_PVT.Delete_Row(
3517: p_api_version => p_api_version,

Line 3516: OKC_GVE_PVT.Delete_Row(

3512: x_msg_data OUT NOCOPY VARCHAR2,
3513: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3514:
3515: BEGIN
3516: OKC_GVE_PVT.Delete_Row(
3517: p_api_version => p_api_version,
3518: p_init_msg_list => p_init_msg_list,
3519: x_return_status => x_return_status,
3520: x_msg_count => x_msg_count,

Line 3531: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS

3527: p_init_msg_list IN VARCHAR2 ,
3528: x_return_status OUT NOCOPY VARCHAR2,
3529: x_msg_count OUT NOCOPY NUMBER,
3530: x_msg_data OUT NOCOPY VARCHAR2,
3531: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3532:
3533: BEGIN
3534: OKC_GVE_PVT.Lock_Row(
3535: p_api_version => p_api_version,

Line 3534: OKC_GVE_PVT.Lock_Row(

3530: x_msg_data OUT NOCOPY VARCHAR2,
3531: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3532:
3533: BEGIN
3534: OKC_GVE_PVT.Lock_Row(
3535: p_api_version => p_api_version,
3536: p_init_msg_list => p_init_msg_list,
3537: x_return_status => x_return_status,
3538: x_msg_count => x_msg_count,

Line 3549: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS

3545: p_init_msg_list IN VARCHAR2 ,
3546: x_return_status OUT NOCOPY VARCHAR2,
3547: x_msg_count OUT NOCOPY NUMBER,
3548: x_msg_data OUT NOCOPY VARCHAR2,
3549: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3550:
3551: BEGIN
3552: OKC_GVE_PVT.Lock_Row(
3553: p_api_version => p_api_version,

Line 3552: OKC_GVE_PVT.Lock_Row(

3548: x_msg_data OUT NOCOPY VARCHAR2,
3549: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3550:
3551: BEGIN
3552: OKC_GVE_PVT.Lock_Row(
3553: p_api_version => p_api_version,
3554: p_init_msg_list => p_init_msg_list,
3555: x_return_status => x_return_status,
3556: x_msg_count => x_msg_count,

Line 3567: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS

3563: p_init_msg_list IN VARCHAR2 ,
3564: x_return_status OUT NOCOPY VARCHAR2,
3565: x_msg_count OUT NOCOPY NUMBER,
3566: x_msg_data OUT NOCOPY VARCHAR2,
3567: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3568:
3569: BEGIN
3570: OKC_GVE_PVT.Validate_Row(
3571: p_api_version => p_api_version,

Line 3570: OKC_GVE_PVT.Validate_Row(

3566: x_msg_data OUT NOCOPY VARCHAR2,
3567: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3568:
3569: BEGIN
3570: OKC_GVE_PVT.Validate_Row(
3571: p_api_version => p_api_version,
3572: p_init_msg_list => p_init_msg_list,
3573: x_return_status => x_return_status,
3574: x_msg_count => x_msg_count,

Line 3585: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS

3581: p_init_msg_list IN VARCHAR2 ,
3582: x_return_status OUT NOCOPY VARCHAR2,
3583: x_msg_count OUT NOCOPY NUMBER,
3584: x_msg_data OUT NOCOPY VARCHAR2,
3585: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3586:
3587: BEGIN
3588: OKC_GVE_PVT.Validate_Row(
3589: p_api_version => p_api_version,

Line 3588: OKC_GVE_PVT.Validate_Row(

3584: x_msg_data OUT NOCOPY VARCHAR2,
3585: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3586:
3587: BEGIN
3588: OKC_GVE_PVT.Validate_Row(
3589: p_api_version => p_api_version,
3590: p_init_msg_list => p_init_msg_list,
3591: x_return_status => x_return_status,
3592: x_msg_count => x_msg_count,