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_TCD_INS dependencies on PQH_TCD_INS

Line 1: Package Body pqh_tcd_ins as

1: Package Body pqh_tcd_ins as
2: /* $Header: pqtcdrhi.pkb 115.0 2003/05/11 13:05:52 svorugan noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_tcd_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_tcd_ins.g_document_id_i := p_document_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pqh_tcd_ins.g_document_id_i := p_document_id;
29: pqh_tcd_ins.g_transaction_category_id_i := p_transaction_category_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: pqh_tcd_ins.g_transaction_category_id_i := p_transaction_category_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pqh_tcd_ins.g_document_id_i := p_document_id;
29: pqh_tcd_ins.g_transaction_category_id_i := p_transaction_category_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 174: pqh_tcd_ins.g_document_id_i

170: Cursor C_Sel2 is
171: Select null
172: from pqh_txn_category_documents
173: where document_id =
174: pqh_tcd_ins.g_document_id_i
175: or transaction_category_id =
176: pqh_tcd_ins.g_transaction_category_id_i;
177: --
178: l_proc varchar2(72) := g_package||'pre_insert';

Line 176: pqh_tcd_ins.g_transaction_category_id_i;

172: from pqh_txn_category_documents
173: where document_id =
174: pqh_tcd_ins.g_document_id_i
175: or transaction_category_id =
176: pqh_tcd_ins.g_transaction_category_id_i;
177: --
178: l_proc varchar2(72) := g_package||'pre_insert';
179: l_exists varchar2(1);
180: --

Line 184: If (pqh_tcd_ins.g_document_id_i is not null or

180: --
181: Begin
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: If (pqh_tcd_ins.g_document_id_i is not null or
185: pqh_tcd_ins.g_transaction_category_id_i is not null) Then
186: --
187: -- Verify registered primary key values not already in use
188: --

Line 185: pqh_tcd_ins.g_transaction_category_id_i is not null) Then

181: Begin
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: If (pqh_tcd_ins.g_document_id_i is not null or
185: pqh_tcd_ins.g_transaction_category_id_i is not null) Then
186: --
187: -- Verify registered primary key values not already in use
188: --
189: Open C_Sel2;

Line 205: pqh_tcd_ins.g_document_id_i;

201: --
202: -- Use registered key values and clear globals
203: --
204: p_rec.document_id :=
205: pqh_tcd_ins.g_document_id_i;
206: pqh_tcd_ins.g_document_id_i := null;
207: p_rec.transaction_category_id :=
208: pqh_tcd_ins.g_transaction_category_id_i;
209: pqh_tcd_ins.g_transaction_category_id_i := null;

Line 206: pqh_tcd_ins.g_document_id_i := null;

202: -- Use registered key values and clear globals
203: --
204: p_rec.document_id :=
205: pqh_tcd_ins.g_document_id_i;
206: pqh_tcd_ins.g_document_id_i := null;
207: p_rec.transaction_category_id :=
208: pqh_tcd_ins.g_transaction_category_id_i;
209: pqh_tcd_ins.g_transaction_category_id_i := null;
210: End If;

Line 208: pqh_tcd_ins.g_transaction_category_id_i;

204: p_rec.document_id :=
205: pqh_tcd_ins.g_document_id_i;
206: pqh_tcd_ins.g_document_id_i := null;
207: p_rec.transaction_category_id :=
208: pqh_tcd_ins.g_transaction_category_id_i;
209: pqh_tcd_ins.g_transaction_category_id_i := null;
210: End If;
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 209: pqh_tcd_ins.g_transaction_category_id_i := null;

205: pqh_tcd_ins.g_document_id_i;
206: pqh_tcd_ins.g_document_id_i := null;
207: p_rec.transaction_category_id :=
208: pqh_tcd_ins.g_transaction_category_id_i;
209: pqh_tcd_ins.g_transaction_category_id_i := null;
210: End If;
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 10);
213: End pre_insert;

Line 308: pqh_tcd_ins.pre_insert(p_rec);

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

Line 312: pqh_tcd_ins.insert_dml(p_rec);

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

Line 316: pqh_tcd_ins.post_insert

312: pqh_tcd_ins.insert_dml(p_rec);
313: --
314: -- Call the supporting post-insert operation
315: --
316: pqh_tcd_ins.post_insert
317: (p_effective_date
318: ,p_rec
319: );
320: --

Line 358: pqh_tcd_ins.ins

354: --
355: -- Having converted the arguments into the pqh_tcd_rec
356: -- plsql record structure we call the corresponding record business process.
357: --
358: pqh_tcd_ins.ins
359: (p_effective_date
360: ,l_rec
361: );
362: --

Line 368: end pqh_tcd_ins;

364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End ins;
367: --
368: end pqh_tcd_ins;