APPS.PER_PTU_INS dependencies on PER_PTU_SHD

Line 52: (p_rec in out nocopy per_ptu_shd.g_rec_type,

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure dt_insert_dml
52: (p_rec in out nocopy per_ptu_shd.g_rec_type,
53: p_effective_date in date,
54: p_datetrack_mode in varchar2,
55: p_validation_start_date in date,
56: p_validation_end_date in date) is

Line 66: per_ptu_shd.g_old_rec.effective_start_date

62: t.creation_date
63: from per_person_type_usages_f t
64: where t.person_type_usage_id = p_rec.person_type_usage_id
65: and t.effective_start_date =
66: per_ptu_shd.g_old_rec.effective_start_date
67: and t.effective_end_date = (p_validation_start_date - 1);
68: --
69: l_proc varchar2(72) := g_package||'dt_insert_dml';
70: l_created_by per_person_type_usages_f.created_by%TYPE;

Line 228: per_ptu_shd.constraint_error

224: --
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: per_ptu_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: per_ptu_shd.constraint_error

Line 232: per_ptu_shd.constraint_error

228: per_ptu_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: per_ptu_shd.constraint_error
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When Others Then
235: Raise;
236: End dt_insert_dml;

Line 242: (p_rec in out nocopy per_ptu_shd.g_rec_type,

238: -- ----------------------------------------------------------------------------
239: -- |------------------------------< insert_dml >------------------------------|
240: -- ----------------------------------------------------------------------------
241: Procedure insert_dml
242: (p_rec in out nocopy per_ptu_shd.g_rec_type,
243: p_effective_date in date,
244: p_datetrack_mode in varchar2,
245: p_validation_start_date in date,
246: p_validation_end_date in date) is

Line 302: (p_rec in out nocopy per_ptu_shd.g_rec_type,

298: --
299: -- {End Of Comments}
300: -- ----------------------------------------------------------------------------
301: Procedure pre_insert
302: (p_rec in out nocopy per_ptu_shd.g_rec_type,
303: p_effective_date in date,
304: p_datetrack_mode in varchar2,
305: p_validation_start_date in date,
306: p_validation_end_date in date) is

Line 359: (p_rec in per_ptu_shd.g_rec_type,

355: --
356: -- {End Of Comments}
357: -- ----------------------------------------------------------------------------
358: Procedure post_insert
359: (p_rec in per_ptu_shd.g_rec_type,
360: p_effective_date in date,
361: p_datetrack_mode in varchar2,
362: p_validation_start_date in date,
363: p_validation_end_date in date) is

Line 500: p_rec in per_ptu_shd.g_rec_type,

496: -- ----------------------------------------------------------------------------
497: Procedure ins_lck
498: (p_effective_date in date,
499: p_datetrack_mode in varchar2,
500: p_rec in per_ptu_shd.g_rec_type,
501: p_validation_start_date out nocopy date,
502: p_validation_end_date out nocopy date) is
503: --
504: l_proc varchar2(72) := g_package||'ins_lck';

Line 541: p_rec in out nocopy per_ptu_shd.g_rec_type,

537: -- |---------------------------------< ins >----------------------------------|
538: -- ----------------------------------------------------------------------------
539: Procedure ins
540: (
541: p_rec in out nocopy per_ptu_shd.g_rec_type,
542: p_effective_date in date
543: ) is
544: --
545: l_proc varchar2(72) := g_package||'ins';

Line 648: l_rec per_ptu_shd.g_rec_type;

644: p_attribute30 in varchar2 default null,
645: p_effective_date in date
646: ) is
647: --
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);

Line 658: per_ptu_shd.convert_args

654: -- Call conversion function to turn arguments into the
655: -- p_rec structure.
656: --
657: l_rec :=
658: per_ptu_shd.convert_args
659: (
660: null,
661: p_person_id,
662: p_person_type_id,