APPS.OKL_VENDOR_REFUND_PVT dependencies on OKL_CURE_AMOUNTS

Line 35: FROM okl_cure_amounts

31: CURSOR c_get_cure_amts (p_contract_id IN NUMBER)
32: IS
33: SELECT cure_amount_id
34: ,object_version_number
35: FROM okl_cure_amounts
36: WHERE chr_id = p_contract_id
37: AND STATUS = 'CURESINPROGRESS';
38:
39: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;

Line 39: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;

35: FROM okl_cure_amounts
36: WHERE chr_id = p_contract_id
37: AND STATUS = 'CURESINPROGRESS';
38:
39: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
40: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
41: l_msg_count NUMBER;
42: l_msg_data VARCHAR2(32627);
43: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

Line 40: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;

36: WHERE chr_id = p_contract_id
37: AND STATUS = 'CURESINPROGRESS';
38:
39: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
40: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
41: l_msg_count NUMBER;
42: l_msg_data VARCHAR2(32627);
43: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
44: next_row INTEGER;

Line 81: OKL_cure_amounts_pub.update_cure_amounts

77: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
78: 'no of records to be updated in Cure amounts '||l_camv_tbl.COUNT);
79: IF (l_camv_tbl.COUNT > 0)
80: THEN
81: OKL_cure_amounts_pub.update_cure_amounts
82: ( p_api_version => 1
83: ,p_init_msg_list => 'T'
84: ,x_return_status => l_return_status
85: ,x_msg_count => l_msg_count

Line 90: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : OKL_cure_amounts_pub.update_cure_amounts : '||l_return_status);

86: ,x_msg_data => l_msg_data
87: ,p_camv_tbl => l_camv_tbl
88: ,x_camv_tbl => x_camv_tbl
89: );
90: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : OKL_cure_amounts_pub.update_cure_amounts : '||l_return_status);
91:
92: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS )
93: THEN
94: RAISE Fnd_Api.G_EXC_ERROR;

Line 164: l_camv_rec OKL_cure_amounts_pub.camv_rec_type;

160: l_outstanding_amount NUMBER := 0;
161: l_delinquent_amount NUMBER := 0;
162: l_cures_in_possession NUMBER := 0;
163:
164: l_camv_rec OKL_cure_amounts_pub.camv_rec_type;
165: x_camv_rec OKL_cure_amounts_pub.camv_rec_type;
166: l_crsv_rec OKL_cure_rfnd_stage_pub.crsv_rec_type;
167: x_crsv_rec OKL_cure_rfnd_stage_pub.crsv_rec_type;
168: l_msg_count NUMBER;

Line 165: x_camv_rec OKL_cure_amounts_pub.camv_rec_type;

161: l_delinquent_amount NUMBER := 0;
162: l_cures_in_possession NUMBER := 0;
163:
164: l_camv_rec OKL_cure_amounts_pub.camv_rec_type;
165: x_camv_rec OKL_cure_amounts_pub.camv_rec_type;
166: l_crsv_rec OKL_cure_rfnd_stage_pub.crsv_rec_type;
167: x_crsv_rec OKL_cure_rfnd_stage_pub.crsv_rec_type;
168: l_msg_count NUMBER;
169: l_msg_data VARCHAR2(32627);

Line 174: from okl_cure_amounts

170: l_error_msg_tbl error_message_type;
171:
172: Cursor c_calc_refund_csr (p_contract_id IN NUMBER) is
173: select nvl(sum(negotiated_amount),0), nvl(sum(received_amount),0)
174: from okl_cure_amounts
175: where chr_id =p_contract_id
176: and nvl(negotiated_amount,0) > 0
177: and nvl(received_amount,0) > 0
178: and status ='CURESINPROGRESS';

Line 555: and exists (select 1 from okl_cure_amounts cam

551: AND pty.rle_code = 'OKL_VENDOR'
552: AND pty.object1_id1 = to_char(vnd.id1)
553: AND pty.object1_id2 = vnd.id2
554: AND lease.contract_number =nvl(p_contract_number,lease.contract_number)
555: and exists (select 1 from okl_cure_amounts cam
556: where cam.chr_id = lease.id
557: and cam.status = 'CURESINPROGRESS'
558: and nvl(negotiated_amount,0) > 0);
559: /*

Line 563: l_cure_amount okl_cure_amounts.cure_amount%type;

559: /*
560: and exists (select 1 from okl_cure_reports cr
561: where cr.vendor_id = vnd.id1);
562: */
563: l_cure_amount okl_cure_amounts.cure_amount%type;
564:
565: /*if the cure invoice is paid in full (i.e remaining_amount =0)
566: then it is considered to be cured */
567: