51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58: --
59: -- Insert the row into: pqh_copy_entity_functions
79: p_rec.context
80: );
81: --
82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: pqh_cef_shd.constraint_error
141: --
142: Cursor C_Sel1 is select pqh_copy_entity_functions_s.nextval from sys.dual;
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: --
148: -- Select the next sequence number
149: --
150: Open C_Sel1;
151: Fetch C_Sel1 Into p_rec.copy_entity_function_id;
152: Close C_Sel1;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: End pre_insert;
156: --
157: -- ----------------------------------------------------------------------------
158: -- |-----------------------------< post_insert >------------------------------|
191: --
192: l_proc varchar2(72) := g_package||'post_insert';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: --
198: -- Start of API User Hook for post_insert.
199: --
224: --
225: -- End of API User Hook for post_insert.
226: --
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End post_insert;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------------< ins >----------------------------------|
239: --
240: l_proc varchar2(72) := g_package||'ins';
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: --
245: -- Call the supporting insert validate operations
246: --
247: pqh_cef_bus.insert_validate(p_rec
280: l_rec pqh_cef_shd.g_rec_type;
281: l_proc varchar2(72) := g_package||'ins';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- Call conversion function to turn arguments into the
287: -- p_rec structure.
288: --
310: --
311: p_copy_entity_function_id := l_rec.copy_entity_function_id;
312: p_object_version_number := l_rec.object_version_number;
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: End ins;
316: --
317: end pqh_cef_ins;