DBA Data[Home] [Help]

APPS.PER_ASP_INS dependencies on PER_ASP_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_asp_shd.g_rec_type) is

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

Line 92: per_asp_shd.constraint_error

88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: per_asp_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: per_asp_shd.constraint_error

Line 96: per_asp_shd.constraint_error

92: per_asp_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: per_asp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: per_asp_shd.constraint_error

Line 100: per_asp_shd.constraint_error

96: per_asp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: per_asp_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: Raise;
104: End insert_dml;

Line 143: Procedure pre_insert(p_rec in out nocopy per_asp_shd.g_rec_type) is

139: -- Internal Row Handler Use Only.
140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure pre_insert(p_rec in out nocopy per_asp_shd.g_rec_type) is
144: --
145: l_proc varchar2(72) := g_package||'pre_insert';
146: --
147: Cursor C_Sel1 is select per_sec_profile_assignments_s.nextval from sys.dual;

Line 194: Procedure post_insert(p_rec in per_asp_shd.g_rec_type) is

190: -- Internal Row Handler Use Only.
191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure post_insert(p_rec in per_asp_shd.g_rec_type) is
195: --
196: l_proc varchar2(72) := g_package||'post_insert';
197: --
198: Begin

Line 255: p_rec in out nocopy per_asp_shd.g_rec_type

251: -- |---------------------------------< ins >----------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure ins
254: (
255: p_rec in out nocopy per_asp_shd.g_rec_type
256: ) is
257: --
258: l_proc varchar2(72) := g_package||'ins';
259: --

Line 297: l_rec per_asp_shd.g_rec_type;

293: p_end_date in date default null,
294: p_object_version_number out nocopy number
295: ) is
296: --
297: l_rec per_asp_shd.g_rec_type;
298: l_proc varchar2(72) := g_package||'ins';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);

Line 307: per_asp_shd.convert_args

303: -- Call conversion function to turn arguments into the
304: -- p_rec structure.
305: --
306: l_rec :=
307: per_asp_shd.convert_args
308: (
309: null,
310: p_user_id,
311: p_security_group_id,