DBA Data[Home] [Help]

APPS.PER_SOS_UPD dependencies on PER_SOS_SHD

Line 55: (p_rec in out nocopy per_sos_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_sos_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 88: per_sos_shd.constraint_error

84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: --
88: per_sos_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --

Line 93: per_sos_shd.constraint_error

89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: --
93: per_sos_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --

Line 98: per_sos_shd.constraint_error

94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: --
98: per_sos_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: --
102: Raise;

Line 138: (p_rec in per_sos_shd.g_rec_type

134: --
135: -- {End Of Comments}
136: -- ----------------------------------------------------------------------------
137: Procedure pre_update
138: (p_rec in per_sos_shd.g_rec_type
139: ) is
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --

Line 182: (p_rec in per_sos_shd.g_rec_type

178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure post_update
182: (p_rec in per_sos_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --

Line 201: => per_sos_shd.g_old_rec.object_version_number

197: => p_rec.user_id
198: ,p_object_version_number
199: => p_rec.object_version_number
200: ,p_object_version_number_o
201: => per_sos_shd.g_old_rec.object_version_number
202: );
203: --
204: exception
205: --

Line 261: (p_rec in out nocopy per_sos_shd.g_rec_type

257: --
258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure convert_defs
261: (p_rec in out nocopy per_sos_shd.g_rec_type
262: ) is
263: --
264: Begin
265: --

Line 279: (p_rec in out nocopy per_sos_shd.g_rec_type

275: -- ----------------------------------------------------------------------------
276: -- |---------------------------------< upd >----------------------------------|
277: -- ----------------------------------------------------------------------------
278: Procedure upd
279: (p_rec in out nocopy per_sos_shd.g_rec_type
280: ) is
281: --
282: l_proc varchar2(72) := g_package||'upd';
283: --

Line 289: per_sos_shd.lck

285: hr_utility.set_location('Entering:'||l_proc, 5);
286: --
287: -- We must lock the row which we need to update.
288: --
289: per_sos_shd.lck
290: (p_rec.solution_id
291: ,p_rec.solution_set_name
292: ,p_rec.user_id
293: ,p_rec.object_version_number

Line 338: l_rec per_sos_shd.g_rec_type;

334: ,p_user_id in number
335: ,p_object_version_number in out nocopy number
336: ) is
337: --
338: l_rec per_sos_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);

Line 348: per_sos_shd.convert_args

344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
347: l_rec :=
348: per_sos_shd.convert_args
349: (p_solution_id
350: ,p_solution_set_name
351: ,p_user_id
352: ,p_object_version_number