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_CEF_DEL dependencies on PQH_CEF_SHD

Line 48: Procedure delete_dml(p_rec in pqh_cef_shd.g_rec_type) is

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

Line 67: pqh_cef_shd.constraint_error

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

Line 105: Procedure pre_delete(p_rec in pqh_cef_shd.g_rec_type) is

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

Line 148: p_effective_date in date,p_rec in pqh_cef_shd.g_rec_type) is

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

Line 163: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id

159: --
160: pqh_cef_rkd.after_delete
161: (
162: p_copy_entity_function_id =>p_rec.copy_entity_function_id
163: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name

Line 164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd

160: pqh_cef_rkd.after_delete
161: (
162: p_copy_entity_function_id =>p_rec.copy_entity_function_id
163: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number

Line 165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name

161: (
162: p_copy_entity_function_id =>p_rec.copy_entity_function_id
163: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
169: ,p_context_o =>pqh_cef_shd.g_old_rec.context

Line 166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name

162: p_copy_entity_function_id =>p_rec.copy_entity_function_id
163: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
169: ,p_context_o =>pqh_cef_shd.g_old_rec.context
170: );

Line 167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name

163: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
169: ,p_context_o =>pqh_cef_shd.g_old_rec.context
170: );
171: --

Line 168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number

164: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
169: ,p_context_o =>pqh_cef_shd.g_old_rec.context
170: );
171: --
172: exception

Line 169: ,p_context_o =>pqh_cef_shd.g_old_rec.context

165: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
166: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
167: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
168: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
169: ,p_context_o =>pqh_cef_shd.g_old_rec.context
170: );
171: --
172: exception
173: --

Line 194: p_rec in pqh_cef_shd.g_rec_type

190: -- ----------------------------------------------------------------------------
191: Procedure del
192: (
193: p_effective_date in date,
194: p_rec in pqh_cef_shd.g_rec_type
195: ) is
196: --
197: l_proc varchar2(72) := g_package||'del';
198: --

Line 204: pqh_cef_shd.lck

200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: -- We must lock the row which we need to delete.
203: --
204: pqh_cef_shd.lck
205: (
206: p_rec.copy_entity_function_id,
207: p_rec.object_version_number
208: );

Line 239: l_rec pqh_cef_shd.g_rec_type;

235: p_copy_entity_function_id in number,
236: p_object_version_number in number
237: ) is
238: --
239: l_rec pqh_cef_shd.g_rec_type;
240: l_proc varchar2(72) := g_package||'del';
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);