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_TSH_UPD dependencies on PQH_TSH_SHD

Line 55: (p_rec in out nocopy pqh_tsh_shd.g_rec_type

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

Line 93: pqh_tsh_shd.constraint_error

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

Line 98: pqh_tsh_shd.constraint_error

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

Line 103: pqh_tsh_shd.constraint_error

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

Line 143: (p_rec in pqh_tsh_shd.g_rec_type

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

Line 187: (p_rec in pqh_tsh_shd.g_rec_type

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

Line 255: (p_rec in out nocopy pqh_tsh_shd.g_rec_type

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

Line 267: pqh_tsh_shd.g_old_rec.creator_person_id;

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

Line 271: pqh_tsh_shd.g_old_rec.creator_role;

267: pqh_tsh_shd.g_old_rec.creator_person_id;
268: End If;
269: If (p_rec.creator_role = hr_api.g_varchar2) then
270: p_rec.creator_role :=
271: pqh_tsh_shd.g_old_rec.creator_role;
272: End If;
273: If (p_rec.status = hr_api.g_varchar2) then
274: p_rec.status :=
275: pqh_tsh_shd.g_old_rec.status;

Line 275: pqh_tsh_shd.g_old_rec.status;

271: pqh_tsh_shd.g_old_rec.creator_role;
272: End If;
273: If (p_rec.status = hr_api.g_varchar2) then
274: p_rec.status :=
275: pqh_tsh_shd.g_old_rec.status;
276: End If;
277: If (p_rec.transaction_state = hr_api.g_varchar2) then
278: p_rec.transaction_state :=
279: pqh_tsh_shd.g_old_rec.transaction_state;

Line 279: pqh_tsh_shd.g_old_rec.transaction_state;

275: pqh_tsh_shd.g_old_rec.status;
276: End If;
277: If (p_rec.transaction_state = hr_api.g_varchar2) then
278: p_rec.transaction_state :=
279: pqh_tsh_shd.g_old_rec.transaction_state;
280: End If;
281: If (p_rec.effective_date = hr_api.g_date) then
282: p_rec.effective_date :=
283: pqh_tsh_shd.g_old_rec.effective_date;

Line 283: pqh_tsh_shd.g_old_rec.effective_date;

279: pqh_tsh_shd.g_old_rec.transaction_state;
280: End If;
281: If (p_rec.effective_date = hr_api.g_date) then
282: p_rec.effective_date :=
283: pqh_tsh_shd.g_old_rec.effective_date;
284: End If;
285: If (p_rec.effective_date_option = hr_api.g_varchar2) then
286: p_rec.effective_date_option :=
287: pqh_tsh_shd.g_old_rec.effective_date_option;

Line 287: pqh_tsh_shd.g_old_rec.effective_date_option;

283: pqh_tsh_shd.g_old_rec.effective_date;
284: End If;
285: If (p_rec.effective_date_option = hr_api.g_varchar2) then
286: p_rec.effective_date_option :=
287: pqh_tsh_shd.g_old_rec.effective_date_option;
288: End If;
289: If (p_rec.last_update_role = hr_api.g_varchar2) then
290: p_rec.last_update_role :=
291: pqh_tsh_shd.g_old_rec.last_update_role;

Line 291: pqh_tsh_shd.g_old_rec.last_update_role;

287: pqh_tsh_shd.g_old_rec.effective_date_option;
288: End If;
289: If (p_rec.last_update_role = hr_api.g_varchar2) then
290: p_rec.last_update_role :=
291: pqh_tsh_shd.g_old_rec.last_update_role;
292: End If;
293: If (p_rec.parent_transaction_id = hr_api.g_number) then
294: p_rec.parent_transaction_id :=
295: pqh_tsh_shd.g_old_rec.parent_transaction_id;

Line 295: pqh_tsh_shd.g_old_rec.parent_transaction_id;

291: pqh_tsh_shd.g_old_rec.last_update_role;
292: End If;
293: If (p_rec.parent_transaction_id = hr_api.g_number) then
294: p_rec.parent_transaction_id :=
295: pqh_tsh_shd.g_old_rec.parent_transaction_id;
296: End If;
297: If (p_rec.relaunch_function = hr_api.g_varchar2) then
298: p_rec.relaunch_function :=
299: pqh_tsh_shd.g_old_rec.relaunch_function;

Line 299: pqh_tsh_shd.g_old_rec.relaunch_function;

295: pqh_tsh_shd.g_old_rec.parent_transaction_id;
296: End If;
297: If (p_rec.relaunch_function = hr_api.g_varchar2) then
298: p_rec.relaunch_function :=
299: pqh_tsh_shd.g_old_rec.relaunch_function;
300: End If;
301: If (p_rec.transaction_document IS NULL) then
302: p_rec.transaction_document := pqh_tsh_shd.g_old_rec.transaction_document;
303: End If;

Line 302: p_rec.transaction_document := pqh_tsh_shd.g_old_rec.transaction_document;

298: p_rec.relaunch_function :=
299: pqh_tsh_shd.g_old_rec.relaunch_function;
300: End If;
301: If (p_rec.transaction_document IS NULL) then
302: p_rec.transaction_document := pqh_tsh_shd.g_old_rec.transaction_document;
303: End If;
304: --
305: End convert_defs;
306: --

Line 311: (p_rec in out nocopy pqh_tsh_shd.g_rec_type

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

Line 321: pqh_tsh_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_tsh_shd.lck
322: (p_rec.transaction_history_id
323: ,p_rec.approval_history_id
324: );
325: --

Line 376: l_rec pqh_tsh_shd.g_rec_type;

372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2
373: ,p_transaction_document in CLOB default NULL
374: ) is
375: --
376: l_rec pqh_tsh_shd.g_rec_type;
377: l_proc varchar2(72) := g_package||'upd';
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 5);

Line 386: pqh_tsh_shd.convert_args

382: -- Call conversion function to turn arguments into the
383: -- l_rec structure.
384: --
385: l_rec :=
386: pqh_tsh_shd.convert_args
387: (p_transaction_history_id
388: ,p_approval_history_id
389: ,p_creator_person_id
390: ,p_creator_role