APPS.OKL_VENDOR_REFUND_PVT dependencies on OKL_CURE_AMOUNTS_PUB

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);