APPS.PER_STT_UPD dependencies on PER_STT_SHD

Line 51: Procedure update_dml(p_rec in out nocopy per_stt_shd.g_rec_type) is

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

Line 76: per_stt_shd.constraint_error

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

Line 80: per_stt_shd.constraint_error

76: per_stt_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: per_stt_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: per_stt_shd.constraint_error

Line 84: per_stt_shd.constraint_error

80: per_stt_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: per_stt_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: Raise;
88: End update_dml;

Line 122: Procedure pre_update(p_rec in per_stt_shd.g_rec_type) is

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

Line 164: Procedure post_update(p_rec in per_stt_shd.g_rec_type) is

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

Line 182: ,p_language_o =>per_stt_shd.g_old_rec.language

178: p_shared_type_id =>p_rec.shared_type_id
179: ,p_language =>p_rec.language
180: ,p_source_lang =>p_rec.source_lang
181: ,p_shared_type_name =>p_rec.shared_type_name
182: ,p_language_o =>per_stt_shd.g_old_rec.language
183: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang
184: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name
185: );
186: --

Line 183: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang

179: ,p_language =>p_rec.language
180: ,p_source_lang =>p_rec.source_lang
181: ,p_shared_type_name =>p_rec.shared_type_name
182: ,p_language_o =>per_stt_shd.g_old_rec.language
183: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang
184: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name
185: );
186: --
187: exception

Line 184: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name

180: ,p_source_lang =>p_rec.source_lang
181: ,p_shared_type_name =>p_rec.shared_type_name
182: ,p_language_o =>per_stt_shd.g_old_rec.language
183: ,p_source_lang_o =>per_stt_shd.g_old_rec.source_lang
184: ,p_shared_type_name_o =>per_stt_shd.g_old_rec.shared_type_name
185: );
186: --
187: exception
188: --

Line 246: Procedure convert_defs(p_rec in out nocopy per_stt_shd.g_rec_type) is

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

Line 261: per_stt_shd.g_old_rec.source_lang;

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

Line 265: per_stt_shd.g_old_rec.shared_type_name;

261: per_stt_shd.g_old_rec.source_lang;
262: End If;
263: If (p_rec.shared_type_name = hr_api.g_varchar2) then
264: p_rec.shared_type_name :=
265: per_stt_shd.g_old_rec.shared_type_name;
266: End If;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: --

Line 277: p_rec in out nocopy per_stt_shd.g_rec_type

273: -- |---------------------------------< upd >----------------------------------|
274: -- ----------------------------------------------------------------------------
275: Procedure upd
276: (
277: p_rec in out nocopy per_stt_shd.g_rec_type
278: ) is
279: --
280: l_proc varchar2(72) := g_package||'upd';
281: --

Line 287: per_stt_shd.lck

283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- We must lock the row which we need to update.
286: --
287: per_stt_shd.lck
288: (
289: p_rec.shared_type_id,
290: p_rec.language
291: );

Line 326: l_rec per_stt_shd.g_rec_type;

322: p_source_lang in varchar2 default hr_api.g_varchar2,
323: p_shared_type_name in varchar2 default hr_api.g_varchar2
324: ) is
325: --
326: l_rec per_stt_shd.g_rec_type;
327: l_proc varchar2(72) := g_package||'upd';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);

Line 336: per_stt_shd.convert_args

332: -- Call conversion function to turn arguments into the
333: -- l_rec structure.
334: --
335: l_rec :=
336: per_stt_shd.convert_args
337: (
338: p_shared_type_id,
339: p_language,
340: p_source_lang,