APPS.DEFCONDN_PKG dependencies on OE_DEF_CONDITIONS_TL

Line 141: INSERT INTO OE_DEF_CONDITIONS_TL(display_name,description,condition_id,

137: p_last_updated_by,
138: p_system_flag,
139: p_last_update_date,p_last_update_login);
140:
141: INSERT INTO OE_DEF_CONDITIONS_TL(display_name,description,condition_id,
142: created_by,
143: creation_date,
144: last_updated_by,
145: last_update_date,

Line 163: FROM oe_def_conditions_tl t

159: FROM fnd_languages l
160: WHERE l.installed_flag in ('I', 'B')
161: AND not exists (
162: SELECT null
163: FROM oe_def_conditions_tl t
164: WHERE t.condition_id = p_condition_id
165: AND t.language = l.language_code);
166:
167:

Line 251: UPDATE oe_def_conditions_tl

247: if (SQL%NOTFOUND) then
248: RAISE NO_DATA_FOUND;
249: end if;
250:
251: UPDATE oe_def_conditions_tl
252: SET
253: source_lang = USERENV('LANG')
254: ,last_updated_by = p_last_updated_by
255: ,last_update_date = p_last_update_date

Line 289: DELETE FROM OE_DEF_CONDITIONS_TL

285:
286: DELETE FROM OE_DEF_CONDITIONS
287: WHERE rowid = p_rowid;
288:
289: DELETE FROM OE_DEF_CONDITIONS_TL
290: WHERE condition_id = l_condition_id;
291:
292: DELETE FROM OE_DEF_CONDN_ELEMS
293: WHERE condition_id = l_condition_id;

Line 347: FROM oe_def_conditions_tl t

343: Recinfo C%ROWTYPE;
344:
345: CURSOR C1 IS
346: SELECT *
347: FROM oe_def_conditions_tl t
348: WHERE condition_id = p_condition_id
349: AND language = userenv('LANG')
350: FOR UPDATE OF condition_id NOWAIT;
351:

Line 463: UPDATE oe_def_conditions_tl

459: p_description in VARCHAR2)
460: IS
461: BEGIN
462:
463: UPDATE oe_def_conditions_tl
464: SET
465: source_lang = USERENV('LANG')
466: ,last_updated_by = decode(p_OWNER, 'SEED', 1, 0)
467: ,last_update_date = sysdate

Line 589: DELETE FROM oe_def_conditions_tl t

585: PROCEDURE ADD_LANGUAGE
586: IS
587: BEGIN
588:
589: DELETE FROM oe_def_conditions_tl t
590: WHERE NOT EXISTS
591: (SELECT null
592: FROM oe_def_conditions b
593: where b.condition_id = t.condition_id);

Line 595: UPDATE oe_def_conditions_tl t

591: (SELECT null
592: FROM oe_def_conditions b
593: where b.condition_id = t.condition_id);
594:
595: UPDATE oe_def_conditions_tl t
596: SET
597: (
598: display_name,
599: description

Line 604: FROM oe_def_conditions_tl b

600: ) = (
601: SELECT
602: b.display_name,
603: b.description
604: FROM oe_def_conditions_tl b
605: WHERE b.condition_id = t.condition_id
606: AND b.language = t.source_lang
607: )
608: where

Line 616: FROM oe_def_conditions_tl subb, oe_def_conditions_tl subt

612: ) IN (
613: SELECT
614: subt.condition_id,
615: subt.language
616: FROM oe_def_conditions_tl subb, oe_def_conditions_tl subt
617: WHERE subb.condition_id = subt.condition_id
618: AND subb.language = subt.source_lang
619: AND(subb.display_name <> subt.display_name
620: OR subb.DESCRIPTION <> subt.description

Line 626: INSERT INTO oe_def_conditions_tl

622: OR (subb.description IS NOT null AND subt.description IS null)
623: )
624: );
625:
626: INSERT INTO oe_def_conditions_tl
627: (
628: condition_id
629: ,language
630: ,source_lang

Line 650: FROM oe_def_conditions_tl b, fnd_languages l

646: ,b.last_update_date
647: ,b.display_name
648: ,b.description
649: ,b.last_update_login
650: FROM oe_def_conditions_tl b, fnd_languages l
651: WHERE l.installed_flag IN ('I', 'B')
652: AND b.language = USERENV('LANG')
653: AND NOT EXISTS
654: ( SELECT null

Line 655: FROM oe_def_conditions_tl t

651: WHERE l.installed_flag IN ('I', 'B')
652: AND b.language = USERENV('LANG')
653: AND NOT EXISTS
654: ( SELECT null
655: FROM oe_def_conditions_tl t
656: WHERE t.condition_id = b.condition_id
657: AND t.language = l.language_code);
658:
659: END ADD_LANGUAGE;