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 378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

374:
375: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
376: ,p_date IN DATE) RETURN VARCHAR2 IS
377:
378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
379: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
380: SELECT pdt.quality_val revenue_recognition_method
381: FROM OKL_PROD_QLTY_VAL_UV pdt,
382: OKL_K_HEADERS_FULL_V khr

Line 474: l_rev_rec_method OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;

470: AND txl.sty_id = sty.id
471: AND sty.stream_type_purpose = 'ACTUAL_INCOME_ACCRUAL';
472:
473: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
474: l_rev_rec_method OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
475: l_accrual_status VARCHAR2(1);
476: x_result VARCHAR2(1);
477: -- Bug 5036337.Commenting below as no longer needed.
478: -- l_formula_name CONSTANT VARCHAR2(30) := 'CONTRACT_ACTUAL_INCOME_ACCRUAL';

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

10007: l_data_found BOOLEAN := FALSE;
10008: l_num_workers NUMBER;
10009: l_worker_id VARCHAR2(2000);
10010:
10011: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10012: CURSOR chk_update_header_csr is
10013: SELECT chr.contract_number
10014: FROM OKC_K_HEADERS_B chr,
10015: OKL_K_HEADERS khr,

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

10086:
10087: -- -- Cursor to select contracts for accrual processing
10088: -- -- modified cursor to select only lease contracts
10089: -- -- bug#2618966
10090: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10091: CURSOR accrual_contract_csr IS
10092: SELECT chr.id
10093: ,chr.contract_number
10094: ,chr.start_date

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

11047: l_accrual_date DATE;
11048: l_process_accrual_rec process_accrual_rec_type;
11049: l_rev_rec_method VARCHAR2(2000);
11050:
11051: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
11052: CURSOR accrual_contract_csr (p_khr_id NUMBER) IS
11053: SELECT chr.contract_number
11054: ,chr.start_date
11055: ,chr.sts_code