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;
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;
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:
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 (
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,
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,