APPS.AHL_SIMULATION_PLANS_PKG dependencies on AHL_SIMULATION_PLANS_TL

Line 94: insert into AHL_SIMULATION_PLANS_TL (

90: X_STATUS_CODE,
91: X_SIMULATION_TYPE
92: );
93:
94: insert into AHL_SIMULATION_PLANS_TL (
95: SIMULATION_PLAN_ID,
96: LAST_UPDATE_DATE,
97: LAST_UPDATED_BY,
98: CREATION_DATE,

Line 120: from AHL_SIMULATION_PLANS_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from AHL_SIMULATION_PLANS_TL T
121: where T.SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
122: and T.LANGUAGE = L.LANGUAGE_CODE);
123:
124: open c;

Line 189: from AHL_SIMULATION_PLANS_TL

185: cursor c1 is select
186: SIMULATION_PLAN_NAME,
187: DESCRIPTION,
188: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
189: from AHL_SIMULATION_PLANS_TL
190: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID
191: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
192: for update of SIMULATION_PLAN_ID nowait;
193: begin

Line 322: update AHL_SIMULATION_PLANS_TL set

318: if (sql%notfound) then
319: raise no_data_found;
320: end if;
321:
322: update AHL_SIMULATION_PLANS_TL set
323: SIMULATION_PLAN_NAME = X_SIMULATION_PLAN_NAME,
324: DESCRIPTION = X_DESCRIPTION,
325: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
326: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 341: delete from AHL_SIMULATION_PLANS_TL

337: procedure DELETE_ROW (
338: X_SIMULATION_PLAN_ID in NUMBER
339: ) is
340: begin
341: delete from AHL_SIMULATION_PLANS_TL
342: where SIMULATION_PLAN_ID = X_SIMULATION_PLAN_ID;
343:
344: if (sql%notfound) then
345: raise no_data_found;

Line 359: delete from AHL_SIMULATION_PLANS_TL T

355:
356: procedure ADD_LANGUAGE
357: is
358: begin
359: delete from AHL_SIMULATION_PLANS_TL T
360: where not exists
361: (select NULL
362: from AHL_SIMULATION_PLANS_B B
363: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID

Line 366: update AHL_SIMULATION_PLANS_TL T set (

362: from AHL_SIMULATION_PLANS_B B
363: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID
364: );
365:
366: update AHL_SIMULATION_PLANS_TL T set (
367: SIMULATION_PLAN_NAME,
368: DESCRIPTION
369: ) = (select
370: B.SIMULATION_PLAN_NAME,

Line 372: from AHL_SIMULATION_PLANS_TL B

368: DESCRIPTION
369: ) = (select
370: B.SIMULATION_PLAN_NAME,
371: B.DESCRIPTION
372: from AHL_SIMULATION_PLANS_TL B
373: where B.SIMULATION_PLAN_ID = T.SIMULATION_PLAN_ID
374: and B.LANGUAGE = T.SOURCE_LANG)
375: where (
376: T.SIMULATION_PLAN_ID,

Line 381: from AHL_SIMULATION_PLANS_TL SUBB, AHL_SIMULATION_PLANS_TL SUBT

377: T.LANGUAGE
378: ) in (select
379: SUBT.SIMULATION_PLAN_ID,
380: SUBT.LANGUAGE
381: from AHL_SIMULATION_PLANS_TL SUBB, AHL_SIMULATION_PLANS_TL SUBT
382: where SUBB.SIMULATION_PLAN_ID = SUBT.SIMULATION_PLAN_ID
383: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
384: and (SUBB.SIMULATION_PLAN_NAME <> SUBT.SIMULATION_PLAN_NAME
385: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 390: insert into AHL_SIMULATION_PLANS_TL (

386: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
387: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
388: ));
389:
390: insert into AHL_SIMULATION_PLANS_TL (
391: SIMULATION_PLAN_ID,
392: LAST_UPDATE_DATE,
393: LAST_UPDATED_BY,
394: CREATION_DATE,

Line 412: from AHL_SIMULATION_PLANS_TL B, FND_LANGUAGES L

408: B.SIMULATION_PLAN_NAME,
409: B.DESCRIPTION,
410: L.LANGUAGE_CODE,
411: B.SOURCE_LANG
412: from AHL_SIMULATION_PLANS_TL B, FND_LANGUAGES L
413: where L.INSTALLED_FLAG in ('I', 'B')
414: and B.LANGUAGE = userenv('LANG')
415: and not exists
416: (select NULL

Line 417: from AHL_SIMULATION_PLANS_TL T

413: where L.INSTALLED_FLAG in ('I', 'B')
414: and B.LANGUAGE = userenv('LANG')
415: and not exists
416: (select NULL
417: from AHL_SIMULATION_PLANS_TL T
418: where T.SIMULATION_PLAN_ID = B.SIMULATION_PLAN_ID
419: and T.LANGUAGE = L.LANGUAGE_CODE);
420: end ADD_LANGUAGE;
421:

Line 591: update AHL_SIMULATION_PLANS_TL set

587: , x_description in VARCHAR2
588: , x_owner in VARCHAR2
589: ) is
590: begin
591: update AHL_SIMULATION_PLANS_TL set
592: simulation_plan_name = nvl(x_simulation_plan_name, simulation_plan_name),
593: description = nvl(x_description, description),
594: source_lang = userenv('LANG'),
595: last_update_date = sysdate,