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_FULL_V

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