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_TAH_INS dependencies on PQH_TAH_INS

Line 1: Package Body pqh_tah_ins as

1: Package Body pqh_tah_ins as
2: /* $Header: pqtahrhi.pkb 120.2 2005/12/21 11:27:52 hpandya noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_tah_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_tah_ins.g_approval_history_id_i := p_approval_history_id;

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

Line 29: pqh_tah_ins.g_transaction_history_id_i := p_transaction_history_id;

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

Line 191: where approval_history_id = pqh_tah_ins.g_approval_history_id_i

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

Line 192: AND transaction_history_id = pqh_tah_ins.g_transaction_history_id_i;

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

Line 200: If (pqh_tah_ins.g_approval_history_id_i is not null AND

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

Line 201: pqh_tah_ins.g_transaction_history_id_i is not null) Then

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

Line 219: p_rec.approval_history_id := pqh_tah_ins.g_approval_history_id_i;

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

Line 220: pqh_tah_ins.g_approval_history_id_i := null;

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

Line 221: p_rec.transaction_history_id := pqh_tah_ins.g_transaction_history_id_i;

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

Line 222: pqh_tah_ins.g_transaction_history_id_i := null;

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

Line 310: pqh_tah_ins.pre_insert(p_rec);

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

Line 314: pqh_tah_ins.insert_dml(p_rec);

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

Line 318: pqh_tah_ins.post_insert

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

Line 374: pqh_tah_ins.ins

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

Line 388: end pqh_tah_ins;

384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End ins;
387: --
388: end pqh_tah_ins;