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 489: FROM okl_fe_eo_terms_all_b

485: ,p_ethv_rec IN okl_ethv_rec) IS
486:
487: CURSOR pos_exists_csr IS
488: SELECT 'x'
489: FROM okl_fe_eo_terms_all_b
490: WHERE end_of_term_id = p_ethv_rec.orig_end_of_term_id;
491: l_dummy_var VARCHAR2(1) := '?';
492:
493: BEGIN

Line 659: -- Procedure get_rec for OKL_FE_EO_TERMS_ALL_B

655: x_return_status := okc_api.g_ret_sts_unexp_error;
656: END validate_sts_code;
657:
658: --------------------------------------------------------------------------------
659: -- Procedure get_rec for OKL_FE_EO_TERMS_ALL_B
660: --------------------------------------------------------------------------------
661:
662: FUNCTION get_rec(p_ethb_rec IN okl_ethb_rec
663: ,x_no_data_found OUT NOCOPY BOOLEAN) RETURN okl_ethb_rec IS

Line 699: FROM okl_fe_eo_terms_all_b

695: ,creation_date
696: ,last_updated_by
697: ,last_update_date
698: ,last_update_login
699: FROM okl_fe_eo_terms_all_b
700: WHERE okl_fe_eo_terms_all_b.end_of_term_id = p_id;
701: l_ethb_pk posb_pk_csr%ROWTYPE;
702: l_ethb_rec okl_ethb_rec;
703:

Line 700: WHERE okl_fe_eo_terms_all_b.end_of_term_id = p_id;

696: ,last_updated_by
697: ,last_update_date
698: ,last_update_login
699: FROM okl_fe_eo_terms_all_b
700: WHERE okl_fe_eo_terms_all_b.end_of_term_id = p_id;
701: l_ethb_pk posb_pk_csr%ROWTYPE;
702: l_ethb_rec okl_ethb_rec;
703:
704: BEGIN

Line 1306: FROM okl_fe_eo_terms_all_b

1302: PRAGMA EXCEPTION_INIT(e_resource_busy, - 00054);
1303:
1304: CURSOR lock_csr(p_ethb_rec IN okl_ethb_rec) IS
1305: SELECT object_version_number
1306: FROM okl_fe_eo_terms_all_b
1307: WHERE end_of_term_id = p_ethb_rec.end_of_term_id
1308: AND object_version_number = p_ethb_rec.object_version_number
1309: FOR UPDATE OF object_version_number NOWAIT;
1310:

Line 1313: FROM okl_fe_eo_terms_all_b

1309: FOR UPDATE OF object_version_number NOWAIT;
1310:
1311: CURSOR lchk_csr(p_ethb_rec IN okl_ethb_rec) IS
1312: SELECT object_version_number
1313: FROM okl_fe_eo_terms_all_b
1314: WHERE end_of_term_id = p_ethb_rec.end_of_term_id;
1315: l_api_version CONSTANT NUMBER := 1;
1316: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1317: l_return_status VARCHAR2(1) := okl_api.g_ret_sts_success;

Line 1743: INSERT INTO okl_fe_eo_terms_all_b

1739: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1740: RAISE okc_api.g_exception_error;
1741: END IF;
1742:
1743: INSERT INTO okl_fe_eo_terms_all_b
1744: (end_of_term_id
1745: ,end_of_term_name
1746: ,object_version_number
1747: ,org_id

Line 2249: UPDATE okl_fe_eo_terms_all_b

2245: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2246: RAISE okc_api.g_exception_error;
2247: END IF;
2248:
2249: UPDATE okl_fe_eo_terms_all_b
2250: SET end_of_term_id = l_def_ethb_rec.end_of_term_id
2251: ,end_of_term_name = l_def_ethb_rec.end_of_term_name
2252: ,object_version_number = l_def_ethb_rec.object_version_number + 1
2253: ,org_id = l_def_ethb_rec.org_id

Line 2861: DELETE FROM okl_fe_eo_terms_all_b

2857: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2858: RAISE okc_api.g_exception_error;
2859: END IF;
2860:
2861: DELETE FROM okl_fe_eo_terms_all_b
2862: WHERE end_of_term_id = l_ethb_rec.end_of_term_id;
2863:
2864: EXCEPTION
2865: WHEN g_exception_halt_validation THEN