APPS.OKL_ETH_PVT dependencies on OKL_FE_EO_TERMS_ALL_B

Line 32: FROM OKL_FE_EO_TERMS_ALL_B b

28: BEGIN
29:
30: DELETE FROM OKL_FE_EO_TERMS_ALL_TL t
31: WHERE NOT EXISTS(SELECT NULL
32: FROM OKL_FE_EO_TERMS_ALL_B b
33: WHERE b.end_of_term_id = t.end_of_term_id);
34:
35: UPDATE OKL_FE_EO_TERMS_ALL_TL t
36: SET(end_of_term_desc) = (SELECT

Line 499: FROM okl_fe_eo_terms_all_b

495: ,p_ethv_rec IN okl_ethv_rec) IS
496:
497: CURSOR pos_exists_csr IS
498: SELECT 'x'
499: FROM okl_fe_eo_terms_all_b
500: WHERE end_of_term_id = p_ethv_rec.orig_end_of_term_id;
501: l_dummy_var VARCHAR2(1) := '?';
502:
503: BEGIN

Line 669: -- Procedure get_rec for OKL_FE_EO_TERMS_ALL_B

665: x_return_status := okc_api.g_ret_sts_unexp_error;
666: END validate_sts_code;
667:
668: --------------------------------------------------------------------------------
669: -- Procedure get_rec for OKL_FE_EO_TERMS_ALL_B
670: --------------------------------------------------------------------------------
671:
672: FUNCTION get_rec(p_ethb_rec IN okl_ethb_rec
673: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_ethb_rec IS

Line 709: FROM okl_fe_eo_terms_all_b

705: ,creation_date
706: ,last_updated_by
707: ,last_update_date
708: ,last_update_login
709: FROM okl_fe_eo_terms_all_b
710: WHERE okl_fe_eo_terms_all_b.end_of_term_id = p_id;
711: l_ethb_pk posb_pk_csr%ROWTYPE;
712: l_ethb_rec okl_ethb_rec;
713:

Line 710: WHERE okl_fe_eo_terms_all_b.end_of_term_id = p_id;

706: ,last_updated_by
707: ,last_update_date
708: ,last_update_login
709: FROM okl_fe_eo_terms_all_b
710: WHERE okl_fe_eo_terms_all_b.end_of_term_id = p_id;
711: l_ethb_pk posb_pk_csr%ROWTYPE;
712: l_ethb_rec okl_ethb_rec;
713:
714: BEGIN

Line 1316: FROM okl_fe_eo_terms_all_b

1312: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1313:
1314: CURSOR lock_csr(p_ethb_rec IN okl_ethb_rec) IS
1315: SELECT object_version_number
1316: FROM okl_fe_eo_terms_all_b
1317: WHERE end_of_term_id = p_ethb_rec.end_of_term_id
1318: AND object_version_number = p_ethb_rec.object_version_number
1319: FOR UPDATE OF object_version_number NOWAIT;
1320:

Line 1323: FROM okl_fe_eo_terms_all_b

1319: FOR UPDATE OF object_version_number NOWAIT;
1320:
1321: CURSOR lchk_csr(p_ethb_rec IN okl_ethb_rec) IS
1322: SELECT object_version_number
1323: FROM okl_fe_eo_terms_all_b
1324: WHERE end_of_term_id = p_ethb_rec.end_of_term_id;
1325: l_api_version CONSTANT NUMBER := 1;
1326: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1327: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

Line 1753: INSERT INTO okl_fe_eo_terms_all_b

1749: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1750: RAISE okc_api.g_exception_error;
1751: END IF;
1752:
1753: INSERT INTO okl_fe_eo_terms_all_b
1754: (end_of_term_id
1755: ,end_of_term_name
1756: ,object_version_number
1757: ,org_id

Line 2259: UPDATE okl_fe_eo_terms_all_b

2255: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2256: RAISE okc_api.g_exception_error;
2257: END IF;
2258:
2259: UPDATE okl_fe_eo_terms_all_b
2260: SET end_of_term_id = l_def_ethb_rec.end_of_term_id
2261: ,end_of_term_name = l_def_ethb_rec.end_of_term_name
2262: ,object_version_number = l_def_ethb_rec.object_version_number + 1
2263: ,org_id = l_def_ethb_rec.org_id

Line 2871: DELETE FROM okl_fe_eo_terms_all_b

2867: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2868: RAISE okc_api.g_exception_error;
2869: END IF;
2870:
2871: DELETE FROM okl_fe_eo_terms_all_b
2872: WHERE end_of_term_id = l_ethb_rec.end_of_term_id;
2873:
2874: EXCEPTION
2875: WHEN g_exception_halt_validation THEN