APPS.CS_INCIDENT_STATUSES_PKG dependencies on CS_INCIDENT_STATUSES_TL

Line 163: insert into CS_INCIDENT_STATUSES_TL (

159: p_REJECTION_ACTION_STATUS_ID ,
160: p_APPROVAL_ACTION_STATUS_ID
161: );
162:
163: insert into CS_INCIDENT_STATUSES_TL (
164: INCIDENT_STATUS_ID,
165: LAST_UPDATE_DATE,
166: LAST_UPDATED_BY,
167: CREATION_DATE,

Line 189: from CS_INCIDENT_STATUSES_TL T

185: from FND_LANGUAGES L
186: where L.INSTALLED_FLAG in ('I', 'B')
187: and not exists
188: (select NULL
189: from CS_INCIDENT_STATUSES_TL T
190: where T.INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
191: and T.LANGUAGE = L.LANGUAGE_CODE);
192:
193: open c;

Line 304: from CS_INCIDENT_STATUSES_TL

300: cursor c1 is select
301: NAME,
302: DESCRIPTION,
303: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
304: from CS_INCIDENT_STATUSES_TL
305: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
306: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
307: for update of INCIDENT_STATUS_ID nowait;
308: begin

Line 539: update CS_INCIDENT_STATUSES_TL set

535: if (sql%notfound) then
536: raise no_data_found;
537: end if;
538:
539: update CS_INCIDENT_STATUSES_TL set
540: NAME = X_NAME,
541: DESCRIPTION = X_DESCRIPTION,
542: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
543: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 570: update cs_incident_statuses_tl set

566: else
567: l_user_id := 0;
568: end if;
569:
570: update cs_incident_statuses_tl set
571: name = nvl(x_name,name),
572: description = nvl(x_description,description),
573: last_update_date = nvl(x_last_update_date,sysdate),
574: last_updated_by = l_user_id,

Line 752: delete from CS_INCIDENT_STATUSES_TL

748: procedure DELETE_ROW (
749: X_INCIDENT_STATUS_ID in NUMBER
750: ) is
751: begin
752: delete from CS_INCIDENT_STATUSES_TL
753: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID;
754:
755: if (sql%notfound) then
756: raise no_data_found;

Line 770: delete from CS_INCIDENT_STATUSES_TL T

766:
767: procedure ADD_LANGUAGE
768: is
769: begin
770: delete from CS_INCIDENT_STATUSES_TL T
771: where not exists
772: (select NULL
773: from CS_INCIDENT_STATUSES_B B
774: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID

Line 777: update CS_INCIDENT_STATUSES_TL T set (

773: from CS_INCIDENT_STATUSES_B B
774: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
775: );
776:
777: update CS_INCIDENT_STATUSES_TL T set (
778: NAME,
779: DESCRIPTION
780: ) = (select
781: B.NAME,

Line 783: from CS_INCIDENT_STATUSES_TL B

779: DESCRIPTION
780: ) = (select
781: B.NAME,
782: B.DESCRIPTION
783: from CS_INCIDENT_STATUSES_TL B
784: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
785: and B.LANGUAGE = T.SOURCE_LANG)
786: where (
787: T.INCIDENT_STATUS_ID,

Line 792: from CS_INCIDENT_STATUSES_TL SUBB, CS_INCIDENT_STATUSES_TL SUBT

788: T.LANGUAGE
789: ) in (select
790: SUBT.INCIDENT_STATUS_ID,
791: SUBT.LANGUAGE
792: from CS_INCIDENT_STATUSES_TL SUBB, CS_INCIDENT_STATUSES_TL SUBT
793: where SUBB.INCIDENT_STATUS_ID = SUBT.INCIDENT_STATUS_ID
794: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
795: and (SUBB.NAME <> SUBT.NAME
796: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 801: insert into CS_INCIDENT_STATUSES_TL (

797: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
798: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
799: ));
800:
801: insert into CS_INCIDENT_STATUSES_TL (
802: INCIDENT_STATUS_ID,
803: LAST_UPDATE_DATE,
804: LAST_UPDATED_BY,
805: CREATION_DATE,

Line 823: from CS_INCIDENT_STATUSES_TL B, FND_LANGUAGES L

819: B.NAME,
820: B.DESCRIPTION,
821: L.LANGUAGE_CODE,
822: B.SOURCE_LANG
823: from CS_INCIDENT_STATUSES_TL B, FND_LANGUAGES L
824: where L.INSTALLED_FLAG in ('I', 'B')
825: and B.LANGUAGE = userenv('LANG')
826: and not exists
827: (select NULL

Line 828: from CS_INCIDENT_STATUSES_TL T

824: where L.INSTALLED_FLAG in ('I', 'B')
825: and B.LANGUAGE = userenv('LANG')
826: and not exists
827: (select NULL
828: from CS_INCIDENT_STATUSES_TL T
829: where T.INCIDENT_STATUS_ID = B.INCIDENT_STATUS_ID
830: and T.LANGUAGE = L.LANGUAGE_CODE);
831: end ADD_LANGUAGE;
832: