75: --
76: -- {End Of Comments}
77: -- ----------------------------------------------------------------------------
78: Procedure insert_dml
79: (p_rec in out nocopy pay_tdu_shd.g_rec_type
80: ) is
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: pay_tdu_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: pay_tdu_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_tdu_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure pre_insert
165: (p_rec in out nocopy pay_tdu_shd.g_rec_type
166: ) is
167: --
168: Cursor C_Sel2 is
169: Select null
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure post_insert
247: (p_effective_date in date
248: ,p_rec in pay_tdu_shd.g_rec_type
249: ) is
250: --
251: l_proc varchar2(72) := g_package||'post_insert';
252: --
281: -- |---------------------------------< ins >----------------------------------|
282: -- ----------------------------------------------------------------------------
283: Procedure ins
284: (p_effective_date in date
285: ,p_rec in out nocopy pay_tdu_shd.g_rec_type
286: ) is
287: --
288: l_proc varchar2(72) := g_package||'ins';
289: --
330: ,p_usage_type in varchar2
331: ,p_object_version_number out nocopy number
332: ) is
333: --
334: l_rec pay_tdu_shd.g_rec_type;
335: l_proc varchar2(72) := g_package||'ins';
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
340: -- Call conversion function to turn arguments into the
341: -- p_rec structure.
342: --
343: l_rec :=
344: pay_tdu_shd.convert_args
345: (p_time_definition_id
346: ,p_usage_type
347: ,null
348: );