[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_doa_ins.g_document_attribute_id_i := p_document_attribute_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_doa_ins.g_document_attribute_id_i := p_document_attribute_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_document_attributes_f.last_updated_by%TYPE;
102: l_last_update_login pqh_document_attributes_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;
182: ,l_last_update_login
183: );
184: --
185: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
186: hr_utility.set_location(' Leaving:'||l_proc, 15);
187: --
188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
214: --
215: l_proc varchar2(72) := g_package||'insert_dml';
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: pqh_doa_ins.dt_insert_dml
221: (p_rec => p_rec
222: ,p_effective_date => p_effective_date
224: ,p_validation_start_date => p_validation_start_date
225: ,p_validation_end_date => p_validation_end_date
226: );
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End insert_dml;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |------------------------------< pre_insert >------------------------------|
286: l_proc varchar2(72) := g_package||'pre_insert';
287: l_exists varchar2(1);
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: If (pqh_doa_ins.g_document_attribute_id_i is not null) Then
293: --
294: -- Verify registered primary key values not already in use
323: Close C_Sel1;
324: End If;
325: --
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: End pre_insert;
329: --
330: -- ----------------------------------------------------------------------------
331: -- |----------------------------< post_insert >-------------------------------|
369: --
370: l_proc varchar2(72) := g_package||'post_insert';
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: begin
375: --
376: pqh_doa_rki.after_insert
377: (p_effective_date
405: ,p_hook_type => 'AI');
406: --
407: end;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 10);
410: End post_insert;
411: --
412: -- ----------------------------------------------------------------------------
413: -- |-------------------------------< ins_lck >--------------------------------|
457: l_validation_start_date date;
458: l_validation_end_date date;
459: --
460: Begin
461: hr_utility.set_location('Entering:'||l_proc, 5);
462: --
463: -- Validate the datetrack mode mode getting the validation start
464: -- and end dates for the specified datetrack operation.
465: --
478: --
479: p_validation_start_date := l_validation_start_date;
480: p_validation_end_date := l_validation_end_date;
481: --
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: --
484: End ins_lck;
485: --
486: -- ----------------------------------------------------------------------------
496: l_validation_start_date date;
497: l_validation_end_date date;
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Call the lock operation
503: --
504: pqh_doa_ins.ins_lck
554: --
555: -- Call to raise any errors on multi-message list
556: hr_multi_message.end_validation_set;
557: --
558: hr_utility.set_location('Leaving:'||l_proc,10);
559: end ins;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------------< ins >----------------------------------|
575: l_rec pqh_doa_shd.g_rec_type;
576: l_proc varchar2(72) := g_package||'ins';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call conversion function to turn arguments into the
582: -- p_rec structure.
583: --
608: p_effective_end_date := l_rec.effective_end_date;
609: p_object_version_number := l_rec.object_version_number;
610: --
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);
613: End ins;
614: --
615: end pqh_doa_ins;