APPS.CAC_SR_EXCEPTIONS_PKG dependencies on CAC_SR_EXCEPTIONS_TL

Line 58: insert into CAC_SR_EXCEPTIONS_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into CAC_SR_EXCEPTIONS_TL (
59: CREATION_DATE,
60: LAST_UPDATED_BY,
61: LAST_UPDATE_DATE,
62: LAST_UPDATE_LOGIN,

Line 84: from CAC_SR_EXCEPTIONS_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from CAC_SR_EXCEPTIONS_TL T
85: where T.EXCEPTION_ID = X_EXCEPTION_ID
86: and T.LANGUAGE = L.LANGUAGE_CODE);
87:
88: open c;

Line 129: from CAC_SR_EXCEPTIONS_TL

125: cursor c1 is select
126: EXCEPTION_NAME,
127: EXCEPTION_DESC,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from CAC_SR_EXCEPTIONS_TL
130: where EXCEPTION_ID = X_EXCEPTION_ID
131: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
132: for update of EXCEPTION_ID nowait;
133: begin

Line 212: update CAC_SR_EXCEPTIONS_TL set

208: if (sql%notfound) then
209: raise no_data_found;
210: end if;
211:
212: update CAC_SR_EXCEPTIONS_TL set
213: EXCEPTION_NAME = X_EXCEPTION_NAME,
214: EXCEPTION_DESC = X_EXCEPTION_DESC,
215: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
216: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 231: delete from CAC_SR_EXCEPTIONS_TL

227: procedure DELETE_ROW (
228: X_EXCEPTION_ID in NUMBER
229: ) is
230: begin
231: delete from CAC_SR_EXCEPTIONS_TL
232: where EXCEPTION_ID = X_EXCEPTION_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 249: delete from CAC_SR_EXCEPTIONS_TL T

245:
246: procedure ADD_LANGUAGE
247: is
248: begin
249: delete from CAC_SR_EXCEPTIONS_TL T
250: where not exists
251: (select NULL
252: from CAC_SR_EXCEPTIONS_B B
253: where B.EXCEPTION_ID = T.EXCEPTION_ID

Line 256: update CAC_SR_EXCEPTIONS_TL T set (

252: from CAC_SR_EXCEPTIONS_B B
253: where B.EXCEPTION_ID = T.EXCEPTION_ID
254: );
255:
256: update CAC_SR_EXCEPTIONS_TL T set (
257: EXCEPTION_NAME,
258: EXCEPTION_DESC
259: ) = (select
260: B.EXCEPTION_NAME,

Line 262: from CAC_SR_EXCEPTIONS_TL B

258: EXCEPTION_DESC
259: ) = (select
260: B.EXCEPTION_NAME,
261: B.EXCEPTION_DESC
262: from CAC_SR_EXCEPTIONS_TL B
263: where B.EXCEPTION_ID = T.EXCEPTION_ID
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (
266: T.EXCEPTION_ID,

Line 271: from CAC_SR_EXCEPTIONS_TL SUBB, CAC_SR_EXCEPTIONS_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.EXCEPTION_ID,
270: SUBT.LANGUAGE
271: from CAC_SR_EXCEPTIONS_TL SUBB, CAC_SR_EXCEPTIONS_TL SUBT
272: where SUBB.EXCEPTION_ID = SUBT.EXCEPTION_ID
273: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
274: and (SUBB.EXCEPTION_NAME <> SUBT.EXCEPTION_NAME
275: or SUBB.EXCEPTION_DESC <> SUBT.EXCEPTION_DESC

Line 280: insert into CAC_SR_EXCEPTIONS_TL (

276: or (SUBB.EXCEPTION_DESC is null and SUBT.EXCEPTION_DESC is not null)
277: or (SUBB.EXCEPTION_DESC is not null and SUBT.EXCEPTION_DESC is null)
278: ));
279:
280: insert into CAC_SR_EXCEPTIONS_TL (
281: CREATION_DATE,
282: LAST_UPDATED_BY,
283: LAST_UPDATE_DATE,
284: LAST_UPDATE_LOGIN,

Line 302: from CAC_SR_EXCEPTIONS_TL B, FND_LANGUAGES L

298: B.EXCEPTION_DESC,
299: B.EXCEPTION_ID,
300: L.LANGUAGE_CODE,
301: B.SOURCE_LANG
302: from CAC_SR_EXCEPTIONS_TL B, FND_LANGUAGES L
303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL

Line 307: from CAC_SR_EXCEPTIONS_TL T

303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL
307: from CAC_SR_EXCEPTIONS_TL T
308: where T.EXCEPTION_ID = B.EXCEPTION_ID
309: and T.LANGUAGE = L.LANGUAGE_CODE);
310: end ADD_LANGUAGE;
311: