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_LRF_PVT dependencies on OKL_LS_RT_FCTR_ENTS

Line 73: FROM okl_ls_rt_fctr_ents_v lrfv

69: ,l_lrfv_rec.attribute13
70: ,l_lrfv_rec.attribute14
71: ,l_lrfv_rec.attribute15
72: ,l_lrfv_rec.rate_set_version_id
73: FROM okl_ls_rt_fctr_ents_v lrfv
74: WHERE lrfv.id = p_id;
75: x_return_status := g_ret_sts_success;
76: RETURN l_lrfv_rec;
77: EXCEPTION

Line 95: -- FUNCTION null_out_defaults for: OKL_LS_RT_FCTR_ENTS_V

91: x_return_status := g_ret_sts_unexp_error;
92: END get_rec;
93:
94: ---------------------------------------------------------------------------
95: -- FUNCTION null_out_defaults for: OKL_LS_RT_FCTR_ENTS_V
96: ---------------------------------------------------------------------------
97:
98: FUNCTION null_out_defaults(p_lrfv_rec IN lrfv_rec_type) RETURN lrfv_rec_type IS
99: l_lrfv_rec lrfv_rec_type := p_lrfv_rec;

Line 688: FROM okl_ls_rt_fctr_ents

684: --asawanka start changed 'lrt_id = p_lrfv_rec.lrt_id' to 'rate_set_version_id=p_lrfv_rec.rate_set_version_id'
685:
686: CURSOR c_enforce_uk IS
687: SELECT 'x'
688: FROM okl_ls_rt_fctr_ents
689: WHERE rate_set_version_id = p_lrfv_rec.rate_set_version_id --lrt_id = p_lrfv_rec.lrt_id
690: AND term_in_months = p_lrfv_rec.term_in_months
691: AND residual_value_percent = p_lrfv_rec.residual_value_percent
692: AND interest_rate = p_lrfv_rec.interest_rate

Line 865: INSERT INTO okl_ls_rt_fctr_ents

861: ELSIF (l_return_status = g_ret_sts_error) THEN
862: RAISE okl_api.g_exception_error;
863: END IF;
864:
865: INSERT INTO okl_ls_rt_fctr_ents
866: (id
867: ,object_version_number
868: ,lrt_id
869: ,term_in_months

Line 1019: FROM okl_ls_rt_fctr_ents

1015: PRAGMA exception_init(e_resource_busy, - 00054);
1016:
1017: CURSOR lock_csr(p_lrfv_rec IN lrfv_rec_type) IS
1018: SELECT object_version_number
1019: FROM okl_ls_rt_fctr_ents
1020: WHERE id = p_lrfv_rec.id
1021: AND object_version_number = p_lrfv_rec.object_version_number
1022: FOR UPDATE OF object_version_number NOWAIT;
1023:

Line 1026: FROM okl_ls_rt_fctr_ents

1022: FOR UPDATE OF object_version_number NOWAIT;
1023:
1024: CURSOR lchk_csr(p_lrfv_rec IN lrfv_rec_type) IS
1025: SELECT object_version_number
1026: FROM okl_ls_rt_fctr_ents
1027: WHERE id = p_lrfv_rec.id;
1028: l_return_status varchar2(1);
1029: l_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;
1030: lc_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;

Line 1029: l_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;

1025: SELECT object_version_number
1026: FROM okl_ls_rt_fctr_ents
1027: WHERE id = p_lrfv_rec.id;
1028: l_return_status varchar2(1);
1029: l_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;
1030: lc_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;
1031: l_row_notfound boolean := false;
1032: lc_row_notfound boolean := false;
1033:

Line 1030: lc_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;

1026: FROM okl_ls_rt_fctr_ents
1027: WHERE id = p_lrfv_rec.id;
1028: l_return_status varchar2(1);
1029: l_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;
1030: lc_object_version_number okl_ls_rt_fctr_ents.object_version_number%TYPE;
1031: l_row_notfound boolean := false;
1032: lc_row_notfound boolean := false;
1033:
1034: BEGIN

Line 1146: -- update_row for:OKL_LS_RT_FCTR_ENTS_V --

1142: x_return_status := g_ret_sts_unexp_error;
1143: END lock_row;
1144:
1145: ------------------------------------------
1146: -- update_row for:OKL_LS_RT_FCTR_ENTS_V --
1147: ------------------------------------------
1148:
1149: PROCEDURE update_row(p_api_version IN number
1150: ,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false

Line 1345: UPDATE okl_ls_rt_fctr_ents

1341: ELSIF (l_return_status = g_ret_sts_error) THEN
1342: RAISE okl_api.g_exception_error;
1343: END IF;
1344:
1345: UPDATE okl_ls_rt_fctr_ents
1346: SET object_version_number = l_lrfv_rec.object_version_number + 1
1347: ,lrt_id = l_lrfv_rec.lrt_id
1348: ,term_in_months = l_lrfv_rec.term_in_months
1349: ,residual_value_percent = l_lrfv_rec.residual_value_percent

Line 1466: DELETE FROM okl_ls_rt_fctr_ents

1462: l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (REC)';
1463:
1464: BEGIN
1465:
1466: DELETE FROM okl_ls_rt_fctr_ents
1467: WHERE id = p_lrfv_rec.id;
1468: x_return_status := g_ret_sts_success;
1469: EXCEPTION
1470: WHEN okl_api.g_exception_error THEN