3:
4: -- Bug 4110239. sty_id is not supported from 11.5.10+ version
5: -- Removing sty_id parameter as API is not published
6: TYPE glpv_rec_type IS RECORD (
7: product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE,
8: --sty_id OKL_STRM_TYPE_V.ID%TYPE,
9: bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE,
10: entry_date DATE,
11: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
7: product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE,
8: --sty_id OKL_STRM_TYPE_V.ID%TYPE,
9: bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE,
10: entry_date DATE,
11: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
12: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
13: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE);
14:
15:
8: --sty_id OKL_STRM_TYPE_V.ID%TYPE,
9: bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE,
10: entry_date DATE,
11: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
12: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
13: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE);
14:
15:
16: TYPE slpv_rec_type IS RECORD (
9: bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE,
10: entry_date DATE,
11: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
12: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
13: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE);
14:
15:
16: TYPE slpv_rec_type IS RECORD (
17: khr_id OKL_K_HEADERS.ID%TYPE,
15:
16: TYPE slpv_rec_type IS RECORD (
17: khr_id OKL_K_HEADERS.ID%TYPE,
18: sty_id OKL_STRM_TYPE_V.ID%TYPE,
19: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
20: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
21: reverse_flag VARCHAR2(1),
22: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
23: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
16: TYPE slpv_rec_type IS RECORD (
17: khr_id OKL_K_HEADERS.ID%TYPE,
18: sty_id OKL_STRM_TYPE_V.ID%TYPE,
19: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
20: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
21: reverse_flag VARCHAR2(1),
22: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
23: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
24: provision_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE);
18: sty_id OKL_STRM_TYPE_V.ID%TYPE,
19: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
20: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
21: reverse_flag VARCHAR2(1),
22: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
23: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
24: provision_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE);
25:
26:
19: amount OKL_TRX_CONTRACTS.AMOUNT%TYPE,
20: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
21: reverse_flag VARCHAR2(1),
22: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
23: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
24: provision_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE);
25:
26:
27: TYPE bktv_rec_type IS RECORD (
20: description OKL_TRX_CONTRACTS.DESCRIPTION%TYPE,
21: reverse_flag VARCHAR2(1),
22: tax_deductible_local OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_LOCAL%TYPE,
23: tax_deductible_corporate OKL_TRX_CONTRACTS.TAX_DEDUCTIBLE_CORPORATE%TYPE,
24: provision_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE);
25:
26:
27: TYPE bktv_rec_type IS RECORD (
28: aging_bucket_line_id OKX_AGING_BUCKETS_V.aging_bucket_line_id%TYPE