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_K_RATE_PARAMS_PVT dependencies on OKL_SETUPPRODUCTS_PUB

Line 276: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)

272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_khr_id IN okc_k_headers_b.id%type,
276: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)
277: IS
278:
279: l_api_name CONSTANT VARCHAR2(30) := 'get_product';
280: l_api_version CONSTANT NUMBER := 1.0;

Line 282: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

278:
279: l_api_name CONSTANT VARCHAR2(30) := 'get_product';
280: l_api_version CONSTANT NUMBER := 1.0;
281:
282: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
283: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
284: x_no_data_found BOOLEAN;
285:
286: CURSOR l_hdr_csr( chrId NUMBER ) IS

Line 283: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

279: l_api_name CONSTANT VARCHAR2(30) := 'get_product';
280: l_api_version CONSTANT NUMBER := 1.0;
281:
282: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
283: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
284: x_no_data_found BOOLEAN;
285:
286: CURSOR l_hdr_csr( chrId NUMBER ) IS
287: SELECT

Line 319: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

315: END IF;
316:
317: p_pdtv_rec.id := l_hdr_rec.pid;
318:
319: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
320: p_api_version => p_api_version,
321: p_init_msg_list => p_init_msg_list,
322: x_return_status => x_return_status,
323: x_msg_count => x_msg_count,

Line 355: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)

351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_khr_id IN okc_k_headers_b.id%type,
354: x_product_id OUT NOCOPY NUMBER,
355: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)
356: IS
357:
358: l_api_name CONSTANT VARCHAR2(30) := 'get_product2';
359: l_api_version CONSTANT NUMBER := 1.0;

Line 361: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

357:
358: l_api_name CONSTANT VARCHAR2(30) := 'get_product2';
359: l_api_version CONSTANT NUMBER := 1.0;
360:
361: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
362: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
363: x_no_data_found BOOLEAN;
364:
365: CURSOR l_hdr_csr( chrId NUMBER ) IS

Line 362: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

358: l_api_name CONSTANT VARCHAR2(30) := 'get_product2';
359: l_api_version CONSTANT NUMBER := 1.0;
360:
361: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
362: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
363: x_no_data_found BOOLEAN;
364:
365: CURSOR l_hdr_csr( chrId NUMBER ) IS
366: SELECT

Line 399: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

395:
396: p_pdtv_rec.id := l_hdr_rec.pid;
397: x_product_id := l_hdr_rec.pid;
398:
399: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
400: p_api_version => p_api_version,
401: p_init_msg_list => p_init_msg_list,
402: x_return_status => x_return_status,
403: x_msg_count => x_msg_count,

Line 582: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

578: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
579: l_orig_rate_rec krpv_rec_type;
580: l_no_data BOOLEAN;
581: l_rebook_date DATE;
582: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
583: l_deal_type VARCHAR2(30);
584: l_interest_calculation_basis VARCHAR2(30);
585: l_revenue_recognition_method VARCHAR2(30);
586: l_last_interest_calc_date DATE;

Line 965: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

961: --x_krpv_rec krpv_rec_type;
962: l_count NUMBER;
963: l_rate_count NUMBER;
964: l_k_rate_tbl krpv_tbl_type;
965: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
966: l_product_id NUMBER;
967: l_contract_start_date DATE;
968:
969: --Bug# 7566308

Line 1767: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

1763: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1764: l_orig_rate_rec krpv_rec_type;
1765: l_no_data BOOLEAN;
1766: l_rebook_date DATE;
1767: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
1768: l_deal_type VARCHAR2(30);
1769: l_interest_calculation_basis VARCHAR2(30);
1770: l_revenue_recognition_method VARCHAR2(30);
1771: l_last_interest_calc_date DATE;

Line 2754: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

2750:
2751: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_RATE_PARAMS';
2752: l_api_version CONSTANT NUMBER := 1.0;
2753:
2754: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
2755: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2756: x_no_data_found BOOLEAN;
2757: l_k_rate_tbl krpv_tbl_type;
2758: l_k_rate_tbl2 krpv_tbl_type;

Line 2755: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

2751: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_RATE_PARAMS';
2752: l_api_version CONSTANT NUMBER := 1.0;
2753:
2754: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
2755: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2756: x_no_data_found BOOLEAN;
2757: l_k_rate_tbl krpv_tbl_type;
2758: l_k_rate_tbl2 krpv_tbl_type;
2759: l_rate_counter NUMBER := 1;

Line 2862: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

2858: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'pid=' || l_hdr_rec.pid);
2859: END IF;
2860:
2861: p_pdtv_rec.id := l_hdr_rec.pid;
2862: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
2863: p_api_version => p_api_version,
2864: p_init_msg_list => p_init_msg_list,
2865: x_return_status => x_return_status,
2866: x_msg_count => x_msg_count,

Line 3070: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

3066: p_k_rate_tbl IN krpv_tbl_type,
3067: --Bug# 7440232
3068: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
3069:
3070: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
3071: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3072: x_no_data_found BOOLEAN;
3073:
3074: l_pdt_id number;

Line 3071: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

3067: --Bug# 7440232
3068: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
3069:
3070: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
3071: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3072: x_no_data_found BOOLEAN;
3073:
3074: l_pdt_id number;
3075: begin

Line 3092: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

3088: p_pdtv_rec.id := p_product_id;
3089: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3090: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_product_id=' || to_char(p_product_id));
3091: END IF;
3092: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
3093: p_api_version => p_api_version,
3094: p_init_msg_list => p_init_msg_list,
3095: x_return_status => x_return_status,
3096: x_msg_count => x_msg_count,

Line 3485: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

3481: l_api_version number := 1;
3482: l_no_data_found BOOLEAN:= FALSE;
3483: l_krpv_rec krpv_rec_type;
3484: x_krpv_rec krpv_rec_type;
3485: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3486: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3487: l_interest_processing_started BOOLEAN;
3488: l_product_id NUMBER;
3489: l_contract_start_date DATE;

Line 3717: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

3713:
3714: l_last_accrued_due_date DATE;
3715: l_last_billed_due_date DATE;
3716:
3717: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3718:
3719: -- Get the quality descriptions
3720: CURSOR get_prod_param_values(cp_name OKL_PDT_QUALITYS.NAME%TYPE
3721: , cp_value OKL_PQY_VALUES.VALUE%TYPE) IS

Line 4946: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

4942:
4943: -- Bug 4999888
4944: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
4945: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
4946: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
4947:
4948: --Cursor to query the last billed due date of the stream.
4949: CURSOR get_last_billed_due_date(
4950: p_chr_id OKC_K_HEADERS_B.ID%TYPE