[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: pqh_acc_ins.g_accommodation_id_i := p_accommodation_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_acc_ins.g_accommodation_id_i := p_accommodation_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 pqh_accommodations_f.last_updated_by%TYPE;
102: l_last_update_login pqh_accommodations_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
388: --
389: l_proc varchar2(72) := g_package||'insert_dml';
390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc, 5);
393: --
394: pqh_acc_ins.dt_insert_dml
395: (p_rec => p_rec
396: ,p_effective_date => p_effective_date
398: ,p_validation_start_date => p_validation_start_date
399: ,p_validation_end_date => p_validation_end_date
400: );
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End insert_dml;
404: --
405: -- ----------------------------------------------------------------------------
406: -- |------------------------------< pre_insert >------------------------------|
460: l_proc varchar2(72) := g_package||'pre_insert';
461: l_exists varchar2(1);
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: If (pqh_acc_ins.g_accommodation_id_i is not null) Then
467: --
468: -- Verify registered primary key values not already in use
497: Close C_Sel1;
498: End If;
499: --
500: --
501: hr_utility.set_location(' Leaving:'||l_proc, 10);
502: End pre_insert;
503: --
504: -- ----------------------------------------------------------------------------
505: -- |----------------------------< post_insert >-------------------------------|
543: --
544: l_proc varchar2(72) := g_package||'post_insert';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: begin
549: --
550: pqh_acc_rki.after_insert
551: (p_effective_date
753: ,p_hook_type => 'AI');
754: --
755: end;
756: --
757: hr_utility.set_location(' Leaving:'||l_proc, 10);
758: End post_insert;
759: --
760: -- ----------------------------------------------------------------------------
761: -- |-------------------------------< ins_lck >--------------------------------|
805: l_validation_start_date date;
806: l_validation_end_date date;
807: --
808: Begin
809: hr_utility.set_location('Entering:'||l_proc, 5);
810: --
811: -- Validate the datetrack mode mode getting the validation start
812: -- and end dates for the specified datetrack operation.
813: --
826: --
827: p_validation_start_date := l_validation_start_date;
828: p_validation_end_date := l_validation_end_date;
829: --
830: hr_utility.set_location(' Leaving:'||l_proc, 10);
831: --
832: End ins_lck;
833: --
834: -- ----------------------------------------------------------------------------
844: l_validation_start_date date;
845: l_validation_end_date date;
846: --
847: Begin
848: hr_utility.set_location('Entering:'||l_proc, 5);
849: --
850: -- Call the lock operation
851: --
852: pqh_acc_ins.ins_lck
902: --
903: -- Call to raise any errors on multi-message list
904: hr_multi_message.end_validation_set;
905: --
906: hr_utility.set_location('Leaving:'||l_proc,10);
907: end ins;
908: --
909: -- ----------------------------------------------------------------------------
910: -- |---------------------------------< ins >----------------------------------|
1010: l_rec pqh_acc_shd.g_rec_type;
1011: l_proc varchar2(72) := g_package||'ins';
1012: --
1013: Begin
1014: hr_utility.set_location('Entering:'||l_proc, 5);
1015: --
1016: -- Call conversion function to turn arguments into the
1017: -- p_rec structure.
1018: --
1130: p_effective_end_date := l_rec.effective_end_date;
1131: p_object_version_number := l_rec.object_version_number;
1132: --
1133: --
1134: hr_utility.set_location(' Leaving:'||l_proc, 10);
1135: End ins;
1136: --
1137: end pqh_acc_ins;