DBA Data[Home] [Help]

APPS.PER_PDP_INS dependencies on PER_PDP_SHD

Line 76: (p_rec in out nocopy per_pdp_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy per_pdp_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 237: per_pdp_shd.constraint_error

233: Exception
234: When hr_api.check_integrity_violated Then
235: -- A check constraint has been violated
236: --
237: per_pdp_shd.constraint_error
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
240: -- Parent integrity has been violated
241: --

Line 242: per_pdp_shd.constraint_error

238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When hr_api.parent_integrity_violated Then
240: -- Parent integrity has been violated
241: --
242: per_pdp_shd.constraint_error
243: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244: When hr_api.unique_integrity_violated Then
245: -- Unique integrity has been violated
246: --

Line 247: per_pdp_shd.constraint_error

243: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244: When hr_api.unique_integrity_violated Then
245: -- Unique integrity has been violated
246: --
247: per_pdp_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When Others Then
250: --
251: Raise;

Line 292: (p_rec in out nocopy per_pdp_shd.g_rec_type

288: --
289: -- {End Of Comments}
290: -- ----------------------------------------------------------------------------
291: Procedure pre_insert
292: (p_rec in out nocopy per_pdp_shd.g_rec_type
293: ) is
294: --
295: Cursor C_Sel1 is select per_periods_of_placement_s.nextval from sys.dual;
296: --

Line 380: ,p_rec in per_pdp_shd.g_rec_type

376: -- {End Of Comments}
377: -- ----------------------------------------------------------------------------
378: Procedure post_insert
379: (p_effective_date in date
380: ,p_rec in per_pdp_shd.g_rec_type
381: ) is
382: --
383: l_proc varchar2(72) := g_package||'post_insert';
384: --

Line 545: ,p_rec in out nocopy per_pdp_shd.g_rec_type

541: -- |---------------------------------< ins >----------------------------------|
542: -- ----------------------------------------------------------------------------
543: Procedure ins
544: (p_effective_date in date
545: ,p_rec in out nocopy per_pdp_shd.g_rec_type
546: ) is
547: --
548: l_proc varchar2(72) := g_package||'ins';
549: --

Line 659: l_rec per_pdp_shd.g_rec_type;

655: ,p_validate_df_flex in boolean default true
656: ,p_object_version_number out nocopy number
657: ) is
658: --
659: l_rec per_pdp_shd.g_rec_type;
660: l_proc varchar2(72) := g_package||'ins';
661: --
662: Begin
663: hr_utility.set_location('Entering:'||l_proc, 5);

Line 672: per_pdp_shd.g_validate_df_flex := p_validate_df_flex;

668: -- This is necessary because flexfield attributes are not
669: -- populated when creating the default PDP and mandatory
670: -- flexfield attributes would otherwise raise an error.
671: --
672: per_pdp_shd.g_validate_df_flex := p_validate_df_flex;
673:
674: --
675: -- Call conversion function to turn arguments into the
676: -- p_rec structure.

Line 679: per_pdp_shd.convert_args

675: -- Call conversion function to turn arguments into the
676: -- p_rec structure.
677: --
678: l_rec :=
679: per_pdp_shd.convert_args
680: (null
681: ,p_business_group_id
682: ,p_person_id
683: ,p_date_start