APPS.AHL_ITEM_GROUPS_PKG dependencies on AHL_ITEM_GROUPS_TL

Line 97: insert into AHL_ITEM_GROUPS_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into AHL_ITEM_GROUPS_TL (
98: ITEM_GROUP_ID,
99: LAST_UPDATE_DATE,
100: LAST_UPDATED_BY,
101: CREATION_DATE,

Line 121: from AHL_ITEM_GROUPS_TL T

117: from FND_LANGUAGES L
118: where L.INSTALLED_FLAG in ('I', 'B')
119: and not exists
120: (select NULL
121: from AHL_ITEM_GROUPS_TL T
122: where T.ITEM_GROUP_ID = X_ITEM_GROUP_ID
123: and T.LANGUAGE = L.LANGUAGE_CODE);
124:
125: open c;

Line 190: from AHL_ITEM_GROUPS_TL

186:
187: cursor c1 is select
188: DESCRIPTION,
189: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
190: from AHL_ITEM_GROUPS_TL
191: where ITEM_GROUP_ID = X_ITEM_GROUP_ID
192: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
193: for update of ITEM_GROUP_ID nowait;
194: begin

Line 324: update AHL_ITEM_GROUPS_TL set

320: if (sql%notfound) then
321: raise no_data_found;
322: end if;
323:
324: update AHL_ITEM_GROUPS_TL set
325: DESCRIPTION = X_DESCRIPTION,
326: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
327: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
328: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 342: delete from AHL_ITEM_GROUPS_TL

338: procedure DELETE_ROW (
339: X_ITEM_GROUP_ID in NUMBER
340: ) is
341: begin
342: delete from AHL_ITEM_GROUPS_TL
343: where ITEM_GROUP_ID = X_ITEM_GROUP_ID;
344:
345: if (sql%notfound) then
346: raise no_data_found;

Line 360: delete from AHL_ITEM_GROUPS_TL T

356:
357: procedure ADD_LANGUAGE
358: is
359: begin
360: delete from AHL_ITEM_GROUPS_TL T
361: where not exists
362: (select NULL
363: from AHL_ITEM_GROUPS_B B
364: where B.ITEM_GROUP_ID = T.ITEM_GROUP_ID

Line 367: update AHL_ITEM_GROUPS_TL T set (

363: from AHL_ITEM_GROUPS_B B
364: where B.ITEM_GROUP_ID = T.ITEM_GROUP_ID
365: );
366:
367: update AHL_ITEM_GROUPS_TL T set (
368: DESCRIPTION
369: ) = (select
370: B.DESCRIPTION
371: from AHL_ITEM_GROUPS_TL B

Line 371: from AHL_ITEM_GROUPS_TL B

367: update AHL_ITEM_GROUPS_TL T set (
368: DESCRIPTION
369: ) = (select
370: B.DESCRIPTION
371: from AHL_ITEM_GROUPS_TL B
372: where B.ITEM_GROUP_ID = T.ITEM_GROUP_ID
373: and B.LANGUAGE = T.SOURCE_LANG)
374: where (
375: T.ITEM_GROUP_ID,

Line 380: from AHL_ITEM_GROUPS_TL SUBB, AHL_ITEM_GROUPS_TL SUBT

376: T.LANGUAGE
377: ) in (select
378: SUBT.ITEM_GROUP_ID,
379: SUBT.LANGUAGE
380: from AHL_ITEM_GROUPS_TL SUBB, AHL_ITEM_GROUPS_TL SUBT
381: where SUBB.ITEM_GROUP_ID = SUBT.ITEM_GROUP_ID
382: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
383: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
384: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 388: insert into AHL_ITEM_GROUPS_TL (

384: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
385: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
386: ));
387:
388: insert into AHL_ITEM_GROUPS_TL (
389: ITEM_GROUP_ID,
390: LAST_UPDATE_DATE,
391: LAST_UPDATED_BY,
392: CREATION_DATE,

Line 408: from AHL_ITEM_GROUPS_TL B, FND_LANGUAGES L

404: B.LAST_UPDATE_LOGIN,
405: B.DESCRIPTION,
406: L.LANGUAGE_CODE,
407: B.SOURCE_LANG
408: from AHL_ITEM_GROUPS_TL B, FND_LANGUAGES L
409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL

Line 413: from AHL_ITEM_GROUPS_TL T

409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL
413: from AHL_ITEM_GROUPS_TL T
414: where T.ITEM_GROUP_ID = B.ITEM_GROUP_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;
417: