APPS.AMS_CUSTOM_SETUPS_PKG dependencies on AMS_CUSTOM_SETUPS_TL

Line 64: insert into AMS_CUSTOM_SETUPS_TL (

60: X_USAGE,
61: X_MIGRATED_CUSTOM_SETUP_ID
62: );
63:
64: insert into AMS_CUSTOM_SETUPS_TL (
65: LAST_UPDATE_DATE,
66: LAST_UPDATED_BY,
67: CREATION_DATE,
68: CREATED_BY,

Line 90: from AMS_CUSTOM_SETUPS_TL T

86: from FND_LANGUAGES L
87: where L.INSTALLED_FLAG in ('I', 'B')
88: and not exists
89: (select NULL
90: from AMS_CUSTOM_SETUPS_TL T
91: where T.CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID
92: and T.LANGUAGE = L.LANGUAGE_CODE);
93:
94: open c;

Line 135: from AMS_CUSTOM_SETUPS_TL

131: cursor c1 is select
132: SETUP_NAME,
133: DESCRIPTION,
134: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
135: from AMS_CUSTOM_SETUPS_TL
136: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID
137: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
138: for update of CUSTOM_SETUP_ID nowait;
139: begin

Line 221: update AMS_CUSTOM_SETUPS_TL set

217: if (sql%notfound) then
218: raise no_data_found;
219: end if;
220:
221: update AMS_CUSTOM_SETUPS_TL set
222: SETUP_NAME = X_SETUP_NAME,
223: DESCRIPTION = X_DESCRIPTION,
224: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
225: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 240: delete from AMS_CUSTOM_SETUPS_TL

236: procedure DELETE_ROW (
237: X_CUSTOM_SETUP_ID in NUMBER
238: ) is
239: begin
240: delete from AMS_CUSTOM_SETUPS_TL
241: where CUSTOM_SETUP_ID = X_CUSTOM_SETUP_ID;
242:
243: if (sql%notfound) then
244: raise no_data_found;

Line 258: delete from AMS_CUSTOM_SETUPS_TL T

254:
255: procedure ADD_LANGUAGE
256: is
257: begin
258: delete from AMS_CUSTOM_SETUPS_TL T
259: where not exists
260: (select NULL
261: from AMS_CUSTOM_SETUPS_B B
262: where B.CUSTOM_SETUP_ID = T.CUSTOM_SETUP_ID

Line 265: update AMS_CUSTOM_SETUPS_TL T set (

261: from AMS_CUSTOM_SETUPS_B B
262: where B.CUSTOM_SETUP_ID = T.CUSTOM_SETUP_ID
263: );
264:
265: update AMS_CUSTOM_SETUPS_TL T set (
266: SETUP_NAME,
267: DESCRIPTION
268: ) = (select
269: B.SETUP_NAME,

Line 271: from AMS_CUSTOM_SETUPS_TL B

267: DESCRIPTION
268: ) = (select
269: B.SETUP_NAME,
270: B.DESCRIPTION
271: from AMS_CUSTOM_SETUPS_TL B
272: where B.CUSTOM_SETUP_ID = T.CUSTOM_SETUP_ID
273: and B.LANGUAGE = T.SOURCE_LANG)
274: where (
275: T.CUSTOM_SETUP_ID,

Line 280: from AMS_CUSTOM_SETUPS_TL SUBB, AMS_CUSTOM_SETUPS_TL SUBT

276: T.LANGUAGE
277: ) in (select
278: SUBT.CUSTOM_SETUP_ID,
279: SUBT.LANGUAGE
280: from AMS_CUSTOM_SETUPS_TL SUBB, AMS_CUSTOM_SETUPS_TL SUBT
281: where SUBB.CUSTOM_SETUP_ID = SUBT.CUSTOM_SETUP_ID
282: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
283: and (SUBB.SETUP_NAME <> SUBT.SETUP_NAME
284: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 289: insert into AMS_CUSTOM_SETUPS_TL (

285: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
286: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
287: ));
288:
289: insert into AMS_CUSTOM_SETUPS_TL (
290: LAST_UPDATE_DATE,
291: LAST_UPDATED_BY,
292: CREATION_DATE,
293: CREATED_BY,

Line 311: from AMS_CUSTOM_SETUPS_TL B, FND_LANGUAGES L

307: B.DESCRIPTION,
308: B.CUSTOM_SETUP_ID,
309: L.LANGUAGE_CODE,
310: B.SOURCE_LANG
311: from AMS_CUSTOM_SETUPS_TL B, FND_LANGUAGES L
312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL

Line 316: from AMS_CUSTOM_SETUPS_TL T

312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL
316: from AMS_CUSTOM_SETUPS_TL T
317: where T.CUSTOM_SETUP_ID = B.CUSTOM_SETUP_ID
318: and T.LANGUAGE = L.LANGUAGE_CODE);
319: end ADD_LANGUAGE;
320:

Line 329: update ams_custom_setups_tl set

325: , X_DESCRIPTION in VARCHAR2
326: , x_owner in VARCHAR2
327: ) is
328: begin
329: update ams_custom_setups_tl set
330: setup_name = nvl(x_SETUP_NAME, setup_name),
331: description = nvl(x_description, description),
332: source_lang = userenv('LANG'),
333: last_update_date = sysdate,