APPS.CUG_INCIDNT_ATTR_VALS_PKG dependencies on CUG_INCIDNT_ATTR_VALS_TL

Line 93: insert into CUG_INCIDNT_ATTR_VALS_TL (

89: X_LAST_UPDATED_BY,
90: X_LAST_UPDATE_LOGIN
91: );
92:
93: insert into CUG_INCIDNT_ATTR_VALS_TL (
94: INCIDNT_ATTR_VAL_ID,
95: CREATED_BY,
96: CREATION_DATE,
97: LAST_UPDATED_BY,

Line 117: from CUG_INCIDNT_ATTR_VALS_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from CUG_INCIDNT_ATTR_VALS_TL T
118: where T.INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 185: from CUG_INCIDNT_ATTR_VALS_TL

181:
182: cursor c1 is select
183: SR_ATTRIBUTE_VALUE,
184: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
185: from CUG_INCIDNT_ATTR_VALS_TL
186: where INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID
187: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
188: for update of INCIDNT_ATTR_VAL_ID nowait;
189: begin

Line 317: update CUG_INCIDNT_ATTR_VALS_TL set

313: if (sql%notfound) then
314: raise no_data_found;
315: end if;
316:
317: update CUG_INCIDNT_ATTR_VALS_TL set
318: SR_ATTRIBUTE_VALUE = X_SR_ATTRIBUTE_VALUE,
319: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
320: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
321: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 335: delete from CUG_INCIDNT_ATTR_VALS_TL

331: procedure DELETE_ROW (
332: X_INCIDNT_ATTR_VAL_ID in NUMBER
333: ) is
334: begin
335: delete from CUG_INCIDNT_ATTR_VALS_TL
336: where INCIDNT_ATTR_VAL_ID = X_INCIDNT_ATTR_VAL_ID;
337:
338: if (sql%notfound) then
339: raise no_data_found;

Line 353: delete from CUG_INCIDNT_ATTR_VALS_TL T

349:
350: procedure ADD_LANGUAGE
351: is
352: begin
353: delete from CUG_INCIDNT_ATTR_VALS_TL T
354: where not exists
355: (select NULL
356: from CUG_INCIDNT_ATTR_VALS_B B
357: where B.INCIDNT_ATTR_VAL_ID = T.INCIDNT_ATTR_VAL_ID

Line 360: update CUG_INCIDNT_ATTR_VALS_TL T set (

356: from CUG_INCIDNT_ATTR_VALS_B B
357: where B.INCIDNT_ATTR_VAL_ID = T.INCIDNT_ATTR_VAL_ID
358: );
359:
360: update CUG_INCIDNT_ATTR_VALS_TL T set (
361: SR_ATTRIBUTE_VALUE
362: ) = (select
363: B.SR_ATTRIBUTE_VALUE
364: from CUG_INCIDNT_ATTR_VALS_TL B

Line 364: from CUG_INCIDNT_ATTR_VALS_TL B

360: update CUG_INCIDNT_ATTR_VALS_TL T set (
361: SR_ATTRIBUTE_VALUE
362: ) = (select
363: B.SR_ATTRIBUTE_VALUE
364: from CUG_INCIDNT_ATTR_VALS_TL B
365: where B.INCIDNT_ATTR_VAL_ID = T.INCIDNT_ATTR_VAL_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.INCIDNT_ATTR_VAL_ID,

Line 373: from CUG_INCIDNT_ATTR_VALS_TL SUBB, CUG_INCIDNT_ATTR_VALS_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.INCIDNT_ATTR_VAL_ID,
372: SUBT.LANGUAGE
373: from CUG_INCIDNT_ATTR_VALS_TL SUBB, CUG_INCIDNT_ATTR_VALS_TL SUBT
374: where SUBB.INCIDNT_ATTR_VAL_ID = SUBT.INCIDNT_ATTR_VAL_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.SR_ATTRIBUTE_VALUE <> SUBT.SR_ATTRIBUTE_VALUE
377: or (SUBB.SR_ATTRIBUTE_VALUE is null and SUBT.SR_ATTRIBUTE_VALUE is not null)

Line 381: insert into CUG_INCIDNT_ATTR_VALS_TL (

377: or (SUBB.SR_ATTRIBUTE_VALUE is null and SUBT.SR_ATTRIBUTE_VALUE is not null)
378: or (SUBB.SR_ATTRIBUTE_VALUE is not null and SUBT.SR_ATTRIBUTE_VALUE is null)
379: ));
380:
381: insert into CUG_INCIDNT_ATTR_VALS_TL (
382: INCIDNT_ATTR_VAL_ID,
383: CREATED_BY,
384: CREATION_DATE,
385: LAST_UPDATED_BY,

Line 401: from CUG_INCIDNT_ATTR_VALS_TL B, FND_LANGUAGES L

397: B.LAST_UPDATE_LOGIN,
398: B.SR_ATTRIBUTE_VALUE,
399: L.LANGUAGE_CODE,
400: B.SOURCE_LANG
401: from CUG_INCIDNT_ATTR_VALS_TL B, FND_LANGUAGES L
402: where L.INSTALLED_FLAG in ('I', 'B')
403: and B.LANGUAGE = userenv('LANG')
404: and not exists
405: (select NULL

Line 406: from CUG_INCIDNT_ATTR_VALS_TL T

402: where L.INSTALLED_FLAG in ('I', 'B')
403: and B.LANGUAGE = userenv('LANG')
404: and not exists
405: (select NULL
406: from CUG_INCIDNT_ATTR_VALS_TL T
407: where T.INCIDNT_ATTR_VAL_ID = B.INCIDNT_ATTR_VAL_ID
408: and T.LANGUAGE = L.LANGUAGE_CODE);
409: end ADD_LANGUAGE;
410: