APPS.AMS_TRIGGER_PKG dependencies on AMS_TRIGGERS_TL

Line 450: delete from ams_triggers_tl T

446:
447: procedure ADD_LANGUAGE
448: is
449: begin
450: delete from ams_triggers_tl T
451: where not exists
452: (select NULL
453: from ams_triggers B
454: where B.trigger_id = T.trigger_id

Line 457: update ams_triggers_tl T set (

453: from ams_triggers B
454: where B.trigger_id = T.trigger_id
455: );
456:
457: update ams_triggers_tl T set (
458: trigger_name
459: , DESCRIPTION
460: ) = (select
461: B.trigger_name

Line 463: from ams_triggers_tl B

459: , DESCRIPTION
460: ) = (select
461: B.trigger_name
462: , B.DESCRIPTION
463: from ams_triggers_tl B
464: where B.trigger_id = T.trigger_id
465: and B.LANGUAGE = T.SOURCE_LANG)
466: where (
467: T.trigger_id,

Line 472: from ams_triggers_tl SUBB, ams_triggers_tl SUBT

468: T.LANGUAGE
469: ) in (select
470: SUBT.trigger_id,
471: SUBT.LANGUAGE
472: from ams_triggers_tl SUBB, ams_triggers_tl SUBT
473: where SUBB.trigger_id = SUBT.trigger_id
474: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
475: and (SUBB.trigger_name <> SUBT.trigger_name
476: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 481: insert into ams_triggers_tl (

477: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
478: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
479: ));
480:
481: insert into ams_triggers_tl (
482: trigger_id,
483: CREATION_DATE,
484: CREATED_BY,
485: LAST_UPDATE_DATE,

Line 503: from ams_triggers_tl B, FND_LANGUAGES L

499: B.trigger_name,
500: B.DESCRIPTION,
501: L.LANGUAGE_CODE,
502: B.SOURCE_LANG
503: from ams_triggers_tl B, FND_LANGUAGES L
504: where L.INSTALLED_FLAG in ('I', 'B')
505: and B.LANGUAGE = userenv('LANG')
506: and not exists
507: (select NULL

Line 508: from ams_triggers_tl T

504: where L.INSTALLED_FLAG in ('I', 'B')
505: and B.LANGUAGE = userenv('LANG')
506: and not exists
507: (select NULL
508: from ams_triggers_tl T
509: where T.trigger_id = B.trigger_id
510: and T.LANGUAGE = L.LANGUAGE_CODE);
511: end ADD_LANGUAGE;
512: