APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_USER_COLUMNS

Line 165: (user_column_name pay_user_columns.user_column_name%TYPE

161:
162: l_udt_type r_udt_type;
163:
164: TYPE r_udt_cols_type IS RECORD
165: (user_column_name pay_user_columns.user_column_name%TYPE
166: ,formula_id pay_user_columns.formula_id%TYPE
167: ,business_group_id pay_user_columns.business_group_id%TYPE
168: ,legislation_code pay_user_columns.legislation_code%TYPE
169: );

Line 166: ,formula_id pay_user_columns.formula_id%TYPE

162: l_udt_type r_udt_type;
163:
164: TYPE r_udt_cols_type IS RECORD
165: (user_column_name pay_user_columns.user_column_name%TYPE
166: ,formula_id pay_user_columns.formula_id%TYPE
167: ,business_group_id pay_user_columns.business_group_id%TYPE
168: ,legislation_code pay_user_columns.legislation_code%TYPE
169: );
170:

Line 167: ,business_group_id pay_user_columns.business_group_id%TYPE

163:
164: TYPE r_udt_cols_type IS RECORD
165: (user_column_name pay_user_columns.user_column_name%TYPE
166: ,formula_id pay_user_columns.formula_id%TYPE
167: ,business_group_id pay_user_columns.business_group_id%TYPE
168: ,legislation_code pay_user_columns.legislation_code%TYPE
169: );
170:
171: TYPE t_udt_cols IS TABLE OF r_udt_cols_type

Line 168: ,legislation_code pay_user_columns.legislation_code%TYPE

164: TYPE r_udt_cols_type IS RECORD
165: (user_column_name pay_user_columns.user_column_name%TYPE
166: ,formula_id pay_user_columns.formula_id%TYPE
167: ,business_group_id pay_user_columns.business_group_id%TYPE
168: ,legislation_code pay_user_columns.legislation_code%TYPE
169: );
170:
171: TYPE t_udt_cols IS TABLE OF r_udt_cols_type
172: INDEX BY BINARY_INTEGER;

Line 532: l_user_column_id pay_user_columns.user_column_id%TYPE;

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;
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;

Line 571: pay_user_columns_pkg.insert_row

567:
568: WHILE i IS NOT NULL
569: LOOP
570:
571: pay_user_columns_pkg.insert_row
572: (p_rowid => l_udt_cols_rowid
573: ,p_user_column_id => l_user_column_id
574: ,p_user_table_id => l_user_table_id
575: ,p_business_group_id => p_udt_cols(i).business_group_id

Line 1984: FROM pay_user_columns

1980: AND business_group_id = p_business_group_id;
1981:
1982: CURSOR csr_get_usr_col_id IS
1983: SELECT user_column_id
1984: FROM pay_user_columns
1985: WHERE user_table_id = p_udt_id;
1986:
1987: CURSOR csr_get_usr_row_id IS
1988: SELECT user_row_id

Line 1996: l_usr_col_id pay_user_columns.user_column_id%TYPE;

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

Line 2011: -- Get user_column_id from pay_user_columns

2007: FETCH csr_get_usr_table_id INTO l_rowid;
2008:
2009: IF csr_get_usr_table_id%FOUND THEN
2010:
2011: -- Get user_column_id from pay_user_columns
2012: hr_utility.set_location (l_proc_name, 20);
2013:
2014: OPEN csr_get_usr_col_id;
2015: LOOP

Line 2028: -- Delete pay_user_columns for this table_id

2024:
2025: END LOOP;
2026: CLOSE csr_get_usr_col_id;
2027:
2028: -- Delete pay_user_columns for this table_id
2029: hr_utility.set_location (l_proc_name, 40);
2030:
2031: DELETE pay_user_columns
2032: WHERE user_table_id = p_udt_id;

Line 2031: DELETE pay_user_columns

2027:
2028: -- Delete pay_user_columns for this table_id
2029: hr_utility.set_location (l_proc_name, 40);
2030:
2031: DELETE pay_user_columns
2032: WHERE user_table_id = p_udt_id;
2033:
2034: OPEN csr_get_usr_row_id;
2035: LOOP