PACKAGE: APPS.AP_WEB_DB_USER_PREF_PKG

Source

1 PACKAGE AP_WEB_DB_USER_PREF_PKG AS
2 /* $Header: apwdbups.pls 120.7 2006/02/24 07:30:35 sbalaji noship $ */
3 
4 SUBTYPE pref_DefaultApproverID        IS AP_WEB_PREFERENCES.DEFAULT_APPROVER_ID%TYPE;
5 SUBTYPE pref_DefaultExpenseTemplateID IS AP_WEB_PREFERENCES.DEFAULT_EXPENSE_TEMPLATE_ID%TYPE;
6 SUBTYPE pref_DefaultPurpose           IS AP_WEB_PREFERENCES.DEFAULT_PURPOSE%TYPE;
7 SUBTYPE pref_ValidateDetailsFlag      IS AP_WEB_PREFERENCES.VALIDATE_DETAILS_FLAG%TYPE;
8 SUBTYPE pref_DefaultForeignCurrFlag   IS AP_WEB_PREFERENCES.DEFAULT_FOREIGN_CURR_FLAG%TYPE;
9 SUBTYPE pref_DefaultExchangeRateFlag   IS AP_WEB_PREFERENCES.DEFAULT_EXCHANGE_RATE_FLAG%TYPE;
10 
11 TYPE UserPrefsInfoRec	IS RECORD (
12   default_approver_id         pref_DefaultApproverID,
13   default_expense_template_id pref_DefaultExpenseTemplateID,
14   default_purpose             pref_DefaultPurpose,
15   validate_details_flag       pref_ValidateDetailsFlag,
16   default_foreign_curr_flag   pref_DefaultForeignCurrFlag,
17   default_exchange_rate_flag  pref_DefaultExchangeRateFlag
18 );
19 
20 FUNCTION GetUserPrefs(p_employee_id   IN HR_EMPLOYEES_CURRENT_V.employee_id%TYPE,
21                       p_userPrefs_rec OUT NOCOPY UserPrefsInfoRec)
22 RETURN BOOLEAN;
23 
24 --------------------------------------------------------------------------------
25 PROCEDURE getCumulativeMileage(
26 	p_policy_id		IN AP_POL_LINES.POLICY_ID%TYPE,
27 	p_start_date		IN AP_EXPENSE_REPORT_LINES.start_expense_date%TYPE,
28 	p_end_date		IN AP_EXPENSE_REPORT_LINES.end_expense_date%TYPE,
29 	p_employee_id		IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE,
30 	p_cumulative_mileage OUT NOCOPY AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
31 	p_period_id	 OUT NOCOPY AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE
32 );
33 
34 END AP_WEB_DB_USER_PREF_PKG;