APPS.AHL_ITEM_ASSOCIATIONS_PKG dependencies on AHL_ITEM_ASSOCIATIONS_TL

Line 114: insert into AHL_ITEM_ASSOCIATIONS_TL (

110: X_LAST_UPDATED_BY,
111: X_LAST_UPDATE_LOGIN
112: );
113:
114: insert into AHL_ITEM_ASSOCIATIONS_TL (
115: ITEM_ASSOCIATION_ID,
116: LAST_UPDATE_DATE,
117: LAST_UPDATED_BY,
118: CREATION_DATE,

Line 138: from AHL_ITEM_ASSOCIATIONS_TL T

134: from FND_LANGUAGES L
135: where L.INSTALLED_FLAG in ('I', 'B')
136: and not exists
137: (select NULL
138: from AHL_ITEM_ASSOCIATIONS_TL T
139: where T.ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID
140: and T.LANGUAGE = L.LANGUAGE_CODE);
141:
142: open c;

Line 219: from AHL_ITEM_ASSOCIATIONS_TL

215:
216: cursor c1 is select
217: INTERCHANGE_REASON,
218: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
219: from AHL_ITEM_ASSOCIATIONS_TL
220: where ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID
221: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
222: for update of ITEM_ASSOCIATION_ID nowait;
223: begin

Line 375: update AHL_ITEM_ASSOCIATIONS_TL set

371: if (sql%notfound) then
372: raise no_data_found;
373: end if;
374:
375: update AHL_ITEM_ASSOCIATIONS_TL set
376: INTERCHANGE_REASON = X_INTERCHANGE_REASON,
377: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
378: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
379: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 393: delete from AHL_ITEM_ASSOCIATIONS_TL

389: procedure DELETE_ROW (
390: X_ITEM_ASSOCIATION_ID in NUMBER
391: ) is
392: begin
393: delete from AHL_ITEM_ASSOCIATIONS_TL
394: where ITEM_ASSOCIATION_ID = X_ITEM_ASSOCIATION_ID;
395:
396: if (sql%notfound) then
397: raise no_data_found;

Line 411: delete from AHL_ITEM_ASSOCIATIONS_TL T

407:
408: procedure ADD_LANGUAGE
409: is
410: begin
411: delete from AHL_ITEM_ASSOCIATIONS_TL T
412: where not exists
413: (select NULL
414: from AHL_ITEM_ASSOCIATIONS_B B
415: where B.ITEM_ASSOCIATION_ID = T.ITEM_ASSOCIATION_ID

Line 418: update AHL_ITEM_ASSOCIATIONS_TL T set (

414: from AHL_ITEM_ASSOCIATIONS_B B
415: where B.ITEM_ASSOCIATION_ID = T.ITEM_ASSOCIATION_ID
416: );
417:
418: update AHL_ITEM_ASSOCIATIONS_TL T set (
419: INTERCHANGE_REASON
420: ) = (select
421: B.INTERCHANGE_REASON
422: from AHL_ITEM_ASSOCIATIONS_TL B

Line 422: from AHL_ITEM_ASSOCIATIONS_TL B

418: update AHL_ITEM_ASSOCIATIONS_TL T set (
419: INTERCHANGE_REASON
420: ) = (select
421: B.INTERCHANGE_REASON
422: from AHL_ITEM_ASSOCIATIONS_TL B
423: where B.ITEM_ASSOCIATION_ID = T.ITEM_ASSOCIATION_ID
424: and B.LANGUAGE = T.SOURCE_LANG)
425: where (
426: T.ITEM_ASSOCIATION_ID,

Line 431: from AHL_ITEM_ASSOCIATIONS_TL SUBB, AHL_ITEM_ASSOCIATIONS_TL SUBT

427: T.LANGUAGE
428: ) in (select
429: SUBT.ITEM_ASSOCIATION_ID,
430: SUBT.LANGUAGE
431: from AHL_ITEM_ASSOCIATIONS_TL SUBB, AHL_ITEM_ASSOCIATIONS_TL SUBT
432: where SUBB.ITEM_ASSOCIATION_ID = SUBT.ITEM_ASSOCIATION_ID
433: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
434: and (SUBB.INTERCHANGE_REASON <> SUBT.INTERCHANGE_REASON
435: or (SUBB.INTERCHANGE_REASON is null and SUBT.INTERCHANGE_REASON is not null)

Line 439: insert into AHL_ITEM_ASSOCIATIONS_TL (

435: or (SUBB.INTERCHANGE_REASON is null and SUBT.INTERCHANGE_REASON is not null)
436: or (SUBB.INTERCHANGE_REASON is not null and SUBT.INTERCHANGE_REASON is null)
437: ));
438:
439: insert into AHL_ITEM_ASSOCIATIONS_TL (
440: ITEM_ASSOCIATION_ID,
441: LAST_UPDATE_DATE,
442: LAST_UPDATED_BY,
443: CREATION_DATE,

Line 459: from AHL_ITEM_ASSOCIATIONS_TL B, FND_LANGUAGES L

455: B.LAST_UPDATE_LOGIN,
456: B.INTERCHANGE_REASON,
457: L.LANGUAGE_CODE,
458: B.SOURCE_LANG
459: from AHL_ITEM_ASSOCIATIONS_TL B, FND_LANGUAGES L
460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL

Line 464: from AHL_ITEM_ASSOCIATIONS_TL T

460: where L.INSTALLED_FLAG in ('I', 'B')
461: and B.LANGUAGE = userenv('LANG')
462: and not exists
463: (select NULL
464: from AHL_ITEM_ASSOCIATIONS_TL T
465: where T.ITEM_ASSOCIATION_ID = B.ITEM_ASSOCIATION_ID
466: and T.LANGUAGE = L.LANGUAGE_CODE);
467: end ADD_LANGUAGE;
468: