50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ghr_cmp_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
394: Exception
395: When hr_api.check_integrity_violated Then
396: -- A check constraint has been violated
397: --
398: ghr_cmp_shd.constraint_error
399: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
400: When hr_api.parent_integrity_violated Then
401: -- Parent integrity has been violated
402: --
399: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
400: When hr_api.parent_integrity_violated Then
401: -- Parent integrity has been violated
402: --
403: ghr_cmp_shd.constraint_error
404: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
405: When hr_api.unique_integrity_violated Then
406: -- Unique integrity has been violated
407: --
404: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
405: When hr_api.unique_integrity_violated Then
406: -- Unique integrity has been violated
407: --
408: ghr_cmp_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When Others Then
411: --
412: Raise;
449: --
450: -- {End Of Comments}
451: -- ----------------------------------------------------------------------------
452: Procedure pre_insert
453: (p_rec in out nocopy ghr_cmp_shd.g_rec_type
454: ) is
455: --
456: l_proc varchar2(72) := g_package||'pre_insert';
457: --
503: -- {End Of Comments}
504: -- ----------------------------------------------------------------------------
505: Procedure post_insert
506: (p_effective_date in date
507: ,p_rec in ghr_cmp_shd.g_rec_type
508: ) is
509: --
510: l_proc varchar2(72) := g_package||'post_insert';
511: --
695: -- |---------------------------------< ins >----------------------------------|
696: -- ----------------------------------------------------------------------------
697: Procedure ins
698: (p_effective_date in date
699: ,p_rec in out nocopy ghr_cmp_shd.g_rec_type
700: ) is
701: --
702: l_proc varchar2(72) := g_package||'ins';
703: --
894: ,p_complaint_id out nocopy number
895: ,p_object_version_number out nocopy number
896: ) is
897: --
898: l_rec ghr_cmp_shd.g_rec_type;
899: l_proc varchar2(72) := g_package||'ins';
900: --
901: Begin
902: hr_utility.set_location('Entering:'||l_proc, 5);
904: -- Call conversion function to turn arguments into the
905: -- p_rec structure.
906: --
907: l_rec :=
908: ghr_cmp_shd.convert_args
909: (null
910: ,p_complainant_person_id
911: ,p_business_group_id
912: ,p_docket_number