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_TXH_UPD dependencies on PQH_TXH_SHD

Line 55: (p_rec in out nocopy pqh_txh_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_txh_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 94: pqh_txh_shd.constraint_error

90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: pqh_txh_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --

Line 99: pqh_txh_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pqh_txh_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --

Line 104: pqh_txh_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pqh_txh_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;

Line 144: (p_rec in pqh_txh_shd.g_rec_type

140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure pre_update
144: (p_rec in pqh_txh_shd.g_rec_type
145: ) is
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --

Line 188: (p_rec in pqh_txh_shd.g_rec_type

184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_rec in pqh_txh_shd.g_rec_type
189: ) is
190: --
191: l_proc varchar2(72) := g_package||'post_update';
192: --

Line 256: (p_rec in out nocopy pqh_txh_shd.g_rec_type

252: --
253: -- {End Of Comments}
254: -- ----------------------------------------------------------------------------
255: Procedure convert_defs
256: (p_rec in out nocopy pqh_txh_shd.g_rec_type
257: ) is
258: --
259: Begin
260: --

Line 268: pqh_txh_shd.g_old_rec.creator_person_id;

264: -- is being used then we must set to the 'current' argument value.
265: --
266: If (p_rec.creator_person_id = hr_api.g_number) then
267: p_rec.creator_person_id :=
268: pqh_txh_shd.g_old_rec.creator_person_id;
269: End If;
270: If (p_rec.assignment_id = hr_api.g_number) then
271: p_rec.assignment_id :=
272: pqh_txh_shd.g_old_rec.assignment_id;

Line 272: pqh_txh_shd.g_old_rec.assignment_id;

268: pqh_txh_shd.g_old_rec.creator_person_id;
269: End If;
270: If (p_rec.assignment_id = hr_api.g_number) then
271: p_rec.assignment_id :=
272: pqh_txh_shd.g_old_rec.assignment_id;
273: End If;
274: If (p_rec.selected_person_id = hr_api.g_number) then
275: p_rec.selected_person_id :=
276: pqh_txh_shd.g_old_rec.selected_person_id;

Line 276: pqh_txh_shd.g_old_rec.selected_person_id;

272: pqh_txh_shd.g_old_rec.assignment_id;
273: End If;
274: If (p_rec.selected_person_id = hr_api.g_number) then
275: p_rec.selected_person_id :=
276: pqh_txh_shd.g_old_rec.selected_person_id;
277: End If;
278: If (p_rec.item_type = hr_api.g_varchar2) then
279: p_rec.item_type :=
280: pqh_txh_shd.g_old_rec.item_type;

Line 280: pqh_txh_shd.g_old_rec.item_type;

276: pqh_txh_shd.g_old_rec.selected_person_id;
277: End If;
278: If (p_rec.item_type = hr_api.g_varchar2) then
279: p_rec.item_type :=
280: pqh_txh_shd.g_old_rec.item_type;
281: End If;
282: If (p_rec.item_key = hr_api.g_varchar2) then
283: p_rec.item_key :=
284: pqh_txh_shd.g_old_rec.item_key;

Line 284: pqh_txh_shd.g_old_rec.item_key;

280: pqh_txh_shd.g_old_rec.item_type;
281: End If;
282: If (p_rec.item_key = hr_api.g_varchar2) then
283: p_rec.item_key :=
284: pqh_txh_shd.g_old_rec.item_key;
285: End If;
286: If (p_rec.process_name = hr_api.g_varchar2) then
287: p_rec.process_name :=
288: pqh_txh_shd.g_old_rec.process_name;

Line 288: pqh_txh_shd.g_old_rec.process_name;

284: pqh_txh_shd.g_old_rec.item_key;
285: End If;
286: If (p_rec.process_name = hr_api.g_varchar2) then
287: p_rec.process_name :=
288: pqh_txh_shd.g_old_rec.process_name;
289: End If;
290: If (p_rec.approval_item_type = hr_api.g_varchar2) then
291: p_rec.approval_item_type :=
292: pqh_txh_shd.g_old_rec.approval_item_type;

Line 292: pqh_txh_shd.g_old_rec.approval_item_type;

288: pqh_txh_shd.g_old_rec.process_name;
289: End If;
290: If (p_rec.approval_item_type = hr_api.g_varchar2) then
291: p_rec.approval_item_type :=
292: pqh_txh_shd.g_old_rec.approval_item_type;
293: End If;
294: If (p_rec.approval_item_key = hr_api.g_varchar2) then
295: p_rec.approval_item_key :=
296: pqh_txh_shd.g_old_rec.approval_item_key;

Line 296: pqh_txh_shd.g_old_rec.approval_item_key;

292: pqh_txh_shd.g_old_rec.approval_item_type;
293: End If;
294: If (p_rec.approval_item_key = hr_api.g_varchar2) then
295: p_rec.approval_item_key :=
296: pqh_txh_shd.g_old_rec.approval_item_key;
297: End If;
298: If (p_rec.function_id = hr_api.g_number) then
299: p_rec.function_id :=
300: pqh_txh_shd.g_old_rec.function_id;

Line 300: pqh_txh_shd.g_old_rec.function_id;

296: pqh_txh_shd.g_old_rec.approval_item_key;
297: End If;
298: If (p_rec.function_id = hr_api.g_number) then
299: p_rec.function_id :=
300: pqh_txh_shd.g_old_rec.function_id;
301: End If;
302: If (p_rec.rptg_grp_id = hr_api.g_number) then
303: p_rec.rptg_grp_id :=
304: pqh_txh_shd.g_old_rec.rptg_grp_id;

Line 304: pqh_txh_shd.g_old_rec.rptg_grp_id;

300: pqh_txh_shd.g_old_rec.function_id;
301: End If;
302: If (p_rec.rptg_grp_id = hr_api.g_number) then
303: p_rec.rptg_grp_id :=
304: pqh_txh_shd.g_old_rec.rptg_grp_id;
305: End If;
306: If (p_rec.plan_id = hr_api.g_number) then
307: p_rec.plan_id :=
308: pqh_txh_shd.g_old_rec.plan_id;

Line 308: pqh_txh_shd.g_old_rec.plan_id;

304: pqh_txh_shd.g_old_rec.rptg_grp_id;
305: End If;
306: If (p_rec.plan_id = hr_api.g_number) then
307: p_rec.plan_id :=
308: pqh_txh_shd.g_old_rec.plan_id;
309: End If;
310: If (p_rec.transaction_group = hr_api.g_varchar2) then
311: p_rec.transaction_group :=
312: pqh_txh_shd.g_old_rec.transaction_group;

Line 312: pqh_txh_shd.g_old_rec.transaction_group;

308: pqh_txh_shd.g_old_rec.plan_id;
309: End If;
310: If (p_rec.transaction_group = hr_api.g_varchar2) then
311: p_rec.transaction_group :=
312: pqh_txh_shd.g_old_rec.transaction_group;
313: End If;
314: If (p_rec.transaction_identifier = hr_api.g_varchar2) then
315: p_rec.transaction_identifier :=
316: pqh_txh_shd.g_old_rec.transaction_identifier;

Line 316: pqh_txh_shd.g_old_rec.transaction_identifier;

312: pqh_txh_shd.g_old_rec.transaction_group;
313: End If;
314: If (p_rec.transaction_identifier = hr_api.g_varchar2) then
315: p_rec.transaction_identifier :=
316: pqh_txh_shd.g_old_rec.transaction_identifier;
317: End If;
318: --
319: End convert_defs;
320: --

Line 325: (p_rec in out nocopy pqh_txh_shd.g_rec_type

321: -- ----------------------------------------------------------------------------
322: -- |---------------------------------< upd >----------------------------------|
323: -- ----------------------------------------------------------------------------
324: Procedure upd
325: (p_rec in out nocopy pqh_txh_shd.g_rec_type
326: ) is
327: --
328: l_proc varchar2(72) := g_package||'upd';
329: --

Line 335: pqh_txh_shd.lck

331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- We must lock the row which we need to update.
334: --
335: pqh_txh_shd.lck
336: (p_rec.transaction_history_id
337: );
338: --
339: -- 1. During an update system defaults are used to determine if

Line 391: l_rec pqh_txh_shd.g_rec_type;

387: ,p_transaction_group in varchar2 default hr_api.g_varchar2
388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2
389: ) is
390: --
391: l_rec pqh_txh_shd.g_rec_type;
392: l_proc varchar2(72) := g_package||'upd';
393: --
394: Begin
395: hr_utility.set_location('Entering:'||l_proc, 5);

Line 401: pqh_txh_shd.convert_args

397: -- Call conversion function to turn arguments into the
398: -- l_rec structure.
399: --
400: l_rec :=
401: pqh_txh_shd.convert_args
402: (p_transaction_history_id
403: ,p_creator_person_id
404: ,p_assignment_id
405: ,p_selected_person_id