APPS.PAY_PUC_INS dependencies on PAY_USER_COLUMNS

Line 135: -- Insert the row into: pay_user_columns

131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: pay_puc_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: pay_user_columns
136: --
137: insert into pay_user_columns
138: (user_column_id
139: ,business_group_id

Line 137: insert into pay_user_columns

133: pay_puc_shd.g_api_dml := true; -- Set the api dml status
134: --
135: -- Insert the row into: pay_user_columns
136: --
137: insert into pay_user_columns
138: (user_column_id
139: ,business_group_id
140: ,legislation_code
141: ,user_table_id

Line 221: Cursor C_Sel1 is select pay_user_columns_s.nextval from sys.dual;

217: Procedure pre_insert
218: (p_rec in out nocopy pay_puc_shd.g_rec_type
219: ) is
220: --
221: Cursor C_Sel1 is select pay_user_columns_s.nextval from sys.dual;
222: --
223: Cursor C_Sel2 is
224: Select null
225: from pay_user_columns

Line 225: from pay_user_columns

221: Cursor C_Sel1 is select pay_user_columns_s.nextval from sys.dual;
222: --
223: Cursor C_Sel2 is
224: Select null
225: from pay_user_columns
226: where user_column_id =
227: pay_puc_ins.g_user_column_id_i;
228: --
229: l_proc varchar2(72) := g_package||'pre_insert';

Line 247: fnd_message.set_token('TABLE_NAME','pay_user_columns');

243: --
244: -- The primary key values are already in use.
245: --
246: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
247: fnd_message.set_token('TABLE_NAME','pay_user_columns');
248: fnd_message.raise_error;
249: End If;
250: Close C_Sel2;
251: --

Line 342: (p_module_name => 'PAY_USER_COLUMNS'

338: --
339: when hr_api.cannot_find_prog_unit then
340: --
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'PAY_USER_COLUMNS'
343: ,p_hook_type => 'AI');
344: --
345: end;
346: --