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 423: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,

419: p_effective_from_date IN DATE,
420: x_krpv_rec OUT NOCOPY krpv_rec_type,
421: x_no_data_found OUT NOCOPY BOOLEAN
422: ) IS
423: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,
424: p_khr_id IN NUMBER,
425: p_parameter_type_code IN VARCHAR2) IS
426: SELECT
427: KHR_ID,

Line 475: FROM Okl_K_Rate_Params_V

471: CREATION_DATE,
472: LAST_UPDATED_BY,
473: LAST_UPDATE_DATE,
474: LAST_UPDATE_LOGIN
475: FROM Okl_K_Rate_Params_V
476: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
477: AND khr_id = p_khr_id
478: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

Line 479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

475: FROM Okl_K_Rate_Params_V
476: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
477: AND khr_id = p_khr_id
478: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
480: BEGIN
481: x_no_data_found := TRUE;
482: -- Get current database values
483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

Line 483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
480: BEGIN
481: x_no_data_found := TRUE;
482: -- Get current database values
483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
484: p_chr_id,
485: p_parameter_type_code);
486: FETCH okl_k_rate_params_v_u1_csr INTO
487: x_krpv_rec.khr_id,

Line 486: FETCH okl_k_rate_params_v_u1_csr INTO

482: -- Get current database values
483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
484: p_chr_id,
485: p_parameter_type_code);
486: FETCH okl_k_rate_params_v_u1_csr INTO
487: x_krpv_rec.khr_id,
488: x_krpv_rec.parameter_type_code,
489: x_krpv_rec.effective_from_date,
490: x_krpv_rec.effective_to_date,

Line 535: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;

531: x_krpv_rec.creation_date,
532: x_krpv_rec.last_updated_by,
533: x_krpv_rec.last_update_date,
534: x_krpv_rec.last_update_login;
535: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
536: CLOSE okl_k_rate_params_v_u1_csr;
537: --RETURN(x_krpv_rec);
538:
539: END;

Line 536: CLOSE okl_k_rate_params_v_u1_csr;

532: x_krpv_rec.last_updated_by,
533: x_krpv_rec.last_update_date,
534: x_krpv_rec.last_update_login;
535: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
536: CLOSE okl_k_rate_params_v_u1_csr;
537: --RETURN(x_krpv_rec);
538:
539: END;
540: