eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_USER_COLUMNS_PKG dependencies on PAY_USER_COLUMNS_TL

Line 129: from PAY_USER_COLUMNS_TL

125: p_formula_id in number,
126: p_base_user_column_name in varchar2 default hr_api.g_varchar2) is
127: --_TL cursor--
128: cursor T is select *
129: from PAY_USER_COLUMNS_TL
130: where user_column_id = p_user_column_id
131: and language = userenv('lang')
132: for update NOWAIT ;
133: --

Line 254: from pay_user_columns uc,pay_user_columns_tl ucl

250:
251: --_TL cursor
252: cursor c2 is
253: select '1'
254: from pay_user_columns uc,pay_user_columns_tl ucl
255: where upper(ucl.user_column_name) = upper(p_user_column_name)
256: and ucl.user_column_id = uc.user_column_id
257: and uc.user_table_id = p_user_table_id
258: and nvl(uc.business_group_id,nvl(p_business_group_id, -1))

Line 262: and (ucl.rowid not in ((select rowid from pay_user_columns_tl pct

258: and nvl(uc.business_group_id,nvl(p_business_group_id, -1))
259: = nvl(p_business_group_id, -1)
260: and nvl(uc.legislation_code, nvl(p_legislation_code,'~~nvl~~'))
261: = nvl(p_legislation_code, '~~nvl~~')
262: and (ucl.rowid not in ((select rowid from pay_user_columns_tl pct
263: where pct.user_column_id = (select user_column_id from
264: pay_user_columns
265: where rowid = p_rowid)
266: --and language = userenv('lang')

Line 340: delete from PAY_USER_COLUMNS_TL T

336:
337: procedure ADD_LANGUAGE
338: is
339: begin
340: delete from PAY_USER_COLUMNS_TL T
341: where not exists
342: (select NULL
343: from PAY_USER_COLUMNS B
344: where B.USER_COLUMN_ID = T.USER_COLUMN_ID

Line 346: update PAY_USER_COLUMNS_TL T

342: (select NULL
343: from PAY_USER_COLUMNS B
344: where B.USER_COLUMN_ID = T.USER_COLUMN_ID
345: );
346: update PAY_USER_COLUMNS_TL T
347: set (USER_COLUMN_NAME) =
348: (select B.USER_COLUMN_NAME
349: from PAY_USER_COLUMNS_TL B
350: where B.USER_COLUMN_ID = T.USER_COLUMN_ID

Line 349: from PAY_USER_COLUMNS_TL B

345: );
346: update PAY_USER_COLUMNS_TL T
347: set (USER_COLUMN_NAME) =
348: (select B.USER_COLUMN_NAME
349: from PAY_USER_COLUMNS_TL B
350: where B.USER_COLUMN_ID = T.USER_COLUMN_ID
351: and B.LANGUAGE = T.SOURCE_LANG)
352: where (T.USER_COLUMN_ID,T.LANGUAGE) in
353: (select SUBT.USER_COLUMN_ID,SUBT.LANGUAGE

Line 354: from PAY_USER_COLUMNS_TL SUBB, PAY_USER_COLUMNS_TL SUBT

350: where B.USER_COLUMN_ID = T.USER_COLUMN_ID
351: and B.LANGUAGE = T.SOURCE_LANG)
352: where (T.USER_COLUMN_ID,T.LANGUAGE) in
353: (select SUBT.USER_COLUMN_ID,SUBT.LANGUAGE
354: from PAY_USER_COLUMNS_TL SUBB, PAY_USER_COLUMNS_TL SUBT
355: where SUBB.USER_COLUMN_ID = SUBT.USER_COLUMN_ID
356: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
357: and (SUBB.USER_COLUMN_NAME <> SUBT.USER_COLUMN_NAME
358: ));

Line 360: insert into PAY_USER_COLUMNS_TL (

356: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
357: and (SUBB.USER_COLUMN_NAME <> SUBT.USER_COLUMN_NAME
358: ));
359:
360: insert into PAY_USER_COLUMNS_TL (
361: USER_COLUMN_ID,
362: USER_COLUMN_NAME,
363: LAST_UPDATE_DATE,
364: LAST_UPDATED_BY,

Line 380: from PAY_USER_COLUMNS_TL B, FND_LANGUAGES L

376: B.CREATED_BY,
377: B.CREATION_DATE,
378: L.LANGUAGE_CODE,
379: B.SOURCE_LANG
380: from PAY_USER_COLUMNS_TL B, FND_LANGUAGES L
381: where L.INSTALLED_FLAG in ('I', 'B')
382: and B.LANGUAGE = userenv('LANG')
383: and not exists
384: (select NULL

Line 385: from PAY_USER_COLUMNS_TL T

381: where L.INSTALLED_FLAG in ('I', 'B')
382: and B.LANGUAGE = userenv('LANG')
383: and not exists
384: (select NULL
385: from PAY_USER_COLUMNS_TL T
386: where T.USER_COLUMN_ID = B.USER_COLUMN_ID
387: and T.LANGUAGE = L.LANGUAGE_CODE);
388: end ADD_LANGUAGE;
389: --

Line 397: UPDATE PAY_USER_COLUMNS_TL

393: X_USER_COLUMN_NAME in VARCHAR2,
394: X_OWNER in VARCHAR2
395: ) is
396: begin
397: UPDATE PAY_USER_COLUMNS_TL
398: SET USER_COLUMN_NAME = nvl(X_USER_COLUMN_NAME,USER_COLUMN_NAME),
399: last_update_date = SYSDATE,
400: last_updated_by = decode(x_owner,'SEED',1,0),
401: last_update_login = 0,

Line 454: pay_user_columns_tl ucl

450: p_bus_grp_id IN NUMBER,
451: p_leg_code IN varchar2) IS
452: select '1'
453: from pay_user_columns uc,
454: pay_user_columns_tl ucl
455: where upper(ucl.user_column_name) = upper(p_user_column_name)
456: AND uc.user_column_id = ucl.user_column_id
457: AND (ucl.user_column_id <> p_user_column_id OR p_user_column_id IS NULL)
458: AND uc.user_table_id = p_user_table_id