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 140: per_stc_shd.constraint_error

136: Exception
137: When hr_api.check_integrity_violated Then
138: -- A check constraint has been violated
139: --
140: per_stc_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: --

Line 145: per_stc_shd.constraint_error

141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.parent_integrity_violated Then
143: -- Parent integrity has been violated
144: --
145: per_stc_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.unique_integrity_violated Then
148: -- Unique integrity has been violated
149: --

Line 150: per_stc_shd.constraint_error

146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.unique_integrity_violated Then
148: -- Unique integrity has been violated
149: --
150: per_stc_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: --
154: Raise;

Line 195: (p_rec in out nocopy per_stc_shd.g_rec_type

191: --
192: -- {End Of Comments}
193: -- ----------------------------------------------------------------------------
194: Procedure pre_insert
195: (p_rec in out nocopy per_stc_shd.g_rec_type
196: ) is
197: --
198: Cursor C_Sel2 is
199: Select null

Line 285: ,p_rec in per_stc_shd.g_rec_type

281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283: Procedure post_insert
284: (p_effective_date in date
285: ,p_rec in per_stc_shd.g_rec_type
286: ) is
287: --
288: l_proc varchar2(72) := g_package||'post_insert';
289: --

Line 332: ,p_rec in out nocopy per_stc_shd.g_rec_type

328: -- |---------------------------------< ins >----------------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure ins
331: (p_effective_date in date
332: ,p_rec in out nocopy per_stc_shd.g_rec_type
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'ins';
336: --

Line 386: l_rec per_stc_shd.g_rec_type;

382: ,p_legislation_code out nocopy varchar2
383: ,p_object_version_number out nocopy number
384: ) is
385: --
386: l_rec per_stc_shd.g_rec_type;
387: l_proc varchar2(72) := g_package||'ins';
388: --
389: Begin
390: hr_utility.set_location('Entering:'||l_proc, 5);

Line 396: per_stc_shd.convert_args

392: -- Call conversion function to turn arguments into the
393: -- p_rec structure.
394: --
395: l_rec :=
396: per_stc_shd.convert_args
397: (null
398: ,null
399: ,null
400: ,p_api_name