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_ECC_PVT dependencies on OKL_FE_CRIT_CAT_DEF_B

Line 44: FROM OKL_FE_CRIT_CAT_DEF_B b

40: BEGIN
41:
42: DELETE FROM OKL_FE_CRIT_CAT_DEF_TL t
43: WHERE NOT EXISTS(SELECT NULL
44: FROM OKL_FE_CRIT_CAT_DEF_B b
45: WHERE b.crit_cat_def_id = t.crit_cat_def_id);
46:
47: UPDATE OKL_FE_CRIT_CAT_DEF_TL t
48: SET(crit_cat_desc) = (SELECT

Line 594: -- lock_row for:OKL_FE_CRIT_CAT_DEF_B --

590: ---------------------------------------------------------------------------
591: -- PROCEDURE lock_row
592: ---------------------------------------------------------------------------
593: ---------------------------------------
594: -- lock_row for:OKL_FE_CRIT_CAT_DEF_B --
595: ---------------------------------------
596:
597: PROCEDURE lock_row(p_init_msg_list IN varchar2
598: ,x_return_status OUT NOCOPY varchar2

Line 608: FROM okl_fe_crit_cat_def_b

604: PRAGMA exception_init(e_resource_busy, - 00054);
605:
606: CURSOR lock_csr(p_eccb_rec IN okl_eccb_rec) IS
607: SELECT object_version_number
608: FROM okl_fe_crit_cat_def_b
609: WHERE crit_cat_def_id = p_eccb_rec.crit_cat_def_id
610: AND object_version_number = p_eccb_rec.object_version_number
611: FOR UPDATE OF object_version_number NOWAIT;
612:

Line 615: FROM okl_fe_crit_cat_def_b

611: FOR UPDATE OF object_version_number NOWAIT;
612:
613: CURSOR lchk_csr(p_eccb_rec IN okl_eccb_rec) IS
614: SELECT object_version_number
615: FROM okl_fe_crit_cat_def_b
616: WHERE crit_cat_def_id = p_eccb_rec.crit_cat_def_id;
617: l_api_version CONSTANT number := 1;
618: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
619: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 620: l_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;

616: WHERE crit_cat_def_id = p_eccb_rec.crit_cat_def_id;
617: l_api_version CONSTANT number := 1;
618: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
619: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
620: l_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;
621: lc_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;
622: l_row_notfound boolean := false;
623: lc_row_notfound boolean := false;
624:

Line 621: lc_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;

617: l_api_version CONSTANT number := 1;
618: l_api_name CONSTANT varchar2(30) := 'B_lock_row';
619: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
620: l_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;
621: lc_object_version_number okl_fe_crit_cat_def_b.object_version_number%TYPE;
622: l_row_notfound boolean := false;
623: lc_row_notfound boolean := false;
624:
625: BEGIN

Line 983: -- Procedure get_rec for OKL_FE_CRIT_CAT_DEF_B

979: ,'_PVT');
980: END lock_row;
981:
982: --------------------------------------------------------------------------------
983: -- Procedure get_rec for OKL_FE_CRIT_CAT_DEF_B
984: --------------------------------------------------------------------------------
985:
986: FUNCTION get_rec(p_eccb_rec IN okl_eccb_rec
987: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_eccb_rec IS

Line 1007: FROM okl_fe_crit_cat_def_b

1003: ,creation_date
1004: ,last_updated_by
1005: ,last_update_date
1006: ,last_update_login
1007: FROM okl_fe_crit_cat_def_b
1008: WHERE okl_fe_crit_cat_def_b.crit_cat_def_id = p_id;
1009: l_eccb_pk eccb_pk_csr%ROWTYPE;
1010: l_eccb_rec okl_eccb_rec;
1011:

Line 1008: WHERE okl_fe_crit_cat_def_b.crit_cat_def_id = p_id;

1004: ,last_updated_by
1005: ,last_update_date
1006: ,last_update_login
1007: FROM okl_fe_crit_cat_def_b
1008: WHERE okl_fe_crit_cat_def_b.crit_cat_def_id = p_id;
1009: l_eccb_pk eccb_pk_csr%ROWTYPE;
1010: l_eccb_rec okl_eccb_rec;
1011:
1012: BEGIN

Line 1469: INSERT INTO okl_fe_crit_cat_def_b

1465: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1466: RAISE okl_api.g_exception_error;
1467: END IF;
1468:
1469: INSERT INTO okl_fe_crit_cat_def_b
1470: (crit_cat_def_id
1471: ,object_version_number
1472: ,crit_cat_name
1473: ,ecc_ac_flag

Line 1969: UPDATE okl_fe_crit_cat_def_b

1965: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1966: RAISE okl_api.g_exception_error;
1967: END IF;
1968:
1969: UPDATE okl_fe_crit_cat_def_b
1970: SET crit_cat_def_id = l_eccb_rec.crit_cat_def_id
1971: ,object_version_number = l_eccb_rec.object_version_number + 1
1972: ,crit_cat_name = l_eccb_rec.crit_cat_name
1973: ,ecc_ac_flag = l_eccb_rec.ecc_ac_flag

Line 2507: DELETE FROM okl_fe_crit_cat_def_b

2503: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2504: RAISE okl_api.g_exception_error;
2505: END IF;
2506:
2507: DELETE FROM okl_fe_crit_cat_def_b
2508: WHERE crit_cat_def_id = l_eccb_rec.crit_cat_def_id;
2509: x_return_status := l_return_status;
2510: okl_api.end_activity(x_msg_count, x_msg_data);
2511: EXCEPTION

Line 2847: FROM OKL_FE_CRIT_CAT_DEF_B

2843:
2844: BEGIN
2845: SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
2846: INTO id, db_luby, db_ludate
2847: FROM OKL_FE_CRIT_CAT_DEF_B
2848: where crit_cat_def_id = p_eccv_rec.crit_cat_def_id;
2849:
2850: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2851: db_ludate, '')) then

Line 2853: UPDATE okl_fe_crit_cat_def_b

2849:
2850: IF(fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2851: db_ludate, '')) then
2852: --Update _b
2853: UPDATE okl_fe_crit_cat_def_b
2854: SET crit_cat_def_id = p_eccv_rec.crit_cat_def_id
2855: ,object_version_number = p_eccv_rec.object_version_number + 1
2856: ,crit_cat_name = p_eccv_rec.crit_cat_name
2857: ,ecc_ac_flag = p_eccv_rec.ecc_ac_flag

Line 2920: INSERT INTO okl_fe_crit_cat_def_b

2916:
2917: END;
2918: EXCEPTION
2919: when no_data_found then
2920: INSERT INTO okl_fe_crit_cat_def_b
2921: (crit_cat_def_id
2922: ,object_version_number
2923: ,crit_cat_name
2924: ,ecc_ac_flag