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_LRV_PVT dependencies on OKL_FE_RATE_SET_VERSIONS

Line 35: -- lock_row for:OKL_FE_RATE_SET_VERSIONS --

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

Line 49: FROM okl_fe_rate_set_versions

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

Line 56: FROM okl_fe_rate_set_versions

52: FOR UPDATE OF object_version_number NOWAIT;
53:
54: CURSOR lchk_csr(p_lrvv_rec IN okl_lrvv_rec) IS
55: SELECT object_version_number
56: FROM okl_fe_rate_set_versions
57: WHERE rate_set_version_id = p_lrvv_rec.rate_set_version_id;
58: l_api_version CONSTANT number := 1;
59: l_api_name CONSTANT varchar2(30) := 'V_lock_row';
60: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 61: l_object_version_number okl_fe_rate_set_versions.object_version_number%TYPE;

57: WHERE rate_set_version_id = p_lrvv_rec.rate_set_version_id;
58: l_api_version CONSTANT number := 1;
59: l_api_name CONSTANT varchar2(30) := 'V_lock_row';
60: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
61: l_object_version_number okl_fe_rate_set_versions.object_version_number%TYPE;
62: lc_object_version_number okl_fe_rate_set_versions.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_rate_set_versions.object_version_number%TYPE;

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

Line 351: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'

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

Line 657: -- Procedure get_rec for OKL_FE_RATE_SET_VERSIONS_V

653: END validate_rate_tolerance;
654:
655:
656: --------------------------------------------------------------------------------
657: -- Procedure get_rec for OKL_FE_RATE_SET_VERSIONS_V
658: --------------------------------------------------------------------------------
659:
660: FUNCTION get_rec(p_lrvv_rec IN okl_lrvv_rec
661: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_lrvv_rec IS

Line 702: FROM okl_fe_rate_set_versions_v

698: ,attribute13
699: ,attribute14
700: ,attribute15
701: ,standard_rate
702: FROM okl_fe_rate_set_versions_v
703: WHERE rate_set_version_id = p_id;
704: l_lrvv_pk lrvv_pk_csr%ROWTYPE;
705: l_lrvv_rec okl_lrvv_rec;
706:

Line 1079: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'

1075: ,p_msg_name => g_no_parent_record
1076: ,p_token1 => g_col_name_token
1077: ,p_token1_value => 'END_OF_TERM_VER_ID'
1078: ,p_token2 => g_child_table_token
1079: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'
1080: ,p_token3 => g_parent_table_token
1081: ,p_token3_value => 'OKL_FE_EO_TERM_VERS');
1082: RAISE okl_api.g_exception_error;
1083: END IF;

Line 1101: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'

1097: ,p_msg_name => g_no_parent_record
1098: ,p_token1 => g_col_name_token
1099: ,p_token1_value => 'STD_RATE_TMPL_VER_ID'
1100: ,p_token2 => g_child_table_token
1101: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'
1102: ,p_token3 => g_parent_table_token
1103: ,p_token3_value => 'OKL_FE_SRT_VERSIONS');
1104: RAISE okl_api.g_exception_error;
1105: END IF;

Line 1125: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'

1121: ,p_msg_name => g_no_parent_record
1122: ,p_token1 => g_col_name_token
1123: ,p_token1_value => 'PAM_VERSION_ID'
1124: ,p_token2 => g_child_table_token
1125: ,p_token2_value => 'OKL_FE_RATE_SET_VERSIONS'
1126: ,p_token3 => g_parent_table_token
1127: ,p_token3_value => 'OKL_FE_ADJ_MAT_VERSIONS');
1128: RAISE okl_api.g_exception_error;
1129: END IF;

Line 1260: INSERT INTO okl_fe_rate_set_versions

1256: END IF;
1257:
1258: --insert into table
1259:
1260: INSERT INTO okl_fe_rate_set_versions
1261: (rate_set_version_id
1262: ,object_version_number
1263: ,arrears_yn
1264: ,effective_from_date

Line 1730: UPDATE okl_fe_rate_set_versions

1726: RAISE okl_api.g_exception_error;
1727: END IF;
1728: --update the record
1729:
1730: UPDATE okl_fe_rate_set_versions
1731: SET rate_set_version_id = l_def_lrvv_rec.rate_set_version_id
1732: ,object_version_number = l_def_lrvv_rec.object_version_number + 1
1733: ,arrears_yn = l_def_lrvv_rec.arrears_yn
1734: ,effective_from_date = l_def_lrvv_rec.effective_from_date

Line 1910: DELETE FROM okl_fe_rate_set_versions

1906: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1907: RAISE okl_api.g_exception_error;
1908: END IF;
1909:
1910: DELETE FROM okl_fe_rate_set_versions
1911: WHERE rate_set_version_id = l_lrvv_rec.rate_set_version_id;
1912: x_return_status := l_return_status;
1913: okl_api.end_activity(x_msg_count, x_msg_data);
1914: EXCEPTION