APPS.HR_TRS_INS dependencies on HR_API_TRANSACTION_STEPS

Line 85: -- Insert the row into: hr_api_transaction_steps

81: p_rec.object_version_number := 1; -- Initialise the object version
82: --
83: hr_trs_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: hr_api_transaction_steps
86: --
87: insert into hr_api_transaction_steps
88: ( transaction_step_id,
89: transaction_id,

Line 87: insert into hr_api_transaction_steps

83: hr_trs_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Insert the row into: hr_api_transaction_steps
86: --
87: insert into hr_api_transaction_steps
88: ( transaction_step_id,
89: transaction_id,
90: api_name,
91: api_display_name,

Line 262: Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;

258: --
259: l_proc varchar2(72) := g_package||'pre_insert';
260: l_exists varchar2(1);
261: --
262: Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;
263:
264: Cursor C_Sel2 is
265: select null
266: from hr_api_transaction_steps

Line 266: from hr_api_transaction_steps

262: Cursor C_Sel1 is select hr_api_transaction_steps_s.nextval from sys.dual;
263:
264: Cursor C_Sel2 is
265: select null
266: from hr_api_transaction_steps
267: where transaction_step_id = hr_trs_ins.g_transaction_step_id_i;
268: --
269: --
270: Begin

Line 285: fnd_message.set_token('TABLE_NAME','hr_api_transaction_steps');

281: --
282: -- The primary key values are already in use.
283: --
284: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
285: fnd_message.set_token('TABLE_NAME','hr_api_transaction_steps');
286: fnd_message.raise_error;
287: end if;
288: Close C_Sel2;
289: --