DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_INS_PVT dependencies on OKL_QUE_PVT

Line 11: ,x_l_ins_est_rec OUT NOCOPY okl_que_pvt.quev_rec_type

7: ----------------------------------------
8:
9: PROCEDURE get_insurance_estimate_rec(
10: p_insurance_estimate_id IN NUMBER
11: ,x_l_ins_est_rec OUT NOCOPY okl_que_pvt.quev_rec_type
12: ,x_return_status OUT NOCOPY VARCHAR2
13: )IS
14:
15: l_program_name CONSTANT VARCHAR2(30) := 'get_insurance_estimate_rec';

Line 179: l_quev_rec okl_que_pvt.quev_rec_type;

175:
176: l_program_name CONSTANT VARCHAR2(30) := 'insert_row';
177: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
178:
179: l_quev_rec okl_que_pvt.quev_rec_type;
180: lx_quev_rec okl_que_pvt.quev_rec_type;
181:
182: BEGIN
183:

Line 180: lx_quev_rec okl_que_pvt.quev_rec_type;

176: l_program_name CONSTANT VARCHAR2(30) := 'insert_row';
177: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
178:
179: l_quev_rec okl_que_pvt.quev_rec_type;
180: lx_quev_rec okl_que_pvt.quev_rec_type;
181:
182: BEGIN
183:
184: l_quev_rec.lease_quote_id := p_insurance_estimate_rec.lease_quote_id;

Line 206: okl_que_pvt.insert_row (

202: l_quev_rec.attribute14 := p_insurance_estimate_rec.attribute14;
203: l_quev_rec.attribute15 := p_insurance_estimate_rec.attribute15;
204: --Bug#6935907 -Addition end
205:
206: okl_que_pvt.insert_row (
207: p_api_version => G_API_VERSION
208: ,p_init_msg_list => G_FALSE
209: ,x_return_status => x_return_status
210: ,x_msg_count => x_msg_count

Line 260: l_quev_rec okl_que_pvt.quev_rec_type;

256:
257: l_program_name CONSTANT VARCHAR2(30) := 'update_row';
258: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
259:
260: l_quev_rec okl_que_pvt.quev_rec_type;
261: lx_quev_rec okl_que_pvt.quev_rec_type;
262:
263: BEGIN
264:

Line 261: lx_quev_rec okl_que_pvt.quev_rec_type;

257: l_program_name CONSTANT VARCHAR2(30) := 'update_row';
258: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
259:
260: l_quev_rec okl_que_pvt.quev_rec_type;
261: lx_quev_rec okl_que_pvt.quev_rec_type;
262:
263: BEGIN
264:
265: l_quev_rec.id := p_insurance_estimate_rec.id;

Line 289: okl_que_pvt.update_row (

285: l_quev_rec.attribute14 := p_insurance_estimate_rec.attribute14;
286: l_quev_rec.attribute15 := p_insurance_estimate_rec.attribute15;
287: --Bug#6935907 -Addition end
288:
289: okl_que_pvt.update_row (
290: p_api_version => G_API_VERSION
291: ,p_init_msg_list => G_FALSE
292: ,x_return_status => x_return_status
293: ,x_msg_count => x_msg_count

Line 878: l_ins_est_rec okl_que_pvt.quev_rec_type;

874:
875: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_insurance_estimate';
876: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
877:
878: l_ins_est_rec okl_que_pvt.quev_rec_type;
879: lx_ins_est_rec okl_que_pvt.quev_rec_type;
880:
881: BEGIN
882: IF p_transaction_control = G_TRUE THEN

Line 879: lx_ins_est_rec okl_que_pvt.quev_rec_type;

875: l_program_name CONSTANT VARCHAR2(30) := 'duplicate_insurance_estimate';
876: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
877:
878: l_ins_est_rec okl_que_pvt.quev_rec_type;
879: lx_ins_est_rec okl_que_pvt.quev_rec_type;
880:
881: BEGIN
882: IF p_transaction_control = G_TRUE THEN
883: SAVEPOINT l_program_name;

Line 907: okl_que_pvt.insert_row (

903:
904:
905: --call insert_row
906:
907: okl_que_pvt.insert_row (
908: p_api_version => G_API_VERSION
909: ,p_init_msg_list => G_FALSE
910: ,x_return_status => x_return_status
911: ,x_msg_count => x_msg_count