APPS.AHL_SIMULATION_PLANS_PKG dependencies on AHL_SIMULATION_PLANS_TL

Line 88: insert into AHL_SIMULATION_PLANS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into AHL_SIMULATION_PLANS_TL (
89: SIMULATION_PLAN_ID,
90: LAST_UPDATE_DATE,
91: LAST_UPDATED_BY,
92: CREATION_DATE,

Line 114: from AHL_SIMULATION_PLANS_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from AHL_SIMULATION_PLANS_TL T
115: where T.SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 179: from AHL_SIMULATION_PLANS_TL

175: cursor c1 is select
176: SIMULATION_PLAN_NAME,
177: DESCRIPTION,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from AHL_SIMULATION_PLANS_TL
180: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of SIMULATION_PLAN_ID nowait;
183: begin

Line 304: update AHL_SIMULATION_PLANS_TL set

300: if (sql%notfound) then
301: raise no_data_found;
302: end if;
303:
304: update AHL_SIMULATION_PLANS_TL set
305: SIMULATION_PLAN_NAME = X_SIMULATION_PLAN_NAME,
306: DESCRIPTION = X_DESCRIPTION,
307: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
308: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 323: delete from AHL_SIMULATION_PLANS_TL

319: procedure DELETE_ROW (
320: X_SIMULATION_PLAN_ID in NUMBER
321: ) is
322: begin
323: delete from AHL_SIMULATION_PLANS_TL
324: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 341: delete from AHL_SIMULATION_PLANS_TL T

337:
338: procedure ADD_LANGUAGE
339: is
340: begin
341: delete from AHL_SIMULATION_PLANS_TL T
342: where not exists
343: (select NULL
344: from AHL_SIMULATION_PLANS_B B
345: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID

Line 348: update AHL_SIMULATION_PLANS_TL T set (

344: from AHL_SIMULATION_PLANS_B B
345: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID
346: );
347:
348: update AHL_SIMULATION_PLANS_TL T set (
349: SIMULATION_PLAN_NAME,
350: DESCRIPTION
351: ) = (select
352: B.SIMULATION_PLAN_NAME,

Line 354: from AHL_SIMULATION_PLANS_TL B

350: DESCRIPTION
351: ) = (select
352: B.SIMULATION_PLAN_NAME,
353: B.DESCRIPTION
354: from AHL_SIMULATION_PLANS_TL B
355: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID
356: and B.LANGUAGE = T.SOURCE_LANG)
357: where (
358: T.SIMULATION_PLAN_ID,

Line 363: from AHL_SIMULATION_PLANS_TL SUBB, AHL_SIMULATION_PLANS_TL SUBT

359: T.LANGUAGE
360: ) in (select
361: SUBT.SIMULATION_PLAN_ID,
362: SUBT.LANGUAGE
363: from AHL_SIMULATION_PLANS_TL SUBB, AHL_SIMULATION_PLANS_TL SUBT
364: where SUBB.SIMULATION_PLAN_ID = SUBT.SIMULATION_PLAN_ID
365: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
366: and (SUBB.SIMULATION_PLAN_NAME <> SUBT.SIMULATION_PLAN_NAME
367: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 372: insert into AHL_SIMULATION_PLANS_TL (

368: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
369: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
370: ));
371:
372: insert into AHL_SIMULATION_PLANS_TL (
373: SIMULATION_PLAN_ID,
374: LAST_UPDATE_DATE,
375: LAST_UPDATED_BY,
376: CREATION_DATE,

Line 394: from AHL_SIMULATION_PLANS_TL B, FND_LANGUAGES L

390: B.SIMULATION_PLAN_NAME,
391: B.DESCRIPTION,
392: L.LANGUAGE_CODE,
393: B.SOURCE_LANG
394: from AHL_SIMULATION_PLANS_TL B, FND_LANGUAGES L
395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL

Line 399: from AHL_SIMULATION_PLANS_TL T

395: where L.INSTALLED_FLAG in ('I', 'B')
396: and B.LANGUAGE = userenv('LANG')
397: and not exists
398: (select NULL
399: from AHL_SIMULATION_PLANS_TL T
400: where T.SIMULATION_PLAN_ID = B.SIMULATION_PLAN_ID
401: and T.LANGUAGE = L.LANGUAGE_CODE);
402: end ADD_LANGUAGE;
403:

Line 547: update AHL_SIMULATION_PLANS_TL set

543: , x_description in VARCHAR2
544: , x_owner in VARCHAR2
545: ) is
546: begin
547: update AHL_SIMULATION_PLANS_TL set
548: simulation_plan_name = nvl(x_simulation_plan_name, simulation_plan_name),
549: description = nvl(x_description, description),
550: source_lang = userenv('LANG'),
551: last_update_date = sysdate,