eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXPENSE_REPORT_LINES

Line 12: SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;

8: C_Modified CONSTANT VARCHAR2(1) := 'M';
9: C_Split CONSTANT VARCHAR2(1) := 'S';
10:
11: ---------------------------------------------------------------------------------------------------
12: SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;
13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;

Line 13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;

9: C_Split CONSTANT VARCHAR2(1) := 'S';
10:
11: ---------------------------------------------------------------------------------------------------
12: SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;
13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;

Line 14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;

10:
11: ---------------------------------------------------------------------------------------------------
12: SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;
13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;

Line 15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;

11: ---------------------------------------------------------------------------------------------------
12: SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;
13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;

Line 16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;

12: SUBTYPE expLines_headerID IS AP_EXPENSE_REPORT_LINES.report_header_id%TYPE;
13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;

Line 17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;

13: SUBTYPE expLines_codeCombID IS AP_EXPENSE_REPORT_LINES.code_combination_id%TYPE;
14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;

Line 18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;

14: SUBTYPE expLines_setOfBooksID IS AP_EXPENSE_REPORT_LINES.set_of_books_id%TYPE;
15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;

Line 19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;

15: SUBTYPE expLines_amount IS AP_EXPENSE_REPORT_LINES.amount%TYPE;
16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;

Line 20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;

16: SUBTYPE expLines_currCode IS AP_EXPENSE_REPORT_LINES.currency_code%TYPE;
17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;

Line 21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;

17: SUBTYPE expLines_xchRateType IS AP_EXPENSE_REPORT_LINES.exchange_rate_type%TYPE;
18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;

Line 22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;

18: SUBTYPE expLines_xchRate IS AP_EXPENSE_REPORT_LINES.exchange_rate%TYPE;
19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;

Line 23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;

19: SUBTYPE expLines_vatCode IS AP_EXPENSE_REPORT_LINES.vat_code%TYPE;
20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;

Line 24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;

20: SUBTYPE expLines_lineTypeLookupCode IS AP_EXPENSE_REPORT_LINES.line_type_lookup_code%TYPE;
21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;

Line 25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;

21: SUBTYPE expLines_projID IS AP_EXPENSE_REPORT_LINES.project_id%TYPE;
22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;

Line 26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;

22: SUBTYPE expLines_projName IS AP_EXPENSE_REPORT_LINES.project_name%TYPE;
23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;

Line 27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;

23: SUBTYPE expLines_taskID IS AP_EXPENSE_REPORT_LINES.task_id%TYPE;
24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;

Line 28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;

24: SUBTYPE expLines_taskName IS AP_EXPENSE_REPORT_LINES.task_name%TYPE;
25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;

Line 29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;

25: SUBTYPE expLines_orgID IS AP_EXPENSE_REPORT_LINES.org_id%TYPE;
26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;

Line 30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;

26: SUBTYPE expLines_receiptVerifFlag IS AP_EXPENSE_REPORT_LINES.receipt_verified_flag%TYPE;
27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;

Line 31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;

27: SUBTYPE expLines_justifReqdFlag IS AP_EXPENSE_REPORT_LINES.justification_required_flag%TYPE;
28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;

Line 32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;

28: SUBTYPE expLines_receiptReqdFlag IS AP_EXPENSE_REPORT_LINES.receipt_required_flag%TYPE;
29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;

Line 33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;

29: SUBTYPE expLines_receiptMissingFlag IS AP_EXPENSE_REPORT_LINES.receipt_missing_flag%TYPE;
30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;

Line 34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;

30: SUBTYPE expLines_justification IS AP_EXPENSE_REPORT_LINES.justification%TYPE;
31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;

Line 35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;

31: SUBTYPE expLines_dailyAmount IS AP_EXPENSE_REPORT_LINES.daily_amount%TYPE;
32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;

Line 36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;

32: SUBTYPE expLines_webParamID IS AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE;
33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;

Line 37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;

33: SUBTYPE expLines_amtInclTaxFlag IS AP_EXPENSE_REPORT_LINES.amount_includes_tax_flag%TYPE;
34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;

Line 38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;

34: SUBTYPE expLines_adjReason IS AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE;
35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;

Line 39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;

35: SUBTYPE expLines_policyShortpayFlag IS AP_EXPENSE_REPORT_LINES.policy_shortpay_flag%TYPE;
36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;

Line 40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;

36: SUBTYPE expLines_countryOfSupply IS AP_EXPENSE_REPORT_LINES.country_of_supply%TYPE;
37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;

Line 41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;

37: SUBTYPE expLines_taxCodeID IS AP_EXPENSE_REPORT_LINES.tax_code_id%TYPE;
38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;

Line 42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;

38: SUBTYPE expLines_taxCodeOverrideFlag IS AP_EXPENSE_REPORT_LINES.tax_code_override_flag%TYPE;
39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;

Line 43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;

39: SUBTYPE expLines_crdCardTrxID IS AP_EXPENSE_REPORT_LINES.credit_card_trx_id%TYPE;
40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;

Line 44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;

40: SUBTYPE expLines_compPrepaidInvID IS AP_EXPENSE_REPORT_LINES.company_prepaid_invoice_id%TYPE;
41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;

Line 45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;

41: SUBTYPE expLines_itemizeID IS AP_EXPENSE_REPORT_LINES.itemize_id%TYPE;
42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;

Line 46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;

42: SUBTYPE expLines_itemDescription IS AP_EXPENSE_REPORT_LINES.item_description%TYPE;
43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;

Line 47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;

43: SUBTYPE expLines_startExpDate IS AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE;
44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;

Line 48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;

44: SUBTYPE expLines_endExpDate IS AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE;
45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;

Line 49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;

45: SUBTYPE expLines_receiptConvRate IS AP_EXPENSE_REPORT_LINES.receipt_conversion_rate%TYPE;
46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;

Line 50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;

46: SUBTYPE expLines_receiptCurrCode IS AP_EXPENSE_REPORT_LINES.receipt_currency_code%TYPE;
47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;

Line 51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;

47: SUBTYPE expLines_createdBy IS AP_EXPENSE_REPORT_LINES.created_by%TYPE;
48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;

Line 52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;

48: SUBTYPE expLines_projAcctContext IS AP_EXPENSE_REPORT_LINES.project_accounting_context%TYPE;
49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;

Line 53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;

49: SUBTYPE expLines_expOrgID IS AP_EXPENSE_REPORT_LINES.expenditure_organization_id%TYPE;
50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;

Line 54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;

50: SUBTYPE expLines_distLineNum IS AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE;
51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;

Line 55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;

51: SUBTYPE expLines_awtGroupID IS AP_EXPENSE_REPORT_LINES.awt_group_id%TYPE;
52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;

Line 56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;

52: SUBTYPE expLines_expendItemDate IS AP_EXPENSE_REPORT_LINES.expenditure_item_date%TYPE;
53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;

Line 57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;

53: SUBTYPE expLines_expendType IS AP_EXPENSE_REPORT_LINES.expenditure_type%TYPE;
54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;

Line 58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;

54: SUBTYPE expLines_paQuantity IS AP_EXPENSE_REPORT_LINES.pa_quantity%TYPE;
55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;

Line 59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;

55: SUBTYPE expLines_CategoryCode IS AP_EXPENSE_REPORT_LINES.category_code%TYPE;
56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;

Line 60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;

56: SUBTYPE expLines_attrCategory IS AP_EXPENSE_REPORT_LINES.attribute_category%TYPE;
57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;

Line 61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;

57: SUBTYPE expLines_attr1 IS AP_EXPENSE_REPORT_LINES.attribute1%TYPE;
58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;

Line 62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;

58: SUBTYPE expLines_attr2 IS AP_EXPENSE_REPORT_LINES.attribute2%TYPE;
59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;

Line 63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;

59: SUBTYPE expLines_attr3 IS AP_EXPENSE_REPORT_LINES.attribute3%TYPE;
60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;

Line 64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;

60: SUBTYPE expLines_attr4 IS AP_EXPENSE_REPORT_LINES.attribute4%TYPE;
61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;

Line 65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;

61: SUBTYPE expLines_attr5 IS AP_EXPENSE_REPORT_LINES.attribute5%TYPE;
62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;

Line 66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;

62: SUBTYPE expLines_attr6 IS AP_EXPENSE_REPORT_LINES.attribute6%TYPE;
63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;

Line 67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;

63: SUBTYPE expLines_attr7 IS AP_EXPENSE_REPORT_LINES.attribute7%TYPE;
64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;

Line 68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;

64: SUBTYPE expLines_attr8 IS AP_EXPENSE_REPORT_LINES.attribute8%TYPE;
65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;

Line 69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;

65: SUBTYPE expLines_attr9 IS AP_EXPENSE_REPORT_LINES.attribute9%TYPE;
66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;

Line 70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;

66: SUBTYPE expLines_attr10 IS AP_EXPENSE_REPORT_LINES.attribute10%TYPE;
67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;

Line 71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;

67: SUBTYPE expLines_attr11 IS AP_EXPENSE_REPORT_LINES.attribute11%TYPE;
68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;

Line 72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;

68: SUBTYPE expLines_attr12 IS AP_EXPENSE_REPORT_LINES.attribute12%TYPE;
69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;

Line 73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;

69: SUBTYPE expLines_attr13 IS AP_EXPENSE_REPORT_LINES.attribute13%TYPE;
70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;

Line 74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;

70: SUBTYPE expLines_attr14 IS AP_EXPENSE_REPORT_LINES.attribute14%TYPE;
71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;

Line 75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;

71: SUBTYPE expLines_attr15 IS AP_EXPENSE_REPORT_LINES.attribute15%TYPE;
72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;

Line 76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;

72: SUBTYPE expLines_avg_mileage_rate IS AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE;
73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;

Line 77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;

73: SUBTYPE expLines_vehicle_category_code IS AP_EXPENSE_REPORT_LINES.VEHICLE_CATEGORY_CODE%TYPE;
74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;

Line 78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;

74: SUBTYPE expLines_vehicle_type IS AP_EXPENSE_REPORT_LINES.VEHICLE_TYPE%TYPE;
75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;

Line 79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;

75: SUBTYPE expLines_fuel_type IS AP_EXPENSE_REPORT_LINES.FUEL_TYPE%TYPE;
76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;

Line 80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;

76: SUBTYPE expLines_trip_distance IS AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE;
77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;
84: SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;

Line 81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;

77: SUBTYPE expLines_distance_unit_code IS AP_EXPENSE_REPORT_LINES.DISTANCE_UNIT_CODE%TYPE;
78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;
84: SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;
85: ---------------------------------------------------------------------------------------------------

Line 82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;

78: SUBTYPE expLines_daily_distance IS AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE;
79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;
84: SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;
85: ---------------------------------------------------------------------------------------------------
86:

Line 83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;

79: SUBTYPE expLines_LineFlexConcat IS AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE;
80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;
84: SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;
85: ---------------------------------------------------------------------------------------------------
86:
87:

Line 84: SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;

80: SUBTYPE expLines_APValidationError IS AP_EXPENSE_REPORT_LINES.AP_VALIDATION_ERROR%TYPE;
81: SUBTYPE expLines_mrate_adj_flag IS AP_EXPENSE_REPORT_LINES.MILEAGE_RATE_ADJUSTED_FLAG%TYPE;
82: SUBTYPE expLines_report_line_id IS AP_EXPENSE_REPORT_LINES.REPORT_LINE_ID%TYPE;
83: SUBTYPE expLines_number_people IS AP_EXPENSE_REPORT_LINES.NUMBER_PEOPLE%TYPE;
84: SUBTYPE expLines_rate_per_passenger IS AP_EXPENSE_REPORT_LINES.RATE_PER_PASSENGER%TYPE;
85: ---------------------------------------------------------------------------------------------------
86:
87:
88: TYPE CCTrxnCursor IS REF CURSOR;

Line 133: receipt_currency_amount ap_expense_report_lines.receipt_currency_amount%TYPE,

129: status VARCHAR2(1) := C_Unchanged,
130: category_code ap_expense_report_params.category_code%TYPE,
131: copy_From expLines_distLineNum,
132: daily_amount expLines_dailyAmount,
133: receipt_currency_amount ap_expense_report_lines.receipt_currency_amount%TYPE,
134: reimbursement_currency_code expLines_currCode,
135: number_people expLines_number_people,
136: web_parameter_id expLines_webParamID,
137: rate_per_passenger expLines_rate_per_passenger,

Line 153: report_line_id ap_expense_report_lines.report_line_id%type

149: attribute12 expLines_attr12,
150: attribute13 expLines_attr13,
151: attribute14 expLines_attr14,
152: attribute15 expLines_attr15,
153: report_line_id ap_expense_report_lines.report_line_id%type
154: ); /* end TYPE Mileage_Line_Rec */
155:
156: TYPE Mileage_Line_Array IS TABLE OF Mileage_Line_Rec
157: INDEX BY BINARY_INTEGER;

Line 464: report_header_id AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,

460: * information.
461: */
462: TYPE AdjustmentCursor IS REF CURSOR;
463: TYPE AdjustmentRecordType IS RECORD (
464: report_header_id AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
465: start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
466: amount AP_EXPENSE_REPORT_LINES.amount%TYPE,
467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468: adjusted_amount NUMBER,

Line 465: start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,

461: */
462: TYPE AdjustmentCursor IS REF CURSOR;
463: TYPE AdjustmentRecordType IS RECORD (
464: report_header_id AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
465: start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
466: amount AP_EXPENSE_REPORT_LINES.amount%TYPE,
467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468: adjusted_amount NUMBER,
469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,

Line 466: amount AP_EXPENSE_REPORT_LINES.amount%TYPE,

462: TYPE AdjustmentCursor IS REF CURSOR;
463: TYPE AdjustmentRecordType IS RECORD (
464: report_header_id AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
465: start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
466: amount AP_EXPENSE_REPORT_LINES.amount%TYPE,
467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468: adjusted_amount NUMBER,
469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,
470: expense_type_disp VARCHAR2(80),

Line 467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,

463: TYPE AdjustmentRecordType IS RECORD (
464: report_header_id AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
465: start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
466: amount AP_EXPENSE_REPORT_LINES.amount%TYPE,
467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468: adjusted_amount NUMBER,
469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,
470: expense_type_disp VARCHAR2(80),
471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,

Line 469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,

465: start_expense_date AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
466: amount AP_EXPENSE_REPORT_LINES.amount%TYPE,
467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468: adjusted_amount NUMBER,
469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,
470: expense_type_disp VARCHAR2(80),
471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,
472: adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,
473: adjustment_reason_code_disp VARCHAR2(80),

Line 471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,

467: submitted_amount AP_EXPENSE_REPORT_LINES.submitted_amount%TYPE,
468: adjusted_amount NUMBER,
469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,
470: expense_type_disp VARCHAR2(80),
471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,
472: adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,
473: adjustment_reason_code_disp VARCHAR2(80),
474: adjustment_reason_description AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
475: adjustment_reason AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,

Line 472: adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,

468: adjusted_amount NUMBER,
469: web_parameter_id AP_EXPENSE_REPORT_LINES.web_parameter_id%TYPE,
470: expense_type_disp VARCHAR2(80),
471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,
472: adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,
473: adjustment_reason_code_disp VARCHAR2(80),
474: adjustment_reason_description AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
475: adjustment_reason AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
476: credit_card_expense_disp VARCHAR2(80),

Line 474: adjustment_reason_description AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,

470: expense_type_disp VARCHAR2(80),
471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,
472: adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,
473: adjustment_reason_code_disp VARCHAR2(80),
474: adjustment_reason_description AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
475: adjustment_reason AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
476: credit_card_expense_disp VARCHAR2(80),
477: itemized_expense_disp VARCHAR2(80)
478: ); /* end TYPE AdjustmentRecordType */

Line 475: adjustment_reason AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,

471: justification AP_EXPENSE_REPORT_LINES.justification%TYPE,
472: adjustment_reason_code AP_EXPENSE_REPORT_LINES.adjustment_reason_code%TYPE,
473: adjustment_reason_code_disp VARCHAR2(80),
474: adjustment_reason_description AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
475: adjustment_reason AP_EXPENSE_REPORT_LINES.adjustment_reason%TYPE,
476: credit_card_expense_disp VARCHAR2(80),
477: itemized_expense_disp VARCHAR2(80)
478: ); /* end TYPE AdjustmentRecordType */
479:

Line 487: PROCEDURE InsertLine(expense_line_rec in AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE);

483: * jrautiai ADJ Fix
484: * Need the ability to insert a single row, this procedure inserts a row in the
485: * database, using the data provided in the record given as parameter.
486: */
487: PROCEDURE InsertLine(expense_line_rec in AP_EXPENSE_REPORT_LINES_ALL%ROWTYPE);
488:
489: /**
490: * rlangi AUDIT
491: * Check to see if there are any line level audit issue