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

Line 51: Procedure update_dml(p_rec in out nocopy pqh_cef_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure update_dml(p_rec in out nocopy pqh_cef_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'update_dml';
54: --
55: Begin

Line 83: pqh_cef_shd.constraint_error

79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: pqh_cef_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pqh_cef_shd.constraint_error

Line 87: pqh_cef_shd.constraint_error

83: pqh_cef_shd.constraint_error
84: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
85: When hr_api.parent_integrity_violated Then
86: -- Parent integrity has been violated
87: pqh_cef_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pqh_cef_shd.constraint_error

Line 91: pqh_cef_shd.constraint_error

87: pqh_cef_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.unique_integrity_violated Then
90: -- Unique integrity has been violated
91: pqh_cef_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: Raise;
95: End update_dml;

Line 129: Procedure pre_update(p_rec in pqh_cef_shd.g_rec_type) is

125: -- Internal Row Handler Use Only.
126: --
127: -- {End Of Comments}
128: -- ----------------------------------------------------------------------------
129: Procedure pre_update(p_rec in pqh_cef_shd.g_rec_type) is
130: --
131: l_proc varchar2(72) := g_package||'pre_update';
132: --
133: Begin

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

168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure post_update(
172: p_effective_date in date,p_rec in pqh_cef_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_update';
175: --
176: Begin

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

191: ,p_post_copy_function_name =>p_rec.post_copy_function_name
192: ,p_object_version_number =>p_rec.object_version_number
193: ,p_context =>p_rec.context
194: ,p_effective_date =>p_effective_date
195: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
196: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name

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

192: ,p_object_version_number =>p_rec.object_version_number
193: ,p_context =>p_rec.context
194: ,p_effective_date =>p_effective_date
195: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
196: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
200: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number

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

193: ,p_context =>p_rec.context
194: ,p_effective_date =>p_effective_date
195: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
196: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
200: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
201: ,p_context_o =>pqh_cef_shd.g_old_rec.context

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

194: ,p_effective_date =>p_effective_date
195: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
196: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
200: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
201: ,p_context_o =>pqh_cef_shd.g_old_rec.context
202: );

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

195: ,p_table_route_id_o =>pqh_cef_shd.g_old_rec.table_route_id
196: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
200: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
201: ,p_context_o =>pqh_cef_shd.g_old_rec.context
202: );
203: --

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

196: ,p_function_type_cd_o =>pqh_cef_shd.g_old_rec.function_type_cd
197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
200: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
201: ,p_context_o =>pqh_cef_shd.g_old_rec.context
202: );
203: --
204: exception

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

197: ,p_pre_copy_function_name_o =>pqh_cef_shd.g_old_rec.pre_copy_function_name
198: ,p_copy_function_name_o =>pqh_cef_shd.g_old_rec.copy_function_name
199: ,p_post_copy_function_name_o =>pqh_cef_shd.g_old_rec.post_copy_function_name
200: ,p_object_version_number_o =>pqh_cef_shd.g_old_rec.object_version_number
201: ,p_context_o =>pqh_cef_shd.g_old_rec.context
202: );
203: --
204: exception
205: --

Line 263: Procedure convert_defs(p_rec in out nocopy pqh_cef_shd.g_rec_type) is

259: -- Internal Row Handler Use Only.
260: --
261: -- {End Of Comments}
262: -- ----------------------------------------------------------------------------
263: Procedure convert_defs(p_rec in out nocopy pqh_cef_shd.g_rec_type) is
264: --
265: l_proc varchar2(72) := g_package||'convert_defs';
266: --
267: Begin

Line 278: pqh_cef_shd.g_old_rec.table_route_id;

274: -- is being used then we must set to the 'current' argument value.
275: --
276: If (p_rec.table_route_id = hr_api.g_number) then
277: p_rec.table_route_id :=
278: pqh_cef_shd.g_old_rec.table_route_id;
279: End If;
280: If (p_rec.function_type_cd = hr_api.g_varchar2) then
281: p_rec.function_type_cd :=
282: pqh_cef_shd.g_old_rec.function_type_cd;

Line 282: pqh_cef_shd.g_old_rec.function_type_cd;

278: pqh_cef_shd.g_old_rec.table_route_id;
279: End If;
280: If (p_rec.function_type_cd = hr_api.g_varchar2) then
281: p_rec.function_type_cd :=
282: pqh_cef_shd.g_old_rec.function_type_cd;
283: End If;
284: If (p_rec.pre_copy_function_name = hr_api.g_varchar2) then
285: p_rec.pre_copy_function_name :=
286: pqh_cef_shd.g_old_rec.pre_copy_function_name;

Line 286: pqh_cef_shd.g_old_rec.pre_copy_function_name;

282: pqh_cef_shd.g_old_rec.function_type_cd;
283: End If;
284: If (p_rec.pre_copy_function_name = hr_api.g_varchar2) then
285: p_rec.pre_copy_function_name :=
286: pqh_cef_shd.g_old_rec.pre_copy_function_name;
287: End If;
288: If (p_rec.copy_function_name = hr_api.g_varchar2) then
289: p_rec.copy_function_name :=
290: pqh_cef_shd.g_old_rec.copy_function_name;

Line 290: pqh_cef_shd.g_old_rec.copy_function_name;

286: pqh_cef_shd.g_old_rec.pre_copy_function_name;
287: End If;
288: If (p_rec.copy_function_name = hr_api.g_varchar2) then
289: p_rec.copy_function_name :=
290: pqh_cef_shd.g_old_rec.copy_function_name;
291: End If;
292: If (p_rec.post_copy_function_name = hr_api.g_varchar2) then
293: p_rec.post_copy_function_name :=
294: pqh_cef_shd.g_old_rec.post_copy_function_name;

Line 294: pqh_cef_shd.g_old_rec.post_copy_function_name;

290: pqh_cef_shd.g_old_rec.copy_function_name;
291: End If;
292: If (p_rec.post_copy_function_name = hr_api.g_varchar2) then
293: p_rec.post_copy_function_name :=
294: pqh_cef_shd.g_old_rec.post_copy_function_name;
295: End If;
296: If (p_rec.context = hr_api.g_varchar2) then
297: p_rec.context :=
298: pqh_cef_shd.g_old_rec.context;

Line 298: pqh_cef_shd.g_old_rec.context;

294: pqh_cef_shd.g_old_rec.post_copy_function_name;
295: End If;
296: If (p_rec.context = hr_api.g_varchar2) then
297: p_rec.context :=
298: pqh_cef_shd.g_old_rec.context;
299: End If;
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);
302: --

Line 311: p_rec in out nocopy pqh_cef_shd.g_rec_type

307: -- ----------------------------------------------------------------------------
308: Procedure upd
309: (
310: p_effective_date in date,
311: p_rec in out nocopy pqh_cef_shd.g_rec_type
312: ) is
313: --
314: l_proc varchar2(72) := g_package||'upd';
315: --

Line 321: pqh_cef_shd.lck

317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- We must lock the row which we need to update.
320: --
321: pqh_cef_shd.lck
322: (
323: p_rec.copy_entity_function_id,
324: p_rec.object_version_number
325: );

Line 367: l_rec pqh_cef_shd.g_rec_type;

363: p_object_version_number in out nocopy number,
364: p_context in varchar2 default hr_api.g_varchar2
365: ) is
366: --
367: l_rec pqh_cef_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'upd';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);

Line 377: pqh_cef_shd.convert_args

373: -- Call conversion function to turn arguments into the
374: -- l_rec structure.
375: --
376: l_rec :=
377: pqh_cef_shd.convert_args
378: (
379: p_copy_entity_function_id,
380: p_table_route_id,
381: p_function_type_cd,