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_RCT_UPD dependencies on PQH_RCT_SHD

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

Line 84: pqh_rct_shd.constraint_error

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

Line 88: pqh_rct_shd.constraint_error

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

Line 92: pqh_rct_shd.constraint_error

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

Line 130: Procedure pre_update(p_rec in pqh_rct_shd.g_rec_type) is

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

Line 172: Procedure post_update(p_effective_date in date,p_rec in pqh_rct_shd.g_rec_type) is

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

Line 199: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id

195: ,p_override_role_id =>p_rec.override_role_id
196: ,p_override_user_id =>p_rec.override_user_id
197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_effective_date =>p_effective_date
199: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id

Line 200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag

196: ,p_override_user_id =>p_rec.override_user_id
197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_effective_date =>p_effective_date
199: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id

Line 201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag

197: ,p_object_version_number =>p_rec.object_version_number
198: ,p_effective_date =>p_effective_date
199: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id

Line 202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag

198: ,p_effective_date =>p_effective_date
199: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id

Line 203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id

199: ,p_transaction_category_id_o =>pqh_rct_shd.g_old_rec.transaction_category_id
200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id

Line 204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id

200: ,p_enable_flag_o =>pqh_rct_shd.g_old_rec.enable_flag
201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id

Line 205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id

201: ,p_default_flag_o =>pqh_rct_shd.g_old_rec.default_flag
202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
209: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number

Line 206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id

202: ,p_delete_flag_o =>pqh_rct_shd.g_old_rec.delete_flag
203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
209: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
210: );

Line 207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id

203: ,p_routing_list_id_o =>pqh_rct_shd.g_old_rec.routing_list_id
204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
209: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
210: );
211: --

Line 208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id

204: ,p_position_structure_id_o =>pqh_rct_shd.g_old_rec.position_structure_id
205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
209: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
210: );
211: --
212: exception

Line 209: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number

205: ,p_override_position_id_o =>pqh_rct_shd.g_old_rec.override_position_id
206: ,p_override_assignment_id_o =>pqh_rct_shd.g_old_rec.override_assignment_id
207: ,p_override_role_id_o =>pqh_rct_shd.g_old_rec.override_role_id
208: ,p_override_user_id_o =>pqh_rct_shd.g_old_rec.override_user_id
209: ,p_object_version_number_o =>pqh_rct_shd.g_old_rec.object_version_number
210: );
211: --
212: exception
213: --

Line 271: Procedure convert_defs(p_rec in out nocopy pqh_rct_shd.g_rec_type) is

267: -- Internal Row Handler Use Only.
268: --
269: -- {End Of Comments}
270: -- ----------------------------------------------------------------------------
271: Procedure convert_defs(p_rec in out nocopy pqh_rct_shd.g_rec_type) is
272: --
273: l_proc varchar2(72) := g_package||'convert_defs';
274: --
275: Begin

Line 286: pqh_rct_shd.g_old_rec.transaction_category_id;

282: -- is being used then we must set to the 'current' argument value.
283: --
284: If (p_rec.transaction_category_id = hr_api.g_number) then
285: p_rec.transaction_category_id :=
286: pqh_rct_shd.g_old_rec.transaction_category_id;
287: End If;
288: If (p_rec.enable_flag = hr_api.g_varchar2) then
289: p_rec.enable_flag :=
290: pqh_rct_shd.g_old_rec.enable_flag;

Line 290: pqh_rct_shd.g_old_rec.enable_flag;

286: pqh_rct_shd.g_old_rec.transaction_category_id;
287: End If;
288: If (p_rec.enable_flag = hr_api.g_varchar2) then
289: p_rec.enable_flag :=
290: pqh_rct_shd.g_old_rec.enable_flag;
291: End If;
292: If (p_rec.default_flag = hr_api.g_varchar2) then
293: p_rec.default_flag :=
294: pqh_rct_shd.g_old_rec.default_flag;

Line 294: pqh_rct_shd.g_old_rec.default_flag;

290: pqh_rct_shd.g_old_rec.enable_flag;
291: End If;
292: If (p_rec.default_flag = hr_api.g_varchar2) then
293: p_rec.default_flag :=
294: pqh_rct_shd.g_old_rec.default_flag;
295: End If;
296: If (p_rec.delete_flag = hr_api.g_varchar2) then
297: p_rec.delete_flag :=
298: pqh_rct_shd.g_old_rec.delete_flag;

Line 298: pqh_rct_shd.g_old_rec.delete_flag;

294: pqh_rct_shd.g_old_rec.default_flag;
295: End If;
296: If (p_rec.delete_flag = hr_api.g_varchar2) then
297: p_rec.delete_flag :=
298: pqh_rct_shd.g_old_rec.delete_flag;
299: End If;
300: If (p_rec.routing_list_id = hr_api.g_number) then
301: p_rec.routing_list_id :=
302: pqh_rct_shd.g_old_rec.routing_list_id;

Line 302: pqh_rct_shd.g_old_rec.routing_list_id;

298: pqh_rct_shd.g_old_rec.delete_flag;
299: End If;
300: If (p_rec.routing_list_id = hr_api.g_number) then
301: p_rec.routing_list_id :=
302: pqh_rct_shd.g_old_rec.routing_list_id;
303: End If;
304: If (p_rec.position_structure_id = hr_api.g_number) then
305: p_rec.position_structure_id :=
306: pqh_rct_shd.g_old_rec.position_structure_id;

Line 306: pqh_rct_shd.g_old_rec.position_structure_id;

302: pqh_rct_shd.g_old_rec.routing_list_id;
303: End If;
304: If (p_rec.position_structure_id = hr_api.g_number) then
305: p_rec.position_structure_id :=
306: pqh_rct_shd.g_old_rec.position_structure_id;
307: End If;
308: If (p_rec.override_position_id = hr_api.g_number) then
309: p_rec.override_position_id :=
310: pqh_rct_shd.g_old_rec.override_position_id;

Line 310: pqh_rct_shd.g_old_rec.override_position_id;

306: pqh_rct_shd.g_old_rec.position_structure_id;
307: End If;
308: If (p_rec.override_position_id = hr_api.g_number) then
309: p_rec.override_position_id :=
310: pqh_rct_shd.g_old_rec.override_position_id;
311: End If;
312: If (p_rec.override_assignment_id = hr_api.g_number) then
313: p_rec.override_assignment_id :=
314: pqh_rct_shd.g_old_rec.override_assignment_id;

Line 314: pqh_rct_shd.g_old_rec.override_assignment_id;

310: pqh_rct_shd.g_old_rec.override_position_id;
311: End If;
312: If (p_rec.override_assignment_id = hr_api.g_number) then
313: p_rec.override_assignment_id :=
314: pqh_rct_shd.g_old_rec.override_assignment_id;
315: End If;
316: If (p_rec.override_role_id = hr_api.g_number) then
317: p_rec.override_role_id :=
318: pqh_rct_shd.g_old_rec.override_role_id;

Line 318: pqh_rct_shd.g_old_rec.override_role_id;

314: pqh_rct_shd.g_old_rec.override_assignment_id;
315: End If;
316: If (p_rec.override_role_id = hr_api.g_number) then
317: p_rec.override_role_id :=
318: pqh_rct_shd.g_old_rec.override_role_id;
319: End If;
320: If (p_rec.override_user_id = hr_api.g_number) then
321: p_rec.override_user_id :=
322: pqh_rct_shd.g_old_rec.override_user_id;

Line 322: pqh_rct_shd.g_old_rec.override_user_id;

318: pqh_rct_shd.g_old_rec.override_role_id;
319: End If;
320: If (p_rec.override_user_id = hr_api.g_number) then
321: p_rec.override_user_id :=
322: pqh_rct_shd.g_old_rec.override_user_id;
323: End If;
324:
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 336: p_rec in out nocopy pqh_rct_shd.g_rec_type

332: -- ----------------------------------------------------------------------------
333: Procedure upd
334: (
335: p_effective_date in date,
336: p_rec in out nocopy pqh_rct_shd.g_rec_type
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'upd';
340: --

Line 346: pqh_rct_shd.lck

342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- We must lock the row which we need to update.
345: --
346: pqh_rct_shd.lck
347: (
348: p_rec.routing_category_id,
349: p_rec.object_version_number
350: );

Line 394: l_rec pqh_rct_shd.g_rec_type;

390: p_override_user_id in number default hr_api.g_number,
391: p_object_version_number in out nocopy number
392: ) is
393: --
394: l_rec pqh_rct_shd.g_rec_type;
395: l_proc varchar2(72) := g_package||'upd';
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);

Line 404: pqh_rct_shd.convert_args

400: -- Call conversion function to turn arguments into the
401: -- l_rec structure.
402: --
403: l_rec :=
404: pqh_rct_shd.convert_args
405: (
406: p_routing_category_id,
407: p_transaction_category_id,
408: p_enable_flag,