APPS.OKL_ETO_PVT dependencies on OKL_FE_EO_TERM_OBJECTS

Line 272: -- Procedure get_rec for OKL_FE_EO_TERM_OBJECTS

268:
269: END validate_resi_category_set_id;
270:
271: --------------------------------------------------------------------------------
272: -- Procedure get_rec for OKL_FE_EO_TERM_OBJECTS
273: --------------------------------------------------------------------------------
274:
275: FUNCTION get_rec(p_eto_rec IN okl_eto_rec
276: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_eto_rec IS

Line 308: FROM okl_fe_eo_term_objects

304: ,creation_date
305: ,last_updated_by
306: ,last_update_date
307: ,last_update_login
308: FROM okl_fe_eo_term_objects
309: WHERE okl_fe_eo_term_objects.end_of_term_obj_id = p_id;
310: l_eto_pk eto_pk_csr%ROWTYPE;
311: l_eto_rec okl_eto_rec;
312:

Line 309: WHERE okl_fe_eo_term_objects.end_of_term_obj_id = p_id;

305: ,last_updated_by
306: ,last_update_date
307: ,last_update_login
308: FROM okl_fe_eo_term_objects
309: WHERE okl_fe_eo_term_objects.end_of_term_obj_id = p_id;
310: l_eto_pk eto_pk_csr%ROWTYPE;
311: l_eto_rec okl_eto_rec;
312:
313: BEGIN

Line 587: FROM okl_fe_eo_term_objects

583: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
584:
585: CURSOR lock_csr(p_def_eto_rec IN okl_eto_rec) IS
586: SELECT object_version_number
587: FROM okl_fe_eo_term_objects
588: WHERE end_of_term_obj_id = p_def_eto_rec.end_of_term_obj_id
589: AND object_version_number = p_def_eto_rec.object_version_number
590: FOR UPDATE OF object_version_number NOWAIT;
591:

Line 594: FROM okl_fe_eo_term_objects

590: FOR UPDATE OF object_version_number NOWAIT;
591:
592: CURSOR lchk_csr(p_def_eto_rec IN okl_eto_rec) IS
593: SELECT object_version_number
594: FROM okl_fe_eo_term_objects
595: WHERE end_of_term_obj_id = p_def_eto_rec.end_of_term_obj_id;
596: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
597: l_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
598: lc_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;

Line 803: INSERT INTO okl_fe_eo_term_objects

799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
800: RAISE okc_api.g_exception_error;
801: END IF;
802:
803: INSERT INTO okl_fe_eo_term_objects
804: (end_of_term_obj_id
805: ,object_version_number
806: ,inventory_item_id
807: ,organization_id

Line 1220: UPDATE okl_fe_eo_term_objects

1216: ELSIF (l_return_status = g_ret_sts_error) THEN
1217: RAISE okl_api.g_exception_error;
1218: END IF;
1219:
1220: UPDATE okl_fe_eo_term_objects
1221: SET end_of_term_obj_id = l_def_eto_rec.end_of_term_obj_id
1222: ,object_version_number = l_def_eto_rec.object_version_number + 1
1223: ,inventory_item_id = l_def_eto_rec.inventory_item_id
1224: ,organization_id = l_def_eto_rec.organization_id

Line 1395: DELETE FROM okl_fe_eo_term_objects

1391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1392: RAISE okc_api.g_exception_error;
1393: END IF;
1394:
1395: DELETE FROM okl_fe_eo_term_objects
1396: WHERE end_of_term_obj_id = l_eto_rec.end_of_term_obj_id;
1397:
1398: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1399: RAISE okc_api.g_exception_unexpected_error;