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_TABLES_PKG dependencies on PAY_USER_TABLES

Line 1: PACKAGE BODY PAY_USER_TABLES_PKG AS

1: PACKAGE BODY PAY_USER_TABLES_PKG AS
2: /* $Header: pyust01t.pkb 120.2 2006/05/12 02:45:59 snekkala noship $ */
3: --
4: g_dummy number(1); -- Dummy for cursor returns which are not needed
5: --

Line 16: select pay_user_tables_s.nextval

12: p_user_key_units in varchar2,
13: p_user_table_name in varchar2,
14: p_user_row_title in varchar2 ) is
15: cursor c1 is
16: select pay_user_tables_s.nextval
17: from sys.dual ;
18: --
19: cursor c2 is
20: select rowid

Line 21: from pay_user_tables

17: from sys.dual ;
18: --
19: cursor c2 is
20: select rowid
21: from pay_user_tables
22: where user_table_id = p_user_table_id ;
23: --
24: begin
25: --

Line 36: insert into PAY_USER_TABLES

32: open c1 ;
33: fetch c1 into p_user_table_id ;
34: close c1 ;
35: --
36: insert into PAY_USER_TABLES
37: ( USER_TABLE_ID,
38: BUSINESS_GROUP_ID,
39: LEGISLATION_CODE,
40: LEGISLATION_SUBGROUP,

Line 90: update PAY_USER_TABLES

86: p_business_group_id => p_business_group_id,
87: p_legislation_code => p_legislation_code,
88: p_base_user_table_name => p_base_user_table_name) ;
89: --
90: update PAY_USER_TABLES
91: set USER_TABLE_ID = p_user_table_id,
92: BUSINESS_GROUP_ID = p_business_group_id ,
93: LEGISLATION_CODE = p_legislation_code,
94: LEGISLATION_SUBGROUP = p_legislation_subgroup ,

Line 124: delete from PAY_USER_TABLES

120: pay_ptt_del.del_tl(p_user_table_id);
121: --------------------------------------------------------------------------------
122: g_dml_status := FALSE;
123: --
124: delete from PAY_USER_TABLES
125: where ROWID = p_rowid;
126: --
127: Exception
128: When Others then

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 156: from PAY_USER_TABLES

152: tlrowinfo T%rowtype;
153: --
154: --
155: cursor C is select *
156: from PAY_USER_TABLES
157: where rowid = p_rowid
158: for update of USER_TABLE_ID NOWAIT ;
159: --
160: rowinfo C%rowtype;

Line 242: from pay_user_tables ut

238: p_legislation_code in varchar2,
239: p_base_user_table_name in varchar2 default hr_api.g_varchar2) is
240: cursor c1 is
241: select '1'
242: from pay_user_tables ut
243: where upper(ut.user_table_name) = upper(p_base_user_table_name)
244: and nvl(ut.business_group_id,nvl(p_business_group_id, -1))
245: = nvl(p_business_group_id, -1)
246: and nvl(ut.legislation_code, nvl(p_legislation_code,'~~nvl~~'))

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 263: pay_user_tables

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')
266: )));
267: l_dummy varchar2(1) ;

Line 330: l_package_name VARCHAR2(80) := 'PAY_USER_TABLES_PKG.CHECK_UPDATE';

326: --
327:
328: procedure check_base_update(p_base_user_table_name in varchar2,
329: p_rowid in varchar2) is
330: l_package_name VARCHAR2(80) := 'PAY_USER_TABLES_PKG.CHECK_UPDATE';
331: original_user_table_name varchar2(80);
332: begin
333: select base_user_table_name into original_user_table_name
334: from pay_user_tables_vl

Line 334: from pay_user_tables_vl

330: l_package_name VARCHAR2(80) := 'PAY_USER_TABLES_PKG.CHECK_UPDATE';
331: original_user_table_name varchar2(80);
332: begin
333: select base_user_table_name into original_user_table_name
334: from pay_user_tables_vl
335: where row_id = p_rowid;
336: if(p_base_user_table_name <> original_user_table_name) then
337: hr_utility.set_location (l_package_name,1);
338: fnd_message.set_name ('PER','PER_52480_SSM_NON_UPD_FIELD'); -- checkformat failure

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 402: from PAY_USER_TABLES B

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
404: );
405: update PAY_USER_TABLES_TL T set (
406: USER_TABLE_NAME,

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 478: from PAY_USER_TABLES

474: source_lang = userenv('LANG')
475: WHERE userenv('LANG') IN (language,source_lang)
476: AND USER_TABLE_ID in
477: (select USER_TABLE_ID
478: from PAY_USER_TABLES
479: where nvl(USER_TABLE_NAME,'~null~')=nvl(X_B_USER_TABLE_NAME,'~null~')
480: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_B_LEGISLATION_CODE,'~null~')
481: and BUSINESS_GROUP_ID is NULL);
482: if (sql%notfound) then

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

Line 516: pay_user_tables put

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
520: AND (put.user_table_id <> p_user_table_id OR p_user_table_id IS NULL)

Line 529: l_package_name := 'PAY_USER_TABLES_PKG.VALIDATE_TRANSLATION';

525: l_business_group_id NUMBER;
526: l_legislation_code VARCHAR2(150);
527:
528: BEGIN
529: l_package_name := 'PAY_USER_TABLES_PKG.VALIDATE_TRANSLATION';
530: l_business_group_id := p_business_group_id;
531: l_legislation_code := p_legislation_code;
532: hr_utility.set_location (l_package_name,10);
533: OPEN c_translation(language, user_table_name,user_table_id,

Line 558: END PAY_USER_TABLES_PKG;

554: begin
555: return g_dml_status;
556: end return_dml_status;
557: --
558: END PAY_USER_TABLES_PKG;