DBA Data[Home] [Help]

APPS.PER_SCN_UPD dependencies on PER_SCN_SHD

Line 55: (p_rec in out nocopy per_scn_shd.g_rec_type

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

Line 90: per_scn_shd.constraint_error

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

Line 95: per_scn_shd.constraint_error

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

Line 100: per_scn_shd.constraint_error

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

Line 140: (p_rec in per_scn_shd.g_rec_type

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

Line 184: (p_rec in per_scn_shd.g_rec_type

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

Line 205: => per_scn_shd.g_old_rec.name

201: => p_rec.name
202: ,p_object_version_number
203: => p_rec.object_version_number
204: ,p_name_o
205: => per_scn_shd.g_old_rec.name
206: ,p_object_version_number_o
207: => per_scn_shd.g_old_rec.object_version_number
208: );
209: --

Line 207: => per_scn_shd.g_old_rec.object_version_number

203: => p_rec.object_version_number
204: ,p_name_o
205: => per_scn_shd.g_old_rec.name
206: ,p_object_version_number_o
207: => per_scn_shd.g_old_rec.object_version_number
208: );
209: --
210: exception
211: --

Line 267: (p_rec in out nocopy per_scn_shd.g_rec_type

263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure convert_defs
267: (p_rec in out nocopy per_scn_shd.g_rec_type
268: ) is
269: --
270: Begin
271: --

Line 279: per_scn_shd.g_old_rec.name;

275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.name = hr_api.g_varchar2) then
278: p_rec.name :=
279: per_scn_shd.g_old_rec.name;
280: End If;
281: /* If (p_rec.template_file = hr_api.g_varchar2) then
282: p_rec.template_file :=
283: per_scn_shd.g_old_rec.template_file;

Line 283: per_scn_shd.g_old_rec.template_file;

279: per_scn_shd.g_old_rec.name;
280: End If;
281: /* If (p_rec.template_file = hr_api.g_varchar2) then
282: p_rec.template_file :=
283: per_scn_shd.g_old_rec.template_file;
284: End If; */
285: --
286: End convert_defs;
287: --

Line 292: (p_rec in out nocopy per_scn_shd.g_rec_type

288: -- ----------------------------------------------------------------------------
289: -- |---------------------------------< upd >----------------------------------|
290: -- ----------------------------------------------------------------------------
291: Procedure upd
292: (p_rec in out nocopy per_scn_shd.g_rec_type
293: ) is
294: --
295: l_proc varchar2(72) := g_package||'upd';
296: --

Line 302: per_scn_shd.lck

298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- We must lock the row which we need to update.
301: --
302: per_scn_shd.lck
303: (p_rec.solution_id
304: ,p_rec.component_name
305: ,p_rec.solution_type_name
306: ,p_rec.object_version_number

Line 352: l_rec per_scn_shd.g_rec_type;

348: ,p_object_version_number in out nocopy number
349: ,p_name in varchar2 default hr_api.g_varchar2
350: ) is
351: --
352: l_rec per_scn_shd.g_rec_type;
353: l_proc varchar2(72) := g_package||'upd';
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);

Line 362: per_scn_shd.convert_args

358: -- Call conversion function to turn arguments into the
359: -- l_rec structure.
360: --
361: l_rec :=
362: per_scn_shd.convert_args
363: (p_solution_id
364: ,p_component_name
365: ,p_solution_type_name
366: ,p_name