APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_USER_COLUMNS

Line 38: (user_column_name pay_user_columns.user_column_name%TYPE

34: ,user_row_title VARCHAR2(80)
35: );
36:
37: TYPE r_udt_cols_type IS RECORD
38: (user_column_name pay_user_columns.user_column_name%TYPE
39: ,formula_id pay_user_columns.formula_id%TYPE
40: ,business_group_id pay_user_columns.business_group_id%TYPE
41: ,legislation_code pay_user_columns.legislation_code%TYPE
42: );

Line 39: ,formula_id pay_user_columns.formula_id%TYPE

35: );
36:
37: TYPE r_udt_cols_type IS RECORD
38: (user_column_name pay_user_columns.user_column_name%TYPE
39: ,formula_id pay_user_columns.formula_id%TYPE
40: ,business_group_id pay_user_columns.business_group_id%TYPE
41: ,legislation_code pay_user_columns.legislation_code%TYPE
42: );
43:

Line 40: ,business_group_id pay_user_columns.business_group_id%TYPE

36:
37: TYPE r_udt_cols_type IS RECORD
38: (user_column_name pay_user_columns.user_column_name%TYPE
39: ,formula_id pay_user_columns.formula_id%TYPE
40: ,business_group_id pay_user_columns.business_group_id%TYPE
41: ,legislation_code pay_user_columns.legislation_code%TYPE
42: );
43:
44: TYPE t_udt_cols IS TABLE OF r_udt_cols_type

Line 41: ,legislation_code pay_user_columns.legislation_code%TYPE

37: TYPE r_udt_cols_type IS RECORD
38: (user_column_name pay_user_columns.user_column_name%TYPE
39: ,formula_id pay_user_columns.formula_id%TYPE
40: ,business_group_id pay_user_columns.business_group_id%TYPE
41: ,legislation_code pay_user_columns.legislation_code%TYPE
42: );
43:
44: TYPE t_udt_cols IS TABLE OF r_udt_cols_type
45: INDEX BY BINARY_INTEGER;

Line 421: l_udt_col_name pay_user_columns.user_column_name%TYPE;

417: ORDER BY lookup_code;
418:
419: l_proc_step NUMBER(20,10);
420: l_proc_name VARCHAR2(72) := g_package_name || 'get_udt_col_info';
421: l_udt_col_name pay_user_columns.user_column_name%TYPE;
422: l_udt_cols t_udt_cols;
423: i number;
424:
425: --

Line 486: l_user_column_id pay_user_columns.user_column_id%TYPE;

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;
490: l_udt_rows_rowid rowid;

Line 534: pay_user_columns_pkg.insert_row

530:
531: WHILE i IS NOT NULL
532: LOOP
533:
534: pay_user_columns_pkg.insert_row
535: (p_rowid => l_udt_cols_rowid
536: ,p_user_column_id => l_user_column_id
537: ,p_user_table_id => l_user_table_id
538: ,p_business_group_id => p_udt_cols(i).business_group_id

Line 1824: FROM pay_user_columns

1820:
1821: CURSOR csr_get_usr_col_id
1822: IS
1823: SELECT user_column_id
1824: FROM pay_user_columns
1825: WHERE user_table_id = p_udt_id;
1826:
1827: CURSOR csr_get_usr_row_id
1828: IS

Line 1838: l_usr_col_id pay_user_columns.user_column_id%TYPE;

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
1842:

Line 1853: -- Get user_column_id from pay_user_columns

1849: FETCH csr_get_usr_table_id INTO l_rowid;
1850:
1851: IF csr_get_usr_table_id%FOUND THEN
1852:
1853: -- Get user_column_id from pay_user_columns
1854: l_proc_step := 20;
1855: IF g_debug THEN
1856: debug(l_proc_name, l_proc_step);
1857: END IF;

Line 1878: -- Delete pay_user_columns for this table_id

1874:
1875: END LOOP;
1876: CLOSE csr_get_usr_col_id;
1877:
1878: -- Delete pay_user_columns for this table_id
1879: l_proc_step := 40;
1880: IF g_debug THEN
1881: debug(l_proc_name, l_proc_step);
1882: END IF;

Line 1885: DELETE pay_user_columns

1881: debug(l_proc_name, l_proc_step);
1882: END IF;
1883:
1884:
1885: DELETE pay_user_columns
1886: WHERE user_table_id = p_udt_id;
1887:
1888: OPEN csr_get_usr_row_id;
1889: LOOP