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.

APPS.DEFCONDN_PKG dependencies on OE_DEF_CONDITIONS

Line 62: SELECT display_name from OE_DEF_CONDITIONS_VL

58: IS
59: l_condn_name VARCHAR2(255);
60:
61: CURSOR CDN is
62: SELECT display_name from OE_DEF_CONDITIONS_VL
63: WHERE display_name = p_display_name
64: and database_object_name = p_database_object_name
65: and ((p_rowid is null) OR (row_id <> p_rowid));
66:

Line 117: CURSOR C IS SELECT rowid from OE_DEF_CONDITIONS

113: ,p_attribute14 in varchar2
114: ,p_attribute15 in varchar2
115: ) IS
116:
117: CURSOR C IS SELECT rowid from OE_DEF_CONDITIONS
118: WHERE condition_id = p_condition_id;
119:
120: BEGIN
121:

Line 122: INSERT INTO OE_DEF_CONDITIONS(

118: WHERE condition_id = p_condition_id;
119:
120: BEGIN
121:
122: INSERT INTO OE_DEF_CONDITIONS(
123: condition_id,
124: database_object_name,
125: number_of_elements,
126: created_by,

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 220: UPDATE oe_def_conditions

216: ) IS
217:
218: BEGIN
219:
220: UPDATE oe_def_conditions
221: SET
222: condition_id = p_condition_id
223: ,system_flag = p_system_flag
224: ,created_by = p_created_by

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 278: FROM OE_DEF_CONDITIONS

274: BEGIN
275:
276:
277: SELECT condition_id INTO l_condition_id
278: FROM OE_DEF_CONDITIONS
279: WHERE rowid = p_rowid;
280:
281:
282: if (SQL%NOTFOUND) then

Line 286: DELETE FROM OE_DEF_CONDITIONS

282: if (SQL%NOTFOUND) then
283: Raise NO_DATA_FOUND;
284: else
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;

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 339: SELECT * FROM OE_DEF_CONDITIONS

335: ,p_attribute15 in varchar2
336: ) IS
337:
338: CURSOR C IS
339: SELECT * FROM OE_DEF_CONDITIONS
340: WHERE rowid = p_Rowid
341: FOR UPDATE OF condition_id NOWAIT;
342:
343: Recinfo C%ROWTYPE;

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 592: FROM oe_def_conditions b

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);
594:
595: UPDATE oe_def_conditions_tl t
596: SET

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;