85: p_rec.object_version_number := 1; -- Initialise the object version
86: --
87: --
88: --
89: -- Insert the row into: pqh_rank_process_approvals
90: --
91: insert into pqh_rank_process_approvals
92: (rank_process_approval_id
93: ,rank_process_id
87: --
88: --
89: -- Insert the row into: pqh_rank_process_approvals
90: --
91: insert into pqh_rank_process_approvals
92: (rank_process_approval_id
93: ,rank_process_id
94: ,approval_date
95: ,supervisor_id
173: Procedure pre_insert
174: (p_rec in out nocopy pqh_rap_shd.g_rec_type
175: ) is
176: --
177: Cursor C_Sel1 is select pqh_rank_process_approvals_s.nextval from sys.dual;
178: --
179: Cursor C_Sel2 is
180: Select null
181: from pqh_rank_process_approvals
177: Cursor C_Sel1 is select pqh_rank_process_approvals_s.nextval from sys.dual;
178: --
179: Cursor C_Sel2 is
180: Select null
181: from pqh_rank_process_approvals
182: where rank_process_approval_id =
183: pqh_rap_ins.g_rank_process_approval_id_i;
184: --
185: l_proc constant varchar2(72):= g_package||'pre_insert';
200: --
201: -- The primary key values are already in use.
202: --
203: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
204: fnd_message.set_token('TABLE_NAME','pqh_rank_process_approvals');
205: fnd_message.raise_error;
206: End If;
207: Close C_Sel2;
208: --
294: --
295: when hr_api.cannot_find_prog_unit then
296: --
297: hr_api.cannot_find_prog_unit_error
298: (p_module_name => 'PQH_RANK_PROCESS_APPROVALS'
299: ,p_hook_type => 'AI');
300: --
301: end;
302: --