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_TTL_UPD dependencies on PQH_TTL_SHD

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

Line 74: pqh_ttl_shd.constraint_error

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

Line 78: pqh_ttl_shd.constraint_error

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

Line 82: pqh_ttl_shd.constraint_error

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

Line 120: Procedure pre_update(p_rec in pqh_ttl_shd.g_rec_type) is

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

Line 162: Procedure post_update(p_rec in pqh_ttl_shd.g_rec_type) is

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

Line 180: ,p_template_name_o =>pqh_ttl_shd.g_old_rec.template_name

176: p_template_id =>p_rec.template_id
177: ,p_template_name =>p_rec.template_name
178: ,p_language =>p_rec.language
179: ,p_source_lang =>p_rec.source_lang
180: ,p_template_name_o =>pqh_ttl_shd.g_old_rec.template_name
181: ,p_language_o =>pqh_ttl_shd.g_old_rec.language
182: ,p_source_lang_o =>pqh_ttl_shd.g_old_rec.source_lang
183: );
184: --

Line 181: ,p_language_o =>pqh_ttl_shd.g_old_rec.language

177: ,p_template_name =>p_rec.template_name
178: ,p_language =>p_rec.language
179: ,p_source_lang =>p_rec.source_lang
180: ,p_template_name_o =>pqh_ttl_shd.g_old_rec.template_name
181: ,p_language_o =>pqh_ttl_shd.g_old_rec.language
182: ,p_source_lang_o =>pqh_ttl_shd.g_old_rec.source_lang
183: );
184: --
185: exception

Line 182: ,p_source_lang_o =>pqh_ttl_shd.g_old_rec.source_lang

178: ,p_language =>p_rec.language
179: ,p_source_lang =>p_rec.source_lang
180: ,p_template_name_o =>pqh_ttl_shd.g_old_rec.template_name
181: ,p_language_o =>pqh_ttl_shd.g_old_rec.language
182: ,p_source_lang_o =>pqh_ttl_shd.g_old_rec.source_lang
183: );
184: --
185: exception
186: --

Line 244: Procedure convert_defs(p_rec in out nocopy pqh_ttl_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 pqh_ttl_shd.g_rec_type) is
245: --
246: l_proc varchar2(72) := g_package||'convert_defs';
247: --
248: Begin

Line 259: pqh_ttl_shd.g_old_rec.template_name;

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

Line 263: pqh_ttl_shd.g_old_rec.source_lang;

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

Line 275: p_rec in out nocopy pqh_ttl_shd.g_rec_type

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

Line 285: pqh_ttl_shd.lck

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

Line 324: l_rec pqh_ttl_shd.g_rec_type;

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

Line 334: pqh_ttl_shd.convert_args

330: -- Call conversion function to turn arguments into the
331: -- l_rec structure.
332: --
333: l_rec :=
334: pqh_ttl_shd.convert_args
335: (
336: p_template_id,
337: p_template_name,
338: p_language,