[Home] [Help]
PACKAGE: APPS.ASF_USER_PREFERENCE_PUB
Source
1 PACKAGE ASF_USER_PREFERENCE_PUB AUTHID CURRENT_USER as
2 /* $Header: asfuprfs.pls 115.3 2003/01/21 22:31:13 hoyuan ship $ */
3 -- Start of Comments
4 --
5 -- NAME
6 -- ASF_USER_PREFERENCE_PUB
7 --
8 TYPE user_preference_rec_type IS RECORD
9 (PREFERENCE_ID NUMBER := FND_API.G_MISS_NUM
10 ,USER_ID NUMBER := FND_API.G_MISS_NUM
11 ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12 ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13 ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14 ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15 ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16 ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17 ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18 ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19 ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20 ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21 ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22 ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23 ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24 ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25 ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26 ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27 ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28 ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29 ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30 ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31 ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32 ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33 ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34 ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35 ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36 ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
37 );
38
39 G_MISS_USER_PREFERENCE_REC user_preference_rec_type;
40
41 -- Start of Comments
42 --
43 -- API name : Create_Preference
44 -- Type : Public.
45 -- Type : Public.
46 --
47 --
48 -- Required:
49 -- last_update_date
50 -- last_updated_by
51 -- creation_date
52 -- created_by
53 -- last_update_login
54 -- owner_table_name
55 -- owner_table_id
56 -- preference_code
57 -- user_id
58 --
59 -- End of Comments
60
61 PROCEDURE CREATE_PREFERENCE
62 ( p_user_preference_rec IN USER_PREFERENCE_REC_TYPE := G_MISS_USER_PREFERENCE_REC,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67 -- Start of Comments
68 --
69 -- API name : Update_Preference
70 -- Type : Public.
71 --
72 -- Required:
73 -- last_update_date
74 -- last_updated_by
75 -- last_update_login
76 -- preference_id
77 -- owner_table_name
78 -- owner_table_id
79 -- preference_code
80 -- user_id
81 --
82 -- End of Comments
83
84 PROCEDURE UPDATE_PREFERENCE
85 ( p_user_preference_rec IN USER_PREFERENCE_REC_TYPE := G_MISS_USER_PREFERENCE_REC,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91 -- Start of Comments
92 --
93 -- API name : Delete_Preference
94 -- Type : Public.
95 --
96 -- Function : Delete User Reference Record
97 --
98 -- End of Comments
99
100 PROCEDURE DELETE_PREFERENCE
101 ( p_user_preference_rec IN USER_PREFERENCE_REC_TYPE := G_MISS_USER_PREFERENCE_REC,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 End ASF_USER_PREFERENCE_PUB;