APPS.AHL_DOC_TITLE_ASSOS_PKG dependencies on AHL_DOC_TITLE_ASSOS_TL

Line 110: insert into AHL_DOC_TITLE_ASSOS_TL (

106: X_LAST_UPDATED_BY,
107: X_LAST_UPDATE_LOGIN
108: );
109:
110: insert into AHL_DOC_TITLE_ASSOS_TL (
111: FIGURE,
112: NOTE,
113: LAST_UPDATED_BY,
114: CREATION_DATE,

Line 144: from AHL_DOC_TITLE_ASSOS_TL T

140: from FND_LANGUAGES L
141: where L.INSTALLED_FLAG in ('I', 'B')
142: and not exists
143: (select NULL
144: from AHL_DOC_TITLE_ASSOS_TL T
145: where T.DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID
146: and T.LANGUAGE = L.LANGUAGE_CODE);
147:
148: open c;

Line 229: from AHL_DOC_TITLE_ASSOS_TL

225: FIGURE,
226: PAGE,
227: NOTE,
228: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
229: from AHL_DOC_TITLE_ASSOS_TL
230: where DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID
231: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
232: for update of DOC_TITLE_ASSO_ID nowait;
233: begin

Line 389: update AHL_DOC_TITLE_ASSOS_TL set

385: if (sql%notfound) then
386: raise no_data_found;
387: end if;
388:
389: update AHL_DOC_TITLE_ASSOS_TL set
390: CHAPTER = X_CHAPTER,
391: SECTION = X_SECTION,
392: SUBJECT = X_SUBJECT,
393: FIGURE = X_FIGURE,

Line 412: delete from AHL_DOC_TITLE_ASSOS_TL

408: procedure DELETE_ROW (
409: X_DOC_TITLE_ASSO_ID in NUMBER
410: ) is
411: begin
412: delete from AHL_DOC_TITLE_ASSOS_TL
413: where DOC_TITLE_ASSO_ID = X_DOC_TITLE_ASSO_ID;
414:
415: if (sql%notfound) then
416: raise no_data_found;

Line 430: delete from AHL_DOC_TITLE_ASSOS_TL T

426:
427: procedure ADD_LANGUAGE
428: is
429: begin
430: delete from AHL_DOC_TITLE_ASSOS_TL T
431: where not exists
432: (select NULL
433: from AHL_DOC_TITLE_ASSOS_B B
434: where B.DOC_TITLE_ASSO_ID = T.DOC_TITLE_ASSO_ID

Line 437: update AHL_DOC_TITLE_ASSOS_TL T set (

433: from AHL_DOC_TITLE_ASSOS_B B
434: where B.DOC_TITLE_ASSO_ID = T.DOC_TITLE_ASSO_ID
435: );
436:
437: update AHL_DOC_TITLE_ASSOS_TL T set (
438: CHAPTER,
439: SECTION,
440: SUBJECT,
441: FIGURE,

Line 451: from AHL_DOC_TITLE_ASSOS_TL B

447: B.SUBJECT,
448: B.FIGURE,
449: B.PAGE,
450: B.NOTE
451: from AHL_DOC_TITLE_ASSOS_TL B
452: where B.DOC_TITLE_ASSO_ID = T.DOC_TITLE_ASSO_ID
453: and B.LANGUAGE = T.SOURCE_LANG)
454: where (
455: T.DOC_TITLE_ASSO_ID,

Line 460: from AHL_DOC_TITLE_ASSOS_TL SUBB, AHL_DOC_TITLE_ASSOS_TL SUBT

456: T.LANGUAGE
457: ) in (select
458: SUBT.DOC_TITLE_ASSO_ID,
459: SUBT.LANGUAGE
460: from AHL_DOC_TITLE_ASSOS_TL SUBB, AHL_DOC_TITLE_ASSOS_TL SUBT
461: where SUBB.DOC_TITLE_ASSO_ID = SUBT.DOC_TITLE_ASSO_ID
462: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
463: and (SUBB.CHAPTER <> SUBT.CHAPTER
464: or (SUBB.CHAPTER is null and SUBT.CHAPTER is not null)

Line 483: insert into AHL_DOC_TITLE_ASSOS_TL (

479: or (SUBB.NOTE is null and SUBT.NOTE is not null)
480: or (SUBB.NOTE is not null and SUBT.NOTE is null)
481: ));
482:
483: insert into AHL_DOC_TITLE_ASSOS_TL (
484: FIGURE,
485: NOTE,
486: LAST_UPDATED_BY,
487: CREATION_DATE,

Line 513: from AHL_DOC_TITLE_ASSOS_TL B, FND_LANGUAGES L

509: B.DOC_TITLE_ASSO_ID,
510: B.LAST_UPDATE_DATE,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from AHL_DOC_TITLE_ASSOS_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from AHL_DOC_TITLE_ASSOS_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from AHL_DOC_TITLE_ASSOS_TL T
519: where T.DOC_TITLE_ASSO_ID = B.DOC_TITLE_ASSO_ID
520: and T.LANGUAGE = L.LANGUAGE_CODE);
521: end ADD_LANGUAGE;
522:

Line 664: update AHl_DOC_TITLE_ASSOS_TL set

660: X_NOTE in VARCHAR2,
661: X_OWNER in VARCHAR2
662: ) is
663: begin
664: update AHl_DOC_TITLE_ASSOS_TL set
665: chapter = nvl(X_CHAPTER, chapter),
666: section = nvl(X_SECTION, section),
667: subject = nvl(X_SUBJECT, subject),
668: figure = nvl(X_FIGURE, figure),