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.PQP_GB_OMP_TEMPLATE dependencies on PAY_USER_ROWS

Line 177: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE

173:
174: l_udt_cols t_udt_cols;
175:
176: TYPE r_udt_rows_type IS RECORD
177: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
178: ,display_sequence pay_user_rows_f.display_sequence%TYPE
179: ,row_high_range pay_user_rows_f.row_high_range%TYPE
180: ,business_group_id pay_user_rows.business_group_id%TYPE
181: ,legislation_code pay_user_rows.legislation_code%TYPE

Line 178: ,display_sequence pay_user_rows_f.display_sequence%TYPE

174: l_udt_cols t_udt_cols;
175:
176: TYPE r_udt_rows_type IS RECORD
177: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
178: ,display_sequence pay_user_rows_f.display_sequence%TYPE
179: ,row_high_range pay_user_rows_f.row_high_range%TYPE
180: ,business_group_id pay_user_rows.business_group_id%TYPE
181: ,legislation_code pay_user_rows.legislation_code%TYPE
182: );

Line 179: ,row_high_range pay_user_rows_f.row_high_range%TYPE

175:
176: TYPE r_udt_rows_type IS RECORD
177: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
178: ,display_sequence pay_user_rows_f.display_sequence%TYPE
179: ,row_high_range pay_user_rows_f.row_high_range%TYPE
180: ,business_group_id pay_user_rows.business_group_id%TYPE
181: ,legislation_code pay_user_rows.legislation_code%TYPE
182: );
183:

Line 180: ,business_group_id pay_user_rows.business_group_id%TYPE

176: TYPE r_udt_rows_type IS RECORD
177: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
178: ,display_sequence pay_user_rows_f.display_sequence%TYPE
179: ,row_high_range pay_user_rows_f.row_high_range%TYPE
180: ,business_group_id pay_user_rows.business_group_id%TYPE
181: ,legislation_code pay_user_rows.legislation_code%TYPE
182: );
183:
184: TYPE t_udt_rows IS TABLE OF r_udt_rows_type

Line 181: ,legislation_code pay_user_rows.legislation_code%TYPE

177: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
178: ,display_sequence pay_user_rows_f.display_sequence%TYPE
179: ,row_high_range pay_user_rows_f.row_high_range%TYPE
180: ,business_group_id pay_user_rows.business_group_id%TYPE
181: ,legislation_code pay_user_rows.legislation_code%TYPE
182: );
183:
184: TYPE t_udt_rows IS TABLE OF r_udt_rows_type
185: INDEX BY BINARY_INTEGER;

Line 527: SELECT pay_user_rows_s.NEXTVAL

523: --
524:
525: CURSOR csr_get_next_udt_row_seq
526: IS
527: SELECT pay_user_rows_s.NEXTVAL
528: FROM dual;
529:
530: l_proc_name VARCHAR2(72) := g_proc_name || 'create_udt';
531: l_user_table_id pay_user_tables.user_table_id%TYPE;

Line 533: l_user_row_id pay_user_rows_f.user_row_id%TYPE;

529:
530: l_proc_name VARCHAR2(72) := g_proc_name || 'create_udt';
531: l_user_table_id pay_user_tables.user_table_id%TYPE;
532: l_user_column_id pay_user_columns.user_column_id%TYPE;
533: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
534: l_udt_rowid rowid ;
535: l_udt_cols_rowid rowid;
536: l_udt_rows_rowid rowid;
537:

Line 601: pay_user_rows_pkg.pre_insert

597: OPEN csr_get_next_udt_row_seq;
598: FETCH csr_get_next_udt_row_seq INTO l_user_row_id;
599: CLOSE csr_get_next_udt_row_seq;
600:
601: pay_user_rows_pkg.pre_insert
602: (p_rowid => l_udt_rows_rowid
603: ,p_user_table_id => l_user_table_id
604: ,p_row_low_range_or_name => p_udt_rows(i).row_low_range_or_name
605: ,p_user_row_id => l_user_row_id

Line 609: INSERT INTO pay_user_rows_f

605: ,p_user_row_id => l_user_row_id
606: ,p_business_group_id => p_bg_id
607: );
608:
609: INSERT INTO pay_user_rows_f
610: (user_row_id
611: ,effective_start_date
612: ,effective_end_date
613: ,business_group_id

Line 1989: FROM pay_user_rows_f

1985: WHERE user_table_id = p_udt_id;
1986:
1987: CURSOR csr_get_usr_row_id IS
1988: SELECT user_row_id
1989: FROM pay_user_rows_f
1990: WHERE user_table_id = p_udt_id;
1991:
1992: --
1993: l_proc_name VARCHAR(72) := g_proc_name || 'delete_udt';

Line 1995: l_usr_row_id pay_user_rows.user_row_id%TYPE;

1991:
1992: --
1993: l_proc_name VARCHAR(72) := g_proc_name || 'delete_udt';
1994: l_rowid rowid;
1995: l_usr_row_id pay_user_rows.user_row_id%TYPE;
1996: l_usr_col_id pay_user_columns.user_column_id%TYPE;
1997: --
1998: --
1999: BEGIN

Line 2039: -- Delete pay_user_rows_f for this table id

2035: LOOP
2036: FETCH csr_get_usr_row_id INTO l_usr_row_id;
2037: EXIT WHEN csr_get_usr_row_id%NOTFOUND;
2038:
2039: -- Delete pay_user_rows_f for this table id
2040: hr_utility.set_location (l_proc_name, 50);
2041:
2042: pay_user_rows_pkg.check_delete_row
2043: (p_user_row_id => l_usr_row_id

Line 2042: pay_user_rows_pkg.check_delete_row

2038:
2039: -- Delete pay_user_rows_f for this table id
2040: hr_utility.set_location (l_proc_name, 50);
2041:
2042: pay_user_rows_pkg.check_delete_row
2043: (p_user_row_id => l_usr_row_id
2044: ,p_validation_start_date => NULL
2045: ,p_dt_delete_mode => 'ZAP'
2046: );

Line 2048: DELETE pay_user_rows_f

2044: ,p_validation_start_date => NULL
2045: ,p_dt_delete_mode => 'ZAP'
2046: );
2047:
2048: DELETE pay_user_rows_f
2049: WHERE user_row_id = l_usr_row_id;
2050:
2051: END LOOP;
2052: CLOSE csr_get_usr_row_id;