APPS.AHL_MC_HEADERS_PKG dependencies on AHL_MC_HEADERS_TL

Line 105: insert into AHL_MC_HEADERS_TL (

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

Line 131: from AHL_MC_HEADERS_TL T

127: from FND_LANGUAGES L
128: where L.INSTALLED_FLAG in ('I', 'B')
129: and not exists
130: (select NULL
131: from AHL_MC_HEADERS_TL T
132: where T.MC_HEADER_ID = X_MC_HEADER_ID
133: and T.LANGUAGE = L.LANGUAGE_CODE);
134:
135: open c;

Line 206: from AHL_MC_HEADERS_TL

202:
203: cursor c1 is select
204: DESCRIPTION,
205: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
206: from AHL_MC_HEADERS_TL
207: where MC_HEADER_ID = X_MC_HEADER_ID
208: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
209: for update of MC_HEADER_ID nowait;
210: begin

Line 351: update AHL_MC_HEADERS_TL set

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

Line 369: delete from AHL_MC_HEADERS_TL

365: procedure DELETE_ROW (
366: X_MC_HEADER_ID in NUMBER
367: ) is
368: begin
369: delete from AHL_MC_HEADERS_TL
370: where MC_HEADER_ID = X_MC_HEADER_ID;
371:
372: if (sql%notfound) then
373: raise no_data_found;

Line 387: delete from AHL_MC_HEADERS_TL T

383:
384: procedure ADD_LANGUAGE
385: is
386: begin
387: delete from AHL_MC_HEADERS_TL T
388: where not exists
389: (select NULL
390: from AHL_MC_HEADERS_B B
391: where B.MC_HEADER_ID = T.MC_HEADER_ID

Line 394: update AHL_MC_HEADERS_TL T set (

390: from AHL_MC_HEADERS_B B
391: where B.MC_HEADER_ID = T.MC_HEADER_ID
392: );
393:
394: update AHL_MC_HEADERS_TL T set (
395: DESCRIPTION
396: ) = (select
397: B.DESCRIPTION
398: from AHL_MC_HEADERS_TL B

Line 398: from AHL_MC_HEADERS_TL B

394: update AHL_MC_HEADERS_TL T set (
395: DESCRIPTION
396: ) = (select
397: B.DESCRIPTION
398: from AHL_MC_HEADERS_TL B
399: where B.MC_HEADER_ID = T.MC_HEADER_ID
400: and B.LANGUAGE = T.SOURCE_LANG)
401: where (
402: T.MC_HEADER_ID,

Line 407: from AHL_MC_HEADERS_TL SUBB, AHL_MC_HEADERS_TL SUBT

403: T.LANGUAGE
404: ) in (select
405: SUBT.MC_HEADER_ID,
406: SUBT.LANGUAGE
407: from AHL_MC_HEADERS_TL SUBB, AHL_MC_HEADERS_TL SUBT
408: where SUBB.MC_HEADER_ID = SUBT.MC_HEADER_ID
409: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
410: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
411: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 415: insert into AHL_MC_HEADERS_TL (

411: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
412: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
413: ));
414:
415: insert into AHL_MC_HEADERS_TL (
416: MC_HEADER_ID,
417: DESCRIPTION,
418: LAST_UPDATE_DATE,
419: LAST_UPDATED_BY,

Line 437: from AHL_MC_HEADERS_TL B, FND_LANGUAGES L

433: B.LAST_UPDATE_LOGIN,
434: B.SECURITY_GROUP_ID,
435: L.LANGUAGE_CODE,
436: B.SOURCE_LANG
437: from AHL_MC_HEADERS_TL B, FND_LANGUAGES L
438: where L.INSTALLED_FLAG in ('I', 'B')
439: and B.LANGUAGE = userenv('LANG')
440: and not exists
441: (select NULL

Line 442: from AHL_MC_HEADERS_TL T

438: where L.INSTALLED_FLAG in ('I', 'B')
439: and B.LANGUAGE = userenv('LANG')
440: and not exists
441: (select NULL
442: from AHL_MC_HEADERS_TL T
443: where T.MC_HEADER_ID = B.MC_HEADER_ID
444: and T.LANGUAGE = L.LANGUAGE_CODE);
445: end ADD_LANGUAGE;
446:

Line 571: update AHL_MC_HEADERS_TL

567: X_DESCRIPTION in VARCHAR2,
568: X_OWNER in VARCHAR2
569: ) is
570: begin
571: update AHL_MC_HEADERS_TL
572: set
573: DESCRIPTION = NVL(X_DESCRIPTION, DESCRIPTION),
574: SOURCE_LANG = USERENV('LANG'),
575: LAST_UPDATE_DATE = sysdate,