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_INS dependencies on PQH_TSH_INS

Line 1: Package Body pqh_tsh_ins as

1: Package Body pqh_tsh_ins as
2: /* $Header: pqtshrhi.pkb 120.2 2005/12/21 11:28:58 hpandya noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pqh_tsh_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_tsh_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 28: pqh_tsh_ins.g_transaction_history_id_i := p_transaction_history_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pqh_tsh_ins.g_transaction_history_id_i := p_transaction_history_id;
29: pqh_tsh_ins.g_approval_history_id_i := p_approval_history_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: pqh_tsh_ins.g_approval_history_id_i := p_approval_history_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pqh_tsh_ins.g_transaction_history_id_i := p_transaction_history_id;
29: pqh_tsh_ins.g_approval_history_id_i := p_approval_history_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 191: where transaction_history_id = pqh_tsh_ins.g_transaction_history_id_i

187: --
188: Cursor C_Sel2 is
189: Select null
190: from pqh_ss_trans_state_history
191: where transaction_history_id = pqh_tsh_ins.g_transaction_history_id_i
192: and approval_history_id = pqh_tsh_ins.g_approval_history_id_i;
193: --
194: l_proc varchar2(72) := g_package||'pre_insert';
195: l_exists varchar2(1);

Line 192: and approval_history_id = pqh_tsh_ins.g_approval_history_id_i;

188: Cursor C_Sel2 is
189: Select null
190: from pqh_ss_trans_state_history
191: where transaction_history_id = pqh_tsh_ins.g_transaction_history_id_i
192: and approval_history_id = pqh_tsh_ins.g_approval_history_id_i;
193: --
194: l_proc varchar2(72) := g_package||'pre_insert';
195: l_exists varchar2(1);
196: --

Line 201: If (pqh_tsh_ins.g_transaction_history_id_i is not null AND

197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199:
200: --
201: If (pqh_tsh_ins.g_transaction_history_id_i is not null AND
202: pqh_tsh_ins.g_approval_history_id_i is not null) Then
203: --
204: -- Verify registered primary key values not already in use
205: --

Line 202: pqh_tsh_ins.g_approval_history_id_i is not null) Then

198: hr_utility.set_location('Entering:'||l_proc, 5);
199:
200: --
201: If (pqh_tsh_ins.g_transaction_history_id_i is not null AND
202: pqh_tsh_ins.g_approval_history_id_i is not null) Then
203: --
204: -- Verify registered primary key values not already in use
205: --
206: Open C_Sel2;

Line 220: p_rec.transaction_history_id := pqh_tsh_ins.g_transaction_history_id_i;

216: Close C_Sel2;
217: --
218: -- Use registered key values and clear globals
219: --
220: p_rec.transaction_history_id := pqh_tsh_ins.g_transaction_history_id_i;
221: pqh_tsh_ins.g_transaction_history_id_i := null;
222: p_rec.approval_history_id := pqh_tsh_ins.g_approval_history_id_i;
223: pqh_tsh_ins.g_approval_history_id_i := null;
224: Else

Line 221: pqh_tsh_ins.g_transaction_history_id_i := null;

217: --
218: -- Use registered key values and clear globals
219: --
220: p_rec.transaction_history_id := pqh_tsh_ins.g_transaction_history_id_i;
221: pqh_tsh_ins.g_transaction_history_id_i := null;
222: p_rec.approval_history_id := pqh_tsh_ins.g_approval_history_id_i;
223: pqh_tsh_ins.g_approval_history_id_i := null;
224: Else
225: NULL;

Line 222: p_rec.approval_history_id := pqh_tsh_ins.g_approval_history_id_i;

218: -- Use registered key values and clear globals
219: --
220: p_rec.transaction_history_id := pqh_tsh_ins.g_transaction_history_id_i;
221: pqh_tsh_ins.g_transaction_history_id_i := null;
222: p_rec.approval_history_id := pqh_tsh_ins.g_approval_history_id_i;
223: pqh_tsh_ins.g_approval_history_id_i := null;
224: Else
225: NULL;
226: End If;

Line 223: pqh_tsh_ins.g_approval_history_id_i := null;

219: --
220: p_rec.transaction_history_id := pqh_tsh_ins.g_transaction_history_id_i;
221: pqh_tsh_ins.g_transaction_history_id_i := null;
222: p_rec.approval_history_id := pqh_tsh_ins.g_approval_history_id_i;
223: pqh_tsh_ins.g_approval_history_id_i := null;
224: Else
225: NULL;
226: End If;
227: --

Line 312: pqh_tsh_ins.pre_insert(p_rec);

308: hr_multi_message.end_validation_set;
309: --
310: -- Call the supporting pre-insert operation
311: --
312: pqh_tsh_ins.pre_insert(p_rec);
313: --
314: -- Insert the row
315: --
316: pqh_tsh_ins.insert_dml(p_rec);

Line 316: pqh_tsh_ins.insert_dml(p_rec);

312: pqh_tsh_ins.pre_insert(p_rec);
313: --
314: -- Insert the row
315: --
316: pqh_tsh_ins.insert_dml(p_rec);
317: --
318: -- Call the supporting post-insert operation
319: --
320: pqh_tsh_ins.post_insert

Line 320: pqh_tsh_ins.post_insert

316: pqh_tsh_ins.insert_dml(p_rec);
317: --
318: -- Call the supporting post-insert operation
319: --
320: pqh_tsh_ins.post_insert
321: (p_rec
322: );
323: --
324: -- Call to raise any errors on multi-message list

Line 376: pqh_tsh_ins.ins

372: --
373: -- Having converted the arguments into the pqh_tsh_rec
374: -- plsql record structure we call the corresponding record business process.
375: --
376: pqh_tsh_ins.ins
377: (l_rec
378: );
379: --
380: -- As the primary key argument(s)

Line 390: end pqh_tsh_ins;

386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: End ins;
389: --
390: end pqh_tsh_ins;