APPS.PER_SHA_INS dependencies on PER_SHA_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy per_sha_shd.g_rec_type) is

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

Line 125: per_sha_shd.constraint_error

121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_sha_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: per_sha_shd.constraint_error

Line 129: per_sha_shd.constraint_error

125: per_sha_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: per_sha_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: per_sha_shd.constraint_error

Line 133: per_sha_shd.constraint_error

129: per_sha_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: per_sha_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: Raise;
137: End insert_dml;

Line 176: Procedure pre_insert(p_rec in out nocopy per_sha_shd.g_rec_type) is

172: -- Internal Row Handler Use Only.
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_insert(p_rec in out nocopy per_sha_shd.g_rec_type) is
177: --
178: l_proc varchar2(72) := g_package||'pre_insert';
179: --
180: Cursor C_Sel1 is select per_std_holiday_absences_s.nextval from sys.dual;

Line 227: Procedure post_insert(p_rec in per_sha_shd.g_rec_type) is

223: -- Internal Row Handler Use Only.
224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure post_insert(p_rec in per_sha_shd.g_rec_type) is
228: --
229: l_proc varchar2(72) := g_package||'post_insert';
230: --
231: Begin

Line 283: p_rec in out nocopy per_sha_shd.g_rec_type

279: -- |---------------------------------< ins >----------------------------------|
280: -- ----------------------------------------------------------------------------
281: Procedure ins
282: (
283: p_rec in out nocopy per_sha_shd.g_rec_type
284: ) is
285: --
286: l_proc varchar2(72) := g_package||'ins';
287: --

Line 344: l_rec per_sha_shd.g_rec_type;

340: p_attribute20 in varchar2 default null,
341: p_object_version_number out nocopy number
342: ) is
343: --
344: l_rec per_sha_shd.g_rec_type;
345: l_proc varchar2(72) := g_package||'ins';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);

Line 354: per_sha_shd.convert_args

350: -- Call conversion function to turn arguments into the
351: -- p_rec structure.
352: --
353: l_rec :=
354: per_sha_shd.convert_args
355: (
356: null,
357: p_date_not_taken,
358: p_person_id,