eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ECL_PVT dependencies on OKL_FE_CRITERIA

Line 35: -- lock_row for:OKL_FE_CRITERIA --

31: NULL;
32: END change_version;
33:
34: ---------------------------------------
35: -- lock_row for:OKL_FE_CRITERIA --
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

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

Line 56: FROM okl_fe_criteria

52: FOR UPDATE OF object_version_number NOWAIT;
53:
54: CURSOR lchk_csr(p_ecl_rec IN okl_ecl_rec) IS
55: SELECT object_version_number
56: FROM okl_fe_criteria
57: WHERE criteria_id = p_ecl_rec.criteria_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.object_version_number%TYPE;

57: WHERE criteria_id = p_ecl_rec.criteria_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.object_version_number%TYPE;
62: lc_object_version_number okl_fe_criteria.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.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.object_version_number%TYPE;
62: lc_object_version_number okl_fe_criteria.object_version_number%TYPE;
63: l_row_notfound boolean := false;
64: lc_row_notfound boolean := false;
65:
66: BEGIN

Line 146: -- PL/SQL TBL lock_row for: OKL_FE_CRITERIA --

142: ,'_PVT');
143: END lock_row;
144:
145: --------------------------------------------------
146: -- PL/SQL TBL lock_row for: OKL_FE_CRITERIA --
147: --------------------------------------------------
148:
149: PROCEDURE lock_row(p_api_version IN number
150: ,p_init_msg_list IN varchar2

Line 352: ,p_token2_value => 'OKL_FE_CRITERIA'

348: ,p_msg_name => g_no_parent_record
349: ,p_token1 => g_col_name_token
350: ,p_token1_value => 'CRIT_CAT_DEF_ID'
351: ,p_token2 => g_child_table_token
352: ,p_token2_value => 'OKL_FE_CRITERIA'
353: ,p_token3 => g_parent_table_token
354: ,p_token3_value => 'OKL_FE_CRIT_CAT_DEF_V');
355: RAISE okl_api.g_exception_error;
356: END IF;

Line 405: FROM okl_fe_criteria_set

401: -- select the ID of the parent record from the parent table
402:
403: CURSOR l_ech_csr IS
404: SELECT 'x'
405: FROM okl_fe_criteria_set
406: WHERE criteria_set_id = p_criteria_set_id;
407:
408: BEGIN
409:

Line 435: ,p_token2_value => 'OKL_FE_CRITERIA'

431: ,p_msg_name => g_no_parent_record
432: ,p_token1 => g_col_name_token
433: ,p_token1_value => 'CRITERIA_SET_ID'
434: ,p_token2 => g_child_table_token
435: ,p_token2_value => 'OKL_FE_CRITERIA'
436: ,p_token3 => g_parent_table_token
437: ,p_token3_value => 'OKL_FE_CRITERIA_SET');
438: RAISE okl_api.g_exception_error;
439: END IF;

Line 437: ,p_token3_value => 'OKL_FE_CRITERIA_SET');

433: ,p_token1_value => 'CRITERIA_SET_ID'
434: ,p_token2 => g_child_table_token
435: ,p_token2_value => 'OKL_FE_CRITERIA'
436: ,p_token3 => g_parent_table_token
437: ,p_token3_value => 'OKL_FE_CRITERIA_SET');
438: RAISE okl_api.g_exception_error;
439: END IF;
440: RETURN g_ret_sts_success;
441: EXCEPTION

Line 558: -- Procedure get_rec for OKL_FE_CRITERIA

554: RETURN g_ret_sts_unexp_error;
555: END validate_match_criteria_code;
556:
557: --------------------------------------------------------------------------------
558: -- Procedure get_rec for OKL_FE_CRITERIA
559: --------------------------------------------------------------------------------
560:
561: FUNCTION get_rec(p_ecl_rec IN okl_ecl_rec
562: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_ecl_rec IS

Line 577: FROM okl_fe_criteria

573: ,creation_date
574: ,last_updated_by
575: ,last_update_date
576: ,last_update_login
577: FROM okl_fe_criteria
578: WHERE okl_fe_criteria.criteria_id = p_id;
579: l_ecl_pk ecl_pk_csr%ROWTYPE;
580: l_ecl_rec okl_ecl_rec;
581:

Line 578: WHERE okl_fe_criteria.criteria_id = p_id;

574: ,last_updated_by
575: ,last_update_date
576: ,last_update_login
577: FROM okl_fe_criteria
578: WHERE okl_fe_criteria.criteria_id = p_id;
579: l_ecl_pk ecl_pk_csr%ROWTYPE;
580: l_ecl_rec okl_ecl_rec;
581:
582: BEGIN

Line 879: INSERT INTO okl_fe_criteria

875: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
876: RAISE okl_api.g_exception_error;
877: END IF; --insert into table
878:
879: INSERT INTO okl_fe_criteria
880: (criteria_id
881: ,object_version_number
882: ,criteria_set_id
883: ,crit_cat_def_id

Line 1183: UPDATE okl_fe_criteria

1179:
1180: --
1181: --update the record
1182:
1183: UPDATE okl_fe_criteria
1184: SET criteria_id = l_def_ecl_rec.criteria_id
1185: ,object_version_number = l_def_ecl_rec.object_version_number + 1
1186: ,criteria_set_id = l_def_ecl_rec.criteria_set_id
1187: ,crit_cat_def_id = l_def_ecl_rec.crit_cat_def_id

Line 1336: DELETE FROM okl_fe_criteria

1332: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1333: RAISE okl_api.g_exception_error;
1334: END IF;
1335:
1336: DELETE FROM okl_fe_criteria
1337: WHERE criteria_id = l_ecl_rec.criteria_id;
1338: x_return_status := l_return_status;
1339: okl_api.end_activity(x_msg_count, x_msg_data);
1340: EXCEPTION