APPS.AMS_LIST_FIELDS_PKG dependencies on AMS_LIST_FIELDS_TL

Line 54: insert into AMS_LIST_FIELDS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into AMS_LIST_FIELDS_TL (
55: LIST_FIELD_ID,
56: LAST_UPDATE_DATE,
57: LAST_UPDATED_BY,
58: CREATION_DATE,

Line 78: from AMS_LIST_FIELDS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from AMS_LIST_FIELDS_TL T
79: where T.LIST_FIELD_ID = X_LIST_FIELD_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from AMS_LIST_FIELDS_TL

115:
116: cursor c1 is select
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from AMS_LIST_FIELDS_TL
120: where LIST_FIELD_ID = X_LIST_FIELD_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of LIST_FIELD_ID nowait;
123: begin

Line 195: update AMS_LIST_FIELDS_TL set

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: update AMS_LIST_FIELDS_TL set
196: DESCRIPTION = X_DESCRIPTION,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
198: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
199: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 213: delete from AMS_LIST_FIELDS_TL

209: procedure DELETE_ROW (
210: X_LIST_FIELD_ID in NUMBER
211: ) is
212: begin
213: delete from AMS_LIST_FIELDS_TL
214: where LIST_FIELD_ID = X_LIST_FIELD_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 231: delete from AMS_LIST_FIELDS_TL T

227:
228: procedure ADD_LANGUAGE
229: is
230: begin
231: delete from AMS_LIST_FIELDS_TL T
232: where not exists
233: (select NULL
234: from AMS_LIST_FIELDS_B B
235: where B.LIST_FIELD_ID = T.LIST_FIELD_ID

Line 238: update AMS_LIST_FIELDS_TL T set (

234: from AMS_LIST_FIELDS_B B
235: where B.LIST_FIELD_ID = T.LIST_FIELD_ID
236: );
237:
238: update AMS_LIST_FIELDS_TL T set (
239: DESCRIPTION
240: ) = (select
241: B.DESCRIPTION
242: from AMS_LIST_FIELDS_TL B

Line 242: from AMS_LIST_FIELDS_TL B

238: update AMS_LIST_FIELDS_TL T set (
239: DESCRIPTION
240: ) = (select
241: B.DESCRIPTION
242: from AMS_LIST_FIELDS_TL B
243: where B.LIST_FIELD_ID = T.LIST_FIELD_ID
244: and B.LANGUAGE = T.SOURCE_LANG)
245: where (
246: T.LIST_FIELD_ID,

Line 251: from AMS_LIST_FIELDS_TL SUBB, AMS_LIST_FIELDS_TL SUBT

247: T.LANGUAGE
248: ) in (select
249: SUBT.LIST_FIELD_ID,
250: SUBT.LANGUAGE
251: from AMS_LIST_FIELDS_TL SUBB, AMS_LIST_FIELDS_TL SUBT
252: where SUBB.LIST_FIELD_ID = SUBT.LIST_FIELD_ID
253: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
254: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
255: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 259: insert into AMS_LIST_FIELDS_TL (

255: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
256: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
257: ));
258:
259: insert into AMS_LIST_FIELDS_TL (
260: LIST_FIELD_ID,
261: LAST_UPDATE_DATE,
262: LAST_UPDATED_BY,
263: CREATION_DATE,

Line 279: from AMS_LIST_FIELDS_TL B, FND_LANGUAGES L

275: B.LAST_UPDATE_LOGIN,
276: B.DESCRIPTION,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from AMS_LIST_FIELDS_TL B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from AMS_LIST_FIELDS_TL T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from AMS_LIST_FIELDS_TL T
285: where T.LIST_FIELD_ID = B.LIST_FIELD_ID
286: and T.LANGUAGE = L.LANGUAGE_CODE);
287: end ADD_LANGUAGE;
288:

Line 296: update ams_list_fields_tl set

292: , x_owner in VARCHAR2
293: )
294: IS
295: BEGIN
296: update ams_list_fields_tl set
297: description = nvl(x_description, description),
298: source_lang = userenv('LANG'),
299: last_update_date = sysdate,
300: last_updated_by = decode(x_owner, 'SEED', 1, 0),