eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.OE_PC_CONDITIONS_PKG

Source


1 package body OE_PC_CONDITIONS_PKG as
2 /* $Header: OEXPCCDB.pls 120.1 2005/07/15 01:32:02 ppnair noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_CONDITION_ID in NUMBER,
7   X_CONSTRAINT_ID in NUMBER,
8   X_GROUP_NUMBER in NUMBER,
9   X_SYSTEM_FLAG in VARCHAR2,
10   X_MODIFIER_FLAG in VARCHAR2,
11   X_VALIDATION_ENTITY_ID in NUMBER,
12   X_VALIDATION_TMPLT_ID in NUMBER,
13   X_RECORD_SET_ID in NUMBER,
14   X_SCOPE_OP in VARCHAR2,
15   X_ATTRIBUTE_CATEGORY in VARCHAR2,
16   X_ATTRIBUTE1 in VARCHAR2,
17   X_ATTRIBUTE2 in VARCHAR2,
18   X_ATTRIBUTE3 in VARCHAR2,
19   X_ATTRIBUTE4 in VARCHAR2,
20   X_ATTRIBUTE5 in VARCHAR2,
21   X_ATTRIBUTE6 in VARCHAR2,
22   X_ATTRIBUTE7 in VARCHAR2,
23   X_ATTRIBUTE8 in VARCHAR2,
24   X_ATTRIBUTE9 in VARCHAR2,
25   X_ATTRIBUTE10 in VARCHAR2,
26   X_ATTRIBUTE11 in VARCHAR2,
27   X_ATTRIBUTE12 in VARCHAR2,
28   X_ATTRIBUTE13 in VARCHAR2,
29   X_ATTRIBUTE14 in VARCHAR2,
30   X_ATTRIBUTE15 in VARCHAR2,
31   X_START_DATE_ACTIVE in DATE,
32   X_END_DATE_ACTIVE in DATE,
33   X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL,
34   X_USER_MESSAGE in VARCHAR2,
35   X_CREATION_DATE in DATE,
36   X_CREATED_BY in NUMBER,
37   X_LAST_UPDATE_DATE in DATE,
38   X_LAST_UPDATED_BY in NUMBER,
39   X_LAST_UPDATE_LOGIN in NUMBER
40 ) is
41   cursor C is select ROWID from OE_PC_CONDITIONS
42     where CONDITION_ID = X_CONDITION_ID
43     ;
44 begin
45 
46   insert into OE_PC_CONDITIONS (
47     CONDITION_ID,
48     CONSTRAINT_ID,
49     GROUP_NUMBER,
50     SYSTEM_FLAG,
51     MODIFIER_FLAG,
52     VALIDATION_ENTITY_ID,
53     VALIDATION_TMPLT_ID,
54     RECORD_SET_ID,
55     SCOPE_OP,
56     ATTRIBUTE_CATEGORY,
57     ATTRIBUTE1,
58     ATTRIBUTE2,
59     ATTRIBUTE3,
60     ATTRIBUTE4,
61     ATTRIBUTE5,
62     ATTRIBUTE6,
63     ATTRIBUTE7,
64     ATTRIBUTE8,
65     ATTRIBUTE9,
66     ATTRIBUTE10,
67     ATTRIBUTE11,
68     ATTRIBUTE12,
69     ATTRIBUTE13,
70     ATTRIBUTE14,
71     ATTRIBUTE15,
72     START_DATE_ACTIVE,
73     END_DATE_ACTIVE,
74     ENABLED_FLAG,
75     CREATION_DATE,
76     CREATED_BY,
77     LAST_UPDATE_DATE,
78     LAST_UPDATED_BY,
79     LAST_UPDATE_LOGIN
80   ) values (
81     X_CONDITION_ID,
82     X_CONSTRAINT_ID,
83     X_GROUP_NUMBER,
84     X_SYSTEM_FLAG,
85     X_MODIFIER_FLAG,
86     X_VALIDATION_ENTITY_ID,
87     X_VALIDATION_TMPLT_ID,
88     X_RECORD_SET_ID,
89     X_SCOPE_OP,
90     X_ATTRIBUTE_CATEGORY,
91     X_ATTRIBUTE1,
92     X_ATTRIBUTE2,
93     X_ATTRIBUTE3,
94     X_ATTRIBUTE4,
95     X_ATTRIBUTE5,
96     X_ATTRIBUTE6,
97     X_ATTRIBUTE7,
98     X_ATTRIBUTE8,
99     X_ATTRIBUTE9,
100     X_ATTRIBUTE10,
101     X_ATTRIBUTE11,
102     X_ATTRIBUTE12,
103     X_ATTRIBUTE13,
104     X_ATTRIBUTE14,
105     X_ATTRIBUTE15,
106     X_START_DATE_ACTIVE,
107     X_END_DATE_ACTIVE,
108     X_ENABLED_FLAG,
109     X_CREATION_DATE,
110     X_CREATED_BY,
111     X_LAST_UPDATE_DATE,
112     X_LAST_UPDATED_BY,
113     X_LAST_UPDATE_LOGIN
114   );
115 
116   insert into OE_PC_CONDITIONS_TL (
117     CONDITION_ID,
118     USER_MESSAGE,
119     CREATED_BY,
120     CREATION_DATE,
121     LAST_UPDATED_BY,
122     LAST_UPDATE_DATE,
123     LAST_UPDATE_LOGIN,
124     LANGUAGE,
125     SOURCE_LANG
126   ) select
127     X_CONDITION_ID,
128     X_USER_MESSAGE,
129     X_CREATED_BY,
130     X_CREATION_DATE,
131     X_LAST_UPDATED_BY,
132     X_LAST_UPDATE_DATE,
133     X_LAST_UPDATE_LOGIN,
134     L.LANGUAGE_CODE,
135     userenv('LANG')
136   from FND_LANGUAGES L
137   where L.INSTALLED_FLAG in ('I', 'B')
138   and not exists
139     (select NULL
140     from OE_PC_CONDITIONS_TL T
141     where T.CONDITION_ID = X_CONDITION_ID
142     and T.LANGUAGE = L.LANGUAGE_CODE);
143 
144   open c;
145   fetch c into X_ROWID;
146   if (c%notfound) then
147     close c;
148     fnd_message.set_name('ONT', 'INSERT_NO_DATA_FOUND');
149     app_exception.raise_exception;
150     raise no_data_found;
151   end if;
152   close c;
153 
154 end INSERT_ROW;
155 
156 procedure LOCK_ROW (
157   X_CONDITION_ID in NUMBER,
158   X_CONSTRAINT_ID in NUMBER,
159   X_GROUP_NUMBER in NUMBER,
160   X_SYSTEM_FLAG in VARCHAR2,
161   X_MODIFIER_FLAG in VARCHAR2,
162   X_VALIDATION_ENTITY_ID in NUMBER,
163   X_VALIDATION_TMPLT_ID in NUMBER,
164   X_RECORD_SET_ID in NUMBER,
165   X_SCOPE_OP in VARCHAR2,
166   X_ATTRIBUTE_CATEGORY in VARCHAR2,
167   X_ATTRIBUTE1 in VARCHAR2,
168   X_ATTRIBUTE2 in VARCHAR2,
169   X_ATTRIBUTE3 in VARCHAR2,
170   X_ATTRIBUTE4 in VARCHAR2,
171   X_ATTRIBUTE5 in VARCHAR2,
172   X_ATTRIBUTE6 in VARCHAR2,
173   X_ATTRIBUTE7 in VARCHAR2,
174   X_ATTRIBUTE8 in VARCHAR2,
175   X_ATTRIBUTE9 in VARCHAR2,
176   X_ATTRIBUTE10 in VARCHAR2,
177   X_ATTRIBUTE11 in VARCHAR2,
178   X_ATTRIBUTE12 in VARCHAR2,
179   X_ATTRIBUTE13 in VARCHAR2,
180   X_ATTRIBUTE14 in VARCHAR2,
181   X_ATTRIBUTE15 in VARCHAR2,
182   X_START_DATE_ACTIVE in DATE,
183   X_END_DATE_ACTIVE in DATE,
184   X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL,
185   X_USER_MESSAGE in VARCHAR2
186 ) is
187   cursor c is select
188       CONSTRAINT_ID,
189       GROUP_NUMBER,
190       SYSTEM_FLAG,
191       MODIFIER_FLAG,
192       VALIDATION_ENTITY_ID,
193       VALIDATION_TMPLT_ID,
194       RECORD_SET_ID,
195       SCOPE_OP,
196       ATTRIBUTE_CATEGORY,
197       ATTRIBUTE1,
198       ATTRIBUTE2,
199       ATTRIBUTE3,
200       ATTRIBUTE4,
201       ATTRIBUTE5,
202       ATTRIBUTE6,
203       ATTRIBUTE7,
204       ATTRIBUTE8,
205       ATTRIBUTE9,
206       ATTRIBUTE10,
207       ATTRIBUTE11,
208       ATTRIBUTE12,
209       ATTRIBUTE13,
210       ATTRIBUTE14,
211       ATTRIBUTE15,
212       START_DATE_ACTIVE,
213       END_DATE_ACTIVE,
214       ENABLED_FLAG
215     from OE_PC_CONDITIONS
216     where CONDITION_ID = X_CONDITION_ID
217     for update of CONDITION_ID nowait;
218   recinfo c%rowtype;
219 
220   cursor c1 is select
221       USER_MESSAGE,
222       decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
223     from OE_PC_CONDITIONS_TL
224     where CONDITION_ID = X_CONDITION_ID
225     and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
226     for update of CONDITION_ID nowait;
227 begin
228   open c;
229   fetch c into recinfo;
230   if (c%notfound) then
231     close c;
232     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
233     app_exception.raise_exception;
234   end if;
235   close c;
236   if (    (recinfo.CONSTRAINT_ID = X_CONSTRAINT_ID)
237       AND (recinfo.GROUP_NUMBER = X_GROUP_NUMBER)
238       AND (recinfo.SYSTEM_FLAG = X_SYSTEM_FLAG)
239       AND (recinfo.MODIFIER_FLAG = X_MODIFIER_FLAG)
240       AND (recinfo.VALIDATION_ENTITY_ID = X_VALIDATION_ENTITY_ID)
241       AND (recinfo.VALIDATION_TMPLT_ID = X_VALIDATION_TMPLT_ID)
242       AND (recinfo.RECORD_SET_ID = X_RECORD_SET_ID)
243       AND (recinfo.SCOPE_OP = X_SCOPE_OP)
244       AND ((recinfo.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
245            OR ((recinfo.ATTRIBUTE_CATEGORY is null) AND (X_ATTRIBUTE_CATEGORY is null)))
246       AND ((recinfo.ATTRIBUTE1 = X_ATTRIBUTE1)
247            OR ((recinfo.ATTRIBUTE1 is null) AND (X_ATTRIBUTE1 is null)))
248       AND ((recinfo.ATTRIBUTE2 = X_ATTRIBUTE2)
249            OR ((recinfo.ATTRIBUTE2 is null) AND (X_ATTRIBUTE2 is null)))
250       AND ((recinfo.ATTRIBUTE3 = X_ATTRIBUTE3)
251            OR ((recinfo.ATTRIBUTE3 is null) AND (X_ATTRIBUTE3 is null)))
252       AND ((recinfo.ATTRIBUTE4 = X_ATTRIBUTE4)
253            OR ((recinfo.ATTRIBUTE4 is null) AND (X_ATTRIBUTE4 is null)))
254       AND ((recinfo.ATTRIBUTE5 = X_ATTRIBUTE5)
255            OR ((recinfo.ATTRIBUTE5 is null) AND (X_ATTRIBUTE5 is null)))
256       AND ((recinfo.ATTRIBUTE6 = X_ATTRIBUTE6)
257            OR ((recinfo.ATTRIBUTE6 is null) AND (X_ATTRIBUTE6 is null)))
258       AND ((recinfo.ATTRIBUTE7 = X_ATTRIBUTE7)
259            OR ((recinfo.ATTRIBUTE7 is null) AND (X_ATTRIBUTE7 is null)))
260       AND ((recinfo.ATTRIBUTE8 = X_ATTRIBUTE8)
261            OR ((recinfo.ATTRIBUTE8 is null) AND (X_ATTRIBUTE8 is null)))
262       AND ((recinfo.ATTRIBUTE9 = X_ATTRIBUTE9)
263            OR ((recinfo.ATTRIBUTE9 is null) AND (X_ATTRIBUTE9 is null)))
264       AND ((recinfo.ATTRIBUTE10 = X_ATTRIBUTE10)
265            OR ((recinfo.ATTRIBUTE10 is null) AND (X_ATTRIBUTE10 is null)))
266       AND ((recinfo.ATTRIBUTE11 = X_ATTRIBUTE11)
267            OR ((recinfo.ATTRIBUTE11 is null) AND (X_ATTRIBUTE11 is null)))
268       AND ((recinfo.ATTRIBUTE12 = X_ATTRIBUTE12)
269            OR ((recinfo.ATTRIBUTE12 is null) AND (X_ATTRIBUTE12 is null)))
270       AND ((recinfo.ATTRIBUTE13 = X_ATTRIBUTE13)
271            OR ((recinfo.ATTRIBUTE13 is null) AND (X_ATTRIBUTE13 is null)))
272       AND ((recinfo.ATTRIBUTE14 = X_ATTRIBUTE14)
273            OR ((recinfo.ATTRIBUTE14 is null) AND (X_ATTRIBUTE14 is null)))
274       AND ((recinfo.ATTRIBUTE15 = X_ATTRIBUTE15)
275            OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
276       AND (recinfo.START_DATE_ACTIVE = X_START_DATE_ACTIVE)
277       AND ((recinfo.END_DATE_ACTIVE = X_END_DATE_ACTIVE)
278            OR ((recinfo.END_DATE_ACTIVE is null) AND (X_END_DATE_ACTIVE is null)))
279   ) then
280     null;
281   else
282     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
283     app_exception.raise_exception;
284   end if;
285 
286   for tlinfo in c1 loop
287     if (tlinfo.BASELANG = 'Y') then
288       if (    (tlinfo.USER_MESSAGE = X_USER_MESSAGE)
289       ) then
290         null;
291       else
292         fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
293         app_exception.raise_exception;
294       end if;
295     end if;
296   end loop;
297   return;
298 end LOCK_ROW;
299 
300 procedure UPDATE_ROW (
301   X_CONDITION_ID in NUMBER,
302   X_CONSTRAINT_ID in NUMBER,
303   X_GROUP_NUMBER in NUMBER,
304   X_SYSTEM_FLAG in VARCHAR2,
305   X_MODIFIER_FLAG in VARCHAR2,
306   X_VALIDATION_ENTITY_ID in NUMBER,
307   X_VALIDATION_TMPLT_ID in NUMBER,
308   X_RECORD_SET_ID in NUMBER,
309   X_SCOPE_OP in VARCHAR2,
310   X_ATTRIBUTE_CATEGORY in VARCHAR2,
311   X_ATTRIBUTE1 in VARCHAR2,
312   X_ATTRIBUTE2 in VARCHAR2,
313   X_ATTRIBUTE3 in VARCHAR2,
314   X_ATTRIBUTE4 in VARCHAR2,
315   X_ATTRIBUTE5 in VARCHAR2,
316   X_ATTRIBUTE6 in VARCHAR2,
317   X_ATTRIBUTE7 in VARCHAR2,
318   X_ATTRIBUTE8 in VARCHAR2,
319   X_ATTRIBUTE9 in VARCHAR2,
320   X_ATTRIBUTE10 in VARCHAR2,
321   X_ATTRIBUTE11 in VARCHAR2,
322   X_ATTRIBUTE12 in VARCHAR2,
323   X_ATTRIBUTE13 in VARCHAR2,
324   X_ATTRIBUTE14 in VARCHAR2,
325   X_ATTRIBUTE15 in VARCHAR2,
326   X_START_DATE_ACTIVE in DATE,
327   X_END_DATE_ACTIVE in DATE,
328   X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL,
329   X_USER_MESSAGE in VARCHAR2,
330   X_LAST_UPDATE_DATE in DATE,
331   X_LAST_UPDATED_BY in NUMBER,
332   X_LAST_UPDATE_LOGIN in NUMBER
333 ) is
334 begin
335 
336   update OE_PC_CONDITIONS set
337     CONSTRAINT_ID = X_CONSTRAINT_ID,
338     GROUP_NUMBER = X_GROUP_NUMBER,
339     SYSTEM_FLAG = X_SYSTEM_FLAG,
340     MODIFIER_FLAG = X_MODIFIER_FLAG,
341     VALIDATION_ENTITY_ID = X_VALIDATION_ENTITY_ID,
342     VALIDATION_TMPLT_ID = X_VALIDATION_TMPLT_ID,
343     RECORD_SET_ID = X_RECORD_SET_ID,
344     SCOPE_OP = X_SCOPE_OP,
345     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
346     ATTRIBUTE1 = X_ATTRIBUTE1,
347     ATTRIBUTE2 = X_ATTRIBUTE2,
348     ATTRIBUTE3 = X_ATTRIBUTE3,
349     ATTRIBUTE4 = X_ATTRIBUTE4,
350     ATTRIBUTE5 = X_ATTRIBUTE5,
351     ATTRIBUTE6 = X_ATTRIBUTE6,
352     ATTRIBUTE7 = X_ATTRIBUTE7,
353     ATTRIBUTE8 = X_ATTRIBUTE8,
354     ATTRIBUTE9 = X_ATTRIBUTE9,
355     ATTRIBUTE10 = X_ATTRIBUTE10,
356     ATTRIBUTE11 = X_ATTRIBUTE11,
357     ATTRIBUTE12 = X_ATTRIBUTE12,
358     ATTRIBUTE13 = X_ATTRIBUTE13,
359     ATTRIBUTE14 = X_ATTRIBUTE14,
360     ATTRIBUTE15 = X_ATTRIBUTE15,
361     START_DATE_ACTIVE = X_START_DATE_ACTIVE,
362     END_DATE_ACTIVE = X_END_DATE_ACTIVE,
363     ENABLED_FLAG = NVL(X_ENABLED_FLAG, ENABLED_FLAG),
364     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
365     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
366     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
367   where CONDITION_ID = X_CONDITION_ID;
368 
369   if (sql%notfound) then
370     raise no_data_found;
371   end if;
372 
373   update OE_PC_CONDITIONS_TL set
374     USER_MESSAGE = X_USER_MESSAGE,
375     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
376     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
377     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
378     SOURCE_LANG = userenv('LANG')
379   where CONDITION_ID = X_CONDITION_ID
380   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
381 
382   if (sql%notfound) then
383     raise no_data_found;
384   end if;
385 
386 end UPDATE_ROW;
387 
388 
389 procedure DELETE_ROW (
390   X_CONDITION_ID in NUMBER
391 ) is
392 begin
393 
394   delete from OE_PC_CONDITIONS_TL
395   where CONDITION_ID = X_CONDITION_ID;
396 
397   if (sql%notfound) then
398     raise no_data_found;
399   end if;
400 
401   delete from OE_PC_CONDITIONS
402   where CONDITION_ID = X_CONDITION_ID;
403 
404   if (sql%notfound) then
405     raise no_data_found;
406   end if;
407 
408 end DELETE_ROW;
409 
410 procedure ADD_LANGUAGE
411 is
412 begin
413   delete from OE_PC_CONDITIONS_TL T
414   where not exists
415     (select NULL
416     from OE_PC_CONDITIONS B
417     where B.CONDITION_ID = T.CONDITION_ID
418     );
419 
420   update OE_PC_CONDITIONS_TL T set (
421       USER_MESSAGE
422     ) = (select
423       B.USER_MESSAGE
424     from OE_PC_CONDITIONS_TL B
425     where B.CONDITION_ID = T.CONDITION_ID
426     and B.LANGUAGE = T.SOURCE_LANG)
427   where (
428       T.CONDITION_ID,
429       T.LANGUAGE
430   ) in (select
431       SUBT.CONDITION_ID,
432       SUBT.LANGUAGE
433     from OE_PC_CONDITIONS_TL SUBB, OE_PC_CONDITIONS_TL SUBT
434     where SUBB.CONDITION_ID = SUBT.CONDITION_ID
435     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
436     and (SUBB.USER_MESSAGE <> SUBT.USER_MESSAGE
437   ));
438 
439   insert into OE_PC_CONDITIONS_TL (
440     CONDITION_ID,
441     USER_MESSAGE,
442     CREATED_BY,
443     CREATION_DATE,
444     LAST_UPDATED_BY,
445     LAST_UPDATE_DATE,
446     LAST_UPDATE_LOGIN,
447     LANGUAGE,
448     SOURCE_LANG
449   ) select
450     B.CONDITION_ID,
451     B.USER_MESSAGE,
452     B.CREATED_BY,
453     B.CREATION_DATE,
454     B.LAST_UPDATED_BY,
455     B.LAST_UPDATE_DATE,
456     B.LAST_UPDATE_LOGIN,
457     L.LANGUAGE_CODE,
458     B.SOURCE_LANG
459   from OE_PC_CONDITIONS_TL B, FND_LANGUAGES L
460   where L.INSTALLED_FLAG in ('I', 'B')
461   and B.LANGUAGE = userenv('LANG')
462   and not exists
463     (select NULL
464     from OE_PC_CONDITIONS_TL T
465     where T.CONDITION_ID = B.CONDITION_ID
466     and T.LANGUAGE = L.LANGUAGE_CODE);
467 end ADD_LANGUAGE;
468 
469 procedure TRANSLATE_ROW (
470   X_CONDITION_ID in VARCHAR2,
471   x_owner		  in VARCHAR2,
472   x_user_message in	VARCHAR2
473 )
474 is
475   l_user_id number:=0;
476 begin
480     LAST_UPDATE_DATE = sysdate,
477   l_user_id :=fnd_load_util.owner_id(x_owner); --seed data versioning changes
478   update OE_PC_CONDITIONS_TL set
479     USER_MESSAGE = X_USER_MESSAGE,
481     --LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
482     LAST_UPDATED_BY =l_user_id ,
483     LAST_UPDATE_LOGIN = 0,
484     SOURCE_LANG = userenv('LANG')
485   where CONDITION_ID = X_CONDITION_ID
486   and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
487 
488 end Translate_Row;
489 
490 
491 procedure LOAD_ROW (
492   X_CONDITION_ID in VARCHAR2,
493   x_owner		  in VARCHAR2,
494   x_user_message in	VARCHAR2,
495   X_CONSTRAINT_ID in VARCHAR2,
496   X_GROUP_NUMBER in VARCHAR2,
497   X_SYSTEM_FLAG in VARCHAR2,
498   X_MODIFIER_FLAG in VARCHAR2,
499   X_VALIDATION_ENTITY_ID in VARCHAR2,
500   X_VALIDATION_TMPLT_ID in VARCHAR2,
501   X_RECORD_SET_ID in VARCHAR2,
502   X_SCOPE_OP in VARCHAR2,
503   X_ATTRIBUTE_CATEGORY in VARCHAR2,
504   X_ATTRIBUTE1 in VARCHAR2,
505   X_ATTRIBUTE2 in VARCHAR2,
506   X_ATTRIBUTE3 in VARCHAR2,
507   X_ATTRIBUTE4 in VARCHAR2,
508   X_ATTRIBUTE5 in VARCHAR2,
509   X_ATTRIBUTE6 in VARCHAR2,
510   X_ATTRIBUTE7 in VARCHAR2,
511   X_ATTRIBUTE8 in VARCHAR2,
512   X_ATTRIBUTE9 in VARCHAR2,
513   X_ATTRIBUTE10 in VARCHAR2,
514   X_ATTRIBUTE11 in VARCHAR2,
515   X_ATTRIBUTE12 in VARCHAR2,
516   X_ATTRIBUTE13 in VARCHAR2,
517   X_ATTRIBUTE14 in VARCHAR2,
518   X_ATTRIBUTE15 in VARCHAR2,
519   X_START_DATE_ACTIVE in VARCHAR2,
520   X_END_DATE_ACTIVE in VARCHAR2,
521   X_ENABLED_FLAG in VARCHAR2 DEFAULT NULL
522 ) is
523 CURSOR CID IS SELECT oe_pc_conditions_s.nextval from dual;
524 begin
525 
526     declare
527 	user_id	number := 0;
528 	row_id	varchar2(64);
529         l_db_user_id	number := 0;
530 	l_valid_release boolean :=false;
531     begin
532 
533      if (X_OWNER = 'SEED') then
534 		  user_id := 1;
535      end if;
536     --seed data version changes start
537     user_id :=fnd_load_util.owner_id(x_owner);
538     begin
539       select last_updated_by
540         into l_db_user_id
541 	from OE_PC_CONDITIONS
542 	where CONDITION_ID = X_CONDITION_ID;
543       exception
544          when no_data_found then null;
545     end;
546      if (l_db_user_id <= user_id)
547            or (l_db_user_id in (0,1,2)
548               and user_id in (0,1,2))       then
549 	  l_valid_release :=true ;
550     end if;
551     if l_valid_release then
552     --seed data version changes end
553     OE_PC_CONDITIONS_pkg.UPDATE_ROW(
554       x_condition_id 		 => x_condition_id
555 	 ,x_group_number		 => x_group_number
556       ,x_constraint_id		 => x_constraint_id
557       ,x_system_flag	      => x_system_flag
558 	 ,x_modifier_flag		 => x_modifier_flag
559       ,x_validation_entity_id		 => x_validation_entity_id
560 	 ,x_validation_tmplt_id		 => x_validation_tmplt_id
561       ,x_record_set_id		 => x_record_set_id
562       ,x_scope_op	      	 => x_scope_op
563 	 ,x_start_date_active	 => to_date(x_start_date_active,'YYYY/MM/DD')
564 	 ,x_end_date_active		 => to_date(x_end_date_active,'YYYY/MM/DD')
565          ,x_enabled_flag                 => NULL
566 	 ,x_user_message		 => x_user_message
567       ,x_last_updated_by 	 => user_id
568       ,x_last_update_date      => sysdate
569       ,x_last_update_login     => 0
570       ,x_attribute_category    => x_attribute_category
571       ,x_attribute1	           => x_attribute1
572       ,x_attribute2	           => x_attribute2
573       ,x_attribute3	           => x_attribute3
574       ,x_attribute4	           => x_attribute4
575       ,x_attribute5	           => x_attribute5
576       ,x_attribute6	           => x_attribute6
577       ,x_attribute7	           => x_attribute7
578       ,x_attribute8	           => x_attribute8
579       ,x_attribute9	           => x_attribute9
580       ,x_attribute10	           => x_attribute10
581       ,x_attribute11	           => x_attribute11
582       ,x_attribute12	           => x_attribute12
583       ,x_attribute13	           => x_attribute13
584       ,x_attribute14	           => x_attribute14
585       ,x_attribute15	           => x_attribute15
586 	 );
587     end if;
588     exception
589 	when NO_DATA_FOUND then
590 
591 	 OE_PC_CONDITIONS_pkg.INSERT_ROW(
592 	 x_rowid				 => row_id
593       ,x_condition_id 		 => x_condition_id
594 	 ,x_group_number		 => x_group_number
595       ,x_constraint_id		 => x_constraint_id
596       ,x_system_flag	      => x_system_flag
597 	 ,x_modifier_flag		 => x_modifier_flag
598       ,x_validation_entity_id		 => x_validation_entity_id
599 	 ,x_validation_tmplt_id		 => x_validation_tmplt_id
600       ,x_record_set_id		 => x_record_set_id
601       ,x_scope_op	      	 => x_scope_op
602 	 ,x_start_date_active	 => to_date(x_start_date_active,'YYYY/MM/DD')
603 	 ,x_end_date_active		 => to_date(x_end_date_active,'YYYY/MM/DD')
604 	 ,x_user_message		 => x_user_message
605       ,x_created_by            => user_id
606       ,x_creation_date         => sysdate
607       ,x_last_updated_by 	 => user_id
608       ,x_last_update_date      => sysdate
609       ,x_last_update_login     => 0
610       ,x_attribute_category    => x_attribute_category
611       ,x_attribute1	           => x_attribute1
612       ,x_attribute2	           => x_attribute2
613       ,x_attribute3	           => x_attribute3
614       ,x_attribute4	           => x_attribute4
615       ,x_attribute5	           => x_attribute5
616       ,x_attribute6	           => x_attribute6
617       ,x_attribute7	           => x_attribute7
618       ,x_attribute8	           => x_attribute8
619       ,x_attribute9	           => x_attribute9
620       ,x_attribute10	           => x_attribute10
621       ,x_attribute11	           => x_attribute11
622       ,x_attribute12	           => x_attribute12
623       ,x_attribute13	           => x_attribute13
624       ,x_attribute14	           => x_attribute14
625       ,x_attribute15	           => x_attribute15
626       ,x_enabled_flag              => x_enabled_flag
627 	 );
628   end;
629 
630 end Load_Row;
631 
632 end OE_PC_CONDITIONS_PKG;