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_LOSS_PROV_PVT dependencies on OKL_K_HEADERS

Line 22: FROM OKL_K_HEADERS

18: ATTRIBUTE12,
19: ATTRIBUTE13,
20: ATTRIBUTE14,
21: ATTRIBUTE15
22: FROM OKL_K_HEADERS
23: WHERE ID = p_khr_id ;
24: -- Bug 5935176 dpsingh for AE signature Uptake end
25: -- this function is used to calculate net book value for a contract
26: FUNCTION calculate_cntrct_nbv (p_cntrct_id IN NUMBER) RETURN NUMBER

Line 363: l_oper_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEOP';

359: FUNCTION calculate_capital_balance(p_cntrct_id IN NUMBER
360: ,p_deal_type IN VARCHAR2) RETURN NUMBER
361: IS
362:
363: l_oper_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEOP';
364: l_df_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEDF';
365: l_sales_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEST';
366: l_loan_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LOAN';
367: l_capital_bal NUMBER := 0;

Line 364: l_df_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEDF';

360: ,p_deal_type IN VARCHAR2) RETURN NUMBER
361: IS
362:
363: l_oper_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEOP';
364: l_df_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEDF';
365: l_sales_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEST';
366: l_loan_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LOAN';
367: l_capital_bal NUMBER := 0;
368: l_original_amt NUMBER := 0;

Line 365: l_sales_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEST';

361: IS
362:
363: l_oper_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEOP';
364: l_df_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEDF';
365: l_sales_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEST';
366: l_loan_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LOAN';
367: l_capital_bal NUMBER := 0;
368: l_original_amt NUMBER := 0;
369: l_converted_amt NUMBER := 0;

Line 366: l_loan_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LOAN';

362:
363: l_oper_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEOP';
364: l_df_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEDF';
365: l_sales_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LEASEST';
366: l_loan_lease CONSTANT OKL_K_HEADERS.DEAL_TYPE%TYPE := 'LOAN';
367: l_capital_bal NUMBER := 0;
368: l_original_amt NUMBER := 0;
369: l_converted_amt NUMBER := 0;
370: l_loss_date DATE := TRUNC(sysdate);

Line 376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

372: l_period_end_date DATE;
373: l_period_name VARCHAR2(2000);
374: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
379: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
380:

Line 377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

373: l_period_name VARCHAR2(2000);
374: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
379: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
380:
381: -- Cursor to select currency information for the contract. Bug 2712001

Line 378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

374: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
379: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
380:
381: -- Cursor to select currency information for the contract. Bug 2712001
382: CURSOR currency_info_csr(p_khr_id NUMBER) IS

Line 379: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

375: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
376: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
377: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
378: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
379: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
380:
381: -- Cursor to select currency information for the contract. Bug 2712001
382: CURSOR currency_info_csr(p_khr_id NUMBER) IS
383: SELECT currency_code

Line 391: OKL_K_HEADERS_FULL_V khr

387: -- cursor to get the rev rec method .. racheruv. Bug 6342556
388: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
389: SELECT pdt.quality_val revenue_recognition_method
390: FROM OKL_PROD_QLTY_VAL_UV pdt,
391: OKL_K_HEADERS_FULL_V khr
392: WHERE khr.id = p_chr_id
393: AND khr.pdt_id = pdt.pdt_id
394: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD';
395:

Line 399: FROM OKL_K_HEADERS

395:
396: -- cursor to get the last interest calc date .. racheruv. Bug 6342556
397: CURSOR last_int_date_csr IS
398: SELECT TRUNC(DATE_LAST_INTERIM_INTEREST_CAL)
399: FROM OKL_K_HEADERS
400: WHERE ID = p_cntrct_id;
401:
402: l_last_int_calc_date date;
403: l_rev_rec_method_code varchar2(30);

Line 638: p_contract_id IN OKL_K_HEADERS_FULL_V.ID%TYPE,

634: p_init_msg_list IN VARCHAR2,
635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_count OUT NOCOPY NUMBER,
637: x_msg_data OUT NOCOPY VARCHAR2,
638: p_contract_id IN OKL_K_HEADERS_FULL_V.ID%TYPE,
639: p_contract_number IN OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
640: p_fact_synd_code IN VARCHAR2,
641: p_inv_acct_code IN VARCHAR2,
642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,

Line 639: p_contract_number IN OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_count OUT NOCOPY NUMBER,
637: x_msg_data OUT NOCOPY VARCHAR2,
638: p_contract_id IN OKL_K_HEADERS_FULL_V.ID%TYPE,
639: p_contract_number IN OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
640: p_fact_synd_code IN VARCHAR2,
641: p_inv_acct_code IN VARCHAR2,
642: p_tcnv_rec IN OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
643: p_tclv_tbl IN OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,

Line 1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';

1003: l_tcn_type CONSTANT OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'PGL';
1004: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PGL';
1005: ----Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';
1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';
1009: l_sales_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEST';
1010: l_loan_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LOAN';
1011: l_sysdate DATE := SYSDATE;

Line 1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';

1004: l_tcl_type CONSTANT OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'PGL';
1005: ----Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';
1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';
1009: l_sales_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEST';
1010: l_loan_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LOAN';
1011: l_sysdate DATE := SYSDATE;
1012: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;

Line 1009: l_sales_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEST';

1005: ----Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';
1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';
1009: l_sales_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEST';
1010: l_loan_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LOAN';
1011: l_sysdate DATE := SYSDATE;
1012: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1013: l_sob_name VARCHAR2(2000);

Line 1010: l_loan_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LOAN';

1006: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1007: l_oper_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEOP';
1008: l_df_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEDF';
1009: l_sales_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LEASEST';
1010: l_loan_lease CONSTANT OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE := 'LOAN';
1011: l_sysdate DATE := SYSDATE;
1012: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1013: l_sob_name VARCHAR2(2000);
1014: l_org_id NUMBER;

Line 1020: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;

1016: l_product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE := to_number(p_product_id);
1017: l_product_name OKL_PRODUCTS_V.NAME%TYPE;
1018: l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE := to_number(p_bucket_id);
1019: l_entry_date DATE := FND_DATE.CANONICAL_TO_DATE(p_entry_date);
1020: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1021: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1022: l_try_id OKL_TRX_TYPES_V.ID%TYPE;
1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;

Line 1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

1019: l_entry_date DATE := FND_DATE.CANONICAL_TO_DATE(p_entry_date);
1020: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1021: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1022: l_try_id OKL_TRX_TYPES_V.ID%TYPE;
1023: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
1024: l_least_bucket_rate OKL_BUCKETS_V.LOSS_RATE%TYPE;
1025: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1026: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
1027: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 1047: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

1043: l_last_int_calc_date DATE;
1044: l_rev_rec_method_code VARCHAR2(30);
1045:
1046: -- record and table structure variables
1047: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1048: -- Bug# 3020763
1049: TYPE pdt_contracts_rec_type IS RECORD (
1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE

Line 1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE

1046: -- record and table structure variables
1047: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1048: -- Bug# 3020763
1049: TYPE pdt_contracts_rec_type IS RECORD (
1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE

Line 1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE

1047: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1048: -- Bug# 3020763
1049: TYPE pdt_contracts_rec_type IS RECORD (
1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE
1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE

Line 1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE

1048: -- Bug# 3020763
1049: TYPE pdt_contracts_rec_type IS RECORD (
1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE
1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE
1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

Line 1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE

1049: TYPE pdt_contracts_rec_type IS RECORD (
1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE
1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE
1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
1057:

Line 1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE

1050: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE
1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE
1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
1057:
1058: TYPE pool_contents_rec_type is RECORD(

Line 1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE

1051: ,contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE
1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE
1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE
1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
1057:
1058: TYPE pool_contents_rec_type is RECORD(
1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE

Line 1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

1052: ,deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE
1053: ,currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE
1054: ,currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE
1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE
1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
1057:
1058: TYPE pool_contents_rec_type is RECORD(
1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1060: ,sty_id OKL_STRM_TYPE_V.ID%TYPE

Line 1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE

1055: ,currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE
1056: ,currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
1057:
1058: TYPE pool_contents_rec_type is RECORD(
1059: lease_contract_id OKL_K_HEADERS_FULL_V.ID%TYPE
1060: ,sty_id OKL_STRM_TYPE_V.ID%TYPE
1061: ,sty_subclass OKL_STRM_TYPE_V.STREAM_TYPE_SUBCLASS%TYPE
1062: ,streams_to_date OKL_POOL_CONTENTS_V.streams_to_date%TYPE);
1063:

Line 1095: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

1091: ,khr.currency_conversion_rate
1092: ,khr.currency_conversion_date
1093: -- get the last interest calc date .. racheruv. Bug 6342556
1094: ,TRUNC(nvl(khr.date_last_interim_interest_cal, chr.start_date)) last_int_calc_date
1095: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
1096: WHERE khr.pdt_id = p_pdt_id
1097: AND chr.id = khr.id
1098: AND sts_code IN ('BOOKED','EVERGREEN')
1099: AND chr.scs_code = 'LEASE';

Line 1111: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

1107: ,chr.currency_code
1108: ,khr.currency_conversion_type
1109: ,khr.currency_conversion_rate
1110: ,khr.currency_conversion_date
1111: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
1112: WHERE khr.pdt_id = p_pdt_id
1113: AND chr.id = khr.id
1114: AND sts_code = 'ACTIVE'
1115: AND chr.scs_code = 'INVESTOR';

Line 1182: CURSOR sp_loss_trx_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

1178: -- AND to_currency = p_to_currency
1179: -- AND status_code = 'C';
1180:
1181: -- cursor to check whether the contract has a specific loss
1182: CURSOR sp_loss_trx_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
1183: SELECT 'Y'
1184: FROM OKL_TRX_CONTRACTS
1185: WHERE khr_id = p_khr_id
1186: AND tcn_type = 'PSP'

Line 1191: CURSOR gen_loss_trx_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

1187: AND tsu_code = l_tsu_code
1188: AND representation_type = 'PRIMARY'; -- SGIYER MGAAP Changes Bug 7263041
1189:
1190: -- cursor to check whether the contract has a general loss
1191: CURSOR gen_loss_trx_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
1192: SELECT 'Y'
1193: FROM OKL_TRX_CONTRACTS
1194: WHERE khr_id = p_khr_id
1195: AND tcn_type = 'PGL'

Line 1204: CURSOR cntrct_invcs_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_entry_date DATE) IS

1200: --Bug 2969989. Not all outstanding invoices need to be considered.Consider
1201: --only those less than or equal to provision date.
1202: -- Bug 4058948. Changing view from okl_bpd_leasing_payment_trx_v to okl_bpd_contract_invoices_v.
1203: -- Also adding new where condition to exclude invoices subject to cash receipt.
1204: CURSOR cntrct_invcs_csr (p_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE, p_entry_date DATE) IS
1205: SELECT amount_due_remaining, due_date
1206: FROM okl_bpd_contract_invoices_v
1207: WHERE contract_id = p_khr_id
1208: AND status = 'OP'

Line 1223: OKL_K_HEADERS khr

1219: FROM OKL_POOLS pol,
1220: OKL_POOL_CONTENTS poc,
1221: OKL_STRM_TYPE_B sty,
1222: OKC_K_HEADERS_B chr,
1223: OKL_K_HEADERS khr
1224: WHERE pol.khr_id = p_agr_id
1225: AND pol.id = poc.pol_id
1226: AND poc.status_code = 'ACTIVE'
1227: AND poc.sty_id = sty.id

Line 1272: OKL_K_HEADERS_FULL_V khr

1268: -- cursor to get the revenue recognition method.. racheruv. Bug 6342556
1269: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
1270: SELECT pdt.quality_val revenue_recognition_method
1271: FROM OKL_PROD_QLTY_VAL_UV pdt,
1272: OKL_K_HEADERS_FULL_V khr
1273: WHERE khr.id = p_chr_id
1274: AND khr.pdt_id = pdt.pdt_id
1275: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD';
1276:

Line 1537: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;

1533:
1534:
1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency
1536: -- these variables not used anywhere.
1537: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
1538: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
1541:

Line 1538: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;

1534:
1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency
1536: -- these variables not used anywhere.
1537: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
1538: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
1541:
1542: -- record and table structure variables

Line 1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;

1535: -- creating variable required by okl_accounting_util.convert_to_contract_currency
1536: -- these variables not used anywhere.
1537: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
1538: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
1541:
1542: -- record and table structure variables
1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;

1536: -- these variables not used anywhere.
1537: x_contract_currency OKL_K_HEADERS_FULL_V.currency_code%TYPE;
1538: x_currency_conversion_type OKL_K_HEADERS_FULL_V.currency_conversion_type%TYPE;
1539: x_currency_conversion_rate OKL_K_HEADERS_FULL_V.currency_conversion_rate%TYPE;
1540: x_currency_conversion_date OKL_K_HEADERS_FULL_V.currency_conversion_date%TYPE;
1541:
1542: -- record and table structure variables
1543: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1544: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

Line 2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;

2307: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;
2308: l_currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE;
2309: l_currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE;
2310: l_set_of_books_id OKL_SYS_ACCT_OPTS.SET_OF_BOOKS_ID%TYPE;
2311: l_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE;
2312: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
2313: l_sysdate DATE := SYSDATE;
2314: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
2315: l_period_start_date DATE;

Line 2360: FROM OKL_K_HEADERS_FULL_V

2356:
2357: -- cursor to get scs_code
2358: CURSOR scs_code_csr IS
2359: SELECT scs_code
2360: FROM OKL_K_HEADERS_FULL_V
2361: WHERE id = p_slpv_rec.khr_id;
2362:
2363:
2364: -- Cursor to verify if the stream type selected is the same as used earlier

Line 2365: -- CURSOR sty_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

2361: WHERE id = p_slpv_rec.khr_id;
2362:
2363:
2364: -- Cursor to verify if the stream type selected is the same as used earlier
2365: -- CURSOR sty_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2366: -- SELECT DISTINCT sty.id id
2367: -- FROM OKL_STRM_TYPE_B sty, OKL_TRX_CONTRACTS_V trx, OKL_TXL_CNTRCT_LNS_V txl
2368: -- WHERE trx.khr_id = p_ctr_id
2369: -- AND trx.tcn_type = 'PSP'

Line 2375: CURSOR gen_loss_trx_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

2371: -- AND trx.id = txl.tcn_id
2372: -- AND txl.sty_id = sty.id;
2373:
2374: -- cursor to check whether the contract has a general loss
2375: CURSOR gen_loss_trx_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2376: SELECT 'Y'
2377: FROM OKL_TRX_CONTRACTS
2378: WHERE khr_id = p_ctr_id
2379: AND tcn_type = 'PGL'

Line 2384: CURSOR spec_loss_trx_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

2380: AND tsu_code = l_tsu_code
2381: AND representation_type='PRIMARY';
2382:
2383: -- cursor to check whether the contract has a specific loss
2384: CURSOR spec_loss_trx_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2385: SELECT 'Y'
2386: FROM OKL_TRX_CONTRACTS
2387: WHERE khr_id = p_ctr_id
2388: AND tcn_type = 'PSP'

Line 2393: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

2389: AND tsu_code = l_tsu_code
2390: AND representation_type='PRIMARY';
2391:
2392: -- cursor to get the contract number
2393: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2394: SELECT contract_number
2395: FROM OKL_K_HEADERS_FULL_V
2396: WHERE id = p_ctr_id;
2397:

Line 2395: FROM OKL_K_HEADERS_FULL_V

2391:
2392: -- cursor to get the contract number
2393: CURSOR contract_num_csr (p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2394: SELECT contract_number
2395: FROM OKL_K_HEADERS_FULL_V
2396: WHERE id = p_ctr_id;
2397:
2398: -- cursor to get the product id for the given contract id
2399: CURSOR pdt_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

Line 2399: CURSOR pdt_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS

2395: FROM OKL_K_HEADERS_FULL_V
2396: WHERE id = p_ctr_id;
2397:
2398: -- cursor to get the product id for the given contract id
2399: CURSOR pdt_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2400: SELECT pdt_id
2401: FROM OKL_K_HEADERS_FULL_V
2402: WHERE id = p_ctr_id;
2403:

Line 2401: FROM OKL_K_HEADERS_FULL_V

2397:
2398: -- cursor to get the product id for the given contract id
2399: CURSOR pdt_id_csr(p_ctr_id OKL_K_HEADERS_FULL_V.ID%TYPE) IS
2400: SELECT pdt_id
2401: FROM OKL_K_HEADERS_FULL_V
2402: WHERE id = p_ctr_id;
2403:
2404: -- Cursor to select currency information for the contract
2405: CURSOR currency_info_csr(p_khr_id NUMBER) IS

Line 2410: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

2406: SELECT chr.currency_code currency_code,
2407: khr.currency_conversion_type currency_conversion_type,
2408: khr.currency_conversion_date currency_conversion_date,
2409: khr.currency_conversion_rate currency_conversion_rate
2410: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
2411: WHERE chr.id = p_khr_id
2412: AND chr.id = khr.id;
2413:
2414: