DBA Data[Home] [Help]

PACKAGE: APPS.WIP_WPS_PREFERENCES_PKG

Source


1 PACKAGE WIP_WPS_PREFERENCES_PKG AUTHID CURRENT_USER AS
2 /* $Header: wipzprfs.pls 120.0 2005/05/25 12:49:57 appldev noship $ */
3 
4     /**
5      * This will remove all the saved preferences for the given application/user
6      * combination.
7      */
8      PROCEDURE delete_user_preferences(x_application_id NUMBER,
9 				       x_organization_id NUMBER,
10 				       x_user_id NUMBER);
11 
12      /**
13       * Same as above, but will look at the module as well. added 11.5.10
14       */
15      PROCEDURE delete_user_preferences(x_application_id NUMBER,
16 				       x_organization_id NUMBER,
17 				       x_user_id NUMBER,
18 				       x_module_id NUMBER);
19 
20      /**
21       * Same as above, but will look at the module and preference type as well.
22       * Added 11.5.11
23       */
24      PROCEDURE delete_user_preferences(x_application_id NUMBER,
25 				       x_organization_id NUMBER,
26 				       x_user_id NUMBER,
27 				       x_module_id NUMBER,
28                                        x_preference_type NUMBER);
29 
30     /**
31      * This will insert a record into the preference table.
32      */
33      PROCEDURE insert_preference(x_application_id NUMBER,
34 				 x_organization_id NUMBER,
35 				 x_user_id NUMBER,
36 				 x_preference_type NUMBER,
37 				 x_value VARCHAR2,
38 				 x_value_index NUMBER);
39 
40       PROCEDURE insert_preference(x_application_id NUMBER,
41 				 x_organization_id NUMBER,
42 				 x_user_id NUMBER,
43 				 x_preference_type NUMBER,
44 				 x_value VARCHAR2,
45 				  x_value_index NUMBER,
46 				  x_module_id NUMBER);
47 
48 
49 
50 END WIP_WPS_PREFERENCES_PKG;