APPS.PAY_BDT_SHD dependencies on PAY_BALANCE_DIMENSIONS

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

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

50: ,source_lang
51: ,dimension_name
52: ,database_item_suffix
53: ,description
54: from pay_balance_dimensions_tl
55: where balance_dimension_id = p_balance_dimension_id
56: and language = p_language;
57: --
58: l_fct_ret boolean;

Line 122: from pay_balance_dimensions_tl

118: ,source_lang
119: ,dimension_name
120: ,database_item_suffix
121: ,description
122: from pay_balance_dimensions_tl
123: where balance_dimension_id = p_balance_dimension_id
124: and language = p_language
125: for update nowait;
126: --

Line 168: fnd_message.set_token('TABLE_NAME', 'pay_balance_dimensions_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_balance_dimensions_tl');
169: fnd_message.raise_error;
170: End lck;
171: --
172: -- ----------------------------------------------------------------------------

Line 177: delete from PAY_BALANCE_DIMENSIONS_TL T

173: -- |----------------------------< add_language >------------------------------|
174: -- ----------------------------------------------------------------------------
175: PROCEDURE add_language IS
176: Begin
177: delete from PAY_BALANCE_DIMENSIONS_TL T
178: where not exists
179: (select NULL
180: from PAY_BALANCE_DIMENSIONS B
181: where B.BALANCE_DIMENSION_ID = T.BALANCE_DIMENSION_ID

Line 180: from PAY_BALANCE_DIMENSIONS B

176: Begin
177: delete from PAY_BALANCE_DIMENSIONS_TL T
178: where not exists
179: (select NULL
180: from PAY_BALANCE_DIMENSIONS B
181: where B.BALANCE_DIMENSION_ID = T.BALANCE_DIMENSION_ID
182: );
183: update PAY_BALANCE_DIMENSIONS_TL T set (
184: DIMENSION_NAME,

Line 183: update PAY_BALANCE_DIMENSIONS_TL T set (

179: (select NULL
180: from PAY_BALANCE_DIMENSIONS B
181: where B.BALANCE_DIMENSION_ID = T.BALANCE_DIMENSION_ID
182: );
183: update PAY_BALANCE_DIMENSIONS_TL T set (
184: DIMENSION_NAME,
185: DESCRIPTION
186: ) = (select
187: B.DIMENSION_NAME,

Line 189: from PAY_BALANCE_DIMENSIONS_TL B

185: DESCRIPTION
186: ) = (select
187: B.DIMENSION_NAME,
188: B.DESCRIPTION
189: from PAY_BALANCE_DIMENSIONS_TL B
190: where B.BALANCE_DIMENSION_ID = T.BALANCE_DIMENSION_ID
191: and B.LANGUAGE = T.SOURCE_LANG)
192: where (
193: T.BALANCE_DIMENSION_ID,

Line 198: from PAY_BALANCE_DIMENSIONS_TL SUBB, PAY_BALANCE_DIMENSIONS_TL SUBT

194: T.LANGUAGE
195: ) in (select
196: SUBT.BALANCE_DIMENSION_ID,
197: SUBT.LANGUAGE
198: from PAY_BALANCE_DIMENSIONS_TL SUBB, PAY_BALANCE_DIMENSIONS_TL SUBT
199: where SUBB.BALANCE_DIMENSION_ID = SUBT.BALANCE_DIMENSION_ID
200: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
201: and (SUBB.DIMENSION_NAME <> SUBT.DIMENSION_NAME
202: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 206: insert into PAY_BALANCE_DIMENSIONS_TL (

202: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
203: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
204: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
205: ));
206: insert into PAY_BALANCE_DIMENSIONS_TL (
207: BALANCE_DIMENSION_ID,
208: DIMENSION_NAME,
209: DATABASE_ITEM_SUFFIX,
210: DESCRIPTION,

Line 230: from PAY_BALANCE_DIMENSIONS_TL B, FND_LANGUAGES L

226: B.CREATED_BY,
227: B.CREATION_DATE,
228: L.LANGUAGE_CODE,
229: B.SOURCE_LANG
230: from PAY_BALANCE_DIMENSIONS_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_BALANCE_DIMENSIONS_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_BALANCE_DIMENSIONS_TL T
236: where T.BALANCE_DIMENSION_ID = B.BALANCE_DIMENSION_ID
237: and T.LANGUAGE = L.LANGUAGE_CODE);
238: End add_language;
239: --