[Home] [Help]
3: ---------------------------------------------------------------------------
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,
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,
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,
13: lsm_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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
24: date_accounting OKL_TXL_AP_INV_LNS_B.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
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,
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,
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,
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,
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,
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,
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,
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,
29: program_id 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
35: attribute2 OKL_TXL_AP_INV_LNS_B.ATTRIBUTE2%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,
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,
53: last_update_login NUMBER := OKC_API.G_MISS_NUM,
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
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
55: funding_reference_number OKL_TXL_AP_INV_LNS_B.FUNDING_REFERENCE_NUMBER%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
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
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
57: sel_id OKL_TXL_AP_INV_LNS_B.sel_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
63: g_miss_tpl_rec tpl_rec_type;
64: TYPE tpl_tbl_type IS TABLE OF tpl_rec_type
65: INDEX BY BINARY_INTEGER;
66: TYPE okl_txl_ap_inv_lns_tl_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
64: TYPE tpl_tbl_type IS TABLE OF tpl_rec_type
65: INDEX BY BINARY_INTEGER;
66: TYPE okl_txl_ap_inv_lns_tl_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
65: INDEX BY BINARY_INTEGER;
66: TYPE okl_txl_ap_inv_lns_tl_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66: TYPE okl_txl_ap_inv_lns_tl_rec_type IS RECORD (
67: id NUMBER := OKC_API.G_MISS_NUM,
68: language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67: id NUMBER := OKC_API.G_MISS_NUM,
68: language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68: language OKL_TXL_AP_INV_LNS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
69: source_lang OKL_TXL_AP_INV_LNS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: GMissOklTxlApInvLnsTlRec okl_txl_ap_inv_lns_tl_rec_type;
70: sfwt_flag OKL_TXL_AP_INV_LNS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: GMissOklTxlApInvLnsTlRec okl_txl_ap_inv_lns_tl_rec_type;
78: TYPE okl_txl_ap_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ap_inv_lns_tl_rec_type
71: description OKL_TXL_AP_INV_LNS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: GMissOklTxlApInvLnsTlRec okl_txl_ap_inv_lns_tl_rec_type;
78: TYPE okl_txl_ap_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ap_inv_lns_tl_rec_type
79: INDEX BY BINARY_INTEGER;
72: created_by NUMBER := OKC_API.G_MISS_NUM,
73: creation_date OKL_TXL_AP_INV_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
74: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
75: last_update_date OKL_TXL_AP_INV_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
76: last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: GMissOklTxlApInvLnsTlRec okl_txl_ap_inv_lns_tl_rec_type;
78: TYPE okl_txl_ap_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ap_inv_lns_tl_rec_type
79: INDEX BY BINARY_INTEGER;
80: TYPE tplv_rec_type IS RECORD (
77: GMissOklTxlApInvLnsTlRec okl_txl_ap_inv_lns_tl_rec_type;
78: TYPE okl_txl_ap_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ap_inv_lns_tl_rec_type
79: INDEX BY BINARY_INTEGER;
80: TYPE tplv_rec_type IS RECORD (
81: id NUMBER := OKC_API.G_MISS_NUM,
82: object_version_number NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
78: TYPE okl_txl_ap_inv_lns_tl_tbl_type IS TABLE OF okl_txl_ap_inv_lns_tl_rec_type
79: INDEX BY BINARY_INTEGER;
80: TYPE tplv_rec_type IS RECORD (
81: id NUMBER := OKC_API.G_MISS_NUM,
82: object_version_number NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: INDEX BY BINARY_INTEGER;
80: TYPE tplv_rec_type IS RECORD (
81: id NUMBER := OKC_API.G_MISS_NUM,
82: object_version_number NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
80: TYPE tplv_rec_type IS RECORD (
81: id NUMBER := OKC_API.G_MISS_NUM,
82: object_version_number NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
81: id NUMBER := OKC_API.G_MISS_NUM,
82: object_version_number NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
82: object_version_number NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
83: sfwt_flag OKL_TXL_AP_INV_LNS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
84: combo_id NUMBER := OKC_API.G_MISS_NUM,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
85: itc_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
86: disbursement_basis_code OKL_TXL_AP_INV_LNS_V.DISBURSEMENT_BASIS_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
87: kle_id NUMBER := OKC_API.G_MISS_NUM,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
88: khr_id NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
89: cnsld_ap_inv_id NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
90: lsm_id NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
91: tpl_id_reverses NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
92: inv_distr_line_code OKL_TXL_AP_INV_LNS_V.INV_DISTR_LINE_CODE%TYPE := OKC_API.G_MISS_CHAR,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
93: sty_id NUMBER := OKC_API.G_MISS_NUM,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
94: tap_id NUMBER := OKC_API.G_MISS_NUM,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
95: date_accounting OKL_TXL_AP_INV_LNS_V.DATE_ACCOUNTING%TYPE := OKC_API.G_MISS_DATE,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
96: amount NUMBER := OKC_API.G_MISS_NUM,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
97: line_number NUMBER := OKC_API.G_MISS_NUM,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
98: cnsld_line_number NUMBER := OKC_API.G_MISS_NUM,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
99: ref_line_number NUMBER := OKC_API.G_MISS_NUM,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
100: payables_invoice_id NUMBER := OKC_API.G_MISS_NUM,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
101: description OKL_TXL_AP_INV_LNS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
102: error_message OKL_TXL_AP_INV_LNS_V.error_message%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
103: attribute_category OKL_TXL_AP_INV_LNS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
104: attribute1 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
105: attribute2 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
106: attribute3 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
107: attribute4 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
108: attribute5 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
109: attribute6 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
110: attribute7 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
111: attribute8 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
112: attribute9 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
113: attribute10 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
114: attribute11 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
115: attribute12 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
116: attribute13 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
117: attribute14 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
118: attribute15 OKL_TXL_AP_INV_LNS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
119: -- trx_type OKL_TXL_AP_INV_LNS_V.TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
127: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
120: request_id NUMBER := OKC_API.G_MISS_NUM,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
121: program_application_id NUMBER := OKC_API.G_MISS_NUM,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
122: program_id NUMBER := OKC_API.G_MISS_NUM,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
123: program_update_date OKL_TXL_AP_INV_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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
124: org_id NUMBER := OKC_API.G_MISS_NUM,
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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
125: created_by NUMBER := OKC_API.G_MISS_NUM,
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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
126: creation_date OKL_TXL_AP_INV_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
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,
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 |
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 |
136: TLD_ID OKL_TXL_AP_INV_LNS_B.TLD_ID%TYPE := OKC_API.G_MISS_NUM
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 |
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 |
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 |
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: );
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
141: INDEX BY BINARY_INTEGER;
142: ---------------------------------------------------------------------------
143: -- GLOBAL MESSAGE CONSTANTS
144: ---------------------------------------------------------------------------
145: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
146: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
142: ---------------------------------------------------------------------------
143: -- GLOBAL MESSAGE CONSTANTS
144: ---------------------------------------------------------------------------
145: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
146: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
143: -- GLOBAL MESSAGE CONSTANTS
144: ---------------------------------------------------------------------------
145: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
146: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
144: ---------------------------------------------------------------------------
145: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
146: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
145: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
146: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
146: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
154: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
147: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
154: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
155: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
148: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
154: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
155: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
156: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
149: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
154: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
155: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
156: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
157: G_NO_PARENT_RECORD CONSTANT VARCHAR2(30) :='OKL_NO_PARENT_RECORD';
150: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
151: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
152: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
153: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
154: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
155: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
156: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
157: G_NO_PARENT_RECORD CONSTANT VARCHAR2(30) :='OKL_NO_PARENT_RECORD';
158: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'OKL_SQLERRM';
160: ---------------------------------------------------------------------------
161: -- GLOBAL VARIABLES
162: ---------------------------------------------------------------------------
163: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TPL_PVT';
164: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
165: ---------------------------------------------------------------------------
166: -- Procedures and Functions
167: ---------------------------------------------------------------------------
168:
171: PROCEDURE api_copy;
172: PROCEDURE add_language;
173: PROCEDURE insert_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_tplv_rec IN tplv_rec_type,
180: x_tplv_rec OUT NOCOPY tplv_rec_type);
181:
182: PROCEDURE insert_row(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
187: x_msg_data OUT NOCOPY VARCHAR2,
188: p_tplv_tbl IN tplv_tbl_type,
189: x_tplv_tbl OUT NOCOPY tplv_tbl_type);
190:
191: PROCEDURE lock_row(
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_tplv_rec IN tplv_rec_type);
197: p_tplv_rec IN tplv_rec_type);
198:
199: PROCEDURE lock_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_tplv_tbl IN tplv_tbl_type);
205: p_tplv_tbl IN tplv_tbl_type);
206:
207: PROCEDURE update_row(
208: p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210: x_return_status OUT NOCOPY VARCHAR2,
211: x_msg_count OUT NOCOPY NUMBER,
212: x_msg_data OUT NOCOPY VARCHAR2,
213: p_tplv_rec IN tplv_rec_type,
214: x_tplv_rec OUT NOCOPY tplv_rec_type);
215:
216: PROCEDURE update_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_tplv_tbl IN tplv_tbl_type,
223: x_tplv_tbl OUT NOCOPY tplv_tbl_type);
224:
225: PROCEDURE delete_row(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_tplv_rec IN tplv_rec_type);
231: p_tplv_rec IN tplv_rec_type);
232:
233: PROCEDURE delete_row(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_tplv_tbl IN tplv_tbl_type);
239: p_tplv_tbl IN tplv_tbl_type);
240:
241: PROCEDURE validate_row(
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
244: x_return_status OUT NOCOPY VARCHAR2,
245: x_msg_count OUT NOCOPY NUMBER,
246: x_msg_data OUT NOCOPY VARCHAR2,
247: p_tplv_rec IN tplv_rec_type);
247: p_tplv_rec IN tplv_rec_type);
248:
249: PROCEDURE validate_row(
250: p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY NUMBER,
254: x_msg_data OUT NOCOPY VARCHAR2,
255: p_tplv_tbl IN tplv_tbl_type);