APPS.WMS_LABEL_FIELDS_PKG dependencies on WMS_LABEL_FIELDS_TL

Line 109: insert into WMS_LABEL_FIELDS_TL (

105: X_WMS_EXCLUSIVE,
106: X_SQL_STMT
107: );
108:
109: insert into WMS_LABEL_FIELDS_TL (
110: LABEL_FIELD_ID,
111: LAST_UPDATED_BY,
112: LAST_UPDATE_DATE,
113: CREATED_BY,

Line 135: from WMS_LABEL_FIELDS_TL T

131: from FND_LANGUAGES L
132: where L.INSTALLED_FLAG in ('I', 'B')
133: and not exists
134: (select NULL
135: from WMS_LABEL_FIELDS_TL T
136: where T.LABEL_FIELD_ID = X_LABEL_FIELD_ID
137: and T.LANGUAGE = L.LANGUAGE_CODE);
138:
139: open c;

Line 206: from WMS_LABEL_FIELDS_TL

202: cursor c1 is select
203: FIELD_NAME,
204: FIELD_DESCRIPTION,
205: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
206: from WMS_LABEL_FIELDS_TL
207: where LABEL_FIELD_ID = X_LABEL_FIELD_ID
208: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
209: for update of LABEL_FIELD_ID nowait;
210: begin

Line 343: update WMS_LABEL_FIELDS_TL set

339: if (sql%notfound) then
340: raise no_data_found;
341: end if;
342:
343: update WMS_LABEL_FIELDS_TL set
344: FIELD_NAME = X_FIELD_NAME,
345: FIELD_DESCRIPTION = X_FIELD_DESCRIPTION,
346: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
347: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 362: delete from WMS_LABEL_FIELDS_TL

358: procedure DELETE_ROW (
359: X_LABEL_FIELD_ID in NUMBER
360: ) is
361: begin
362: delete from WMS_LABEL_FIELDS_TL
363: where LABEL_FIELD_ID = X_LABEL_FIELD_ID;
364:
365: if (sql%notfound) then
366: raise no_data_found;

Line 380: delete from WMS_LABEL_FIELDS_TL T

376:
377: procedure ADD_LANGUAGE
378: is
379: begin
380: delete from WMS_LABEL_FIELDS_TL T
381: where not exists
382: (select NULL
383: from WMS_LABEL_FIELDS_B B
384: where B.LABEL_FIELD_ID = T.LABEL_FIELD_ID

Line 387: update WMS_LABEL_FIELDS_TL T set (

383: from WMS_LABEL_FIELDS_B B
384: where B.LABEL_FIELD_ID = T.LABEL_FIELD_ID
385: );
386:
387: update WMS_LABEL_FIELDS_TL T set (
388: FIELD_NAME,
389: FIELD_DESCRIPTION
390: ) = (select
391: B.FIELD_NAME,

Line 393: from WMS_LABEL_FIELDS_TL B

389: FIELD_DESCRIPTION
390: ) = (select
391: B.FIELD_NAME,
392: B.FIELD_DESCRIPTION
393: from WMS_LABEL_FIELDS_TL B
394: where B.LABEL_FIELD_ID = T.LABEL_FIELD_ID
395: and B.LANGUAGE = T.SOURCE_LANG)
396: where (
397: T.LABEL_FIELD_ID,

Line 402: from WMS_LABEL_FIELDS_TL SUBB, WMS_LABEL_FIELDS_TL SUBT

398: T.LANGUAGE
399: ) in (select
400: SUBT.LABEL_FIELD_ID,
401: SUBT.LANGUAGE
402: from WMS_LABEL_FIELDS_TL SUBB, WMS_LABEL_FIELDS_TL SUBT
403: where SUBB.LABEL_FIELD_ID = SUBT.LABEL_FIELD_ID
404: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
405: and (SUBB.FIELD_NAME <> SUBT.FIELD_NAME
406: or SUBB.FIELD_DESCRIPTION <> SUBT.FIELD_DESCRIPTION

Line 411: insert into WMS_LABEL_FIELDS_TL (

407: or (SUBB.FIELD_DESCRIPTION is null and SUBT.FIELD_DESCRIPTION is not null)
408: or (SUBB.FIELD_DESCRIPTION is not null and SUBT.FIELD_DESCRIPTION is null)
409: ));
410:
411: insert into WMS_LABEL_FIELDS_TL (
412: LABEL_FIELD_ID,
413: LAST_UPDATED_BY,
414: LAST_UPDATE_DATE,
415: CREATED_BY,

Line 433: from WMS_LABEL_FIELDS_TL B, FND_LANGUAGES L

429: B.FIELD_NAME,
430: B.FIELD_DESCRIPTION,
431: L.LANGUAGE_CODE,
432: B.SOURCE_LANG
433: from WMS_LABEL_FIELDS_TL B, FND_LANGUAGES L
434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL

Line 438: from WMS_LABEL_FIELDS_TL T

434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL
438: from WMS_LABEL_FIELDS_TL T
439: where T.LABEL_FIELD_ID = B.LABEL_FIELD_ID
440: and T.LANGUAGE = L.LANGUAGE_CODE);
441: end ADD_LANGUAGE;
442:

Line 451: UPDATE wms_label_fields_tl SET

447: x_field_name IN VARCHAR2 ,
448: x_field_description IN VARCHAR2
449: ) IS
450: BEGIN
451: UPDATE wms_label_fields_tl SET
452: field_name = x_field_name,
453: field_description = x_field_description,
454: last_update_date = sysdate,
455: last_updated_by = Decode(x_owner, 'SEED', 1, 0),