APPS.PER_ZA_AO_ASS_INS dependencies on PER_ZA_AO_ASS_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_za_ao_ass_shd.g_za_rec_type) is

49: -- Internal Table Handler Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy per_za_ao_ass_shd.g_za_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: per_za_ao_ass_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59:
60: --
61: per_za_ao_ass_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_za_ao_assessments
64: --
65: insert into per_za_areas_of_assessment(

Line 81: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

77: p_rec.assessment_result,
78: p_rec.assessment_criteria
79: );
80: --
81: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: Exception
85: When hr_api.check_integrity_violated Then

Line 87: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
88: per_za_ao_ass_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated

Line 88: per_za_ao_ass_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
88: per_za_ao_ass_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

Line 92: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

88: per_za_ao_ass_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
93: per_za_ao_ass_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated

Line 93: per_za_ao_ass_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
93: per_za_ao_ass_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

Line 97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

93: per_za_ao_ass_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_ao_ass_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

Line 98: per_za_ao_ass_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_ao_ass_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;

Line 101: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status

97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_ao_ass_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;
103: End insert_dml;
104:
105: -- ----------------------------------------------------------------------------

Line 137: Procedure post_insert(p_rec in per_za_ao_ass_shd.g_za_rec_type) is

133: -- Internal Table Handler Use Only.
134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure post_insert(p_rec in per_za_ao_ass_shd.g_za_rec_type) is
138: --
139: l_proc varchar2(72) := g_package||'post_insert';
140: --
141: Begin

Line 152: p_rec in out nocopy per_za_ao_ass_shd.g_za_rec_type,

148: -- |---------------------------------< ins >----------------------------------|
149: -- ----------------------------------------------------------------------------
150: Procedure ins
151: (
152: p_rec in out nocopy per_za_ao_ass_shd.g_za_rec_type,
153: p_validate in boolean default false
154: ) is
155: --
156: l_proc varchar2(72) := g_package||'ins';

Line 208: l_rec per_za_ao_ass_shd.g_za_rec_type;

204: p_assessment_criteria in varchar2 default null,
205: p_validate in boolean default false
206: ) is
207: --
208: l_rec per_za_ao_ass_shd.g_za_rec_type;
209: l_proc varchar2(72) := g_package||'ins';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);

Line 218: per_za_ao_ass_shd.convert_args

214: -- Call conversion function to turn arguments into the
215: -- p_rec structure.
216: --
217: l_rec :=
218: per_za_ao_ass_shd.convert_args
219: (
220: p_area_of_assessment_id,
221: p_assessment_id,
222: p_area_of_assessment,