APPS.CS_INCIDENTS_PURGE_AUDIT_PKG dependencies on CS_INCIDENTS_PURGE_AUDIT_TL

Line 66: insert into CS_INCIDENTS_PURGE_AUDIT_TL (

62: X_LAST_UPDATED_BY,
63: X_LAST_UPDATE_LOGIN
64: );
65:
66: insert into CS_INCIDENTS_PURGE_AUDIT_TL (
67: PURGE_ID,
68: INCIDENT_ID,
69: SUMMARY,
70: CREATION_DATE,

Line 92: from CS_INCIDENTS_PURGE_AUDIT_TL T

88: from FND_LANGUAGES L
89: where L.INSTALLED_FLAG in ('I', 'B')
90: and not exists
91: (select NULL
92: from CS_INCIDENTS_PURGE_AUDIT_TL T
93: where T.INCIDENT_ID = X_INCIDENT_ID
94: and T.LANGUAGE = L.LANGUAGE_CODE);
95:
96: open c;

Line 141: from CS_INCIDENTS_PURGE_AUDIT_TL

137:
138: cursor c1 is select
139: SUMMARY,
140: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
141: from CS_INCIDENTS_PURGE_AUDIT_TL
142: where INCIDENT_ID = X_INCIDENT_ID
143: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
144: for update of INCIDENT_ID nowait;
145: begin

Line 230: update CS_INCIDENTS_PURGE_AUDIT_TL set

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: update CS_INCIDENTS_PURGE_AUDIT_TL set
231: SUMMARY = X_SUMMARY,
232: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
233: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
234: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 248: delete from CS_INCIDENTS_PURGE_AUDIT_TL

244: procedure DELETE_ROW (
245: X_INCIDENT_ID in NUMBER
246: ) is
247: begin
248: delete from CS_INCIDENTS_PURGE_AUDIT_TL
249: where INCIDENT_ID = X_INCIDENT_ID;
250:
251: if (sql%notfound) then
252: raise no_data_found;

Line 266: delete from CS_INCIDENTS_PURGE_AUDIT_TL T

262:
263: procedure ADD_LANGUAGE
264: is
265: begin
266: delete from CS_INCIDENTS_PURGE_AUDIT_TL T
267: where not exists
268: (select NULL
269: from CS_INCIDENTS_PURGE_AUDIT_B B
270: where B.INCIDENT_ID = T.INCIDENT_ID

Line 273: update CS_INCIDENTS_PURGE_AUDIT_TL T set (

269: from CS_INCIDENTS_PURGE_AUDIT_B B
270: where B.INCIDENT_ID = T.INCIDENT_ID
271: );
272:
273: update CS_INCIDENTS_PURGE_AUDIT_TL T set (
274: SUMMARY
275: ) = (select
276: B.SUMMARY
277: from CS_INCIDENTS_PURGE_AUDIT_TL B

Line 277: from CS_INCIDENTS_PURGE_AUDIT_TL B

273: update CS_INCIDENTS_PURGE_AUDIT_TL T set (
274: SUMMARY
275: ) = (select
276: B.SUMMARY
277: from CS_INCIDENTS_PURGE_AUDIT_TL B
278: where B.INCIDENT_ID = T.INCIDENT_ID
279: and B.LANGUAGE = T.SOURCE_LANG)
280: where (
281: T.INCIDENT_ID,

Line 286: from CS_INCIDENTS_PURGE_AUDIT_TL SUBB, CS_INCIDENTS_PURGE_AUDIT_TL SUBT

282: T.LANGUAGE
283: ) in (select
284: SUBT.INCIDENT_ID,
285: SUBT.LANGUAGE
286: from CS_INCIDENTS_PURGE_AUDIT_TL SUBB, CS_INCIDENTS_PURGE_AUDIT_TL SUBT
287: where SUBB.INCIDENT_ID = SUBT.INCIDENT_ID
288: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
289: and (SUBB.SUMMARY <> SUBT.SUMMARY
290: ));

Line 292: insert into CS_INCIDENTS_PURGE_AUDIT_TL (

288: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
289: and (SUBB.SUMMARY <> SUBT.SUMMARY
290: ));
291:
292: insert into CS_INCIDENTS_PURGE_AUDIT_TL (
293: PURGE_ID,
294: INCIDENT_ID,
295: SUMMARY,
296: CREATION_DATE,

Line 314: from CS_INCIDENTS_PURGE_AUDIT_TL B, FND_LANGUAGES L

310: B.LAST_UPDATED_BY,
311: B.LAST_UPDATE_LOGIN,
312: L.LANGUAGE_CODE,
313: B.SOURCE_LANG
314: from CS_INCIDENTS_PURGE_AUDIT_TL B, FND_LANGUAGES L
315: where L.INSTALLED_FLAG in ('I', 'B')
316: and B.LANGUAGE = userenv('LANG')
317: and not exists
318: (select NULL

Line 319: from CS_INCIDENTS_PURGE_AUDIT_TL T

315: where L.INSTALLED_FLAG in ('I', 'B')
316: and B.LANGUAGE = userenv('LANG')
317: and not exists
318: (select NULL
319: from CS_INCIDENTS_PURGE_AUDIT_TL T
320: where T.INCIDENT_ID = B.INCIDENT_ID
321: and T.LANGUAGE = L.LANGUAGE_CODE);
322: end ADD_LANGUAGE;
323: