APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_USER_TABLES

Line 485: l_user_table_id pay_user_tables.user_table_id%TYPE;

481:
482: l_proc_name VARCHAR2(72) := g_package_name || 'create_udt';
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;

Line 508: pay_user_tables_pkg.insert_row

504: debug(l_proc_name, l_proc_step);
505: END IF;
506:
507:
508: pay_user_tables_pkg.insert_row
509: (p_rowid => l_udt_rowid
510: ,p_user_table_id => l_user_table_id
511: ,p_business_group_id => p_business_group_id
512: ,p_legislation_code => NULL

Line 1817: FROM pay_user_tables

1813:
1814: CURSOR csr_get_usr_table_id
1815: IS
1816: SELECT rowid
1817: FROM pay_user_tables
1818: WHERE user_table_id = p_udt_id
1819: AND business_group_id = p_business_group_id;
1820:
1821: CURSOR csr_get_usr_col_id

Line 1847: -- Get user_table_id from pay_user_tables

1843: --
1844: debug ('Entering '||l_proc_name, 10);
1845: --
1846:
1847: -- Get user_table_id from pay_user_tables
1848: OPEN csr_get_usr_table_id;
1849: FETCH csr_get_usr_table_id INTO l_rowid;
1850:
1851: IF csr_get_usr_table_id%FOUND THEN

Line 1913: -- Delete pay_user_tables for this table id

1909: END LOOP;
1910: CLOSE csr_get_usr_row_id;
1911:
1912:
1913: -- Delete pay_user_tables for this table id
1914: l_proc_step := 60;
1915: IF g_debug THEN
1916: debug(l_proc_name, l_proc_step);
1917: END IF;

Line 1919: pay_user_tables_pkg.delete_row

1915: IF g_debug THEN
1916: debug(l_proc_name, l_proc_step);
1917: END IF;
1918:
1919: pay_user_tables_pkg.delete_row
1920: (p_rowid => l_rowid
1921: ,p_user_table_id => p_udt_id
1922: );
1923:

Line 1955: l_entudt_id pay_user_tables.user_table_id%TYPE;

1951: l_proc_step NUMBER(20,10);
1952: l_proc_name varchar2(72) := g_package_name || 'delete_user_template';
1953: l_eei_info_id number;
1954: l_ovn_eei number;
1955: l_entudt_id pay_user_tables.user_table_id%TYPE;
1956: l_caludt_id pay_user_tables.user_table_id%TYPE;
1957: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1958: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1959: l_exists VARCHAR2(1);

Line 1956: l_caludt_id pay_user_tables.user_table_id%TYPE;

1952: l_proc_name varchar2(72) := g_package_name || 'delete_user_template';
1953: l_eei_info_id number;
1954: l_ovn_eei number;
1955: l_entudt_id pay_user_tables.user_table_id%TYPE;
1956: l_caludt_id pay_user_tables.user_table_id%TYPE;
1957: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1958: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1959: l_exists VARCHAR2(1);
1960: l_element_type_id pay_element_types_f.element_type_id%TYPE;