APPS.CS_INCIDENT_STATUSES_PKG dependencies on CS_INCIDENT_STATUSES_TL

Line 166: insert into CS_INCIDENT_STATUSES_TL (

162: p_APPROVAL_ACTION_STATUS_ID,
163: X_DUP_CHK_FLAG
164: );
165:
166: insert into CS_INCIDENT_STATUSES_TL (
167: INCIDENT_STATUS_ID,
168: LAST_UPDATE_DATE,
169: LAST_UPDATED_BY,
170: CREATION_DATE,

Line 192: from CS_INCIDENT_STATUSES_TL T

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

Line 309: from CS_INCIDENT_STATUSES_TL

305: cursor c1 is select
306: NAME,
307: DESCRIPTION,
308: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
309: from CS_INCIDENT_STATUSES_TL
310: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID
311: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
312: for update of INCIDENT_STATUS_ID nowait;
313: begin

Line 550: update CS_INCIDENT_STATUSES_TL set

546: if (sql%notfound) then
547: raise no_data_found;
548: end if;
549:
550: update CS_INCIDENT_STATUSES_TL set
551: NAME = X_NAME,
552: DESCRIPTION = X_DESCRIPTION,
553: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
554: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 581: update cs_incident_statuses_tl set

577: else
578: l_user_id := 0;
579: end if;
580:
581: update cs_incident_statuses_tl set
582: name = nvl(x_name,name),
583: description = nvl(x_description,description),
584: last_update_date = nvl(x_last_update_date,sysdate),
585: last_updated_by = l_user_id,

Line 770: delete from CS_INCIDENT_STATUSES_TL

766: procedure DELETE_ROW (
767: X_INCIDENT_STATUS_ID in NUMBER
768: ) is
769: begin
770: delete from CS_INCIDENT_STATUSES_TL
771: where INCIDENT_STATUS_ID = X_INCIDENT_STATUS_ID;
772:
773: if (sql%notfound) then
774: raise no_data_found;

Line 788: delete from CS_INCIDENT_STATUSES_TL T

784:
785: procedure ADD_LANGUAGE
786: is
787: begin
788: delete from CS_INCIDENT_STATUSES_TL T
789: where not exists
790: (select NULL
791: from CS_INCIDENT_STATUSES_B B
792: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID

Line 795: update CS_INCIDENT_STATUSES_TL T set (

791: from CS_INCIDENT_STATUSES_B B
792: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
793: );
794:
795: update CS_INCIDENT_STATUSES_TL T set (
796: NAME,
797: DESCRIPTION
798: ) = (select
799: B.NAME,

Line 801: from CS_INCIDENT_STATUSES_TL B

797: DESCRIPTION
798: ) = (select
799: B.NAME,
800: B.DESCRIPTION
801: from CS_INCIDENT_STATUSES_TL B
802: where B.INCIDENT_STATUS_ID = T.INCIDENT_STATUS_ID
803: and B.LANGUAGE = T.SOURCE_LANG)
804: where (
805: T.INCIDENT_STATUS_ID,

Line 810: from CS_INCIDENT_STATUSES_TL SUBB, CS_INCIDENT_STATUSES_TL SUBT

806: T.LANGUAGE
807: ) in (select
808: SUBT.INCIDENT_STATUS_ID,
809: SUBT.LANGUAGE
810: from CS_INCIDENT_STATUSES_TL SUBB, CS_INCIDENT_STATUSES_TL SUBT
811: where SUBB.INCIDENT_STATUS_ID = SUBT.INCIDENT_STATUS_ID
812: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
813: and (SUBB.NAME <> SUBT.NAME
814: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 819: insert into CS_INCIDENT_STATUSES_TL (

815: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
816: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
817: ));
818:
819: insert into CS_INCIDENT_STATUSES_TL (
820: INCIDENT_STATUS_ID,
821: LAST_UPDATE_DATE,
822: LAST_UPDATED_BY,
823: CREATION_DATE,

Line 841: from CS_INCIDENT_STATUSES_TL B, FND_LANGUAGES L

837: B.NAME,
838: B.DESCRIPTION,
839: L.LANGUAGE_CODE,
840: B.SOURCE_LANG
841: from CS_INCIDENT_STATUSES_TL B, FND_LANGUAGES L
842: where L.INSTALLED_FLAG in ('I', 'B')
843: and B.LANGUAGE = userenv('LANG')
844: and not exists
845: (select NULL

Line 846: from CS_INCIDENT_STATUSES_TL T

842: where L.INSTALLED_FLAG in ('I', 'B')
843: and B.LANGUAGE = userenv('LANG')
844: and not exists
845: (select NULL
846: from CS_INCIDENT_STATUSES_TL T
847: where T.INCIDENT_STATUS_ID = B.INCIDENT_STATUS_ID
848: and T.LANGUAGE = L.LANGUAGE_CODE);
849: end ADD_LANGUAGE;
850: