DBA Data[Home] [Help]

APPS.PER_SSB_INS dependencies on PER_SSB_SHD

Line 76: (p_rec in out nocopy per_ssb_shd.g_rec_type

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

Line 123: per_ssb_shd.constraint_error

119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: --
123: per_ssb_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --

Line 128: per_ssb_shd.constraint_error

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

Line 133: per_ssb_shd.constraint_error

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

Line 178: (p_rec in out nocopy per_ssb_shd.g_rec_type

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure pre_insert
178: (p_rec in out nocopy per_ssb_shd.g_rec_type
179: ) is
180:
181: --
182: Cursor C_Sel2 is

Line 265: ,p_rec in per_ssb_shd.g_rec_type

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

Line 307: ,p_rec in out nocopy per_ssb_shd.g_rec_type

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

Line 364: l_rec per_ssb_shd.g_rec_type;

360: ,p_legislation_code In varchar2
361: ,p_object_version_number out nocopy number
362: ) is
363: --
364: l_rec per_ssb_shd.g_rec_type;
365: l_proc varchar2(72) := g_package||'ins';
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);

Line 374: per_ssb_shd.convert_args

370: -- Call conversion function to turn arguments into the
371: -- p_rec structure.
372: --
373: l_rec :=
374: per_ssb_shd.convert_args
375: (null
376: ,p_setup_task_code
377: ,p_setup_sub_task_sequence
378: ,p_setup_sub_task_status