APPS.AHL_PC_NODES_PKG dependencies on AHL_PC_NODES_TL

Line 108: insert into AHL_PC_NODES_TL (

104: X_LAST_UPDATED_BY,
105: X_LAST_UPDATE_LOGIN
106: );
107:
108: insert into AHL_PC_NODES_TL (
109: PC_NODE_ID,
110: DESCRIPTION,
111: LAST_UPDATE_DATE,
112: LAST_UPDATED_BY,

Line 134: from AHL_PC_NODES_TL T

130: from FND_LANGUAGES L
131: where L.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from AHL_PC_NODES_TL T
135: where T.PC_NODE_ID = X_PC_NODE_ID
136: and T.LANGUAGE = L.LANGUAGE_CODE);
137:
138: open c;

Line 211: from AHL_PC_NODES_TL

207:
208: cursor c1 is select
209: DESCRIPTION,
210: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
211: from AHL_PC_NODES_TL
212: where PC_NODE_ID = X_PC_NODE_ID
213: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
214: for update of PC_NODE_ID nowait;
215: begin

Line 358: update AHL_PC_NODES_TL set

354: if (sql%notfound) then
355: raise no_data_found;
356: end if;
357:
358: update AHL_PC_NODES_TL set
359: DESCRIPTION = X_DESCRIPTION,
360: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
361: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
362: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 376: delete from AHL_PC_NODES_TL

372: procedure DELETE_ROW (
373: X_PC_NODE_ID in NUMBER
374: ) is
375: begin
376: delete from AHL_PC_NODES_TL
377: where PC_NODE_ID = X_PC_NODE_ID;
378:
379: if (sql%notfound) then
380: raise no_data_found;

Line 394: delete from AHL_PC_NODES_TL T

390:
391: procedure ADD_LANGUAGE
392: is
393: begin
394: delete from AHL_PC_NODES_TL T
395: where not exists
396: (select NULL
397: from AHL_PC_NODES_B B
398: where B.PC_NODE_ID = T.PC_NODE_ID

Line 401: update AHL_PC_NODES_TL T set (

397: from AHL_PC_NODES_B B
398: where B.PC_NODE_ID = T.PC_NODE_ID
399: );
400:
401: update AHL_PC_NODES_TL T set (
402: DESCRIPTION
403: ) = (select
404: B.DESCRIPTION
405: from AHL_PC_NODES_TL B

Line 405: from AHL_PC_NODES_TL B

401: update AHL_PC_NODES_TL T set (
402: DESCRIPTION
403: ) = (select
404: B.DESCRIPTION
405: from AHL_PC_NODES_TL B
406: where B.PC_NODE_ID = T.PC_NODE_ID
407: and B.LANGUAGE = T.SOURCE_LANG)
408: where (
409: T.PC_NODE_ID,

Line 414: from AHL_PC_NODES_TL SUBB, AHL_PC_NODES_TL SUBT

410: T.LANGUAGE
411: ) in (select
412: SUBT.PC_NODE_ID,
413: SUBT.LANGUAGE
414: from AHL_PC_NODES_TL SUBB, AHL_PC_NODES_TL SUBT
415: where SUBB.PC_NODE_ID = SUBT.PC_NODE_ID
416: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
417: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
418: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 422: insert into AHL_PC_NODES_TL (

418: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
419: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
420: ));
421:
422: insert into AHL_PC_NODES_TL (
423: PC_NODE_ID,
424: DESCRIPTION,
425: LAST_UPDATE_DATE,
426: LAST_UPDATED_BY,

Line 444: from AHL_PC_NODES_TL B, FND_LANGUAGES L

440: B.LAST_UPDATE_LOGIN,
441: B.SECURITY_GROUP_ID,
442: L.LANGUAGE_CODE,
443: B.SOURCE_LANG
444: from AHL_PC_NODES_TL B, FND_LANGUAGES L
445: where L.INSTALLED_FLAG in ('I', 'B')
446: and B.LANGUAGE = userenv('LANG')
447: and not exists
448: (select NULL

Line 449: from AHL_PC_NODES_TL T

445: where L.INSTALLED_FLAG in ('I', 'B')
446: and B.LANGUAGE = userenv('LANG')
447: and not exists
448: (select NULL
449: from AHL_PC_NODES_TL T
450: where T.PC_NODE_ID = B.PC_NODE_ID
451: and T.LANGUAGE = L.LANGUAGE_CODE);
452: end ADD_LANGUAGE;
453: