DBA Data[Home] [Help]

APPS.PER_STC_INS dependencies on PER_STC_SHD

Line 82: (p_rec in out nocopy per_stc_shd.g_rec_type

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

Line 123: per_stc_shd.constraint_error

119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: --
123: per_stc_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_stc_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_stc_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_stc_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_stc_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_stc_shd.g_rec_type

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

Line 268: ,p_rec in per_stc_shd.g_rec_type

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

Line 315: ,p_rec in out nocopy per_stc_shd.g_rec_type

311: -- |---------------------------------< ins >----------------------------------|
312: -- ----------------------------------------------------------------------------
313: Procedure ins
314: (p_effective_date in date
315: ,p_rec in out nocopy per_stc_shd.g_rec_type
316: ) is
317: --
318: l_proc varchar2(72) := g_package||'ins';
319: --

Line 369: l_rec per_stc_shd.g_rec_type;

365: ,p_legislation_code out nocopy varchar2
366: ,p_object_version_number out nocopy number
367: ) is
368: --
369: l_rec per_stc_shd.g_rec_type;
370: l_proc varchar2(72) := g_package||'ins';
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);

Line 379: per_stc_shd.convert_args

375: -- Call conversion function to turn arguments into the
376: -- p_rec structure.
377: --
378: l_rec :=
379: per_stc_shd.convert_args
380: (null
381: ,null
382: ,null
383: ,p_api_name