4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE tpl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: inv_distr_line_code OKL_TXL_AP_INV_LNS_B.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: tap_id NUMBER := OKC_API.G_MISS_NUM,
10: disbursement_basis_code OKL_TXL_AP_INV_LNS_B.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
12: combo_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE tpl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: inv_distr_line_code OKL_TXL_AP_INV_LNS_B.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: tap_id NUMBER := OKC_API.G_MISS_NUM,
10: disbursement_basis_code OKL_TXL_AP_INV_LNS_B.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
12: combo_id NUMBER := OKC_API.G_MISS_NUM,
13: lsm_id NUMBER := OKC_API.G_MISS_NUM,
14: kle_id NUMBER := OKC_API.G_MISS_NUM,
15: khr_id NUMBER := OKC_API.G_MISS_NUM,
16: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
17: itc_id NUMBER := OKC_API.G_MISS_NUM,
18: sty_id NUMBER := OKC_API.G_MISS_NUM,
19: -- trx_type OKL_TXL_AP_INV_LNS_B.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
20: line_number NUMBER := OKC_API.G_MISS_NUM,
21: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
22: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
23: object_version_number NUMBER := OKC_API.G_MISS_NUM,
20: line_number NUMBER := OKC_API.G_MISS_NUM,
21: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
22: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
23: object_version_number NUMBER := OKC_API.G_MISS_NUM,
24: date_accounting OKL_TXL_AP_INV_LNS_B.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
25: amount NUMBER := OKC_API.G_MISS_NUM,
26: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
27: request_id NUMBER := OKC_API.G_MISS_NUM,
28: program_application_id NUMBER := OKC_API.G_MISS_NUM,
26: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
27: request_id NUMBER := OKC_API.G_MISS_NUM,
28: program_application_id NUMBER := OKC_API.G_MISS_NUM,
29: program_id NUMBER := OKC_API.G_MISS_NUM,
30: program_update_date OKL_TXL_AP_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: org_id NUMBER := OKC_API.G_MISS_NUM,
32: error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
28: program_application_id NUMBER := OKC_API.G_MISS_NUM,
29: program_id NUMBER := OKC_API.G_MISS_NUM,
30: program_update_date OKL_TXL_AP_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: org_id NUMBER := OKC_API.G_MISS_NUM,
32: error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: program_id NUMBER := OKC_API.G_MISS_NUM,
30: program_update_date OKL_TXL_AP_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: org_id NUMBER := OKC_API.G_MISS_NUM,
32: error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: program_update_date OKL_TXL_AP_INV_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
31: org_id NUMBER := OKC_API.G_MISS_NUM,
32: error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: org_id NUMBER := OKC_API.G_MISS_NUM,
32: error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: error_message OKL_TXL_AP_INV_LNS_B.error_message%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKL_TXL_AP_INV_LNS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: created_by NUMBER := OKC_API.G_MISS_NUM,
42: attribute9 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: created_by NUMBER := OKC_API.G_MISS_NUM,
50: creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
43: attribute10 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: created_by NUMBER := OKC_API.G_MISS_NUM,
50: creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
44: attribute11 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: created_by NUMBER := OKC_API.G_MISS_NUM,
50: creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
52: last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
46: attribute13 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: created_by NUMBER := OKC_API.G_MISS_NUM,
50: creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
52: last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
48: attribute15 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
49: created_by NUMBER := OKC_API.G_MISS_NUM,
50: creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
52: last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
50: creation_date OKL_TXL_AP_INV_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
51: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
52: last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58: taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
51: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
52: last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58: taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
59: --start:| 14-May-07 cklee -- added TLD_ID column |
52: last_update_date OKL_TXL_AP_INV_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58: taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
59: --start:| 14-May-07 cklee -- added TLD_ID column |
60: TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58: taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
59: --start:| 14-May-07 cklee -- added TLD_ID column |
60: TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
61: --end:| 14-May-07 cklee -- added TLD_ID column |
54: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58: taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
59: --start:| 14-May-07 cklee -- added TLD_ID column |
60: TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
61: --end:| 14-May-07 cklee -- added TLD_ID column |
62: );
56: code_combination_id OKL_TXL_AP_INV_LNS_B.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
58: taxable_yn OKL_TXL_AP_INV_LNS_B.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
59: --start:| 14-May-07 cklee -- added TLD_ID column |
60: TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
61: --end:| 14-May-07 cklee -- added TLD_ID column |
62: );
63: g_miss_tpl_rec tpl_rec_type;
64: TYPE tpl_tbl_type IS TABLE OF tpl_rec_type
127: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
128: last_update_date OKL_TXL_AP_INV_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
129: last_update_login NUMBER := OKC_API.G_MISS_NUM,
130: funding_reference_number OKL_TXL_AP_INV_LNS_v.FUNDING_REFERENCE_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
131: funding_reference_type_code OKL_TXL_AP_INV_LNS_B.funding_reference_type_code%TYPE := OKC_API.G_MISS_CHAR, -- added g_miss 5/14/07 cklee
132: code_combination_id OKL_TXL_AP_INV_LNS_v.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
133: sel_id OKL_TXL_AP_INV_LNS_v.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
134: taxable_yn OKL_TXL_AP_INV_LNS_V.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
135: --start:| 14-May-07 cklee -- added TLD_ID column |
132: code_combination_id OKL_TXL_AP_INV_LNS_v.code_combination_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
133: sel_id OKL_TXL_AP_INV_LNS_v.sel_id%TYPE := OKC_API.G_MISS_NUM, -- added g_miss 5/14/07 cklee
134: taxable_yn OKL_TXL_AP_INV_LNS_V.TAXABLE_YN%TYPE := OKC_API.G_MISS_CHAR,
135: --start:| 14-May-07 cklee -- added TLD_ID column |
136: TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
137: --end:| 14-May-07 cklee -- added TLD_ID column |
138: );
139: g_miss_tplv_rec tplv_rec_type;
140: TYPE tplv_tbl_type IS TABLE OF tplv_rec_type