[Home] [Help]
20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqp_gds_ins.g_gap_duration_summary_id_i := p_gap_duration_summary_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqp_gds_ins.g_gap_duration_summary_id_i := p_gap_duration_summary_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: pqp_gds_shd.g_api_dml := true; -- Set the api dml status
86: --
112: );
113: --
114: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
187: l_proc varchar2(72) := g_package||'pre_insert';
188: l_exists varchar2(1);
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: If (pqp_gds_ins.g_gap_duration_summary_id_i is not null) Then
194: --
195: -- Verify registered primary key values not already in use
223: Fetch C_Sel1 Into p_rec.gap_duration_summary_id;
224: Close C_Sel1;
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: End pre_insert;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |-----------------------------< post_insert >------------------------------|
265: --
266: l_proc varchar2(72) := g_package||'post_insert';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: begin
271: --
272: pqp_gds_rki.after_insert
273: (p_gap_duration_summary_id
301: ,p_hook_type => 'AI');
302: --
303: end;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End post_insert;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |---------------------------------< ins >----------------------------------|
314: --
315: l_proc varchar2(72) := g_package||'ins';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Call the supporting insert validate operations
321: --
322: pqp_gds_bus.insert_validate
342: --
343: -- Call to raise any errors on multi-message list
344: hr_multi_message.end_validation_set;
345: --
346: hr_utility.set_location('Leaving:'||l_proc, 20);
347: end ins;
348: --
349: -- ----------------------------------------------------------------------------
350: -- |---------------------------------< ins >----------------------------------|
365: l_rec pqp_gds_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'ins';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Call conversion function to turn arguments into the
372: -- p_rec structure.
373: --
397: --
398: p_gap_duration_summary_id := l_rec.gap_duration_summary_id;
399: p_object_version_number := l_rec.object_version_number;
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 10);
402: End ins;
403: --
404: end pqp_gds_ins;