APPS.PER_CPN_INS dependencies on PER_CPN_SHD

Line 48: Procedure insert_dml(p_rec in out nocopy per_cpn_shd.g_rec_type) is

44: -- Internal Table Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure insert_dml(p_rec in out nocopy per_cpn_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'insert_dml';
51: --
52: Begin

Line 205: per_cpn_shd.constraint_error

201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: Exception
203: When hr_api.check_integrity_violated Then
204: -- A check constraint has been violated
205: per_cpn_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: per_cpn_shd.constraint_error

Line 209: per_cpn_shd.constraint_error

205: per_cpn_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: per_cpn_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When hr_api.unique_integrity_violated Then
212: -- Unique integrity has been violated
213: per_cpn_shd.constraint_error

Line 213: per_cpn_shd.constraint_error

209: per_cpn_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When hr_api.unique_integrity_violated Then
212: -- Unique integrity has been violated
213: per_cpn_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: Raise;
217: End insert_dml;

Line 256: Procedure pre_insert(p_rec in out nocopy per_cpn_shd.g_rec_type) is

252: -- Internal Table Handler Use Only.
253: --
254: -- {End Of Comments}
255: -- ----------------------------------------------------------------------------
256: Procedure pre_insert(p_rec in out nocopy per_cpn_shd.g_rec_type) is
257: --
258: l_proc varchar2(72) := g_package||'pre_insert';
259: --
260: cursor C_Sel1 is select per_competences_s.nextval from sys.dual;

Line 304: Procedure post_insert(p_rec in per_cpn_shd.g_rec_type) is

300: -- Internal Table Handler Use Only.
301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure post_insert(p_rec in per_cpn_shd.g_rec_type) is
305: --
306: l_proc varchar2(72) := g_package||'post_insert';
307: --
308: Begin

Line 402: p_rec in out nocopy per_cpn_shd.g_rec_type,

398: -- |---------------------------------< ins >----------------------------------|
399: -- ----------------------------------------------------------------------------
400: Procedure ins
401: (
402: p_rec in out nocopy per_cpn_shd.g_rec_type,
403: p_effective_date in date default null,
404: p_validate in boolean default false
405: ) is
406: --

Line 530: l_rec per_cpn_shd.g_rec_type;

526: ,p_information19 in varchar2 default null
527: ,p_information20 in varchar2 default null
528: ) is
529: --
530: l_rec per_cpn_shd.g_rec_type;
531: l_proc varchar2(72) := g_package||'ins';
532: --
533: Begin
534: hr_utility.set_location('Entering:'||l_proc, 5);

Line 540: per_cpn_shd.convert_args

536: -- Call conversion function to turn arguments into the
537: -- p_rec structure.
538: -- ngundura added competence_alias as a parameter to convert args
539: l_rec :=
540: per_cpn_shd.convert_args
541: (
542: null,
543: p_name,
544: p_business_group_id,