APPS.CUG_SR_TASK_ATTR_VALS_PKG dependencies on CUG_SR_TASK_ATTR_VALS_TL

Line 42: insert into CUG_SR_TASK_ATTR_VALS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into CUG_SR_TASK_ATTR_VALS_TL (
43: SR_TASK_ATTR_VAL_ID,
44: CREATED_BY,
45: CREATION_DATE,
46: LAST_UPDATED_BY,

Line 66: from CUG_SR_TASK_ATTR_VALS_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from CUG_SR_TASK_ATTR_VALS_TL T
67: where T.SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from CUG_SR_TASK_ATTR_VALS_TL

95:
96: cursor c1 is select
97: TASK_TYPE_ATTR_VALUE,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from CUG_SR_TASK_ATTR_VALS_TL
100: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of SR_TASK_ATTR_VAL_ID nowait;
103: begin

Line 162: update CUG_SR_TASK_ATTR_VALS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update CUG_SR_TASK_ATTR_VALS_TL set
163: TASK_TYPE_ATTR_VALUE = X_TASK_TYPE_ATTR_VALUE,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
166: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 180: delete from CUG_SR_TASK_ATTR_VALS_TL

176: procedure DELETE_ROW (
177: X_SR_TASK_ATTR_VAL_ID in NUMBER
178: ) is
179: begin
180: delete from CUG_SR_TASK_ATTR_VALS_TL
181: where SR_TASK_ATTR_VAL_ID = X_SR_TASK_ATTR_VAL_ID;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 198: delete from CUG_SR_TASK_ATTR_VALS_TL T

194:
195: procedure ADD_LANGUAGE
196: is
197: begin
198: delete from CUG_SR_TASK_ATTR_VALS_TL T
199: where not exists
200: (select NULL
201: from CUG_SR_TASK_ATTR_VALS_B B
202: where B.SR_TASK_ATTR_VAL_ID = T.SR_TASK_ATTR_VAL_ID

Line 205: update CUG_SR_TASK_ATTR_VALS_TL T set (

201: from CUG_SR_TASK_ATTR_VALS_B B
202: where B.SR_TASK_ATTR_VAL_ID = T.SR_TASK_ATTR_VAL_ID
203: );
204:
205: update CUG_SR_TASK_ATTR_VALS_TL T set (
206: TASK_TYPE_ATTR_VALUE
207: ) = (select
208: B.TASK_TYPE_ATTR_VALUE
209: from CUG_SR_TASK_ATTR_VALS_TL B

Line 209: from CUG_SR_TASK_ATTR_VALS_TL B

205: update CUG_SR_TASK_ATTR_VALS_TL T set (
206: TASK_TYPE_ATTR_VALUE
207: ) = (select
208: B.TASK_TYPE_ATTR_VALUE
209: from CUG_SR_TASK_ATTR_VALS_TL B
210: where B.SR_TASK_ATTR_VAL_ID = T.SR_TASK_ATTR_VAL_ID
211: and B.LANGUAGE = T.SOURCE_LANG)
212: where (
213: T.SR_TASK_ATTR_VAL_ID,

Line 218: from CUG_SR_TASK_ATTR_VALS_TL SUBB, CUG_SR_TASK_ATTR_VALS_TL SUBT

214: T.LANGUAGE
215: ) in (select
216: SUBT.SR_TASK_ATTR_VAL_ID,
217: SUBT.LANGUAGE
218: from CUG_SR_TASK_ATTR_VALS_TL SUBB, CUG_SR_TASK_ATTR_VALS_TL SUBT
219: where SUBB.SR_TASK_ATTR_VAL_ID = SUBT.SR_TASK_ATTR_VAL_ID
220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.TASK_TYPE_ATTR_VALUE <> SUBT.TASK_TYPE_ATTR_VALUE
222: or (SUBB.TASK_TYPE_ATTR_VALUE is null and SUBT.TASK_TYPE_ATTR_VALUE is not null)

Line 226: insert into CUG_SR_TASK_ATTR_VALS_TL (

222: or (SUBB.TASK_TYPE_ATTR_VALUE is null and SUBT.TASK_TYPE_ATTR_VALUE is not null)
223: or (SUBB.TASK_TYPE_ATTR_VALUE is not null and SUBT.TASK_TYPE_ATTR_VALUE is null)
224: ));
225:
226: insert into CUG_SR_TASK_ATTR_VALS_TL (
227: SR_TASK_ATTR_VAL_ID,
228: CREATED_BY,
229: CREATION_DATE,
230: LAST_UPDATED_BY,

Line 246: from CUG_SR_TASK_ATTR_VALS_TL B, FND_LANGUAGES L

242: B.LAST_UPDATE_DATE,
243: B.TASK_TYPE_ATTR_VALUE,
244: L.LANGUAGE_CODE,
245: B.SOURCE_LANG
246: from CUG_SR_TASK_ATTR_VALS_TL B, FND_LANGUAGES L
247: where L.INSTALLED_FLAG in ('I', 'B')
248: and B.LANGUAGE = userenv('LANG')
249: and not exists
250: (select NULL

Line 251: from CUG_SR_TASK_ATTR_VALS_TL T

247: where L.INSTALLED_FLAG in ('I', 'B')
248: and B.LANGUAGE = userenv('LANG')
249: and not exists
250: (select NULL
251: from CUG_SR_TASK_ATTR_VALS_TL T
252: where T.SR_TASK_ATTR_VAL_ID = B.SR_TASK_ATTR_VAL_ID
253: and T.LANGUAGE = L.LANGUAGE_CODE);
254: end ADD_LANGUAGE;
255: