APPS.OTA_CTL_INS dependencies on OTA_CTL_SHD

Line 54: (p_rec in out nocopy ota_ctl_shd.g_rec_type

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

Line 101: ota_ctl_shd.constraint_error

97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: --
101: ota_ctl_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --

Line 106: ota_ctl_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: --
106: ota_ctl_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --

Line 111: ota_ctl_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: --
111: ota_ctl_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: --
115: Raise;

Line 156: (p_rec in out nocopy ota_ctl_shd.g_rec_type

152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure pre_insert
156: (p_rec in out nocopy ota_ctl_shd.g_rec_type
157: ,p_certification_id in number
158: ) is
159: --
160: l_proc varchar2(72) := g_package||'pre_insert';

Line 204: ,p_rec in ota_ctl_shd.g_rec_type

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

Line 257: ,p_rec in out nocopy ota_ctl_shd.g_rec_type

253: -- |---------------------------------< ins >----------------------------------|
254: -- ----------------------------------------------------------------------------
255: Procedure ins
256: (p_effective_date in date
257: ,p_rec in out nocopy ota_ctl_shd.g_rec_type
258: ,p_certification_id in number
259: ) is
260: --
261: l_proc varchar2(72) := g_package||'ins';

Line 320: l_rec ota_ctl_shd.g_rec_type;

316: ,p_initial_period_comments in varchar2
317: ,p_renewal_period_comments in varchar2
318: ) is
319: --
320: l_rec ota_ctl_shd.g_rec_type;
321: l_proc varchar2(72) := g_package||'ins';
322: --
323: Begin
324: hr_utility.set_location('Entering:'||l_proc, 5);

Line 330: ota_ctl_shd.convert_args

326: -- Call conversion function to turn arguments into the
327: -- p_rec structure.
328: --
329: l_rec :=
330: ota_ctl_shd.convert_args
331: (null
332: ,p_language
333: ,p_name
334: ,p_description