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_EXPTEMPLATE_PKG dependencies on AP_EXPENSE_REPORT_PARAMS

Line 5: SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;

1: PACKAGE AP_WEB_DB_EXPTEMPLATE_PKG AUTHID CURRENT_USER AS
2: /* $Header: apwdbets.pls 115.12 2003/08/15 10:59:50 jrautiai ship $ */
3:
4: ---------------------------------------------------------------------------------------------------
5: SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;
6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;

Line 6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;

2: /* $Header: apwdbets.pls 115.12 2003/08/15 10:59:50 jrautiai ship $ */
3:
4: ---------------------------------------------------------------------------------------------------
5: SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;
6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;

Line 7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;

3:
4: ---------------------------------------------------------------------------------------------------
5: SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;
6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;

Line 8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;

4: ---------------------------------------------------------------------------------------------------
5: SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;
6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;

Line 9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;

5: SUBTYPE expTempl_paramID IS AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE;
6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;

Line 10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;

6: SUBTYPE expTempl_reportID IS AP_EXPENSE_REPORT_PARAMS.expense_report_id%TYPE;
7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;

Line 11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;

7: SUBTYPE expTempl_flexConcat IS AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;

Line 12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;

8: SUBTYPE expTempl_vatCode IS AP_EXPENSE_REPORT_PARAMS.vat_code%TYPE;
9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;

Line 13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;

9: SUBTYPE expTempl_amtInclTaxFlag IS AP_EXPENSE_REPORT_PARAMS.amount_includes_tax_flag%TYPE;
10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;
17: SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;

Line 14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;

10: SUBTYPE expTempl_lineTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.line_type_lookup_code%TYPE;
11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;
17: SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
18:

Line 15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;

11: SUBTYPE expTempl_prompt IS AP_EXPENSE_REPORT_PARAMS.prompt%TYPE;
12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;
17: SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
18:
19:

Line 16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;

12: SUBTYPE expTempl_webFriendlyPrompt IS AP_EXPENSE_REPORT_PARAMS.web_friendly_prompt%TYPE;
13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;
17: SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
18:
19:
20:

Line 17: SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;

13: SUBTYPE expTempl_requireReceiptAmt IS AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
14: SUBTYPE expTempl_cardExpTypeLookupCode IS AP_EXPENSE_REPORT_PARAMS.card_exp_type_lookup_code%TYPE;
15: SUBTYPE expTempl_justificationReqdFlag IS AP_EXPENSE_REPORT_PARAMS.justification_required_flag%TYPE;
16: SUBTYPE expTempl_paExpenditureType IS AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE;
17: SUBTYPE expTempl_calcAmtFlag IS AP_EXPENSE_REPORT_PARAMS.calculate_amount_flag%TYPE;
18:
19:
20:
21: SUBTYPE expTypes_reportID IS AP_EXPENSE_REPORTS.expense_report_id%TYPE;