1 PACKAGE HZ_MIXNM_API_DYNAMIC_PKG AS
2 /*$Header: ARHXAPIS.pls 120.2 2005/10/30 04:23:23 appldev noship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7
8 /**
9 * PROCEDURE initAttributeList
10 *
11 * DESCRIPTION
12 * Initialize attribute list
13 *
14 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15 *
16 * ARGUMENTS
17 * IN:
18 * p_create_update_flag Create update flag.
19 * p_new_rec New person record.
20 * p_old_rec Old person record.
21 * OUT:
22 * x_name_list A list of attribute name. The attribute should
23 * be a restricted attribute (i.e. defined in setup
24 * tables) and it should not be null in creation and
25 * it should be updated in update.
26 * x_new_value_is_null_list Is 'Y' if the restricted column in the new record
27 * has null value.
28 *
29 * NOTES
30 *
31 * MODIFICATION HISTORY
32 *
33 * 05-01-2002 Jianying Huang o Created
34 */
35
36 PROCEDURE initAttributeList (
37 p_create_update_flag IN VARCHAR2,
38 p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
39 p_old_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
40 x_name_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
41 x_new_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
42 );
43
44 /**
45 * PROCEDURE getColumnNullProperty
46 *
47 * DESCRIPTION
48 * Return null property of attributes in person record.
49 *
50 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
51 *
52 * ARGUMENTS
53 * IN:
54 * p_sst_rec SST person record.
55 * OUT:
56 * x_value_is_null_list Is 'Y' if the restricted column in the SST record
57 * has null value.
58 * x_value_is_not_null_list Is 'Y' if the restricted column in the new record
59 * has not-null value.
60 *
61 * NOTES
62 *
63 * MODIFICATION HISTORY
64 *
65 * 05-01-2002 Jianying Huang o Created
66 */
67
68 PROCEDURE getColumnNullProperty (
69 p_sst_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
70 x_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
71 x_value_is_not_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
72 );
73
74 /**
75 * PROCEDURE createSSTRecord
76 *
77 * DESCRIPTION
78 * Create SST record.
79 *
80 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
81 *
82 * ARGUMENTS
83 * IN:
84 * p_new_data_source New data source type.
85 * p_new_rec New person record.
86 * IN/OUT:
87 * p_sst_rec SST person record.
88 * p_updateable_flag_list A list of updateable property.
89 * p_exception_type_list A list of exception type.
90 *
91 * NOTES
92 *
93 * MODIFICATION HISTORY
94 *
95 * 05-01-2002 Jianying Huang o Created
96 */
97
98 PROCEDURE createSSTRecord (
99 p_new_data_source IN VARCHAR2,
100 p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
101 p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
102 p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
103 p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
104 );
105
106 /**
107 * PROCEDURE updateSSTRecord
108 *
109 * DESCRIPTION
110 * Update SST record.
111 *
112 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
113 *
114 * ARGUMENTS
115 * IN:
116 * p_new_data_source New data source type.
117 * p_new_rec New person record.
118 * p_new_value_is_null_list Is 'Y' if the restricted column in the new record
119 * has null value.
120 * IN/OUT:
121 * p_sst_rec SST person record.
122 * p_updateable_flag_list A list of updateable property.
123 * p_exception_type_list A list of exception type.
124 * x_data_source_list Data source list.
125 *
126 * NOTES
127 *
128 * MODIFICATION HISTORY
129 *
130 * 05-01-2002 Jianying Huang o Created
131 */
132
133 PROCEDURE updateSSTRecord (
134 -- Bug 4201309 : add parameter p_create_update_flag
135 p_create_update_flag IN VARCHAR2,
136 p_new_data_source IN VARCHAR2,
137 p_new_rec IN HZ_PARTY_V2PUB.PERSON_REC_TYPE,
138 p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
139 p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
140 p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
141 p_new_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
142 x_data_source_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
143 );
144
145 /**
146 * PROCEDURE initAttributeList
147 *
148 * DESCRIPTION
149 * Initialize attribute list
150 *
151 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
152 *
153 * ARGUMENTS
154 * IN:
155 * p_create_update_flag Create update flag.
156 * p_new_rec New organization record.
157 * p_old_rec Old organization record.
158 * OUT:
159 * x_name_list A list of attribute name. The attribute should
160 * be a restricted attribute (i.e. defined in setup
161 * tables) and it should not be null in creation and
162 * it should be updated in update.
163 * x_new_value_is_null_list Is 'Y' if the restricted column in the new record
164 * has null value.
165 *
166 * NOTES
167 *
168 * MODIFICATION HISTORY
169 *
170 * 05-01-2002 Jianying Huang o Created
171 */
172
173 PROCEDURE initAttributeList (
174 p_create_update_flag IN VARCHAR2,
175 p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
176 p_old_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
177 x_name_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
178 x_new_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
179 );
180
181 /**
182 * PROCEDURE getColumnNullProperty
183 *
184 * DESCRIPTION
185 * Return null property of attributes in organization record.
186 *
187 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
188 *
189 * ARGUMENTS
190 * IN:
191 * p_sst_rec SST organization record.
192 * OUT:
193 * x_value_is_null_list Is 'Y' if the restricted column in the SST record
194 * has null value.
195 * x_value_is_not_null_list Is 'Y' if the restricted column in the new record
196 * has not-null value.
197 *
198 * NOTES
199 *
200 * MODIFICATION HISTORY
201 *
202 * 05-01-2002 Jianying Huang o Created
203 */
204
205 PROCEDURE getColumnNullProperty (
206 p_sst_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
207 x_value_is_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
208 x_value_is_not_null_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List
209 );
210
211 /**
212 * PROCEDURE createSSTRecord
213 *
214 * DESCRIPTION
215 * Create SST record.
216 *
217 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
218 *
219 * ARGUMENTS
220 * IN:
221 * p_new_data_source New data source type.
222 * p_new_rec New organization record.
223 * IN/OUT:
224 * p_sst_rec SST organization record.
225 * p_updateable_flag_list A list of updateable property.
226 * p_exception_type_list A list of exception type.
227 *
228 * NOTES
229 *
230 * MODIFICATION HISTORY
231 *
232 * 05-01-2002 Jianying Huang o Created
233 */
234
235 PROCEDURE createSSTRecord (
236 p_new_data_source IN VARCHAR2,
237 p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
238 p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
239 p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
240 p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
241 );
242
243 /**
244 * PROCEDURE updateSSTRecord
245 *
246 * DESCRIPTION
247 * Update SST record.
248 *
249 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
250 *
251 * ARGUMENTS
252 * IN:
253 * p_new_data_source New data source type.
254 * p_new_rec New organization record.
255 * p_new_value_is_null_list Is 'Y' if the restricted column in the new record
256 * has null value.
257 * IN/OUT:
258 * p_sst_rec SST organization record.
259 * p_updateable_flag_list A list of updateable property.
260 * p_exception_type_list A list of exception type.
261 * x_data_source_list Data source list.
262 *
263 * NOTES
264 *
265 * MODIFICATION HISTORY
266 *
267 * 05-01-2002 Jianying Huang o Created
268 */
269
270 PROCEDURE updateSSTRecord (
271 -- Bug 4201309 : add parameter p_create_update_flag
272 p_create_update_flag IN VARCHAR2,
273 p_new_data_source IN VARCHAR2,
274 p_new_rec IN HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
275 p_sst_rec IN OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
276 p_updateable_flag_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
277 p_exception_type_list IN OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List,
278 p_new_value_is_null_list IN HZ_MIXNM_UTILITY.INDEXVARCHAR1List,
279 x_data_source_list OUT NOCOPY HZ_MIXNM_UTILITY.INDEXVARCHAR30List
280 );
281
282 END HZ_MIXNM_API_DYNAMIC_PKG;