APPS.AHL_VISIT_TYPES_PKG dependencies on AHL_VISIT_TYPES_TL

Line 105: insert into AHL_VISIT_TYPES_TL (

101: X_LAST_UPDATED_BY,
102: X_LAST_UPDATE_LOGIN
103: );
104:
105: insert into AHL_VISIT_TYPES_TL (
106: VISIT_TYPE_ID,
107: DESCRIPTION,
108: LAST_UPDATE_DATE,
109: LAST_UPDATED_BY,

Line 129: from AHL_VISIT_TYPES_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from AHL_VISIT_TYPES_TL T
130: where T.VISIT_TYPE_ID = X_VISIT_TYPE_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 204: from AHL_VISIT_TYPES_TL

200:
201: cursor c1 is select
202: DESCRIPTION,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from AHL_VISIT_TYPES_TL
205: where VISIT_TYPE_ID = X_VISIT_TYPE_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of VISIT_TYPE_ID nowait;
208: begin

Line 349: update AHL_VISIT_TYPES_TL set

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: update AHL_VISIT_TYPES_TL set
350: DESCRIPTION = X_DESCRIPTION,
351: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
352: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
353: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 367: delete from AHL_VISIT_TYPES_TL

363: procedure DELETE_ROW (
364: X_VISIT_TYPE_ID in NUMBER
365: ) is
366: begin
367: delete from AHL_VISIT_TYPES_TL
368: where VISIT_TYPE_ID = X_VISIT_TYPE_ID;
369:
370: if (sql%notfound) then
371: raise no_data_found;

Line 385: delete from AHL_VISIT_TYPES_TL T

381:
382: procedure ADD_LANGUAGE
383: is
384: begin
385: delete from AHL_VISIT_TYPES_TL T
386: where not exists
387: (select NULL
388: from AHL_VISIT_TYPES_B B
389: where B.VISIT_TYPE_ID = T.VISIT_TYPE_ID

Line 392: update AHL_VISIT_TYPES_TL T set (

388: from AHL_VISIT_TYPES_B B
389: where B.VISIT_TYPE_ID = T.VISIT_TYPE_ID
390: );
391:
392: update AHL_VISIT_TYPES_TL T set (
393: DESCRIPTION
394: ) = (select
395: B.DESCRIPTION
396: from AHL_VISIT_TYPES_TL B

Line 396: from AHL_VISIT_TYPES_TL B

392: update AHL_VISIT_TYPES_TL T set (
393: DESCRIPTION
394: ) = (select
395: B.DESCRIPTION
396: from AHL_VISIT_TYPES_TL B
397: where B.VISIT_TYPE_ID = T.VISIT_TYPE_ID
398: and B.LANGUAGE = T.SOURCE_LANG)
399: where (
400: T.VISIT_TYPE_ID,

Line 405: from AHL_VISIT_TYPES_TL SUBB, AHL_VISIT_TYPES_TL SUBT

401: T.LANGUAGE
402: ) in (select
403: SUBT.VISIT_TYPE_ID,
404: SUBT.LANGUAGE
405: from AHL_VISIT_TYPES_TL SUBB, AHL_VISIT_TYPES_TL SUBT
406: where SUBB.VISIT_TYPE_ID = SUBT.VISIT_TYPE_ID
407: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
408: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
409: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 413: insert into AHL_VISIT_TYPES_TL (

409: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
410: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
411: ));
412:
413: insert into AHL_VISIT_TYPES_TL (
414: VISIT_TYPE_ID,
415: DESCRIPTION,
416: LAST_UPDATE_DATE,
417: LAST_UPDATED_BY,

Line 433: from AHL_VISIT_TYPES_TL B, FND_LANGUAGES L

429: B.CREATED_BY,
430: B.LAST_UPDATE_LOGIN,
431: L.LANGUAGE_CODE,
432: B.SOURCE_LANG
433: from AHL_VISIT_TYPES_TL B, FND_LANGUAGES L
434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL

Line 438: from AHL_VISIT_TYPES_TL T

434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL
438: from AHL_VISIT_TYPES_TL T
439: where T.VISIT_TYPE_ID = B.VISIT_TYPE_ID
440: and T.LANGUAGE = L.LANGUAGE_CODE);
441: end ADD_LANGUAGE;
442: