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_ROWS_PKG dependencies on PAY_USER_ROWS

Line 1: PACKAGE BODY PAY_USER_ROWS_PKG AS

1: PACKAGE BODY PAY_USER_ROWS_PKG AS
2: /* $Header: pyusr01t.pkb 120.1 2005/07/29 05:09:07 shisriva noship $ */
3:
4: --
5: g_dummy number(1); -- Dummy for cursor returns which are not needed

Line 25: from pay_user_rows_f usr

21: p_validation_end_date in date) is
22:
23: cursor c1 is
24: select '1'
25: from pay_user_rows_f usr
26: where usr.user_table_id = p_user_table_id
27: and upper(usr.row_low_range_or_name) = upper(p_row_low_range_or_name)
28: and ( p_rowid is null
29: or ( p_rowid is not null and usr.user_row_id <> p_user_row_id ) )

Line 58: -- changed following cursor to reference table instead of view pay_user_rows

54: p_row_low_range_or_name in varchar2,
55: p_business_group_id in number ) is
56: --
57: -- JBARKER, bug #2608226
58: -- changed following cursor to reference table instead of view pay_user_rows
59: -- to remove date comparison
60: --
61: cursor c1 is
62: select '1'

Line 63: from pay_user_rows_f usr

59: -- to remove date comparison
60: --
61: cursor c1 is
62: select '1'
63: from pay_user_rows_f usr
64: where usr.user_table_id = p_user_table_id
65: and upper(usr.row_low_range_or_name) = upper(p_row_low_range_or_name)
66: and ( p_rowid is null
67: or ( p_rowid is not null and usr.user_row_id <> p_user_row_id ) )

Line 102: from pay_user_rows_f usr

98: p_validation_end_date in date) is
99: --
100: cursor csr_row_overlap is
101: select '1'
102: from pay_user_rows_f usr
103: where usr.user_table_id = p_user_table_id
104: and (usr.business_group_id is null
105: or (usr.business_group_id = p_business_group_id))
106: and ((usr.effective_start_date between p_validation_start_date and p_validation_end_date)

Line 148: from pay_user_rows usr

144: p_business_group_id in number) is
145: --
146: cursor csr_row_overlap is
147: select '1'
148: from pay_user_rows usr
149: where usr.user_table_id = p_user_table_id
150: and (usr.business_group_id is null
151: or (usr.business_group_id = p_business_group_id))
152: and (p_rowid is null

Line 184: from pay_user_rows_f usr

180: p_business_group_id in number)return date is
181: --
182: cursor csr_new_end_date is
183: select (min(usr.effective_start_date)-1)
184: from pay_user_rows_f usr
185: where usr.user_table_id = p_user_table_id
186: and (usr.business_group_id is null
187: or (usr.business_group_id = p_business_group_id))
188: and usr.effective_start_date > p_effective_start_date

Line 220: from pay_user_rows_f usr

216: p_business_group_id in number) return date is
217: --
218: cursor csr_new_match_end is
219: select (min(usr.effective_start_date)-1)
220: from pay_user_rows_f usr
221: where usr.user_table_id = p_user_table_id
222: and (usr.business_group_id is null
223: or (usr.business_group_id = p_business_group_id))
224: and usr.effective_start_date > p_effective_start_date

Line 263: from pay_user_rows_f usr

259: p_validation_end_date in date)return boolean is
260: --
261: cursor csr_rows_exist is
262: select '1'
263: from pay_user_rows_f usr
264: where usr.user_table_id = p_user_table_id
265: and (usr.business_group_id is null
266: or (usr.business_group_id = p_business_group_id))
267:

Line 307: from pay_user_rows_f usr

303: p_business_group_id in number)return boolean is
304: --
305: cursor csr_rows_exist is
306: select '1'
307: from pay_user_rows_f usr
308: where usr.user_table_id = p_user_table_id
309: and (usr.business_group_id is null
310: or (usr.business_group_id = p_business_group_id))
311: and usr.effective_start_date > p_effective_start_date

Line 344: from pay_user_rows_f usr

340: p_business_group_id in number) return boolean is
341: --
342: cursor csr_matches_exist is
343: select '1'
344: from pay_user_rows_f usr
345: where usr.user_table_id = p_user_table_id
346: and (usr.business_group_id is null
347: or (usr.business_group_id = p_business_group_id))
348: and usr.effective_start_date > p_effective_start_date

Line 371: select pay_user_rows_s.nextval

367:
368: --
369: procedure get_seq ( p_user_row_id in out NOCOPY number ) is
370: cursor c1 is
371: select pay_user_rows_s.nextval
372: from dual ;
373: begin
374: --
375: open c1 ;

Line 463: app_exception.invalid_argument('pay_user_rows_pkg.check_delete_row',

459: check_dt_zap_row ( p_user_row_id ) ;
460: elsif p_dt_delete_mode = 'DELETE' then
461: check_dt_delete_row( p_user_row_id , p_validation_start_date ) ;
462: else
463: app_exception.invalid_argument('pay_user_rows_pkg.check_delete_row',
464: 'p_dt_delete_mode',
465: p_dt_delete_mode ) ;
466: end if ;
467: --

Line 474: delete from PAY_USER_ROWS_F_TL T

470: --For MLS-----------------------------------------------------------------------
471: procedure ADD_LANGUAGE
472: is
473: begin
474: delete from PAY_USER_ROWS_F_TL T
475: where not exists
476: (select NULL
477: from PAY_USER_ROWS_F B
478: where B.USER_ROW_ID = T.USER_ROW_ID

Line 477: from PAY_USER_ROWS_F B

473: begin
474: delete from PAY_USER_ROWS_F_TL T
475: where not exists
476: (select NULL
477: from PAY_USER_ROWS_F B
478: where B.USER_ROW_ID = T.USER_ROW_ID
479: );
480: update PAY_USER_ROWS_F_TL T
481: set (ROW_LOW_RANGE_OR_NAME) =

Line 480: update PAY_USER_ROWS_F_TL T

476: (select NULL
477: from PAY_USER_ROWS_F B
478: where B.USER_ROW_ID = T.USER_ROW_ID
479: );
480: update PAY_USER_ROWS_F_TL T
481: set (ROW_LOW_RANGE_OR_NAME) =
482: (select B.ROW_LOW_RANGE_OR_NAME
483: from PAY_USER_ROWS_F_TL B
484: where B.USER_ROW_ID = T.USER_ROW_ID

Line 483: from PAY_USER_ROWS_F_TL B

479: );
480: update PAY_USER_ROWS_F_TL T
481: set (ROW_LOW_RANGE_OR_NAME) =
482: (select B.ROW_LOW_RANGE_OR_NAME
483: from PAY_USER_ROWS_F_TL B
484: where B.USER_ROW_ID = T.USER_ROW_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (T.USER_ROW_ID,T.LANGUAGE) in
487: (select SUBT.USER_ROW_ID,SUBT.LANGUAGE

Line 488: from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT

484: where B.USER_ROW_ID = T.USER_ROW_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (T.USER_ROW_ID,T.LANGUAGE) in
487: (select SUBT.USER_ROW_ID,SUBT.LANGUAGE
488: from PAY_USER_ROWS_F_TL SUBB, PAY_USER_ROWS_F_TL SUBT
489: where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
490: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
491: and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME
492: ));

Line 493: insert into PAY_USER_ROWS_F_TL (

489: where SUBB.USER_ROW_ID = SUBT.USER_ROW_ID
490: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
491: and (SUBB.ROW_LOW_RANGE_OR_NAME <> SUBT.ROW_LOW_RANGE_OR_NAME
492: ));
493: insert into PAY_USER_ROWS_F_TL (
494: USER_ROW_ID,
495: ROW_LOW_RANGE_OR_NAME,
496: LAST_UPDATE_DATE,
497: LAST_UPDATED_BY,

Line 513: from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L

509: B.CREATED_BY,
510: B.CREATION_DATE,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from PAY_USER_ROWS_F_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from PAY_USER_ROWS_F_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from PAY_USER_ROWS_F_TL T
519: where T.USER_ROW_ID = B.USER_ROW_ID
520: and T.LANGUAGE = L.LANGUAGE_CODE);
521: end ADD_LANGUAGE;
522: --

Line 530: UPDATE PAY_USER_ROWS_F_TL

526: X_ROW_LOW_RANGE_OR_NAME in VARCHAR2,
527: X_OWNER in VARCHAR2
528: ) is
529: begin
530: UPDATE PAY_USER_ROWS_F_TL
531: SET ROW_LOW_RANGE_OR_NAME = nvl(X_ROW_LOW_RANGE_OR_NAME,ROW_LOW_RANGE_OR_NAME),
532: last_update_date = SYSDATE,
533: last_updated_by = decode(x_owner,'SEED',1,0),
534: last_update_login = 0,

Line 539: from PAY_USER_ROWS_F

535: source_lang = userenv('LANG')
536: WHERE userenv('LANG') IN (language,source_lang)
537: AND USER_ROW_ID in
538: (select USER_ROW_ID
539: from PAY_USER_ROWS_F
540: where nvl(ROW_LOW_RANGE_OR_NAME,'~null~')=nvl(X_B_ROW_LOW_RANGE_OR_NAME,'~null~')
541: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_B_LEGISLATION_CODE,'~null~')
542: and BUSINESS_GROUP_ID is NULL);
543: if (sql%notfound) then

Line 584: from pay_user_rows_f pur,

580: p_user_table_id IN NUMBER,
581: p_bus_grp_id IN NUMBER,
582: p_leg_code IN varchar2) IS
583: select '1'
584: from pay_user_rows_f pur,
585: pay_user_rows_f_tl urt
586: where upper(urt.row_low_range_or_name) = upper(p_row_low_range_or_name)
587: AND pur.user_row_id = urt.user_row_id
588: AND (urt.user_row_id <> p_user_row_id OR p_user_row_id IS NULL)

Line 585: pay_user_rows_f_tl urt

581: p_bus_grp_id IN NUMBER,
582: p_leg_code IN varchar2) IS
583: select '1'
584: from pay_user_rows_f pur,
585: pay_user_rows_f_tl urt
586: where upper(urt.row_low_range_or_name) = upper(p_row_low_range_or_name)
587: AND pur.user_row_id = urt.user_row_id
588: AND (urt.user_row_id <> p_user_row_id OR p_user_row_id IS NULL)
589: AND pur.user_table_id = p_user_table_id

Line 600: l_package_name := 'PAY_user_rowS_PKG.VALIDATE_TRANSLATION';

596: l_legislation_code VARCHAR2(150);
597:
598:
599: BEGIN
600: l_package_name := 'PAY_user_rowS_PKG.VALIDATE_TRANSLATION';
601: l_business_group_id := p_business_group_id;
602: l_legislation_code := p_legislation_code;
603: hr_utility.set_location (l_package_name,10);
604: OPEN c_translation(language, row_low_range_or_name,user_row_id,g_user_table_id,

Line 625: END PAY_USER_ROWS_PKG;

621: --
622:
623: --------------------------------------------------------------------------
624: --
625: END PAY_USER_ROWS_PKG;