DBA Data[Home] [Help]

APPS.PER_STB_INS dependencies on PER_STB_SHD

Line 76: (p_rec in out nocopy per_stb_shd.g_rec_type

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

Line 119: per_stb_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: per_stb_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_stb_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_stb_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_stb_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_stb_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_stb_shd.g_rec_type

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

Line 261: ,p_rec in per_stb_shd.g_rec_type

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

Line 301: ,p_rec in out nocopy per_stb_shd.g_rec_type

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

Line 356: l_rec per_stb_shd.g_rec_type;

352: ,p_setup_task_code out nocopy varchar2
353: ,p_object_version_number out nocopy number
354: ) is
355: --
356: l_rec per_stb_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_stb_shd.convert_args

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