APPS.HZ_DSS_GROUPS_PKG dependencies on HZ_DSS_GROUPS_TL

Line 59: INSERT INTO HZ_DSS_GROUPS_TL (

55: rowid
56: INTO
57: x_rowid;
58:
59: INSERT INTO HZ_DSS_GROUPS_TL (
60: dss_group_code,
61: language,
62: source_lang,
63: dss_group_name,

Line 88: FROM HZ_DSS_GROUPS_TL T

84: WHERE L.INSTALLED_FLAG in ('I', 'B')
85: and B.INSTALLED_FLAG = 'B'
86: and not exists
87: (SELECT NULL
88: FROM HZ_DSS_GROUPS_TL T
89: WHERE T.dss_group_code = x_dss_group_code AND
90: T.LANGUAGE = L.LANGUAGE_CODE);
91: l_success := 'Y';
92:

Line 147: UPDATE HZ_DSS_GROUPS_TL

143: IF ( SQL%NOTFOUND ) THEN
144: RAISE NO_DATA_FOUND;
145: END IF;
146:
147: UPDATE HZ_DSS_GROUPS_TL
148: SET
149: source_lang =
150: DECODE(USERENV('LANG'),
151: NULL, source_lang,

Line 283: FROM HZ_DSS_GROUPS_TL

279: NVL(dss_group_name, FND_API.G_MISS_CHAR),
280: NVL(description, FND_API.G_MISS_CHAR)
281: INTO
282: x_dss_group_code, x_dummy1, x_dummy2
283: FROM HZ_DSS_GROUPS_TL
284: WHERE dss_group_code = x_dss_group_code AND
285: USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
286:
287: EXCEPTION

Line 309: DELETE FROM HZ_DSS_GROUPS_TL

305: IF ( SQL%NOTFOUND ) THEN
306: RAISE NO_DATA_FOUND;
307: END IF;
308:
309: DELETE FROM HZ_DSS_GROUPS_TL
310: WHERE dss_group_code = x_dss_group_code;
311:
312: IF ( SQL%NOTFOUND ) THEN
313: RAISE NO_DATA_FOUND;

Line 323: delete from HZ_DSS_GROUPS_TL T

319:
320: procedure ADD_LANGUAGE
321: is
322: begin
323: delete from HZ_DSS_GROUPS_TL T
324: where not exists
325: (select NULL
326: from HZ_DSS_GROUPS_B B
327: where B.DSS_GROUP_CODE = T.DSS_GROUP_CODE

Line 330: update HZ_DSS_GROUPS_TL T set (

326: from HZ_DSS_GROUPS_B B
327: where B.DSS_GROUP_CODE = T.DSS_GROUP_CODE
328: );
329:
330: update HZ_DSS_GROUPS_TL T set (
331: DSS_GROUP_CODE,
332: DESCRIPTION
333: ) = (select
334: B.DSS_GROUP_NAME,

Line 336: from HZ_DSS_GROUPS_TL B

332: DESCRIPTION
333: ) = (select
334: B.DSS_GROUP_NAME,
335: B.DESCRIPTION
336: from HZ_DSS_GROUPS_TL B
337: where B.DSS_GROUP_CODE = T.DSS_GROUP_CODE
338: and B.LANGUAGE = T.SOURCE_LANG)
339: where (
340: T.DSS_GROUP_CODE,

Line 345: from HZ_DSS_GROUPS_TL SUBB, HZ_DSS_GROUPS_TL SUBT

341: T.LANGUAGE
342: ) in (select
343: SUBT.DSS_GROUP_CODE,
344: SUBT.LANGUAGE
345: from HZ_DSS_GROUPS_TL SUBB, HZ_DSS_GROUPS_TL SUBT
346: where SUBB.DSS_GROUP_CODE = SUBT.DSS_GROUP_CODE
347: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
348: and (SUBB.DSS_GROUP_NAME <> SUBT.DSS_GROUP_NAME
349: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 354: insert into HZ_DSS_GROUPS_TL (

350: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
351: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
352: ));
353:
354: insert into HZ_DSS_GROUPS_TL (
355: DSS_GROUP_CODE,
356: DSS_GROUP_NAME,
357: DESCRIPTION,
358: LAST_UPDATE_DATE,

Line 376: from HZ_DSS_GROUPS_TL B, FND_LANGUAGES L

372: B.CREATED_BY,
373: B.LAST_UPDATE_LOGIN,
374: L.LANGUAGE_CODE,
375: B.SOURCE_LANG
376: from HZ_DSS_GROUPS_TL B, FND_LANGUAGES L
377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL

Line 381: from HZ_DSS_GROUPS_TL T

377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL
381: from HZ_DSS_GROUPS_TL T
382: where T.DSS_GROUP_CODE = B.DSS_GROUP_CODE
383: and T.LANGUAGE = L.LANGUAGE_CODE);
384: end ADD_LANGUAGE;
385:

Line 489: from HZ_DSS_GROUPS_TL

485:
486: begin
487: select LAST_UPDATED_BY, LAST_UPDATE_DATE
488: into l_db_luby, l_db_ludate
489: from HZ_DSS_GROUPS_TL
490: where DSS_GROUP_CODE = x_dss_group_code
491: and LANGUAGE = userenv('LANG');
492:
493: -- Update record, honoring customization mode.

Line 503: update HZ_DSS_GROUPS_TL

499: if ((x_custom_mode = 'FORCE') or
500: ((l_f_luby = 0) and (l_db_luby = 1)) or
501: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
502: then
503: update HZ_DSS_GROUPS_TL
504: set DSS_GROUP_NAME = nvl(X_DSS_GROUP_NAME,DSS_GROUP_NAME),
505: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
506: LAST_UPDATE_DATE = l_f_ludate,
507: LAST_UPDATED_BY = l_f_luby,