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_RFT_UPD dependencies on PQH_RFT_SHD

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

Line 77: pqh_rft_shd.constraint_error

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

Line 81: pqh_rft_shd.constraint_error

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

Line 85: pqh_rft_shd.constraint_error

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

Line 123: Procedure pre_update(p_rec in pqh_rft_shd.g_rec_type) is

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

Line 165: Procedure post_update(p_effective_date in date,p_rec in pqh_rft_shd.g_rec_type) is

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

Line 185: ,p_base_template_id_o =>pqh_rft_shd.g_old_rec.base_template_id

181: ,p_parent_template_id =>p_rec.parent_template_id
182: ,p_reference_type_cd =>p_rec.reference_type_cd
183: ,p_object_version_number =>p_rec.object_version_number
184: ,p_effective_date =>p_effective_date
185: ,p_base_template_id_o =>pqh_rft_shd.g_old_rec.base_template_id
186: ,p_parent_template_id_o =>pqh_rft_shd.g_old_rec.parent_template_id
187: ,p_reference_type_cd_o =>pqh_rft_shd.g_old_rec.reference_type_cd
188: ,p_object_version_number_o =>pqh_rft_shd.g_old_rec.object_version_number
189: );

Line 186: ,p_parent_template_id_o =>pqh_rft_shd.g_old_rec.parent_template_id

182: ,p_reference_type_cd =>p_rec.reference_type_cd
183: ,p_object_version_number =>p_rec.object_version_number
184: ,p_effective_date =>p_effective_date
185: ,p_base_template_id_o =>pqh_rft_shd.g_old_rec.base_template_id
186: ,p_parent_template_id_o =>pqh_rft_shd.g_old_rec.parent_template_id
187: ,p_reference_type_cd_o =>pqh_rft_shd.g_old_rec.reference_type_cd
188: ,p_object_version_number_o =>pqh_rft_shd.g_old_rec.object_version_number
189: );
190: --

Line 187: ,p_reference_type_cd_o =>pqh_rft_shd.g_old_rec.reference_type_cd

183: ,p_object_version_number =>p_rec.object_version_number
184: ,p_effective_date =>p_effective_date
185: ,p_base_template_id_o =>pqh_rft_shd.g_old_rec.base_template_id
186: ,p_parent_template_id_o =>pqh_rft_shd.g_old_rec.parent_template_id
187: ,p_reference_type_cd_o =>pqh_rft_shd.g_old_rec.reference_type_cd
188: ,p_object_version_number_o =>pqh_rft_shd.g_old_rec.object_version_number
189: );
190: --
191: exception

Line 188: ,p_object_version_number_o =>pqh_rft_shd.g_old_rec.object_version_number

184: ,p_effective_date =>p_effective_date
185: ,p_base_template_id_o =>pqh_rft_shd.g_old_rec.base_template_id
186: ,p_parent_template_id_o =>pqh_rft_shd.g_old_rec.parent_template_id
187: ,p_reference_type_cd_o =>pqh_rft_shd.g_old_rec.reference_type_cd
188: ,p_object_version_number_o =>pqh_rft_shd.g_old_rec.object_version_number
189: );
190: --
191: exception
192: --

Line 250: Procedure convert_defs(p_rec in out nocopy pqh_rft_shd.g_rec_type) is

246: -- Internal Row Handler Use Only.
247: --
248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure convert_defs(p_rec in out nocopy pqh_rft_shd.g_rec_type) is
251: --
252: l_proc varchar2(72) := g_package||'convert_defs';
253: --
254: Begin

Line 265: pqh_rft_shd.g_old_rec.base_template_id;

261: -- is being used then we must set to the 'current' argument value.
262: --
263: If (p_rec.base_template_id = hr_api.g_number) then
264: p_rec.base_template_id :=
265: pqh_rft_shd.g_old_rec.base_template_id;
266: End If;
267: If (p_rec.parent_template_id = hr_api.g_number) then
268: p_rec.parent_template_id :=
269: pqh_rft_shd.g_old_rec.parent_template_id;

Line 269: pqh_rft_shd.g_old_rec.parent_template_id;

265: pqh_rft_shd.g_old_rec.base_template_id;
266: End If;
267: If (p_rec.parent_template_id = hr_api.g_number) then
268: p_rec.parent_template_id :=
269: pqh_rft_shd.g_old_rec.parent_template_id;
270: End If;
271: If (p_rec.reference_type_cd = hr_api.g_varchar2) then
272: p_rec.reference_type_cd :=
273: pqh_rft_shd.g_old_rec.reference_type_cd;

Line 273: pqh_rft_shd.g_old_rec.reference_type_cd;

269: pqh_rft_shd.g_old_rec.parent_template_id;
270: End If;
271: If (p_rec.reference_type_cd = hr_api.g_varchar2) then
272: p_rec.reference_type_cd :=
273: pqh_rft_shd.g_old_rec.reference_type_cd;
274: End If;
275:
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 287: p_rec in out nocopy pqh_rft_shd.g_rec_type

283: -- ----------------------------------------------------------------------------
284: Procedure upd
285: (
286: p_effective_date in date,
287: p_rec in out nocopy pqh_rft_shd.g_rec_type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'upd';
291: --

Line 297: pqh_rft_shd.lck

293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- We must lock the row which we need to update.
296: --
297: pqh_rft_shd.lck
298: (
299: p_rec.ref_template_id,
300: p_rec.object_version_number
301: );

Line 338: l_rec pqh_rft_shd.g_rec_type;

334: p_reference_type_cd in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is
337: --
338: l_rec pqh_rft_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);

Line 348: pqh_rft_shd.convert_args

344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
347: l_rec :=
348: pqh_rft_shd.convert_args
349: (
350: p_ref_template_id,
351: p_base_template_id,
352: p_parent_template_id,