APPS.WMS_STRATEGIES_PKG dependencies on WMS_STRATEGIES_TL

Line 103: insert into WMS_STRATEGIES_TL (

99: X_OVER_ALLOCATION_MODE,
100: X_TOLERANCE_VALUE
101: );
102:
103: insert into WMS_STRATEGIES_TL (
104: STRATEGY_ID,
105: LAST_UPDATED_BY,
106: LAST_UPDATE_DATE,
107: CREATED_BY,

Line 129: from WMS_STRATEGIES_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from WMS_STRATEGIES_TL T
130: where T.STRATEGY_ID = X_STRATEGY_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 202: from WMS_STRATEGIES_TL

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

Line 341: update WMS_STRATEGIES_TL set

337: if (sql%notfound) then
338: raise no_data_found;
339: end if;
340:
341: update WMS_STRATEGIES_TL set
342: NAME = X_NAME,
343: DESCRIPTION = X_DESCRIPTION,
344: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
345: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 360: delete from WMS_STRATEGIES_TL

356: procedure DELETE_ROW (
357: X_STRATEGY_ID in NUMBER
358: ) is
359: begin
360: delete from WMS_STRATEGIES_TL
361: where STRATEGY_ID = X_STRATEGY_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 378: delete from WMS_STRATEGIES_TL T

374:
375: procedure ADD_LANGUAGE
376: is
377: begin
378: delete from WMS_STRATEGIES_TL T
379: where not exists
380: (select NULL
381: from WMS_STRATEGIES_B B
382: where B.STRATEGY_ID = T.STRATEGY_ID

Line 385: update WMS_STRATEGIES_TL T set (

381: from WMS_STRATEGIES_B B
382: where B.STRATEGY_ID = T.STRATEGY_ID
383: );
384:
385: update WMS_STRATEGIES_TL T set (
386: NAME,
387: DESCRIPTION
388: ) = (select
389: B.NAME,

Line 391: from WMS_STRATEGIES_TL B

387: DESCRIPTION
388: ) = (select
389: B.NAME,
390: B.DESCRIPTION
391: from WMS_STRATEGIES_TL B
392: where B.STRATEGY_ID = T.STRATEGY_ID
393: and B.LANGUAGE = T.SOURCE_LANG)
394: where (
395: T.STRATEGY_ID,

Line 400: from WMS_STRATEGIES_TL SUBB, WMS_STRATEGIES_TL SUBT

396: T.LANGUAGE
397: ) in (select
398: SUBT.STRATEGY_ID,
399: SUBT.LANGUAGE
400: from WMS_STRATEGIES_TL SUBB, WMS_STRATEGIES_TL SUBT
401: where SUBB.STRATEGY_ID = SUBT.STRATEGY_ID
402: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
403: and (SUBB.NAME <> SUBT.NAME
404: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 409: insert into WMS_STRATEGIES_TL (

405: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
406: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
407: ));
408:
409: insert into WMS_STRATEGIES_TL (
410: STRATEGY_ID,
411: LAST_UPDATED_BY,
412: LAST_UPDATE_DATE,
413: CREATED_BY,

Line 431: from WMS_STRATEGIES_TL B, FND_LANGUAGES L

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

Line 436: from WMS_STRATEGIES_TL T

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

Line 449: UPDATE wms_strategies_tl SET

445: x_description IN VARCHAR2,
446: x_owner IN VARCHAR2
447: ) IS
448: BEGIN
449: UPDATE wms_strategies_tl SET
450: name = x_name,
451: description = x_description,
452: last_update_date = Sysdate,
453: last_updated_by = Decode(x_owner, 'SEED', 1, 0),