[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: pay_cal_ins.g_cost_allocation_id_i := p_cost_allocation_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_cal_ins.g_cost_allocation_id_i := p_cost_allocation_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 pay_cost_allocations_f.last_updated_by%TYPE;
102: l_last_update_login pay_cost_allocations_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Set the effective start and end dates to the corresponding
108: -- validation start and end dates
109: --
113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=
195: );
196: --
197: --
198: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
199: hr_utility.set_location(' Leaving:'||l_proc, 15);
200: --
201: Exception
202: When hr_api.check_integrity_violated Then
203: -- A check constraint has been violated
227: --
228: l_proc varchar2(72) := g_package||'insert_dml';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: pay_cal_ins.dt_insert_dml
234: (p_rec => p_rec
235: ,p_effective_date => p_effective_date
237: ,p_validation_start_date => p_validation_start_date
238: ,p_validation_end_date => p_validation_end_date
239: );
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: End insert_dml;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |------------------------------< pre_insert >------------------------------|
299: l_proc varchar2(72) := g_package||'pre_insert';
300: l_exists varchar2(1);
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: If (pay_cal_ins.g_cost_allocation_id_i is not null) Then
306: --
307: -- Verify registered primary key values not already in use
336: Close C_Sel1;
337: End If;
338: --
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: End pre_insert;
342: --
343: -- ----------------------------------------------------------------------------
344: -- |----------------------------< post_insert >-------------------------------|
383: --
384: l_proc varchar2(72) := g_package||'post_insert';
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: begin
389: --
390: pay_cal_rki.after_insert
391: (p_effective_date
429: ,p_hook_type => 'AI');
430: --
431: end;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 10);
434: End post_insert;
435: --
436: -- ----------------------------------------------------------------------------
437: -- |-------------------------------< ins_lck >--------------------------------|
481: l_validation_start_date date;
482: l_validation_end_date date;
483: --
484: Begin
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: -- Validate the datetrack mode mode getting the validation start
488: -- and end dates for the specified datetrack operation.
489: --
502: --
503: p_validation_start_date := l_validation_start_date;
504: p_validation_end_date := l_validation_end_date;
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: --
508: End ins_lck;
509: --
510: -- ----------------------------------------------------------------------------
520: l_validation_start_date date;
521: l_validation_end_date date;
522: --
523: Begin
524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- Call the lock operation
527: --
528: pay_cal_ins.ins_lck
578: --
579: -- Call to raise any errors on multi-message list
580: hr_multi_message.end_validation_set;
581: --
582: hr_utility.set_location('Leaving:'||l_proc,10);
583: end ins;
584: --
585: -- ----------------------------------------------------------------------------
586: -- |---------------------------------< ins >----------------------------------|
604: l_rec pay_cal_shd.g_rec_type;
605: l_proc varchar2(72) := g_package||'ins';
606: --
607: Begin
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: -- Call conversion function to turn arguments into the
611: -- p_rec structure.
612: --
642: p_effective_end_date := l_rec.effective_end_date;
643: p_object_version_number := l_rec.object_version_number;
644: --
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 10);
647: End ins;
648: --
649: end pay_cal_ins;