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_TAT_DEL dependencies on PQH_TAT_SHD

Line 45: Procedure delete_dml(p_rec in pqh_tat_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in pqh_tat_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_tat_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_tat_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;

Line 102: Procedure pre_delete(p_rec in pqh_tat_shd.g_rec_type) is

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_tat_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

Line 145: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is

141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(
145: p_effective_date in date,p_rec in pqh_tat_shd.g_rec_type) is
146: --
147: l_proc varchar2(72) := g_package||'post_delete';
148: --
149: Begin

Line 160: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag

156: --
157: pqh_tat_rkd.after_delete
158: (
159: p_template_attribute_id =>p_rec.template_attribute_id
160: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id

Line 161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag

157: pqh_tat_rkd.after_delete
158: (
159: p_template_attribute_id =>p_rec.template_attribute_id
160: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
165: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number

Line 162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag

158: (
159: p_template_attribute_id =>p_rec.template_attribute_id
160: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
165: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
166: );

Line 163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id

159: p_template_attribute_id =>p_rec.template_attribute_id
160: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
165: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
166: );
167: --

Line 164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id

160: ,p_required_flag_o =>pqh_tat_shd.g_old_rec.required_flag
161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
165: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
166: );
167: --
168: exception

Line 165: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number

161: ,p_view_flag_o =>pqh_tat_shd.g_old_rec.view_flag
162: ,p_edit_flag_o =>pqh_tat_shd.g_old_rec.edit_flag
163: ,p_attribute_id_o =>pqh_tat_shd.g_old_rec.attribute_id
164: ,p_template_id_o =>pqh_tat_shd.g_old_rec.template_id
165: ,p_object_version_number_o =>pqh_tat_shd.g_old_rec.object_version_number
166: );
167: --
168: exception
169: --

Line 190: p_rec in pqh_tat_shd.g_rec_type

186: -- ----------------------------------------------------------------------------
187: Procedure del
188: (
189: p_effective_date in date,
190: p_rec in pqh_tat_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package||'del';
194: --

Line 200: pqh_tat_shd.lck

196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: -- We must lock the row which we need to delete.
199: --
200: pqh_tat_shd.lck
201: (
202: p_rec.template_attribute_id,
203: p_rec.object_version_number
204: );

Line 235: l_rec pqh_tat_shd.g_rec_type;

231: p_template_attribute_id in number,
232: p_object_version_number in number
233: ) is
234: --
235: l_rec pqh_tat_shd.g_rec_type;
236: l_proc varchar2(72) := g_package||'del';
237: --
238: Begin
239: hr_utility.set_location('Entering:'||l_proc, 5);