1 PACKAGE AP_WEB_OA_DISC_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwoadis.pls 115.7 2004/01/30 05:00:13 ammishra noship $ */
3
4 SUBTYPE DefaultExchangeRates IS AP_POL_EXRATE_OPTIONS.default_exchange_rates%TYPE;
5
6 TYPE PolicyRateOptionsRec IS RECORD (
7 default_exchange_rates DefaultExchangeRates
8 );
9
10
11 Procedure OAExpReport(
12 p_exp IN VARCHAR2,
13 p_empid IN VARCHAR2,
14 p_receipt_count OUT NOCOPY NUMBER,
15 p_receipt_with_error OUT NOCOPY NUMBER,
16 p_error_type OUT NOCOPY VARCHAR2,
17 p_return_status OUT NOCOPY VARCHAR2,
18 p_msg_count OUT NOCOPY NUMBER,
19 p_msg_data OUT NOCOPY VARCHAR2);
20
21
22 Function AreMPDRateSchedulesAssigned (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE) RETURN boolean;
23 Function ArePCRateSchedulesAssigned (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE) RETURN boolean;
24 Function AreExpenseFieldsRequired (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE) RETURN boolean;
25 Function AreExpenseFieldsEnabled (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE) RETURN boolean;
26 Function IsItemizationRequired (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE) RETURN boolean;
27 Function AreMerchantFieldsRequired RETURN boolean;
28 Function IsExchangeRateSetup RETURN boolean;
29 Function IsGrantsEnabled RETURN boolean;
30 Function IsLineLevelAcctingEnabled RETURN boolean;
31 /*========================================================================
32 | PROCEDURE GetPolicyRateOptions
33 |
34 | DESCRIPTION
35 | Get the default_exchange_rates from ap_pol_exrate_options
36 | we can add other fields to the record PolicyRateOptionsRec and
37 | the select statement to get values for other fields
38 |
39 | PARAMETERS
40 | None
41 |
42 | MODIFICATION HISTORY
43 | Date Author Description of Changes
44 | 28-JUL-2003 Srihari Koukuntla Created
45 |
46 *=======================================================================*/
47 PROCEDURE GetPolicyRateOptions(p_policyRateOptions OUT NOCOPY PolicyRateOptionsRec);
48
49 END AP_WEB_OA_DISC_PKG;
50
[Home] [Help]