APPS.CS_KB_SETS_PKG dependencies on CS_KB_SETS_TL

Line 164: INSERT INTO CS_KB_SETS_TL (

160: x_visibility_id,
161: 'Y',
162: 0 );
163:
164: INSERT INTO CS_KB_SETS_TL (
165: set_id,
166: name,
167: description,
168: creation_date,

Line 190: FROM CS_KB_SETS_TL t

186: FROM fnd_languages l
187: WHERE l.installed_flag IN ('I', 'B')
188: AND NOT EXISTS
189: (SELECT NULL
190: FROM CS_KB_SETS_TL t
191: WHERE t.set_id = x_set_id
192: AND t.language = l.language_code);
193:
194: OPEN c;

Line 282: FROM CS_KB_SETS_TL

278: SELECT
279: name,
280: description,
281: decode(language, USERENV('LANG'), 'Y', 'N') baselang
282: FROM CS_KB_SETS_TL
283: WHERE set_id = x_set_id
284: AND USERENV('LANG') IN (language, source_lang)
285: FOR UPDATE OF set_id NOWAIT;
286:

Line 461: UPDATE CS_KB_SETS_TL SET

457: IF (SQL%NOTFOUND) THEN
458: RAISE NO_DATA_FOUND;
459: END IF;
460:
461: UPDATE CS_KB_SETS_TL SET
462: name = x_name,
463: description = x_description,
464: last_update_date = x_last_update_date,
465: last_updated_by = x_last_updated_by,

Line 490: DELETE FROM CS_KB_SETS_TL

486:
487: BEGIN
488:
489: FOR rec IN c LOOP
490: DELETE FROM CS_KB_SETS_TL
491: WHERE set_id = rec.set_id;
492: END LOOP;
493:
494: DELETE FROM CS_KB_SETS_B

Line 508: DELETE FROM CS_KB_SETS_TL t

504: IS
505:
506: BEGIN
507:
508: DELETE FROM CS_KB_SETS_TL t
509: WHERE NOT EXISTS
510: (SELECT NULL
511: FROM CS_KB_SETS_B b
512: WHERE b.set_id = t.set_id );

Line 514: UPDATE CS_KB_SETS_TL T SET (

510: (SELECT NULL
511: FROM CS_KB_SETS_B b
512: WHERE b.set_id = t.set_id );
513:
514: UPDATE CS_KB_SETS_TL T SET (
515: name,
516: description
517: ) = (SELECT
518: b.name,

Line 520: FROM CS_KB_SETS_TL b

516: description
517: ) = (SELECT
518: b.name,
519: b.description
520: FROM CS_KB_SETS_TL b
521: WHERE b.set_id = t.set_id
522: AND b.language = t.source_lang)
523: WHERE (
524: t.set_id,

Line 529: FROM CS_KB_SETS_TL subb, CS_KB_SETS_TL subt

525: t.language
526: ) IN (SELECT
527: subt.set_id,
528: subt.language
529: FROM CS_KB_SETS_TL subb, CS_KB_SETS_TL subt
530: WHERE subb.set_id = subt.set_id
531: AND subb.language = subt.source_lang
532: AND (subb.name <> subt.name
533: OR (subb.name IS NULL AND subt.name IS NOT NULL)

Line 540: INSERT INTO CS_KB_SETS_TL (

536: OR (subb.description IS NULL AND subt.description IS NOT NULL)
537: OR (subb.description IS NOT NULL AND subt.description IS NULL)
538: ));
539:
540: INSERT INTO CS_KB_SETS_TL (
541: set_id,
542: name,
543: description,
544: creation_date,

Line 562: FROM CS_KB_SETS_TL b, fnd_languages l --bayu

558: b.last_update_login,
559: b.last_updated_by,
560: l.language_code,
561: b.source_lang
562: FROM CS_KB_SETS_TL b, fnd_languages l --bayu
563: WHERE l.installed_flag IN ('I', 'B')
564: AND b.language = USERENV('LANG')
565: AND NOT EXISTS
566: (SELECT NULL

Line 567: FROM CS_KB_SETS_TL t

563: WHERE l.installed_flag IN ('I', 'B')
564: AND b.language = USERENV('LANG')
565: AND NOT EXISTS
566: (SELECT NULL
567: FROM CS_KB_SETS_TL t
568: WHERE t.set_id = b.set_id
569: AND t.language = l.language_code);
570:
571: END Add_Language;

Line 581: UPDATE CS_KB_SETS_TL SET

577: X_OWNER IN VARCHAR2,
578: X_NAME IN VARCHAR2) IS
579: BEGIN
580:
581: UPDATE CS_KB_SETS_TL SET
582: name = x_name,
583: last_update_date = SYSDATE,
584: last_updated_by = decode(x_owner, 'SEED', 1, 0),
585: last_update_login = 0,