DBA Data[Home] [Help]

APPS.PER_CTC_INS dependencies on PER_CTC_SHD

Line 58: (p_rec in out nocopy per_ctc_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy per_ctc_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) is

Line 73: per_ctc_shd.g_old_rec.effective_start_date

69:
70: from per_contracts_f t
71: where t.contract_id = p_rec.contract_id
72: and t.effective_start_date =
73: per_ctc_shd.g_old_rec.effective_start_date
74: and t.effective_end_date = (p_validation_start_date - 1);
75: --
76: l_proc varchar2(72) := g_package||'dt_insert_dml';
77: l_created_by per_contracts_f.created_by%TYPE;

Line 283: per_ctc_shd.constraint_error

279: --
280: Exception
281: When hr_api.check_integrity_violated Then
282: -- A check constraint has been violated
283: per_ctc_shd.constraint_error
284: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285: When hr_api.unique_integrity_violated Then
286: -- Unique integrity has been violated
287: per_ctc_shd.constraint_error

Line 287: per_ctc_shd.constraint_error

283: per_ctc_shd.constraint_error
284: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285: When hr_api.unique_integrity_violated Then
286: -- Unique integrity has been violated
287: per_ctc_shd.constraint_error
288: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
289: When Others Then
290: Raise;
291: End dt_insert_dml;

Line 297: (p_rec in out nocopy per_ctc_shd.g_rec_type,

293: -- ----------------------------------------------------------------------------
294: -- |------------------------------< insert_dml >------------------------------|
295: -- ----------------------------------------------------------------------------
296: Procedure insert_dml
297: (p_rec in out nocopy per_ctc_shd.g_rec_type,
298: p_effective_date in date,
299: p_datetrack_mode in varchar2,
300: p_validation_start_date in date,
301: p_validation_end_date in date) is

Line 358: (p_rec in out nocopy per_ctc_shd.g_rec_type,

354: --
355: -- {End Of Comments}
356: -- ----------------------------------------------------------------------------
357: Procedure pre_insert
358: (p_rec in out nocopy per_ctc_shd.g_rec_type,
359: p_effective_date in date,
360: p_datetrack_mode in varchar2,
361: p_validation_start_date in date,
362: p_validation_end_date in date) is

Line 415: (p_rec in per_ctc_shd.g_rec_type,

411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure post_insert
415: (p_rec in per_ctc_shd.g_rec_type,
416: p_effective_date in date,
417: p_datetrack_mode in varchar2,
418: p_validation_start_date in date,
419: p_validation_end_date in date) is

Line 557: p_rec in per_ctc_shd.g_rec_type,

553: -- ----------------------------------------------------------------------------
554: Procedure ins_lck
555: (p_effective_date in date,
556: p_datetrack_mode in varchar2,
557: p_rec in per_ctc_shd.g_rec_type,
558: p_validation_start_date out nocopy date,
559: p_validation_end_date out nocopy date) is
560: --
561: l_proc varchar2(72) := g_package||'ins_lck';

Line 599: p_rec in out nocopy per_ctc_shd.g_rec_type,

595: -- |---------------------------------< ins >----------------------------------|
596: -- ----------------------------------------------------------------------------
597: Procedure ins
598: (
599: p_rec in out nocopy per_ctc_shd.g_rec_type,
600: p_effective_date in date
601: ) is
602: --
603: l_proc varchar2(72) := g_package||'ins';

Line 730: l_rec per_ctc_shd.g_rec_type;

726: p_attribute20 in varchar2 default null,
727: p_effective_date in date
728: ) is
729: --
730: l_rec per_ctc_shd.g_rec_type;
731: l_proc varchar2(72) := g_package||'ins';
732: --
733: Begin
734: hr_utility.set_location('Entering:'||l_proc, 5);

Line 740: per_ctc_shd.convert_args

736: -- Call conversion function to turn arguments into the
737: -- p_rec structure.
738: --
739: l_rec :=
740: per_ctc_shd.convert_args
741: (
742: null,
743: null,
744: null,