DBA Data[Home] [Help]

APPS.PER_SLS_INS dependencies on PER_SLS_SHD

Line 79: (p_rec in out nocopy per_sls_shd.g_rec_type

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

Line 118: per_sls_shd.constraint_error

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

Line 123: per_sls_shd.constraint_error

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

Line 128: per_sls_shd.constraint_error

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

Line 173: (p_rec in out nocopy per_sls_shd.g_rec_type

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

Line 261: ,p_rec in per_sls_shd.g_rec_type

257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure post_insert
260: (p_effective_date in date
261: ,p_rec in per_sls_shd.g_rec_type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'post_insert';
265: --

Line 304: ,p_rec in out nocopy per_sls_shd.g_rec_type

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

Line 356: l_rec per_sls_shd.g_rec_type;

352: ,p_user_id out nocopy number
353: ,p_object_version_number out nocopy number
354: ) is
355: --
356: l_rec per_sls_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'ins';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);

Line 366: per_sls_shd.convert_args

362: -- Call conversion function to turn arguments into the
363: -- p_rec structure.
364: --
365: l_rec :=
366: per_sls_shd.convert_args
367: (null
368: ,null
369: ,p_description
370: ,p_status