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_ECO_PVT dependencies on OKL_FE_CRIT_CAT_OBJECTS

Line 35: -- lock_row for:OKL_FE_CRIT_CAT_OBJECTS --

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

Line 49: FROM okl_fe_crit_cat_objects

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

Line 56: FROM okl_fe_crit_cat_objects

52: FOR UPDATE OF object_version_number NOWAIT;
53:
54: CURSOR lchk_csr(p_eco_rec IN okl_eco_rec) IS
55: SELECT object_version_number
56: FROM okl_fe_crit_cat_objects
57: WHERE object_class_id = p_eco_rec.object_class_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_crit_cat_objects.object_version_number%TYPE;

57: WHERE object_class_id = p_eco_rec.object_class_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_crit_cat_objects.object_version_number%TYPE;
62: lc_object_version_number okl_fe_crit_cat_objects.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_crit_cat_objects.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_crit_cat_objects.object_version_number%TYPE;
62: lc_object_version_number okl_fe_crit_cat_objects.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_CRIT_CAT_OBJECTS --

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

Line 406: ,p_token2_value => 'OKL_FE_CRIT_CAT_OBJECTS'

402: ,p_msg_name => g_no_parent_record
403: ,p_token1 => g_col_name_token
404: ,p_token1_value => 'CRIT_CAT_DEF_ID'
405: ,p_token2 => g_child_table_token
406: ,p_token2_value => 'OKL_FE_CRIT_CAT_OBJECTS'
407: ,p_token3 => g_parent_table_token
408: ,p_token3_value => 'OKL_FE_CRIT_CAT_DEF_V');
409: RAISE okl_api.g_exception_error;
410: END IF;

Line 534: -- Validate_Record for:OKL_FE_CRIT_CAT_OBJECTS --

530: RETURN g_ret_sts_unexp_error;
531: END validate_attributes;
532:
533: --------------------------------------------
534: -- Validate_Record for:OKL_FE_CRIT_CAT_OBJECTS --
535: --------------------------------------------
536:
537: FUNCTION validate_record(p_eco_rec IN okl_eco_rec) RETURN varchar2 IS
538: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 546: -- Procedure get_rec for OKL_FE_CRIT_CAT_OBJECTS

542: RETURN(l_return_status);
543: END validate_record;
544:
545: --------------------------------------------------------------------------------
546: -- Procedure get_rec for OKL_FE_CRIT_CAT_OBJECTS
547: --------------------------------------------------------------------------------
548:
549: FUNCTION get_rec(p_eco_rec IN okl_eco_rec
550: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_eco_rec IS

Line 562: FROM okl_fe_crit_cat_objects

558: ,creation_date
559: ,last_updated_by
560: ,last_update_date
561: ,last_update_login
562: FROM okl_fe_crit_cat_objects
563: WHERE okl_fe_crit_cat_objects.object_class_id = p_id;
564: l_eco_pk eco_pk_csr%ROWTYPE;
565: l_eco_rec okl_eco_rec;
566:

Line 563: WHERE okl_fe_crit_cat_objects.object_class_id = p_id;

559: ,last_updated_by
560: ,last_update_date
561: ,last_update_login
562: FROM okl_fe_crit_cat_objects
563: WHERE okl_fe_crit_cat_objects.object_class_id = p_id;
564: l_eco_pk eco_pk_csr%ROWTYPE;
565: l_eco_rec okl_eco_rec;
566:
567: BEGIN

Line 741: INSERT INTO okl_fe_crit_cat_objects

737: END IF;
738:
739: --insert into table
740:
741: INSERT INTO okl_fe_crit_cat_objects
742: (object_class_id
743: ,object_version_number
744: ,crit_cat_def_id
745: ,object_class_code

Line 1028: UPDATE okl_fe_crit_cat_objects

1024: END IF;
1025:
1026: --update the record
1027:
1028: UPDATE okl_fe_crit_cat_objects
1029: SET object_class_id = l_def_eco_rec.object_class_id
1030: ,object_version_number = l_def_eco_rec.object_version_number + 1
1031: ,crit_cat_def_id = l_def_eco_rec.crit_cat_def_id
1032: ,object_class_code = l_def_eco_rec.object_class_code

Line 1181: DELETE FROM okl_fe_crit_cat_objects

1177: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1178: RAISE okl_api.g_exception_error;
1179: END IF;
1180:
1181: DELETE FROM okl_fe_crit_cat_objects
1182: WHERE object_class_id = l_eco_rec.object_class_id;
1183:
1184: EXCEPTION
1185: WHEN g_exception_halt_validation THEN

Line 1315: from OKL_FE_CRIT_CAT_OBJECTS

1311: BEGIN
1312:
1313: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
1314: into id, db_luby, db_ludate
1315: from OKL_FE_CRIT_CAT_OBJECTS
1316: where OBJECT_CLASS_ID = p_object_class_id;
1317:
1318: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1319: db_ludate, '')) then

Line 1320: UPDATE OKL_FE_CRIT_CAT_OBJECTS

1316: where OBJECT_CLASS_ID = p_object_class_id;
1317:
1318: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1319: db_ludate, '')) then
1320: UPDATE OKL_FE_CRIT_CAT_OBJECTS
1321: SET
1322: OBJECT_VERSION_NUMBER = p_object_version_number,
1323: CRIT_CAT_DEF_ID = to_number(p_crit_cat_def_id),
1324: OBJECT_CLASS_CODE = p_object_class_code,

Line 1332: INSERT INTO OKL_FE_CRIT_CAT_OBJECTS

1328: WHERE OBJECT_CLASS_ID = to_number(p_object_class_id);
1329: END IF;
1330: exception
1331: when no_data_found then
1332: INSERT INTO OKL_FE_CRIT_CAT_OBJECTS
1333: (OBJECT_CLASS_ID,
1334: OBJECT_VERSION_NUMBER,
1335: CRIT_CAT_DEF_ID,
1336: OBJECT_CLASS_CODE,