eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_ATL_UPD dependencies on PQH_ATL_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_atl_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 pqh_atl_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 73: pqh_atl_shd.constraint_error

69: --
70: Exception
71: When hr_api.check_integrity_violated Then
72: -- A check constraint has been violated
73: pqh_atl_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: pqh_atl_shd.constraint_error

Line 77: pqh_atl_shd.constraint_error

73: pqh_atl_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: pqh_atl_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: pqh_atl_shd.constraint_error

Line 81: pqh_atl_shd.constraint_error

77: pqh_atl_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: pqh_atl_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 pqh_atl_shd.g_rec_type) is

115: -- Internal Row Handler Use Only.
116: --
117: -- {End Of Comments}
118: -- ----------------------------------------------------------------------------
119: Procedure pre_update(p_rec in pqh_atl_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 pqh_atl_shd.g_rec_type) is

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

Line 179: ,p_attribute_name_o =>pqh_atl_shd.g_old_rec.attribute_name

175: p_attribute_id =>p_rec.attribute_id
176: ,p_attribute_name =>p_rec.attribute_name
177: ,p_language =>p_rec.language
178: ,p_source_lang =>p_rec.source_lang
179: ,p_attribute_name_o =>pqh_atl_shd.g_old_rec.attribute_name
180: ,p_language_o =>pqh_atl_shd.g_old_rec.language
181: ,p_source_lang_o =>pqh_atl_shd.g_old_rec.source_lang
182: );
183: --

Line 180: ,p_language_o =>pqh_atl_shd.g_old_rec.language

176: ,p_attribute_name =>p_rec.attribute_name
177: ,p_language =>p_rec.language
178: ,p_source_lang =>p_rec.source_lang
179: ,p_attribute_name_o =>pqh_atl_shd.g_old_rec.attribute_name
180: ,p_language_o =>pqh_atl_shd.g_old_rec.language
181: ,p_source_lang_o =>pqh_atl_shd.g_old_rec.source_lang
182: );
183: --
184: exception

Line 181: ,p_source_lang_o =>pqh_atl_shd.g_old_rec.source_lang

177: ,p_language =>p_rec.language
178: ,p_source_lang =>p_rec.source_lang
179: ,p_attribute_name_o =>pqh_atl_shd.g_old_rec.attribute_name
180: ,p_language_o =>pqh_atl_shd.g_old_rec.language
181: ,p_source_lang_o =>pqh_atl_shd.g_old_rec.source_lang
182: );
183: --
184: exception
185: --

Line 243: Procedure convert_defs(p_rec in out nocopy pqh_atl_shd.g_rec_type) is

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

Line 258: pqh_atl_shd.g_old_rec.attribute_name;

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

Line 262: pqh_atl_shd.g_old_rec.source_lang;

258: pqh_atl_shd.g_old_rec.attribute_name;
259: End If;
260: If (p_rec.source_lang = hr_api.g_varchar2) then
261: p_rec.source_lang :=
262: pqh_atl_shd.g_old_rec.source_lang;
263: End If;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: --

Line 274: p_rec in out nocopy pqh_atl_shd.g_rec_type

270: -- |---------------------------------< upd >----------------------------------|
271: -- ----------------------------------------------------------------------------
272: Procedure upd
273: (
274: p_rec in out nocopy pqh_atl_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'upd';
278: --

Line 284: pqh_atl_shd.lck

280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to update.
283: --
284: pqh_atl_shd.lck
285: (
286: p_rec.attribute_id,
287: p_rec.language
288: );

Line 323: l_rec pqh_atl_shd.g_rec_type;

319: p_language in varchar2,
320: p_source_lang in varchar2 default hr_api.g_varchar2
321: ) is
322: --
323: l_rec pqh_atl_shd.g_rec_type;
324: l_proc varchar2(72) := g_package||'upd';
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);

Line 333: pqh_atl_shd.convert_args

329: -- Call conversion function to turn arguments into the
330: -- l_rec structure.
331: --
332: l_rec :=
333: pqh_atl_shd.convert_args
334: (
335: p_attribute_id,
336: p_attribute_name,
337: p_language,