APPS.OTA_TMT_INS dependencies on OTA_TMT_SHD

Line 54: (p_rec in out nocopy ota_tmt_shd.g_rec_type

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

Line 161: ota_tmt_shd.constraint_error

157: Exception
158: When hr_api.check_integrity_violated Then
159: -- A check constraint has been violated
160: --
161: ota_tmt_shd.constraint_error
162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: --

Line 166: ota_tmt_shd.constraint_error

162: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.parent_integrity_violated Then
164: -- Parent integrity has been violated
165: --
166: ota_tmt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: --

Line 171: ota_tmt_shd.constraint_error

167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: --
171: ota_tmt_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: --
175: Raise;

Line 216: (p_rec in out nocopy ota_tmt_shd.g_rec_type

212: --
213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: Procedure pre_insert
216: (p_rec in out nocopy ota_tmt_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'pre_insert';
220: --

Line 270: ,p_rec in ota_tmt_shd.g_rec_type

266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure post_insert
269: (p_effective_date in date
270: ,p_rec in ota_tmt_shd.g_rec_type
271: ) is
272: --
273: l_proc varchar2(72) := g_package||'post_insert';
274: --

Line 383: ,p_rec in out nocopy ota_tmt_shd.g_rec_type

379: -- |---------------------------------< ins >----------------------------------|
380: -- ----------------------------------------------------------------------------
381: Procedure ins
382: (p_effective_date in date
383: ,p_rec in out nocopy ota_tmt_shd.g_rec_type
384: ) is
385: --
386: l_proc varchar2(72) := g_package||'ins';
387: --

Line 464: l_rec ota_tmt_shd.g_rec_type;

460: ,p_tp_measurement_type_id out nocopy number
461: ,p_object_version_number out nocopy number
462: ) is
463: --
464: l_rec ota_tmt_shd.g_rec_type;
465: l_proc varchar2(72) := g_package||'ins';
466: --
467: Begin
468: hr_utility.set_location('Entering:'||l_proc, 5);

Line 474: ota_tmt_shd.convert_args

470: -- Call conversion function to turn arguments into the
471: -- p_rec structure.
472: --
473: l_rec :=
474: ota_tmt_shd.convert_args
475: (null
476: ,p_tp_measurement_code
477: ,p_unit
478: ,p_reporting_sequence