APPS.AHL_VWP_STAGES_PKG dependencies on AHL_VWP_STAGES_TL

Line 111: insert into AHL_VWP_STAGES_TL (

107: X_PREV_STAGE_NUM,
108: X_EARLIEST_START_DATE
109: );
110:
111: insert into AHL_VWP_STAGES_TL (
112: STAGE_ID,
113: LAST_UPDATE_DATE,
114: LAST_UPDATED_BY,
115: CREATION_DATE,

Line 135: from AHL_VWP_STAGES_TL T

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

Line 202: from AHL_VWP_STAGES_TL

198:
199: cursor c1 is select
200: STAGE_NAME,
201: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
202: from AHL_VWP_STAGES_TL
203: where STAGE_ID = X_STAGE_ID
204: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
205: for update of STAGE_ID nowait;
206: begin

Line 346: update AHL_VWP_STAGES_TL set

342: if (sql%notfound) then
343: raise no_data_found;
344: end if;
345:
346: update AHL_VWP_STAGES_TL set
347: STAGE_NAME = X_STAGE_NAME,
348: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
349: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
350: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 364: delete from AHL_VWP_STAGES_TL

360: procedure DELETE_ROW (
361: X_STAGE_ID in NUMBER
362: ) is
363: begin
364: delete from AHL_VWP_STAGES_TL
365: where STAGE_ID = X_STAGE_ID;
366:
367: if (sql%notfound) then
368: raise no_data_found;

Line 382: delete from AHL_VWP_STAGES_TL T

378:
379: procedure ADD_LANGUAGE
380: is
381: begin
382: delete from AHL_VWP_STAGES_TL T
383: where not exists
384: (select NULL
385: from AHL_VWP_STAGES_B B
386: where B.STAGE_ID = T.STAGE_ID

Line 389: update AHL_VWP_STAGES_TL T set (

385: from AHL_VWP_STAGES_B B
386: where B.STAGE_ID = T.STAGE_ID
387: );
388:
389: update AHL_VWP_STAGES_TL T set (
390: STAGE_NAME
391: ) = (select
392: B.STAGE_NAME
393: from AHL_VWP_STAGES_TL B

Line 393: from AHL_VWP_STAGES_TL B

389: update AHL_VWP_STAGES_TL T set (
390: STAGE_NAME
391: ) = (select
392: B.STAGE_NAME
393: from AHL_VWP_STAGES_TL B
394: where B.STAGE_ID = T.STAGE_ID
395: and B.LANGUAGE = T.SOURCE_LANG)
396: where (
397: T.STAGE_ID,

Line 402: from AHL_VWP_STAGES_TL SUBB, AHL_VWP_STAGES_TL SUBT

398: T.LANGUAGE
399: ) in (select
400: SUBT.STAGE_ID,
401: SUBT.LANGUAGE
402: from AHL_VWP_STAGES_TL SUBB, AHL_VWP_STAGES_TL SUBT
403: where SUBB.STAGE_ID = SUBT.STAGE_ID
404: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
405: and (SUBB.STAGE_NAME <> SUBT.STAGE_NAME
406: or (SUBB.STAGE_NAME is null and SUBT.STAGE_NAME is not null)

Line 410: insert into AHL_VWP_STAGES_TL (

406: or (SUBB.STAGE_NAME is null and SUBT.STAGE_NAME is not null)
407: or (SUBB.STAGE_NAME is not null and SUBT.STAGE_NAME is null)
408: ));
409:
410: insert into AHL_VWP_STAGES_TL (
411: STAGE_ID,
412: LAST_UPDATE_DATE,
413: LAST_UPDATED_BY,
414: CREATION_DATE,

Line 430: from AHL_VWP_STAGES_TL B, FND_LANGUAGES L

426: B.LAST_UPDATE_LOGIN,
427: B.STAGE_NAME,
428: L.LANGUAGE_CODE,
429: B.SOURCE_LANG
430: from AHL_VWP_STAGES_TL B, FND_LANGUAGES L
431: where L.INSTALLED_FLAG in ('I', 'B')
432: and B.LANGUAGE = userenv('LANG')
433: and not exists
434: (select NULL

Line 435: from AHL_VWP_STAGES_TL T

431: where L.INSTALLED_FLAG in ('I', 'B')
432: and B.LANGUAGE = userenv('LANG')
433: and not exists
434: (select NULL
435: from AHL_VWP_STAGES_TL T
436: where T.STAGE_ID = B.STAGE_ID
437: and T.LANGUAGE = L.LANGUAGE_CODE);
438: end ADD_LANGUAGE;
439: