APPS.CS_INCIDENT_TYPES_PKG dependencies on CS_INCIDENT_TYPES_TL

Line 162: insert into CS_INCIDENT_TYPES_TL (

158: X_IMAGE_FILE_NAME,
159: P_DETAILED_ERECORD_REQ_FLAG
160: );
161:
162: insert into CS_INCIDENT_TYPES_TL (
163: NAME,
164: INCIDENT_TYPE_ID,
165: DESCRIPTION,
166: CREATED_BY,

Line 188: from CS_INCIDENT_TYPES_TL T

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

Line 369: from CS_INCIDENT_TYPES_TL

365: cursor c1 is select
366: NAME,
367: DESCRIPTION,
368: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
369: from CS_INCIDENT_TYPES_TL
370: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID
371: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
372: for update of INCIDENT_TYPE_ID nowait;
373: begin

Line 615: update CS_INCIDENT_TYPES_TL set

611: if (sql%notfound) then
612: raise no_data_found;
613: end if;
614:
615: update CS_INCIDENT_TYPES_TL set
616: NAME = X_NAME,
617: DESCRIPTION = X_DESCRIPTION,
618: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
619: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 723: update cs_incident_types_tl set

719: else
720: l_user_id := 0;
721: end if;
722:
723: update cs_incident_types_tl set
724: name = nvl(x_name,name),
725: description = nvl(x_description, description), -- 5353154, if null set it description
726: last_update_date = nvl(x_last_update_date,sysdate),
727: last_updated_by = l_user_id,

Line 894: delete from CS_INCIDENT_TYPES_TL

890: procedure DELETE_ROW (
891: X_INCIDENT_TYPE_ID in NUMBER
892: ) is
893: begin
894: delete from CS_INCIDENT_TYPES_TL
895: where INCIDENT_TYPE_ID = X_INCIDENT_TYPE_ID;
896:
897: if (sql%notfound) then
898: raise no_data_found;

Line 912: delete from CS_INCIDENT_TYPES_TL T

908:
909: procedure ADD_LANGUAGE
910: is
911: begin
912: delete from CS_INCIDENT_TYPES_TL T
913: where not exists
914: (select NULL
915: from CS_INCIDENT_TYPES_B B
916: where B.INCIDENT_TYPE_ID = T.INCIDENT_TYPE_ID

Line 919: update CS_INCIDENT_TYPES_TL T set (

915: from CS_INCIDENT_TYPES_B B
916: where B.INCIDENT_TYPE_ID = T.INCIDENT_TYPE_ID
917: );
918:
919: update CS_INCIDENT_TYPES_TL T set (
920: NAME,
921: DESCRIPTION
922: ) = (select
923: B.NAME,

Line 925: from CS_INCIDENT_TYPES_TL B

921: DESCRIPTION
922: ) = (select
923: B.NAME,
924: B.DESCRIPTION
925: from CS_INCIDENT_TYPES_TL B
926: where B.INCIDENT_TYPE_ID = T.INCIDENT_TYPE_ID
927: and B.LANGUAGE = T.SOURCE_LANG)
928: where (
929: T.INCIDENT_TYPE_ID,

Line 934: from CS_INCIDENT_TYPES_TL SUBB, CS_INCIDENT_TYPES_TL SUBT

930: T.LANGUAGE
931: ) in (select
932: SUBT.INCIDENT_TYPE_ID,
933: SUBT.LANGUAGE
934: from CS_INCIDENT_TYPES_TL SUBB, CS_INCIDENT_TYPES_TL SUBT
935: where SUBB.INCIDENT_TYPE_ID = SUBT.INCIDENT_TYPE_ID
936: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
937: and (SUBB.NAME <> SUBT.NAME
938: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 943: insert into CS_INCIDENT_TYPES_TL (

939: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
940: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
941: ));
942:
943: insert into CS_INCIDENT_TYPES_TL (
944: NAME,
945: INCIDENT_TYPE_ID,
946: DESCRIPTION,
947: CREATED_BY,

Line 965: from CS_INCIDENT_TYPES_TL B, FND_LANGUAGES L

961: B.LAST_UPDATE_DATE,
962: B.LAST_UPDATE_LOGIN,
963: L.LANGUAGE_CODE,
964: B.SOURCE_LANG
965: from CS_INCIDENT_TYPES_TL B, FND_LANGUAGES L
966: where L.INSTALLED_FLAG in ('I', 'B')
967: and B.LANGUAGE = userenv('LANG')
968: and not exists
969: (select NULL

Line 970: from CS_INCIDENT_TYPES_TL T

966: where L.INSTALLED_FLAG in ('I', 'B')
967: and B.LANGUAGE = userenv('LANG')
968: and not exists
969: (select NULL
970: from CS_INCIDENT_TYPES_TL T
971: where T.INCIDENT_TYPE_ID = B.INCIDENT_TYPE_ID
972: and T.LANGUAGE = L.LANGUAGE_CODE);
973: end ADD_LANGUAGE;
974: