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.PQP_ERS_INS dependencies on PQP_ERS_INS

Line 1: Package Body pqp_ers_ins as

1: Package Body pqp_ers_ins as
2: /* $Header: pqersrhi.pkb 115.2 2003/08/25 13:50:57 sshetty noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqp_ers_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 29: pqp_ers_ins.g_database_item_suffix_i := p_database_item_suffix;

25: --
26: Begin
27: hr_utility.set_location('Entering:'||l_proc, 10);
28: --
29: pqp_ers_ins.g_database_item_suffix_i := p_database_item_suffix;
30: pqp_ers_ins.g_legislation_code_i := p_legislation_code;
31: --
32: hr_utility.set_location(' Leaving:'||l_proc, 20);
33: End set_base_key_value;

Line 30: pqp_ers_ins.g_legislation_code_i := p_legislation_code;

26: Begin
27: hr_utility.set_location('Entering:'||l_proc, 10);
28: --
29: pqp_ers_ins.g_database_item_suffix_i := p_database_item_suffix;
30: pqp_ers_ins.g_legislation_code_i := p_legislation_code;
31: --
32: hr_utility.set_location(' Leaving:'||l_proc, 20);
33: End set_base_key_value;
34: --

Line 176: pqp_ers_ins.g_database_item_suffix_i

172: Cursor C_Sel2 is
173: Select null
174: from pqp_exception_report_suffix
175: where database_item_suffix =
176: pqp_ers_ins.g_database_item_suffix_i
177: or legislation_code =
178: pqp_ers_ins.g_legislation_code_i;
179: --
180: l_proc varchar2(72) := g_package||'pre_insert';

Line 178: pqp_ers_ins.g_legislation_code_i;

174: from pqp_exception_report_suffix
175: where database_item_suffix =
176: pqp_ers_ins.g_database_item_suffix_i
177: or legislation_code =
178: pqp_ers_ins.g_legislation_code_i;
179: --
180: l_proc varchar2(72) := g_package||'pre_insert';
181: l_exists varchar2(1);
182: --

Line 186: If (pqp_ers_ins.g_database_item_suffix_i is not null or

182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: If (pqp_ers_ins.g_database_item_suffix_i is not null or
187: pqp_ers_ins.g_legislation_code_i is not null) Then
188: --
189: -- Verify registered primary key values not already in use
190: --

Line 187: pqp_ers_ins.g_legislation_code_i is not null) Then

183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: If (pqp_ers_ins.g_database_item_suffix_i is not null or
187: pqp_ers_ins.g_legislation_code_i is not null) Then
188: --
189: -- Verify registered primary key values not already in use
190: --
191: Open C_Sel2;

Line 207: pqp_ers_ins.g_database_item_suffix_i;

203: --
204: -- Use registered key values and clear globals
205: --
206: p_rec.database_item_suffix :=
207: pqp_ers_ins.g_database_item_suffix_i;
208: pqp_ers_ins.g_database_item_suffix_i := null;
209: p_rec.legislation_code :=
210: pqp_ers_ins.g_legislation_code_i;
211: pqp_ers_ins.g_legislation_code_i := null;

Line 208: pqp_ers_ins.g_database_item_suffix_i := null;

204: -- Use registered key values and clear globals
205: --
206: p_rec.database_item_suffix :=
207: pqp_ers_ins.g_database_item_suffix_i;
208: pqp_ers_ins.g_database_item_suffix_i := null;
209: p_rec.legislation_code :=
210: pqp_ers_ins.g_legislation_code_i;
211: pqp_ers_ins.g_legislation_code_i := null;
212: End If;

Line 210: pqp_ers_ins.g_legislation_code_i;

206: p_rec.database_item_suffix :=
207: pqp_ers_ins.g_database_item_suffix_i;
208: pqp_ers_ins.g_database_item_suffix_i := null;
209: p_rec.legislation_code :=
210: pqp_ers_ins.g_legislation_code_i;
211: pqp_ers_ins.g_legislation_code_i := null;
212: End If;
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 211: pqp_ers_ins.g_legislation_code_i := null;

207: pqp_ers_ins.g_database_item_suffix_i;
208: pqp_ers_ins.g_database_item_suffix_i := null;
209: p_rec.legislation_code :=
210: pqp_ers_ins.g_legislation_code_i;
211: pqp_ers_ins.g_legislation_code_i := null;
212: End If;
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_insert;

Line 307: pqp_ers_ins.pre_insert(p_rec);

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

Line 311: pqp_ers_ins.insert_dml(p_rec);

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

Line 315: pqp_ers_ins.post_insert

311: pqp_ers_ins.insert_dml(p_rec);
312: --
313: -- Call the supporting post-insert operation
314: --
315: pqp_ers_ins.post_insert
316: (p_rec
317: );
318: --
319: -- Call to raise any errors on multi-message list

Line 355: pqp_ers_ins.ins

351: --
352: -- Having converted the arguments into the pqp_ers_rec
353: -- plsql record structure we call the corresponding record business process.
354: --
355: pqp_ers_ins.ins
356: (l_rec
357: );
358: --
359: -- As the primary key argument(s)

Line 367: end pqp_ers_ins;

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