APPS.AMS_CATEGORIES_PKG dependencies on AMS_CATEGORIES_TL

Line 100: insert into AMS_CATEGORIES_TL (

96: X_ACCRUED_LIABILITY_ACCOUNT,
97: X_DED_ADJUSTMENT_ACCOUNT
98: );
99:
100: insert into AMS_CATEGORIES_TL (
101: CATEGORY_ID,
102: LAST_UPDATE_DATE,
103: LAST_UPDATED_BY,
104: CREATION_DATE,

Line 126: from AMS_CATEGORIES_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from AMS_CATEGORIES_TL T
127: where T.CATEGORY_ID = X_CATEGORY_ID
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:
130: open c;

Line 199: from AMS_CATEGORIES_TL

195: cursor c1 is select
196: CATEGORY_NAME,
197: DESCRIPTION,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from AMS_CATEGORIES_TL
200: where CATEGORY_ID = X_CATEGORY_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of CATEGORY_ID nowait;
203: begin

Line 341: update AMS_CATEGORIES_TL set

337: if (sql%notfound) then
338: raise no_data_found;
339: end if;
340:
341: update AMS_CATEGORIES_TL set
342: CATEGORY_NAME = X_CATEGORY_NAME,
343: DESCRIPTION = X_DESCRIPTION,
344: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
345: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 360: delete from AMS_CATEGORIES_TL

356: procedure DELETE_ROW (
357: X_CATEGORY_ID in NUMBER
358: ) is
359: begin
360: delete from AMS_CATEGORIES_TL
361: where CATEGORY_ID = X_CATEGORY_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 378: delete from AMS_CATEGORIES_TL T

374:
375: procedure ADD_LANGUAGE
376: is
377: begin
378: delete from AMS_CATEGORIES_TL T
379: where not exists
380: (select NULL
381: from AMS_CATEGORIES_B B
382: where B.CATEGORY_ID = T.CATEGORY_ID

Line 385: update AMS_CATEGORIES_TL T set (

381: from AMS_CATEGORIES_B B
382: where B.CATEGORY_ID = T.CATEGORY_ID
383: );
384:
385: update AMS_CATEGORIES_TL T set (
386: CATEGORY_NAME,
387: DESCRIPTION
388: ) = (select
389: B.CATEGORY_NAME,

Line 391: from AMS_CATEGORIES_TL B

387: DESCRIPTION
388: ) = (select
389: B.CATEGORY_NAME,
390: B.DESCRIPTION
391: from AMS_CATEGORIES_TL B
392: where B.CATEGORY_ID = T.CATEGORY_ID
393: and B.LANGUAGE = T.SOURCE_LANG)
394: where (
395: T.CATEGORY_ID,

Line 400: from AMS_CATEGORIES_TL SUBB, AMS_CATEGORIES_TL SUBT

396: T.LANGUAGE
397: ) in (select
398: SUBT.CATEGORY_ID,
399: SUBT.LANGUAGE
400: from AMS_CATEGORIES_TL SUBB, AMS_CATEGORIES_TL SUBT
401: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
402: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
403: and (SUBB.CATEGORY_NAME <> SUBT.CATEGORY_NAME
404: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 409: insert into AMS_CATEGORIES_TL (

405: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
406: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
407: ));
408:
409: insert into AMS_CATEGORIES_TL (
410: CATEGORY_ID,
411: LAST_UPDATE_DATE,
412: LAST_UPDATED_BY,
413: CREATION_DATE,

Line 431: from AMS_CATEGORIES_TL B, FND_LANGUAGES L

427: B.CATEGORY_NAME,
428: B.DESCRIPTION,
429: L.LANGUAGE_CODE,
430: B.SOURCE_LANG
431: from AMS_CATEGORIES_TL B, FND_LANGUAGES L
432: where L.INSTALLED_FLAG in ('I', 'B')
433: and B.LANGUAGE = userenv('LANG')
434: and not exists
435: (select NULL

Line 436: from AMS_CATEGORIES_TL T

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

Line 448: update AMS_CATEGORIES_TL set

444: , x_description in VARCHAR2
445: , x_owner in VARCHAR2
446: ) is
447: begin
448: update AMS_CATEGORIES_TL set
449: category_name = nvl(x_category_name, category_name),
450: description = nvl(x_description, description),
451: source_lang = userenv('LANG'),
452: last_update_date = sysdate,