APPS.PAY_RTT_SHD dependencies on PAY_RUN_TYPES_F

Line 53: from pay_run_types_f_tl

49: ,language
50: ,source_lang
51: ,run_type_name
52: ,shortname
53: from pay_run_types_f_tl
54: where run_type_id = p_run_type_id
55: and language = p_language;
56: --
57: l_fct_ret boolean;

Line 120: from pay_run_types_f_tl

116: ,language
117: ,source_lang
118: ,run_type_name
119: ,shortname
120: from pay_run_types_f_tl
121: where run_type_id = p_run_type_id
122: and language = p_language
123: for update nowait;
124: --

Line 166: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f_tl');

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

Line 180: delete from PAY_RUN_TYPES_F_TL T

176: -- ----------------------------------------------------------------------------
177: PROCEDURE add_language
178: is
179: begin
180: delete from PAY_RUN_TYPES_F_TL T
181: where not exists
182: (select NULL
183: from PAY_RUN_TYPES_F B
184: where B.RUN_TYPE_ID = T.RUN_TYPE_ID

Line 183: from PAY_RUN_TYPES_F B

179: begin
180: delete from PAY_RUN_TYPES_F_TL T
181: where not exists
182: (select NULL
183: from PAY_RUN_TYPES_F B
184: where B.RUN_TYPE_ID = T.RUN_TYPE_ID
185: );
186:
187: update PAY_RUN_TYPES_F_TL T set (

Line 187: update PAY_RUN_TYPES_F_TL T set (

183: from PAY_RUN_TYPES_F B
184: where B.RUN_TYPE_ID = T.RUN_TYPE_ID
185: );
186:
187: update PAY_RUN_TYPES_F_TL T set (
188: RUN_TYPE_NAME,
189: SHORTNAME
190: ) = (select
191: B.RUN_TYPE_NAME,

Line 193: from PAY_RUN_TYPES_F_TL B

189: SHORTNAME
190: ) = (select
191: B.RUN_TYPE_NAME,
192: B.SHORTNAME
193: from PAY_RUN_TYPES_F_TL B
194: where B.RUN_TYPE_ID = T.RUN_TYPE_ID
195: and B.LANGUAGE = T.SOURCE_LANG)
196: where (
197: T.RUN_TYPE_ID,

Line 202: from PAY_RUN_TYPES_F_TL SUBB, PAY_RUN_TYPES_F_TL SUBT

198: T.LANGUAGE
199: ) in (select
200: SUBT.RUN_TYPE_ID,
201: SUBT.LANGUAGE
202: from PAY_RUN_TYPES_F_TL SUBB, PAY_RUN_TYPES_F_TL SUBT
203: where SUBB.RUN_TYPE_ID = SUBT.RUN_TYPE_ID
204: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
205: and (SUBB.RUN_TYPE_NAME <> SUBT.RUN_TYPE_NAME
206: or (SUBB.RUN_TYPE_NAME is null and SUBT.RUN_TYPE_NAME is not null)

Line 213: insert into PAY_RUN_TYPES_F_TL (

209: or (SUBB.SHORTNAME is null and SUBT.SHORTNAME is not null)
210: or (SUBB.SHORTNAME is not null and SUBT.SHORTNAME is null)
211: ));
212:
213: insert into PAY_RUN_TYPES_F_TL (
214: RUN_TYPE_ID,
215: RUN_TYPE_NAME,
216: SHORTNAME,
217: LAST_UPDATE_DATE,

Line 235: from PAY_RUN_TYPES_F_TL B, FND_LANGUAGES L

231: B.CREATED_BY,
232: B.CREATION_DATE,
233: L.LANGUAGE_CODE,
234: B.SOURCE_LANG
235: from PAY_RUN_TYPES_F_TL B, FND_LANGUAGES L
236: where L.INSTALLED_FLAG in ('I', 'B')
237: and B.LANGUAGE = userenv('LANG')
238: and not exists
239: (select NULL

Line 240: from PAY_RUN_TYPES_F_TL T

236: where L.INSTALLED_FLAG in ('I', 'B')
237: and B.LANGUAGE = userenv('LANG')
238: and not exists
239: (select NULL
240: from PAY_RUN_TYPES_F_TL T
241: where T.RUN_TYPE_ID = B.RUN_TYPE_ID
242: and T.LANGUAGE = L.LANGUAGE_CODE);
243: END add_language;
244: -- ----------------------------------------------------------------------------