4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_TAX_TRX_DETAILS_V Record Spec
7: TYPE ttdv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,txs_id NUMBER := OKL_API.G_MISS_NUM
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- OKL_TAX_TRX_DETAILS_V Record Spec
7: TYPE ttdv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,txs_id NUMBER := OKL_API.G_MISS_NUM
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
6: -- OKL_TAX_TRX_DETAILS_V Record Spec
7: TYPE ttdv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,txs_id NUMBER := OKL_API.G_MISS_NUM
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
7: TYPE ttdv_rec_type IS RECORD (
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,txs_id NUMBER := OKL_API.G_MISS_NUM
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
8: id NUMBER := OKL_API.G_MISS_NUM
9: ,txs_id NUMBER := OKL_API.G_MISS_NUM
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
9: ,txs_id NUMBER := OKL_API.G_MISS_NUM
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
10: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
11: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
12: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
13: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
14: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
15: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
16: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
17: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
18: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
19: ,program_id NUMBER := OKL_API.G_MISS_NUM
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
20: ,request_id NUMBER := OKL_API.G_MISS_NUM
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
21: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
22: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
23: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
24: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
25: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
26: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
27: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
28: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
29: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
30: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
31: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
32: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
33: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
34: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
35: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
36: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
37: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
38: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
39: ,created_by NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
40: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
41: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
42: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
43: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
44: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
45: -- Modified by dcshanmu for eBTax - modification starts
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
46: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
47: ,line_amt NUMBER := OKL_API.G_MISS_NUM
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
48: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
49: ,application_id NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
50: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
51: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
52: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
53: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
54: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
55: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
56: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
57: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
58: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
59: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
60: ,tax_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
61: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
62: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
63: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
64: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
65: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
66: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
67: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
68: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
69: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
70: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
78: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
71: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
78: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
79: -- Modified by dcshanmu for eBTax - modification end
72: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
78: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
79: -- Modified by dcshanmu for eBTax - modification end
80: GMissOklTaxTrxDetailsVRec ttdv_rec_type;
73: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
78: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
79: -- Modified by dcshanmu for eBTax - modification end
80: GMissOklTaxTrxDetailsVRec ttdv_rec_type;
81: TYPE ttdv_tbl_type IS TABLE OF ttdv_rec_type
74: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
75: ,precision NUMBER := OKL_API.G_MISS_NUM
76: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
77: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
78: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
79: -- Modified by dcshanmu for eBTax - modification end
80: GMissOklTaxTrxDetailsVRec ttdv_rec_type;
81: TYPE ttdv_tbl_type IS TABLE OF ttdv_rec_type
82: INDEX BY BINARY_INTEGER;
81: TYPE ttdv_tbl_type IS TABLE OF ttdv_rec_type
82: INDEX BY BINARY_INTEGER;
83: -- OKL_TAX_TRX_DETAILS Record Spec
84: TYPE ttd_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM
86: ,txs_id NUMBER := OKL_API.G_MISS_NUM
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
82: INDEX BY BINARY_INTEGER;
83: -- OKL_TAX_TRX_DETAILS Record Spec
84: TYPE ttd_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM
86: ,txs_id NUMBER := OKL_API.G_MISS_NUM
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
83: -- OKL_TAX_TRX_DETAILS Record Spec
84: TYPE ttd_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM
86: ,txs_id NUMBER := OKL_API.G_MISS_NUM
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
84: TYPE ttd_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM
86: ,txs_id NUMBER := OKL_API.G_MISS_NUM
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
85: id NUMBER := OKL_API.G_MISS_NUM
86: ,txs_id NUMBER := OKL_API.G_MISS_NUM
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
86: ,txs_id NUMBER := OKL_API.G_MISS_NUM
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
87: ,tax_determine_date OKL_TAX_TRX_DETAILS.TAX_DETERMINE_DATE%TYPE := OKL_API.G_MISS_DATE
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
88: ,tax_rate_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
89: ,tax_rate_code OKL_TAX_TRX_DETAILS.TAX_RATE_CODE%TYPE := OKL_API.G_MISS_CHAR
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
90: ,taxable_amt NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
91: ,tax_exemption_id NUMBER := OKL_API.G_MISS_NUM
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
92: ,tax_rate NUMBER := OKL_API.G_MISS_NUM
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
93: ,tax_amt NUMBER := OKL_API.G_MISS_NUM
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
94: ,billed_yn OKL_TAX_TRX_DETAILS.BILLED_YN%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
95: ,tax_call_type_code OKL_TAX_TRX_DETAILS.TAX_CALL_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
96: ,program_id NUMBER := OKL_API.G_MISS_NUM
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
97: ,request_id NUMBER := OKL_API.G_MISS_NUM
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
98: ,program_application_id NUMBER := OKL_API.G_MISS_NUM
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
99: ,program_update_date OKL_TAX_TRX_DETAILS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
100: ,attribute_category OKL_TAX_TRX_DETAILS.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
101: ,attribute1 OKL_TAX_TRX_DETAILS.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
102: ,attribute2 OKL_TAX_TRX_DETAILS.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
103: ,attribute3 OKL_TAX_TRX_DETAILS.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
104: ,attribute4 OKL_TAX_TRX_DETAILS.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
105: ,attribute5 OKL_TAX_TRX_DETAILS.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
106: ,attribute6 OKL_TAX_TRX_DETAILS.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
107: ,attribute7 OKL_TAX_TRX_DETAILS.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
108: ,attribute8 OKL_TAX_TRX_DETAILS.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
109: ,attribute9 OKL_TAX_TRX_DETAILS.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
110: ,attribute10 OKL_TAX_TRX_DETAILS.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
111: ,attribute11 OKL_TAX_TRX_DETAILS.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
112: ,attribute12 OKL_TAX_TRX_DETAILS.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
113: ,attribute13 OKL_TAX_TRX_DETAILS.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
114: ,attribute14 OKL_TAX_TRX_DETAILS.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
115: ,attribute15 OKL_TAX_TRX_DETAILS.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
116: ,created_by NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
117: ,creation_date OKL_TAX_TRX_DETAILS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
118: ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
119: ,last_update_date OKL_TAX_TRX_DETAILS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
120: ,last_update_login NUMBER := OKL_API.G_MISS_NUM
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
121: ,object_version_number NUMBER := OKL_API.G_MISS_NUM
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
122: -- Modified by dcshanmu for eBTax - modification starts
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
123: ,tax_date OKL_TAX_TRX_DETAILS.TAX_DATE%TYPE := OKL_API.G_MISS_DATE
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
124: ,line_amt NUMBER := OKL_API.G_MISS_NUM
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
125: ,internal_organization_id NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
126: ,application_id NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
127: ,entity_code OKL_TAX_TRX_DETAILS.ENTITY_CODE%TYPE := OKL_API.G_MISS_CHAR
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
128: ,event_class_code OKL_TAX_TRX_DETAILS.EVENT_CLASS_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
129: ,event_type_code OKL_TAX_TRX_DETAILS.EVENT_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
130: ,trx_id NUMBER :=OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
131: ,trx_line_id NUMBER := OKL_API.G_MISS_CHAR
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
132: ,trx_level_type OKL_TAX_TRX_DETAILS.TRX_LEVEL_TYPE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
133: ,trx_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
134: ,tax_line_number NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
135: ,tax_regime_id NUMBER := OKL_API.G_MISS_NUM
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
136: ,tax_regime_code OKL_TAX_TRX_DETAILS.TAX_REGIME_CODE%TYPE := OKL_API.G_MISS_CHAR
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
137: ,tax_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
138: ,tax OKL_TAX_TRX_DETAILS.TAX%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
139: ,tax_status_id NUMBER := OKL_API.G_MISS_NUM
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
140: ,tax_status_code OKL_TAX_TRX_DETAILS.TAX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
141: ,tax_apportionment_line_number NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
142: ,legal_entity_id NUMBER := OKL_API.G_MISS_NUM
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
143: ,trx_number OKL_TAX_TRX_DETAILS.TRX_NUMBER%TYPE := OKL_API.G_MISS_CHAR
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
144: ,trx_date OKL_TAX_TRX_DETAILS.TRX_DATE%TYPE := OKL_API.G_MISS_DATE
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
145: ,tax_jurisdiction_id NUMBER := OKL_API.G_MISS_NUM
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
146: ,tax_jurisdiction_code OKL_TAX_TRX_DETAILS.TAX_JURISDICTION_CODE%TYPE := OKL_API.G_MISS_CHAR
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
147: ,tax_type_code OKL_TAX_TRX_DETAILS.TAX_TYPE_CODE%TYPE := OKL_API.G_MISS_CHAR
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
155: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
148: ,tax_currency_code OKL_TAX_TRX_DETAILS.TAX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
155: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
156: -- Modified by dcshanmu for eBTax - modification end
149: ,taxable_amt_tax_curr NUMBER := OKL_API.G_MISS_NUM
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
155: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
156: -- Modified by dcshanmu for eBTax - modification end
157: G_MISS_ttd_rec ttd_rec_type;
150: ,trx_currency_code OKL_TAX_TRX_DETAILS.TRX_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
155: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
156: -- Modified by dcshanmu for eBTax - modification end
157: G_MISS_ttd_rec ttd_rec_type;
158: TYPE ttd_tbl_type IS TABLE OF ttd_rec_type
151: ,minimum_accountable_unit NUMBER := OKL_API.G_MISS_NUM
152: ,precision NUMBER := OKL_API.G_MISS_NUM
153: ,currency_conversion_type OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR
154: ,currency_conversion_rate NUMBER := OKL_API.G_MISS_NUM
155: ,currency_conversion_date OKL_TAX_TRX_DETAILS.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE);
156: -- Modified by dcshanmu for eBTax - modification end
157: G_MISS_ttd_rec ttd_rec_type;
158: TYPE ttd_tbl_type IS TABLE OF ttd_rec_type
159: INDEX BY BINARY_INTEGER;
159: INDEX BY BINARY_INTEGER;
160: ---------------------------------------------------------------------------
161: -- GLOBAL MESSAGE CONSTANTS
162: ---------------------------------------------------------------------------
163: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
164: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
160: ---------------------------------------------------------------------------
161: -- GLOBAL MESSAGE CONSTANTS
162: ---------------------------------------------------------------------------
163: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
164: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
161: -- GLOBAL MESSAGE CONSTANTS
162: ---------------------------------------------------------------------------
163: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
164: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
162: ---------------------------------------------------------------------------
163: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
164: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
163: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
164: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
164: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
172: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
165: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
172: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
173: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
166: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
172: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
173: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
174: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
167: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
172: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
173: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
174: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
175: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
168: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
169: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
170: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
171: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
172: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
173: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
174: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
175: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
176:
182: ---------------------------------------------------------------------------
183: -- GLOBAL VARIABLES
184: ---------------------------------------------------------------------------
185: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TTD_PVT';
186: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
187:
188: -- SECHAWLA Added
189: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
190: ---------------------------------------------------------------------------
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_ttdv_tbl IN ttdv_tbl_type,
212: x_ttdv_tbl OUT NOCOPY ttdv_tbl_type,
213: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
214: PROCEDURE insert_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_ttdv_tbl IN ttdv_tbl_type,
236: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
237: PROCEDURE lock_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2,
240: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_ttdv_tbl IN ttdv_tbl_type,
259: x_ttdv_tbl OUT NOCOPY ttdv_tbl_type,
260: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
261: PROCEDURE update_row(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2,
264: x_return_status OUT NOCOPY VARCHAR2,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
282: p_ttdv_tbl IN ttdv_tbl_type,
283: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
284: PROCEDURE delete_row(
285: p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2,
287: x_return_status OUT NOCOPY VARCHAR2,
301: x_return_status OUT NOCOPY VARCHAR2,
302: x_msg_count OUT NOCOPY NUMBER,
303: x_msg_data OUT NOCOPY VARCHAR2,
304: p_ttdv_tbl IN ttdv_tbl_type,
305: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
306: PROCEDURE validate_row(
307: p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2,
309: x_return_status OUT NOCOPY VARCHAR2,