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 328: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE

324: RETURN(l_return_status);
325:
326: END GET_FACTORING_FLAG;
327:
328: FUNCTION CHECK_DATE_ACCRUED_TILL(p_khr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE
329: ,p_date IN DATE) RETURN VARCHAR2 IS
330:
331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
332: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS

Line 335: OKL_K_HEADERS_FULL_V khr

331: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
332: CURSOR get_rev_rec_method_csr(p_chr_id NUMBER) IS
333: SELECT pdt.quality_val revenue_recognition_method
334: FROM OKL_PROD_QLTY_VAL_UV pdt,
335: OKL_K_HEADERS_FULL_V khr
336: WHERE khr.id = p_chr_id
337: AND khr.pdt_id = pdt.pdt_id
338: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD'
339: AND khr.scs_code = 'LEASE'

Line 342: FROM OKL_K_HEADERS_FULL_V khr

338: AND pdt.quality_name = 'REVENUE_RECOGNITION_METHOD'
339: AND khr.scs_code = 'LEASE'
340: UNION
341: SELECT 'STREAMS' revenue_recognition_method
342: FROM OKL_K_HEADERS_FULL_V khr
343: WHERE khr.id = p_chr_id
344: AND khr.scs_code = 'INVESTOR'
345: ;
346:

Line 351: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,

347: CURSOR get_contract_number_csr(p_chr_id NUMBER) IS
348: SELECT a.contract_number,
349: nvl(b.multi_gaap_yn, 'N') multi_gaap_yn,
350: c.reporting_pdt_id -- MGAAP 7263041
351: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,
352: OKL_PRODUCTS C
353: WHERE A.id = p_chr_id
354: AND A.id = B.id
355: AND B.PDT_ID = C.ID;

Line 358: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

354: AND A.id = B.id
355: AND B.PDT_ID = C.ID;
356:
357: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE := null;
358: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
359:
360: -- bug 7577628
361: cursor get_sec_rep_method IS
362: select secondary_rep_method

Line 380: OKL_K_HEADERS khr,

376: --OKL_STREAMS stm,
377: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
378: OKL_STRM_ELEMENTS ste,
379: OKL_PROD_STRM_TYPES psty,
380: OKL_K_HEADERS khr,
381: OKL_PRODUCTS pdt
382: WHERE khr.id = p_chr_id
383: AND stm.khr_id = khr.id
384: AND stm.say_code = 'CURR'

Line 401: FROM OKL_K_HEADERS

397: AND ste.accrued_yn IS NULL);
398:
399: CURSOR last_int_date_csr IS
400: SELECT TRUNC(DATE_LAST_INTERIM_INTEREST_CAL)
401: FROM OKL_K_HEADERS
402: WHERE ID = p_khr_id;
403:
404: CURSOR khr_start_date_csr IS
405: SELECT TRUNC(start_date)

Line 426: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

422: AND trx.representation_type = 'PRIMARY' -- MGAAP 7263041
423: AND txl.sty_id = sty.id
424: AND sty.stream_type_purpose = 'ACTUAL_INCOME_ACCRUAL';
425:
426: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
427: l_rev_rec_method OKL_PRODUCT_PARAMETERS_V.revenue_recognition_method%TYPE;
428: l_accrual_status VARCHAR2(1);
429: x_result VARCHAR2(1);
430: -- Bug 5036337.Commenting below as no longer needed.

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

793:
794: -- Function to validate contract against accrual rule
795: PROCEDURE VALIDATE_ACCRUAL_RULE(x_return_status OUT NOCOPY VARCHAR2
796: ,x_result OUT NOCOPY VARCHAR2
797: ,p_ctr_id IN OKL_K_HEADERS.id%TYPE) IS
798:
799:
800: -- Bug 4576668. SGIYER. Only English lang meaning required.Commented cursor.
801: -- CURSOR accrual_rule_csr IS

Line 886: ,p_khr_id IN OKL_K_HEADERS.ID%TYPE

882:
883: -- Procedure to select streams that need to be accrued
884: PROCEDURE GET_ACCRUAL_STREAMS(x_return_status OUT NOCOPY VARCHAR2
885: ,x_stream_tbl OUT NOCOPY stream_tbl_type
886: ,p_khr_id IN OKL_K_HEADERS.ID%TYPE
887: ,p_product_id IN OKL_PRODUCTS_V.ID%TYPE
888: ,p_ctr_start_date IN DATE
889: ,p_period_end_date IN DATE
890: ,p_accrual_rule_yn IN VARCHAR2) IS

Line 909: OKL_K_HEADERS khr

905: --OKL_STREAMS stm,
906: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
907: OKL_STRM_ELEMENTS ste,
908: OKL_PROD_STRM_TYPES psty,
909: OKL_K_HEADERS khr
910: WHERE stm.khr_id = p_ctr_id
911: AND khr.id = stm.khr_id
912: AND stm.active_yn = 'Y'
913: AND stm.say_code = 'CURR'

Line 942: OKL_K_HEADERS khr

938: --OKL_STREAMS stm,
939: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
940: OKL_STRM_ELEMENTS ste,
941: OKL_PROD_STRM_TYPES psty,
942: OKL_K_HEADERS khr
943: WHERE stm.khr_id = p_ctr_id
944: AND khr.id = stm.khr_id
945: AND stm.active_yn = 'Y'
946: AND stm.say_code = 'CURR'

Line 1401: okl_k_headers_full_v khr

1397: okc_line_styles_b lse_fa,
1398: okc_k_lines_b kle_ml,
1399: okc_line_styles_b lse_ml,
1400: okc_k_items ite,
1401: okl_k_headers_full_v khr
1402: WHERE kle_fa.id = cp_cle_id
1403: AND kle_fa.chr_id = cp_chr_id
1404: AND lse_fa.id = kle_fa.lse_id
1405: AND lse_fa.lty_code = 'FREE_FORM1'

Line 1455: FROM okl_k_headers khr

1451: ,khr.attribute12
1452: ,khr.attribute13
1453: ,khr.attribute14
1454: ,khr.attribute15
1455: FROM okl_k_headers khr
1456: WHERE khr.id = p_khr_id;
1457:
1458: --Added by kthiruva on 14-May-2007
1459: --cursor to fetch the line dff information for SLA Uptake

Line 2212: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

2208: l_period_end_date DATE;
2209: l_period_status VARCHAR2(1);
2210: l_sob_id NUMBER;
2211: l_accrual_rec accrual_rec_type;
2212: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2213: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2214: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2215: l_total1 NUMBER := 0;
2216: l_total2 NUMBER := 0;

Line 2213: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

2209: l_period_status VARCHAR2(1);
2210: l_sob_id NUMBER;
2211: l_accrual_rec accrual_rec_type;
2212: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2213: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2214: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2215: l_total1 NUMBER := 0;
2216: l_total2 NUMBER := 0;
2217: l_try_id NUMBER;

Line 2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

2214: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2215: l_total1 NUMBER := 0;
2216: l_total2 NUMBER := 0;
2217: l_try_id NUMBER;
2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2219: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 2219: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;

2215: l_total1 NUMBER := 0;
2216: l_total2 NUMBER := 0;
2217: l_try_id NUMBER;
2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2219: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;

Line 2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

2216: l_total2 NUMBER := 0;
2217: l_try_id NUMBER;
2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2219: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2220: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2221: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

2222: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

2223: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2231: l_accrual_strm_tbl stream_tbl_type;

Line 2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

2224: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2231: l_accrual_strm_tbl stream_tbl_type;
2232: l_non_accrual_strm_tbl stream_tbl_type;

Line 2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

2225: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2231: l_accrual_strm_tbl stream_tbl_type;
2232: l_non_accrual_strm_tbl stream_tbl_type;
2233: l_accrual_rule_value OKL_STRM_TYPE_V.accrual_yn%TYPE;

Line 2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

2226: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
2227: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
2228: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
2229: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
2230: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
2231: l_accrual_strm_tbl stream_tbl_type;
2232: l_non_accrual_strm_tbl stream_tbl_type;
2233: l_accrual_rule_value OKL_STRM_TYPE_V.accrual_yn%TYPE;
2234: l_counter1 NUMBER := 1;

Line 2258: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,

2254: khr.generate_accrual_yn,
2255: khr.generate_accrual_override_yn,
2256: khr.deal_type,
2257: pdt.reporting_pdt_id -- MGAAP 7263014
2258: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2259: OKL_PRODUCTS pdt
2260: WHERE chr.id = p_ctr_id
2261: AND chr.id = khr.id
2262: AND khr.pdt_id = pdt.id;

Line 2780: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

2776: l_period_status VARCHAR2(1);
2777: l_sob_id NUMBER;
2778: l_stream_tbl stream_tbl_type;
2779: l_accrual_rec accrual_rec_type;
2780: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2781: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2782: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041
2783: l_apply_accrual_rule VARCHAR2(1) := '?';
2784: l_rule_result VARCHAR2(1);

Line 2781: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

2777: l_sob_id NUMBER;
2778: l_stream_tbl stream_tbl_type;
2779: l_accrual_rec accrual_rec_type;
2780: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2781: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2782: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041
2783: l_apply_accrual_rule VARCHAR2(1) := '?';
2784: l_rule_result VARCHAR2(1);
2785: l_override_status VARCHAR2(1);

Line 2788: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

2784: l_rule_result VARCHAR2(1);
2785: l_override_status VARCHAR2(1);
2786: l_total NUMBER := 0;
2787: l_try_id NUMBER;
2788: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2789: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2790: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 2789: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

2785: l_override_status VARCHAR2(1);
2786: l_total NUMBER := 0;
2787: l_try_id NUMBER;
2788: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2789: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2790: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;

Line 2790: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;

2786: l_total NUMBER := 0;
2787: l_try_id NUMBER;
2788: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2789: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2790: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;

Line 2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

2787: l_try_id NUMBER;
2788: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
2789: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
2790: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;
2791: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
2792: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
2793: l_factoring_synd_flag VARCHAR2(2000) := NULL;
2794: l_billing_type VARCHAR2(2000) := NULL;
2795: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 2818: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,

2814: ,khr.currency_conversion_type
2815: ,khr.currency_conversion_rate
2816: ,khr.currency_conversion_date
2817: ,pdt.reporting_pdt_id
2818: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2819: OKL_PRODUCTS pdt --MGAAP 7263041
2820: WHERE chr.id = p_khr_id
2821: AND chr.id = khr.id
2822: AND khr.pdt_id = pdt.id;

Line 2899: OKL_K_HEADERS khr,

2895: --OKL_STREAMS stm,
2896: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2897: OKL_STRM_ELEMENTS ste,
2898: OKL_PROD_STRM_TYPES psty,
2899: OKL_K_HEADERS khr,
2900: OKL_PRODUCTS pdt
2901: WHERE sty.id = p_acceleration_rec.sty_id
2902: AND stm.khr_id = p_acceleration_rec.khr_id
2903: AND stm.kle_id = p_acceleration_rec.kle_id

Line 2935: OKL_K_HEADERS khr,

2931: --OKL_STREAMS stm,
2932: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2933: OKL_STRM_ELEMENTS ste,
2934: OKL_PROD_STRM_TYPES psty,
2935: OKL_K_HEADERS khr,
2936: OKL_PRODUCTS pdt
2937: WHERE sty.id = p_acceleration_rec.sty_id
2938: AND stm.khr_id = p_acceleration_rec.khr_id
2939: AND stm.kle_id = p_acceleration_rec.kle_id

Line 2972: OKL_K_HEADERS khr,

2968: --OKL_STREAMS stm,
2969: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2970: OKL_STRM_ELEMENTS ste,
2971: OKL_PROD_STRM_TYPES psty,
2972: OKL_K_HEADERS khr,
2973: OKL_PRODUCTS pdt
2974: WHERE stm.khr_id = p_acceleration_rec.khr_id
2975: AND khr.id = stm.khr_id
2976: AND sty.id = p_acceleration_rec.sty_id

Line 3009: OKL_K_HEADERS khr,

3005: --OKL_STREAMS stm,
3006: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3007: OKL_STRM_ELEMENTS ste,
3008: OKL_PROD_STRM_TYPES psty,
3009: OKL_K_HEADERS khr,
3010: OKL_PRODUCTS pdt
3011: WHERE stm.khr_id = p_acceleration_rec.khr_id
3012: AND khr.id = stm.khr_id
3013: AND sty.id = p_acceleration_rec.sty_id

Line 4512: FROM okl_k_headers khr

4508: ,khr.attribute12
4509: ,khr.attribute13
4510: ,khr.attribute14
4511: ,khr.attribute15
4512: FROM okl_k_headers khr
4513: WHERE khr.id = p_khr_id;
4514:
4515: --local variables
4516: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

Line 5210: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

5206: p_process_accrual_rec IN process_accrual_rec_type
5207:
5208: )IS
5209:
5210: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

5207:
5208: )IS
5209:
5210: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

5208: )IS
5209:
5210: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

5209:
5210: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

5210: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

5211: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

5212: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

5213: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
5214: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
5215: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
5216: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
5217: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
5218: l_try_id OKL_TRX_TYPES_V.id%TYPE;
5219: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5220: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
5221: l_currency_conv_type OKL_TRX_CONTRACTS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 5324: FROM OKL_K_HEADERS

5320:
5321: -- Cursor to select the last interest calculated date
5322: CURSOR last_int_date_csr(p_khr_id NUMBER) IS
5323: SELECT TRUNC(DATE_LAST_INTERIM_INTEREST_CAL)
5324: FROM OKL_K_HEADERS
5325: WHERE ID = p_khr_id;
5326:
5327:
5328: -- Cursor to select the stream type id for the streams being accrued in case of variable interest rate contracts

Line 5398: FROM OKL_K_HEADERS a,

5394: -- MGAAP start 7263041
5395: CURSOR contract_multigaap_csr (p_contract_id NUMBER) IS
5396: SELECT NVL(a.multi_gaap_yn,'N') multi_gaap_yn,
5397: b.reporting_pdt_id
5398: FROM OKL_K_HEADERS a,
5399: OKL_PRODUCTS b
5400: WHERE a.ID = p_contract_id
5401: AND a.PDT_ID = b.ID;
5402:

Line 5403: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

5399: OKL_PRODUCTS b
5400: WHERE a.ID = p_contract_id
5401: AND a.PDT_ID = b.ID;
5402:
5403: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
5404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
5405: l_tcnv_tbl_cnt NUMBER;
5406: l_sty_id_rep OKL_STRM_TYPE_V.id%TYPE;
5407: -- MGAAP end 7263041

Line 8959: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

8955: ,p_contract_number IN VARCHAR2
8956: ,p_rev_rec_method IN VARCHAR2) IS
8957:
8958: -- declare local variables
8959: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

8956: ,p_rev_rec_method IN VARCHAR2) IS
8957:
8958: -- declare local variables
8959: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

8957:
8958: -- declare local variables
8959: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

8958: -- declare local variables
8959: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

8959: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

8960: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

8961: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

8962: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
8963: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
8964: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
8965: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
8966: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
8967: l_try_id OKL_TRX_TYPES_V.id%TYPE;
8968: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
8969: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
8970: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 9019: OKL_K_HEADERS khr,

9015: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
9016: CURSOR chk_update_header_csr is
9017: SELECT chr.contract_number
9018: FROM OKC_K_HEADERS_B chr,
9019: OKL_K_HEADERS khr,
9020: OKL_PROD_QLTY_VAL_UV pdt
9021: WHERE chr.scs_code = 'LEASE'
9022: AND chr.sts_code IN ('BOOKED','EVERGREEN')
9023: AND chr.id = khr.id

Line 9031: OKL_K_HEADERS khr

9027: -- modified by zrehman for Bug#6788005 on 04-Feb-2008 start
9028: UNION
9029: SELECT chr.contract_number
9030: FROM OKC_K_HEADERS_B chr,
9031: OKL_K_HEADERS khr
9032: WHERE chr.scs_code = 'INVESTOR'
9033: AND chr.sts_code = 'ACTIVE'
9034: AND chr.id = khr.id
9035: ;

Line 9109: OKL_K_HEADERS khr,

9105: ,khr.currency_conversion_type
9106: ,khr.currency_conversion_rate
9107: ,khr.currency_conversion_date
9108: FROM OKC_K_HEADERS_B chr,
9109: OKL_K_HEADERS khr,
9110: OKL_PROD_QLTY_VAL_UV pdt
9111: WHERE chr.contract_number = p_contract_number
9112: AND chr.id = khr.id
9113: AND chr.scs_code = 'LEASE'

Line 9133: OKL_K_HEADERS khr

9129: ,khr.currency_conversion_type
9130: ,khr.currency_conversion_rate
9131: ,khr.currency_conversion_date
9132: FROM OKC_K_HEADERS_B chr,
9133: OKL_K_HEADERS khr
9134: WHERE chr.contract_number = p_contract_number
9135: AND chr.id = khr.id
9136: AND chr.scs_code = 'INVESTOR'
9137: AND chr.sts_code = 'ACTIVE'

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

9148: --AND r.jtot_object1_code = 'OKX_INVRULE'
9149: --AND r.rule_information_category = 'IRE';
9150:
9151: -- declare error placeholders
9152: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
9153: -- Bug 3020763
9154: TYPE accrual_contracts_rec_type IS RECORD(
9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

Line 9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

9151: -- declare error placeholders
9152: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
9153: -- Bug 3020763
9154: TYPE accrual_contracts_rec_type IS RECORD(
9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

Line 9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

9152: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
9153: -- Bug 3020763
9154: TYPE accrual_contracts_rec_type IS RECORD(
9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

Line 9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

9153: -- Bug 3020763
9154: TYPE accrual_contracts_rec_type IS RECORD(
9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

Line 9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

9154: TYPE accrual_contracts_rec_type IS RECORD(
9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

9155: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

Line 9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

9156: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

Line 9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

9157: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

Line 9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

9158: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,

Line 9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

9159: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
9167: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);

Line 9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

9160: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
9167: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
9168:

Line 9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

9161: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
9167: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
9168:
9169: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;

Line 9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,

9162: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
9167: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
9168:
9169: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
9170:

Line 9167: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);

9163: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9164: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9165: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9166: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,
9167: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);
9168:
9169: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
9170:
9171: l_contract_error_tbl contract_error_tbl_type;

Line 9626: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

9622: ,p_batch_name IN VARCHAR2
9623: ,p_worker_id IN VARCHAR2
9624: ,p_rev_rec_method IN VARCHAR2) IS
9625:
9626: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

9623: ,p_worker_id IN VARCHAR2
9624: ,p_rev_rec_method IN VARCHAR2) IS
9625:
9626: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

9624: ,p_rev_rec_method IN VARCHAR2) IS
9625:
9626: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

9625:
9626: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

9626: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

9627: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

9628: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

9629: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
9630: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
9631: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
9632: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
9633: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
9634: l_try_id OKL_TRX_TYPES_V.id%TYPE;
9635: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
9636: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
9637: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 9698: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

9694: ,chr.currency_code
9695: ,khr.currency_conversion_type
9696: ,khr.currency_conversion_rate
9697: ,khr.currency_conversion_date
9698: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
9699: WHERE chr.contract_number = p_khr_num
9700: AND chr.id = khr.id
9701: AND chr.scs_code = 'LEASE'
9702: AND chr.sts_code IN ('BOOKED','EVERGREEN')

Line 9717: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

9713: ,chr.currency_code
9714: ,khr.currency_conversion_type
9715: ,khr.currency_conversion_rate
9716: ,khr.currency_conversion_date
9717: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
9718: WHERE chr.contract_number = p_khr_num
9719: AND chr.id = khr.id
9720: AND chr.scs_code = 'INVESTOR'
9721: AND chr.sts_code = 'ACTIVE'

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

9723: ;
9724:
9725:
9726: -- declare error placeholders
9727: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
9728: -- Bug 3020763
9729: TYPE accrual_contracts_rec_type IS RECORD(
9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

Line 9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

9726: -- declare error placeholders
9727: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
9728: -- Bug 3020763
9729: TYPE accrual_contracts_rec_type IS RECORD(
9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

Line 9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

9727: TYPE contract_error_tbl_type IS TABLE OF okl_k_headers_full_v.CONTRACT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
9728: -- Bug 3020763
9729: TYPE accrual_contracts_rec_type IS RECORD(
9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

Line 9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

9728: -- Bug 3020763
9729: TYPE accrual_contracts_rec_type IS RECORD(
9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

Line 9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

9729: TYPE accrual_contracts_rec_type IS RECORD(
9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

Line 9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

9730: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

Line 9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

9731: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

Line 9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

9732: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,
9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

Line 9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

9733: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,
9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

Line 9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

9734: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
9742:

Line 9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

9735: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,
9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
9742:
9743: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;

Line 9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

9736: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,
9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
9742:
9743: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
9744: TYPE req_id_tbl_type IS TABLE OF FND_CONCURRENT_REQUESTS.request_id%TYPE INDEX BY BINARY_INTEGER;

Line 9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

9737: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
9738: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,
9739: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,
9740: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,
9741: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);
9742:
9743: TYPE accrual_contracts_tbl_type IS TABLE OF accrual_contracts_rec_type INDEX BY BINARY_INTEGER;
9744: TYPE req_id_tbl_type IS TABLE OF FND_CONCURRENT_REQUESTS.request_id%TYPE INDEX BY BINARY_INTEGER;
9745: TYPE contract_number_tbl_type IS TABLE OF OKC_K_HEADERS_B.contract_number%TYPE INDEX BY BINARY_INTEGER;

Line 10018: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

10014: x_msg_data OUT NOCOPY VARCHAR2,
10015: p_accrual_rec IN adjust_accrual_rec_type) IS
10016:
10017: -- declare local variables
10018: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

Line 10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

10015: p_accrual_rec IN adjust_accrual_rec_type) IS
10016:
10017: -- declare local variables
10018: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

Line 10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

10016:
10017: -- declare local variables
10018: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

Line 10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

10017: -- declare local variables
10018: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

10018: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;

Line 10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

10019: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;

Line 10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

10020: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;
10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

10021: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;
10022: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;
10023: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;
10024: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
10025: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
10026: l_try_id OKL_TRX_TYPES_V.id%TYPE;
10027: l_accrual_reversal_days OKL_SYS_ACCT_OPTS.accrual_reversal_days%TYPE;
10028: l_func_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;
10029: l_khr_currency_code OKL_TRX_CONTRACTS.CURRENCY_CODE%TYPE;

Line 10070: OKL_K_HEADERS khr,

10066: ,khr.currency_conversion_rate
10067: ,khr.currency_conversion_date
10068: ,pdt.quality_val revenue_recognition_method
10069: FROM OKC_K_HEADERS_B chr,
10070: OKL_K_HEADERS khr,
10071: OKL_PROD_QLTY_VAL_UV pdt
10072: WHERE chr.id = p_khr_id
10073: AND chr.id = khr.id
10074: AND chr.scs_code = 'LEASE'

Line 10093: OKL_K_HEADERS khr

10089: ,khr.currency_conversion_rate
10090: ,khr.currency_conversion_date
10091: ,'STREAMS' revenue_recognition_method
10092: FROM OKC_K_HEADERS_B chr,
10093: OKL_K_HEADERS khr
10094: WHERE chr.id = p_khr_id
10095: AND chr.id = khr.id
10096: AND chr.scs_code = 'INVESTOR'
10097: AND chr.sts_code = 'ACTIVE'