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.

[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_K_RATE_PARAMS_V

Line 433: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,

429: p_effective_from_date IN DATE,
430: x_krpv_rec OUT NOCOPY krpv_rec_type,
431: x_no_data_found OUT NOCOPY BOOLEAN
432: ) IS
433: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,
434: p_khr_id IN NUMBER,
435: p_parameter_type_code IN VARCHAR2) IS
436: SELECT
437: KHR_ID,

Line 485: FROM Okl_K_Rate_Params_V

481: CREATION_DATE,
482: LAST_UPDATED_BY,
483: LAST_UPDATE_DATE,
484: LAST_UPDATE_LOGIN
485: FROM Okl_K_Rate_Params_V
486: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
487: AND khr_id = p_khr_id
488: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

Line 489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

485: FROM Okl_K_Rate_Params_V
486: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
487: AND khr_id = p_khr_id
488: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
490: BEGIN
491: x_no_data_found := TRUE;
492: -- Get current database values
493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

Line 493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
490: BEGIN
491: x_no_data_found := TRUE;
492: -- Get current database values
493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
494: p_chr_id,
495: p_parameter_type_code);
496: FETCH okl_k_rate_params_v_u1_csr INTO
497: x_krpv_rec.khr_id,

Line 496: FETCH okl_k_rate_params_v_u1_csr INTO

492: -- Get current database values
493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
494: p_chr_id,
495: p_parameter_type_code);
496: FETCH okl_k_rate_params_v_u1_csr INTO
497: x_krpv_rec.khr_id,
498: x_krpv_rec.parameter_type_code,
499: x_krpv_rec.effective_from_date,
500: x_krpv_rec.effective_to_date,

Line 545: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;

541: x_krpv_rec.creation_date,
542: x_krpv_rec.last_updated_by,
543: x_krpv_rec.last_update_date,
544: x_krpv_rec.last_update_login;
545: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
546: CLOSE okl_k_rate_params_v_u1_csr;
547: --RETURN(x_krpv_rec);
548:
549: END;

Line 546: CLOSE okl_k_rate_params_v_u1_csr;

542: x_krpv_rec.last_updated_by,
543: x_krpv_rec.last_update_date,
544: x_krpv_rec.last_update_login;
545: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
546: CLOSE okl_k_rate_params_v_u1_csr;
547: --RETURN(x_krpv_rec);
548:
549: END;
550: