APPS.IEX_OPI_PVT dependencies on IEX_DEL_STATUSES

Line 2265: l_delinquency_status IEX_DEL_STATUSES.DEL_STATUS%TYPE;

2261: lx_message VARCHAR2(2000);
2262: l_api_version CONSTANT NUMBER := 1;
2263: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2264: l_recall VARCHAR2(1) := Okc_Api.G_FALSE;
2265: l_delinquency_status IEX_DEL_STATUSES.DEL_STATUS%TYPE;
2266:
2267: l_api_name CONSTANT VARCHAR2(30) := 'notify_recall_external_agency';
2268: l_ext_agncy_contracts_notified NUMBER := 0;
2269:

Line 3240: l_delinquency_status IEX_DEL_STATUSES.DEL_STATUS%TYPE;

3236: x_delinquency_status OUT NOCOPY VARCHAR2,
3237: x_return_status OUT NOCOPY VARCHAR2) AS
3238:
3239: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3240: l_delinquency_status IEX_DEL_STATUSES.DEL_STATUS%TYPE;
3241:
3242: l_oinv_rec oinv_rec_type;
3243: l_iohv_rec iohv_rec_type;
3244: l_score_id IEX_SCORES.SCORE_ID%TYPE;

Line 3262: FROM IEX_DEL_STATUSES

3258:
3259: CURSOR l_del_status_csr(cp_score_id IN NUMBER
3260: ,cp_score_value IN NUMBER) IS
3261: SELECT del_status
3262: FROM IEX_DEL_STATUSES
3263: WHERE score_id = cp_score_id
3264: AND cp_score_value BETWEEN score_value_low AND score_value_high;
3265: BEGIN
3266: l_oinv_rec := p_oinv_rec;