DBA Data[Home] [Help]

APPS.HR_TIS_INS dependencies on HR_TIS_SHD

Line 76: (p_rec in out nocopy hr_tis_shd.g_rec_type

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

Line 149: hr_tis_shd.constraint_error

145: Exception
146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
148: --
149: hr_tis_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: -- Parent integrity has been violated
153: --

Line 154: hr_tis_shd.constraint_error

150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.parent_integrity_violated Then
152: -- Parent integrity has been violated
153: --
154: hr_tis_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: --

Line 159: hr_tis_shd.constraint_error

155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.unique_integrity_violated Then
157: -- Unique integrity has been violated
158: --
159: hr_tis_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When Others Then
162: --
163: Raise;

Line 204: (p_rec in out nocopy hr_tis_shd.g_rec_type

200: --
201: -- {End Of Comments}
202: -- ----------------------------------------------------------------------------
203: Procedure pre_insert
204: (p_rec in out nocopy hr_tis_shd.g_rec_type
205: ) is
206: --
207: Cursor C_Sel1 is select hr_ki_topic_integrations_s.nextval from sys.dual;
208: --

Line 291: (p_rec in hr_tis_shd.g_rec_type

287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure post_insert
291: (p_rec in hr_tis_shd.g_rec_type
292: ) is
293: --
294: l_proc varchar2(72) := g_package||'post_insert';
295: --

Line 344: (p_rec in out nocopy hr_tis_shd.g_rec_type

340: -- ----------------------------------------------------------------------------
341: -- |---------------------------------< ins >----------------------------------|
342: -- ----------------------------------------------------------------------------
343: Procedure ins
344: (p_rec in out nocopy hr_tis_shd.g_rec_type
345: ) is
346: --
347: l_proc varchar2(72) := g_package||'ins';
348: --

Line 411: l_rec hr_tis_shd.g_rec_type;

407: ,p_topic_integrations_id out nocopy number
408: ,p_object_version_number out nocopy number
409: ) is
410: --
411: l_rec hr_tis_shd.g_rec_type;
412: l_proc varchar2(72) := g_package||'ins';
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);

Line 421: hr_tis_shd.convert_args

417: -- Call conversion function to turn arguments into the
418: -- p_rec structure.
419: --
420: l_rec :=
421: hr_tis_shd.convert_args
422: (null
423: ,p_topic_id
424: ,p_integration_id
425: ,p_param_name1