DBA Data[Home] [Help]

APPS.OTA_THG_INS dependencies on OTA_THG_SHD

Line 54: (p_rec in out nocopy ota_thg_shd.g_rec_type

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

Line 95: ota_thg_shd.constraint_error

91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: ota_thg_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --

Line 100: ota_thg_shd.constraint_error

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

Line 105: ota_thg_shd.constraint_error

101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: ota_thg_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: --
109: Raise;

Line 150: (p_rec in out nocopy ota_thg_shd.g_rec_type

146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_insert
150: (p_rec in out nocopy ota_thg_shd.g_rec_type
151: ) is
152: --
153: l_proc varchar2(72) := g_package||'pre_insert';
154: --

Line 204: ,p_rec in ota_thg_shd.g_rec_type

200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_insert
203: (p_effective_date in date
204: ,p_rec in ota_thg_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'post_insert';
208: --

Line 251: ,p_rec in out nocopy ota_thg_shd.g_rec_type

247: -- |---------------------------------< ins >----------------------------------|
248: -- ----------------------------------------------------------------------------
249: Procedure ins
250: (p_effective_date in date
251: ,p_rec in out nocopy ota_thg_shd.g_rec_type
252: ,p_validate in boolean default false
253: ) is
254: --
255: l_proc varchar2(72) := g_package||'ins';

Line 323: l_rec ota_thg_shd.g_rec_type;

319: ,p_object_version_number out nocopy number
320: ,p_validate in boolean default false
321: ) is
322: --
323: l_rec ota_thg_shd.g_rec_type;
324: l_proc varchar2(72) := g_package||'ins';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);

Line 333: ota_thg_shd.convert_args

329: -- Call conversion function to turn arguments into the
330: -- p_rec structure.
331: --
332: l_rec :=
333: ota_thg_shd.convert_args
334: (null
335: ,p_cross_charge_id
336: ,p_segment
337: ,p_segment_num