APPS.WMS_OBJECTS_PKG dependencies on WMS_OBJECTS_TL

Line 91: insert into WMS_OBJECTS_TL (

87: X_LAST_UPDATED_BY,
88: X_LAST_UPDATE_LOGIN
89: );
90:
91: insert into WMS_OBJECTS_TL (
92: NAME,
93: DESCRIPTION,
94: OBJECT_ID,
95: LAST_UPDATED_BY,

Line 117: from WMS_OBJECTS_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from WMS_OBJECTS_TL T
118: where T.OBJECT_ID = X_OBJECT_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: open c;

Line 184: from WMS_OBJECTS_TL

180: cursor c1 is select
181: NAME,
182: DESCRIPTION,
183: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
184: from WMS_OBJECTS_TL
185: where OBJECT_ID = X_OBJECT_ID
186: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
187: for update of OBJECT_ID nowait;
188: begin

Line 314: update WMS_OBJECTS_TL set

310: if (sql%notfound) then
311: raise no_data_found;
312: end if;
313:
314: update WMS_OBJECTS_TL set
315: NAME = X_NAME,
316: DESCRIPTION = X_DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 333: delete from WMS_OBJECTS_TL

329: procedure DELETE_ROW (
330: X_OBJECT_ID in NUMBER
331: ) is
332: begin
333: delete from WMS_OBJECTS_TL
334: where OBJECT_ID = X_OBJECT_ID;
335:
336: if (sql%notfound) then
337: raise no_data_found;

Line 351: delete from WMS_OBJECTS_TL T

347:
348: procedure ADD_LANGUAGE
349: is
350: begin
351: delete from WMS_OBJECTS_TL T
352: where not exists
353: (select NULL
354: from WMS_OBJECTS_B B
355: where B.OBJECT_ID = T.OBJECT_ID

Line 358: update WMS_OBJECTS_TL T set (

354: from WMS_OBJECTS_B B
355: where B.OBJECT_ID = T.OBJECT_ID
356: );
357:
358: update WMS_OBJECTS_TL T set (
359: NAME,
360: DESCRIPTION
361: ) = (select
362: B.NAME,

Line 364: from WMS_OBJECTS_TL B

360: DESCRIPTION
361: ) = (select
362: B.NAME,
363: B.DESCRIPTION
364: from WMS_OBJECTS_TL B
365: where B.OBJECT_ID = T.OBJECT_ID
366: and B.LANGUAGE = T.SOURCE_LANG)
367: where (
368: T.OBJECT_ID,

Line 373: from WMS_OBJECTS_TL SUBB, WMS_OBJECTS_TL SUBT

369: T.LANGUAGE
370: ) in (select
371: SUBT.OBJECT_ID,
372: SUBT.LANGUAGE
373: from WMS_OBJECTS_TL SUBB, WMS_OBJECTS_TL SUBT
374: where SUBB.OBJECT_ID = SUBT.OBJECT_ID
375: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: and (SUBB.NAME <> SUBT.NAME
377: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 382: insert into WMS_OBJECTS_TL (

378: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
379: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
380: ));
381:
382: insert into WMS_OBJECTS_TL (
383: NAME,
384: DESCRIPTION,
385: OBJECT_ID,
386: LAST_UPDATED_BY,

Line 404: from WMS_OBJECTS_TL B, FND_LANGUAGES L

400: B.CREATION_DATE,
401: B.LAST_UPDATE_LOGIN,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: from WMS_OBJECTS_TL B, FND_LANGUAGES L
405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL

Line 409: from WMS_OBJECTS_TL T

405: where L.INSTALLED_FLAG in ('I', 'B')
406: and B.LANGUAGE = userenv('LANG')
407: and not exists
408: (select NULL
409: from WMS_OBJECTS_TL T
410: where T.OBJECT_ID = B.OBJECT_ID
411: and T.LANGUAGE = L.LANGUAGE_CODE);
412: end ADD_LANGUAGE;
413: PROCEDURE translate_row

Line 421: UPDATE wms_objects_tl SET

417: x_name IN VARCHAR2,
418: x_description IN VARCHAR2
419: ) IS
420: BEGIN
421: UPDATE wms_objects_tl SET
422: name = x_name,
423: description = x_description,
424: last_update_date = Sysdate,
425: last_updated_by = Decode(x_owner,'SEED',1,0),