APPS.CS_KB_SET_TYPES_PKG dependencies on CS_KB_SET_TYPES_TL

Line 340: insert into CS_KB_SET_TYPES_TL (

336: X_START_DATE,
337: X_END_DATE
338: );
339:
340: insert into CS_KB_SET_TYPES_TL (
341: SET_TYPE_ID,
342: NAME,
343: DESCRIPTION,
344: CREATION_DATE,

Line 366: from CS_KB_SET_TYPES_TL T

362: from FND_LANGUAGES L
363: where L.INSTALLED_FLAG in ('I', 'B')
364: and not exists
365: (select NULL
366: from CS_KB_SET_TYPES_TL T
367: where T.SET_TYPE_ID = X_SET_TYPE_ID
368: and T.LANGUAGE = L.LANGUAGE_CODE);
369:
370: open c;

Line 434: from CS_KB_SET_TYPES_TL

430: cursor c1 is select
431: NAME,
432: DESCRIPTION,
433: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
434: from CS_KB_SET_TYPES_TL
435: where SET_TYPE_ID = X_SET_TYPE_ID
436: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
437: for update of SET_TYPE_ID nowait;
438: begin

Line 569: update CS_KB_SET_TYPES_TL set

565: if (sql%notfound) then
566: raise no_data_found;
567: end if;
568:
569: update CS_KB_SET_TYPES_TL set
570: NAME = X_NAME,
571: DESCRIPTION = X_DESCRIPTION,
572: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
573: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 588: delete from CS_KB_SET_TYPES_TL

584: procedure DELETE_ROW (
585: X_SET_TYPE_ID in NUMBER
586: ) is
587: begin
588: delete from CS_KB_SET_TYPES_TL
589: where SET_TYPE_ID = X_SET_TYPE_ID;
590:
591: if (sql%notfound) then
592: raise no_data_found;

Line 606: delete from CS_KB_SET_TYPES_TL T

602:
603: procedure ADD_LANGUAGE
604: is
605: begin
606: delete from CS_KB_SET_TYPES_TL T
607: where not exists
608: (select NULL
609: from CS_KB_SET_TYPES_B B
610: where B.SET_TYPE_ID = T.SET_TYPE_ID

Line 613: update CS_KB_SET_TYPES_TL T set (

609: from CS_KB_SET_TYPES_B B
610: where B.SET_TYPE_ID = T.SET_TYPE_ID
611: );
612:
613: update CS_KB_SET_TYPES_TL T set (
614: NAME,
615: DESCRIPTION
616: ) = (select
617: B.NAME,

Line 619: from CS_KB_SET_TYPES_TL B

615: DESCRIPTION
616: ) = (select
617: B.NAME,
618: B.DESCRIPTION
619: from CS_KB_SET_TYPES_TL B
620: where B.SET_TYPE_ID = T.SET_TYPE_ID
621: and B.LANGUAGE = T.SOURCE_LANG)
622: where (
623: T.SET_TYPE_ID,

Line 628: from CS_KB_SET_TYPES_TL SUBB, CS_KB_SET_TYPES_TL SUBT

624: T.LANGUAGE
625: ) in (select
626: SUBT.SET_TYPE_ID,
627: SUBT.LANGUAGE
628: from CS_KB_SET_TYPES_TL SUBB, CS_KB_SET_TYPES_TL SUBT
629: where SUBB.SET_TYPE_ID = SUBT.SET_TYPE_ID
630: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
631: and (SUBB.NAME <> SUBT.NAME
632: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 639: insert into CS_KB_SET_TYPES_TL (

635: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
636: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
637: ));
638:
639: insert into CS_KB_SET_TYPES_TL (
640: SET_TYPE_ID,
641: NAME,
642: DESCRIPTION,
643: CREATION_DATE,

Line 661: from CS_KB_SET_TYPES_TL B, FND_LANGUAGES L

657: B.LAST_UPDATED_BY,
658: B.LAST_UPDATE_LOGIN,
659: L.LANGUAGE_CODE,
660: B.SOURCE_LANG
661: from CS_KB_SET_TYPES_TL B, FND_LANGUAGES L
662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL

Line 666: from CS_KB_SET_TYPES_TL T

662: where L.INSTALLED_FLAG in ('I', 'B')
663: and B.LANGUAGE = userenv('LANG')
664: and not exists
665: (select NULL
666: from CS_KB_SET_TYPES_TL T
667: where T.SET_TYPE_ID = B.SET_TYPE_ID
668: and T.LANGUAGE = L.LANGUAGE_CODE);
669: end ADD_LANGUAGE;
670:

Line 681: update CS_KB_SET_TYPES_TL set

677: l_user_id number;
678:
679: begin
680:
681: update CS_KB_SET_TYPES_TL set
682: NAME = X_NAME,
683: DESCRIPTION=X_DESCRIPTION,
684: last_update_date = sysdate,
685: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),