1 PACKAGE FND_UPDATE_USER_PREF_PUB AUTHID CURRENT_USER AS
2 /* $Header: fndpiprs.pls 120.1 2005/07/02 03:35:07 appldev noship $ */
3
4 -- Global constants
5
6 -- Pre-defined validation levels
7 --
8 TYPE preference_rec IS RECORD
9 (
10 purpose_code VARCHAR2(30),
11 purpose_default_code VARCHAR2(10),
12 user_option VARCHAR2(10));
13
14 TYPE preference_tbl IS TABLE OF preference_rec
15 INDEX BY BINARY_INTEGER;
16 /* this procedure is used to set the switch of opt-out of all purposes */
17 PROCEDURE set_donotuse_preference
18 ( p_api_version IN NUMBER,
19 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
20 p_commit IN VARCHAR2 DEFAULT NULL,
21 p_user_id IN NUMBER DEFAULT NULL ,
22 p_party_id IN NUMBER DEFAULT NULL,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2
26 );
27
28
29 /* this procedure is used to set the user to default option for all business purposes */
30 PROCEDURE set_default_preference
31 ( p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
33 p_commit IN VARCHAR2 DEFAULT NULL,
34 p_user_id IN NUMBER DEFAULT NULL ,
35 p_party_id IN NUMBER DEFAULT NULL,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 /* this procedure is used to individually opt-in /opt-out of business purposes */
42 PROCEDURE set_purpose_option
43 ( p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
45 p_commit IN VARCHAR2 DEFAULT NULL,
46 p_user_id IN NUMBER DEFAULT NULL ,
47 p_party_id IN NUMBER DEFAULT NULL ,
48 p_option IN preference_tbl ,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53
54
55 END FND_UPDATE_USER_PREF_PUB;