4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_TAX_LINES_V Record Spec
7: TYPE OKL_TAX_LINES_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,khr_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_TAX_LINES_V Record Spec
7: TYPE OKL_TAX_LINES_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,khr_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
6: -- OKL_TAX_LINES_V Record Spec
7: TYPE OKL_TAX_LINES_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,khr_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE OKL_TAX_LINES_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,khr_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,khr_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
9: ,khr_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
10: ,kle_id NUMBER := OKC_API.G_MISS_NUM
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
11: ,asset_id NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
12: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
13: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
14: ,sel_id NUMBER := OKC_API.G_MISS_NUM
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
15: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
16: ,tax_type NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
17: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
18: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
19: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
20: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
21: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
22: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
23: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
24: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
25: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
26: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
27: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
28: ,org_id NUMBER := OKC_API.G_MISS_NUM
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
29: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
30: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
31: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
32: ,trq_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
33: ,program_id NUMBER := OKC_API.G_MISS_NUM
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
35: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
36: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
43: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
44: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
45: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
46: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
47: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
48: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
49: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
50: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
51: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
59: TYPE OKL_TAX_LINES_tbl_type IS TABLE OF OKL_TAX_LINES_rec_type
52: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
59: TYPE OKL_TAX_LINES_tbl_type IS TABLE OF OKL_TAX_LINES_rec_type
60: INDEX BY BINARY_INTEGER;
53: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
58: G_MISS_OKL_TAX_LINES_rec OKL_TAX_LINES_rec_type;
59: TYPE OKL_TAX_LINES_tbl_type IS TABLE OF OKL_TAX_LINES_rec_type
60: INDEX BY BINARY_INTEGER;
61: -- OKL_TAX_LINES Record Spec
59: TYPE OKL_TAX_LINES_tbl_type IS TABLE OF OKL_TAX_LINES_rec_type
60: INDEX BY BINARY_INTEGER;
61: -- OKL_TAX_LINES Record Spec
62: TYPE tax_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM
64: ,khr_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
60: INDEX BY BINARY_INTEGER;
61: -- OKL_TAX_LINES Record Spec
62: TYPE tax_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM
64: ,khr_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: -- OKL_TAX_LINES Record Spec
62: TYPE tax_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM
64: ,khr_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
62: TYPE tax_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM
64: ,khr_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
63: id NUMBER := OKC_API.G_MISS_NUM
64: ,khr_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
64: ,khr_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
65: ,kle_id NUMBER := OKC_API.G_MISS_NUM
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,asset_id NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
67: ,asset_number OKL_TAX_LINES.ASSET_NUMBER%TYPE := OKC_API.G_MISS_CHAR
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
68: ,tax_line_type OKL_TAX_LINES.TAX_LINE_TYPE%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
69: ,sel_id NUMBER := OKC_API.G_MISS_NUM
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
70: ,tax_due_date OKL_TAX_LINES.TAX_DUE_DATE%TYPE := OKC_API.G_MISS_DATE
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
71: ,tax_type NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
72: ,tax_rate_code_id NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
73: ,tax_rate_code OKL_TAX_LINES.TAX_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
74: ,taxable_amount NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
75: ,tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
76: ,manually_entered_flag OKL_TAX_LINES.MANUALLY_ENTERED_FLAG%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
77: ,overridden_flag OKL_TAX_LINES.OVERRIDDEN_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
78: ,calculated_tax_amount NUMBER := OKC_API.G_MISS_NUM
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
79: ,tax_rate NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
80: ,tax_amount NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
81: ,sales_tax_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
82: ,source_trx_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
83: ,org_id NUMBER := OKC_API.G_MISS_NUM
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
84: ,history_yn OKL_TAX_LINES.HISTORY_YN%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
85: ,actual_yn OKL_TAX_LINES.ACTUAL_YN%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
86: ,source_name OKL_TAX_LINES.SOURCE_NAME%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
87: ,trq_id NUMBER := OKC_API.G_MISS_NUM
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
88: ,program_id NUMBER := OKC_API.G_MISS_NUM
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
89: ,request_id NUMBER := OKC_API.G_MISS_NUM
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
90: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
91: ,program_update_date OKL_TAX_LINES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
92: ,attribute_category OKL_TAX_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
93: ,attribute1 OKL_TAX_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
94: ,attribute2 OKL_TAX_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
95: ,attribute3 OKL_TAX_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
96: ,attribute4 OKL_TAX_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
97: ,attribute5 OKL_TAX_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
98: ,attribute6 OKL_TAX_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
99: ,attribute7 OKL_TAX_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
100: ,attribute8 OKL_TAX_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
101: ,attribute9 OKL_TAX_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
102: ,attribute10 OKL_TAX_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
103: ,attribute11 OKL_TAX_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
104: ,attribute12 OKL_TAX_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
112: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
105: ,attribute13 OKL_TAX_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
112: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_tax_rec tax_rec_type;
106: ,attribute14 OKL_TAX_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
112: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_tax_rec tax_rec_type;
114: TYPE tax_tbl_type IS TABLE OF tax_rec_type
107: ,attribute15 OKL_TAX_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
112: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_tax_rec tax_rec_type;
114: TYPE tax_tbl_type IS TABLE OF tax_rec_type
115: INDEX BY BINARY_INTEGER;
108: ,created_by NUMBER := OKC_API.G_MISS_NUM
109: ,creation_date OKL_TAX_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
110: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
111: ,last_update_date OKL_TAX_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
112: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
113: G_MISS_tax_rec tax_rec_type;
114: TYPE tax_tbl_type IS TABLE OF tax_rec_type
115: INDEX BY BINARY_INTEGER;
116: ---------------------------------------------------------------------------
115: INDEX BY BINARY_INTEGER;
116: ---------------------------------------------------------------------------
117: -- GLOBAL MESSAGE CONSTANTS
118: ---------------------------------------------------------------------------
119: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
120: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: ---------------------------------------------------------------------------
117: -- GLOBAL MESSAGE CONSTANTS
118: ---------------------------------------------------------------------------
119: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
120: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: -- GLOBAL MESSAGE CONSTANTS
118: ---------------------------------------------------------------------------
119: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
120: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: ---------------------------------------------------------------------------
119: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
120: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
120: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
128: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
128: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
129: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
122: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
128: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
129: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
130: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
123: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
128: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
129: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
130: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
131: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
124: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
125: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
126: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
127: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
128: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
129: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
130: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
131: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
132:
138: ---------------------------------------------------------------------------
139: -- GLOBAL VARIABLES
140: ---------------------------------------------------------------------------
141: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TAX_PVT';
142: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
143: ---------------------------------------------------------------------------
144: -- Procedures and Functions
145: ---------------------------------------------------------------------------
146:
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
165: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
166: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
167: PROCEDURE insert_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2,
170: x_return_status OUT NOCOPY VARCHAR2,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
189: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
190: PROCEDURE lock_row(
191: p_api_version IN NUMBER,
192: p_init_msg_list IN VARCHAR2,
193: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
212: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type,
213: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
214: PROCEDURE update_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
236: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
237: PROCEDURE delete_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2,
240: x_return_status OUT NOCOPY VARCHAR2,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
258: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
259: PROCEDURE validate_row(
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2,
262: x_return_status OUT NOCOPY VARCHAR2,