DBA Data[Home] [Help]

APPS.HR_LOT_UPD dependencies on HR_LOT_SHD

Line 48: Procedure update_dml(p_rec in out nocopy hr_lot_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy hr_lot_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 73: hr_lot_shd.constraint_error

69: --
70: Exception
71: When hr_api.check_integrity_violated Then
72: -- A check constraint has been violated
73: hr_lot_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When hr_api.parent_integrity_violated Then
76: -- Parent integrity has been violated
77: hr_lot_shd.constraint_error

Line 77: hr_lot_shd.constraint_error

73: hr_lot_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When hr_api.parent_integrity_violated Then
76: -- Parent integrity has been violated
77: hr_lot_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When hr_api.unique_integrity_violated Then
80: -- Unique integrity has been violated
81: hr_lot_shd.constraint_error

Line 81: hr_lot_shd.constraint_error

77: hr_lot_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When hr_api.unique_integrity_violated Then
80: -- Unique integrity has been violated
81: hr_lot_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: Raise;
85: End update_dml;

Line 119: Procedure pre_update(p_rec in hr_lot_shd.g_rec_type) is

115: -- Internal Row Handler Use Only.
116: --
117: -- {End Of Comments}
118: -- ----------------------------------------------------------------------------
119: Procedure pre_update(p_rec in hr_lot_shd.g_rec_type) is
120: --
121: l_proc varchar2(72) := g_package||'pre_update';
122: --
123: Begin

Line 161: Procedure post_update(p_rec in hr_lot_shd.g_rec_type) is

157: -- Internal Row Handler Use Only.
158: --
159: -- {End Of Comments}
160: -- ----------------------------------------------------------------------------
161: Procedure post_update(p_rec in hr_lot_shd.g_rec_type) is
162: --
163: l_proc varchar2(72) := g_package||'post_update';
164: --
165: Begin

Line 180: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang

176: ,p_language =>p_rec.language
177: ,p_source_lang =>p_rec.source_lang
178: ,p_location_code =>p_rec.location_code
179: ,p_description =>p_rec.description
180: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
181: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
182: ,p_description_o =>hr_lot_shd.g_old_rec.description
183: );
184: --

Line 181: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code

177: ,p_source_lang =>p_rec.source_lang
178: ,p_location_code =>p_rec.location_code
179: ,p_description =>p_rec.description
180: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
181: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
182: ,p_description_o =>hr_lot_shd.g_old_rec.description
183: );
184: --
185: exception

Line 182: ,p_description_o =>hr_lot_shd.g_old_rec.description

178: ,p_location_code =>p_rec.location_code
179: ,p_description =>p_rec.description
180: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
181: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
182: ,p_description_o =>hr_lot_shd.g_old_rec.description
183: );
184: --
185: exception
186: --

Line 244: Procedure convert_defs(p_rec in out nocopy hr_lot_shd.g_rec_type) is

240: -- Internal Row Handler Use Only.
241: --
242: -- {End Of Comments}
243: -- ----------------------------------------------------------------------------
244: Procedure convert_defs(p_rec in out nocopy hr_lot_shd.g_rec_type) is
245: --
246: l_proc varchar2(72) := g_package||'convert_defs';
247: --
248: Begin

Line 259: hr_lot_shd.g_old_rec.source_lang;

255: -- is being used then we must set to the 'current' argument value.
256: --
257: If (p_rec.source_lang = hr_api.g_varchar2) then
258: p_rec.source_lang :=
259: hr_lot_shd.g_old_rec.source_lang;
260: End If;
261: If (p_rec.location_code = hr_api.g_varchar2) then
262: p_rec.location_code :=
263: hr_lot_shd.g_old_rec.location_code;

Line 263: hr_lot_shd.g_old_rec.location_code;

259: hr_lot_shd.g_old_rec.source_lang;
260: End If;
261: If (p_rec.location_code = hr_api.g_varchar2) then
262: p_rec.location_code :=
263: hr_lot_shd.g_old_rec.location_code;
264: End If;
265: If (p_rec.description = hr_api.g_varchar2) then
266: p_rec.description :=
267: hr_lot_shd.g_old_rec.description;

Line 267: hr_lot_shd.g_old_rec.description;

263: hr_lot_shd.g_old_rec.location_code;
264: End If;
265: If (p_rec.description = hr_api.g_varchar2) then
266: p_rec.description :=
267: hr_lot_shd.g_old_rec.description;
268: End If;
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 10);
271: --

Line 279: p_rec in out nocopy hr_lot_shd.g_rec_type,

275: -- |---------------------------------< upd >----------------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure upd
278: (
279: p_rec in out nocopy hr_lot_shd.g_rec_type,
280: p_business_group_id in number
281: ) is
282: --
283: l_proc varchar2(72) := g_package||'upd';

Line 290: hr_lot_shd.lck

286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: -- We must lock the row which we need to update.
289: --
290: hr_lot_shd.lck
291: (
292: p_rec.location_id,
293: p_rec.language
294: );

Line 331: l_rec hr_lot_shd.g_rec_type;

327: p_description in varchar2 default hr_api.g_varchar2,
328: p_business_group_id in number
329: ) is
330: --
331: l_rec hr_lot_shd.g_rec_type;
332: l_proc varchar2(72) := g_package||'upd';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);

Line 341: hr_lot_shd.convert_args

337: -- Call conversion function to turn arguments into the
338: -- l_rec structure.
339: --
340: l_rec :=
341: hr_lot_shd.convert_args
342: (
343: p_location_id,
344: p_language,
345: p_source_lang,

Line 390: l_business_group_id := hr_lot_shd.return_value_business_group_id

386: begin
387: --
388: hr_utility.set_location('Entering:'||l_proc, 10);
389: --
390: l_business_group_id := hr_lot_shd.return_value_business_group_id
391: ( p_location_id => p_location_id );
392: --
393: -- Update the translated values for every matching row
394: -- setting SOURCE_LANG to the specified language.