eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_OPI_PVT dependencies on IEX_SCORE_HISTORIES

Line 3044: l_score_value IEX_SCORE_HISTORIES.SCORE_VALUE%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
3048: INDEX BY BINARY_INTEGER;

Line 3060: FROM IEX_SCORE_HISTORIES

3056: CURSOR l_score_csr(cp_case_id IN NUMBER
3057: ,cp_score_id IN NUMBER
3058: ,cp_creation_date IN DATE) IS
3059: SELECT score_value
3060: FROM IEX_SCORE_HISTORIES
3061: WHERE score_object_id = cp_case_id
3062: AND score_object_code = 'IEX_CASES'
3063: AND score_id = cp_score_id
3064: AND TRUNC(creation_date) = TRUNC(cp_creation_date)

Line 3179: l_score_value IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;

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
3183: ,cp_score_id IN NUMBER

Line 3180: l_score_value_previous IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;

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
3183: ,cp_score_id IN NUMBER
3184: ,cp_creation_date IN DATE) IS

Line 3186: FROM IEX_SCORE_HISTORIES

3182: CURSOR l_score_csr(cp_case_id IN NUMBER
3183: ,cp_score_id IN NUMBER
3184: ,cp_creation_date IN DATE) IS
3185: SELECT score_value
3186: FROM IEX_SCORE_HISTORIES
3187: WHERE score_object_id = cp_case_id
3188: AND score_object_code = 'IEX_CASES'
3189: AND score_id = cp_score_id
3190: AND TRUNC(creation_date) = TRUNC(cp_creation_date)

Line 3246: l_score_value IEX_SCORE_HISTORIES.SCORE_VALUE%TYPE;

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
3249: ,cp_score_id IN NUMBER
3250: ,cp_creation_date IN DATE) IS

Line 3252: FROM IEX_SCORE_HISTORIES

3248: CURSOR l_score_csr(cp_case_id IN NUMBER
3249: ,cp_score_id IN NUMBER
3250: ,cp_creation_date IN DATE) IS
3251: SELECT score_value
3252: FROM IEX_SCORE_HISTORIES
3253: WHERE score_object_id = cp_case_id
3254: AND score_object_code = 'IEX_CASES'
3255: AND score_id = cp_score_id
3256: AND TRUNC(creation_date) = TRUNC(cp_creation_date)