DBA Data[Home] [Help]

APPS.HR_DTT_UPD dependencies on HR_DTT_SHD

Line 49: (p_rec in out nocopy hr_dtt_shd.g_rec_type

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: --

Line 80: hr_dtt_shd.constraint_error

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: --

Line 85: 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: --
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: --

Line 90: 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: --
90: hr_dtt_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: --
94: Raise;

Line 130: (p_rec in hr_dtt_shd.g_rec_type

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: --

Line 174: (p_rec in hr_dtt_shd.g_rec_type

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: --

Line 195: => hr_dtt_shd.g_old_rec.source_language

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

Line 197: => hr_dtt_shd.g_old_rec.document_type

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: --

Line 199: => hr_dtt_shd.g_old_rec.description

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: --

Line 259: (p_rec in out nocopy hr_dtt_shd.g_rec_type

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: --

Line 271: hr_dtt_shd.g_old_rec.source_language;

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;

Line 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;

Line 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: --

Line 288: (p_rec in out nocopy hr_dtt_shd.g_rec_type

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: --

Line 298: hr_dtt_shd.lck

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: --

Line 346: l_rec hr_dtt_shd.g_rec_type;

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);

Line 356: hr_dtt_shd.convert_args

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