APPS.IEX_OPI_PVT dependencies on IEX_SCORES

Line 3043: l_score_id IEX_SCORES.SCORE_ID%TYPE;

3039: l_oinv_rec oinv_rec_type;
3040: l_iohv_rec iohv_rec_type;
3041: l_ext_agncy_id IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE;
3042: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3043: l_score_id IEX_SCORES.SCORE_ID%TYPE;
3044: l_score_value IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;
3045: l_score_found BOOLEAN := FALSE;
3046:
3047: TYPE ext_agncy_tbl_type IS TABLE OF IEX_OPEN_INT_HST.EXT_AGNCY_ID%TYPE

Line 3178: l_score_id IEX_SCORES.SCORE_ID%TYPE;

3174: l_recall VARCHAR2(1) := Okc_Api.G_TRUE;
3175:
3176: l_oinv_rec oinv_rec_type;
3177: l_iohv_rec iohv_rec_type;
3178: l_score_id IEX_SCORES.SCORE_ID%TYPE;
3179: l_score_value IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;
3180: l_score_value_previous IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;
3181:
3182: CURSOR l_score_csr(cp_case_id IN NUMBER

Line 3244: l_score_id IEX_SCORES.SCORE_ID%TYPE;

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;
3245: l_score_found BOOLEAN := FALSE;
3246: l_score_value IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;
3247:
3248: CURSOR l_score_csr(cp_case_id IN NUMBER