DBA Data[Home] [Help]

APPS.PQP_COPY_UDT dependencies on PAY_USER_COLUMNS

Line 131: FROM pay_user_columns

127: ) IS
128:
129: CURSOR c_user_columns IS
130: SELECT *
131: FROM pay_user_columns
132: WHERE user_table_id = p_curr_put_id;
133:
134: r_user_columns c_user_columns%ROWTYPE;
135:

Line 148: pay_user_columns_pkg.check_unique_f

144: For r_user_columns in c_user_columns
145: Loop
146:
147: -- Check column name unique
148: pay_user_columns_pkg.check_unique_f
149: (p_rowid => l_row_id
150: ,p_user_column_name => r_user_columns.user_column_name
151: ,p_user_table_id => p_new_put_id
152: ,p_business_group_id => g_target_bg_id

Line 156: -- Insert new row into PAY_USER_COLUMNS

152: ,p_business_group_id => g_target_bg_id
153: ,p_legislation_code => NULL
154: );
155:
156: -- Insert new row into PAY_USER_COLUMNS
157: pay_user_columns_pkg.insert_row
158: (p_rowid => l_row_id -- IN OUT
159: ,p_user_column_id => l_new_puc_id -- IN OUT
160: ,p_user_table_id => p_new_put_id

Line 157: pay_user_columns_pkg.insert_row

153: ,p_legislation_code => NULL
154: );
155:
156: -- Insert new row into PAY_USER_COLUMNS
157: pay_user_columns_pkg.insert_row
158: (p_rowid => l_row_id -- IN OUT
159: ,p_user_column_id => l_new_puc_id -- IN OUT
160: ,p_user_table_id => p_new_put_id
161: ,p_business_group_id => g_target_bg_id

Line 415: -- Copy PAY_USER_COLUMNS data

411:
412: -- Copy PAY_USER_TABLES data
413: l_new_put_id := copy_table(p_curr_put_id => p_curr_udt_id);
414:
415: -- Copy PAY_USER_COLUMNS data
416: copy_columns(p_curr_put_id => p_curr_udt_id
417: ,p_new_put_id => l_new_put_id
418: );
419: