APPS.OKL_ECH_PVT dependencies on OKL_FE_CRITERIA_SET

Line 35: -- lock_row for:OKL_FE_CRITERIA_SET --

31: NULL;
32: END change_version;
33:
34: ---------------------------------------
35: -- lock_row for:OKL_FE_CRITERIA_SET --
36: ---------------------------------------
37:
38: PROCEDURE lock_row(p_init_msg_list IN varchar2
39: ,x_return_status OUT NOCOPY varchar2

Line 49: FROM okl_fe_criteria_set

45: PRAGMA exception_init(e_resource_busy, - 00054);
46:
47: CURSOR lock_csr(p_ech_rec IN okl_ech_rec) IS
48: SELECT object_version_number
49: FROM okl_fe_criteria_set
50: WHERE criteria_set_id = p_ech_rec.criteria_set_id
51: AND object_version_number = p_ech_rec.object_version_number
52: FOR UPDATE OF object_version_number NOWAIT;
53:

Line 56: FROM okl_fe_criteria_set

52: FOR UPDATE OF object_version_number NOWAIT;
53:
54: CURSOR lchk_csr(p_ech_rec IN okl_ech_rec) IS
55: SELECT object_version_number
56: FROM okl_fe_criteria_set
57: WHERE criteria_set_id = p_ech_rec.criteria_set_id;
58: l_api_version CONSTANT number := 1;
59: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
60: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 61: l_object_version_number okl_fe_criteria_set.object_version_number%TYPE;

57: WHERE criteria_set_id = p_ech_rec.criteria_set_id;
58: l_api_version CONSTANT number := 1;
59: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
60: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
61: l_object_version_number okl_fe_criteria_set.object_version_number%TYPE;
62: lc_object_version_number okl_fe_criteria_set.object_version_number%TYPE;
63: l_row_notfound boolean := false;
64: lc_row_notfound boolean := false;
65:

Line 62: lc_object_version_number okl_fe_criteria_set.object_version_number%TYPE;

58: l_api_version CONSTANT number := 1;
59: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
60: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
61: l_object_version_number okl_fe_criteria_set.object_version_number%TYPE;
62: lc_object_version_number okl_fe_criteria_set.object_version_number%TYPE;
63: l_row_notfound boolean := false;
64: lc_row_notfound boolean := false;
65:
66: BEGIN

Line 150: -- PL/SQL TBL lock_row for: OKL_FE_CRITERIA_SET --

146: ,'_PVT');
147: END lock_row;
148:
149: --------------------------------------------------
150: -- PL/SQL TBL lock_row for: OKL_FE_CRITERIA_SET --
151: --------------------------------------------------
152:
153: PROCEDURE lock_row(p_api_version IN number
154: ,p_init_msg_list IN varchar2

Line 408: -- Procedure get_rec for OKL_FE_CRITERIA_SET

404: RETURN g_ret_sts_unexp_error;
405: END validate_source_object_code;
406:
407: --------------------------------------------------------------------------------
408: -- Procedure get_rec for OKL_FE_CRITERIA_SET
409: --------------------------------------------------------------------------------
410:
411: FUNCTION get_rec(p_ech_rec IN okl_ech_rec
412: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_ech_rec IS

Line 426: FROM okl_fe_criteria_set

422: ,creation_date
423: ,last_updated_by
424: ,last_update_date
425: ,last_update_login
426: FROM okl_fe_criteria_set
427: WHERE okl_fe_criteria_set.criteria_set_id = p_id;
428: l_ech_pk ech_pk_csr%ROWTYPE;
429: l_ech_rec okl_ech_rec;
430:

Line 427: WHERE okl_fe_criteria_set.criteria_set_id = p_id;

423: ,last_updated_by
424: ,last_update_date
425: ,last_update_login
426: FROM okl_fe_criteria_set
427: WHERE okl_fe_criteria_set.criteria_set_id = p_id;
428: l_ech_pk ech_pk_csr%ROWTYPE;
429: l_ech_rec okl_ech_rec;
430:
431: BEGIN

Line 748: INSERT INTO okl_fe_criteria_set

744: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
745: RAISE okl_api.g_exception_error;
746: END IF; --insert into table
747:
748: INSERT INTO okl_fe_criteria_set
749: (criteria_set_id
750: ,object_version_number
751: ,source_id
752: ,source_object_code

Line 1047: UPDATE okl_fe_criteria_set

1043: --update the record
1044:
1045:
1046:
1047: UPDATE okl_fe_criteria_set
1048: SET criteria_set_id = l_def_ech_rec.criteria_set_id
1049: ,object_version_number = l_def_ech_rec.object_version_number + 1
1050: ,source_id = l_def_ech_rec.source_id
1051: ,source_object_code = l_def_ech_rec.source_object_code

Line 1200: DELETE FROM okl_fe_criteria_set

1196: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1197: RAISE okl_api.g_exception_error;
1198: END IF;
1199:
1200: DELETE FROM okl_fe_criteria_set
1201: WHERE criteria_set_id = l_ech_rec.criteria_set_id;
1202: x_return_status := l_return_status;
1203: okl_api.end_activity(x_msg_count, x_msg_data);
1204: EXCEPTION