APPS.ITA_SETUP_GROUPS_PKG dependencies on ITA_SETUP_GROUPS_TL

Line 57: insert into ITA_SETUP_GROUPS_TL (

53: X_LAST_UPDATED_BY,
54: X_LAST_UPDATE_LOGIN
55: );
56:
57: insert into ITA_SETUP_GROUPS_TL (
58: CREATED_BY,
59: CREATION_DATE,
60: LAST_UPDATED_BY,
61: LAST_UPDATE_DATE,

Line 83: from ITA_SETUP_GROUPS_TL T

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

Line 126: from ITA_SETUP_GROUPS_TL

122:
123: cursor c1 is select
124: SETUP_GROUP_NAME,
125: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
126: from ITA_SETUP_GROUPS_TL
127: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE
128: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
129: for update of SETUP_GROUP_CODE nowait;
130: begin

Line 213: update ITA_SETUP_GROUPS_TL set

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: update ITA_SETUP_GROUPS_TL set
214: SETUP_GROUP_NAME = X_SETUP_GROUP_NAME,
215: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
216: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
217: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 231: delete from ITA_SETUP_GROUPS_TL

227: procedure DELETE_ROW (
228: X_SETUP_GROUP_CODE in VARCHAR2
229: ) is
230: begin
231: delete from ITA_SETUP_GROUPS_TL
232: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 249: delete from ITA_SETUP_GROUPS_TL T

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

Line 256: update ITA_SETUP_GROUPS_TL T set (

252: from ITA_SETUP_GROUPS_B B
253: where B.SETUP_GROUP_CODE = T.SETUP_GROUP_CODE
254: );
255:
256: update ITA_SETUP_GROUPS_TL T set (
257: SETUP_GROUP_NAME
258: ) = (select
259: B.SETUP_GROUP_NAME
260: from ITA_SETUP_GROUPS_TL B

Line 260: from ITA_SETUP_GROUPS_TL B

256: update ITA_SETUP_GROUPS_TL T set (
257: SETUP_GROUP_NAME
258: ) = (select
259: B.SETUP_GROUP_NAME
260: from ITA_SETUP_GROUPS_TL B
261: where B.SETUP_GROUP_CODE = T.SETUP_GROUP_CODE
262: and B.LANGUAGE = T.SOURCE_LANG)
263: where (
264: T.SETUP_GROUP_CODE,

Line 269: from ITA_SETUP_GROUPS_TL SUBB, ITA_SETUP_GROUPS_TL SUBT

265: T.LANGUAGE
266: ) in (select
267: SUBT.SETUP_GROUP_CODE,
268: SUBT.LANGUAGE
269: from ITA_SETUP_GROUPS_TL SUBB, ITA_SETUP_GROUPS_TL SUBT
270: where SUBB.SETUP_GROUP_CODE = SUBT.SETUP_GROUP_CODE
271: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
272: and (SUBB.SETUP_GROUP_NAME <> SUBT.SETUP_GROUP_NAME
273: or (SUBB.SETUP_GROUP_NAME is null and SUBT.SETUP_GROUP_NAME is not null)

Line 277: insert into ITA_SETUP_GROUPS_TL (

273: or (SUBB.SETUP_GROUP_NAME is null and SUBT.SETUP_GROUP_NAME is not null)
274: or (SUBB.SETUP_GROUP_NAME is not null and SUBT.SETUP_GROUP_NAME is null)
275: ));
276:
277: insert into ITA_SETUP_GROUPS_TL (
278: CREATED_BY,
279: CREATION_DATE,
280: LAST_UPDATED_BY,
281: LAST_UPDATE_DATE,

Line 299: from ITA_SETUP_GROUPS_TL B, FND_LANGUAGES L

295: B.SETUP_GROUP_CODE,
296: B.SETUP_GROUP_NAME,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANG
299: from ITA_SETUP_GROUPS_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL

Line 304: from ITA_SETUP_GROUPS_TL T

300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL
304: from ITA_SETUP_GROUPS_TL T
305: where T.SETUP_GROUP_CODE = B.SETUP_GROUP_CODE
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307: end ADD_LANGUAGE;
308:

Line 450: from ITA_SETUP_GROUPS_TL

446:
447: begin
448: select LAST_UPDATED_BY, LAST_UPDATE_DATE
449: into db_luby, db_ludate
450: from ITA_SETUP_GROUPS_TL
451: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE
452: and LANGUAGE = userenv('LANG');
453:
454: -- Test for customization and version

Line 458: update ITA_SETUP_GROUPS_TL set

454: -- Test for customization and version
455: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
456: db_ludate, x_CUSTOM_MODE)) then
457: -- Update translations for this language
458: update ITA_SETUP_GROUPS_TL set
459: SETUP_GROUP_NAME = decode(x_SETUP_GROUP_NAME,
460: fnd_load_util.null_value, null, -- Real null
461: null, x_SETUP_GROUP_NAME, -- No change
462: x_SETUP_GROUP_NAME),