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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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
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;
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;
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;
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;
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;
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;
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;
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';
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';
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';
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:
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,