45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml
49: (p_rec in out nocopy hr_dtt_shd.g_rec_type
50: ) is
51: --
52: l_proc varchar2(72) := g_package||'update_dml';
53: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
79: --
80: hr_dtt_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.parent_integrity_violated Then
83: -- Parent integrity has been violated
84: --
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.parent_integrity_violated Then
83: -- Parent integrity has been violated
84: --
85: hr_dtt_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: --
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: --
90: hr_dtt_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: --
94: Raise;
126: --
127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure pre_update
130: (p_rec in hr_dtt_shd.g_rec_type
131: ) is
132: --
133: l_proc varchar2(72) := g_package||'pre_update';
134: --
170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure post_update
174: (p_rec in hr_dtt_shd.g_rec_type
175: ) is
176: --
177: l_proc varchar2(72) := g_package||'post_update';
178: --
191: => p_rec.document_type
192: ,p_description
193: => p_rec.description
194: ,p_source_language_o
195: => hr_dtt_shd.g_old_rec.source_language
196: ,p_document_type_o
197: => hr_dtt_shd.g_old_rec.document_type
198: ,p_description_o
199: => hr_dtt_shd.g_old_rec.description
193: => p_rec.description
194: ,p_source_language_o
195: => hr_dtt_shd.g_old_rec.source_language
196: ,p_document_type_o
197: => hr_dtt_shd.g_old_rec.document_type
198: ,p_description_o
199: => hr_dtt_shd.g_old_rec.description
200: );
201: --
195: => hr_dtt_shd.g_old_rec.source_language
196: ,p_document_type_o
197: => hr_dtt_shd.g_old_rec.document_type
198: ,p_description_o
199: => hr_dtt_shd.g_old_rec.description
200: );
201: --
202: exception
203: --
255: --
256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure convert_defs
259: (p_rec in out nocopy hr_dtt_shd.g_rec_type
260: ) is
261: --
262: Begin
263: --
267: -- is being used then we must set to the 'current' argument value.
268: --
269: If (p_rec.source_language = hr_api.g_varchar2) then
270: p_rec.source_language :=
271: hr_dtt_shd.g_old_rec.source_language;
272: End If;
273: If (p_rec.document_type = hr_api.g_varchar2) then
274: p_rec.document_type :=
275: hr_dtt_shd.g_old_rec.document_type;
271: hr_dtt_shd.g_old_rec.source_language;
272: End If;
273: If (p_rec.document_type = hr_api.g_varchar2) then
274: p_rec.document_type :=
275: hr_dtt_shd.g_old_rec.document_type;
276: End If;
277: If (p_rec.description = hr_api.g_varchar2) then
278: p_rec.description :=
279: hr_dtt_shd.g_old_rec.description;
275: hr_dtt_shd.g_old_rec.document_type;
276: End If;
277: If (p_rec.description = hr_api.g_varchar2) then
278: p_rec.description :=
279: hr_dtt_shd.g_old_rec.description;
280: End If;
281: --
282: End convert_defs;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |---------------------------------< upd >----------------------------------|
286: -- ----------------------------------------------------------------------------
287: Procedure upd
288: (p_rec in out nocopy hr_dtt_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'upd';
292: --
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- We must lock the row which we need to update.
297: --
298: hr_dtt_shd.lck
299: (p_rec.document_type_id
300: ,p_rec.language
301: );
302: --
342: ,p_document_type in varchar2 default hr_api.g_varchar2
343: ,p_description in varchar2 default hr_api.g_varchar2
344: ) is
345: --
346: l_rec hr_dtt_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'upd';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
352: -- Call conversion function to turn arguments into the
353: -- l_rec structure.
354: --
355: l_rec :=
356: hr_dtt_shd.convert_args
357: (p_document_type_id
358: ,p_language
359: ,p_source_language
360: ,p_document_type