54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: pqp_aad_shd.g_api_dml := true; -- Set the api dml status
62: --
110: );
111: --
112: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pqp_aad_shd.g_api_dml := false; -- Unset the api dml status
176: --
177: Cursor C_Sel1 is select pqp_analyzed_alien_data_s.nextval from sys.dual;
178: --
179: Begin
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: --
183: -- Select the next sequence number
184: --
185: Open C_Sel1;
186: Fetch C_Sel1 Into p_rec.analyzed_data_id;
187: Close C_Sel1;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190: End pre_insert;
191: --
192: -- ----------------------------------------------------------------------------
193: -- |-----------------------------< post_insert >------------------------------|
226: --
227: l_proc varchar2(72) := g_package||'post_insert';
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: --
233: -- Start of API User Hook for post_insert.
234: --
272: --
273: -- End of API User Hook for post_insert.
274: --
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End post_insert;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |---------------------------------< ins >----------------------------------|
287: --
288: l_proc varchar2(72) := g_package||'ins';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- Call the supporting insert validate operations
294: --
295: pqp_aad_bus.insert_validate(p_rec
341: l_rec pqp_aad_shd.g_rec_type;
342: l_proc varchar2(72) := g_package||'ins';
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: -- Call conversion function to turn arguments into the
348: -- p_rec structure.
349: --
384: --
385: p_analyzed_data_id := l_rec.analyzed_data_id;
386: p_object_version_number := l_rec.object_version_number;
387: --
388: hr_utility.set_location(' Leaving:'||l_proc, 10);
389: End ins;
390: --
391: end pqp_aad_ins;