50: --
51: l_proc varchar2(72) := g_package||'insert_dml';
52: --
53: Begin
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: p_rec.object_version_number := 1; -- Initialise the object version
56: --
57: --
58: -- Insert the row into: pqh_copy_entity_contexts
74: p_rec.object_version_number
75: );
76: --
77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_cec_shd.constraint_error
136: --
137: -- Cursor C_Sel1 is select pqh_copy_entity_contexts_s.nextval from sys.dual;
138: --
139: Begin
140: hr_utility.set_location('Entering:'||l_proc, 5);
141: --
142: --
143: -- Select the next sequence number
144: --
147: Fetch C_Sel1 Into p_rec.context;
148: Close C_Sel1;
149: */
150: --
151: hr_utility.set_location(' Leaving:'||l_proc, 10);
152: End pre_insert;
153: --
154: -- ----------------------------------------------------------------------------
155: -- |-----------------------------< post_insert >------------------------------|
187: --
188: l_proc varchar2(72) := g_package||'post_insert';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: --
194: -- Start of API User Hook for post_insert.
195: --
217: --
218: -- End of API User Hook for post_insert.
219: --
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End post_insert;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |---------------------------------< ins >----------------------------------|
231: --
232: l_proc varchar2(72) := g_package||'ins';
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- Call the supporting insert validate operations
238: --
239: pqh_cec_bus.insert_validate(p_rec);
267: l_rec pqh_cec_shd.g_rec_type;
268: l_proc varchar2(72) := g_package||'ins';
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: --
273: -- Call conversion function to turn arguments into the
274: -- p_rec structure.
275: --
294: --
295: -- p_context := l_rec.context;
296: p_object_version_number := l_rec.object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: End ins;
300: --
301: end pqh_cec_ins;