APPS.AHL_MR_HEADERS_PKG dependencies on AHL_MR_HEADERS_TL

Line 177: insert into AHL_MR_HEADERS_TL (

173: FND_PROFILE.VALUE('AHL_APPLN_USAGE')
174: )
175: RETURNING MR_HEADER_ID INTO X_MR_HEADER_ID;
176:
177: insert into AHL_MR_HEADERS_TL (
178: COMMENTS,
179: DESCRIPTION,
180: CREATED_BY,
181: LAST_UPDATE_LOGIN,

Line 203: from AHL_MR_HEADERS_TL T

199: from FND_LANGUAGES L
200: where L.INSTALLED_FLAG in ('I', 'B')
201: and not exists
202: (select NULL
203: from AHL_MR_HEADERS_TL T
204: where T.MR_HEADER_ID = X_MR_HEADER_ID
205: and T.LANGUAGE = L.LANGUAGE_CODE);
206:
207: end INSERT_ROW;

Line 324: update AHL_MR_HEADERS_TL set

320: if sql%rowcount=0 then
321: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
322: FND_MSG_PUB.ADD;
323: else
324: update AHL_MR_HEADERS_TL set
325: DESCRIPTION = X_DESCRIPTION,
326: COMMENTS = X_COMMENTS,
327: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
328: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 340: delete from AHL_MR_HEADERS_TL

336: procedure DELETE_ROW (
337: X_MR_HEADER_ID in NUMBER
338: ) is
339: begin
340: delete from AHL_MR_HEADERS_TL
341: where MR_HEADER_ID = X_MR_HEADER_ID;
342:
343: delete from AHL_MR_HEADERS_B
344: where MR_HEADER_ID = X_MR_HEADER_ID;

Line 350: delete from AHL_MR_HEADERS_TL T

346:
347: procedure ADD_LANGUAGE
348: is
349: begin
350: delete from AHL_MR_HEADERS_TL T
351: where not exists
352: (select NULL
353: from AHL_MR_HEADERS_B B
354: where B.MR_HEADER_ID = T.MR_HEADER_ID

Line 357: update AHL_MR_HEADERS_TL T set (

353: from AHL_MR_HEADERS_B B
354: where B.MR_HEADER_ID = T.MR_HEADER_ID
355: );
356:
357: update AHL_MR_HEADERS_TL T set (
358: DESCRIPTION,
359: COMMENTS
360: ) = (select
361: B.DESCRIPTION,

Line 363: from AHL_MR_HEADERS_TL B

359: COMMENTS
360: ) = (select
361: B.DESCRIPTION,
362: B.COMMENTS
363: from AHL_MR_HEADERS_TL B
364: where B.MR_HEADER_ID = T.MR_HEADER_ID
365: and B.LANGUAGE = T.SOURCE_LANG)
366: where (
367: T.MR_HEADER_ID,

Line 372: from AHL_MR_HEADERS_TL SUBB, AHL_MR_HEADERS_TL SUBT

368: T.LANGUAGE
369: ) in (select
370: SUBT.MR_HEADER_ID,
371: SUBT.LANGUAGE
372: from AHL_MR_HEADERS_TL SUBB, AHL_MR_HEADERS_TL SUBT
373: where SUBB.MR_HEADER_ID = SUBT.MR_HEADER_ID
374: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
375: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
376: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 383: insert into AHL_MR_HEADERS_TL (

379: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
380: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
381: ));
382:
383: insert into AHL_MR_HEADERS_TL (
384: COMMENTS,
385: DESCRIPTION,
386: CREATED_BY,
387: LAST_UPDATE_LOGIN,

Line 405: from AHL_MR_HEADERS_TL B, FND_LANGUAGES L

401: B.CREATION_DATE,
402: B.MR_HEADER_ID,
403: L.LANGUAGE_CODE,
404: B.SOURCE_LANG
405: from AHL_MR_HEADERS_TL B, FND_LANGUAGES L
406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL

Line 410: from AHL_MR_HEADERS_TL T

406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL
410: from AHL_MR_HEADERS_TL T
411: where T.MR_HEADER_ID = B.MR_HEADER_ID
412: and T.LANGUAGE = L.LANGUAGE_CODE);
413: end ADD_LANGUAGE;
414: