DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_GVE_PVT

Line 1755: l_gvev_rec OKC_GVE_PVT.gvev_rec_type;

1751: l_lse_id NUMBER; --linestyle
1752: l_dnz_chr_id NUMBER;
1753: l_ph_pricing_type VARCHAR2(30);
1754:
1755: l_gvev_rec OKC_GVE_PVT.gvev_rec_type;
1756:
1757:
1758: BEGIN
1759: -- check whether the contract is updateable or not

Line 1922: OKC_GVE_PVT.Delete_Row(

1918:
1919: l_gvev_rec.id := c.id;
1920: l_gvev_rec.object_version_number := c.object_version_number;
1921:
1922: OKC_GVE_PVT.Delete_Row(
1923: p_api_version => p_api_version,
1924: p_init_msg_list => p_init_msg_list,
1925: x_return_status => x_return_status,
1926: x_msg_count => x_msg_count,

Line 3333: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,

3329: p_init_msg_list IN VARCHAR2 ,
3330: x_return_status OUT NOCOPY VARCHAR2,
3331: x_msg_count OUT NOCOPY NUMBER,
3332: x_msg_data OUT NOCOPY VARCHAR2,
3333: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3334: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3335:
3336: BEGIN
3337: OKC_GVE_PVT.Insert_Row(

Line 3334: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS

3330: x_return_status OUT NOCOPY VARCHAR2,
3331: x_msg_count OUT NOCOPY NUMBER,
3332: x_msg_data OUT NOCOPY VARCHAR2,
3333: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3334: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3335:
3336: BEGIN
3337: OKC_GVE_PVT.Insert_Row(
3338: p_api_version => p_api_version,

Line 3337: OKC_GVE_PVT.Insert_Row(

3333: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3334: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3335:
3336: BEGIN
3337: OKC_GVE_PVT.Insert_Row(
3338: p_api_version => p_api_version,
3339: p_init_msg_list => p_init_msg_list,
3340: x_return_status => x_return_status,
3341: x_msg_count => x_msg_count,

Line 3358: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,

3354: p_init_msg_list IN VARCHAR2 ,
3355: x_return_status OUT NOCOPY VARCHAR2,
3356: x_msg_count OUT NOCOPY NUMBER,
3357: x_msg_data OUT NOCOPY VARCHAR2,
3358: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3359: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3360:
3361: BEGIN
3362: OKC_GVE_PVT.Insert_Row(

Line 3359: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS

3355: x_return_status OUT NOCOPY VARCHAR2,
3356: x_msg_count OUT NOCOPY NUMBER,
3357: x_msg_data OUT NOCOPY VARCHAR2,
3358: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3359: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3360:
3361: BEGIN
3362: OKC_GVE_PVT.Insert_Row(
3363: p_api_version => p_api_version,

Line 3362: OKC_GVE_PVT.Insert_Row(

3358: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3359: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3360:
3361: BEGIN
3362: OKC_GVE_PVT.Insert_Row(
3363: p_api_version => p_api_version,
3364: p_init_msg_list => p_init_msg_list,
3365: x_return_status => x_return_status,
3366: x_msg_count => x_msg_count,

Line 3378: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,

3374: p_init_msg_list IN VARCHAR2 ,
3375: x_return_status OUT NOCOPY VARCHAR2,
3376: x_msg_count OUT NOCOPY NUMBER,
3377: x_msg_data OUT NOCOPY VARCHAR2,
3378: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3379: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3380:
3381: BEGIN
3382: OKC_GVE_PVT.Update_Row(

Line 3379: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS

3375: x_return_status OUT NOCOPY VARCHAR2,
3376: x_msg_count OUT NOCOPY NUMBER,
3377: x_msg_data OUT NOCOPY VARCHAR2,
3378: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3379: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3380:
3381: BEGIN
3382: OKC_GVE_PVT.Update_Row(
3383: p_api_version => p_api_version,

Line 3382: OKC_GVE_PVT.Update_Row(

3378: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
3379: x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type) IS
3380:
3381: BEGIN
3382: OKC_GVE_PVT.Update_Row(
3383: p_api_version => p_api_version,
3384: p_init_msg_list => p_init_msg_list,
3385: x_return_status => x_return_status,
3386: x_msg_count => x_msg_count,

Line 3403: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,

3399: p_init_msg_list IN VARCHAR2 ,
3400: x_return_status OUT NOCOPY VARCHAR2,
3401: x_msg_count OUT NOCOPY NUMBER,
3402: x_msg_data OUT NOCOPY VARCHAR2,
3403: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3404: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3405:
3406: BEGIN
3407: OKC_GVE_PVT.Update_Row(

Line 3404: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS

3400: x_return_status OUT NOCOPY VARCHAR2,
3401: x_msg_count OUT NOCOPY NUMBER,
3402: x_msg_data OUT NOCOPY VARCHAR2,
3403: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3404: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3405:
3406: BEGIN
3407: OKC_GVE_PVT.Update_Row(
3408: p_api_version => p_api_version,

Line 3407: OKC_GVE_PVT.Update_Row(

3403: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
3404: x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type) IS
3405:
3406: BEGIN
3407: OKC_GVE_PVT.Update_Row(
3408: p_api_version => p_api_version,
3409: p_init_msg_list => p_init_msg_list,
3410: x_return_status => x_return_status,
3411: x_msg_count => x_msg_count,

Line 3423: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS

3419: p_init_msg_list IN VARCHAR2 ,
3420: x_return_status OUT NOCOPY VARCHAR2,
3421: x_msg_count OUT NOCOPY NUMBER,
3422: x_msg_data OUT NOCOPY VARCHAR2,
3423: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3424:
3425: l_chr_id NUMBER;
3426: Cursor l_gvev_csr Is
3427: SELECT dnz_chr_id

Line 3435: OKC_GVE_PVT.Delete_Row(

3431: Open l_gvev_csr;
3432: Fetch l_gvev_csr into l_chr_id;
3433: Close l_gvev_csr;
3434:
3435: OKC_GVE_PVT.Delete_Row(
3436: p_api_version => p_api_version,
3437: p_init_msg_list => p_init_msg_list,
3438: x_return_status => x_return_status,
3439: x_msg_count => x_msg_count,

Line 3455: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS

3451: p_init_msg_list IN VARCHAR2 ,
3452: x_return_status OUT NOCOPY VARCHAR2,
3453: x_msg_count OUT NOCOPY NUMBER,
3454: x_msg_data OUT NOCOPY VARCHAR2,
3455: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3456:
3457: BEGIN
3458: OKC_GVE_PVT.Delete_Row(
3459: p_api_version => p_api_version,

Line 3458: OKC_GVE_PVT.Delete_Row(

3454: x_msg_data OUT NOCOPY VARCHAR2,
3455: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3456:
3457: BEGIN
3458: OKC_GVE_PVT.Delete_Row(
3459: p_api_version => p_api_version,
3460: p_init_msg_list => p_init_msg_list,
3461: x_return_status => x_return_status,
3462: x_msg_count => x_msg_count,

Line 3473: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS

3469: p_init_msg_list IN VARCHAR2 ,
3470: x_return_status OUT NOCOPY VARCHAR2,
3471: x_msg_count OUT NOCOPY NUMBER,
3472: x_msg_data OUT NOCOPY VARCHAR2,
3473: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3474:
3475: BEGIN
3476: OKC_GVE_PVT.Lock_Row(
3477: p_api_version => p_api_version,

Line 3476: OKC_GVE_PVT.Lock_Row(

3472: x_msg_data OUT NOCOPY VARCHAR2,
3473: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3474:
3475: BEGIN
3476: OKC_GVE_PVT.Lock_Row(
3477: p_api_version => p_api_version,
3478: p_init_msg_list => p_init_msg_list,
3479: x_return_status => x_return_status,
3480: x_msg_count => x_msg_count,

Line 3491: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS

3487: p_init_msg_list IN VARCHAR2 ,
3488: x_return_status OUT NOCOPY VARCHAR2,
3489: x_msg_count OUT NOCOPY NUMBER,
3490: x_msg_data OUT NOCOPY VARCHAR2,
3491: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3492:
3493: BEGIN
3494: OKC_GVE_PVT.Lock_Row(
3495: p_api_version => p_api_version,

Line 3494: OKC_GVE_PVT.Lock_Row(

3490: x_msg_data OUT NOCOPY VARCHAR2,
3491: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3492:
3493: BEGIN
3494: OKC_GVE_PVT.Lock_Row(
3495: p_api_version => p_api_version,
3496: p_init_msg_list => p_init_msg_list,
3497: x_return_status => x_return_status,
3498: x_msg_count => x_msg_count,

Line 3509: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS

3505: p_init_msg_list IN VARCHAR2 ,
3506: x_return_status OUT NOCOPY VARCHAR2,
3507: x_msg_count OUT NOCOPY NUMBER,
3508: x_msg_data OUT NOCOPY VARCHAR2,
3509: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3510:
3511: BEGIN
3512: OKC_GVE_PVT.Validate_Row(
3513: p_api_version => p_api_version,

Line 3512: OKC_GVE_PVT.Validate_Row(

3508: x_msg_data OUT NOCOPY VARCHAR2,
3509: p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type) IS
3510:
3511: BEGIN
3512: OKC_GVE_PVT.Validate_Row(
3513: p_api_version => p_api_version,
3514: p_init_msg_list => p_init_msg_list,
3515: x_return_status => x_return_status,
3516: x_msg_count => x_msg_count,

Line 3527: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS

3523: p_init_msg_list IN VARCHAR2 ,
3524: x_return_status OUT NOCOPY VARCHAR2,
3525: x_msg_count OUT NOCOPY NUMBER,
3526: x_msg_data OUT NOCOPY VARCHAR2,
3527: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3528:
3529: BEGIN
3530: OKC_GVE_PVT.Validate_Row(
3531: p_api_version => p_api_version,

Line 3530: OKC_GVE_PVT.Validate_Row(

3526: x_msg_data OUT NOCOPY VARCHAR2,
3527: p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type) IS
3528:
3529: BEGIN
3530: OKC_GVE_PVT.Validate_Row(
3531: p_api_version => p_api_version,
3532: p_init_msg_list => p_init_msg_list,
3533: x_return_status => x_return_status,
3534: x_msg_count => x_msg_count,