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

Line 48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE

44: TYPE t_udt_cols IS TABLE OF r_udt_cols_type
45: INDEX BY BINARY_INTEGER;
46:
47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE

Line 49: ,display_sequence pay_user_rows_f.display_sequence%TYPE

45: INDEX BY BINARY_INTEGER;
46:
47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE
53: );

Line 50: ,row_high_range pay_user_rows_f.row_high_range%TYPE

46:
47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE
53: );
54:

Line 51: ,business_group_id pay_user_rows.business_group_id%TYPE

47: TYPE r_udt_rows_type IS RECORD
48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE
53: );
54:
55: TYPE t_udt_rows IS TABLE OF r_udt_rows_type

Line 52: ,legislation_code pay_user_rows.legislation_code%TYPE

48: (row_low_range_or_name pay_user_rows_f.row_low_range_or_name%TYPE
49: ,display_sequence pay_user_rows_f.display_sequence%TYPE
50: ,row_high_range pay_user_rows_f.row_high_range%TYPE
51: ,business_group_id pay_user_rows.business_group_id%TYPE
52: ,legislation_code pay_user_rows.legislation_code%TYPE
53: );
54:
55: TYPE t_udt_rows IS TABLE OF r_udt_rows_type
56: INDEX BY BINARY_INTEGER;

Line 479: SELECT pay_user_rows_s.NEXTVAL

475: --
476:
477: CURSOR csr_get_next_udt_row_seq
478: IS
479: SELECT pay_user_rows_s.NEXTVAL
480: FROM dual;
481:
482: l_proc_name VARCHAR2(72) := g_package_name || 'create_udt';
483: l_proc_step NUMBER(20,10);

Line 487: l_user_row_id pay_user_rows_f.user_row_id%TYPE;

483: l_proc_step NUMBER(20,10);
484:
485: l_user_table_id pay_user_tables.user_table_id%TYPE;
486: l_user_column_id pay_user_columns.user_column_id%TYPE;
487: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
488: l_udt_rowid rowid ;
489: l_udt_cols_rowid rowid;
490: l_udt_rows_rowid rowid;
491: i number;

Line 568: pay_user_rows_pkg.pre_insert

564: OPEN csr_get_next_udt_row_seq;
565: FETCH csr_get_next_udt_row_seq INTO l_user_row_id;
566: CLOSE csr_get_next_udt_row_seq;
567:
568: pay_user_rows_pkg.pre_insert
569: (p_rowid => l_udt_rows_rowid
570: ,p_user_table_id => l_user_table_id
571: ,p_row_low_range_or_name => p_udt_rows(i).row_low_range_or_name
572: ,p_user_row_id => l_user_row_id

Line 576: INSERT INTO pay_user_rows_f

572: ,p_user_row_id => l_user_row_id
573: ,p_business_group_id => p_business_group_id
574: );
575:
576: INSERT INTO pay_user_rows_f
577: (user_row_id
578: ,effective_start_date
579: ,effective_end_date
580: ,business_group_id

Line 1830: FROM pay_user_rows_f

1826:
1827: CURSOR csr_get_usr_row_id
1828: IS
1829: SELECT user_row_id
1830: FROM pay_user_rows_f
1831: WHERE user_table_id = p_udt_id;
1832:
1833: --
1834: l_proc_step NUMBER(20,10);

Line 1837: l_usr_row_id pay_user_rows.user_row_id%TYPE;

1833: --
1834: l_proc_step NUMBER(20,10);
1835: l_proc_name VARCHAR(72) := g_package_name || 'delete_udt';
1836: l_rowid rowid;
1837: l_usr_row_id pay_user_rows.user_row_id%TYPE;
1838: l_usr_col_id pay_user_columns.user_column_id%TYPE;
1839: --
1840: --
1841: BEGIN

Line 1893: -- Delete pay_user_rows_f for this table id

1889: LOOP
1890: FETCH csr_get_usr_row_id INTO l_usr_row_id;
1891: EXIT WHEN csr_get_usr_row_id%NOTFOUND;
1892:
1893: -- Delete pay_user_rows_f for this table id
1894: l_proc_step := 50;
1895: IF g_debug THEN
1896: debug(l_proc_name, l_proc_step);
1897: END IF;

Line 1900: pay_user_rows_pkg.check_delete_row

1896: debug(l_proc_name, l_proc_step);
1897: END IF;
1898:
1899:
1900: pay_user_rows_pkg.check_delete_row
1901: (p_user_row_id => l_usr_row_id
1902: ,p_validation_start_date => NULL
1903: ,p_dt_delete_mode => 'ZAP'
1904: );

Line 1906: DELETE pay_user_rows_f

1902: ,p_validation_start_date => NULL
1903: ,p_dt_delete_mode => 'ZAP'
1904: );
1905:
1906: DELETE pay_user_rows_f
1907: WHERE user_row_id = l_usr_row_id;
1908:
1909: END LOOP;
1910: CLOSE csr_get_usr_row_id;