APPS.OKL_AMH_PVT dependencies on FA_FLAT_RATES

Line 566: CURSOR fa_flat_rates_csr(p_method_id IN NUMBER, p_deprn_rate IN NUMBER ) IS

562: FROM OKL_AM_ASST_DEP_METHODS_UV
563: WHERE OKL_AM_ASST_DEP_METHODS_UV.id1 = p_id1;
564:
565: -- SECHAWLA 26-MAY-04 3645574 : New cursor
566: CURSOR fa_flat_rates_csr(p_method_id IN NUMBER, p_deprn_rate IN NUMBER ) IS
567: SELECT 'x'
568: FROM fa_flat_rates
569: WHERE method_id = p_method_id
570: AND adjusted_rate = p_deprn_rate/100 -- rate is passed from the screen as a percentage but stored as the actual value

Line 568: FROM fa_flat_rates

564:
565: -- SECHAWLA 26-MAY-04 3645574 : New cursor
566: CURSOR fa_flat_rates_csr(p_method_id IN NUMBER, p_deprn_rate IN NUMBER ) IS
567: SELECT 'x'
568: FROM fa_flat_rates
569: WHERE method_id = p_method_id
570: AND adjusted_rate = p_deprn_rate/100 -- rate is passed from the screen as a percentage but stored as the actual value
571: AND nvl(adjusting_rate,0) = 0 ;
572:

Line 634: OPEN fa_flat_rates_csr(p_amhv_rec.METHOD_ID, p_amhv_rec.deprn_rate );

630: okl_api.SET_MESSAGE(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'METHOD_ID');
631: l_return_status := OKL_API.G_RET_STS_ERROR;
632: ELSE
633:
634: OPEN fa_flat_rates_csr(p_amhv_rec.METHOD_ID, p_amhv_rec.deprn_rate );
635: FETCH fa_flat_rates_csr INTO l_dummy;
636: IF fa_flat_rates_csr%NOTFOUND THEN
637: okl_api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DEPRN_RATE');
638: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 635: FETCH fa_flat_rates_csr INTO l_dummy;

631: l_return_status := OKL_API.G_RET_STS_ERROR;
632: ELSE
633:
634: OPEN fa_flat_rates_csr(p_amhv_rec.METHOD_ID, p_amhv_rec.deprn_rate );
635: FETCH fa_flat_rates_csr INTO l_dummy;
636: IF fa_flat_rates_csr%NOTFOUND THEN
637: okl_api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DEPRN_RATE');
638: l_return_status := OKL_API.G_RET_STS_ERROR;
639: END IF;

Line 636: IF fa_flat_rates_csr%NOTFOUND THEN

632: ELSE
633:
634: OPEN fa_flat_rates_csr(p_amhv_rec.METHOD_ID, p_amhv_rec.deprn_rate );
635: FETCH fa_flat_rates_csr INTO l_dummy;
636: IF fa_flat_rates_csr%NOTFOUND THEN
637: okl_api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DEPRN_RATE');
638: l_return_status := OKL_API.G_RET_STS_ERROR;
639: END IF;
640: CLOSE fa_flat_rates_csr;

Line 640: CLOSE fa_flat_rates_csr;

636: IF fa_flat_rates_csr%NOTFOUND THEN
637: okl_api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'DEPRN_RATE');
638: l_return_status := OKL_API.G_RET_STS_ERROR;
639: END IF;
640: CLOSE fa_flat_rates_csr;
641: END IF;
642: END IF;
643:
644: