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_LRL_PVT dependencies on OKL_FE_RATE_SET_LEVELS

Line 72: -- lock_row for:OKL_FE_RATE_SET_LEVELS_V --

68: RETURN g_ret_sts_unexp_error;
69: END validate_id;
70:
71: --------------------------------------------
72: -- lock_row for:OKL_FE_RATE_SET_LEVELS_V --
73: --------------------------------------------
74:
75: PROCEDURE lock_row(p_init_msg_list IN varchar2
76: ,x_return_status OUT NOCOPY varchar2

Line 86: FROM okl_fe_rate_set_levels

82: PRAGMA exception_init(e_resource_busy, - 00054);
83:
84: CURSOR lock_csr(p_lrlv_rec IN okl_lrlv_rec) IS
85: SELECT object_version_number
86: FROM okl_fe_rate_set_levels
87: WHERE rate_set_level_id = p_lrlv_rec.rate_set_level_id
88: AND object_version_number = p_lrlv_rec.object_version_number
89: FOR UPDATE OF object_version_number NOWAIT;
90:

Line 93: FROM okl_fe_rate_set_levels

89: FOR UPDATE OF object_version_number NOWAIT;
90:
91: CURSOR lchk_csr(p_lrlv_rec IN okl_lrlv_rec) IS
92: SELECT object_version_number
93: FROM okl_fe_rate_set_levels
94: WHERE rate_set_level_id = p_lrlv_rec.rate_set_level_id;
95: l_api_version CONSTANT number := 1;
96: l_api_name CONSTANT varchar2(30) := 'V_lock_row';
97: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

Line 98: l_object_version_number okl_fe_rate_set_levels.object_version_number%TYPE;

94: WHERE rate_set_level_id = p_lrlv_rec.rate_set_level_id;
95: l_api_version CONSTANT number := 1;
96: l_api_name CONSTANT varchar2(30) := 'V_lock_row';
97: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
98: l_object_version_number okl_fe_rate_set_levels.object_version_number%TYPE;
99: lc_object_version_number okl_fe_rate_set_levels.object_version_number%TYPE;
100: l_row_notfound boolean := false;
101: lc_row_notfound boolean := false;
102:

Line 99: lc_object_version_number okl_fe_rate_set_levels.object_version_number%TYPE;

95: l_api_version CONSTANT number := 1;
96: l_api_name CONSTANT varchar2(30) := 'V_lock_row';
97: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
98: l_object_version_number okl_fe_rate_set_levels.object_version_number%TYPE;
99: lc_object_version_number okl_fe_rate_set_levels.object_version_number%TYPE;
100: l_row_notfound boolean := false;
101: lc_row_notfound boolean := false;
102:
103: BEGIN

Line 385: ,p_token2_value => 'OKL_FE_RATE_SET_LEVELS'

381: ,p_msg_name => g_no_parent_record
382: ,p_token1 => g_col_name_token
383: ,p_token1_value => 'RATE_SET_ID'
384: ,p_token2 => g_child_table_token
385: ,p_token2_value => 'OKL_FE_RATE_SET_LEVELS'
386: ,p_token3 => g_parent_table_token
387: ,p_token3_value => 'OKL_LS_RT_FCTR_SETS_B');
388: RAISE okl_api.g_exception_error;
389: END IF;

Line 468: ,p_token2_value => 'OKL_FE_RATE_SET_LEVELS'

464: ,p_msg_name => g_no_parent_record
465: ,p_token1 => g_col_name_token
466: ,p_token1_value => 'RATE_SET_VERSION_ID'
467: ,p_token2 => g_child_table_token
468: ,p_token2_value => 'OKL_FE_RATE_SET_LEVELS'
469: ,p_token3 => g_parent_table_token
470: ,p_token3_value => 'OKL_LS_RT_FCTR_VERS');
471: RAISE okl_api.g_exception_error;
472: END IF;

Line 545: ,p_token2_value => 'OKL_FE_RATE_SET_LEVELS'

541: ,p_msg_name => g_no_parent_record
542: ,p_token1 => g_col_name_token
543: ,p_token1_value => 'RATE_SET_FACTOR_ID'
544: ,p_token2 => g_child_table_token
545: ,p_token2_value => 'OKL_FE_RATE_SET_LEVELS'
546: ,p_token3 => g_parent_table_token
547: ,p_token3_value => 'OKL_LS_RT_FCTR_ENTS');
548: RAISE okl_api.g_exception_error;
549: END IF;

Line 679: -- Procedure get_rec for OKL_FE_RATE_SET_LEVELS_V

675: RETURN g_ret_sts_unexp_error;
676: END validate_lease_rate_factor;
677:
678: --------------------------------------------------------------------------------
679: -- Procedure get_rec for OKL_FE_RATE_SET_LEVELS_V
680: --------------------------------------------------------------------------------
681:
682: FUNCTION get_rec(p_lrlv_rec IN okl_lrlv_rec
683: ,x_no_data_found OUT NOCOPY boolean) RETURN okl_lrlv_rec IS

Line 716: FROM okl_fe_rate_set_levels_v

712: ,attribute12
713: ,attribute13
714: ,attribute14
715: ,attribute15
716: FROM okl_fe_rate_set_levels_v
717: WHERE okl_fe_rate_set_levels_v.rate_set_level_id = p_id;
718: l_lrlv_pk lrlv_pk_csr%ROWTYPE;
719: l_lrlv_rec okl_lrlv_rec;
720:

Line 717: WHERE okl_fe_rate_set_levels_v.rate_set_level_id = p_id;

713: ,attribute13
714: ,attribute14
715: ,attribute15
716: FROM okl_fe_rate_set_levels_v
717: WHERE okl_fe_rate_set_levels_v.rate_set_level_id = p_id;
718: l_lrlv_pk lrlv_pk_csr%ROWTYPE;
719: l_lrlv_rec okl_lrlv_rec;
720:
721: BEGIN

Line 1093: INSERT INTO okl_fe_rate_set_levels

1089: END IF;
1090:
1091: --insert into table
1092:
1093: INSERT INTO okl_fe_rate_set_levels
1094: (rate_set_level_id
1095: ,object_version_number
1096: ,residual_percent
1097: ,rate_set_id

Line 1501: UPDATE okl_fe_rate_set_levels

1497: RAISE okl_api.g_exception_error;
1498: END IF;
1499: --update the record
1500:
1501: UPDATE okl_fe_rate_set_levels
1502: SET rate_set_level_id = l_def_lrlv_rec.rate_set_level_id
1503: ,object_version_number = l_def_lrlv_rec.object_version_number
1504: ,residual_percent = l_def_lrlv_rec.residual_percent
1505: ,rate_set_id = l_def_lrlv_rec.rate_set_id

Line 1672: DELETE FROM okl_fe_rate_set_levels

1668: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1669: RAISE okl_api.g_exception_error;
1670: END IF;
1671:
1672: DELETE FROM okl_fe_rate_set_levels
1673: WHERE rate_set_level_id = l_lrlv_rec.rate_set_level_id;
1674: x_return_status := l_return_status;
1675: okl_api.end_activity(x_msg_count, x_msg_data);
1676: EXCEPTION