APPS.OKL_ETV_PVT dependencies on OKL_FE_EO_TERM_VALUES

Line 162: -- Procedure get_rec for OKL_FE_EO_TERM_VALUES

158:
159: END validate_end_of_term_ver_id;
160:
161: --------------------------------------------------------------------------------
162: -- Procedure get_rec for OKL_FE_EO_TERM_VALUES
163: --------------------------------------------------------------------------------
164:
165: FUNCTION get_rec(p_etv_rec IN okl_etv_rec
166: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_etv_rec IS

Line 195: FROM okl_fe_eo_term_values

191: ,creation_date
192: ,last_updated_by
193: ,last_update_date
194: ,last_update_login
195: FROM okl_fe_eo_term_values
196: WHERE okl_fe_eo_term_values.end_of_term_value_id = p_id;
197: l_pvl_pk pod_pk_csr%ROWTYPE;
198: l_etv_rec okl_etv_rec;
199:

Line 196: WHERE okl_fe_eo_term_values.end_of_term_value_id = p_id;

192: ,last_updated_by
193: ,last_update_date
194: ,last_update_login
195: FROM okl_fe_eo_term_values
196: WHERE okl_fe_eo_term_values.end_of_term_value_id = p_id;
197: l_pvl_pk pod_pk_csr%ROWTYPE;
198: l_etv_rec okl_etv_rec;
199:
200: BEGIN

Line 420: FROM okl_fe_eo_term_values

416: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
417:
418: CURSOR lock_csr(p_def_etv_rec IN okl_etv_rec) IS
419: SELECT object_version_number
420: FROM okl_fe_eo_term_values
421: WHERE end_of_term_value_id = p_def_etv_rec.end_of_term_value_id
422: AND object_version_number = p_def_etv_rec.object_version_number
423: FOR UPDATE OF object_version_number NOWAIT;
424:

Line 427: FROM okl_fe_eo_term_values

423: FOR UPDATE OF object_version_number NOWAIT;
424:
425: CURSOR lchk_csr(p_def_etv_rec IN okl_etv_rec) IS
426: SELECT object_version_number
427: FROM okl_fe_eo_term_values
428: WHERE end_of_term_value_id = p_def_etv_rec.end_of_term_value_id;
429: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;
430: l_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;
431: lc_object_version_number okl_fe_item_residual_all.object_version_number%TYPE;

Line 630: INSERT INTO okl_fe_eo_term_values

626: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
627: RAISE okc_api.g_exception_error;
628: END IF;
629:
630: INSERT INTO okl_fe_eo_term_values
631: (end_of_term_value_id
632: ,object_version_number
633: ,eot_term
634: ,eot_value

Line 1009: UPDATE okl_fe_eo_term_values

1005: ELSIF (l_return_status = g_ret_sts_error) THEN
1006: RAISE okl_api.g_exception_error;
1007: END IF;
1008:
1009: UPDATE okl_fe_eo_term_values
1010: SET end_of_term_value_id = l_def_etv_rec.end_of_term_value_id
1011: ,object_version_number = l_def_etv_rec.object_version_number + 1
1012: ,eot_term = l_def_etv_rec.eot_term
1013: ,eot_value = l_def_etv_rec.eot_value

Line 1170: DELETE FROM okl_fe_eo_term_values

1166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1167: RAISE okc_api.g_exception_error;
1168: END IF;
1169:
1170: DELETE FROM okl_fe_eo_term_values
1171: WHERE end_of_term_value_id = l_etv_rec.end_of_term_value_id;
1172:
1173: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1174: RAISE okc_api.g_exception_unexpected_error;