[Home] [Help]
PACKAGE: APPS.JTF_PERZ_DATA_PVT
Source
1 PACKAGE JTF_PERZ_DATA_PVT AUTHID CURRENT_USER as
2 /* $Header: jtfzvpds.pls 120.2 2005/11/02 22:31:03 skothe ship $ */
3 --
4 --
5 -- Start of Comments
6 --
7 -- NAME
8 -- JTF_PERZ_DATA_PUB
9 --
10 -- PURPOSE
11 -- Public API for creating, getting and updating personalized data objects
12 -- in the Personalization Framework.
13 --
14 -- NOTES
15 -- This is a pulicly accessible pacakge. It should be used by all
16 -- sources for creating, getting and updating personalized data objects
17 -- in the Personalization Framework.
18 --
19 -- HISTORY
20 --
21 -- 09/20/99 SMATTEGU Created
22 --
23 -- End of Comments
24 --
25 --
26 -- *****************************************************************************
27 --
28 --
29
30 PROCEDURE Save_Perz_Data
31 ( p_api_version_number IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR := FND_API.G_FALSE,
34
35 p_application_id IN NUMBER,
36 p_profile_id IN NUMBER,
37 p_profile_name IN VARCHAR2,
38 p_profile_type IN VARCHAR2,
39 p_profile_attrib IN JTF_PERZ_PROFILE_PUB.PROFILE_ATTRIB_TBL_TYPE
40 := JTF_PERZ_PROFILE_PUB.G_MISS_PROFILE_ATTRIB_TBL,
41 p_perz_data_id IN NUMBER,
42 p_perz_data_name IN VARCHAR2,
43 p_perz_data_type IN VARCHAR2,
44 p_perz_data_desc IN VARCHAR2,
45 p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
46 := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
47
48 x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
49 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
50 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
51 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 );
53
54
55 -- *****************************************************************************
56 --
57
58 PROCEDURE Create_Perz_Data
59 ( p_api_version_number IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR := FND_API.G_FALSE,
62
63 p_application_id IN NUMBER,
64 p_profile_id IN NUMBER,
65 p_profile_name IN VARCHAR2,
66 p_perz_data_id IN NUMBER,
67 p_perz_data_name IN VARCHAR2,
68 p_perz_data_type IN VARCHAR2,
69 p_perz_data_desc IN VARCHAR2,
70 p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
71 := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
72
73 x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
74 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 );
78
79
80 -- *****************************************************************************
81
82 PROCEDURE Get_Perz_Data
83 ( p_api_version_number IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85
86 p_application_id IN NUMBER,
87 p_profile_id IN NUMBER,
88 p_profile_name IN VARCHAR2,
89 p_perz_data_id IN NUMBER,
90 p_perz_data_name IN VARCHAR2,
91 p_perz_data_type IN VARCHAR2 := NULL,
92
93 x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
94 x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95 x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
96 x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
97 x_data_attrib_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE,
98
99 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
101 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 );
103 -- *****************************************************************************
104
105 PROCEDURE Get_Perz_Data_Summary
106 ( p_api_version_number IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108
109 p_application_id IN NUMBER,
110 p_profile_id IN NUMBER,
111 p_profile_name IN VARCHAR2,
112 p_perz_data_id IN NUMBER,
113 p_perz_data_name IN VARCHAR2,
114 p_perz_data_type IN VARCHAR2 := NULL,
115
116 x_data_out_tbl OUT NOCOPY /* file.sql.39 change */ JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE,
117
118 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
119 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
120 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 );
122 -- *****************************************************************************
123 --
124
125 PROCEDURE Update_Perz_Data
126 ( p_api_version_number IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128 p_commit IN VARCHAR := FND_API.G_FALSE,
129
130 p_application_id IN NUMBER,
131 p_profile_id IN NUMBER,
132
133 p_perz_data_id IN NUMBER,
134 p_perz_data_name IN VARCHAR2,
135 p_perz_data_type IN VARCHAR2 := NULL,
136 p_perz_data_desc IN VARCHAR2,
137 p_data_attrib_tbl IN JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE
138 := JTF_PERZ_DATA_PUB.G_MISS_DATA_ATTRIB_TBL,
139
140 x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
141 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
143 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 );
145
146 -- *****************************************************************************
147 --
148
149 PROCEDURE Delete_Perz_Data
150 ( p_api_version_number IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 p_commit IN VARCHAR := FND_API.G_FALSE,
153
154 p_application_id IN NUMBER,
155 p_profile_id IN NUMBER,
156 p_perz_data_id IN NUMBER,
157
158 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
159 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
160 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
161 );
162
163 -- *****************************************************************************
164 -- *****************************************************************************
165 END JTF_PERZ_DATA_PVT;