2: /* $Header: OKLSTAXS.pls 120.3 2006/07/11 10:31:36 dkagrawa noship $ */
3: ---------------------------------------------------------------------------
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
3: ---------------------------------------------------------------------------
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
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
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
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
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
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
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
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;
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;
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
62: TYPE tax_rec_type IS RECORD (
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
62: TYPE tax_rec_type IS RECORD (
63: id NUMBER := OKC_API.G_MISS_NUM
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
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
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
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
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
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
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
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
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;
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;
152: p_init_msg_list IN VARCHAR2,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
157: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type);
158: PROCEDURE insert_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
157: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type);
158: PROCEDURE insert_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2,
161: x_return_status OUT NOCOPY VARCHAR2,
160: p_init_msg_list IN VARCHAR2,
161: x_return_status OUT NOCOPY VARCHAR2,
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,
161: x_return_status OUT NOCOPY VARCHAR2,
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,
169: p_init_msg_list IN VARCHAR2,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
174: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type);
175: PROCEDURE lock_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
174: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type);
175: PROCEDURE lock_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2,
178: x_return_status OUT NOCOPY VARCHAR2,
177: p_init_msg_list IN VARCHAR2,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type);
182: PROCEDURE lock_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2,
185: x_return_status OUT NOCOPY VARCHAR2,
184: p_init_msg_list IN 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,
192: p_init_msg_list IN VARCHAR2,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_msg_count OUT NOCOPY NUMBER,
195: x_msg_data OUT NOCOPY VARCHAR2,
196: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type);
197: PROCEDURE update_row(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
199: p_init_msg_list IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
204: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type);
205: PROCEDURE update_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type,
204: x_OKL_TAX_LINES_rec OUT NOCOPY OKL_TAX_LINES_rec_type);
205: PROCEDURE update_row(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2,
208: x_return_status OUT NOCOPY VARCHAR2,
207: p_init_msg_list IN VARCHAR2,
208: 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,
208: 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,
216: p_init_msg_list IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
221: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type);
222: PROCEDURE delete_row(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type,
221: x_OKL_TAX_LINES_tbl OUT NOCOPY OKL_TAX_LINES_tbl_type);
222: PROCEDURE delete_row(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2,
225: x_return_status OUT NOCOPY VARCHAR2,
224: p_init_msg_list IN VARCHAR2,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type);
229: PROCEDURE delete_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2,
232: x_return_status OUT NOCOPY VARCHAR2,
231: p_init_msg_list IN 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,
239: p_init_msg_list IN VARCHAR2,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type);
244: PROCEDURE validate_row(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2,
247: x_return_status OUT NOCOPY VARCHAR2,
246: p_init_msg_list IN VARCHAR2,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_OKL_TAX_LINES_rec IN OKL_TAX_LINES_rec_type);
251: PROCEDURE validate_row(
252: p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2,
254: x_return_status OUT NOCOPY VARCHAR2,
253: p_init_msg_list IN 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,
261: p_init_msg_list IN VARCHAR2,
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
265: p_OKL_TAX_LINES_tbl IN OKL_TAX_LINES_tbl_type);
266: END OKL_TAX_PVT;