APPS.OKL_LEASE_RATE_FACTORS_PVT dependencies on OKL_LRL_PVT

Line 109: okl_lrl_pvt.insert_row(l_api_version

105: --populate the ecl_id with the id of the recently inserted record in okl_ec_lines tablein the
106:
107: lp_lrlv_tbl(j).rate_set_factor_id := lx_lrfv_tbl(i).id;
108: IF (lp_lrlv_tbl(j).rate_set_level_id IS NULL) THEN
109: okl_lrl_pvt.insert_row(l_api_version
110: ,g_false
111: ,l_return_status
112: ,x_msg_count
113: ,x_msg_data

Line 122: ,'Procedure okl_lrl_pvt.insert_row with status ' ||

118:
119: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
120: okl_debug_pub.log_debug(fnd_log.level_statement
121: ,l_module
122: ,'Procedure okl_lrl_pvt.insert_row with status ' ||
123: l_return_status);
124: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
125: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
126: RAISE okl_api.g_exception_error;

Line 131: okl_lrl_pvt.update_row(l_api_version

127: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
128: RAISE okl_api.g_exception_unexpected_error;
129: END IF;
130: ELSE
131: okl_lrl_pvt.update_row(l_api_version
132: ,g_false
133: ,l_return_status
134: ,x_msg_count
135: ,x_msg_data

Line 144: ,'Procedure okl_lrl_pvt.update_row with status ' ||

140:
141: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
142: okl_debug_pub.log_debug(fnd_log.level_statement
143: ,l_module
144: ,'Procedure okl_lrl_pvt.update_row with status ' ||
145: l_return_status);
146: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
147: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
148: RAISE okl_api.g_exception_error;

Line 185: okl_lrl_pvt.insert_row(l_api_version

181:
182: IF (lp_lrlv_tbl(j).rate_set_factor_id = lp_lrfv_tbl(i).id) THEN --populate the ecl_id with the id of the recently inserted record in okl_ec_lines tablein the
183: lp_lrlv_tbl(j).rate_set_factor_id := lx_lrfv_tbl(i).id;
184: IF (lp_lrlv_tbl(j).rate_set_level_id IS NULL) THEN
185: okl_lrl_pvt.insert_row(l_api_version
186: ,g_false
187: ,l_return_status
188: ,x_msg_count
189: ,x_msg_data

Line 198: ,'Procedure okl_lrl_pvt.insert_row with status ' ||

194:
195: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
196: okl_debug_pub.log_debug(fnd_log.level_statement
197: ,l_module
198: ,'Procedure okl_lrl_pvt.insert_row with status ' ||
199: l_return_status);
200: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
201: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
202: RAISE okl_api.g_exception_error;

Line 207: okl_lrl_pvt.update_row(l_api_version

203: ELSIF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
204: RAISE okl_api.g_exception_unexpected_error;
205: END IF;
206: ELSE
207: okl_lrl_pvt.update_row(l_api_version
208: ,g_false
209: ,l_return_status
210: ,x_msg_count
211: ,x_msg_data

Line 220: ,'Procedure okl_lrl_pvt.update_row with status ' ||

216:
217: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
218: okl_debug_pub.log_debug(fnd_log.level_statement
219: ,l_module
220: ,'Procedure okl_lrl_pvt.update_row with status ' ||
221: l_return_status);
222: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
223: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
224: RAISE okl_api.g_exception_error;

Line 359: okl_lrl_pvt.delete_row(p_api_version => p_api_version

355:
356: --delete all levels
357:
358: IF l_lrlv_tbl.COUNT > 0 THEN
359: okl_lrl_pvt.delete_row(p_api_version => p_api_version
360: ,p_init_msg_list => okl_api.g_false
361: ,x_return_status => l_return_status
362: ,x_msg_count => x_msg_count
363: ,x_msg_data => x_msg_data

Line 371: ,'Procedure OKL_LRL_PVT.delete_row returned with status ' ||

367:
368: IF (nvl(l_debug_enabled, 'N') = 'Y' AND is_debug_statement_on) THEN
369: okl_debug_pub.log_debug(fnd_log.level_statement
370: ,l_module
371: ,'Procedure OKL_LRL_PVT.delete_row returned with status ' ||
372: l_return_status);
373: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
374: IF l_return_status = g_ret_sts_error THEN
375: RAISE okl_api.g_exception_error;

Line 513: okl_lrl_pvt.delete_row(p_api_version => p_api_version

509:
510: --delete all levels
511:
512: IF l_lrlv_tbl.COUNT > 0 THEN
513: okl_lrl_pvt.delete_row(p_api_version => p_api_version
514: ,p_init_msg_list => okl_api.g_false
515: ,x_return_status => l_return_status
516: ,x_msg_count => x_msg_count
517: ,x_msg_data => x_msg_data

Line 624: okl_lrl_pvt.delete_row(p_api_version => p_api_version

620: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
621: RAISE okl_api.g_exception_error;
622: END IF;
623: l_lrlv_rec := p_lrlv_rec;
624: okl_lrl_pvt.delete_row(p_api_version => p_api_version
625: ,p_init_msg_list => okl_api.g_false
626: ,x_return_status => l_return_status
627: ,x_msg_count => x_msg_count
628: ,x_msg_data => x_msg_data