3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE try_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: try_id NUMBER := OKC_API.G_MISS_NUM,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE try_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: try_id NUMBER := OKC_API.G_MISS_NUM,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE try_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: try_id NUMBER := OKC_API.G_MISS_NUM,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
6: TYPE try_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: try_id NUMBER := OKC_API.G_MISS_NUM,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: try_id NUMBER := OKC_API.G_MISS_NUM,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
8: try_id NUMBER := OKC_API.G_MISS_NUM,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
9: try_id_for NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
10: ilc_id NUMBER := OKC_API.G_MISS_NUM,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
11: aep_code OKL_TRX_TYPES_B.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
12: try_type OKL_TRX_TYPES_B.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
14: org_id NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
22: --Bug 4386433 - Start of Changes
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
22: --Bug 4386433 - Start of Changes
23: tax_upfront_yn OKL_TRX_TYPES_B.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
16: creation_date OKL_TRX_TYPES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKL_TRX_TYPES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
22: --Bug 4386433 - Start of Changes
23: tax_upfront_yn OKL_TRX_TYPES_B.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
24: tax_invoice_yn OKL_TRX_TYPES_B.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
22: --Bug 4386433 - Start of Changes
23: tax_upfront_yn OKL_TRX_TYPES_B.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
24: tax_invoice_yn OKL_TRX_TYPES_B.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
25: tax_schedule_yn OKL_TRX_TYPES_B.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
26: --Bug 4386433 -End of Changes
27: --Bug 5707866 dpsingh
20: trx_type_class OKL_TRX_TYPES_B.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
22: --Bug 4386433 - Start of Changes
23: tax_upfront_yn OKL_TRX_TYPES_B.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
24: tax_invoice_yn OKL_TRX_TYPES_B.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
25: tax_schedule_yn OKL_TRX_TYPES_B.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
26: --Bug 4386433 -End of Changes
27: --Bug 5707866 dpsingh
28: formula_yn OKL_TRX_TYPES_B.FORMULA_YN%TYPE := OKL_API.G_MISS_CHAR,
21: --Added by kthiruva on 04-May-2005 for Tax Enhancements
22: --Bug 4386433 - Start of Changes
23: tax_upfront_yn OKL_TRX_TYPES_B.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
24: tax_invoice_yn OKL_TRX_TYPES_B.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
25: tax_schedule_yn OKL_TRX_TYPES_B.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
26: --Bug 4386433 -End of Changes
27: --Bug 5707866 dpsingh
28: formula_yn OKL_TRX_TYPES_B.FORMULA_YN%TYPE := OKL_API.G_MISS_CHAR,
29: accounting_event_class_code OKL_TRX_TYPES_B.ACCOUNTING_EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
31: g_miss_try_rec try_rec_type;
32: TYPE try_tbl_type IS TABLE OF try_rec_type
33: INDEX BY BINARY_INTEGER;
34: TYPE okl_trx_types_tl_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
32: TYPE try_tbl_type IS TABLE OF try_rec_type
33: INDEX BY BINARY_INTEGER;
34: TYPE okl_trx_types_tl_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
33: INDEX BY BINARY_INTEGER;
34: TYPE okl_trx_types_tl_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
34: TYPE okl_trx_types_tl_rec_type IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM,
36: LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
35: id NUMBER := OKC_API.G_MISS_NUM,
36: LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
36: LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: source_lang OKL_TRX_TYPES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: sfwt_flag OKL_TRX_TYPES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: name OKL_TRX_TYPES_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: description OKL_TRX_TYPES_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
41: contract_header_line_flag OKL_TRX_TYPES_TL.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
49: TYPE okl_trx_types_tl_tbl_type IS TABLE OF okl_trx_types_tl_rec_type
42: transaction_header_line_detail OKL_TRX_TYPES_TL.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
49: TYPE okl_trx_types_tl_tbl_type IS TABLE OF okl_trx_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
43: created_by NUMBER := OKC_API.G_MISS_NUM,
44: creation_date OKL_TRX_TYPES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46: last_update_date OKL_TRX_TYPES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47: last_update_login NUMBER := OKC_API.G_MISS_NUM);
48: g_miss_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
49: TYPE okl_trx_types_tl_tbl_type IS TABLE OF okl_trx_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE tryv_rec_type IS RECORD (
48: g_miss_okl_trx_types_tl_rec okl_trx_types_tl_rec_type;
49: TYPE okl_trx_types_tl_tbl_type IS TABLE OF okl_trx_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE tryv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
49: TYPE okl_trx_types_tl_tbl_type IS TABLE OF okl_trx_types_tl_rec_type
50: INDEX BY BINARY_INTEGER;
51: TYPE tryv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
50: INDEX BY BINARY_INTEGER;
51: TYPE tryv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
51: TYPE tryv_rec_type IS RECORD (
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
52: id NUMBER := OKC_API.G_MISS_NUM,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
53: object_version_number NUMBER := OKC_API.G_MISS_NUM,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
54: sfwt_flag OKL_TRX_TYPES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
55: aep_code OKL_TRX_TYPES_V.AEP_CODE%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
56: ilc_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
57: try_id NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
58: try_id_for NUMBER := OKC_API.G_MISS_NUM,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59: try_type OKL_TRX_TYPES_V.TRY_TYPE%TYPE := OKC_API.G_MISS_CHAR,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
60: name OKL_TRX_TYPES_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61: description OKL_TRX_TYPES_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
62: contract_header_line_flag OKL_TRX_TYPES_V.CONTRACT_HEADER_LINE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
63: transaction_header_line_detail OKL_TRX_TYPES_V.TRANSACTION_HEADER_LINE_DETAIL%TYPE := OKC_API.G_MISS_CHAR,
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
64: org_id NUMBER := OKC_API.G_MISS_NUM,
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
72: --Bug 4386433 - Start of Changes
65: created_by NUMBER := OKC_API.G_MISS_NUM,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
72: --Bug 4386433 - Start of Changes
73: tax_upfront_yn OKL_TRX_TYPES_V.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
66: creation_date OKL_TRX_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
67: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
68: last_update_date OKL_TRX_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
72: --Bug 4386433 - Start of Changes
73: tax_upfront_yn OKL_TRX_TYPES_V.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: tax_invoice_yn OKL_TRX_TYPES_V.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
69: last_update_login NUMBER := OKC_API.G_MISS_NUM,
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
72: --Bug 4386433 - Start of Changes
73: tax_upfront_yn OKL_TRX_TYPES_V.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: tax_invoice_yn OKL_TRX_TYPES_V.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: tax_schedule_yn OKL_TRX_TYPES_V.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
76: --Bug 4386433 - End of Changes
77: --Bug 5707866 dpsingh
70: trx_type_class OKL_TRX_TYPES_V.TRX_TYPE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
72: --Bug 4386433 - Start of Changes
73: tax_upfront_yn OKL_TRX_TYPES_V.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: tax_invoice_yn OKL_TRX_TYPES_V.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: tax_schedule_yn OKL_TRX_TYPES_V.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
76: --Bug 4386433 - End of Changes
77: --Bug 5707866 dpsingh
78: formula_yn OKL_TRX_TYPES_B.FORMULA_YN%TYPE := OKL_API.G_MISS_CHAR,
71: --Added by kthiruva on 04-May-2005 for Tax Enhancements
72: --Bug 4386433 - Start of Changes
73: tax_upfront_yn OKL_TRX_TYPES_V.TAX_UPFRONT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: tax_invoice_yn OKL_TRX_TYPES_V.TAX_INVOICE_YN%TYPE := OKC_API.G_MISS_CHAR,
75: tax_schedule_yn OKL_TRX_TYPES_V.TAX_SCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR,
76: --Bug 4386433 - End of Changes
77: --Bug 5707866 dpsingh
78: formula_yn OKL_TRX_TYPES_B.FORMULA_YN%TYPE := OKL_API.G_MISS_CHAR,
79: accounting_event_class_code OKL_TRX_TYPES_B.ACCOUNTING_EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
83: INDEX BY BINARY_INTEGER;
84: ---------------------------------------------------------------------------
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: ---------------------------------------------------------------------------
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: -- GLOBAL MESSAGE CONSTANTS
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: ---------------------------------------------------------------------------
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
90: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
98: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
91: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
98: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
99: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
92: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
93: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
94: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
95: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
96: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
97: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
98: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
99: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
100: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
106: ---------------------------------------------------------------------------
107: -- GLOBAL VARIABLES
108: ---------------------------------------------------------------------------
109: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TRY_PVT';
110: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
111: ---------------------------------------------------------------------------
112: -- Procedures and Functions
113: ---------------------------------------------------------------------------
114:
117: PROCEDURE api_copy;
118: PROCEDURE add_language;
119: PROCEDURE insert_row(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_tryv_rec IN tryv_rec_type,
126: x_tryv_rec OUT NOCOPY tryv_rec_type);
127:
128: PROCEDURE insert_row(
129: p_api_version IN NUMBER,
130: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
134: p_tryv_tbl IN tryv_tbl_type,
135: x_tryv_tbl OUT NOCOPY tryv_tbl_type);
136:
137: PROCEDURE lock_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_tryv_rec IN tryv_rec_type);
143: p_tryv_rec IN tryv_rec_type);
144:
145: PROCEDURE lock_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_tryv_tbl IN tryv_tbl_type);
151: p_tryv_tbl IN tryv_tbl_type);
152:
153: PROCEDURE update_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_tryv_rec IN tryv_rec_type,
160: x_tryv_rec OUT NOCOPY tryv_rec_type);
161:
162: PROCEDURE update_row(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_tryv_tbl IN tryv_tbl_type,
169: x_tryv_tbl OUT NOCOPY tryv_tbl_type);
170:
171: PROCEDURE delete_row(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_tryv_rec IN tryv_rec_type);
177: p_tryv_rec IN tryv_rec_type);
178:
179: PROCEDURE delete_row(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_tryv_tbl IN tryv_tbl_type);
185: p_tryv_tbl IN tryv_tbl_type);
186:
187: PROCEDURE validate_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_tryv_rec IN tryv_rec_type);
193: p_tryv_rec IN tryv_rec_type);
194:
195: PROCEDURE validate_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_tryv_tbl IN tryv_tbl_type);