APPS.AME_RTL_SHD dependencies on AME_RULES

Line 21: If (p_constraint_name = 'AME_RULES_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_RULES_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 52: from ame_rules_tl

48: rule_id
49: ,language
50: ,source_lang
51: ,description
52: from ame_rules_tl
53: where rule_id = p_rule_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from ame_rules_tl

114: rule_id
115: ,language
116: ,source_lang
117: ,description
118: from ame_rules_tl
119: where rule_id = p_rule_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'ame_rules_tl');

160: -- The object is locked therefore we need to supply a meaningful
161: -- error message.
162: --
163: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
164: fnd_message.set_token('TABLE_NAME', 'ame_rules_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 181: delete from AME_RULES_TL T

177: -- ----------------------------------------------------------------------------
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from AME_RULES_TL T
182: where not exists
183: (select NULL
184: from AME_RULES B
185: where B.RULE_ID = T.RULE_ID

Line 184: from AME_RULES B

180: begin
181: delete from AME_RULES_TL T
182: where not exists
183: (select NULL
184: from AME_RULES B
185: where B.RULE_ID = T.RULE_ID
186: );
187:
188: update AME_RULES_TL T set (

Line 188: update AME_RULES_TL T set (

184: from AME_RULES B
185: where B.RULE_ID = T.RULE_ID
186: );
187:
188: update AME_RULES_TL T set (
189: DESCRIPTION
190: ) = (select
191: B.DESCRIPTION
192: from AME_RULES_TL B

Line 192: from AME_RULES_TL B

188: update AME_RULES_TL T set (
189: DESCRIPTION
190: ) = (select
191: B.DESCRIPTION
192: from AME_RULES_TL B
193: where B.RULE_ID = T.RULE_ID
194: and B.LANGUAGE = T.SOURCE_LANG)
195: where (
196: T.RULE_ID,

Line 201: from AME_RULES_TL SUBB, AME_RULES_TL SUBT

197: T.LANGUAGE
198: ) in (select
199: SUBT.RULE_ID,
200: SUBT.LANGUAGE
201: from AME_RULES_TL SUBB, AME_RULES_TL SUBT
202: where SUBB.RULE_ID = SUBT.RULE_ID
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
205: ));

Line 207: insert into AME_RULES_TL (

203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
205: ));
206:
207: insert into AME_RULES_TL (
208: RULE_ID,
209: DESCRIPTION,
210: CREATED_BY,
211: CREATION_DATE,

Line 227: from AME_RULES_TL B, FND_LANGUAGES L

223: B.LAST_UPDATE_DATE,
224: B.LAST_UPDATE_LOGIN,
225: L.LANGUAGE_CODE,
226: B.SOURCE_LANG
227: from AME_RULES_TL B, FND_LANGUAGES L
228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL

Line 232: from AME_RULES_TL T

228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL
232: from AME_RULES_TL T
233: where T.RULE_ID = B.RULE_ID
234: and T.LANGUAGE = L.LANGUAGE_CODE);
235: end ADD_LANGUAGE;
236: --