APPS.PAY_USER_TABLES_PKG dependencies on PAY_USER_TABLES_TL

Line 147: from PAY_USER_TABLES_TL

143: p_base_user_row_title in varchar2 default hr_api.g_varchar2) is
144:
145: --_TL cursor--
146: cursor T is select *
147: from PAY_USER_TABLES_TL
148: where user_table_id = p_user_table_id
149: and language = userenv('lang')
150: for update NOWAIT ;
151: --

Line 254: from pay_user_tables ut,pay_user_tables_tl utl

250: and p_rowid <> ut.rowid )
251: ) ;
252: cursor c2 is
253: select '1'
254: from pay_user_tables ut,pay_user_tables_tl utl
255: where upper(utl.user_table_name) = upper(p_user_table_name)
256: and utl.user_table_id = ut.user_table_id
257: and nvl(ut.business_group_id,nvl(p_business_group_id, -1))
258: = nvl(p_business_group_id, -1)

Line 261: and (utl.rowid not in ((select rowid from pay_user_tables_tl ptt

257: and nvl(ut.business_group_id,nvl(p_business_group_id, -1))
258: = nvl(p_business_group_id, -1)
259: and nvl(ut.legislation_code, nvl(p_legislation_code,'~~nvl~~'))
260: = nvl(p_legislation_code, '~~nvl~~')
261: and (utl.rowid not in ((select rowid from pay_user_tables_tl ptt
262: where ptt.user_table_id = (select user_table_id from
263: pay_user_tables
264: where rowid = p_rowid)
265: --and language = userenv('lang')

Line 399: delete from PAY_USER_TABLES_TL T

395: --For MLS-----------------------------------------------------------------------
396: procedure ADD_LANGUAGE
397: is
398: begin
399: delete from PAY_USER_TABLES_TL T
400: where not exists
401: (select NULL
402: from PAY_USER_TABLES B
403: where B.USER_TABLE_ID = T.USER_TABLE_ID

Line 405: update PAY_USER_TABLES_TL T set (

401: (select NULL
402: from PAY_USER_TABLES B
403: where B.USER_TABLE_ID = T.USER_TABLE_ID
404: );
405: update PAY_USER_TABLES_TL T set (
406: USER_TABLE_NAME,
407: USER_ROW_TITLE
408: ) = (select
409: B.USER_TABLE_NAME,

Line 411: from PAY_USER_TABLES_TL B

407: USER_ROW_TITLE
408: ) = (select
409: B.USER_TABLE_NAME,
410: B.USER_ROW_TITLE
411: from PAY_USER_TABLES_TL B
412: where B.USER_TABLE_ID = T.USER_TABLE_ID
413: and B.LANGUAGE = T.SOURCE_LANG)
414: where (
415: T.USER_TABLE_ID,

Line 420: from PAY_USER_TABLES_TL SUBB, PAY_USER_TABLES_TL SUBT

416: T.LANGUAGE
417: ) in (select
418: SUBT.USER_TABLE_ID,
419: SUBT.LANGUAGE
420: from PAY_USER_TABLES_TL SUBB, PAY_USER_TABLES_TL SUBT
421: where SUBB.USER_TABLE_ID = SUBT.USER_TABLE_ID
422: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
423: and (SUBB.USER_TABLE_NAME <> SUBT.USER_TABLE_NAME
424: or SUBB.USER_ROW_TITLE <> SUBT.USER_ROW_TITLE

Line 428: insert into PAY_USER_TABLES_TL (

424: or SUBB.USER_ROW_TITLE <> SUBT.USER_ROW_TITLE
425: or (SUBB.USER_ROW_TITLE is null and SUBT.USER_ROW_TITLE is not null)
426: or (SUBB.USER_ROW_TITLE is not null and SUBT.USER_ROW_TITLE is null)
427: ));
428: insert into PAY_USER_TABLES_TL (
429: USER_TABLE_ID,
430: USER_TABLE_NAME,
431: USER_ROW_TITLE,
432: LAST_UPDATE_DATE,

Line 450: from PAY_USER_TABLES_TL B, FND_LANGUAGES L

446: B.CREATED_BY,
447: B.CREATION_DATE,
448: L.LANGUAGE_CODE,
449: B.SOURCE_LANG
450: from PAY_USER_TABLES_TL B, FND_LANGUAGES L
451: where L.INSTALLED_FLAG in ('I', 'B')
452: and B.LANGUAGE = userenv('LANG')
453: and not exists
454: (select NULL

Line 455: from PAY_USER_TABLES_TL T

451: where L.INSTALLED_FLAG in ('I', 'B')
452: and B.LANGUAGE = userenv('LANG')
453: and not exists
454: (select NULL
455: from PAY_USER_TABLES_TL T
456: where T.USER_TABLE_ID = B.USER_TABLE_ID
457: and T.LANGUAGE = L.LANGUAGE_CODE);
458: end ADD_LANGUAGE;
459: --

Line 468: UPDATE PAY_USER_TABLES_tl

464: X_USER_ROW_TITLE in VARCHAR2,
465: X_OWNER in VARCHAR2
466: ) is
467: begin
468: UPDATE PAY_USER_TABLES_tl
469: SET USER_TABLE_NAME = nvl(X_USER_TABLE_NAME,USER_TABLE_NAME),
470: USER_ROW_TITLE = nvl(X_USER_ROW_TITLE,USER_ROW_TITLE),
471: last_update_date = SYSDATE,
472: last_updated_by = decode(x_owner,'SEED',1,0),

Line 515: FROM pay_user_tables_tl ptt,

511: p_user_table_id IN NUMBER,
512: p_bus_grp_id IN NUMBER,
513: p_leg_code IN varchar2) IS
514: SELECT 1
515: FROM pay_user_tables_tl ptt,
516: pay_user_tables put
517: WHERE upper(ptt.user_table_name)=upper(p_user_table_name)
518: AND ptt.user_table_id = put.user_table_id
519: AND ptt.language = p_language