APPS.OKL_EVE_PVT dependencies on OKL_FE_EO_TERM_VERS

Line 302: -- Procedure get_rec for OKL_FE_EO_TERM_VERS

298: x_return_status := okc_api.g_ret_sts_unexp_error;
299: END validate_sts_code;
300:
301: --------------------------------------------------------------------------------
302: -- Procedure get_rec for OKL_FE_EO_TERM_VERS
303: --------------------------------------------------------------------------------
304:
305: FUNCTION get_rec(p_eve_rec IN okl_eve_rec
306: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_eve_rec IS

Line 337: FROM okl_fe_eo_term_vers

333: ,creation_date
334: ,last_updated_by
335: ,last_update_date
336: ,last_update_login
337: FROM okl_fe_eo_term_vers
338: WHERE okl_fe_eo_term_vers.end_of_term_ver_id = p_id;
339: l_eve_pk pve_pk_csr%ROWTYPE;
340: l_eve_rec okl_eve_rec;
341:

Line 338: WHERE okl_fe_eo_term_vers.end_of_term_ver_id = p_id;

334: ,last_updated_by
335: ,last_update_date
336: ,last_update_login
337: FROM okl_fe_eo_term_vers
338: WHERE okl_fe_eo_term_vers.end_of_term_ver_id = p_id;
339: l_eve_pk pve_pk_csr%ROWTYPE;
340: l_eve_rec okl_eve_rec;
341:
342: BEGIN

Line 613: FROM okl_fe_eo_term_vers

609: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
610:
611: CURSOR lock_csr(p_def_eve_rec IN okl_eve_rec) IS
612: SELECT object_version_number
613: FROM okl_fe_eo_term_vers
614: WHERE end_of_term_ver_id = p_def_eve_rec.end_of_term_ver_id
615: AND object_version_number = p_def_eve_rec.object_version_number
616: FOR UPDATE OF object_version_number NOWAIT;
617:

Line 620: FROM okl_fe_eo_term_vers

616: FOR UPDATE OF object_version_number NOWAIT;
617:
618: CURSOR lchk_csr(p_def_eve_rec IN okl_eve_rec) IS
619: SELECT object_version_number
620: FROM okl_fe_eo_term_vers
621: WHERE end_of_term_ver_id = p_def_eve_rec.end_of_term_ver_id;
622: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
623: l_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
624: lc_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;

Line 837: INSERT INTO okl_fe_eo_term_vers

833: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
834: RAISE okc_api.g_exception_error;
835: END IF;
836:
837: INSERT INTO okl_fe_eo_term_vers
838: (end_of_term_ver_id
839: ,version_number
840: ,object_version_number
841: ,effective_from_date

Line 1248: UPDATE okl_fe_eo_term_vers

1244: ELSIF (l_return_status = g_ret_sts_error) THEN
1245: RAISE okl_api.g_exception_error;
1246: END IF;
1247:
1248: UPDATE okl_fe_eo_term_vers
1249: SET end_of_term_ver_id = l_def_eve_rec.end_of_term_ver_id
1250: ,object_version_number = l_def_eve_rec.object_version_number + 1
1251: ,version_number = l_def_eve_rec.version_number
1252: ,effective_from_date = l_def_eve_rec.effective_from_date

Line 1422: DELETE FROM okl_fe_eo_term_vers

1418: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1419: RAISE okc_api.g_exception_error;
1420: END IF;
1421:
1422: DELETE FROM okl_fe_eo_term_vers
1423: WHERE end_of_term_ver_id = l_eve_rec.end_of_term_ver_id;
1424:
1425: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1426: RAISE okc_api.g_exception_unexpected_error;