[Home] [Help]
PACKAGE BODY: APPS.HZ_EXTENSIBILITY_PUB
Source
1 PACKAGE BODY HZ_EXTENSIBILITY_PUB AS
2 /* $Header: ARHEXTSB.pls 120.1 2005/08/30 19:06:50 geliu noship $ */
3
4 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTSB.pls';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_EXTENSIBILITY_PUB';
6
7 G_USER_ID NUMBER := FND_GLOBAL.User_Id;
8 G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
9
10
11 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTSB.pls';
12 G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_EXTENSIBILITY_PUB';
13
14 G_USER_ID NUMBER := FND_GLOBAL.User_Id;
15 G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;
16
17
18 PROCEDURE Process_Organization_Record (
19 p_api_version IN NUMBER
20 ,p_org_profile_id IN NUMBER
21 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
22 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
23 ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
24 ,p_entity_id IN NUMBER DEFAULT NULL
25 ,p_entity_index IN NUMBER DEFAULT NULL
26 ,p_entity_code IN VARCHAR2 DEFAULT NULL
27 ,p_debug_level IN NUMBER DEFAULT 0
28 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
29 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
30 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
32 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
33 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
34 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_errorcode OUT NOCOPY NUMBER
37 ,x_msg_count OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39 ) IS
40
41 BEGIN
42 -- Add the code here to validate the ID's passed
43 -- Before caalling the PVT API.
44 --
45 -- Need to be filled in.
46 --
47
48 HZ_EXTENSIBILITY_PVT.Process_User_Attrs_For_Item(
49 p_api_version => p_api_version
50 ,p_owner_table_id => p_org_profile_id
51 ,p_owner_table_name => 'HZ_ORGANIZATION_PROFILES'
52 ,p_attributes_row_table => p_attributes_row_table
53 ,p_attributes_data_table => p_attributes_data_table
54 ,p_entity_id => p_entity_id
55 ,p_entity_index => p_entity_index
56 ,p_entity_code => p_entity_code
57 ,p_debug_level => p_debug_level
58 ,p_init_error_handler => p_init_error_handler
59 ,p_write_to_concurrent_log => p_write_to_concurrent_log
60 ,p_init_fnd_msg_list => p_init_fnd_msg_list
61 ,p_log_errors => p_log_errors
62 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
63 ,p_commit => p_commit
64 ,x_failed_row_id_list => x_failed_row_id_list
65 ,x_return_status => x_return_status
66 ,x_errorcode => x_errorcode
67 ,x_msg_count => x_msg_count
68 ,x_msg_data => x_msg_data
69 );
70
71 END Process_Organization_Record;
72
73 PROCEDURE Process_Person_Record (
74 p_api_version IN NUMBER
75 ,p_person_profile_id IN NUMBER
76 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
77 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
78 ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
79 ,p_entity_id IN NUMBER DEFAULT NULL
80 ,p_entity_index IN NUMBER DEFAULT NULL
81 ,p_entity_code IN VARCHAR2 DEFAULT NULL
82 ,p_debug_level IN NUMBER DEFAULT 0
83 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
84 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
85 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
86 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
87 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
88 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
89 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_errorcode OUT NOCOPY NUMBER
92 ,x_msg_count OUT NOCOPY NUMBER
93 ,x_msg_data OUT NOCOPY VARCHAR2
94 ) IS
95
96 BEGIN
97 -- Add the code here to validate the ID's passed
98 -- Before caalling the PVT API.
99 --
100 -- Need to be filled in.
101 --
102
103 HZ_EXTENSIBILITY_PVT.Process_User_Attrs_For_Item(
104 p_api_version => p_api_version
105 ,p_owner_table_id => p_person_profile_id
106 ,p_owner_table_name => 'HZ_PERSON_PROFILES'
107 ,p_attributes_row_table => p_attributes_row_table
108 ,p_attributes_data_table => p_attributes_data_table
109 ,p_entity_id => p_entity_id
110 ,p_entity_index => p_entity_index
111 ,p_entity_code => p_entity_code
112 ,p_debug_level => p_debug_level
113 ,p_init_error_handler => p_init_error_handler
114 ,p_write_to_concurrent_log => p_write_to_concurrent_log
115 ,p_init_fnd_msg_list => p_init_fnd_msg_list
116 ,p_log_errors => p_log_errors
117 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
118 ,p_commit => p_commit
119 ,x_failed_row_id_list => x_failed_row_id_list
120 ,x_return_status => x_return_status
121 ,x_errorcode => x_errorcode
122 ,x_msg_count => x_msg_count
123 ,x_msg_data => x_msg_data
124 );
125
126 END Process_Person_Record;
127
128 PROCEDURE Process_Location_Record (
129 p_api_version IN NUMBER
130 ,p_location_id IN NUMBER
131 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
132 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
133 ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
134 ,p_entity_id IN NUMBER DEFAULT NULL
135 ,p_entity_index IN NUMBER DEFAULT NULL
136 ,p_entity_code IN VARCHAR2 DEFAULT NULL
137 ,p_debug_level IN NUMBER DEFAULT 0
138 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
139 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
140 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
141 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
142 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
143 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
144 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_errorcode OUT NOCOPY NUMBER
147 ,x_msg_count OUT NOCOPY NUMBER
148 ,x_msg_data OUT NOCOPY VARCHAR2
149 ) IS
150
151 BEGIN
152 -- Add the code here to validate the ID's passed
153 -- Before caalling the PVT API.
154 --
155 -- Need to be filled in.
156 --
157 HZ_EXTENSIBILITY_PVT.Process_User_Attrs_For_Item(
158 p_api_version => p_api_version
159 ,p_owner_table_id => p_location_id
160 ,p_owner_table_name => 'HZ_LOCATIONS'
161 ,p_attributes_row_table => p_attributes_row_table
162 ,p_attributes_data_table => p_attributes_data_table
163 ,p_entity_id => p_entity_id
164 ,p_entity_index => p_entity_index
165 ,p_entity_code => p_entity_code
166 ,p_debug_level => p_debug_level
167 ,p_init_error_handler => p_init_error_handler
168 ,p_write_to_concurrent_log => p_write_to_concurrent_log
169 ,p_init_fnd_msg_list => p_init_fnd_msg_list
170 ,p_log_errors => p_log_errors
171 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
172 ,p_commit => p_commit
173 ,x_failed_row_id_list => x_failed_row_id_list
174 ,x_return_status => x_return_status
175 ,x_errorcode => x_errorcode
176 ,x_msg_count => x_msg_count
177 ,x_msg_data => x_msg_data
178 );
179
180 END Process_Location_Record;
181
182 PROCEDURE Process_PartySite_Record (
183 p_api_version IN NUMBER
184 ,p_party_site_id IN NUMBER
185 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
186 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
187 ,p_change_info_table IN EGO_USER_ATTR_CHANGE_TABLE DEFAULT NULL
188 ,p_entity_id IN NUMBER DEFAULT NULL
189 ,p_entity_index IN NUMBER DEFAULT NULL
190 ,p_entity_code IN VARCHAR2 DEFAULT NULL
191 ,p_debug_level IN NUMBER DEFAULT 0
192 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
193 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
194 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
195 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
196 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
197 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
198 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
199 ,x_return_status OUT NOCOPY VARCHAR2
200 ,x_errorcode OUT NOCOPY NUMBER
201 ,x_msg_count OUT NOCOPY NUMBER
202 ,x_msg_data OUT NOCOPY VARCHAR2
203 ) IS
204
205 BEGIN
206 -- Add the code here to validate the ID's passed
207 -- Before caalling the PVT API.
208 --
209 -- Need to be filled in.
210 --
211
212 HZ_EXTENSIBILITY_PVT.Process_User_Attrs_For_Item(
213 p_api_version => p_api_version
214 ,p_owner_table_id => p_party_site_id
215 ,p_owner_table_name => 'HZ_PARTY_SITES'
216 ,p_attributes_row_table => p_attributes_row_table
217 ,p_attributes_data_table => p_attributes_data_table
218 ,p_entity_id => p_entity_id
219 ,p_entity_index => p_entity_index
220 ,p_entity_code => p_entity_code
221 ,p_debug_level => p_debug_level
222 ,p_init_error_handler => p_init_error_handler
223 ,p_write_to_concurrent_log => p_write_to_concurrent_log
224 ,p_init_fnd_msg_list => p_init_fnd_msg_list
225 ,p_log_errors => p_log_errors
226 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
227 ,p_commit => p_commit
228 ,x_failed_row_id_list => x_failed_row_id_list
229 ,x_return_status => x_return_status
230 ,x_errorcode => x_errorcode
231 ,x_msg_count => x_msg_count
232 ,x_msg_data => x_msg_data
233 );
234
235 END Process_PartySite_Record;
236
237 PROCEDURE Get_User_Attrs_For_Item (
238 p_api_version IN NUMBER
239 ,p_org_profile_id IN NUMBER
240 ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
241 ,p_entity_id IN NUMBER DEFAULT NULL
242 ,p_entity_index IN NUMBER DEFAULT NULL
243 ,p_entity_code IN VARCHAR2 DEFAULT NULL
244 ,p_debug_level IN NUMBER DEFAULT 0
245 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
246 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
247 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
248 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
249 ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
250 ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
251 ,x_return_status OUT NOCOPY VARCHAR2
252 ,x_errorcode OUT NOCOPY NUMBER
253 ,x_msg_count OUT NOCOPY NUMBER
254 ,x_msg_data OUT NOCOPY VARCHAR2
255 ) IS
256
257 BEGIN
258
259 HZ_EXTENSIBILITY_PVT.Get_User_Attrs_For_Item(
260 p_api_version => p_api_version
261 ,p_org_profile_id => p_org_profile_id
262 ,p_attr_group_request_table => p_attr_group_request_table
263 ,p_entity_id => p_entity_id
264 ,p_entity_index => p_entity_index
265 ,p_entity_code => p_entity_code
266 ,p_debug_level => p_debug_level
267 ,p_init_error_handler => p_init_error_handler
268 ,p_init_fnd_msg_list => p_init_fnd_msg_list
269 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
270 ,p_commit => p_commit
271 ,x_attributes_row_table => x_attributes_row_table
272 ,x_attributes_data_table => x_attributes_data_table
273 ,x_return_status => x_return_status
274 ,x_errorcode => x_errorcode
275 ,x_msg_count => x_msg_count
276 ,x_msg_data => x_msg_data
277 );
278
279 END Get_User_Attrs_For_Item;
280
281 END HZ_EXTENSIBILITY_PUB;