APPS.PAY_ETT_SHD dependencies on PAY_ELEMENT_TYPES_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_ELEMENT_TYPES_F_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 54: from pay_element_types_f_tl

50: ,reporting_name
51: ,description
52: ,language
53: ,source_lang
54: from pay_element_types_f_tl
55: where element_type_id = p_element_type_id
56: and language = p_language;
57: --
58: l_fct_ret boolean;

Line 122: from pay_element_types_f_tl

118: ,reporting_name
119: ,description
120: ,language
121: ,source_lang
122: from pay_element_types_f_tl
123: where element_type_id = p_element_type_id
124: and language = p_language
125: for update nowait;
126: --

Line 168: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f_tl');

164: -- The object is locked therefore we need to supply a meaningful
165: -- error message.
166: --
167: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
168: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f_tl');
169: fnd_message.raise_error;
170: End lck;
171: --
172: -- ----------------------------------------------------------------------------

Line 182: delete from PAY_ELEMENT_TYPES_F_TL T

178: -- ----------------------------------------------------------------------------
179: procedure ADD_LANGUAGE
180: is
181: begin
182: delete from PAY_ELEMENT_TYPES_F_TL T
183: where not exists
184: (select NULL
185: from PAY_ELEMENT_TYPES_F B
186: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID

Line 185: from PAY_ELEMENT_TYPES_F B

181: begin
182: delete from PAY_ELEMENT_TYPES_F_TL T
183: where not exists
184: (select NULL
185: from PAY_ELEMENT_TYPES_F B
186: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
187: );
188:
189: update PAY_ELEMENT_TYPES_F_TL T set (

Line 189: update PAY_ELEMENT_TYPES_F_TL T set (

185: from PAY_ELEMENT_TYPES_F B
186: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID
187: );
188:
189: update PAY_ELEMENT_TYPES_F_TL T set (
190: ELEMENT_NAME ) =
191: (select B.ELEMENT_NAME
192: from PAY_ELEMENT_TYPES_F_TL B
193: where B.ELEMENT_TYPE_ID = T.ELEMENT_TYPE_ID

Line 192: from PAY_ELEMENT_TYPES_F_TL B

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

Line 201: from PAY_ELEMENT_TYPES_F_TL SUBB, PAY_ELEMENT_TYPES_F_TL SUBT

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

Line 206: insert into PAY_ELEMENT_TYPES_F_TL (

202: where SUBB.ELEMENT_TYPE_ID = SUBT.ELEMENT_TYPE_ID
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.ELEMENT_NAME <> SUBT.ELEMENT_NAME
205: ));
206: insert into PAY_ELEMENT_TYPES_F_TL (
207: ELEMENT_TYPE_ID,
208: ELEMENT_NAME,
209: REPORTING_NAME,
210: DESCRIPTION,

Line 230: from PAY_ELEMENT_TYPES_F_TL B, FND_LANGUAGES L

226: B.CREATED_BY,
227: B.CREATION_DATE,
228: L.LANGUAGE_CODE,
229: B.SOURCE_LANG
230: from PAY_ELEMENT_TYPES_F_TL B, FND_LANGUAGES L
231: where L.INSTALLED_FLAG in ('I', 'B')
232: and B.LANGUAGE = userenv('LANG')
233: and not exists
234: (select NULL

Line 235: from PAY_ELEMENT_TYPES_F_TL T

231: where L.INSTALLED_FLAG in ('I', 'B')
232: and B.LANGUAGE = userenv('LANG')
233: and not exists
234: (select NULL
235: from PAY_ELEMENT_TYPES_F_TL T
236: where T.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID
237: and T.LANGUAGE = L.LANGUAGE_CODE);
238: end ADD_LANGUAGE;
239: --