[Home] [Help]
PACKAGE: APPS.HZ_EXTENSIBILITY_PVT
Source
1 PACKAGE HZ_EXTENSIBILITY_PVT AS
2 /* $Header: ARHEXTCS.pls 120.2 2005/08/30 19:07:52 geliu noship $ */
3
4 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ARHEXTCS.pls';
5
6 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_SUCCESS; --'S'
7 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_ERROR; --'E'
8 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.g_RET_STS_UNEXP_ERROR; --'U'
9
10 -- Define the package global constants to substitute FND_API global variables for missing values
11 G_MISS_NUM CONSTANT NUMBER := 9.99E125;
12 G_MISS_CHAR CONSTANT VARCHAR2(1) := CHR(0);
13 G_MISS_DATE CONSTANT DATE := TO_DATE('1','j');
14
15
16
17 -- -----------------------------------------------------------------------------
18 -- API Name: Process_User_Attrs_For_Item
19 --
20 -- Description:
21 -- Process passed-in User-Defined Attrs data for
22 -- the Item whose Primary Keys are passed in
23 -- -----------------------------------------------------------------------------
24 PROCEDURE Process_User_Attrs_For_Item (
25 p_api_version IN NUMBER
26 ,p_owner_table_id IN NUMBER
27 ,p_owner_table_name IN VARCHAR2
28 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
29 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
30 ,p_entity_id IN NUMBER DEFAULT NULL
31 ,p_entity_index IN NUMBER DEFAULT NULL
32 ,p_entity_code IN VARCHAR2 DEFAULT NULL
33 ,p_debug_level IN NUMBER DEFAULT 0
34 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
35 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
36 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
37 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
38 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
39 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
40 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_errorcode OUT NOCOPY NUMBER
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 -- -----------------------------------------------------------------------------
48 -- API Name: Get_User_Attrs_For_Item
49 --
50 -- Description:
51 -- Fetch passed-in User-Defined Attrs data for
52 -- the Item whose Primary Keys are passed in
53 -- -----------------------------------------------------------------------------
54 PROCEDURE Get_User_Attrs_For_Item (
55 p_api_version IN NUMBER
56 ,p_org_profile_id IN NUMBER
57 ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
58 ,p_entity_id IN NUMBER DEFAULT NULL
59 ,p_entity_index IN NUMBER DEFAULT NULL
60 ,p_entity_code IN VARCHAR2 DEFAULT NULL
61 ,p_debug_level IN NUMBER DEFAULT 0
62 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
63 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
64 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
65 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
66 ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
67 ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_errorcode OUT NOCOPY NUMBER
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74
75 /**
76 * PROCEDURE copy_person_extent_data
77 *
78 * DESCRIPTION
79 * Copy person extent data. This procedure will be called whenever
80 * a new person profile is created for maintain history reason.
81 *
82 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
83 *
84 * ARGUMENTS
85 * IN:
86 * p_old_profile_id Old profile Id.
87 * p_new_profile_id New profile Id.
88 * IN/OUT:
89 * OUT:
90 * x_return_status Return status after the call. The status can
91 * be FND_API.G_RET_STS_SUCCESS (success),
92 * FND_API.G_RET_STS_ERROR (error),
93 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
94 *
95 * NOTES
96 *
97 * MODIFICATION HISTORY
98 *
99 * 12-01-2004 Jianying Huang o Created.
100 *
101 */
102
103 PROCEDURE copy_person_extent_data (
104 p_old_profile_id IN NUMBER,
105 p_new_profile_id IN NUMBER,
106 x_return_status IN OUT NOCOPY VARCHAR2
107 );
108
109
110 /**
111 * PROCEDURE copy_org_extent_data
112 *
113 * DESCRIPTION
114 * Copy organization extent data. This procedure will be called whenever
115 * a new organization profile is created for maintain history reason.
116 *
117 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
118 *
119 * ARGUMENTS
120 * IN:
121 * p_old_profile_id Old profile Id.
122 * p_new_profile_id New profile Id.
123 * IN/OUT:
124 * OUT:
125 * x_return_status Return status after the call. The status can
126 * be FND_API.G_RET_STS_SUCCESS (success),
127 * FND_API.G_RET_STS_ERROR (error),
128 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129 *
130 * NOTES
131 *
132 * MODIFICATION HISTORY
133 *
134 * 12-01-2004 Jianying Huang o Created.
135 *
136 */
137
138 PROCEDURE copy_org_extent_data (
139 p_old_profile_id IN NUMBER,
140 p_new_profile_id IN NUMBER,
141 x_return_status IN OUT NOCOPY VARCHAR2
142 );
143
144
145 /**
146 * PUBLIC PROCEDURE copy_org_conc_main
147 *
148 * DESCRIPTION
149 * Main concurrent program to copy organization extension data
150 *
151 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
152 *
153 * IN:
154 * p_batch_size Batch Size
155 * p_number_of_worker Number of Worker
156 *
157 * MODIFICATION HISTORY
158 *
159 * 03-15-2005 Jianying Huang o Created.
160 */
161
162 PROCEDURE copy_org_conc_main (
163 errbuf OUT NOCOPY VARCHAR2,
164 retcode OUT NOCOPY VARCHAR2,
165 p_batch_size IN NUMBER,
166 p_number_of_worker IN NUMBER
167 );
168
169
170 /**
171 * PUBLIC PROCEDURE copy_per_conc_main
172 *
173 * DESCRIPTION
174 * Main concurrent program to copy person extension data
175 *
176 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
177 *
178 * IN:
179 * p_batch_size Batch Size
180 * p_number_of_worker Number of Worker
181 *
182 * MODIFICATION HISTORY
183 *
184 * 03-15-2005 Jianying Huang o Created.
185 */
186
187 PROCEDURE copy_per_conc_main (
188 errbuf OUT NOCOPY VARCHAR2,
189 retcode OUT NOCOPY VARCHAR2,
190 p_batch_size IN NUMBER,
191 p_number_of_worker IN NUMBER
192 );
193
194
195 /**
196 * PUBLIC PROCEDURE copy_org_conc_sub
197 *
198 * DESCRIPTION
199 * Sub concurrent program to copy organization extension data
200 *
201 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
202 *
203 * IN:
204 * p_parent_request_id Parent Request ID
205 *
206 * MODIFICATION HISTORY
207 *
208 * 03-15-2005 Jianying Huang o Created.
209 */
210
211 PROCEDURE copy_org_conc_sub (
212 errbuf OUT NOCOPY VARCHAR2,
213 retcode OUT NOCOPY VARCHAR2,
214 p_parent_request_id IN NUMBER
215 );
216
217
218 /**
219 * PUBLIC PROCEDURE copy_per_conc_sub
220 *
221 * DESCRIPTION
222 * Sub concurrent program to copy person extension data
223 *
224 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
225 *
226 * IN:
227 * p_parent_request_id Parent Request ID
228 *
229 * MODIFICATION HISTORY
230 *
231 * 03-15-2005 Jianying Huang o Created.
232 */
233
234 PROCEDURE copy_per_conc_sub (
235 errbuf OUT NOCOPY VARCHAR2,
236 retcode OUT NOCOPY VARCHAR2,
237 p_parent_request_id IN NUMBER
238 );
239
240 END HZ_EXTENSIBILITY_PVT;