1 PACKAGE jg_globe_flex_val AS
2 /* $Header: jggdfvs.pls 120.6 2004/11/05 19:58:18 thwon ship $ */
3 --
4 -- Commented the following record definition as this has been moved
5 -- to jggdfvss.pls which is the shared procedure, to avoid cyclic references.
6 -- Needs to be deleted.
7 -- Record type is introduced to handle global_attributes
8 --
9 /*
10 TYPE GdfRec IS RECORD
11 (global_attribute_category VARCHAR2(30) DEFAULT NULL,
12 global_attribute1 VARCHAR2(150) DEFAULT NULL,
13 global_attribute2 VARCHAR2(150) DEFAULT NULL,
14 global_attribute3 VARCHAR2(150) DEFAULT NULL,
15 global_attribute4 VARCHAR2(150) DEFAULT NULL,
16 global_attribute5 VARCHAR2(150) DEFAULT NULL,
17 global_attribute6 VARCHAR2(150) DEFAULT NULL,
18 global_attribute7 VARCHAR2(150) DEFAULT NULL,
19 global_attribute8 VARCHAR2(150) DEFAULT NULL,
20 global_attribute9 VARCHAR2(150) DEFAULT NULL,
21 global_attribute10 VARCHAR2(150) DEFAULT NULL,
22 global_attribute11 VARCHAR2(150) DEFAULT NULL,
23 global_attribute12 VARCHAR2(150) DEFAULT NULL,
24 global_attribute13 VARCHAR2(150) DEFAULT NULL,
25 global_attribute14 VARCHAR2(150) DEFAULT NULL,
26 global_attribute15 VARCHAR2(150) DEFAULT NULL,
27 global_attribute16 VARCHAR2(150) DEFAULT NULL,
28 global_attribute17 VARCHAR2(150) DEFAULT NULL,
29 global_attribute18 VARCHAR2(150) DEFAULT NULL,
30 global_attribute19 VARCHAR2(150) DEFAULT NULL,
31 global_attribute20 VARCHAR2(150) DEFAULT NULL
32 );
33
34 TYPE GenRec IS RECORD
35 (core_prod_arg1 VARCHAR2(150) DEFAULT NULL,
36 core_prod_arg2 VARCHAR2(150) DEFAULT NULL,
37 core_prod_arg3 VARCHAR2(150) DEFAULT NULL,
38 core_prod_arg4 VARCHAR2(150) DEFAULT NULL,
39 core_prod_arg5 VARCHAR2(150) DEFAULT NULL,
40 core_prod_arg6 VARCHAR2(150) DEFAULT NULL,
41 core_prod_arg7 VARCHAR2(150) DEFAULT NULL,
42 core_prod_arg8 VARCHAR2(150) DEFAULT NULL,
43 core_prod_arg9 VARCHAR2(150) DEFAULT NULL,
44 core_prod_arg10 VARCHAR2(150) DEFAULT NULL,
45 core_prod_arg11 VARCHAR2(150) DEFAULT NULL,
46 core_prod_arg12 VARCHAR2(150) DEFAULT NULL,
47 core_prod_arg13 VARCHAR2(150) DEFAULT NULL,
48 core_prod_arg14 VARCHAR2(150) DEFAULT NULL,
49 core_prod_arg15 VARCHAR2(150) DEFAULT NULL,
50 core_prod_arg16 VARCHAR2(150) DEFAULT NULL,
51 core_prod_arg17 VARCHAR2(150) DEFAULT NULL,
52 core_prod_arg18 VARCHAR2(150) DEFAULT NULL,
53 core_prod_arg19 VARCHAR2(150) DEFAULT NULL,
54 core_prod_arg20 VARCHAR2(150) DEFAULT NULL,
55 core_prod_arg21 VARCHAR2(150) DEFAULT NULL,
56 core_prod_arg22 VARCHAR2(150) DEFAULT NULL,
57 core_prod_arg23 VARCHAR2(150) DEFAULT NULL,
58 core_prod_arg24 VARCHAR2(150) DEFAULT NULL,
59 core_prod_arg25 VARCHAR2(150) DEFAULT NULL,
60 core_prod_arg26 VARCHAR2(150) DEFAULT NULL,
61 core_prod_arg27 VARCHAR2(150) DEFAULT NULL,
62 core_prod_arg28 VARCHAR2(150) DEFAULT NULL,
63 core_prod_arg29 VARCHAR2(150) DEFAULT NULL,
64 core_prod_arg30 VARCHAR2(150) DEFAULT NULL
65 );
66 */
67
68 FUNCTION reassign_context_code
69 (p_global_context_code IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
70
71 PROCEDURE check_attr_value
72 (p_calling_program_name IN VARCHAR2,
73 p_global_attribute_category IN VARCHAR2,
74 p_global_attribute1 IN OUT NOCOPY VARCHAR2,
75 p_global_attribute2 IN OUT NOCOPY VARCHAR2,
76 p_global_attribute3 IN OUT NOCOPY VARCHAR2,
77 p_global_attribute4 IN OUT NOCOPY VARCHAR2,
78 p_global_attribute5 IN OUT NOCOPY VARCHAR2,
79 p_global_attribute6 IN OUT NOCOPY VARCHAR2,
80 p_global_attribute7 IN OUT NOCOPY VARCHAR2,
81 p_global_attribute8 IN OUT NOCOPY VARCHAR2,
82 p_global_attribute9 IN OUT NOCOPY VARCHAR2,
83 p_global_attribute10 IN OUT NOCOPY VARCHAR2,
84 p_global_attribute11 IN OUT NOCOPY VARCHAR2,
85 p_global_attribute12 IN OUT NOCOPY VARCHAR2,
86 p_global_attribute13 IN OUT NOCOPY VARCHAR2,
87 p_global_attribute14 IN OUT NOCOPY VARCHAR2,
88 p_global_attribute15 IN OUT NOCOPY VARCHAR2,
89 p_global_attribute16 IN OUT NOCOPY VARCHAR2,
90 p_global_attribute17 IN OUT NOCOPY VARCHAR2,
91 p_global_attribute18 IN OUT NOCOPY VARCHAR2,
92 p_global_attribute19 IN OUT NOCOPY VARCHAR2,
93 p_global_attribute20 IN OUT NOCOPY VARCHAR2,
94 p_core_prod_arg1 IN VARCHAR2 DEFAULT NULL,
95 p_core_prod_arg2 IN VARCHAR2 DEFAULT NULL,
96 p_core_prod_arg3 IN VARCHAR2 DEFAULT NULL,
97 p_core_prod_arg4 IN VARCHAR2 DEFAULT NULL,
98 p_core_prod_arg5 IN VARCHAR2 DEFAULT NULL,
99 p_core_prod_arg6 IN VARCHAR2 DEFAULT NULL,
100 p_core_prod_arg7 IN VARCHAR2 DEFAULT NULL,
101 p_core_prod_arg8 IN VARCHAR2 DEFAULT NULL,
102 p_core_prod_arg9 IN VARCHAR2 DEFAULT NULL,
103 p_core_prod_arg10 IN VARCHAR2 DEFAULT NULL,
104 p_core_prod_arg11 IN VARCHAR2 DEFAULT NULL,
105 p_core_prod_arg12 IN VARCHAR2 DEFAULT NULL,
106 p_core_prod_arg13 IN VARCHAR2 DEFAULT NULL,
107 p_core_prod_arg14 IN VARCHAR2 DEFAULT NULL,
108 p_core_prod_arg15 IN VARCHAR2 DEFAULT NULL,
109 p_core_prod_arg16 IN VARCHAR2 DEFAULT NULL,
110 p_core_prod_arg17 IN VARCHAR2 DEFAULT NULL,
111 p_core_prod_arg18 IN VARCHAR2 DEFAULT NULL,
112 p_core_prod_arg19 IN VARCHAR2 DEFAULT NULL,
113 p_core_prod_arg20 IN VARCHAR2 DEFAULT NULL,
114 p_core_prod_arg21 IN VARCHAR2 DEFAULT NULL,
115 p_core_prod_arg22 IN VARCHAR2 DEFAULT NULL,
116 p_core_prod_arg23 IN VARCHAR2 DEFAULT NULL,
117 p_core_prod_arg24 IN VARCHAR2 DEFAULT NULL,
118 p_core_prod_arg25 IN VARCHAR2 DEFAULT NULL,
119 p_core_prod_arg26 IN VARCHAR2 DEFAULT NULL,
120 p_core_prod_arg27 IN VARCHAR2 DEFAULT NULL,
121 p_core_prod_arg28 IN VARCHAR2 DEFAULT NULL,
122 p_core_prod_arg29 IN VARCHAR2 DEFAULT NULL,
123 p_core_prod_arg30 IN VARCHAR2 DEFAULT NULL,
124 p_current_status OUT NOCOPY VARCHAR2
125 );
126
127 PROCEDURE check_attr_value_ap(
128 p_calling_program_name IN VARCHAR2,
129 p_set_of_books_id IN NUMBER,
130 p_invoice_date IN DATE,
131 p_parent_table IN VARCHAR2,
132 p_parent_id IN NUMBER,
133 p_default_last_updated_by IN NUMBER,
134 p_default_last_update_login IN NUMBER,
135 p_inv_vendor_site_id IN NUMBER,
136 p_inv_payment_currency_code IN VARCHAR2,
137 p_line_type_lookup_code IN VARCHAR2,
138 p_global_attribute_category IN VARCHAR2,
139 p_global_attribute1 IN OUT NOCOPY VARCHAR2,
140 p_global_attribute2 IN OUT NOCOPY VARCHAR2,
141 p_global_attribute3 IN OUT NOCOPY VARCHAR2,
142 p_global_attribute4 IN OUT NOCOPY VARCHAR2,
143 p_global_attribute5 IN OUT NOCOPY VARCHAR2,
144 p_global_attribute6 IN OUT NOCOPY VARCHAR2,
145 p_global_attribute7 IN OUT NOCOPY VARCHAR2,
146 p_global_attribute8 IN OUT NOCOPY VARCHAR2,
147 p_global_attribute9 IN OUT NOCOPY VARCHAR2,
148 p_global_attribute10 IN OUT NOCOPY VARCHAR2,
149 p_global_attribute11 IN OUT NOCOPY VARCHAR2,
150 p_global_attribute12 IN OUT NOCOPY VARCHAR2,
151 p_global_attribute13 IN OUT NOCOPY VARCHAR2,
152 p_global_attribute14 IN OUT NOCOPY VARCHAR2,
153 p_global_attribute15 IN OUT NOCOPY VARCHAR2,
154 p_global_attribute16 IN OUT NOCOPY VARCHAR2,
155 p_global_attribute17 IN OUT NOCOPY VARCHAR2,
156 p_global_attribute18 IN OUT NOCOPY VARCHAR2,
157 p_global_attribute19 IN OUT NOCOPY VARCHAR2,
158 p_global_attribute20 IN OUT NOCOPY VARCHAR2,
159 p_current_invoice_status OUT NOCOPY VARCHAR2,
160 p_calling_sequence IN VARCHAR2);
161
162 PROCEDURE check_ap_context_integrity
163 (p_calling_program_name IN VARCHAR2,
164 p_parent_table IN VARCHAR2,
165 p_parent_id IN NUMBER,
166 p_default_last_updated_by IN NUMBER,
167 p_default_last_update_login IN NUMBER,
168 p_global_attribute_category IN VARCHAR2,
169 p_global_attribute1 IN VARCHAR2,
170 p_global_attribute2 IN VARCHAR2,
171 p_global_attribute3 IN VARCHAR2,
172 p_global_attribute4 IN VARCHAR2,
173 p_global_attribute5 IN VARCHAR2,
174 p_global_attribute6 IN VARCHAR2,
175 p_global_attribute7 IN VARCHAR2,
176 p_global_attribute8 IN VARCHAR2,
177 p_global_attribute9 IN VARCHAR2,
178 p_global_attribute10 IN VARCHAR2,
179 p_global_attribute11 IN VARCHAR2,
180 p_global_attribute12 IN VARCHAR2,
181 p_global_attribute13 IN VARCHAR2,
182 p_global_attribute14 IN VARCHAR2,
183 p_global_attribute15 IN VARCHAR2,
184 p_global_attribute16 IN VARCHAR2,
185 p_global_attribute17 IN VARCHAR2,
186 p_global_attribute18 IN VARCHAR2,
187 p_global_attribute19 IN VARCHAR2,
188 p_global_attribute20 IN VARCHAR2,
189 p_current_invoice_status OUT NOCOPY VARCHAR2,
190 p_calling_sequence IN VARCHAR2);
191
192
193 PROCEDURE reject_value_found(
194 p_parent_table IN VARCHAR2,
195 p_parent_id IN NUMBER,
196 p_default_last_updated_by IN NUMBER,
197 p_default_last_update_login IN NUMBER,
198 p_global_attribute_category IN VARCHAR2,
199 p_global_attribute1 IN VARCHAR2,
200 p_global_attribute2 IN VARCHAR2,
201 p_global_attribute3 IN VARCHAR2,
202 p_global_attribute4 IN VARCHAR2,
203 p_global_attribute5 IN VARCHAR2,
204 p_global_attribute6 IN VARCHAR2,
205 p_global_attribute7 IN VARCHAR2,
206 p_global_attribute8 IN VARCHAR2,
207 p_global_attribute9 IN VARCHAR2,
208 p_global_attribute10 IN VARCHAR2,
209 p_global_attribute11 IN VARCHAR2,
210 p_global_attribute12 IN VARCHAR2,
211 p_global_attribute13 IN VARCHAR2,
212 p_global_attribute14 IN VARCHAR2,
213 p_global_attribute15 IN VARCHAR2,
214 p_global_attribute16 IN VARCHAR2,
215 p_global_attribute17 IN VARCHAR2,
216 p_global_attribute18 IN VARCHAR2,
217 p_global_attribute19 IN VARCHAR2,
218 p_global_attribute20 IN VARCHAR2,
219 p_current_invoice_status OUT NOCOPY VARCHAR2,
220 p_calling_sequence IN VARCHAR2);
221
222 PROCEDURE reject_invalid_context_code(
223 p_calling_program_name IN VARCHAR2,
224 p_parent_table IN VARCHAR2,
225 p_parent_id IN NUMBER,
226 p_default_last_updated_by IN NUMBER,
227 p_default_last_update_login IN NUMBER,
228 p_global_attribute_category IN VARCHAR2,
229 p_current_invoice_status OUT NOCOPY VARCHAR2,
230 p_calling_sequence IN VARCHAR2);
231
232 PROCEDURE check_ap_business_rules(
233 p_calling_program_name IN VARCHAR2,
234 p_set_of_books_id IN NUMBER,
235 p_invoice_date IN DATE,
236 p_parent_table IN VARCHAR2,
237 p_parent_id IN NUMBER,
238 p_default_last_updated_by IN NUMBER,
239 p_default_last_update_login IN NUMBER,
240 p_inv_vendor_site_id IN NUMBER,
241 p_inv_payment_currency_code IN VARCHAR2,
242 p_line_type_lookup_code IN VARCHAR2,
243 p_global_attribute_category IN VARCHAR2,
244 p_global_attribute1 IN OUT NOCOPY VARCHAR2,
245 p_global_attribute2 IN OUT NOCOPY VARCHAR2,
246 p_global_attribute3 IN OUT NOCOPY VARCHAR2,
247 p_global_attribute4 IN OUT NOCOPY VARCHAR2,
248 p_global_attribute5 IN OUT NOCOPY VARCHAR2,
249 p_global_attribute6 IN OUT NOCOPY VARCHAR2,
250 p_global_attribute7 IN OUT NOCOPY VARCHAR2,
251 p_global_attribute8 IN OUT NOCOPY VARCHAR2,
252 p_global_attribute9 IN OUT NOCOPY VARCHAR2,
253 p_global_attribute10 IN OUT NOCOPY VARCHAR2,
254 p_global_attribute11 IN OUT NOCOPY VARCHAR2,
255 p_global_attribute12 IN OUT NOCOPY VARCHAR2,
256 p_global_attribute13 IN OUT NOCOPY VARCHAR2,
257 p_global_attribute14 IN OUT NOCOPY VARCHAR2,
258 p_global_attribute15 IN OUT NOCOPY VARCHAR2,
259 p_global_attribute16 IN OUT NOCOPY VARCHAR2,
260 p_global_attribute17 IN OUT NOCOPY VARCHAR2,
261 p_global_attribute18 IN OUT NOCOPY VARCHAR2,
262 p_global_attribute19 IN OUT NOCOPY VARCHAR2,
263 p_global_attribute20 IN OUT NOCOPY VARCHAR2,
264 p_current_invoice_status OUT NOCOPY VARCHAR2,
265 p_calling_sequence IN VARCHAR2);
266
267 --
268 -- Modified to implement new TCA model.
269 -- Added one more parameter p_int_table_name, which receives the following
270 -- values currently as valid : CUSTOMER or PROFILE.
271 --
272 PROCEDURE ar_cust_interface(p_request_id IN NUMBER,
273 p_org_id IN NUMBER,
274 p_sob_id IN NUMBER,
275 p_user_id IN NUMBER,
276 p_application_id IN NUMBER,
277 p_language IN NUMBER,
278 p_program_id IN NUMBER,
279 p_prog_appl_id IN NUMBER,
280 p_last_update_login IN NUMBER,
281 p_int_table_name IN VARCHAR2);
282
283 --
284 -- Modified check_attr_value_ar to implement the new TCA model.
285 -- Modified parameter type to have record type variables.
286 --
287 PROCEDURE check_attr_value_ar
288 (p_int_table_name IN VARCHAR2,
289 p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
290 p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
291 p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
292 p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
293 p_current_record_status OUT NOCOPY VARCHAR2
294 );
295 --
296 -- End of modification
297 --
301 --
298
299 --
300 -- Modified check_ar_context_integrity parameters to implement TCA model.
302 PROCEDURE check_ar_context_integrity(
303 p_int_table_name IN VARCHAR2,
304 p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
305 p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
306 p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
307 p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
308 p_current_record_status OUT NOCOPY VARCHAR2);
309
310 --
311 -- End of modification
312 --
313
314 --
315 -- Modified check_ar_business_rules parameters to implement TCA model.
316 --
317
318 PROCEDURE check_ar_business_rules(
319 p_int_table_name IN VARCHAR2,
320 p_glob_attr_set1 IN jg_globe_flex_val_shared.GdfRec,
321 p_glob_attr_set2 IN jg_globe_flex_val_shared.GdfRec,
322 p_glob_attr_set3 IN jg_globe_flex_val_shared.GdfRec,
323 p_glob_attr_general IN jg_globe_flex_val_shared.GenRec,
324 p_current_record_status OUT NOCOPY VARCHAR2,
325 p_org_id IN NUMBER); --2354736
326 --
327 -- End of modification
328 --
329
330 PROCEDURE insert_jg_zz_invoice_info
331 (p_invoice_id IN NUMBER,
332 p_global_attribute_category IN OUT NOCOPY VARCHAR2,
333 p_global_attribute1 IN OUT NOCOPY VARCHAR2,
334 p_global_attribute2 IN OUT NOCOPY VARCHAR2,
335 p_global_attribute3 IN OUT NOCOPY VARCHAR2,
336 p_global_attribute4 IN OUT NOCOPY VARCHAR2,
337 p_global_attribute5 IN OUT NOCOPY VARCHAR2,
338 p_global_attribute6 IN OUT NOCOPY VARCHAR2,
339 p_global_attribute7 IN OUT NOCOPY VARCHAR2,
340 p_global_attribute8 IN OUT NOCOPY VARCHAR2,
341 p_global_attribute9 IN OUT NOCOPY VARCHAR2,
342 p_global_attribute10 IN OUT NOCOPY VARCHAR2,
343 p_global_attribute11 IN OUT NOCOPY VARCHAR2,
344 p_global_attribute12 IN OUT NOCOPY VARCHAR2,
345 p_global_attribute13 IN OUT NOCOPY VARCHAR2,
346 p_global_attribute14 IN OUT NOCOPY VARCHAR2,
347 p_global_attribute15 IN OUT NOCOPY VARCHAR2,
348 p_global_attribute16 IN OUT NOCOPY VARCHAR2,
349 p_global_attribute17 IN OUT NOCOPY VARCHAR2,
350 p_global_attribute18 IN OUT NOCOPY VARCHAR2,
351 p_global_attribute19 IN OUT NOCOPY VARCHAR2,
352 p_global_attribute20 IN OUT NOCOPY VARCHAR2,
353 p_last_updated_by IN NUMBER,
354 p_last_update_date IN DATE,
355 p_last_update_login IN NUMBER,
356 p_created_by IN NUMBER,
357 p_creation_date IN DATE,
358 p_calling_sequence IN VARCHAR2);
359
360 --
361 -- Added to implement the TCA model.
362 --
363 PROCEDURE insert_global_tables
364 (p_table_name IN VARCHAR2,
365 p_key_column1 IN VARCHAR2,
366 p_key_column2 IN VARCHAR2,
367 p_key_column3 IN VARCHAR2,
368 p_key_column4 IN VARCHAR2,
369 p_key_column5 IN VARCHAR2,
370 p_key_column6 IN VARCHAR2);
371
372 END jg_globe_flex_val;