APPS.CS_SR_EVENT_CODES_PKG dependencies on CS_SR_EVENT_CODES_TL

Line 58: insert into CS_SR_EVENT_CODES_TL (

54: P_LAST_UPDATED_BY,
55: P_LAST_UPDATE_LOGIN
56: );
57:
58: insert into CS_SR_EVENT_CODES_TL (
59: CREATION_DATE,
60: CREATED_BY,
61: LAST_UPDATE_DATE,
62: LAST_UPDATED_BY,

Line 84: from CS_SR_EVENT_CODES_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from CS_SR_EVENT_CODES_TL T
85: where T.EVENT_CODE = PX_EVENT_CODE
86: and T.LANGUAGE = L.LANGUAGE_CODE);
87:
88: x_object_version_number := l_object_version_number;

Line 163: update CS_SR_EVENT_CODES_TL set

159: if (sql%notfound) then
160: raise no_data_found;
161: end if;
162:
163: update CS_SR_EVENT_CODES_TL set
164: NAME = P_NAME,
165: DESCRIPTION = P_DESCRIPTION,
166: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
167: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 182: delete from CS_SR_EVENT_CODES_TL

178: procedure DELETE_ROW (
179: P_EVENT_CODE in VARCHAR2
180: ) is
181: begin
182: delete from CS_SR_EVENT_CODES_TL
183: where EVENT_CODE = P_EVENT_CODE;
184:
185: if (sql%notfound) then
186: raise no_data_found;

Line 200: delete from CS_SR_EVENT_CODES_TL T

196:
197: procedure ADD_LANGUAGE
198: is
199: begin
200: delete from CS_SR_EVENT_CODES_TL T
201: where not exists
202: (select NULL
203: from CS_SR_EVENT_CODES_B B
204: where B.EVENT_CODE = T.EVENT_CODE

Line 207: update CS_SR_EVENT_CODES_TL T set (

203: from CS_SR_EVENT_CODES_B B
204: where B.EVENT_CODE = T.EVENT_CODE
205: );
206:
207: update CS_SR_EVENT_CODES_TL T set (
208: NAME,
209: DESCRIPTION
210: ) = (select
211: B.NAME,

Line 213: from CS_SR_EVENT_CODES_TL B

209: DESCRIPTION
210: ) = (select
211: B.NAME,
212: B.DESCRIPTION
213: from CS_SR_EVENT_CODES_TL B
214: where B.EVENT_CODE = T.EVENT_CODE
215: and B.LANGUAGE = T.SOURCE_LANG)
216: where (
217: T.EVENT_CODE,

Line 222: from CS_SR_EVENT_CODES_TL SUBB, CS_SR_EVENT_CODES_TL SUBT

218: T.LANGUAGE
219: ) in (select
220: SUBT.EVENT_CODE,
221: SUBT.LANGUAGE
222: from CS_SR_EVENT_CODES_TL SUBB, CS_SR_EVENT_CODES_TL SUBT
223: where SUBB.EVENT_CODE = SUBT.EVENT_CODE
224: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
225: and (SUBB.NAME <> SUBT.NAME
226: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 231: insert into CS_SR_EVENT_CODES_TL (

227: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
228: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
229: ));
230:
231: insert into CS_SR_EVENT_CODES_TL (
232: CREATION_DATE,
233: CREATED_BY,
234: LAST_UPDATE_DATE,
235: LAST_UPDATED_BY,

Line 253: from CS_SR_EVENT_CODES_TL B, FND_LANGUAGES L

249: B.NAME,
250: B.DESCRIPTION,
251: L.LANGUAGE_CODE,
252: B.SOURCE_LANG
253: from CS_SR_EVENT_CODES_TL B, FND_LANGUAGES L
254: where L.INSTALLED_FLAG in ('I', 'B')
255: and B.LANGUAGE = userenv('LANG')
256: and not exists
257: (select NULL

Line 258: from CS_SR_EVENT_CODES_TL T

254: where L.INSTALLED_FLAG in ('I', 'B')
255: and B.LANGUAGE = userenv('LANG')
256: and not exists
257: (select NULL
258: from CS_SR_EVENT_CODES_TL T
259: where T.EVENT_CODE = B.EVENT_CODE
260: and T.LANGUAGE = L.LANGUAGE_CODE);
261: end ADD_LANGUAGE;
262:

Line 364: update CS_SR_EVENT_CODES_TL set

360: else
361: l_user_id := 0;
362: end if;
363:
364: update CS_SR_EVENT_CODES_TL set
365: name = nvl(x_name,name),
366: description = nvl(x_description,name),
367: last_update_date = nvl(x_last_update_date,sysdate),
368: last_updated_by = l_user_id,