22: ---------------------------------------------------------------------------
23: -- GLOBAL DATASTRUCTURES
24: ---------------------------------------------------------------------------
25: TYPE xpi_rec_type IS RECORD (
26: id NUMBER := OKL_API.G_MISS_NUM,
27: invoice_id NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
23: -- GLOBAL DATASTRUCTURES
24: ---------------------------------------------------------------------------
25: TYPE xpi_rec_type IS RECORD (
26: id NUMBER := OKL_API.G_MISS_NUM,
27: invoice_id NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
24: ---------------------------------------------------------------------------
25: TYPE xpi_rec_type IS RECORD (
26: id NUMBER := OKL_API.G_MISS_NUM,
27: invoice_id NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
25: TYPE xpi_rec_type IS RECORD (
26: id NUMBER := OKL_API.G_MISS_NUM,
27: invoice_id NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
26: id NUMBER := OKL_API.G_MISS_NUM,
27: invoice_id NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
27: invoice_id NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
28: object_version_number NUMBER := OKL_API.G_MISS_NUM,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
29: trx_status_code OKL_EXT_PAY_INVS_B.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
30: invoice_num OKL_EXT_PAY_INVS_B.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
31: invoice_type OKL_EXT_PAY_INVS_B.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
32: invoice_date OKL_EXT_PAY_INVS_B.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
33: vendor_id NUMBER := OKL_API.G_MISS_NUM,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
34: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
35: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
36: invoice_currency_code OKL_EXT_PAY_INVS_B.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
37: terms_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
38: workflow_flag OKL_EXT_PAY_INVS_B.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
39: doc_category_code OKL_EXT_PAY_INVS_B.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
40: payment_method OKL_EXT_PAY_INVS_B.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
41: gl_date OKL_EXT_PAY_INVS_B.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
42: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
43: pay_alone_flag OKL_EXT_PAY_INVS_B.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
44: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_B.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
45: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
46: request_id NUMBER := OKL_API.G_MISS_NUM,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
47: program_application_id NUMBER := OKL_API.G_MISS_NUM,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
48: program_id NUMBER := OKL_API.G_MISS_NUM,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
49: program_update_date OKL_EXT_PAY_INVS_B.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
50: org_id NUMBER := OKL_API.G_MISS_NUM,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
51: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
52: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
53: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_B.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
54: attribute_category OKL_EXT_PAY_INVS_B.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
55: attribute1 OKL_EXT_PAY_INVS_B.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
56: attribute2 OKL_EXT_PAY_INVS_B.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
57: attribute3 OKL_EXT_PAY_INVS_B.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
58: attribute4 OKL_EXT_PAY_INVS_B.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
59: attribute5 OKL_EXT_PAY_INVS_B.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
60: attribute6 OKL_EXT_PAY_INVS_B.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
61: attribute7 OKL_EXT_PAY_INVS_B.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
62: attribute8 OKL_EXT_PAY_INVS_B.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
63: attribute9 OKL_EXT_PAY_INVS_B.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
64: attribute10 OKL_EXT_PAY_INVS_B.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
65: attribute11 OKL_EXT_PAY_INVS_B.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73: last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
66: attribute12 OKL_EXT_PAY_INVS_B.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73: last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74: last_update_login NUMBER := OKL_API.G_MISS_NUM,
67: attribute13 OKL_EXT_PAY_INVS_B.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73: last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74: last_update_login NUMBER := OKL_API.G_MISS_NUM,
75: pay_group_lookup_code OKL_EXT_PAY_INVS_B.PAY_GROUP_LOOKUP_CODE%TYPE,
68: attribute14 OKL_EXT_PAY_INVS_B.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73: last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74: last_update_login NUMBER := OKL_API.G_MISS_NUM,
75: pay_group_lookup_code OKL_EXT_PAY_INVS_B.PAY_GROUP_LOOKUP_CODE%TYPE,
76: vendor_invoice_number OKL_EXT_PAY_INVS_B.VENDOR_INVOICE_NUMBER%TYPE,
69: attribute15 OKL_EXT_PAY_INVS_B.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73: last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74: last_update_login NUMBER := OKL_API.G_MISS_NUM,
75: pay_group_lookup_code OKL_EXT_PAY_INVS_B.PAY_GROUP_LOOKUP_CODE%TYPE,
76: vendor_invoice_number OKL_EXT_PAY_INVS_B.VENDOR_INVOICE_NUMBER%TYPE,
77: nettable_yn OKL_EXT_PAY_INVS_B.NETTABLE_YN%TYPE,
70: created_by NUMBER := OKL_API.G_MISS_NUM,
71: creation_date OKL_EXT_PAY_INVS_B.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
72: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
73: last_update_date OKL_EXT_PAY_INVS_B.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
74: last_update_login NUMBER := OKL_API.G_MISS_NUM,
75: pay_group_lookup_code OKL_EXT_PAY_INVS_B.PAY_GROUP_LOOKUP_CODE%TYPE,
76: vendor_invoice_number OKL_EXT_PAY_INVS_B.VENDOR_INVOICE_NUMBER%TYPE,
77: nettable_yn OKL_EXT_PAY_INVS_B.NETTABLE_YN%TYPE,
78: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
75: pay_group_lookup_code OKL_EXT_PAY_INVS_B.PAY_GROUP_LOOKUP_CODE%TYPE,
76: vendor_invoice_number OKL_EXT_PAY_INVS_B.VENDOR_INVOICE_NUMBER%TYPE,
77: nettable_yn OKL_EXT_PAY_INVS_B.NETTABLE_YN%TYPE,
78: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
79: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
80: CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM);
81: g_miss_xpi_rec xpi_rec_type;
82: TYPE xpi_tbl_type IS TABLE OF xpi_rec_type
83: INDEX BY BINARY_INTEGER;
76: vendor_invoice_number OKL_EXT_PAY_INVS_B.VENDOR_INVOICE_NUMBER%TYPE,
77: nettable_yn OKL_EXT_PAY_INVS_B.NETTABLE_YN%TYPE,
78: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
79: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
80: CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM);
81: g_miss_xpi_rec xpi_rec_type;
82: TYPE xpi_tbl_type IS TABLE OF xpi_rec_type
83: INDEX BY BINARY_INTEGER;
84: TYPE okl_ext_pay_invs_tl_rec_type IS RECORD (
81: g_miss_xpi_rec xpi_rec_type;
82: TYPE xpi_tbl_type IS TABLE OF xpi_rec_type
83: INDEX BY BINARY_INTEGER;
84: TYPE okl_ext_pay_invs_tl_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM,
86: language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
82: TYPE xpi_tbl_type IS TABLE OF xpi_rec_type
83: INDEX BY BINARY_INTEGER;
84: TYPE okl_ext_pay_invs_tl_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM,
86: language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
83: INDEX BY BINARY_INTEGER;
84: TYPE okl_ext_pay_invs_tl_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM,
86: language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
84: TYPE okl_ext_pay_invs_tl_rec_type IS RECORD (
85: id NUMBER := OKL_API.G_MISS_NUM,
86: language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
85: id NUMBER := OKL_API.G_MISS_NUM,
86: language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
86: language OKL_EXT_PAY_INVS_TL.LANGUAGE%TYPE := OKL_API.G_MISS_CHAR,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
87: source_lang OKL_EXT_PAY_INVS_TL.SOURCE_LANG%TYPE := OKL_API.G_MISS_CHAR,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95: last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
88: sfwt_flag OKL_EXT_PAY_INVS_TL.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95: last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_update_login NUMBER := OKL_API.G_MISS_NUM);
89: description OKL_EXT_PAY_INVS_TL.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95: last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_update_login NUMBER := OKL_API.G_MISS_NUM);
97: g_miss_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
90: source OKL_EXT_PAY_INVS_TL.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95: last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_update_login NUMBER := OKL_API.G_MISS_NUM);
97: g_miss_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
98: TYPE okl_ext_pay_invs_tl_tbl_type IS TABLE OF okl_ext_pay_invs_tl_rec_type
91: stream_type OKL_EXT_PAY_INVS_TL.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95: last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_update_login NUMBER := OKL_API.G_MISS_NUM);
97: g_miss_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
98: TYPE okl_ext_pay_invs_tl_tbl_type IS TABLE OF okl_ext_pay_invs_tl_rec_type
99: INDEX BY BINARY_INTEGER;
92: created_by NUMBER := OKL_API.G_MISS_NUM,
93: creation_date OKL_EXT_PAY_INVS_TL.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
94: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
95: last_update_date OKL_EXT_PAY_INVS_TL.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
96: last_update_login NUMBER := OKL_API.G_MISS_NUM);
97: g_miss_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
98: TYPE okl_ext_pay_invs_tl_tbl_type IS TABLE OF okl_ext_pay_invs_tl_rec_type
99: INDEX BY BINARY_INTEGER;
100: TYPE xpiv_rec_type IS RECORD (
97: g_miss_okl_ext_pay_invs_tl_rec okl_ext_pay_invs_tl_rec_type;
98: TYPE okl_ext_pay_invs_tl_tbl_type IS TABLE OF okl_ext_pay_invs_tl_rec_type
99: INDEX BY BINARY_INTEGER;
100: TYPE xpiv_rec_type IS RECORD (
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
98: TYPE okl_ext_pay_invs_tl_tbl_type IS TABLE OF okl_ext_pay_invs_tl_rec_type
99: INDEX BY BINARY_INTEGER;
100: TYPE xpiv_rec_type IS RECORD (
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
99: INDEX BY BINARY_INTEGER;
100: TYPE xpiv_rec_type IS RECORD (
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
100: TYPE xpiv_rec_type IS RECORD (
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
101: id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
102: object_version_number NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
103: sfwt_flag OKL_EXT_PAY_INVS_V.SFWT_FLAG%TYPE := OKL_API.G_MISS_CHAR,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
104: trx_status_code OKL_EXT_PAY_INVS_V.TRX_STATUS_CODE%TYPE := OKL_API.G_MISS_CHAR, -- Post postgen add column
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
105: invoice_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
106: invoice_num OKL_EXT_PAY_INVS_V.INVOICE_NUM%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
107: invoice_type OKL_EXT_PAY_INVS_V.INVOICE_TYPE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
108: invoice_date OKL_EXT_PAY_INVS_V.INVOICE_DATE%TYPE := OKL_API.G_MISS_DATE,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
109: vendor_id NUMBER := OKL_API.G_MISS_NUM,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
110: vendor_site_id NUMBER := OKL_API.G_MISS_NUM,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
111: invoice_amount NUMBER := OKL_API.G_MISS_NUM,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
112: invoice_currency_code OKL_EXT_PAY_INVS_V.INVOICE_CURRENCY_CODE%TYPE := OKL_API.G_MISS_CHAR,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
113: terms_id NUMBER := OKL_API.G_MISS_NUM,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
114: description OKL_EXT_PAY_INVS_V.DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
115: source OKL_EXT_PAY_INVS_V.SOURCE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
116: workflow_flag OKL_EXT_PAY_INVS_V.WORKFLOW_FLAG%TYPE := OKL_API.G_MISS_CHAR,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
117: doc_category_code OKL_EXT_PAY_INVS_V.DOC_CATEGORY_CODE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
118: payment_method OKL_EXT_PAY_INVS_V.PAYMENT_METHOD%TYPE := OKL_API.G_MISS_CHAR,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
119: gl_date OKL_EXT_PAY_INVS_V.GL_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
120: accts_pay_cc_id NUMBER := OKL_API.G_MISS_NUM,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
121: pay_alone_flag OKL_EXT_PAY_INVS_V.PAY_ALONE_FLAG%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
122: wait_vendor_invoice_yn OKL_EXT_PAY_INVS_V.WAIT_VENDOR_INVOICE_YN%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
123: stream_type OKL_EXT_PAY_INVS_V.STREAM_TYPE%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
124: payables_invoice_id NUMBER := OKL_API.G_MISS_NUM,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
125: CURRENCY_CONVERSION_TYPE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_TYPE%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
126: CURRENCY_CONVERSION_RATE NUMBER := OKL_API.G_MISS_NUM,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
127: CURRENCY_CONVERSION_DATE OKL_EXT_PAY_INVS_V.CURRENCY_CONVERSION_DATE%TYPE := OKL_API.G_MISS_DATE,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
128: attribute_category OKL_EXT_PAY_INVS_V.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
129: attribute1 OKL_EXT_PAY_INVS_V.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
130: attribute2 OKL_EXT_PAY_INVS_V.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
131: attribute3 OKL_EXT_PAY_INVS_V.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
132: attribute4 OKL_EXT_PAY_INVS_V.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
133: attribute5 OKL_EXT_PAY_INVS_V.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
134: attribute6 OKL_EXT_PAY_INVS_V.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
135: attribute7 OKL_EXT_PAY_INVS_V.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
136: attribute8 OKL_EXT_PAY_INVS_V.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
137: attribute9 OKL_EXT_PAY_INVS_V.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
138: attribute10 OKL_EXT_PAY_INVS_V.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
139: attribute11 OKL_EXT_PAY_INVS_V.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
140: attribute12 OKL_EXT_PAY_INVS_V.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
141: attribute13 OKL_EXT_PAY_INVS_V.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
142: attribute14 OKL_EXT_PAY_INVS_V.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
143: attribute15 OKL_EXT_PAY_INVS_V.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
144: request_id NUMBER := OKL_API.G_MISS_NUM,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
145: program_application_id NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
146: program_id NUMBER := OKL_API.G_MISS_NUM,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
147: program_update_date OKL_EXT_PAY_INVS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
148: org_id NUMBER := OKL_API.G_MISS_NUM,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
149: created_by NUMBER := OKL_API.G_MISS_NUM,
150: creation_date OKL_EXT_PAY_INVS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE,
151: last_updated_by NUMBER := OKL_API.G_MISS_NUM,
152: last_update_date OKL_EXT_PAY_INVS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE,
153: last_update_login NUMBER := OKL_API.G_MISS_NUM,
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
154: pay_group_lookup_code OKL_EXT_PAY_INVS_V.PAY_GROUP_LOOKUP_CODE%TYPE,
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
158: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
159: CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM
160: );
161: g_miss_xpiv_rec xpiv_rec_type;
162: TYPE xpiv_tbl_type IS TABLE OF xpiv_rec_type
155: vendor_invoice_number OKL_EXT_PAY_INVS_V.VENDOR_INVOICE_NUMBER%TYPE,
156: nettable_yn OKL_EXT_PAY_INVS_V.NETTABLE_YN%TYPE,
157: -- 30-OCT-2006 ANSETHUR R12B - Legal Entity
158: legal_entity_id OKL_EXT_PAY_INVS_B.legal_entity_id%TYPE := OKL_API.G_MISS_NUM,
159: CNSLD_AP_INV_ID OKL_EXT_PAY_INVS_B.CNSLD_AP_INV_ID%TYPE := OKL_API.G_MISS_NUM
160: );
161: g_miss_xpiv_rec xpiv_rec_type;
162: TYPE xpiv_tbl_type IS TABLE OF xpiv_rec_type
163: INDEX BY BINARY_INTEGER;
163: INDEX BY BINARY_INTEGER;
164: ---------------------------------------------------------------------------
165: -- GLOBAL MESSAGE CONSTANTS
166: ---------------------------------------------------------------------------
167: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
168: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
164: ---------------------------------------------------------------------------
165: -- GLOBAL MESSAGE CONSTANTS
166: ---------------------------------------------------------------------------
167: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
168: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
165: -- GLOBAL MESSAGE CONSTANTS
166: ---------------------------------------------------------------------------
167: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
168: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
166: ---------------------------------------------------------------------------
167: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
168: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
167: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
168: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
168: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
176: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
169: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
176: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
177: -- PostGen-Begin-0
170: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
176: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
177: -- PostGen-Begin-0
178: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_UNEXPECTED_ERROR';
171: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
176: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
177: -- PostGen-Begin-0
178: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_UNEXPECTED_ERROR';
179: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) :='OKL_NO_PARENT_RECORD';
172: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
173: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
174: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
175: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
176: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
177: -- PostGen-Begin-0
178: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :='OKL_UNEXPECTED_ERROR';
179: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) :='OKL_NO_PARENT_RECORD';
180: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) :='ERROR_MESSAGE';
184: ---------------------------------------------------------------------------
185: -- GLOBAL VARIABLES
186: ---------------------------------------------------------------------------
187: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XPI_PVT';
188: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
189: -- Post-Gen Begin-0
190: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_EXT_PAY_INVS_V';
191: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
192: -- Post-Gen End-0
199: PROCEDURE api_copy;
200: PROCEDURE add_language;
201: PROCEDURE insert_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_xpiv_rec IN xpiv_rec_type,
208: x_xpiv_rec OUT NOCOPY xpiv_rec_type);
209:
210: PROCEDURE insert_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_xpiv_tbl IN xpiv_tbl_type,
217: x_xpiv_tbl OUT NOCOPY xpiv_tbl_type);
218:
219: PROCEDURE lock_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_xpiv_rec IN xpiv_rec_type);
225: p_xpiv_rec IN xpiv_rec_type);
226:
227: PROCEDURE lock_row(
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_xpiv_tbl IN xpiv_tbl_type);
233: p_xpiv_tbl IN xpiv_tbl_type);
234:
235: PROCEDURE update_row(
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: p_xpiv_rec IN xpiv_rec_type,
242: x_xpiv_rec OUT NOCOPY xpiv_rec_type);
243:
244: PROCEDURE update_row(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_xpiv_tbl IN xpiv_tbl_type,
251: x_xpiv_tbl OUT NOCOPY xpiv_tbl_type);
252:
253: PROCEDURE delete_row(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_xpiv_rec IN xpiv_rec_type);
259: p_xpiv_rec IN xpiv_rec_type);
260:
261: PROCEDURE delete_row(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_xpiv_tbl IN xpiv_tbl_type);
267: p_xpiv_tbl IN xpiv_tbl_type);
268:
269: PROCEDURE validate_row(
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_xpiv_rec IN xpiv_rec_type);
275: p_xpiv_rec IN xpiv_rec_type);
276:
277: PROCEDURE validate_row(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_xpiv_tbl IN xpiv_tbl_type);