DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_API

Line 6: subsidy_id NUMBER := OKL_API.G_MISS_NUM,

2: /* $Header: OKLRSBPS.pls 120.3 2006/04/05 21:45:25 stmathew noship $ */
3:
4: -- OKL_ASSET_SUBSIDIES_UV Record Spec
5: TYPE asbv_rec_type IS RECORD (
6: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,

Line 7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,

3:
4: -- OKL_ASSET_SUBSIDIES_UV Record Spec
5: TYPE asbv_rec_type IS RECORD (
6: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,

Line 8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,

4: -- OKL_ASSET_SUBSIDIES_UV Record Spec
5: TYPE asbv_rec_type IS RECORD (
6: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,

Line 9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,

5: TYPE asbv_rec_type IS RECORD (
6: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,

Line 10: amount NUMBER := OKL_API.G_MISS_NUM,

6: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,

Line 11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,

7: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

Line 12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,

8: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,

Line 13: maximum_term NUMBER := OKL_API.G_MISS_NUM,

9: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,

Line 14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,

10: amount NUMBER := OKL_API.G_MISS_NUM,
11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,

Line 15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

11: stream_type_id NUMBER := OKL_API.G_MISS_NUM,
12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,

Line 16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,

12: accounting_method_code OKL_SUBSIDIES_B.ACCOUNTING_METHOD_CODE%TYPE := OKL_API.G_MISS_CHAR,
13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,

Line 17: cpl_id NUMBER := OKL_API.G_MISS_NUM,

13: maximum_term NUMBER := OKL_API.G_MISS_NUM,
14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,

Line 18: vendor_id NUMBER := OKL_API.G_MISS_NUM,

14: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,

Line 19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,

15: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,

Line 20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,

16: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream

Line 21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,

17: cpl_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,

Line 22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,

18: vendor_id NUMBER := OKL_API.G_MISS_NUM,
19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,

Line 23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,

19: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR,
20: pay_site_id NUMBER := OKL_API.G_MISS_NUM,
21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,

Line 25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,

21: payment_term_id NUMBER := OKL_API.G_MISS_NUM,
22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,

Line 26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,

22: payment_method_code FND_LOOKUPS.LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,

Line 27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,

23: pay_group_code PO_VENDORS.PAY_GROUP_LOOKUP_CODE%TYPE := OKL_API.G_MISS_CHAR,
24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,

Line 28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,

24: --extra attributes picked up from subsidy setup may be required downstream
25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,

Line 29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,

25: start_date OKC_K_LINES_B.start_date%TYPE := OKL_API.G_MISS_DATE,
26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,

Line 30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,

26: end_date OKC_K_LINES_B.end_date%TYPE := OKL_API.G_MISS_DATE,
27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,
34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,

Line 31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,

27: expire_after_days NUMBER := OKL_API.G_MISS_NUM,
28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,
34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,
35: customer_visible_yn OKL_SUBSIDIES_B.customer_visible_yn%TYPE := OKL_API.G_MISS_CHAR

Line 32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,

28: currency_code OKC_K_LINES_B.currency_code%TYPE := OKL_API.G_MISS_CHAR,
29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,
34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,
35: customer_visible_yn OKL_SUBSIDIES_B.customer_visible_yn%TYPE := OKL_API.G_MISS_CHAR
36: );

Line 33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,

29: exclusive_yn OKL_SUBSIDIES_B.EXCLUSIVE_YN%TYPE := OKL_API.G_MISS_CHAR,
30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,
34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,
35: customer_visible_yn OKL_SUBSIDIES_B.customer_visible_yn%TYPE := OKL_API.G_MISS_CHAR
36: );
37:

Line 34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,

30: applicable_to_release_yn OKL_SUBSIDIES_B.APPLICABLE_TO_RELEASE_YN%TYPE := OKL_API.G_MISS_CHAR,
31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,
34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,
35: customer_visible_yn OKL_SUBSIDIES_B.customer_visible_yn%TYPE := OKL_API.G_MISS_CHAR
36: );
37:
38: TYPE asbv_tbl_type IS TABLE OF asbv_rec_type

Line 35: customer_visible_yn OKL_SUBSIDIES_B.customer_visible_yn%TYPE := OKL_API.G_MISS_CHAR

31: recourse_yn OKL_SUBSIDIES_B.RECOURSE_YN%TYPE := OKL_API.G_MISS_CHAR,
32: termination_refund_basis OKL_SUBSIDIES_B.termination_refund_basis%TYPE := OKL_API.G_MISS_CHAR,
33: refund_formula_id NUMBER := OKL_API.G_MISS_NUM,
34: receipt_method_code OKL_SUBSIDIES_B.receipt_method_code%TYPE := OKL_API.G_MISS_CHAR,
35: customer_visible_yn OKL_SUBSIDIES_B.customer_visible_yn%TYPE := OKL_API.G_MISS_CHAR
36: );
37:
38: TYPE asbv_tbl_type IS TABLE OF asbv_rec_type
39: INDEX BY BINARY_INTEGER;

Line 47: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

43: G_STREAM_TYPE_CLASS OKL_STRM_TYPE_B.STREAM_TYPE_CLASS%TYPE := 'SUBSIDY';
44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

44: ---------------------------------------------------------------------------
45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

45: -- GLOBAL MESSAGE CONSTANTS
46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

46: ---------------------------------------------------------------------------
47: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

47: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

48: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

49: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
57: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';

Line 54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

50: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
57: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

51: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
57: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
59: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

52: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
53: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
54: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
55: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
56: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
57: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
58: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
59: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
60:

Line 70: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

66: ---------------------------------------------------------------------------
67: -- GLOBAL VARIABLES
68: ---------------------------------------------------------------------------
69: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUBSIDY_PROCESS_PVT';
70: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
71:
72:
73: PROCEDURE is_contract_subsidized(
74: p_api_version IN NUMBER,