APPS.PER_ZA_ASS_INS dependencies on PER_ZA_ASS_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_za_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_ass_shd.g_za_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: per_za_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_ass_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: per_za_assessments
64: --
65: insert into per_za_assessments (

Line 113: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

109: p_rec.date_of_accreditation,
110: p_rec.certification_expiry_date
111: );
112: --
113: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: Exception
117: When hr_api.check_integrity_violated Then

Line 119: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
120: per_za_ass_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated

Line 120: per_za_ass_shd.constraint_error

116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
120: per_za_ass_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

Line 124: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

120: per_za_ass_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
125: per_za_ass_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated

Line 125: per_za_ass_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
125: per_za_ass_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

Line 129: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

125: per_za_ass_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
130: per_za_ass_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

Line 130: per_za_ass_shd.constraint_error

126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
130: per_za_ass_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;

Line 133: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status

129: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
130: per_za_ass_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
134: Raise;
135: End insert_dml;
136:
137: -- ----------------------------------------------------------------------------

Line 169: Procedure post_insert(p_rec in per_za_ass_shd.g_za_rec_type) is

165: -- Internal Table Handler Use Only.
166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure post_insert(p_rec in per_za_ass_shd.g_za_rec_type) is
170: --
171: l_proc varchar2(72) := g_package||'post_insert';
172: --
173: Begin

Line 184: p_rec in out nocopy per_za_ass_shd.g_za_rec_type,

180: -- |---------------------------------< ins >----------------------------------|
181: -- ----------------------------------------------------------------------------
182: Procedure ins
183: (
184: p_rec in out nocopy per_za_ass_shd.g_za_rec_type,
185: p_validate in boolean default false
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'ins';

Line 256: l_rec per_za_ass_shd.g_za_rec_type;

252: p_certification_expiry_date in date default null,
253: p_validate in boolean default false
254: ) is
255: --
256: l_rec per_za_ass_shd.g_za_rec_type;
257: l_proc varchar2(72) := g_package||'ins';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);

Line 266: per_za_ass_shd.convert_args

262: -- Call conversion function to turn arguments into the
263: -- p_rec structure.
264: --
265: l_rec :=
266: per_za_ass_shd.convert_args
267: (
268: p_assessment_id,
269: p_person_id,
270: p_level_id,