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_VER_INS dependencies on PQH_VER_INS

Line 1: Package Body pqh_ver_ins as

1: Package Body pqh_ver_ins as
2: /* $Header: pqverrhi.pkb 115.3 2002/12/05 00:30:42 rpasapul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_ver_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 26: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i := p_wrkplc_vldtn_ver_id;

22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i := p_wrkplc_vldtn_ver_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --

Line 199: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;

195: Cursor C_Sel2 is
196: Select null
197: from pqh_de_wrkplc_vldtn_vers
198: where wrkplc_vldtn_ver_id =
199: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;
200: --
201: l_proc varchar2(72) := g_package||'pre_insert';
202: l_exists varchar2(1);
203: --

Line 207: If (pqh_ver_ins.g_wrkplc_vldtn_ver_id_i is not null) Then

203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: If (pqh_ver_ins.g_wrkplc_vldtn_ver_id_i is not null) Then
208: --
209: -- Verify registered primary key values not already in use
210: --
211: Open C_Sel2;

Line 227: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;

223: --
224: -- Use registered key values and clear globals
225: --
226: p_rec.wrkplc_vldtn_ver_id :=
227: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;
228: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i := null;
229: Else
230: --
231: -- No registerd key values, so select the next sequence number

Line 228: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i := null;

224: -- Use registered key values and clear globals
225: --
226: p_rec.wrkplc_vldtn_ver_id :=
227: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;
228: pqh_ver_ins.g_wrkplc_vldtn_ver_id_i := null;
229: Else
230: --
231: -- No registerd key values, so select the next sequence number
232: --

Line 365: pqh_ver_ins.pre_insert(p_rec);

361: hr_multi_message.end_validation_set;
362: --
363: -- Call the supporting pre-insert operation
364: --
365: pqh_ver_ins.pre_insert(p_rec);
366: --
367: -- Insert the row
368: --
369: pqh_ver_ins.insert_dml(p_rec);

Line 369: pqh_ver_ins.insert_dml(p_rec);

365: pqh_ver_ins.pre_insert(p_rec);
366: --
367: -- Insert the row
368: --
369: pqh_ver_ins.insert_dml(p_rec);
370: --
371: -- Call the supporting post-insert operation
372: --
373: pqh_ver_ins.post_insert

Line 373: pqh_ver_ins.post_insert

369: pqh_ver_ins.insert_dml(p_rec);
370: --
371: -- Call the supporting post-insert operation
372: --
373: pqh_ver_ins.post_insert
374: (p_effective_date
375: ,p_rec
376: );
377: --

Line 441: pqh_ver_ins.ins

437: --
438: -- Having converted the arguments into the pqh_ver_rec
439: -- plsql record structure we call the corresponding record business process.
440: --
441: pqh_ver_ins.ins
442: (p_effective_date
443: ,l_rec
444: );
445: --

Line 455: end pqh_ver_ins;

451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: End ins;
454: --
455: end pqh_ver_ins;