[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_cpd_ins.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following global variables are only to be used by
12: -- the set_base_key_value and pre_insert procedures.
13: --
21: --
22: l_proc varchar2(72);
23: --
24: Begin
25: g_debug := hr_utility.debug_enabled;
26: if g_debug then
27: l_proc := g_package||'set_base_key_value';
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
24: Begin
25: g_debug := hr_utility.debug_enabled;
26: if g_debug then
27: l_proc := g_package||'set_base_key_value';
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
30: --
31: pqh_cpd_ins.g_corps_definition_id_i := p_corps_definition_id;
32: --
30: --
31: pqh_cpd_ins.g_corps_definition_id_i := p_corps_definition_id;
32: --
33: if g_debug then
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: end if;
36: End set_base_key_value;
37: --
38: --
87: --
88: Begin
89: if g_debug then
90: l_proc := g_package||'insert_dml';
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: end if;
93: p_rec.object_version_number := 1; -- Initialise the object version
94: --
95: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status
213: --
214: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
215: --
216: if g_debug then
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: end if;
219: Exception
220: When hr_api.check_integrity_violated Then
221: -- A check constraint has been violated
291: --
292: Begin
293: if g_debug then
294: l_proc := g_package||'pre_insert';
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: end if;
297: --
298: If (pqh_cpd_ins.g_corps_definition_id_i is not null) Then
299: --
329: Close C_Sel1;
330: End If;
331: --
332: if g_debug then
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: end if;
335: End pre_insert;
336: --
337: -- ----------------------------------------------------------------------------
375: --
376: Begin
377: if g_debug then
378: l_proc := g_package||'post_insert';
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: end if;
381: begin
382: --
383: pqh_cpd_rki.after_insert
504: --
505: end;
506: --
507: if g_debug then
508: hr_utility.set_location(' Leaving:'||l_proc, 10);
509: end if;
510: End post_insert;
511: --
512: -- ----------------------------------------------------------------------------
521: --
522: Begin
523: if g_debug then
524: l_proc := g_package||'ins';
525: hr_utility.set_location('Entering:'||l_proc, 5);
526: end if;
527: --
528: -- Call the supporting insert validate operations
529: --
553: -- Call to raise any errors on multi-message list
554: hr_multi_message.end_validation_set;
555: --
556: if g_debug then
557: hr_utility.set_location('Leaving:'||l_proc, 20);
558: end if;
559: end ins;
560: --
561: -- ----------------------------------------------------------------------------
623: l_rec pqh_cpd_shd.g_rec_type;
624: l_proc varchar2(72);
625: --
626: Begin
627: g_debug := hr_utility.debug_enabled;
628: if g_debug then
629: l_proc := g_package||'ins';
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: end if;
626: Begin
627: g_debug := hr_utility.debug_enabled;
628: if g_debug then
629: l_proc := g_package||'ins';
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: end if;
632: --
633: -- Call conversion function to turn arguments into the
634: -- p_rec structure.
706: p_corps_definition_id := l_rec.corps_definition_id;
707: p_object_version_number := l_rec.object_version_number;
708: --
709: if g_debug then
710: hr_utility.set_location(' Leaving:'||l_proc, 10);
711: end if;
712: End ins;
713: --
714: end pqh_cpd_ins;