APPS.WMS_PARAMETERS_PKG dependencies on WMS_PARAMETERS_TL

Line 151: insert into WMS_PARAMETERS_TL (

147: X_LAST_UPDATE_LOGIN,
148: X_USE_FOR_OP_SELECTION_FLAG
149: );
150:
151: insert into WMS_PARAMETERS_TL (
152: PARAMETER_ID,
153: LAST_UPDATED_BY,
154: LAST_UPDATE_DATE,
155: CREATED_BY,

Line 177: from WMS_PARAMETERS_TL T

173: from FND_LANGUAGES L
174: where L.INSTALLED_FLAG in ('I', 'B')
175: and not exists
176: (select NULL
177: from WMS_PARAMETERS_TL T
178: where T.PARAMETER_ID = X_PARAMETER_ID
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:
181: open c;

Line 284: from WMS_PARAMETERS_TL

280: cursor c1 is select
281: NAME,
282: DESCRIPTION,
283: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
284: from WMS_PARAMETERS_TL
285: where PARAMETER_ID = X_PARAMETER_ID
286: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
287: for update of PARAMETER_ID nowait;
288: begin

Line 480: update WMS_PARAMETERS_TL set

476: if (sql%notfound) then
477: raise no_data_found;
478: end if;
479:
480: update WMS_PARAMETERS_TL set
481: NAME = X_NAME,
482: DESCRIPTION = X_DESCRIPTION,
483: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
484: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 499: delete from WMS_PARAMETERS_TL

495: procedure DELETE_ROW (
496: X_PARAMETER_ID in NUMBER
497: ) is
498: begin
499: delete from WMS_PARAMETERS_TL
500: where PARAMETER_ID = X_PARAMETER_ID;
501:
502: if (sql%notfound) then
503: raise no_data_found;

Line 517: delete from WMS_PARAMETERS_TL T

513:
514: procedure ADD_LANGUAGE
515: is
516: begin
517: delete from WMS_PARAMETERS_TL T
518: where not exists
519: (select NULL
520: from WMS_PARAMETERS_B B
521: where B.PARAMETER_ID = T.PARAMETER_ID

Line 524: update WMS_PARAMETERS_TL T set (

520: from WMS_PARAMETERS_B B
521: where B.PARAMETER_ID = T.PARAMETER_ID
522: );
523:
524: update WMS_PARAMETERS_TL T set (
525: NAME,
526: DESCRIPTION
527: ) = (select
528: B.NAME,

Line 530: from WMS_PARAMETERS_TL B

526: DESCRIPTION
527: ) = (select
528: B.NAME,
529: B.DESCRIPTION
530: from WMS_PARAMETERS_TL B
531: where B.PARAMETER_ID = T.PARAMETER_ID
532: and B.LANGUAGE = T.SOURCE_LANG)
533: where (
534: T.PARAMETER_ID,

Line 539: from WMS_PARAMETERS_TL SUBB, WMS_PARAMETERS_TL SUBT

535: T.LANGUAGE
536: ) in (select
537: SUBT.PARAMETER_ID,
538: SUBT.LANGUAGE
539: from WMS_PARAMETERS_TL SUBB, WMS_PARAMETERS_TL SUBT
540: where SUBB.PARAMETER_ID = SUBT.PARAMETER_ID
541: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
542: and (SUBB.NAME <> SUBT.NAME
543: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 548: insert into WMS_PARAMETERS_TL (

544: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
545: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
546: ));
547:
548: insert into WMS_PARAMETERS_TL (
549: PARAMETER_ID,
550: LAST_UPDATED_BY,
551: LAST_UPDATE_DATE,
552: CREATED_BY,

Line 570: from WMS_PARAMETERS_TL B, FND_LANGUAGES L

566: B.NAME,
567: B.DESCRIPTION,
568: L.LANGUAGE_CODE,
569: B.SOURCE_LANG
570: from WMS_PARAMETERS_TL B, FND_LANGUAGES L
571: where L.INSTALLED_FLAG in ('I', 'B')
572: and B.LANGUAGE = userenv('LANG')
573: and not exists
574: (select NULL

Line 575: from WMS_PARAMETERS_TL T

571: where L.INSTALLED_FLAG in ('I', 'B')
572: and B.LANGUAGE = userenv('LANG')
573: and not exists
574: (select NULL
575: from WMS_PARAMETERS_TL T
576: where T.PARAMETER_ID = B.PARAMETER_ID
577: and T.LANGUAGE = L.LANGUAGE_CODE);
578: end ADD_LANGUAGE;
579: PROCEDURE translate_row

Line 587: UPDATE wms_parameters_tl SET

583: x_name IN VARCHAR2 ,
584: x_description IN VARCHAR2
585: ) IS
586: BEGIN
587: UPDATE wms_parameters_tl SET
588: name = x_name,
589: description = x_description,
590: last_update_date = Sysdate,
591: last_updated_by = Decode(x_owner, 'SEED', 1, 0),