APPS.PAY_URT_SHD dependencies on PAY_USER_ROWS_F_TL

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

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

48: user_row_id
49: ,language
50: ,source_lang
51: ,row_low_range_or_name
52: from pay_user_rows_f_tl
53: where user_row_id = p_user_row_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from pay_user_rows_f_tl

114: user_row_id
115: ,language
116: ,source_lang
117: ,row_low_range_or_name
118: from pay_user_rows_f_tl
119: where user_row_id = p_user_row_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'pay_user_rows_f_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', 'pay_user_rows_f_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: PROCEDURE add_language IS

Line 170: delete from PAY_USER_ROWS_F_TL T

166: End lck;
167: --
168: PROCEDURE add_language IS
169: Begin
170: delete from PAY_USER_ROWS_F_TL T
171: where not exists
172: (select NULL
173: from PAY_USER_ROWS_F B
174: where B.USER_ROW_ID = T.USER_ROW_ID

Line 177: update PAY_USER_ROWS_F_TL T set (

173: from PAY_USER_ROWS_F B
174: where B.USER_ROW_ID = T.USER_ROW_ID
175: );
176:
177: update PAY_USER_ROWS_F_TL T set (
178: ROW_LOW_RANGE_OR_NAME
179: ) = (select
180: B.ROW_LOW_RANGE_OR_NAME
181: from PAY_USER_ROWS_F_TL B

Line 181: from PAY_USER_ROWS_F_TL B

177: update PAY_USER_ROWS_F_TL T set (
178: ROW_LOW_RANGE_OR_NAME
179: ) = (select
180: B.ROW_LOW_RANGE_OR_NAME
181: from PAY_USER_ROWS_F_TL B
182: where B.USER_ROW_ID = T.USER_ROW_ID
183: and B.LANGUAGE = T.SOURCE_LANG)
184: where (
185: T.USER_ROW_ID,

Line 190: from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT

186: T.LANGUAGE
187: ) in (select
188: SUBT.USER_ROW_ID,
189: SUBT.LANGUAGE
190: from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT
191: where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
192: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
193: and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME));
194:

Line 195: insert into PAY_USER_ROWS_F_TL (

191: where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
192: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
193: and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME));
194:
195: insert into PAY_USER_ROWS_F_TL (
196: USER_ROW_ID,
197: ROW_LOW_RANGE_OR_NAME,
198: LAST_UPDATE_DATE,
199: LAST_UPDATED_BY,

Line 215: from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L

211: B.CREATED_BY,
212: B.CREATION_DATE,
213: L.LANGUAGE_CODE,
214: B.SOURCE_LANG
215: from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and B.LANGUAGE = userenv('LANG')
218: and not exists
219: (select NULL

Line 220: from PAY_USER_ROWS_F_TL T

216: where L.INSTALLED_FLAG in ('I', 'B')
217: and B.LANGUAGE = userenv('LANG')
218: and not exists
219: (select NULL
220: from PAY_USER_ROWS_F_TL T
221: where T.USER_ROW_ID = B.USER_ROW_ID
222: and T.LANGUAGE = L.LANGUAGE_CODE);
223: End add_language;
224: --