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_CEP_UPD dependencies on PQH_CEP_SHD

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

Line 75: pqh_cep_shd.constraint_error

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

Line 79: pqh_cep_shd.constraint_error

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

Line 83: pqh_cep_shd.constraint_error

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

Line 121: Procedure pre_update(p_rec in pqh_cep_shd.g_rec_type) is

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

Line 164: p_effective_date in date,p_rec in pqh_cep_shd.g_rec_type) is

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

Line 184: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id

180: ,p_copy_entity_txn_id =>p_rec.copy_entity_txn_id
181: ,p_select_flag =>p_rec.select_flag
182: ,p_object_version_number =>p_rec.object_version_number
183: ,p_effective_date =>p_effective_date
184: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
185: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
186: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
187: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
188: );

Line 185: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id

181: ,p_select_flag =>p_rec.select_flag
182: ,p_object_version_number =>p_rec.object_version_number
183: ,p_effective_date =>p_effective_date
184: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
185: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
186: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
187: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
188: );
189: --

Line 186: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag

182: ,p_object_version_number =>p_rec.object_version_number
183: ,p_effective_date =>p_effective_date
184: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
185: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
186: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
187: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
188: );
189: --
190: exception

Line 187: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number

183: ,p_effective_date =>p_effective_date
184: ,p_table_route_id_o =>pqh_cep_shd.g_old_rec.table_route_id
185: ,p_copy_entity_txn_id_o =>pqh_cep_shd.g_old_rec.copy_entity_txn_id
186: ,p_select_flag_o =>pqh_cep_shd.g_old_rec.select_flag
187: ,p_object_version_number_o =>pqh_cep_shd.g_old_rec.object_version_number
188: );
189: --
190: exception
191: --

Line 249: Procedure convert_defs(p_rec in out nocopy pqh_cep_shd.g_rec_type) is

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

Line 264: pqh_cep_shd.g_old_rec.table_route_id;

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

Line 268: pqh_cep_shd.g_old_rec.copy_entity_txn_id;

264: pqh_cep_shd.g_old_rec.table_route_id;
265: End If;
266: If (p_rec.copy_entity_txn_id = hr_api.g_number) then
267: p_rec.copy_entity_txn_id :=
268: pqh_cep_shd.g_old_rec.copy_entity_txn_id;
269: End If;
270: If (p_rec.select_flag = hr_api.g_varchar2) then
271: p_rec.select_flag :=
272: pqh_cep_shd.g_old_rec.select_flag;

Line 272: pqh_cep_shd.g_old_rec.select_flag;

268: pqh_cep_shd.g_old_rec.copy_entity_txn_id;
269: End If;
270: If (p_rec.select_flag = hr_api.g_varchar2) then
271: p_rec.select_flag :=
272: pqh_cep_shd.g_old_rec.select_flag;
273: End If;
274:
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 286: p_rec in out nocopy pqh_cep_shd.g_rec_type

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

Line 296: pqh_cep_shd.lck

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

Line 339: l_rec pqh_cep_shd.g_rec_type;

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

Line 349: pqh_cep_shd.convert_args

345: -- Call conversion function to turn arguments into the
346: -- l_rec structure.
347: --
348: l_rec :=
349: pqh_cep_shd.convert_args
350: (
351: p_copy_entity_pref_id,
352: p_table_route_id,
353: p_copy_entity_txn_id,