[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_asa_ins.g_assignment_acco_id_i := p_assignment_acco_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_asa_ins.g_assignment_acco_id_i := p_assignment_acco_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_assign_accommodations_f.last_updated_by%TYPE;
102: l_last_update_login pqh_assign_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;
328: ,l_last_update_login
329: );
330: --
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 15);
333: --
334: Exception
335: When hr_api.check_integrity_violated Then
336: -- A check constraint has been violated
360: --
361: l_proc varchar2(72) := g_package||'insert_dml';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: pqh_asa_ins.dt_insert_dml
367: (p_rec => p_rec
368: ,p_effective_date => p_effective_date
370: ,p_validation_start_date => p_validation_start_date
371: ,p_validation_end_date => p_validation_end_date
372: );
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 10);
375: End insert_dml;
376: --
377: -- ----------------------------------------------------------------------------
378: -- |------------------------------< pre_insert >------------------------------|
432: l_proc varchar2(72) := g_package||'pre_insert';
433: l_exists varchar2(1);
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: If (pqh_asa_ins.g_assignment_acco_id_i is not null) Then
439: --
440: -- Verify registered primary key values not already in use
469: Close C_Sel1;
470: End If;
471: --
472: --
473: hr_utility.set_location(' Leaving:'||l_proc, 10);
474: End pre_insert;
475: --
476: -- ----------------------------------------------------------------------------
477: -- |----------------------------< post_insert >-------------------------------|
515: --
516: l_proc varchar2(72) := g_package||'post_insert';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: begin
521: --
522: pqh_asa_rki.after_insert
523: (p_effective_date
697: ,p_hook_type => 'AI');
698: --
699: end;
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 10);
702: End post_insert;
703: --
704: -- ----------------------------------------------------------------------------
705: -- |-------------------------------< ins_lck >--------------------------------|
749: l_validation_start_date date;
750: l_validation_end_date date;
751: --
752: Begin
753: hr_utility.set_location('Entering:'||l_proc, 5);
754: --
755: -- Validate the datetrack mode mode getting the validation start
756: -- and end dates for the specified datetrack operation.
757: --
773: --
774: p_validation_start_date := l_validation_start_date;
775: p_validation_end_date := l_validation_end_date;
776: --
777: hr_utility.set_location(' Leaving:'||l_proc, 10);
778: --
779: End ins_lck;
780: --
781: -- ----------------------------------------------------------------------------
791: l_validation_start_date date;
792: l_validation_end_date date;
793: --
794: Begin
795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: -- Call the lock operation
798: --
799: pqh_asa_ins.ins_lck
849: --
850: -- Call to raise any errors on multi-message list
851: hr_multi_message.end_validation_set;
852: --
853: hr_utility.set_location('Leaving:'||l_proc,10);
854: end ins;
855: --
856: -- ----------------------------------------------------------------------------
857: -- |---------------------------------< ins >----------------------------------|
943: l_rec pqh_asa_shd.g_rec_type;
944: l_proc varchar2(72) := g_package||'ins';
945: --
946: Begin
947: hr_utility.set_location('Entering:'||l_proc, 5);
948: --
949: -- Call conversion function to turn arguments into the
950: -- p_rec structure.
951: --
1049: p_effective_end_date := l_rec.effective_end_date;
1050: p_object_version_number := l_rec.object_version_number;
1051: --
1052: --
1053: hr_utility.set_location(' Leaving:'||l_proc, 10);
1054: End ins;
1055: --
1056: end pqh_asa_ins;