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 OKC_K_HEADERS_B

Line 131: l_orig_system_id1 okc_k_headers_b.orig_system_id1%type;

127: x_contract_start_date OUT NOCOPY DATE )
128: RETURN BOOLEAN IS
129: l_interest_date DATE;
130: l_billable_stream_exists VARCHAR2(1) := 'N';
131: l_orig_system_id1 okc_k_headers_b.orig_system_id1%type;
132: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
133: BEGIN
134: SELECT A.DATE_LAST_INTERIM_INTEREST_CAL,
135: B.CONTRACT_NUMBER,

Line 132: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

128: RETURN BOOLEAN IS
129: l_interest_date DATE;
130: l_billable_stream_exists VARCHAR2(1) := 'N';
131: l_orig_system_id1 okc_k_headers_b.orig_system_id1%type;
132: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
133: BEGIN
134: SELECT A.DATE_LAST_INTERIM_INTEREST_CAL,
135: B.CONTRACT_NUMBER,
136: B.START_DATE,

Line 145: OKC_K_HEADERS_B B

141: x_contract_start_date,
142: l_orig_system_id1,
143: l_orig_system_source_code
144: FROM OKL_K_HEADERS A,
145: OKC_K_HEADERS_B B
146: WHERE A.ID = p_chr_id
147: AND A.ID = B.ID;
148: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
149: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_interest_date=' ||l_interest_date);

Line 221: From okc_k_headers_b chr

217:
218: FUNCTION Is_Rebook_Copy (p_chr_id IN NUMBER) return BOOLEAN IS
219: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
220: Select orig_system_source_code
221: From okc_k_headers_b chr
222: --where chr.orig_system_source_code = 'OKL_REBOOK'
223: where chr.id = p_chr_id;
224:
225: l_rbk_cpy BOOLEAN := FALSE;

Line 226: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

222: --where chr.orig_system_source_code = 'OKL_REBOOK'
223: where chr.id = p_chr_id;
224:
225: l_rbk_cpy BOOLEAN := FALSE;
226: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
227: Begin
228: Open Rbk_Cpy_Csr(p_chr_id => p_chr_id);
229: Fetch Rbk_Cpy_Csr into l_orig_system_source_code;
230: Close Rbk_Cpy_Csr;

Line 245: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
246: x_effective_from_date OUT NOCOPY DATE,
247: x_no_data_found OUT NOCOPY BOOLEAN) IS
248: CURSOR effective_from_date_csr(p_id NUMBER) IS
249: SELECT MAX(EFFECTIVE_FROM_DATE)

Line 275: p_khr_id IN okc_k_headers_b.id%type,

271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
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';

Line 293: FROM okc_k_headers_b CHR,

289: CHR.inv_organization_id,
290: khr.deal_type,
291: pdt.id pid,
292: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
293: FROM okc_k_headers_b CHR,
294: okl_k_headers khr,
295: okl_products_v pdt
296: WHERE khr.id = CHR.id
297: AND CHR.id = chrId

Line 353: p_khr_id IN okc_k_headers_b.id%type,

349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
350: x_return_status OUT NOCOPY VARCHAR2,
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:

Line 372: FROM okc_k_headers_b CHR,

368: CHR.inv_organization_id,
369: khr.deal_type,
370: pdt.id pid,
371: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
372: FROM okc_k_headers_b CHR,
373: okl_k_headers khr,
374: okl_products_v pdt
375: WHERE khr.id = CHR.id
376: AND CHR.id = chrId

Line 578: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

574: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RATE_PARAMS_RBK';
575: l_api_version CONSTANT NUMBER := 1.0;
576: l_count NUMBER;
577: l_interest_processing_started BOOLEAN := FALSE;
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;

Line 947: FROM OKC_K_HEADERS_B

943: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
944:
945: CURSOR C1(p_id NUMBER) IS
946: SELECT start_date
947: FROM OKC_K_HEADERS_B
948: WHERE ID = p_id;
949:
950: CURSOR C2(p_id NUMBER, p_parameter_type_code VARCHAR2) IS
951: SELECT COUNT(1) COUNT1

Line 986: OKC_K_HEADERS_B contract,

982: contract.orig_system_source_code,
983: lease.date_last_interim_interest_cal,
984: contract.orig_system_id1
985: FROM OKL_K_RATE_PARAMS rate,
986: OKC_K_HEADERS_B contract,
987: OKL_K_HEADERS lease
988: WHERE rate.khr_id = p_khr_id
989: AND rate.parameter_type_code = p_parameter_type_code
990: AND rate.effective_to_date is null

Line 996: p_chr_id OKC_K_HEADERS_B.ID%TYPE

992: AND contract.id = lease.id;
993:
994: --Cursor to query the last billed due date of the stream.
995: CURSOR get_last_billed_due_date(
996: p_chr_id OKC_K_HEADERS_B.ID%TYPE
997: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
998: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
999: FROM OKL_STRM_ELEMENTS STE
1000: , OKL_STREAMS STM

Line 1003: , OKC_K_HEADERS_B CHR

999: FROM OKL_STRM_ELEMENTS STE
1000: , OKL_STREAMS STM
1001: , OKL_STRM_TYPE_V STY
1002: , OKL_K_HEADERS KHR
1003: , OKC_K_HEADERS_B CHR
1004: WHERE STM.ID = STE.STM_ID
1005: AND STY.ID = STM.STY_ID
1006: AND KHR.ID = STM.KHR_ID
1007: AND CHR.ID = KHR.ID

Line 1763: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1759: --x_krpv_rec krpv_rec_type;
1760: l_count NUMBER;
1761: l_rebook_copy BOOLEAN := FALSE;
1762: l_interest_processing_started BOOLEAN := FALSE;
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;

Line 2381: OKC_K_HEADERS_B contract

2377: contract.sts_code,
2378: contract.orig_system_source_code,
2379: contract.orig_system_id1
2380: FROM OKL_K_RATE_PARAMS rate,
2381: OKC_K_HEADERS_B contract
2382: WHERE rate.khr_id = p_khr_id
2383: AND rate.parameter_type_code = p_parameter_type_code
2384: AND rate.effective_from_date = p_effective_from_date
2385: AND rate.khr_id = contract.id;

Line 2399: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

2395:
2396: l_all_rate_params_null BOOLEAN;
2397: l_parameter_type_code VARCHAR2(30);
2398: l_effective_to_date DATE;
2399: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
2400: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2401: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
2402: l_orig_effective_from_date DATE;
2403: l_del_count NUMBER := 0; -- Bug 4874280

Line 2400: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

2396: l_all_rate_params_null BOOLEAN;
2397: l_parameter_type_code VARCHAR2(30);
2398: l_effective_to_date DATE;
2399: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
2400: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2401: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
2402: l_orig_effective_from_date DATE;
2403: l_del_count NUMBER := 0; -- Bug 4874280
2404: l_khr_id NUMBER;

Line 2401: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

2397: l_parameter_type_code VARCHAR2(30);
2398: l_effective_to_date DATE;
2399: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
2400: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2401: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
2402: l_orig_effective_from_date DATE;
2403: l_del_count NUMBER := 0; -- Bug 4874280
2404: l_khr_id NUMBER;
2405: begin

Line 2748: p_khr_id IN okc_k_headers_b.id%type,

2744: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2745: x_return_status OUT NOCOPY VARCHAR2,
2746: x_msg_count OUT NOCOPY NUMBER,
2747: x_msg_data OUT NOCOPY VARCHAR2,
2748: p_khr_id IN okc_k_headers_b.id%type,
2749: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
2750:
2751: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_RATE_PARAMS';
2752: l_api_version CONSTANT NUMBER := 1.0;

Line 2768: FROM okc_k_headers_b CHR,

2764: CHR.inv_organization_id,
2765: khr.deal_type,
2766: pdt.id pid,
2767: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2768: FROM okc_k_headers_b CHR,
2769: okl_k_headers khr,
2770: okl_products_v pdt
2771: WHERE khr.id = CHR.id
2772: AND CHR.id = chrId

Line 3477: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3473: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3474: x_return_status OUT NOCOPY VARCHAR2,
3475: x_msg_count OUT NOCOPY NUMBER,
3476: x_msg_data OUT NOCOPY VARCHAR2,
3477: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3478: p_new_start_date IN DATE) IS
3479: l_effective_from_date DATE;
3480: l_api_name varchar2(30) := 'cascade_cntrct_start_date';
3481: l_api_version number := 1;

Line 3486: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

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;
3490:

Line 3698: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3695: x_return_status OUT NOCOPY VARCHAR2,
3696: x_msg_count OUT NOCOPY NUMBER,
3697: x_msg_data OUT NOCOPY VARCHAR2,
3698: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3699: p_rebook_date IN DATE) IS
3700:
3701: l_api_name VARCHAR2(30) := 'check_rebook_allowed';
3702: l_api_version NUMBER := 1;

Line 3704: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

3700:
3701: l_api_name VARCHAR2(30) := 'check_rebook_allowed';
3702: l_api_version NUMBER := 1;
3703:
3704: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3705: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3706: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3707: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3708: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;

Line 3753: , OKC_K_HEADERS_B CHR

3749: CHR.CONTRACT_NUMBER
3750: , KHR.DATE_LAST_INTERIM_INTEREST_CAL INTEREST_PROCESSED_FLAG
3751: FROM
3752: OKL_K_HEADERS KHR
3753: , OKC_K_HEADERS_B CHR
3754: WHERE
3755: CHR.ID = KHR.ID
3756: AND KHR.ID = cp_chr_id;
3757:

Line 3761: p_chr_id OKC_K_HEADERS_B.ID%TYPE

3757:
3758: --Cursor to query the last accrued due date of the stream.
3759: --Bug# 9058664: Corrected GROUP BY clause
3760: CURSOR get_last_accrued_due_date(
3761: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3762: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3763: SELECT
3764: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3765: , STY.STYB_PURPOSE_MEANING

Line 3771: , OKC_K_HEADERS_B CHR

3767: OKL_STRM_ELEMENTS STE
3768: , OKL_STREAMS STM
3769: , OKL_STRM_TYPE_V STY
3770: , OKL_K_HEADERS KHR
3771: , OKC_K_HEADERS_B CHR
3772: WHERE
3773: STM.ID = STE.STM_ID
3774: AND STY.ID = STM.STY_ID
3775: AND KHR.ID = STM.KHR_ID

Line 3785: p_chr_id OKC_K_HEADERS_B.ID%TYPE

3781:
3782: --Cursor to query the last billed due date of the stream.
3783: --Bug# 9058664: Corrected GROUP BY clause
3784: CURSOR get_last_billed_due_date(
3785: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3786: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3787: SELECT
3788: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3789: , STY.STYB_PURPOSE_MEANING

Line 3795: , OKC_K_HEADERS_B CHR

3791: OKL_STRM_ELEMENTS STE
3792: , OKL_STREAMS STM
3793: , OKL_STRM_TYPE_V STY
3794: , OKL_K_HEADERS KHR
3795: , OKC_K_HEADERS_B CHR
3796: WHERE
3797: STM.ID = STE.STM_ID
3798: AND STY.ID = STM.STY_ID
3799: AND KHR.ID = STM.KHR_ID

Line 4804: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

4800: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4801: x_return_status OUT NOCOPY VARCHAR2,
4802: x_msg_count OUT NOCOPY NUMBER,
4803: x_msg_data OUT NOCOPY VARCHAR2,
4804: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4805: x_principal_payment_defined OUT NOCOPY BOOLEAN) IS
4806:
4807: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
4808: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

Line 4935: OKC_K_HEADERS_B contract,

4931: contract.orig_system_source_code,
4932: lease.date_last_interim_interest_cal,
4933: contract.orig_system_id1
4934: FROM OKL_K_RATE_PARAMS rate,
4935: OKC_K_HEADERS_B contract,
4936: OKL_K_HEADERS lease
4937: WHERE rate.khr_id = p_khr_id
4938: AND rate.parameter_type_code = p_parameter_type_code
4939: AND rate.effective_to_date is null

Line 4950: p_chr_id OKC_K_HEADERS_B.ID%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
4951: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
4952: SELECT
4953: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
4954: --, STY.STYB_PURPOSE_MEANING

Line 4960: , OKC_K_HEADERS_B CHR

4956: OKL_STRM_ELEMENTS STE
4957: , OKL_STREAMS STM
4958: , OKL_STRM_TYPE_V STY
4959: , OKL_K_HEADERS KHR
4960: , OKC_K_HEADERS_B CHR
4961: WHERE
4962: STM.ID = STE.STM_ID
4963: AND STY.ID = STM.STY_ID
4964: AND KHR.ID = STM.KHR_ID