APPS.AMS_TRIGGER_PKG dependencies on AMS_TRIGGERS

Line 81: INSERT INTO AMS_TRIGGERS(

77:
78: px_object_version_number := 1;
79:
80:
81: INSERT INTO AMS_TRIGGERS(
82: trigger_id,
83: last_update_date,
84: last_updated_by,
85: creation_date,

Line 197: Update AMS_TRIGGERS

193: p_security_group_id NUMBER)
194:
195: IS
196: BEGIN
197: Update AMS_TRIGGERS
198: SET
199: trigger_id = DECODE( p_trigger_id, FND_API.g_miss_num, trigger_id, p_trigger_id),
200: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
201: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 257: DELETE FROM AMS_TRIGGERS

253: PROCEDURE Delete_Row(
254: p_TRIGGER_ID NUMBER)
255: IS
256: BEGIN
257: DELETE FROM AMS_TRIGGERS
258: WHERE TRIGGER_ID = p_TRIGGER_ID;
259: If (SQL%NOTFOUND) then
260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
261: End If;

Line 317: FROM AMS_TRIGGERS

313:
314: IS
315: CURSOR C IS
316: SELECT *
317: FROM AMS_TRIGGERS
318: WHERE TRIGGER_ID = p_TRIGGER_ID
319: FOR UPDATE of TRIGGER_ID NOWAIT;
320: Recinfo C%ROWTYPE;
321: BEGIN

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 453: from ams_triggers B

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
455: );
456:
457: update ams_triggers_tl T set (

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: