DBA Data[Home] [Help]

APPS.PER_DIS_INS dependencies on PER_DIS_SHD

Line 58: (p_rec in out nocopy per_dis_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy per_dis_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 72: per_dis_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from per_disabilities_f t
70: where t.disability_id = p_rec.disability_id
71: and t.effective_start_date =
72: per_dis_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by per_disabilities_f.created_by%TYPE;

Line 316: per_dis_shd.constraint_error

312: Exception
313: When hr_api.check_integrity_violated Then
314: -- A check constraint has been violated
315: --
316: per_dis_shd.constraint_error
317: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
318: When hr_api.unique_integrity_violated Then
319: -- Unique integrity has been violated
320: --

Line 321: per_dis_shd.constraint_error

317: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
318: When hr_api.unique_integrity_violated Then
319: -- Unique integrity has been violated
320: --
321: per_dis_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When Others Then
324: --
325: Raise;

Line 332: (p_rec in out nocopy per_dis_shd.g_rec_type

328: -- ----------------------------------------------------------------------------
329: -- |------------------------------< insert_dml >------------------------------|
330: -- ----------------------------------------------------------------------------
331: Procedure insert_dml
332: (p_rec in out nocopy per_dis_shd.g_rec_type
333: ,p_effective_date in date
334: ,p_datetrack_mode in varchar2
335: ,p_validation_start_date in date
336: ,p_validation_end_date in date

Line 395: (p_rec in out nocopy per_dis_shd.g_rec_type

391: --
392: -- {End Of Comments}
393: -- ----------------------------------------------------------------------------
394: Procedure pre_insert
395: (p_rec in out nocopy per_dis_shd.g_rec_type
396: ,p_effective_date in date
397: ,p_datetrack_mode in varchar2
398: ,p_validation_start_date in date
399: ,p_validation_end_date in date

Line 453: (p_rec in per_dis_shd.g_rec_type

449: --
450: -- {End Of Comments}
451: -- ----------------------------------------------------------------------------
452: Procedure post_insert
453: (p_rec in per_dis_shd.g_rec_type
454: ,p_effective_date in date
455: ,p_datetrack_mode in varchar2
456: ,p_validation_start_date in date
457: ,p_validation_end_date in date

Line 687: ,p_rec in per_dis_shd.g_rec_type

683: -- ----------------------------------------------------------------------------
684: Procedure ins_lck
685: (p_effective_date in date
686: ,p_datetrack_mode in varchar2
687: ,p_rec in per_dis_shd.g_rec_type
688: ,p_validation_start_date out nocopy date
689: ,p_validation_end_date out nocopy date
690: ) is
691: --

Line 730: ,p_rec in out nocopy per_dis_shd.g_rec_type

726: -- |---------------------------------< ins >----------------------------------|
727: -- ----------------------------------------------------------------------------
728: Procedure ins
729: (p_effective_date in date
730: ,p_rec in out nocopy per_dis_shd.g_rec_type
731: ) is
732: --
733: l_proc varchar2(72) := g_package||'ins';
734: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 881: l_rec per_dis_shd.g_rec_type;

877: ,p_effective_start_date out nocopy date
878: ,p_effective_end_date out nocopy date
879: ) is
880: --
881: l_rec per_dis_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'ins';
883: --
884: Begin
885: hr_utility.set_location('Entering:'||l_proc, 5);

Line 891: per_dis_shd.convert_args

887: -- Call conversion function to turn arguments into the
888: -- p_rec structure.
889: --
890: l_rec :=
891: per_dis_shd.convert_args
892: (null
893: ,null
894: ,null
895: ,p_person_id