83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: pqh_de_tatigkeit_details
88: --
89: insert into pqh_de_tatigkeit_details
90: (tatigkeit_detail_id
91: ,tatigkeit_number
85: --
86: --
87: -- Insert the row into: pqh_de_tatigkeit_details
88: --
89: insert into pqh_de_tatigkeit_details
90: (tatigkeit_detail_id
91: ,tatigkeit_number
92: ,description
93: ,object_version_number
163: Procedure pre_insert
164: (p_rec in out nocopy pqh_tkt_shd.g_rec_type
165: ) is
166: --
167: Cursor C_Sel1 is select pqh_de_tatigkeit_details_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: Select null
171: from pqh_de_tatigkeit_details
167: Cursor C_Sel1 is select pqh_de_tatigkeit_details_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: Select null
171: from pqh_de_tatigkeit_details
172: where tatigkeit_detail_id =
173: pqh_tkt_ins.G_TATIGKEIT_DETAIL_ID;
174: --
175: l_proc varchar2(72) := g_package||'pre_insert';
189: --
190: -- The primary key values are already in use.
191: --
192: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
193: fnd_message.set_token('TABLE_NAME','pqh_de_tatigkeit_details');
194: fnd_message.raise_error;
195: End If;
196: Close C_Sel2;
197: --