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.CS_KB_ELEMENTS_PKG dependencies on CS_KB_ELEMENTS_TL

Line 90: FROM CS_KB_ELEMENTS_TL

86: CURSOR c_tl(c_id IN NUMBER) IS
87: SELECT element_id,
88: language,
89: description
90: FROM CS_KB_ELEMENTS_TL
91: WHERE element_id = c_id;
92:
93: BEGIN
94:

Line 186: INSERT INTO CS_KB_ELEMENTS_TL (

182: x_start_active_date,
183: x_end_active_date,
184: l_content_type );
185:
186: INSERT INTO CS_KB_ELEMENTS_TL (
187: element_id,
188: name,
189: description,
190: creation_date,

Line 212: FROM CS_KB_ELEMENTS_TL t

208: FROM FND_LANGUAGES l
209: WHERE l.installed_flag IN ('I', 'B')
210: AND NOT EXISTS
211: (SELECT NULL
212: FROM CS_KB_ELEMENTS_TL t
213: WHERE t.element_id = x_element_id
214: AND t.language = l.language_code);
215:
216: --INSERT given clob INTO clob_locator FOR all languages.

Line 313: FROM CS_KB_ELEMENTS_TL

309: CURSOR c1 IS
310: SELECT name,
311: description,
312: decode(language, USERENV('LANG'), 'Y', 'N') baselang
313: FROM CS_KB_ELEMENTS_TL
314: WHERE element_id = x_element_id
315: AND USERENV('LANG') IN (language, source_lang)
316: FOR UPDATE OF element_id NOWAIT;
317:

Line 458: FROM CS_KB_ELEMENTS_TL

454: CURSOR c_tl(c_id IN NUMBER) IS
455: SELECT element_id,
456: language,
457: description
458: FROM CS_KB_ELEMENTS_TL
459: WHERE element_id = c_id
460: AND USERENV('LANG') IN (language, source_lang) FOR UPDATE;
461:
462: BEGIN

Line 520: UPDATE CS_KB_ELEMENTS_TL SET

516: IF (SQL%NOTFOUND) THEN
517: RAISE NO_DATA_FOUND;
518: END IF;
519:
520: UPDATE CS_KB_ELEMENTS_TL SET
521: name = x_name,
522: description = EMPTY_CLOB(),
523: last_update_date = x_last_update_date,
524: last_updated_by = x_last_updated_by,

Line 560: DELETE FROM CS_KB_ELEMENTS_TL

556: BEGIN
557:
558: FOR rec IN c LOOP
559:
560: DELETE FROM CS_KB_ELEMENTS_TL
561: WHERE element_id = rec.element_id;
562:
563: END LOOP;
564:

Line 574: DELETE FROM CS_KB_ELEMENTS_TL t

570: PROCEDURE Add_Language
571: IS
572: BEGIN
573:
574: DELETE FROM CS_KB_ELEMENTS_TL t
575: WHERE NOT EXISTS (SELECT NULL
576: FROM CS_KB_ELEMENTS_B b
577: WHERE b.element_id = t.element_id );
578:

Line 579: UPDATE CS_KB_ELEMENTS_TL t

575: WHERE NOT EXISTS (SELECT NULL
576: FROM CS_KB_ELEMENTS_B b
577: WHERE b.element_id = t.element_id );
578:
579: UPDATE CS_KB_ELEMENTS_TL t
580: SET ( name,
581: description
582: ) = (SELECT b.name,
583: b.description

Line 584: FROM CS_KB_ELEMENTS_TL b

580: SET ( name,
581: description
582: ) = (SELECT b.name,
583: b.description
584: FROM CS_KB_ELEMENTS_TL b
585: WHERE b.element_id = t.element_id
586: AND b.language = t.source_lang )
587: WHERE ( t.element_id,
588: t.language) IN (SELECT subt.element_id,

Line 590: FROM CS_KB_ELEMENTS_TL subb,

586: AND b.language = t.source_lang )
587: WHERE ( t.element_id,
588: t.language) IN (SELECT subt.element_id,
589: subt.language
590: FROM CS_KB_ELEMENTS_TL subb,
591: CS_KB_ELEMENTS_TL subt
592: WHERE subb.element_id = subt.element_id
593: AND subb.language = subt.source_lang
594: AND (subb.name <> subt.name

Line 591: CS_KB_ELEMENTS_TL subt

587: WHERE ( t.element_id,
588: t.language) IN (SELECT subt.element_id,
589: subt.language
590: FROM CS_KB_ELEMENTS_TL subb,
591: CS_KB_ELEMENTS_TL subt
592: WHERE subb.element_id = subt.element_id
593: AND subb.language = subt.source_lang
594: AND (subb.name <> subt.name
595: OR (subb.name IS NULL AND subt.name IS NOT NULL)

Line 603: INSERT INTO CS_KB_ELEMENTS_TL (

599: OR (subb.description IS NULL AND subt.description IS NOT NULL)
600: OR (subb.description IS NOT NULL AND subt.description IS NULL)
601: ));
602:
603: INSERT INTO CS_KB_ELEMENTS_TL (
604: element_id,
605: name,
606: description,
607: creation_date,

Line 625: FROM CS_KB_ELEMENTS_TL b, fnd_languages l

621: b.last_updated_by,
622: b.last_update_login,
623: l.language_code,
624: b.source_lang
625: FROM CS_KB_ELEMENTS_TL b, fnd_languages l
626: WHERE l.installed_flag IN ('I', 'B')
627: AND b.language = USERENV('LANG')
628: AND NOT EXISTS
629: (SELECT NULL

Line 630: FROM CS_KB_ELEMENTS_TL t

626: WHERE l.installed_flag IN ('I', 'B')
627: AND b.language = USERENV('LANG')
628: AND NOT EXISTS
629: (SELECT NULL
630: FROM CS_KB_ELEMENTS_TL t
631: WHERE t.element_id = b.element_id
632: AND t.language = l.language_code);
633:
634: END Add_Language;

Line 653: FROM CS_KB_ELEMENTS_TL

649: SELECT
650: element_id,
651: language,
652: description
653: FROM CS_KB_ELEMENTS_TL
654: WHERE element_id = c_id
655: AND USERENV('LANG') IN (language, source_lang) FOR UPDATE;
656:
657: l_user_id NUMBER;

Line 672: UPDATE CS_KB_ELEMENTS_TL SET

668: DBMS_LOB.write(l_clob, l_amt, l_offset, x_description);
669: END IF;
670:
671: -- UPDATE translated non-clob portions FOR specified language
672: UPDATE CS_KB_ELEMENTS_TL SET
673: name = x_name,
674: last_update_date = SYSDATE,
675: last_updated_by = decode(x_owner, 'SEED', 1, 0),
676: last_update_login = 0,

Line 809: FROM CS_KB_ELEMENTS_TL

805:
806: CURSOR C_TL IS
807: SELECT
808: description
809: FROM CS_KB_ELEMENTS_TL
810: WHERE element_id = p_element_id
811: AND userenv('LANG') = SOURCE_LANG
812: AND userenv('LANG') <> LANGUAGE
813: FOR UPDATE;

Line 817: FROM cs_kb_elements_tl

813: FOR UPDATE;
814:
815: CURSOR c_desc IS
816: SELECT description
817: FROM cs_kb_elements_tl
818: WHERE element_id = p_element_id
819: AND language = userenv('LANG');
820: BEGIN
821:

Line 830: UPDATE CS_KB_ELEMENTS_TL SET

826: IF (sql%notfound) THEN
827: RETURN;
828: END IF;
829:
830: UPDATE CS_KB_ELEMENTS_TL SET
831: description = EMPTY_CLOB() ,
832: last_update_date = l_sysdate,
833: last_updated_by = l_user_id,
834: last_update_login = l_login_id