DBA Data[Home] [Help]

APPS.PER_SCN_INS dependencies on PER_SCN_SHD

Line 82: (p_rec in out nocopy per_scn_shd.g_rec_type

78: --
79: -- {End Of Comments}
80: -- ----------------------------------------------------------------------------
81: Procedure insert_dml
82: (p_rec in out nocopy per_scn_shd.g_rec_type
83: ) is
84: --
85: l_proc varchar2(72) := g_package||'insert_dml';
86: --

Line 119: per_scn_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: per_scn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --

Line 124: per_scn_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --
124: per_scn_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --

Line 129: per_scn_shd.constraint_error

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

Line 174: (p_rec in out nocopy per_scn_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_insert
174: (p_rec in out nocopy per_scn_shd.g_rec_type
175: ) is
176: --
177: Cursor C_Sel2 is
178: Select null

Line 266: (p_rec in per_scn_shd.g_rec_type

262: --
263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure post_insert
266: (p_rec in per_scn_shd.g_rec_type
267: ) is
268: --
269: l_proc varchar2(72) := g_package||'post_insert';
270: --

Line 305: (p_rec in out nocopy per_scn_shd.g_rec_type

301: -- ----------------------------------------------------------------------------
302: -- |---------------------------------< ins >----------------------------------|
303: -- ----------------------------------------------------------------------------
304: Procedure ins
305: (p_rec in out nocopy per_scn_shd.g_rec_type
306: ) is
307: --
308: l_proc varchar2(72) := g_package||'ins';
309: --

Line 353: l_rec per_scn_shd.g_rec_type;

349: ,p_solution_type_name out nocopy varchar2
350: ,p_object_version_number out nocopy number
351: ) is
352: --
353: l_rec per_scn_shd.g_rec_type;
354: l_proc varchar2(72) := g_package||'ins';
355: --
356: Begin
357: hr_utility.set_location('Entering:'||l_proc, 5);

Line 363: per_scn_shd.convert_args

359: -- Call conversion function to turn arguments into the
360: -- p_rec structure.
361: --
362: l_rec :=
363: per_scn_shd.convert_args
364: (null
365: ,null
366: ,null
367: ,p_name