APPS.PER_CPL_INS dependencies on PER_CPL_SHD

Line 54: (p_rec in out NOCOPY per_cpl_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out NOCOPY per_cpl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 93: per_cpl_shd.constraint_error

89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: per_cpl_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --

Line 98: per_cpl_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: per_cpl_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --

Line 103: per_cpl_shd.constraint_error

99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: per_cpl_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;

Line 148: (p_rec in out NOCOPY per_cpl_shd.g_rec_type

144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_insert
148: (p_rec in out NOCOPY per_cpl_shd.g_rec_type
149: ,p_competence_id in number
150: ) is
151: --
152: l_proc varchar2(72) := g_package||'pre_insert';

Line 196: ,p_rec in per_cpl_shd.g_rec_type

192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure post_insert
195: (p_effective_date in date
196: ,p_rec in per_cpl_shd.g_rec_type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'post_insert';
200: --

Line 241: ,p_rec in out NOCOPY per_cpl_shd.g_rec_type

237: -- |---------------------------------< ins >----------------------------------|
238: -- ----------------------------------------------------------------------------
239: Procedure ins
240: (p_effective_date in date
241: ,p_rec in out NOCOPY per_cpl_shd.g_rec_type
242: ,p_competence_id in number
243: ) is
244: --
245: l_proc varchar2(72) := g_package||'ins';

Line 298: l_rec per_cpl_shd.g_rec_type;

294: ,p_behavioural_indicator in varchar2
295: ,p_description in varchar2
296: ) is
297: --
298: l_rec per_cpl_shd.g_rec_type;
299: l_proc varchar2(72) := g_package||'ins';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);

Line 308: per_cpl_shd.convert_args

304: -- Call conversion function to turn arguments into the
305: -- p_rec structure.
306: --
307: l_rec :=
308: per_cpl_shd.convert_args
309: (null
310: ,p_language
311: ,p_source_lang
312: ,p_name