APPS.AHL_FLEET_HEADERS_PKG dependencies on AHL_FLEET_HEADERS_TL

Line 102: insert into AHL_FLEET_HEADERS_TL (

98: X_LAST_UPDATED_BY,
99: X_LAST_UPDATE_LOGIN
100: );
101:
102: insert into AHL_FLEET_HEADERS_TL (
103: LAST_UPDATE_LOGIN,
104: CREATED_BY,
105: CREATION_DATE,
106: LAST_UPDATED_BY,

Line 126: from AHL_FLEET_HEADERS_TL T

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

Line 199: from AHL_FLEET_HEADERS_TL

195:
196: cursor c1 is select
197: DESCRIPTION,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from AHL_FLEET_HEADERS_TL
200: where FLEET_HEADER_ID = X_FLEET_HEADER_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of FLEET_HEADER_ID nowait;
203: begin

Line 340: update AHL_FLEET_HEADERS_TL set

336: if (sql%notfound) then
337: raise no_data_found;
338: end if;
339:
340: update AHL_FLEET_HEADERS_TL set
341: DESCRIPTION = X_DESCRIPTION,
342: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
343: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
344: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 358: delete from AHL_FLEET_HEADERS_TL

354: procedure DELETE_ROW (
355: X_FLEET_HEADER_ID in NUMBER
356: ) is
357: begin
358: delete from AHL_FLEET_HEADERS_TL
359: where FLEET_HEADER_ID = X_FLEET_HEADER_ID;
360:
361: if (sql%notfound) then
362: raise no_data_found;

Line 376: delete from AHL_FLEET_HEADERS_TL T

372:
373: procedure ADD_LANGUAGE
374: is
375: begin
376: delete from AHL_FLEET_HEADERS_TL T
377: where not exists
378: (select NULL
379: from AHL_FLEET_HEADERS_B B
380: where B.FLEET_HEADER_ID = T.FLEET_HEADER_ID

Line 383: update AHL_FLEET_HEADERS_TL T set (

379: from AHL_FLEET_HEADERS_B B
380: where B.FLEET_HEADER_ID = T.FLEET_HEADER_ID
381: );
382:
383: update AHL_FLEET_HEADERS_TL T set (
384: DESCRIPTION
385: ) = (select
386: B.DESCRIPTION
387: from AHL_FLEET_HEADERS_TL B

Line 387: from AHL_FLEET_HEADERS_TL B

383: update AHL_FLEET_HEADERS_TL T set (
384: DESCRIPTION
385: ) = (select
386: B.DESCRIPTION
387: from AHL_FLEET_HEADERS_TL B
388: where B.FLEET_HEADER_ID = T.FLEET_HEADER_ID
389: and B.LANGUAGE = T.SOURCE_LANG)
390: where (
391: T.FLEET_HEADER_ID,

Line 396: from AHL_FLEET_HEADERS_TL SUBB, AHL_FLEET_HEADERS_TL SUBT

392: T.LANGUAGE
393: ) in (select
394: SUBT.FLEET_HEADER_ID,
395: SUBT.LANGUAGE
396: from AHL_FLEET_HEADERS_TL SUBB, AHL_FLEET_HEADERS_TL SUBT
397: where SUBB.FLEET_HEADER_ID = SUBT.FLEET_HEADER_ID
398: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
399: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
400: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 404: insert into AHL_FLEET_HEADERS_TL (

400: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
401: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
402: ));
403:
404: insert into AHL_FLEET_HEADERS_TL (
405: LAST_UPDATE_LOGIN,
406: CREATED_BY,
407: CREATION_DATE,
408: LAST_UPDATED_BY,

Line 424: from AHL_FLEET_HEADERS_TL B, FND_LANGUAGES L

420: B.DESCRIPTION,
421: B.FLEET_HEADER_ID,
422: L.LANGUAGE_CODE,
423: B.SOURCE_LANG
424: from AHL_FLEET_HEADERS_TL B, FND_LANGUAGES L
425: where L.INSTALLED_FLAG in ('I', 'B')
426: and B.LANGUAGE = userenv('LANG')
427: and not exists
428: (select NULL

Line 429: from AHL_FLEET_HEADERS_TL T

425: where L.INSTALLED_FLAG in ('I', 'B')
426: and B.LANGUAGE = userenv('LANG')
427: and not exists
428: (select NULL
429: from AHL_FLEET_HEADERS_TL T
430: where T.FLEET_HEADER_ID = B.FLEET_HEADER_ID
431: and T.LANGUAGE = L.LANGUAGE_CODE);
432: end ADD_LANGUAGE;
433: