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_pcv_ins.g_configuration_value_id_i := p_configuration_value_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqp_pcv_ins.g_configuration_value_id_i := p_configuration_value_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: p_rec.object_version_number := 1; -- Initialise the object version
132: --
133: --
134: --
234: );
235: --
236: --
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: Exception
240: When hr_api.check_integrity_violated Then
241: -- A check constraint has been violated
242: --
309: l_proc varchar2(72) := g_package||'pre_insert';
310: l_exists varchar2(1);
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: If (pqp_pcv_ins.g_configuration_value_id_i is not null) Then
316: --
317: -- Verify registered primary key values not already in use
345: Fetch C_Sel1 Into p_rec.configuration_value_id;
346: Close C_Sel1;
347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: End pre_insert;
351: --
352: -- ----------------------------------------------------------------------------
353: -- |-----------------------------< post_insert >------------------------------|
388: --
389: l_proc varchar2(72) := g_package||'post_insert';
390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc, 5);
393: begin
394: --
395: -- insert ownerships if applicable
396: create_app_ownerships
505: ,p_hook_type => 'AI');
506: --
507: end;
508: --
509: hr_utility.set_location(' Leaving:'||l_proc, 10);
510: End post_insert;
511: --
512: -- ----------------------------------------------------------------------------
513: -- |---------------------------------< ins >----------------------------------|
519: --
520: l_proc varchar2(72) := g_package||'ins';
521: --
522: Begin
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: --
525: -- Call the supporting insert validate operations
526: --
527: pqp_pcv_bus.insert_validate
549: --
550: -- Call to raise any errors on multi-message list
551: hr_multi_message.end_validation_set;
552: --
553: hr_utility.set_location('Leaving:'||l_proc, 20);
554: end ins;
555: --
556: -- ----------------------------------------------------------------------------
557: -- |---------------------------------< ins >----------------------------------|
610: l_rec pqp_pcv_shd.g_rec_type;
611: l_proc varchar2(72) := g_package||'ins';
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- Call conversion function to turn arguments into the
617: -- p_rec structure.
618: --
680: --
681: p_configuration_value_id := l_rec.configuration_value_id;
682: p_object_version_number := l_rec.object_version_number;
683: --
684: hr_utility.set_location(' Leaving:'||l_proc, 10);
685: End ins;
686: --
687: end pqp_pcv_ins;