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

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

Line 382: OKL_K_HEADERS_FULL_V khr

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

Line 389: FROM OKL_K_HEADERS_FULL_V khr

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

Line 473: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 1511: okl_k_headers_full_v khr

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

Line 2330: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 2331: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

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

Line 2336: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

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

Line 2337: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;

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

Line 2338: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

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

Line 2344: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

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

Line 2345: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

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

Line 2346: l_generate_accrual_yn OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

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

Line 2347: l_generate_accrual_override_yn OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

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

Line 2348: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

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

Line 2956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 2957: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

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

Line 2964: l_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

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

Line 2965: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

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

Line 2966: l_currency_conversion_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE;

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

Line 2967: l_currency_conversion_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;

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

Line 6087: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

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

Line 6088: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 6089: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

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

Line 6090: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

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

Line 6091: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

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

Line 6092: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

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

Line 6093: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

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

Line 6094: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

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

Line 9955: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

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

Line 9956: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 9957: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

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

Line 9958: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

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

Line 9959: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

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

Line 9960: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

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

Line 9961: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

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

Line 9962: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

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

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

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

Line 10151: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

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

Line 10152: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

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

Line 10153: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

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

Line 10154: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

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

Line 10155: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

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

Line 10156: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

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

Line 10157: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

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

Line 10158: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

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

Line 10159: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

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

Line 10160: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

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

Line 10161: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

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

Line 10162: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE,

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

Line 10163: org_id OKL_K_HEADERS_FULL_V.AUTHORING_ORG_ID%TYPE);

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

Line 10622: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

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

Line 10623: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 10624: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

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

Line 10625: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

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

Line 10626: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

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

Line 10627: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

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

Line 10628: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

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

Line 10629: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

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

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

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

Line 10726: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,

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

Line 10727: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,

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

Line 10728: start_date OKL_K_HEADERS_FULL_V.START_DATE%TYPE,

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

Line 10729: sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE,

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

Line 10730: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,

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

Line 10731: accrual_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_YN%TYPE,

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

Line 10732: override_status OKL_K_HEADERS_FULL_V.GENERATE_ACCRUAL_OVERRIDE_YN%TYPE,

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

Line 10733: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,

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

Line 10734: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE,

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

Line 10735: currency_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE,

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

Line 10736: currency_conv_rate OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_RATE%TYPE,

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

Line 10737: currency_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE);

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

Line 11014: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;

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

Line 11015: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;

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

Line 11016: l_accrual_status OKL_K_HEADERS_FULL_V.generate_accrual_yn%TYPE;

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

Line 11017: l_override_status OKL_K_HEADERS_FULL_V.generate_accrual_override_yn%TYPE;

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

Line 11018: l_start_date OKL_K_HEADERS_FULL_V.start_date%TYPE;

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

Line 11019: l_sts_code OKL_K_HEADERS_FULL_V.sts_code%TYPE;

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

Line 11020: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;

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

Line 11021: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

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