APPS.AHL_DOC_FILE_ASSOC_PKG dependencies on AHL_DOC_FILE_ASSOC_TL

Line 99: insert into AHL_DOC_FILE_ASSOC_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into AHL_DOC_FILE_ASSOC_TL (
100: ASSOCIATION_ID,
101: FILE_DESC,
102: SECURITY_GROUP_ID,
103: LAST_UPDATE_LOGIN,

Line 125: from AHL_DOC_FILE_ASSOC_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from AHL_DOC_FILE_ASSOC_TL T
126: where T.ASSOCIATION_ID = X_ASSOCIATION_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 196: from AHL_DOC_FILE_ASSOC_TL

192:
193: cursor c1 is select
194: FILE_DESC,
195: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
196: from AHL_DOC_FILE_ASSOC_TL
197: where ASSOCIATION_ID = X_ASSOCIATION_ID
198: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
199: for update of ASSOCIATION_ID nowait;
200: begin

Line 335: update AHL_DOC_FILE_ASSOC_TL set

331: if (sql%notfound) then
332: raise no_data_found;
333: end if;
334:
335: update AHL_DOC_FILE_ASSOC_TL set
336: FILE_DESC = X_FILE_DESC,
337: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
338: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
339: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 353: delete from AHL_DOC_FILE_ASSOC_TL

349: procedure DELETE_ROW (
350: X_ASSOCIATION_ID in NUMBER
351: ) is
352: begin
353: delete from AHL_DOC_FILE_ASSOC_TL
354: where ASSOCIATION_ID = X_ASSOCIATION_ID;
355:
356: if (sql%notfound) then
357: raise no_data_found;

Line 371: delete from AHL_DOC_FILE_ASSOC_TL T

367:
368: procedure ADD_LANGUAGE
369: is
370: begin
371: delete from AHL_DOC_FILE_ASSOC_TL T
372: where not exists
373: (select NULL
374: from AHL_DOC_FILE_ASSOC_B B
375: where B.ASSOCIATION_ID = T.ASSOCIATION_ID

Line 378: update AHL_DOC_FILE_ASSOC_TL T set (

374: from AHL_DOC_FILE_ASSOC_B B
375: where B.ASSOCIATION_ID = T.ASSOCIATION_ID
376: );
377:
378: update AHL_DOC_FILE_ASSOC_TL T set (
379: FILE_DESC
380: ) = (select
381: B.FILE_DESC
382: from AHL_DOC_FILE_ASSOC_TL B

Line 382: from AHL_DOC_FILE_ASSOC_TL B

378: update AHL_DOC_FILE_ASSOC_TL T set (
379: FILE_DESC
380: ) = (select
381: B.FILE_DESC
382: from AHL_DOC_FILE_ASSOC_TL B
383: where B.ASSOCIATION_ID = T.ASSOCIATION_ID
384: and B.LANGUAGE = T.SOURCE_LANG)
385: where (
386: T.ASSOCIATION_ID,

Line 391: from AHL_DOC_FILE_ASSOC_TL SUBB, AHL_DOC_FILE_ASSOC_TL SUBT

387: T.LANGUAGE
388: ) in (select
389: SUBT.ASSOCIATION_ID,
390: SUBT.LANGUAGE
391: from AHL_DOC_FILE_ASSOC_TL SUBB, AHL_DOC_FILE_ASSOC_TL SUBT
392: where SUBB.ASSOCIATION_ID = SUBT.ASSOCIATION_ID
393: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
394: and (SUBB.FILE_DESC <> SUBT.FILE_DESC
395: or (SUBB.FILE_DESC is null and SUBT.FILE_DESC is not null)

Line 399: insert into AHL_DOC_FILE_ASSOC_TL (

395: or (SUBB.FILE_DESC is null and SUBT.FILE_DESC is not null)
396: or (SUBB.FILE_DESC is not null and SUBT.FILE_DESC is null)
397: ));
398:
399: insert into AHL_DOC_FILE_ASSOC_TL (
400: ASSOCIATION_ID,
401: FILE_DESC,
402: SECURITY_GROUP_ID,
403: LAST_UPDATE_LOGIN,

Line 421: from AHL_DOC_FILE_ASSOC_TL B, FND_LANGUAGES L

417: B.CREATION_DATE,
418: B.CREATED_BY,
419: L.LANGUAGE_CODE,
420: B.SOURCE_LANG
421: from AHL_DOC_FILE_ASSOC_TL B, FND_LANGUAGES L
422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL

Line 426: from AHL_DOC_FILE_ASSOC_TL T

422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL
426: from AHL_DOC_FILE_ASSOC_TL T
427: where T.ASSOCIATION_ID = B.ASSOCIATION_ID
428: and T.LANGUAGE = L.LANGUAGE_CODE);
429: end ADD_LANGUAGE;
430: