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 266: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)

262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_khr_id IN okc_k_headers_b.id%type,
266: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)
267: IS
268:
269: l_api_name CONSTANT VARCHAR2(30) := 'get_product';
270: l_api_version CONSTANT NUMBER := 1.0;

Line 272: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

268:
269: l_api_name CONSTANT VARCHAR2(30) := 'get_product';
270: l_api_version CONSTANT NUMBER := 1.0;
271:
272: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
273: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
274: x_no_data_found BOOLEAN;
275:
276: CURSOR l_hdr_csr( chrId NUMBER ) IS

Line 273: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

269: l_api_name CONSTANT VARCHAR2(30) := 'get_product';
270: l_api_version CONSTANT NUMBER := 1.0;
271:
272: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
273: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
274: x_no_data_found BOOLEAN;
275:
276: CURSOR l_hdr_csr( chrId NUMBER ) IS
277: SELECT

Line 309: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

305: END IF;
306:
307: p_pdtv_rec.id := l_hdr_rec.pid;
308:
309: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
310: p_api_version => p_api_version,
311: p_init_msg_list => p_init_msg_list,
312: x_return_status => x_return_status,
313: x_msg_count => x_msg_count,

Line 345: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)

341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_khr_id IN okc_k_headers_b.id%type,
344: x_product_id OUT NOCOPY NUMBER,
345: x_pdt_parameter_rec OUT NOCOPY OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type)
346: IS
347:
348: l_api_name CONSTANT VARCHAR2(30) := 'get_product2';
349: l_api_version CONSTANT NUMBER := 1.0;

Line 351: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

347:
348: l_api_name CONSTANT VARCHAR2(30) := 'get_product2';
349: l_api_version CONSTANT NUMBER := 1.0;
350:
351: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
352: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
353: x_no_data_found BOOLEAN;
354:
355: CURSOR l_hdr_csr( chrId NUMBER ) IS

Line 352: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

348: l_api_name CONSTANT VARCHAR2(30) := 'get_product2';
349: l_api_version CONSTANT NUMBER := 1.0;
350:
351: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
352: --x_pdt_parameter_rec2 OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
353: x_no_data_found BOOLEAN;
354:
355: CURSOR l_hdr_csr( chrId NUMBER ) IS
356: SELECT

Line 389: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

385:
386: p_pdtv_rec.id := l_hdr_rec.pid;
387: x_product_id := l_hdr_rec.pid;
388:
389: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
390: p_api_version => p_api_version,
391: p_init_msg_list => p_init_msg_list,
392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,

Line 572: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

568: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
569: l_orig_rate_rec krpv_rec_type;
570: l_no_data BOOLEAN;
571: l_rebook_date DATE;
572: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
573: l_deal_type VARCHAR2(30);
574: l_interest_calculation_basis VARCHAR2(30);
575: l_revenue_recognition_method VARCHAR2(30);
576: l_last_interest_calc_date DATE;

Line 955: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

951: --x_krpv_rec krpv_rec_type;
952: l_count NUMBER;
953: l_rate_count NUMBER;
954: l_k_rate_tbl krpv_tbl_type;
955: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
956: l_product_id NUMBER;
957: l_contract_start_date DATE;
958:
959: --Bug# 7566308

Line 1757: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

1753: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1754: l_orig_rate_rec krpv_rec_type;
1755: l_no_data BOOLEAN;
1756: l_rebook_date DATE;
1757: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
1758: l_deal_type VARCHAR2(30);
1759: l_interest_calculation_basis VARCHAR2(30);
1760: l_revenue_recognition_method VARCHAR2(30);
1761: l_last_interest_calc_date DATE;

Line 2744: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

2740:
2741: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_RATE_PARAMS';
2742: l_api_version CONSTANT NUMBER := 1.0;
2743:
2744: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
2745: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2746: x_no_data_found BOOLEAN;
2747: l_k_rate_tbl krpv_tbl_type;
2748: l_k_rate_tbl2 krpv_tbl_type;

Line 2745: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

2741: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_RATE_PARAMS';
2742: l_api_version CONSTANT NUMBER := 1.0;
2743:
2744: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
2745: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2746: x_no_data_found BOOLEAN;
2747: l_k_rate_tbl krpv_tbl_type;
2748: l_k_rate_tbl2 krpv_tbl_type;
2749: l_rate_counter NUMBER := 1;

Line 2852: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

2848: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'pid=' || l_hdr_rec.pid);
2849: END IF;
2850:
2851: p_pdtv_rec.id := l_hdr_rec.pid;
2852: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
2853: p_api_version => p_api_version,
2854: p_init_msg_list => p_init_msg_list,
2855: x_return_status => x_return_status,
2856: x_msg_count => x_msg_count,

Line 3060: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

3056: p_k_rate_tbl IN krpv_tbl_type,
3057: --Bug# 7440232
3058: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
3059:
3060: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
3061: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3062: x_no_data_found BOOLEAN;
3063:
3064: l_pdt_id number;

Line 3061: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

3057: --Bug# 7440232
3058: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
3059:
3060: p_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
3061: x_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3062: x_no_data_found BOOLEAN;
3063:
3064: l_pdt_id number;
3065: begin

Line 3082: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(

3078: p_pdtv_rec.id := p_product_id;
3079: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3080: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_product_id=' || to_char(p_product_id));
3081: END IF;
3082: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters(
3083: p_api_version => p_api_version,
3084: p_init_msg_list => p_init_msg_list,
3085: x_return_status => x_return_status,
3086: x_msg_count => x_msg_count,

Line 3475: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

3471: l_api_version number := 1;
3472: l_no_data_found BOOLEAN:= FALSE;
3473: l_krpv_rec krpv_rec_type;
3474: x_krpv_rec krpv_rec_type;
3475: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3476: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3477: l_interest_processing_started BOOLEAN;
3478: l_product_id NUMBER;
3479: l_contract_start_date DATE;

Line 3707: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

3703:
3704: l_last_accrued_due_date DATE;
3705: l_last_billed_due_date DATE;
3706:
3707: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3708:
3709: -- Get the quality descriptions
3710: CURSOR get_prod_param_values(cp_name OKL_PDT_QUALITYS.NAME%TYPE
3711: , cp_value OKL_PQY_VALUES.VALUE%TYPE) IS

Line 4849: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;

4845:
4846: -- Bug 4999888
4847: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
4848: l_rev_recog_method OKL_PRODUCT_PARAMETERS_V.REVENUE_RECOGNITION_METHOD%TYPE;
4849: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
4850:
4851: --Cursor to query the last billed due date of the stream.
4852: CURSOR get_last_billed_due_date(
4853: p_chr_id OKC_K_HEADERS_B.ID%TYPE