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

Line 52: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

48: AND p_accrual_date BETWEEN start_date AND end_date;
49:
50: -- Process accrual rec type
51: TYPE process_accrual_rec_type IS RECORD (
52: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,

Line 53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

49:
50: -- Process accrual rec type
51: TYPE process_accrual_rec_type IS RECORD (
52: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,

Line 54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

50: -- Process accrual rec type
51: TYPE process_accrual_rec_type IS RECORD (
52: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

Line 55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

51: TYPE process_accrual_rec_type IS RECORD (
52: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
53: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

54: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,

Line 59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

55: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
56: accrual_status OKL_TRX_CONTRACTS.ACCRUAL_STATUS_YN%TYPE,
57: override_status OKL_TRX_CONTRACTS.UPDATE_STATUS_YN%TYPE,
58: start_date OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
59: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
60: khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE,
61: currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE,
62: currency_conv_date OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_DATE%TYPE,
63: currency_conv_rate OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_RATE%TYPE,

Line 171: FUNCTION CALCULATE_OPERAND_VALUE(p_ctr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE

167:
168:
169:
170: -- Function which calculates values for the operand i.e. Limit Days or Bills Unpaid
171: FUNCTION CALCULATE_OPERAND_VALUE(p_ctr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
172: ,p_operand_code IN VARCHAR2) RETURN NUMBER IS
173:
174: l_sysdate DATE := SYSDATE;
175: l_return_value NUMBER := 0;

Line 375: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE

371: RETURN(l_return_status);
372:
373: END GET_FACTORING_FLAG;
374:
375: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
376: ,p_date IN DATE) RETURN VARCHAR2 IS
377:
378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
379: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS

Line 382: OKL_K_HEADERS_FULL_V khr

378: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
379: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
380: SELECT pdt.quality_val revenue_recognition_method
381: FROM OKL_PROD_QLTY_VAL_UV pdt,
382: OKL_K_HEADERS_FULL_V khr
383: WHERE khr.id = p_chr_id
384: AND khr.pdt_id = pdt.pdt_id
385: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD'
386: AND khr.scs_code = 'LEASE'

Line 389: FROM OKL_K_HEADERS_FULL_V khr

385: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD'
386: AND khr.scs_code = 'LEASE'
387: UNION
388: SELECT 'STREAMS' revenue_recognition_method
389: FROM OKL_K_HEADERS_FULL_V khr
390: WHERE khr.id = p_chr_id
391: AND khr.scs_code = 'INVESTOR'
392: ;
393:

Line 398: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,

394: CURSOR get_contract_number_csr(p_chr_id NUMBER) IS
395: SELECT a.contract_number,
396: nvl(b.multi_gaap_yn, 'N') multi_gaap_yn,
397: c.reporting_pdt_id -- MGAAP 7263041
398: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,
399: OKL_PRODUCTS C
400: WHERE A.id = p_chr_id
401: AND A.id = B.id
402: AND B.PDT_ID = C.ID;

Line 405: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

401: AND A.id = B.id
402: AND B.PDT_ID = C.ID;
403:
404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE := null;
405: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
406:
407: -- bug 7577628
408: cursor get_sec_rep_method IS
409: select secondary_rep_method

Line 427: OKL_K_HEADERS khr,

423: --OKL_STREAMS stm,
424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
425: OKL_STRM_ELEMENTS ste,
426: OKL_PROD_STRM_TYPES psty,
427: OKL_K_HEADERS khr,
428: OKL_PRODUCTS pdt
429: WHERE khr.id = p_chr_id
430: AND stm.khr_id = khr.id
431: AND stm.say_code = 'CURR'

Line 448: FROM OKL_K_HEADERS

444: AND ste.accrued_yn IS NULL);
445:
446: CURSOR last_int_date_csr IS
447: SELECT TRUNC(DATE_LAST_INTERIM_INTEREST_CAL)
448: FROM OKL_K_HEADERS
449: WHERE ID = p_khr_id;
450:
451: CURSOR khr_start_date_csr IS
452: SELECT TRUNC(start_date)

Line 473: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

469: AND trx.representation_type = 'PRIMARY' -- MGAAP 7263041
470: AND txl.sty_id = sty.id
471: AND sty.stream_type_purpose = 'ACTUAL_INCOME_ACCRUAL';
472:
473: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
474: l_rev_rec_method OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
475: l_accrual_status VARCHAR2(1);
476: x_result VARCHAR2(1);
477: -- Bug 5036337.Commenting below as no longer needed.

Line 907: ,p_ctr_id IN OKL_K_HEADERS.id%TYPE) IS

903:
904: -- Function to validate contract against accrual rule
905: PROCEDURE VALIDATE_ACCRUAL_RULE(x_return_status OUT NOCOPY VARCHAR2
906: ,x_result OUT NOCOPY VARCHAR2
907: ,p_ctr_id IN OKL_K_HEADERS.id%TYPE) IS
908:
909:
910: -- Bug 4576668. SGIYER. Only English lang meaning required.Commented cursor.
911: -- CURSOR accrual_rule_csr IS

Line 996: ,p_khr_id IN OKL_K_HEADERS.ID%TYPE

992:
993: -- Procedure to select streams that need to be accrued
994: PROCEDURE GET_ACCRUAL_STREAMS(x_return_status OUT NOCOPY VARCHAR2
995: ,x_stream_tbl OUT NOCOPY stream_tbl_type
996: ,p_khr_id IN OKL_K_HEADERS.ID%TYPE
997: ,p_product_id IN OKL_PRODUCTS_V.ID%TYPE
998: ,p_ctr_start_date IN DATE
999: ,p_period_end_date IN DATE
1000: ,p_accrual_rule_yn IN VARCHAR2) IS

Line 1019: OKL_K_HEADERS khr

1015: --OKL_STREAMS stm,
1016: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1017: OKL_STRM_ELEMENTS ste,
1018: OKL_PROD_STRM_TYPES psty,
1019: OKL_K_HEADERS khr
1020: WHERE stm.khr_id = p_ctr_id
1021: AND khr.id = stm.khr_id
1022: AND stm.active_yn = 'Y'
1023: AND stm.say_code = 'CURR'

Line 1052: OKL_K_HEADERS khr

1048: --OKL_STREAMS stm,
1049: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1050: OKL_STRM_ELEMENTS ste,
1051: OKL_PROD_STRM_TYPES psty,
1052: OKL_K_HEADERS khr
1053: WHERE stm.khr_id = p_ctr_id
1054: AND khr.id = stm.khr_id
1055: AND stm.active_yn = 'Y'
1056: AND stm.say_code = 'CURR'

Line 1511: okl_k_headers_full_v khr

1507: okc_line_styles_b lse_fa,
1508: okc_k_lines_b kle_ml,
1509: okc_line_styles_b lse_ml,
1510: okc_k_items ite,
1511: okl_k_headers_full_v khr
1512: WHERE kle_fa.id = cp_cle_id
1513: AND kle_fa.chr_id = cp_chr_id
1514: AND lse_fa.id = kle_fa.lse_id
1515: AND lse_fa.lty_code = 'FREE_FORM1'

Line 1565: FROM okl_k_headers khr

1561: ,khr.attribute12
1562: ,khr.attribute13
1563: ,khr.attribute14
1564: ,khr.attribute15
1565: FROM okl_k_headers khr
1566: WHERE khr.id = p_khr_id;
1567:
1568: --Added by kthiruva on 14-May-2007
1569: --cursor to fetch the line dff information for SLA Uptake

Line 2330: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

2326: l_period_end_date DATE;
2327: l_period_status VARCHAR2(1);
2328: l_sob_id NUMBER;
2329: l_accrual_rec accrual_rec_type;
2330: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2331: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2332: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2333: l_total1 NUMBER := 0;
2334: l_total2 NUMBER := 0;

Line 2331: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

2327: l_period_status VARCHAR2(1);
2328: l_sob_id NUMBER;
2329: l_accrual_rec accrual_rec_type;
2330: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2331: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2332: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2333: l_total1 NUMBER := 0;
2334: l_total2 NUMBER := 0;
2335: l_try_id NUMBER;

Line 2336: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

2332: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2333: l_total1 NUMBER := 0;
2334: l_total2 NUMBER := 0;
2335: l_try_id NUMBER;
2336: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2337: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2338: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2339: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2340: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 2337: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;

2333: l_total1 NUMBER := 0;
2334: l_total2 NUMBER := 0;
2335: l_try_id NUMBER;
2336: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2337: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2338: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2339: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2340: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2341: l_factoring_synd_flag VARCHAR2(2000) := NULL;

Line 2338: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

2334: l_total2 NUMBER := 0;
2335: l_try_id NUMBER;
2336: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2337: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2338: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2339: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2340: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2341: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

2340: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2341: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

2341: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2349: l_accrual_strm_tbl stream_tbl_type;

Line 2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

2342: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2349: l_accrual_strm_tbl stream_tbl_type;
2350: l_non_accrual_strm_tbl stream_tbl_type;

Line 2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

2343: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2349: l_accrual_strm_tbl stream_tbl_type;
2350: l_non_accrual_strm_tbl stream_tbl_type;
2351: l_accrual_rule_value OKL_STRM_TYPE_V.accrual_yn%TYPE;

Line 2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2349: l_accrual_strm_tbl stream_tbl_type;
2350: l_non_accrual_strm_tbl stream_tbl_type;
2351: l_accrual_rule_value OKL_STRM_TYPE_V.accrual_yn%TYPE;
2352: l_counter1 NUMBER := 1;

Line 2376: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,

2372: khr.generate_accrual_yn,
2373: khr.generate_accrual_override_yn,
2374: khr.deal_type,
2375: pdt.reporting_pdt_id -- MGAAP 7263014
2376: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2377: OKL_PRODUCTS pdt
2378: WHERE chr.id = p_ctr_id
2379: AND chr.id = khr.id
2380: AND khr.pdt_id = pdt.id;

Line 2956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

2952: l_period_status VARCHAR2(1);
2953: l_sob_id NUMBER;
2954: l_stream_tbl stream_tbl_type;
2955: l_accrual_rec accrual_rec_type;
2956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2957: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2958: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041
2959: l_apply_accrual_rule VARCHAR2(1) := '?';
2960: l_rule_result VARCHAR2(1);

Line 2957: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

2953: l_sob_id NUMBER;
2954: l_stream_tbl stream_tbl_type;
2955: l_accrual_rec accrual_rec_type;
2956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2957: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2958: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041
2959: l_apply_accrual_rule VARCHAR2(1) := '?';
2960: l_rule_result VARCHAR2(1);
2961: l_override_status VARCHAR2(1);

Line 2964: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

2960: l_rule_result VARCHAR2(1);
2961: l_override_status VARCHAR2(1);
2962: l_total NUMBER := 0;
2963: l_try_id NUMBER;
2964: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2965: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2966: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2968: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 2965: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

2961: l_override_status VARCHAR2(1);
2962: l_total NUMBER := 0;
2963: l_try_id NUMBER;
2964: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2965: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2966: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2968: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2969: l_factoring_synd_flag VARCHAR2(2000) := NULL;

Line 2966: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;

2962: l_total NUMBER := 0;
2963: l_try_id NUMBER;
2964: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2965: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2966: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2968: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2969: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2970: l_billing_type VARCHAR2(2000) := NULL;

Line 2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

2963: l_try_id NUMBER;
2964: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2965: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2966: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2968: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2969: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2970: l_billing_type VARCHAR2(2000) := NULL;
2971: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 3005: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,

3001: ,khr.currency_conversion_type
3002: ,khr.currency_conversion_rate
3003: ,khr.currency_conversion_date
3004: ,pdt.reporting_pdt_id
3005: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
3006: OKL_PRODUCTS pdt --MGAAP 7263041
3007: WHERE chr.id = p_khr_id
3008: AND chr.id = khr.id
3009: AND khr.pdt_id = pdt.id;

Line 3087: OKL_K_HEADERS khr,

3083: --OKL_STREAMS stm,
3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3085: OKL_STRM_ELEMENTS ste,
3086: OKL_PROD_STRM_TYPES psty,
3087: OKL_K_HEADERS khr,
3088: OKL_PRODUCTS pdt
3089: WHERE sty.id = p_acceleration_rec.sty_id
3090: AND stm.khr_id = p_acceleration_rec.khr_id
3091: AND stm.kle_id = p_acceleration_rec.kle_id

Line 3125: OKL_K_HEADERS khr,

3121: --OKL_STREAMS stm,
3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3123: OKL_STRM_ELEMENTS ste,
3124: OKL_PROD_STRM_TYPES psty,
3125: OKL_K_HEADERS khr,
3126: OKL_PRODUCTS pdt
3127: WHERE sty.id = p_acceleration_rec.sty_id
3128: AND stm.khr_id = p_acceleration_rec.khr_id
3129: AND stm.kle_id = p_acceleration_rec.kle_id

Line 3163: OKL_K_HEADERS khr,

3159: --OKL_STREAMS stm,
3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3161: OKL_STRM_ELEMENTS ste,
3162: OKL_PROD_STRM_TYPES psty,
3163: OKL_K_HEADERS khr,
3164: OKL_PRODUCTS pdt
3165: WHERE stm.khr_id = p_acceleration_rec.khr_id
3166: AND khr.id = stm.khr_id
3167: AND sty.id = p_acceleration_rec.sty_id

Line 3201: OKL_K_HEADERS khr,

3197: --OKL_STREAMS stm,
3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3199: OKL_STRM_ELEMENTS ste,
3200: OKL_PROD_STRM_TYPES psty,
3201: OKL_K_HEADERS khr,
3202: OKL_PRODUCTS pdt
3203: WHERE stm.khr_id = p_acceleration_rec.khr_id
3204: AND khr.id = stm.khr_id
3205: AND sty.id = p_acceleration_rec.sty_id

Line 4759: FROM okl_k_headers khr

4755: ,khr.attribute12
4756: ,khr.attribute13
4757: ,khr.attribute14
4758: ,khr.attribute15
4759: FROM okl_k_headers khr
4760: WHERE khr.id = p_khr_id;
4761:
4762: --local variables
4763: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 5377: FROM okl_k_headers khr

5373: ,khr.attribute12
5374: ,khr.attribute13
5375: ,khr.attribute14
5376: ,khr.attribute15
5377: FROM okl_k_headers khr
5378: WHERE khr.id = p_khr_id;
5379:
5380: --local variables
5381: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

6083: p_process_accrual_rec IN process_accrual_rec_type
6084:
6085: )IS
6086:
6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

6084:
6085: )IS
6086:
6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

6085: )IS
6086:
6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

6086:
6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
6095: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
6095: l_try_id OKL_TRX_TYPES_V.id%TYPE;
6096: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
6095: l_try_id OKL_TRX_TYPES_V.id%TYPE;
6096: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
6097: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
6095: l_try_id OKL_TRX_TYPES_V.id%TYPE;
6096: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
6097: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
6098: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 6203: FROM OKL_K_HEADERS

6199:
6200: -- Cursor to select the last interest calculated date
6201: CURSOR last_int_date_csr(p_khr_id NUMBER) IS
6202: SELECT TRUNC(DATE_LAST_INTERIM_INTEREST_CAL)
6203: FROM OKL_K_HEADERS
6204: WHERE ID = p_khr_id;
6205:
6206:
6207: -- Cursor to select the stream type id for the streams being accrued in case of variable interest rate contracts

Line 6278: FROM OKL_K_HEADERS a,

6274: -- MGAAP start 7263041
6275: CURSOR contract_multigaap_csr (p_contract_id NUMBER) IS
6276: SELECT NVL(a.multi_gaap_yn,'N') multi_gaap_yn,
6277: b.reporting_pdt_id
6278: FROM OKL_K_HEADERS a,
6279: OKL_PRODUCTS b
6280: WHERE a.ID = p_contract_id
6281: AND a.PDT_ID = b.ID;
6282:

Line 6283: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

6279: OKL_PRODUCTS b
6280: WHERE a.ID = p_contract_id
6281: AND a.PDT_ID = b.ID;
6282:
6283: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
6284: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
6285: l_tcnv_tbl_cnt NUMBER;
6286: l_sty_id_rep OKL_STRM_TYPE_V.id%TYPE;
6287: -- MGAAP end 7263041

Line 9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

9951: ,p_contract_number IN VARCHAR2
9952: ,p_rev_rec_method IN VARCHAR2) IS
9953:
9954: -- declare local variables
9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

9952: ,p_rev_rec_method IN VARCHAR2) IS
9953:
9954: -- declare local variables
9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

9953:
9954: -- declare local variables
9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

9954: -- declare local variables
9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9963: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9963: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9964: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9963: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9964: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9965: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9963: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9964: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9965: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9966: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 10015: OKL_K_HEADERS khr,

10011: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
10012: CURSOR chk_update_header_csr is
10013: SELECT chr.contract_number
10014: FROM OKC_K_HEADERS_B chr,
10015: OKL_K_HEADERS khr,
10016: OKL_PROD_QLTY_VAL_UV pdt
10017: WHERE chr.scs_code = 'LEASE'
10018: AND chr.sts_code IN ('BOOKED','EVERGREEN')
10019: AND chr.id = khr.id

Line 10027: OKL_K_HEADERS khr

10023: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
10024: UNION
10025: SELECT chr.contract_number
10026: FROM OKC_K_HEADERS_B chr,
10027: OKL_K_HEADERS khr
10028: WHERE chr.scs_code = 'INVESTOR'
10029: AND chr.sts_code = 'ACTIVE'
10030: AND chr.id = khr.id
10031: ;

Line 10105: OKL_K_HEADERS khr,

10101: ,khr.currency_conversion_type
10102: ,khr.currency_conversion_rate
10103: ,khr.currency_conversion_date
10104: FROM OKC_K_HEADERS_B chr,
10105: OKL_K_HEADERS khr,
10106: OKL_PROD_QLTY_VAL_UV pdt
10107: WHERE chr.contract_number = p_contract_number
10108: AND chr.id = khr.id
10109: AND chr.scs_code = 'LEASE'

Line 10129: OKL_K_HEADERS khr

10125: ,khr.currency_conversion_type
10126: ,khr.currency_conversion_rate
10127: ,khr.currency_conversion_date
10128: FROM OKC_K_HEADERS_B chr,
10129: OKL_K_HEADERS khr
10130: WHERE chr.contract_number = p_contract_number
10131: AND chr.id = khr.id
10132: AND chr.scs_code = 'INVESTOR'
10133: AND chr.sts_code = 'ACTIVE'

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

10144: --AND r.jtot_object1_code = 'OKX_INVRULE'
10145: --AND r.rule_information_category = 'IRE';
10146:
10147: -- declare error placeholders
10148: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10149: -- Bug 3020763
10150: TYPE accrual_contracts_rec_type IS RECORD(
10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

Line 10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

10147: -- declare error placeholders
10148: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10149: -- Bug 3020763
10150: TYPE accrual_contracts_rec_type IS RECORD(
10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

Line 10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

10148: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10149: -- Bug 3020763
10150: TYPE accrual_contracts_rec_type IS RECORD(
10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

Line 10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

10149: -- Bug 3020763
10150: TYPE accrual_contracts_rec_type IS RECORD(
10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

Line 10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

10150: TYPE accrual_contracts_rec_type IS RECORD(
10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

Line 10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

Line 10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

Line 10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,

Line 10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);

Line 10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
10164:

Line 10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
10164:
10165: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;

Line 10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,

10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
10164:
10165: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
10166:

Line 10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);

10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
10164:
10165: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
10166:
10167: l_contract_error_tbl contract_error_tbl_type;

Line 10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

10618: ,p_batch_name IN VARCHAR2
10619: ,p_worker_id IN VARCHAR2
10620: ,p_rev_rec_method IN VARCHAR2) IS
10621:
10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

10619: ,p_worker_id IN VARCHAR2
10620: ,p_rev_rec_method IN VARCHAR2) IS
10621:
10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

10620: ,p_rev_rec_method IN VARCHAR2) IS
10621:
10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

10621:
10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10630: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10630: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10631: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10630: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10631: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10632: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10630: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10631: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10632: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10633: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 10694: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

10690: ,chr.currency_code
10691: ,khr.currency_conversion_type
10692: ,khr.currency_conversion_rate
10693: ,khr.currency_conversion_date
10694: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
10695: WHERE chr.contract_number = p_khr_num
10696: AND chr.id = khr.id
10697: AND chr.scs_code = 'LEASE'
10698: AND chr.sts_code IN ('BOOKED','EVERGREEN')

Line 10713: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

10709: ,chr.currency_code
10710: ,khr.currency_conversion_type
10711: ,khr.currency_conversion_rate
10712: ,khr.currency_conversion_date
10713: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
10714: WHERE chr.contract_number = p_khr_num
10715: AND chr.id = khr.id
10716: AND chr.scs_code = 'INVESTOR'
10717: AND chr.sts_code = 'ACTIVE'

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

10719: ;
10720:
10721:
10722: -- declare error placeholders
10723: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10724: -- Bug 3020763
10725: TYPE accrual_contracts_rec_type IS RECORD(
10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

Line 10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

10722: -- declare error placeholders
10723: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10724: -- Bug 3020763
10725: TYPE accrual_contracts_rec_type IS RECORD(
10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

Line 10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

10723: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
10724: -- Bug 3020763
10725: TYPE accrual_contracts_rec_type IS RECORD(
10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

Line 10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

10724: -- Bug 3020763
10725: TYPE accrual_contracts_rec_type IS RECORD(
10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

Line 10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

10725: TYPE accrual_contracts_rec_type IS RECORD(
10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

Line 10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

Line 10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

Line 10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

Line 10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
10738:

Line 10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
10738:
10739: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;

Line 10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
10738:
10739: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
10740: TYPE req_id_tbl_type IS TABLE OF FND_CONCURRENT_REQUESTS.request_id%TYPE INDEX BY BINARY_INTEGER;

Line 10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
10738:
10739: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
10740: TYPE req_id_tbl_type IS TABLE OF FND_CONCURRENT_REQUESTS.request_id%TYPE INDEX BY BINARY_INTEGER;
10741: TYPE contract_number_tbl_type IS TABLE OF OKC_K_HEADERS_B.contract_number%TYPE INDEX BY BINARY_INTEGER;

Line 11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

11010: x_msg_data OUT NOCOPY VARCHAR2,
11011: p_accrual_rec IN adjust_accrual_rec_type) IS
11012:
11013: -- declare local variables
11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

11011: p_accrual_rec IN adjust_accrual_rec_type) IS
11012:
11013: -- declare local variables
11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

11012:
11013: -- declare local variables
11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

11013: -- declare local variables
11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
11022: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
11022: l_try_id OKL_TRX_TYPES_V.id%TYPE;
11023: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
11022: l_try_id OKL_TRX_TYPES_V.id%TYPE;
11023: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
11024: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
11022: l_try_id OKL_TRX_TYPES_V.id%TYPE;
11023: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
11024: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
11025: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 11066: OKL_K_HEADERS khr,

11062: ,khr.currency_conversion_rate
11063: ,khr.currency_conversion_date
11064: ,pdt.quality_val revenue_recognition_method
11065: FROM OKC_K_HEADERS_B chr,
11066: OKL_K_HEADERS khr,
11067: OKL_PROD_QLTY_VAL_UV pdt
11068: WHERE chr.id = p_khr_id
11069: AND chr.id = khr.id
11070: AND chr.scs_code = 'LEASE'

Line 11089: OKL_K_HEADERS khr

11085: ,khr.currency_conversion_rate
11086: ,khr.currency_conversion_date
11087: ,'STREAMS' revenue_recognition_method
11088: FROM OKC_K_HEADERS_B chr,
11089: OKL_K_HEADERS khr
11090: WHERE chr.id = p_khr_id
11091: AND chr.id = khr.id
11092: AND chr.scs_code = 'INVESTOR'
11093: AND chr.sts_code = 'ACTIVE'