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_ECV_PVT dependencies on OKL_FE_CRITERION_VALUES

Line 35: -- lock_row for:OKL_FE_CRITERION_VALUES --

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

Line 49: FROM okl_fe_criterion_values

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

Line 56: FROM okl_fe_criterion_values

52: FOR UPDATE OF object_version_number NOWAIT;
53:
54: CURSOR lchk_csr(p_ecv_rec IN okl_ecv_rec) IS
55: SELECT object_version_number
56: FROM okl_fe_criterion_values
57: WHERE criterion_value_id = p_ecv_rec.criterion_value_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_criterion_values.object_version_number%TYPE;

57: WHERE criterion_value_id = p_ecv_rec.criterion_value_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_criterion_values.object_version_number%TYPE;
62: lc_object_version_number okl_fe_criterion_values.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_criterion_values.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_criterion_values.object_version_number%TYPE;
62: lc_object_version_number okl_fe_criterion_values.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_CRITERION_VALUES --

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

Line 351: ,p_token2_value => 'OKL_FE_CRITERION_VALUES'

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

Line 393: -- Procedure get_rec for OKL_FE_CRITERION_VALUES

389: RETURN g_ret_sts_unexp_error;
390: END validate_criteria_id;
391:
392: --------------------------------------------------------------------------------
393: -- Procedure get_rec for OKL_FE_CRITERION_VALUES
394: --------------------------------------------------------------------------------
395:
396: FUNCTION get_rec(p_ecv_rec IN okl_ecv_rec
397: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_ecv_rec IS

Line 428: FROM okl_fe_criterion_values

424: ,attribute12
425: ,attribute13
426: ,attribute14
427: ,attribute15
428: FROM okl_fe_criterion_values
429: WHERE okl_fe_criterion_values.criterion_value_id = p_id;
430: l_ecv_pk ecv_pk_csr%ROWTYPE;
431: l_ecv_rec okl_ecv_rec;
432:

Line 429: WHERE okl_fe_criterion_values.criterion_value_id = p_id;

425: ,attribute13
426: ,attribute14
427: ,attribute15
428: FROM okl_fe_criterion_values
429: WHERE okl_fe_criterion_values.criterion_value_id = p_id;
430: l_ecv_pk ecv_pk_csr%ROWTYPE;
431: l_ecv_rec okl_ecv_rec;
432:
433: BEGIN

Line 889: INSERT INTO okl_fe_criterion_values

885: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
886: RAISE okl_api.g_exception_error;
887: END IF; --insert into table
888:
889: INSERT INTO okl_fe_criterion_values
890: (criterion_value_id
891: ,object_version_number
892: ,criteria_id
893: ,operator_code

Line 1296: UPDATE okl_fe_criterion_values

1292:
1293: --
1294: --update the record
1295:
1296: UPDATE okl_fe_criterion_values
1297: SET criterion_value_id = l_def_ecv_rec.criterion_value_id
1298: ,object_version_number = l_def_ecv_rec.object_version_number + 1
1299: ,criteria_id = l_def_ecv_rec.criteria_id
1300: ,operator_code = l_def_ecv_rec.operator_code

Line 1465: DELETE FROM okl_fe_criterion_values

1461: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1462: RAISE okl_api.g_exception_error;
1463: END IF;
1464:
1465: DELETE FROM okl_fe_criterion_values
1466: WHERE criterion_value_id = l_ecv_rec.criterion_value_id;
1467: x_return_status := l_return_status;
1468: okl_api.end_activity(x_msg_count, x_msg_data);
1469: EXCEPTION