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 121: l_orig_system_id1 okc_k_headers_b.orig_system_id1%type;

117: x_contract_start_date OUT NOCOPY DATE )
118: RETURN BOOLEAN IS
119: l_interest_date DATE;
120: l_billable_stream_exists VARCHAR2(1) := 'N';
121: l_orig_system_id1 okc_k_headers_b.orig_system_id1%type;
122: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
123: BEGIN
124: SELECT A.DATE_LAST_INTERIM_INTEREST_CAL,
125: B.CONTRACT_NUMBER,

Line 122: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

118: RETURN BOOLEAN IS
119: l_interest_date DATE;
120: l_billable_stream_exists VARCHAR2(1) := 'N';
121: l_orig_system_id1 okc_k_headers_b.orig_system_id1%type;
122: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
123: BEGIN
124: SELECT A.DATE_LAST_INTERIM_INTEREST_CAL,
125: B.CONTRACT_NUMBER,
126: B.START_DATE,

Line 135: OKC_K_HEADERS_B B

131: x_contract_start_date,
132: l_orig_system_id1,
133: l_orig_system_source_code
134: FROM OKL_K_HEADERS A,
135: OKC_K_HEADERS_B B
136: WHERE A.ID = p_chr_id
137: AND A.ID = B.ID;
138: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
139: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_interest_date=' ||l_interest_date);

Line 211: From okc_k_headers_b chr

207:
208: FUNCTION Is_Rebook_Copy (p_chr_id IN NUMBER) return BOOLEAN IS
209: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
210: Select orig_system_source_code
211: From okc_k_headers_b chr
212: --where chr.orig_system_source_code = 'OKL_REBOOK'
213: where chr.id = p_chr_id;
214:
215: l_rbk_cpy BOOLEAN := FALSE;

Line 216: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

212: --where chr.orig_system_source_code = 'OKL_REBOOK'
213: where chr.id = p_chr_id;
214:
215: l_rbk_cpy BOOLEAN := FALSE;
216: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
217: Begin
218: Open Rbk_Cpy_Csr(p_chr_id => p_chr_id);
219: Fetch Rbk_Cpy_Csr into l_orig_system_source_code;
220: Close Rbk_Cpy_Csr;

Line 235: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
236: x_effective_from_date OUT NOCOPY DATE,
237: x_no_data_found OUT NOCOPY BOOLEAN) IS
238: CURSOR effective_from_date_csr(p_id NUMBER) IS
239: SELECT MAX(EFFECTIVE_FROM_DATE)

Line 265: p_khr_id IN okc_k_headers_b.id%type,

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

Line 283: FROM okc_k_headers_b CHR,

279: CHR.inv_organization_id,
280: khr.deal_type,
281: pdt.id pid,
282: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
283: FROM okc_k_headers_b CHR,
284: okl_k_headers khr,
285: okl_products_v pdt
286: WHERE khr.id = CHR.id
287: AND CHR.id = chrId

Line 343: p_khr_id IN okc_k_headers_b.id%type,

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

Line 362: FROM okc_k_headers_b CHR,

358: CHR.inv_organization_id,
359: khr.deal_type,
360: pdt.id pid,
361: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
362: FROM okc_k_headers_b CHR,
363: okl_k_headers khr,
364: okl_products_v pdt
365: WHERE khr.id = CHR.id
366: AND CHR.id = chrId

Line 568: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

564: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_RATE_PARAMS_RBK';
565: l_api_version CONSTANT NUMBER := 1.0;
566: l_count NUMBER;
567: l_interest_processing_started BOOLEAN := FALSE;
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;

Line 937: FROM OKC_K_HEADERS_B

933: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
934:
935: CURSOR C1(p_id NUMBER) IS
936: SELECT start_date
937: FROM OKC_K_HEADERS_B
938: WHERE ID = p_id;
939:
940: CURSOR C2(p_id NUMBER, p_parameter_type_code VARCHAR2) IS
941: SELECT COUNT(1) COUNT1

Line 976: OKC_K_HEADERS_B contract,

972: contract.orig_system_source_code,
973: lease.date_last_interim_interest_cal,
974: contract.orig_system_id1
975: FROM OKL_K_RATE_PARAMS rate,
976: OKC_K_HEADERS_B contract,
977: OKL_K_HEADERS lease
978: WHERE rate.khr_id = p_khr_id
979: AND rate.parameter_type_code = p_parameter_type_code
980: AND rate.effective_to_date is null

Line 986: p_chr_id OKC_K_HEADERS_B.ID%TYPE

982: AND contract.id = lease.id;
983:
984: --Cursor to query the last billed due date of the stream.
985: CURSOR get_last_billed_due_date(
986: p_chr_id OKC_K_HEADERS_B.ID%TYPE
987: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
988: SELECT MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
989: FROM OKL_STRM_ELEMENTS STE
990: , OKL_STREAMS STM

Line 993: , OKC_K_HEADERS_B CHR

989: FROM OKL_STRM_ELEMENTS STE
990: , OKL_STREAMS STM
991: , OKL_STRM_TYPE_V STY
992: , OKL_K_HEADERS KHR
993: , OKC_K_HEADERS_B CHR
994: WHERE STM.ID = STE.STM_ID
995: AND STY.ID = STM.STY_ID
996: AND KHR.ID = STM.KHR_ID
997: AND CHR.ID = KHR.ID

Line 1753: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1749: --x_krpv_rec krpv_rec_type;
1750: l_count NUMBER;
1751: l_rebook_copy BOOLEAN := FALSE;
1752: l_interest_processing_started BOOLEAN := FALSE;
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;

Line 2371: OKC_K_HEADERS_B contract

2367: contract.sts_code,
2368: contract.orig_system_source_code,
2369: contract.orig_system_id1
2370: FROM OKL_K_RATE_PARAMS rate,
2371: OKC_K_HEADERS_B contract
2372: WHERE rate.khr_id = p_khr_id
2373: AND rate.parameter_type_code = p_parameter_type_code
2374: AND rate.effective_from_date = p_effective_from_date
2375: AND rate.khr_id = contract.id;

Line 2389: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

2385:
2386: l_all_rate_params_null BOOLEAN;
2387: l_parameter_type_code VARCHAR2(30);
2388: l_effective_to_date DATE;
2389: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
2390: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2391: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
2392: l_orig_effective_from_date DATE;
2393: l_del_count NUMBER := 0; -- Bug 4874280

Line 2390: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

2386: l_all_rate_params_null BOOLEAN;
2387: l_parameter_type_code VARCHAR2(30);
2388: l_effective_to_date DATE;
2389: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
2390: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2391: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
2392: l_orig_effective_from_date DATE;
2393: l_del_count NUMBER := 0; -- Bug 4874280
2394: l_khr_id NUMBER;

Line 2391: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;

2387: l_parameter_type_code VARCHAR2(30);
2388: l_effective_to_date DATE;
2389: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
2390: l_orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2391: l_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
2392: l_orig_effective_from_date DATE;
2393: l_del_count NUMBER := 0; -- Bug 4874280
2394: l_khr_id NUMBER;
2395: begin

Line 2738: p_khr_id IN okc_k_headers_b.id%type,

2734: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2735: x_return_status OUT NOCOPY VARCHAR2,
2736: x_msg_count OUT NOCOPY NUMBER,
2737: x_msg_data OUT NOCOPY VARCHAR2,
2738: p_khr_id IN okc_k_headers_b.id%type,
2739: p_validate_flag IN VARCHAR2 DEFAULT 'Y') IS
2740:
2741: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_RATE_PARAMS';
2742: l_api_version CONSTANT NUMBER := 1.0;

Line 2758: FROM okc_k_headers_b CHR,

2754: CHR.inv_organization_id,
2755: khr.deal_type,
2756: pdt.id pid,
2757: NVL(pdt.reporting_pdt_id, -1) report_pdt_id
2758: FROM okc_k_headers_b CHR,
2759: okl_k_headers khr,
2760: okl_products_v pdt
2761: WHERE khr.id = CHR.id
2762: AND CHR.id = chrId

Line 3467: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3463: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3464: x_return_status OUT NOCOPY VARCHAR2,
3465: x_msg_count OUT NOCOPY NUMBER,
3466: x_msg_data OUT NOCOPY VARCHAR2,
3467: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3468: p_new_start_date IN DATE) IS
3469: l_effective_from_date DATE;
3470: l_api_name varchar2(30) := 'cascade_cntrct_start_date';
3471: l_api_version number := 1;

Line 3476: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

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

Line 3688: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3684: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3685: x_return_status OUT NOCOPY VARCHAR2,
3686: x_msg_count OUT NOCOPY NUMBER,
3687: x_msg_data OUT NOCOPY VARCHAR2,
3688: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3689: p_rebook_date IN DATE) IS
3690:
3691: l_api_name VARCHAR2(30) := 'check_rebook_allowed';
3692: l_api_version NUMBER := 1;

Line 3694: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

3690:
3691: l_api_name VARCHAR2(30) := 'check_rebook_allowed';
3692: l_api_version NUMBER := 1;
3693:
3694: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3695: l_book_class OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE%TYPE;
3696: l_book_class_meaning OKL_PRODUCT_PARAMETERS_V.DEAL_TYPE_MEANING%TYPE;
3697: l_interest_calc_basis OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_BASIS%TYPE;
3698: l_interest_calc_meaning OKL_PRODUCT_PARAMETERS_V.INTEREST_CALCULATION_MEANING%TYPE;

Line 3743: , OKC_K_HEADERS_B CHR

3739: CHR.CONTRACT_NUMBER
3740: , KHR.DATE_LAST_INTERIM_INTEREST_CAL INTEREST_PROCESSED_FLAG
3741: FROM
3742: OKL_K_HEADERS KHR
3743: , OKC_K_HEADERS_B CHR
3744: WHERE
3745: CHR.ID = KHR.ID
3746: AND KHR.ID = cp_chr_id;
3747:

Line 3750: p_chr_id OKC_K_HEADERS_B.ID%TYPE

3746: AND KHR.ID = cp_chr_id;
3747:
3748: --Cursor to query the last accrued due date of the stream.
3749: CURSOR get_last_accrued_due_date(
3750: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3751: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3752: SELECT
3753: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3754: , STY.STYB_PURPOSE_MEANING

Line 3760: , OKC_K_HEADERS_B CHR

3756: OKL_STRM_ELEMENTS STE
3757: , OKL_STREAMS STM
3758: , OKL_STRM_TYPE_V STY
3759: , OKL_K_HEADERS KHR
3760: , OKC_K_HEADERS_B CHR
3761: WHERE
3762: STM.ID = STE.STM_ID
3763: AND STY.ID = STM.STY_ID
3764: AND KHR.ID = STM.KHR_ID

Line 3773: p_chr_id OKC_K_HEADERS_B.ID%TYPE

3769: GROUP BY STY.STREAM_TYPE_PURPOSE;
3770:
3771: --Cursor to query the last billed due date of the stream.
3772: CURSOR get_last_billed_due_date(
3773: p_chr_id OKC_K_HEADERS_B.ID%TYPE
3774: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
3775: SELECT
3776: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
3777: , STY.STYB_PURPOSE_MEANING

Line 3783: , OKC_K_HEADERS_B CHR

3779: OKL_STRM_ELEMENTS STE
3780: , OKL_STREAMS STM
3781: , OKL_STRM_TYPE_V STY
3782: , OKL_K_HEADERS KHR
3783: , OKC_K_HEADERS_B CHR
3784: WHERE
3785: STM.ID = STE.STM_ID
3786: AND STY.ID = STM.STY_ID
3787: AND KHR.ID = STM.KHR_ID

Line 4707: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

4703: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4704: x_return_status OUT NOCOPY VARCHAR2,
4705: x_msg_count OUT NOCOPY NUMBER,
4706: x_msg_data OUT NOCOPY VARCHAR2,
4707: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4708: x_principal_payment_defined OUT NOCOPY BOOLEAN) IS
4709:
4710: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
4711: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

Line 4838: OKC_K_HEADERS_B contract,

4834: contract.orig_system_source_code,
4835: lease.date_last_interim_interest_cal,
4836: contract.orig_system_id1
4837: FROM OKL_K_RATE_PARAMS rate,
4838: OKC_K_HEADERS_B contract,
4839: OKL_K_HEADERS lease
4840: WHERE rate.khr_id = p_khr_id
4841: AND rate.parameter_type_code = p_parameter_type_code
4842: AND rate.effective_to_date is null

Line 4853: p_chr_id OKC_K_HEADERS_B.ID%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
4854: , p_stream_purpose OKL_STRM_TYPE_V.STREAM_TYPE_PURPOSE%TYPE) IS
4855: SELECT
4856: MAX(STE.STREAM_ELEMENT_DATE) LAST_STREAM_DUE_DATE
4857: --, STY.STYB_PURPOSE_MEANING

Line 4863: , OKC_K_HEADERS_B CHR

4859: OKL_STRM_ELEMENTS STE
4860: , OKL_STREAMS STM
4861: , OKL_STRM_TYPE_V STY
4862: , OKL_K_HEADERS KHR
4863: , OKC_K_HEADERS_B CHR
4864: WHERE
4865: STM.ID = STE.STM_ID
4866: AND STY.ID = STM.STY_ID
4867: AND KHR.ID = STM.KHR_ID