[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_pty_ins.g_pension_type_id_i := p_pension_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqp_pty_ins.g_pension_type_id_i := p_pension_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by pqp_pension_types_f.last_updated_by%TYPE;
102: l_last_update_login pqp_pension_types_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
356: ,l_last_update_login
357: );
358: --
359: --
360: hr_utility.set_location(' Leaving:'||l_proc, 15);
361: --
362: Exception
363: When hr_api.check_integrity_violated Then
364: -- A check constraint has been violated
436: --
437: l_proc varchar2(72) := g_package||'insert_dml';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: pqp_pty_ins.dt_insert_dml
443: (p_rec => p_rec
444: ,p_effective_date => p_effective_date
446: ,p_validation_start_date => p_validation_start_date
447: ,p_validation_end_date => p_validation_end_date
448: );
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: End insert_dml;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |------------------------------< pre_insert >------------------------------|
508: l_proc varchar2(72) := g_package||'pre_insert';
509: l_exists varchar2(1);
510: --
511: Begin
512: hr_utility.set_location('Entering:'||l_proc, 5);
513: --
514: If (pqp_pty_ins.g_pension_type_id_i is not null) Then
515: --
516: -- Verify registered primary key values not already in use
545: Close C_Sel1;
546: End If;
547: --
548: --
549: hr_utility.set_location(' Leaving:'||l_proc, 10);
550: End pre_insert;
551: --
552: -- ----------------------------------------------------------------------------
553: -- |----------------------------< post_insert >-------------------------------|
591: --
592: l_proc varchar2(72) := g_package||'post_insert';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);
596: begin
597: --
598: -- insert ownerships if applicable
599: create_app_ownerships
807: ,p_hook_type => 'AI');
808: --
809: end;
810: --
811: hr_utility.set_location(' Leaving:'||l_proc, 10);
812: End post_insert;
813: --
814: -- ----------------------------------------------------------------------------
815: -- |-------------------------------< ins_lck >--------------------------------|
859: l_validation_start_date date;
860: l_validation_end_date date;
861: --
862: Begin
863: hr_utility.set_location('Entering:'||l_proc, 5);
864: --
865: -- Validate the datetrack mode mode getting the validation start
866: -- and end dates for the specified datetrack operation.
867: --
880: --
881: p_validation_start_date := l_validation_start_date;
882: p_validation_end_date := l_validation_end_date;
883: --
884: hr_utility.set_location(' Leaving:'||l_proc, 10);
885: --
886: End ins_lck;
887: --
888: -- ----------------------------------------------------------------------------
898: l_validation_start_date date;
899: l_validation_end_date date;
900: --
901: Begin
902: hr_utility.set_location('Entering:'||l_proc, 5);
903: --
904: -- Call the lock operation
905: --
906: pqp_pty_ins.ins_lck
956: --
957: -- Call to raise any errors on multi-message list
958: hr_multi_message.end_validation_set;
959: --
960: hr_utility.set_location('Leaving:'||l_proc,10);
961: end ins;
962: --
963: -- ----------------------------------------------------------------------------
964: -- |---------------------------------< ins >----------------------------------|
1064: l_rec pqp_pty_shd.g_rec_type;
1065: l_proc varchar2(72) := g_package||'ins';
1066: --
1067: Begin
1068: hr_utility.set_location('Entering:'||l_proc, 5);
1069: --
1070: -- Call conversion function to turn arguments into the
1071: -- p_rec structure.
1072: --
1184: p_effective_end_date := l_rec.effective_end_date;
1185: p_object_version_number := l_rec.object_version_number;
1186: --
1187: --
1188: hr_utility.set_location(' Leaving:'||l_proc, 10);
1189: End ins;
1190: --
1191:
1192: end pqp_pty_ins;