7: ------------------------------------------------------------------------
8: -- Table Types for Expenses Headers
9: ------------------------------------------------------------------------
10: TYPE InvoiceInfoRecType IS RECORD(
11: report_header_id ap_expense_report_headers.report_header_id%TYPE,
12: employee_id ap_expense_report_headers.employee_id%TYPE,
13: employee_number per_all_people_f.employee_number%TYPE,
14: week_end_date ap_expense_report_headers.week_end_date%TYPE,
15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
8: -- Table Types for Expenses Headers
9: ------------------------------------------------------------------------
10: TYPE InvoiceInfoRecType IS RECORD(
11: report_header_id ap_expense_report_headers.report_header_id%TYPE,
12: employee_id ap_expense_report_headers.employee_id%TYPE,
13: employee_number per_all_people_f.employee_number%TYPE,
14: week_end_date ap_expense_report_headers.week_end_date%TYPE,
15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
10: TYPE InvoiceInfoRecType IS RECORD(
11: report_header_id ap_expense_report_headers.report_header_id%TYPE,
12: employee_id ap_expense_report_headers.employee_id%TYPE,
13: employee_number per_all_people_f.employee_number%TYPE,
14: week_end_date ap_expense_report_headers.week_end_date%TYPE,
15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
11: report_header_id ap_expense_report_headers.report_header_id%TYPE,
12: employee_id ap_expense_report_headers.employee_id%TYPE,
13: employee_number per_all_people_f.employee_number%TYPE,
14: week_end_date ap_expense_report_headers.week_end_date%TYPE,
15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
12: employee_id ap_expense_report_headers.employee_id%TYPE,
13: employee_number per_all_people_f.employee_number%TYPE,
14: week_end_date ap_expense_report_headers.week_end_date%TYPE,
15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
13: employee_number per_all_people_f.employee_number%TYPE,
14: week_end_date ap_expense_report_headers.week_end_date%TYPE,
15: invoice_num ap_expense_report_headers.invoice_num%TYPE,
16: total ap_expense_report_headers.total%TYPE,
17: description ap_expense_report_headers.description%TYPE,
18: name per_all_people_f.full_name%TYPE,
19: location_code hr_locations.location_code%TYPE,
20: address_line_1 hr_locations.address_line_1%TYPE,
21: address_line_2 hr_locations.address_line_2%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
34: created_by ap_expense_report_headers.created_by%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
35: default_currency_code ap_expense_report_headers.default_currency_code%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
36: default_exchange_rate_type ap_expense_report_headers.default_exchange_rate_type%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
37: default_exchange_rate ap_expense_report_headers.default_exchange_rate%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
38: default_exchange_date ap_expense_report_headers.default_exchange_date%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
39: accts_pay_ccid ap_expense_report_headers.accts_pay_code_combination_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
40: set_of_books_id ap_expense_report_headers.set_of_books_id%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
41: accounting_date ap_expense_report_headers.accounting_date%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
42: header_vendor_site_id ap_expense_report_headers.vendor_site_id%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
43: apply_advances_flag ap_expense_report_headers.apply_advances_default%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
44: advance_invoice_to_apply ap_expense_report_headers.advance_invoice_to_apply%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
45: amount_want_to_apply ap_expense_report_headers.maximum_amount_to_apply%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
46: home_or_office ap_expense_report_headers.expense_check_address_flag%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
47: current_emp_id ap_expense_report_headers.employee_id%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
48: voucher_num ap_expense_report_headers.voucher_num%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
49: base_amount ap_expense_report_headers.total%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
50: doc_category_code ap_expense_report_headers.doc_category_code%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
51: reference_1 ap_expense_report_headers.reference_1%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
52: reference_2 ap_expense_report_headers.reference_2%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
53: awt_group_id ap_expense_report_headers.awt_group_id%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
54: global_attribute1 ap_expense_report_headers.global_attribute1%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
55: global_attribute2 ap_expense_report_headers.global_attribute2%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
56: global_attribute3 ap_expense_report_headers.global_attribute3%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
57: global_attribute4 ap_expense_report_headers.global_attribute4%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
58: global_attribute5 ap_expense_report_headers.global_attribute5%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
59: global_attribute6 ap_expense_report_headers.global_attribute6%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
60: global_attribute7 ap_expense_report_headers.global_attribute7%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
61: global_attribute8 ap_expense_report_headers.global_attribute8%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
62: global_attribute9 ap_expense_report_headers.global_attribute9%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
63: global_attribute10 ap_expense_report_headers.global_attribute10%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
64: global_attribute11 ap_expense_report_headers.global_attribute11%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
65: global_attribute12 ap_expense_report_headers.global_attribute12%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
66: global_attribute13 ap_expense_report_headers.global_attribute13%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
67: global_attribute14 ap_expense_report_headers.global_attribute14%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
68: global_attribute15 ap_expense_report_headers.global_attribute15%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
69: global_attribute16 ap_expense_report_headers.global_attribute16%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
70: global_attribute17 ap_expense_report_headers.global_attribute17%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
71: global_attribute18 ap_expense_report_headers.global_attribute18%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
72: global_attribute19 ap_expense_report_headers.global_attribute19%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
73: global_attribute20 ap_expense_report_headers.global_attribute20%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
74: global_attribute_category ap_expense_report_headers.global_attribute_category%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
75: attribute1 ap_expense_report_headers.attribute1%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
76: attribute2 ap_expense_report_headers.attribute2%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
77: attribute3 ap_expense_report_headers.attribute3%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
78: attribute4 ap_expense_report_headers.attribute4%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
79: attribute5 ap_expense_report_headers.attribute5%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
80: attribute6 ap_expense_report_headers.attribute6%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
81: attribute7 ap_expense_report_headers.attribute7%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
82: attribute8 ap_expense_report_headers.attribute8%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
83: attribute9 ap_expense_report_headers.attribute9%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
84: attribute10 ap_expense_report_headers.attribute10%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
85: attribute11 ap_expense_report_headers.attribute11%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
86: attribute12 ap_expense_report_headers.attribute12%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
87: attribute13 ap_expense_report_headers.attribute13%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
88: attribute14 ap_expense_report_headers.attribute14%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
89: attribute15 ap_expense_report_headers.attribute15%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
90: attribute_category ap_expense_report_headers.attribute_category%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
91: payment_currency_code ap_expense_report_headers.payment_currency_code%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
92: payment_cross_rate_type ap_expense_report_headers.payment_cross_rate_type%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
100: amt_due_ccard_company ap_expense_report_headers.amt_due_ccard_company%TYPE,
93: payment_cross_rate_date ap_expense_report_headers.payment_cross_rate_date%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
100: amt_due_ccard_company ap_expense_report_headers.amt_due_ccard_company%TYPE,
101: per_information18_19 per_all_people_f.per_information18%TYPE,
94: payment_cross_rate ap_expense_report_headers.payment_cross_rate%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
100: amt_due_ccard_company ap_expense_report_headers.amt_due_ccard_company%TYPE,
101: per_information18_19 per_all_people_f.per_information18%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
95: prepay_num ap_expense_report_headers.prepay_num%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
100: amt_due_ccard_company ap_expense_report_headers.amt_due_ccard_company%TYPE,
101: per_information18_19 per_all_people_f.per_information18%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
103: source ap_expense_report_headers.source%TYPE,
96: prepay_dist_num ap_expense_report_headers.prepay_dist_num%TYPE,
97: prepay_gl_date ap_expense_report_headers.prepay_gl_date%TYPE,
98: paid_on_behalf_employee_id ap_expense_report_headers.paid_on_behalf_employee_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
100: amt_due_ccard_company ap_expense_report_headers.amt_due_ccard_company%TYPE,
101: per_information18_19 per_all_people_f.per_information18%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
103: source ap_expense_report_headers.source%TYPE,
104: group_id ap_invoices_interface.group_id%TYPE,
99: amt_due_employee ap_expense_report_headers.amt_due_employee%TYPE,
100: amt_due_ccard_company ap_expense_report_headers.amt_due_ccard_company%TYPE,
101: per_information18_19 per_all_people_f.per_information18%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
103: source ap_expense_report_headers.source%TYPE,
104: group_id ap_invoices_interface.group_id%TYPE,
105: style hr_locations.style%TYPE,
106: org_id ap_expense_report_headers_all.org_id%TYPE,
107: invoice_id ap_invoices_interface.invoice_id%TYPE,
102: per_information_category per_all_people_f.per_information_category%TYPE,
103: source ap_expense_report_headers.source%TYPE,
104: group_id ap_invoices_interface.group_id%TYPE,
105: style hr_locations.style%TYPE,
106: org_id ap_expense_report_headers_all.org_id%TYPE,
107: invoice_id ap_invoices_interface.invoice_id%TYPE,
108: invoice_type_lookup_code ap_invoices_interface.invoice_type_lookup_code%TYPE,
109: gl_date ap_invoices_interface.gl_date%TYPE,
110: alternate_name per_all_people_f.full_name%TYPE,
219:
220: TYPE VendorInfoRecType IS RECORD(
221: vendor_id ap_suppliers.vendor_id%TYPE,
222: vendor_site_id ap_supplier_sites.vendor_site_id%TYPE,
223: employee_id ap_expense_report_headers.employee_id%TYPE,
224: party_id ap_suppliers.party_id%TYPE,
225: party_site_id ap_supplier_sites.party_site_id%TYPE,
226: home_or_office VARCHAR2(2),
227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,
241: address_line_3 hr_locations.address_line_3%TYPE,
242: city hr_locations.town_or_city%TYPE,
287: FUNCTION GetVendorinfo(p_vendor_rec IN OUT NOCOPY VendorInfoRecType,
288: p_reject_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
289: ------------------------------------------------------------------------
290: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,
291: p_org_id IN ap_expense_report_headers.org_id%TYPE,
292: p_reject_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
293: ------------------------------------------------------------------------
294:
295: END AP_WEB_EXPORT_ER;