DBA Data[Home] [Help]

APPS.HR_HRC_UPD dependencies on HR_HRC_SHD

Line 55: (p_rec in out nocopy hr_hrc_shd.g_rec_type

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

Line 87: hr_hrc_shd.constraint_error

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

Line 92: hr_hrc_shd.constraint_error

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

Line 97: hr_hrc_shd.constraint_error

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

Line 137: (p_rec in hr_hrc_shd.g_rec_type

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

Line 181: (p_rec in hr_hrc_shd.g_rec_type

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

Line 198: => hr_hrc_shd.g_old_rec.hierarchy_key

194: => p_rec.parent_hierarchy_id
195: ,p_object_version_number
196: => p_rec.object_version_number
197: ,p_hierarchy_key_o
198: => hr_hrc_shd.g_old_rec.hierarchy_key
199: ,p_parent_hierarchy_id_o
200: => hr_hrc_shd.g_old_rec.parent_hierarchy_id
201: ,p_object_version_number_o
202: => hr_hrc_shd.g_old_rec.object_version_number

Line 200: => hr_hrc_shd.g_old_rec.parent_hierarchy_id

196: => p_rec.object_version_number
197: ,p_hierarchy_key_o
198: => hr_hrc_shd.g_old_rec.hierarchy_key
199: ,p_parent_hierarchy_id_o
200: => hr_hrc_shd.g_old_rec.parent_hierarchy_id
201: ,p_object_version_number_o
202: => hr_hrc_shd.g_old_rec.object_version_number
203: );
204: --

Line 202: => hr_hrc_shd.g_old_rec.object_version_number

198: => hr_hrc_shd.g_old_rec.hierarchy_key
199: ,p_parent_hierarchy_id_o
200: => hr_hrc_shd.g_old_rec.parent_hierarchy_id
201: ,p_object_version_number_o
202: => hr_hrc_shd.g_old_rec.object_version_number
203: );
204: --
205: exception
206: --

Line 262: (p_rec in out nocopy hr_hrc_shd.g_rec_type

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

Line 274: hr_hrc_shd.g_old_rec.hierarchy_key;

270: -- is being used then we must set to the 'current' argument value.
271: --
272: If (p_rec.hierarchy_key = hr_api.g_varchar2) then
273: p_rec.hierarchy_key :=
274: hr_hrc_shd.g_old_rec.hierarchy_key;
275: End If;
276: If (p_rec.parent_hierarchy_id = hr_api.g_number) then
277: p_rec.parent_hierarchy_id :=
278: hr_hrc_shd.g_old_rec.parent_hierarchy_id;

Line 278: hr_hrc_shd.g_old_rec.parent_hierarchy_id;

274: hr_hrc_shd.g_old_rec.hierarchy_key;
275: End If;
276: If (p_rec.parent_hierarchy_id = hr_api.g_number) then
277: p_rec.parent_hierarchy_id :=
278: hr_hrc_shd.g_old_rec.parent_hierarchy_id;
279: End If;
280: --
281: End convert_defs;
282: --

Line 287: (p_rec in out nocopy hr_hrc_shd.g_rec_type

283: -- ----------------------------------------------------------------------------
284: -- |---------------------------------< upd >----------------------------------|
285: -- ----------------------------------------------------------------------------
286: Procedure upd
287: (p_rec in out nocopy hr_hrc_shd.g_rec_type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'upd';
291: --

Line 297: hr_hrc_shd.lck

293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- We must lock the row which we need to update.
296: --
297: hr_hrc_shd.lck
298: (p_rec.hierarchy_id
299: ,p_rec.object_version_number
300: );
301: --

Line 343: l_rec hr_hrc_shd.g_rec_type;

339: ,p_object_version_number in out nocopy number
340: ,p_parent_hierarchy_id in number default hr_api.g_number
341: ) is
342: --
343: l_rec hr_hrc_shd.g_rec_type;
344: l_proc varchar2(72) := g_package||'upd';
345: --
346: Begin
347: hr_utility.set_location('Entering:'||l_proc, 5);

Line 353: hr_hrc_shd.convert_args

349: -- Call conversion function to turn arguments into the
350: -- l_rec structure.
351: --
352: l_rec :=
353: hr_hrc_shd.convert_args
354: (p_hierarchy_id
355: ,hr_api.g_varchar2
356: ,p_parent_hierarchy_id
357: ,p_object_version_number