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.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 75: rev_rec_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE);

71: period_start_date DATE,
72: source_trx_id OKL_TRX_CONTRACTS.SOURCE_TRX_ID%TYPE,
73: source_trx_type OKL_TRX_CONTRACTS.SOURCE_TRX_TYPE%TYPE,
74: submission_mode VARCHAR2(2000),
75: rev_rec_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE);
76:
77: --Added by kthiruva on 02-Mar-2006 for logging purposes
78: --Start of Changes
79: PROCEDURE WRITE_TO_LOG(p_message IN VARCHAR2)

Line 331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

327:
328: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
329: ,p_date IN DATE) RETURN VARCHAR2 IS
330:
331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
332: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
333: SELECT pdt.quality_val revenue_recognition_method
334: FROM OKL_PROD_QLTY_VAL_UV pdt,
335: OKL_K_HEADERS_FULL_V khr

Line 427: l_rev_rec_method OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

423: AND txl.sty_id = sty.id
424: AND sty.stream_type_purpose = 'ACTUAL_INCOME_ACCRUAL';
425:
426: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
427: l_rev_rec_method OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
428: l_accrual_status VARCHAR2(1);
429: x_result VARCHAR2(1);
430: -- Bug 5036337.Commenting below as no longer needed.
431: -- l_formula_name CONSTANT VARCHAR2(30) := 'CONTRACT_ACTUAL_INCOME_ACCRUAL';

Line 9015: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

9011: l_data_found BOOLEAN := FALSE;
9012: l_num_workers NUMBER;
9013: l_worker_id VARCHAR2(2000);
9014:
9015: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
9016: CURSOR chk_update_header_csr is
9017: SELECT chr.contract_number
9018: FROM OKC_K_HEADERS_B chr,
9019: OKL_K_HEADERS khr,

Line 9094: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

9090:
9091: -- -- Cursor to select contracts for accrual processing
9092: -- -- modified cursor to select only lease contracts
9093: -- -- bug#2618966
9094: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
9095: CURSOR accrual_contract_csr IS
9096: SELECT chr.id
9097: ,chr.contract_number
9098: ,chr.start_date

Line 10055: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

10051: l_accrual_date DATE;
10052: l_process_accrual_rec process_accrual_rec_type;
10053: l_rev_rec_method VARCHAR2(2000);
10054:
10055: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10056: CURSOR accrual_contract_csr (p_khr_id NUMBER) IS
10057: SELECT chr.contract_number
10058: ,chr.start_date
10059: ,chr.sts_code