APPS.OKL_VP_CHANGE_REQUEST_PVT dependencies on OKL_VRR_PVT

Line 63: lv_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

59: lv_vagr_hdr_rec okl_vp_copy_contract_pvt.copy_header_rec_type;
60: lx_new_agr_id okc_k_headers_b.id%TYPE;
61: lv_khrv_rec okl_khr_pvt.khrv_rec_type;
62: x_khrv_rec okl_khr_pvt.khrv_rec_type;
63: lv_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
64: x_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
65:
66: BEGIN
67: -- get the change request number from the sequence, this call is necessary as change request number is used

Line 64: x_vrrv_rec okl_vrr_pvt.vrrv_rec_type;

60: lx_new_agr_id okc_k_headers_b.id%TYPE;
61: lv_khrv_rec okl_khr_pvt.khrv_rec_type;
62: x_khrv_rec okl_khr_pvt.khrv_rec_type;
63: lv_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
64: x_vrrv_rec okl_vrr_pvt.vrrv_rec_type;
65:
66: BEGIN
67: -- get the change request number from the sequence, this call is necessary as change request number is used
68: -- in the construction of the new agreement number

Line 137: okl_vrr_pvt.insert_row(p_api_version => p_api_version

133: -- now also populate the notes for this reason, the note is derived from fnd_new_messages
134: fnd_message.set_name(G_APP_NAME, G_SYSTEM_COPY_MSG);
135: lv_vrrv_rec.note := fnd_message.get;
136:
137: okl_vrr_pvt.insert_row(p_api_version => p_api_version
138: ,p_init_msg_list => p_init_msg_list
139: ,x_return_status => x_return_status
140: ,x_msg_count => x_msg_count
141: ,x_msg_data => x_msg_data

Line 415: okl_vrr_pvt.insert_row(p_api_version => p_api_version

411: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: END IF;
414:
415: okl_vrr_pvt.insert_row(p_api_version => p_api_version
416: ,p_init_msg_list => p_init_msg_list
417: ,x_return_status => x_return_status
418: ,x_msg_count => x_msg_count
419: ,x_msg_data => x_msg_data

Line 427: 'okl_vrr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data

423: -- write to log
424: IF(NVL(l_debug_enabled,'N')='Y') THEN
425: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
426: l_module,
427: 'okl_vrr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
428: );
429: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
430:
431: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 530: okl_vrr_pvt.update_row(p_api_version => p_api_version

526: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
527: RAISE OKL_API.G_EXCEPTION_ERROR;
528: END IF;
529:
530: okl_vrr_pvt.update_row(p_api_version => p_api_version
531: ,p_init_msg_list => p_init_msg_list
532: ,x_return_status => x_return_status
533: ,x_msg_count => x_msg_count
534: ,x_msg_data => x_msg_data

Line 542: 'okl_vrr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data

538: -- write to log
539: IF(NVL(l_debug_enabled,'N')='Y') THEN
540: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
541: l_module,
542: 'okl_vrr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
543: );
544: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
545:
546: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 649: okl_vrr_pvt.delete_row(p_api_version => p_api_version

645: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
646: RAISE OKL_API.G_EXCEPTION_ERROR;
647: END IF;
648: IF(p_vrrv_tbl.COUNT > 0)THEN
649: okl_vrr_pvt.delete_row(p_api_version => p_api_version
650: ,p_init_msg_list => p_init_msg_list
651: ,x_return_status => x_return_status
652: ,x_msg_count => x_msg_count
653: ,x_msg_data => x_msg_data

Line 660: 'okl_vrr_pvt.delete_row returned with status '||x_return_status||' x_msg_data '||x_msg_data

656: -- write to log
657: IF(NVL(l_debug_enabled,'N')='Y') THEN
658: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
659: l_module,
660: 'okl_vrr_pvt.delete_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
661: );
662: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
663: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;