DBA Data[Home] [Help]

APPS.HR_CTX_INS dependencies on HR_CTX_SHD

Line 76: (p_rec in out nocopy hr_ctx_shd.g_rec_type

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

Line 167: hr_ctx_shd.constraint_error

163: Exception
164: When hr_api.check_integrity_violated Then
165: -- A check constraint has been violated
166: --
167: hr_ctx_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When hr_api.parent_integrity_violated Then
170: -- Parent integrity has been violated
171: --

Line 172: hr_ctx_shd.constraint_error

168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When hr_api.parent_integrity_violated Then
170: -- Parent integrity has been violated
171: --
172: hr_ctx_shd.constraint_error
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.unique_integrity_violated Then
175: -- Unique integrity has been violated
176: --

Line 177: hr_ctx_shd.constraint_error

173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.unique_integrity_violated Then
175: -- Unique integrity has been violated
176: --
177: hr_ctx_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When Others Then
180: --
181: Raise;

Line 222: (p_rec in out nocopy hr_ctx_shd.g_rec_type

218: --
219: -- {End Of Comments}
220: -- ----------------------------------------------------------------------------
221: Procedure pre_insert
222: (p_rec in out nocopy hr_ctx_shd.g_rec_type
223: ) is
224: --
225: Cursor C_Sel1 is select hr_ki_contexts_s.nextval from sys.dual;
226: --

Line 309: (p_rec in hr_ctx_shd.g_rec_type

305: --
306: -- {End Of Comments}
307: -- ----------------------------------------------------------------------------
308: Procedure post_insert
309: (p_rec in hr_ctx_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'post_insert';
313: --

Line 404: (p_rec in out nocopy hr_ctx_shd.g_rec_type

400: -- ----------------------------------------------------------------------------
401: -- |---------------------------------< ins >----------------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure ins
404: (p_rec in out nocopy hr_ctx_shd.g_rec_type
405: ) is
406: --
407: l_proc varchar2(72) := g_package||'ins';
408: --

Line 480: l_rec hr_ctx_shd.g_rec_type;

476: ,p_context_id out nocopy number
477: ,p_object_version_number out nocopy number
478: ) is
479: --
480: l_rec hr_ctx_shd.g_rec_type;
481: l_proc varchar2(72) := g_package||'ins';
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);

Line 490: hr_ctx_shd.convert_args

486: -- Call conversion function to turn arguments into the
487: -- p_rec structure.
488: --
489: l_rec :=
490: hr_ctx_shd.convert_args
491: (null
492: ,p_view_name
493: ,p_param_1
494: ,p_param_2