APPS.AHL_ITEM_ASSOCIATIONS_H_PKG dependencies on AHL_ITEM_ASSOCIATIONS_TL_H

Line 123: insert into AHL_ITEM_ASSOCIATIONS_TL_H (

119: X_LAST_UPDATED_BY,
120: X_LAST_UPDATE_LOGIN
121: );
122:
123: insert into AHL_ITEM_ASSOCIATIONS_TL_H (
124: ITEM_ASSOCIATION_H_ID,
125: LAST_UPDATE_DATE,
126: INTERCHANGE_REASON,
127: LAST_UPDATED_BY,

Line 147: from AHL_ITEM_ASSOCIATIONS_TL_H T

143: from FND_LANGUAGES L
144: where L.INSTALLED_FLAG in ('I', 'B')
145: and not exists
146: (select NULL
147: from AHL_ITEM_ASSOCIATIONS_TL_H T
148: where T.ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID
149: and T.LANGUAGE = L.LANGUAGE_CODE);
150:
151: open c;

Line 234: from AHL_ITEM_ASSOCIATIONS_TL_H

230:
231: cursor c1 is select
232: INTERCHANGE_REASON,
233: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
234: from AHL_ITEM_ASSOCIATIONS_TL_H
235: where ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID
236: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
237: for update of ITEM_ASSOCIATION_H_ID nowait;
238: begin

Line 400: update AHL_ITEM_ASSOCIATIONS_TL_H set

396: if (sql%notfound) then
397: raise no_data_found;
398: end if;
399:
400: update AHL_ITEM_ASSOCIATIONS_TL_H set
401: INTERCHANGE_REASON = X_INTERCHANGE_REASON,
402: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
403: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
404: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 418: delete from AHL_ITEM_ASSOCIATIONS_TL_H

414: procedure DELETE_ROW (
415: X_ITEM_ASSOCIATION_H_ID in NUMBER
416: ) is
417: begin
418: delete from AHL_ITEM_ASSOCIATIONS_TL_H
419: where ITEM_ASSOCIATION_H_ID = X_ITEM_ASSOCIATION_H_ID;
420:
421: if (sql%notfound) then
422: raise no_data_found;

Line 436: delete from AHL_ITEM_ASSOCIATIONS_TL_H T

432:
433: procedure ADD_LANGUAGE
434: is
435: begin
436: delete from AHL_ITEM_ASSOCIATIONS_TL_H T
437: where not exists
438: (select NULL
439: from AHL_ITEM_ASSOCIATIONS_B_H B
440: where B.ITEM_ASSOCIATION_H_ID = T.ITEM_ASSOCIATION_H_ID

Line 443: update AHL_ITEM_ASSOCIATIONS_TL_H T set (

439: from AHL_ITEM_ASSOCIATIONS_B_H B
440: where B.ITEM_ASSOCIATION_H_ID = T.ITEM_ASSOCIATION_H_ID
441: );
442:
443: update AHL_ITEM_ASSOCIATIONS_TL_H T set (
444: INTERCHANGE_REASON
445: ) = (select
446: B.INTERCHANGE_REASON
447: from AHL_ITEM_ASSOCIATIONS_TL_H B

Line 447: from AHL_ITEM_ASSOCIATIONS_TL_H B

443: update AHL_ITEM_ASSOCIATIONS_TL_H T set (
444: INTERCHANGE_REASON
445: ) = (select
446: B.INTERCHANGE_REASON
447: from AHL_ITEM_ASSOCIATIONS_TL_H B
448: where B.ITEM_ASSOCIATION_H_ID = T.ITEM_ASSOCIATION_H_ID
449: and B.LANGUAGE = T.SOURCE_LANG)
450: where (
451: T.ITEM_ASSOCIATION_H_ID,

Line 456: from AHL_ITEM_ASSOCIATIONS_TL_H SUBB, AHL_ITEM_ASSOCIATIONS_TL_H SUBT

452: T.LANGUAGE
453: ) in (select
454: SUBT.ITEM_ASSOCIATION_H_ID,
455: SUBT.LANGUAGE
456: from AHL_ITEM_ASSOCIATIONS_TL_H SUBB, AHL_ITEM_ASSOCIATIONS_TL_H SUBT
457: where SUBB.ITEM_ASSOCIATION_H_ID = SUBT.ITEM_ASSOCIATION_H_ID
458: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
459: and (SUBB.INTERCHANGE_REASON <> SUBT.INTERCHANGE_REASON
460: or (SUBB.INTERCHANGE_REASON is null and SUBT.INTERCHANGE_REASON is not null)

Line 464: insert into AHL_ITEM_ASSOCIATIONS_TL_H (

460: or (SUBB.INTERCHANGE_REASON is null and SUBT.INTERCHANGE_REASON is not null)
461: or (SUBB.INTERCHANGE_REASON is not null and SUBT.INTERCHANGE_REASON is null)
462: ));
463:
464: insert into AHL_ITEM_ASSOCIATIONS_TL_H (
465: ITEM_ASSOCIATION_H_ID,
466: LAST_UPDATE_DATE,
467: INTERCHANGE_REASON,
468: LAST_UPDATED_BY,

Line 484: from AHL_ITEM_ASSOCIATIONS_TL_H B, FND_LANGUAGES L

480: B.CREATED_BY,
481: B.LAST_UPDATE_LOGIN,
482: L.LANGUAGE_CODE,
483: B.SOURCE_LANG
484: from AHL_ITEM_ASSOCIATIONS_TL_H B, FND_LANGUAGES L
485: where L.INSTALLED_FLAG in ('I', 'B')
486: and B.LANGUAGE = userenv('LANG')
487: and not exists
488: (select NULL

Line 489: from AHL_ITEM_ASSOCIATIONS_TL_H T

485: where L.INSTALLED_FLAG in ('I', 'B')
486: and B.LANGUAGE = userenv('LANG')
487: and not exists
488: (select NULL
489: from AHL_ITEM_ASSOCIATIONS_TL_H T
490: where T.ITEM_ASSOCIATION_H_ID = B.ITEM_ASSOCIATION_H_ID
491: and T.LANGUAGE = L.LANGUAGE_CODE);
492: end ADD_LANGUAGE;
493: