DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 8: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;

4: ------------------------
5: -- Types definition
6: ------------------------
7:
8: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;

Line 9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;

5: -- Types definition
6: ------------------------
7:
8: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;

Line 10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;

6: ------------------------
7:
8: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;

Line 11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;

7:
8: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;

Line 12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;

8: SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;

Line 13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;

9: SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;

Line 14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;

10: SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;

Line 15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;

11: SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;

Line 16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;

12: SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;

Line 17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;

13: SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;

Line 18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;

14: SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;

Line 19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;

15: SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;

Line 20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;

16: SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;

Line 21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;

17: SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;

Line 22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;

18: SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;

Line 23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;

19: SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;

Line 24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;

20: SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;

Line 25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;

21: SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;

Line 26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;

22: SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;

Line 27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;

23: SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;

Line 28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;

24: SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;

Line 29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;

25: SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;

Line 30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;

26: SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;

Line 31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;

27: SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;

Line 32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;

28: SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;

Line 33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;

29: SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;

Line 34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;

30: SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;

Line 35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;

31: SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;

Line 36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;

32: SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;

Line 37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;

33: SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;

Line 38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;

34: SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;

Line 39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;

35: SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;

Line 40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;

36: SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;

Line 41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;

37: SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;

Line 42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;

38: SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;

Line 43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;

39: SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;

Line 44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;

40: SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;

Line 45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;

41: SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;

Line 46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;

42: SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;

Line 47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;

43: SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;

Line 48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;

44: SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;

Line 49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;

45: SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;

Line 50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;

46: SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;

Line 51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;

47: SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;

Line 52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;

48: SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;

Line 53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;

49: SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;

Line 54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;

50: SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;

Line 55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;

51: SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;

Line 56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;

52: SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;

Line 57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;

53: SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;
61: SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;

Line 58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;

54: SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;
61: SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;
62:

Line 59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;

55: SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;
61: SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;
62:
63: /* From DB AP INTERFACE PACKAGE */

Line 60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;

56: SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;
61: SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;
62:
63: /* From DB AP INTERFACE PACKAGE */
64: SUBTYPE finSysParams_checkAddrFlag IS FINANCIALS_SYSTEM_PARAMETERS.expense_check_address_flag%TYPE;

Line 61: SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;

57: SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58: SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59: SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60: SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;
61: SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;
62:
63: /* From DB AP INTERFACE PACKAGE */
64: SUBTYPE finSysParams_checkAddrFlag IS FINANCIALS_SYSTEM_PARAMETERS.expense_check_address_flag%TYPE;
65:

Line 400: -- Desc: Updates ap_expense_report_headers with a new default_exchange_rate_type

396:
397:
398: -------------------------------------------------------------------
399: -- Name: SetDefaultExchRateType
400: -- Desc: Updates ap_expense_report_headers with a new default_exchange_rate_type
401: -- Input: p_report_header_id - report_header_id for the expense report
402: -- p_xrate_type - default_exchange_rate_type
403: -- Returns: true - succeeded
404: -- false - failed