APPS.AHL_VWP_STAGES_PKG dependencies on AHL_VWP_STAGES_TL

Line 93: insert into AHL_VWP_STAGES_TL (

89: X_LAST_UPDATED_BY,
90: X_LAST_UPDATE_LOGIN
91: );
92:
93: insert into AHL_VWP_STAGES_TL (
94: STAGE_ID,
95: LAST_UPDATE_DATE,
96: LAST_UPDATED_BY,
97: CREATION_DATE,

Line 117: from AHL_VWP_STAGES_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from AHL_VWP_STAGES_TL T
118: where T.STAGE_ID = X_STAGE_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from AHL_VWP_STAGES_TL

180:
181: cursor c1 is select
182: STAGE_NAME,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from AHL_VWP_STAGES_TL
185: where STAGE_ID = X_STAGE_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of STAGE_ID nowait;
188: begin

Line 314: update AHL_VWP_STAGES_TL set

310: if (sql%notfound) then
311: raise no_data_found;
312: end if;
313:
314: update AHL_VWP_STAGES_TL set
315: STAGE_NAME = X_STAGE_NAME,
316: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
317: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
318: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 332: delete from AHL_VWP_STAGES_TL

328: procedure DELETE_ROW (
329: X_STAGE_ID in NUMBER
330: ) is
331: begin
332: delete from AHL_VWP_STAGES_TL
333: where STAGE_ID = X_STAGE_ID;
334:
335: if (sql%notfound) then
336: raise no_data_found;

Line 350: delete from AHL_VWP_STAGES_TL T

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

Line 357: update AHL_VWP_STAGES_TL T set (

353: from AHL_VWP_STAGES_B B
354: where B.STAGE_ID = T.STAGE_ID
355: );
356:
357: update AHL_VWP_STAGES_TL T set (
358: STAGE_NAME
359: ) = (select
360: B.STAGE_NAME
361: from AHL_VWP_STAGES_TL B

Line 361: from AHL_VWP_STAGES_TL B

357: update AHL_VWP_STAGES_TL T set (
358: STAGE_NAME
359: ) = (select
360: B.STAGE_NAME
361: from AHL_VWP_STAGES_TL B
362: where B.STAGE_ID = T.STAGE_ID
363: and B.LANGUAGE = T.SOURCE_LANG)
364: where (
365: T.STAGE_ID,

Line 370: from AHL_VWP_STAGES_TL SUBB, AHL_VWP_STAGES_TL SUBT

366: T.LANGUAGE
367: ) in (select
368: SUBT.STAGE_ID,
369: SUBT.LANGUAGE
370: from AHL_VWP_STAGES_TL SUBB, AHL_VWP_STAGES_TL SUBT
371: where SUBB.STAGE_ID = SUBT.STAGE_ID
372: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
373: and (SUBB.STAGE_NAME <> SUBT.STAGE_NAME
374: or (SUBB.STAGE_NAME is null and SUBT.STAGE_NAME is not null)

Line 378: insert into AHL_VWP_STAGES_TL (

374: or (SUBB.STAGE_NAME is null and SUBT.STAGE_NAME is not null)
375: or (SUBB.STAGE_NAME is not null and SUBT.STAGE_NAME is null)
376: ));
377:
378: insert into AHL_VWP_STAGES_TL (
379: STAGE_ID,
380: LAST_UPDATE_DATE,
381: LAST_UPDATED_BY,
382: CREATION_DATE,

Line 398: from AHL_VWP_STAGES_TL B, FND_LANGUAGES L

394: B.LAST_UPDATE_LOGIN,
395: B.STAGE_NAME,
396: L.LANGUAGE_CODE,
397: B.SOURCE_LANG
398: from AHL_VWP_STAGES_TL B, FND_LANGUAGES L
399: where L.INSTALLED_FLAG in ('I', 'B')
400: and B.LANGUAGE = userenv('LANG')
401: and not exists
402: (select NULL

Line 403: from AHL_VWP_STAGES_TL T

399: where L.INSTALLED_FLAG in ('I', 'B')
400: and B.LANGUAGE = userenv('LANG')
401: and not exists
402: (select NULL
403: from AHL_VWP_STAGES_TL T
404: where T.STAGE_ID = B.STAGE_ID
405: and T.LANGUAGE = L.LANGUAGE_CODE);
406: end ADD_LANGUAGE;
407: