APPS.OKL_CURE_CALC_PVT dependencies on OKL_CURE_AMOUNTS_PUB

Line 132: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;

128: --cure request, if a new contract is created, we should null out the crt id
129: --of the previous contract if negotiated amount is zero or null
130: --otherwise, okl_cure_invoices_uv will show all the contracts.
131:
132: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
133: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
134: l_msg_count NUMBER;
135: l_msg_data VARCHAR2(32627);
136: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

Line 133: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;

129: --of the previous contract if negotiated amount is zero or null
130: --otherwise, okl_cure_invoices_uv will show all the contracts.
131:
132: l_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
133: x_camv_tbl OKL_cure_amounts_pub.camv_tbl_type;
134: l_msg_count NUMBER;
135: l_msg_data VARCHAR2(32627);
136: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
137: next_row INTEGER;

Line 223: OKL_cure_amounts_pub.update_cure_amounts

219: write_log(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
220: 'no of records to be updated in Cure amounts '||
221: l_camv_tbl.COUNT);
222: IF l_camv_tbl.COUNT > 0 THEN
223: OKL_cure_amounts_pub.update_cure_amounts
224: ( p_api_version => 1
225: ,p_init_msg_list => 'T'
226: ,x_return_status => l_return_status
227: ,x_msg_count => l_msg_count

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

229: ,p_camv_tbl => l_camv_tbl
230: ,x_camv_tbl => x_camv_tbl
231: );
232:
233: okl_debug_pub.logmessage('Update_cure_amounts : OKL_cure_amounts_pub.update_cure_amounts : '||l_return_status);
234:
235: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
236: RAISE Fnd_Api.G_EXC_ERROR;
237: ELSE

Line 818: l_camv_rec OKL_cure_amounts_pub.camv_rec_type;

814: l_negotiated_amount NUMBER := 0;
815: l_outstanding_amount NUMBER := 0;
816: l_delinquent_amount NUMBER := 0;
817: l_cures_in_possession NUMBER := 0;
818: l_camv_rec OKL_cure_amounts_pub.camv_rec_type;
819: x_camv_rec OKL_cure_amounts_pub.camv_rec_type;
820: l_msg_count NUMBER;
821: l_msg_data VARCHAR2(32627);
822: l_error_msg_tbl error_message_type;

Line 819: x_camv_rec OKL_cure_amounts_pub.camv_rec_type;

815: l_outstanding_amount NUMBER := 0;
816: l_delinquent_amount NUMBER := 0;
817: l_cures_in_possession NUMBER := 0;
818: l_camv_rec OKL_cure_amounts_pub.camv_rec_type;
819: x_camv_rec OKL_cure_amounts_pub.camv_rec_type;
820: l_msg_count NUMBER;
821: l_msg_data VARCHAR2(32627);
822: l_error_msg_tbl error_message_type;
823:

Line 1003: OKL_cure_amounts_pub.insert_cure_amounts

999: ELSIF l_camv_rec.repurchase_amount =0 THEN
1000: l_camv_rec.repurchase_amount :=NULL;
1001: END IF;
1002:
1003: OKL_cure_amounts_pub.insert_cure_amounts
1004: (
1005: p_api_version => p_api_version
1006: ,p_init_msg_list => p_init_msg_list
1007: ,x_return_status => l_return_status

Line 1014: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : OKL_cure_amounts_pub.insert_cure_amounts : '||l_return_status);

1010: ,p_camv_rec => l_camv_rec
1011: ,x_camv_rec => x_camv_rec
1012: );
1013:
1014: okl_debug_pub.logmessage('CALC_CURE_REPURCHASE : OKL_cure_amounts_pub.insert_cure_amounts : '||l_return_status);
1015:
1016: IF (l_return_status <> FND_Api.G_RET_STS_SUCCESS ) THEN
1017: RAISE Fnd_Api.G_EXC_ERROR;
1018: ELSE