73: l_last_updated_by per_person_type_usages_f.last_updated_by%TYPE;
74: l_last_update_login per_person_type_usages_f.last_update_login%TYPE;
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: --
79: -- Get the object version number for the insert
80: --
81: p_rec.object_version_number :=
93: -- If the datetrack_mode is not INSERT then we must populate the WHO
94: -- columns with the 'old' creation values and 'new' updated values.
95: --
96: If (p_datetrack_mode <> 'INSERT') then
97: hr_utility.set_location(l_proc, 10);
98: --
99: -- Select the 'old' created values
100: --
101: Open C_Sel1;
105: -- The previous 'old' created row has not been found. We need
106: -- to error as an internal datetrack problem exists.
107: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
106: -- to error as an internal datetrack problem exists.
107: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
107: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: --
108: Close C_Sel1;
109: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','10');
112: hr_utility.raise_error;
113: End If;
114: Close C_Sel1;
115: --
116: -- Set the AOL updated WHO values
219: l_last_updated_by,
220: l_last_update_login
221: );
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 15);
224: --
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
247: --
248: l_proc varchar2(72) := g_package||'insert_dml';
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: dt_insert_dml(p_rec => p_rec,
254: p_effective_date => p_effective_date,
255: p_datetrack_mode => p_datetrack_mode,
255: p_datetrack_mode => p_datetrack_mode,
256: p_validation_start_date => p_validation_start_date,
257: p_validation_end_date => p_validation_end_date);
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: End insert_dml;
261: --
262: -- ----------------------------------------------------------------------------
263: -- |------------------------------< pre_insert >------------------------------|
309: --
310: Cursor C_Sel1 is select per_person_type_usages_s.nextval from sys.dual;
311: --
312: Begin
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: --
316: -- Select the next sequence number
317: --
319: Fetch C_Sel1 Into p_rec.person_type_usage_id;
320: Close C_Sel1;
321: --
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: End pre_insert;
325: --
326: -- ----------------------------------------------------------------------------
327: -- |-----------------------------< post_insert >------------------------------|
372: -- End of Fix for WWBUG 1408379
373: --
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: --
379: -- Start of API User Hook for post_insert.
380: begin
453: --
454: --
455: -- End of API User Hook for post_insert.
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: End post_insert;
459: --
460: -- ----------------------------------------------------------------------------
461: -- |-------------------------------< ins_lck >--------------------------------|
505: l_validation_start_date date;
506: l_validation_end_date date;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Validate the datetrack mode mode getting the validation start
512: -- and end dates for the specified datetrack operation.
513: --
528: --
529: p_validation_start_date := l_validation_start_date;
530: p_validation_end_date := l_validation_end_date;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: --
534: End ins_lck;
535: --
536: -- ----------------------------------------------------------------------------
547: l_validation_start_date date;
548: l_validation_end_date date;
549: --
550: Begin
551: hr_utility.set_location('Entering:'||l_proc, 5);
552: --
553: -- Call the lock operation
554: --
555: ins_lck
648: l_rec per_ptu_shd.g_rec_type;
649: l_proc varchar2(72) := g_package||'ins';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);
653: --
654: -- Call conversion function to turn arguments into the
655: -- p_rec structure.
656: --
713: p_effective_end_date := l_rec.effective_end_date;
714: p_object_version_number := l_rec.object_version_number;
715: --
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 10);
718: End ins;
719: --
720: end per_ptu_ins;