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

Line 1: Package Body hxc_lkr_ins as

1: Package Body hxc_lkr_ins as
2: /* $Header: hxclockrulesrhi.pkb 120.2 2005/09/23 07:58:43 nissharm noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_lkr_ins.'; -- Global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11: --
12: -- The following global variables are only to be used by

Line 35: hxc_lkr_ins.g_locker_type_owner_id_i := p_locker_type_owner_id;

31: l_proc := g_package||'set_base_key_value';
32: hr_utility.set_location('Entering:'||l_proc, 10);
33: end if;
34: --
35: hxc_lkr_ins.g_locker_type_owner_id_i := p_locker_type_owner_id;
36: hxc_lkr_ins.g_locker_type_requestor_id_i := p_locker_type_requestor_id;
37: --
38: if g_debug then
39: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 36: hxc_lkr_ins.g_locker_type_requestor_id_i := p_locker_type_requestor_id;

32: hr_utility.set_location('Entering:'||l_proc, 10);
33: end if;
34: --
35: hxc_lkr_ins.g_locker_type_owner_id_i := p_locker_type_owner_id;
36: hxc_lkr_ins.g_locker_type_requestor_id_i := p_locker_type_requestor_id;
37: --
38: if g_debug then
39: hr_utility.set_location(' Leaving:'||l_proc, 20);
40: end if;

Line 200: hxc_lkr_ins.g_locker_type_owner_id_i

196: Cursor C_Sel2 is
197: Select null
198: from hxc_locking_rules
199: where locker_type_owner_id =
200: hxc_lkr_ins.g_locker_type_owner_id_i
201: or locker_type_requestor_id =
202: hxc_lkr_ins.g_locker_type_requestor_id_i;
203: --
204: l_proc varchar2(72);

Line 202: hxc_lkr_ins.g_locker_type_requestor_id_i;

198: from hxc_locking_rules
199: where locker_type_owner_id =
200: hxc_lkr_ins.g_locker_type_owner_id_i
201: or locker_type_requestor_id =
202: hxc_lkr_ins.g_locker_type_requestor_id_i;
203: --
204: l_proc varchar2(72);
205: l_exists varchar2(1);
206: --

Line 216: If (hxc_lkr_ins.g_locker_type_owner_id_i is not null or

212: if g_debug then
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: end if;
215: --
216: If (hxc_lkr_ins.g_locker_type_owner_id_i is not null or
217: hxc_lkr_ins.g_locker_type_requestor_id_i is not null) Then
218: --
219: -- Verify registered primary key values not already in use
220: --

Line 217: hxc_lkr_ins.g_locker_type_requestor_id_i is not null) Then

213: hr_utility.set_location('Entering:'||l_proc, 5);
214: end if;
215: --
216: If (hxc_lkr_ins.g_locker_type_owner_id_i is not null or
217: hxc_lkr_ins.g_locker_type_requestor_id_i is not null) Then
218: --
219: -- Verify registered primary key values not already in use
220: --
221: Open C_Sel2;

Line 237: hxc_lkr_ins.g_locker_type_owner_id_i;

233: --
234: -- Use registered key values and clear globals
235: --
236: p_rec.locker_type_owner_id :=
237: hxc_lkr_ins.g_locker_type_owner_id_i;
238: hxc_lkr_ins.g_locker_type_owner_id_i := null;
239: p_rec.locker_type_requestor_id :=
240: hxc_lkr_ins.g_locker_type_requestor_id_i;
241: hxc_lkr_ins.g_locker_type_requestor_id_i := null;

Line 238: hxc_lkr_ins.g_locker_type_owner_id_i := null;

234: -- Use registered key values and clear globals
235: --
236: p_rec.locker_type_owner_id :=
237: hxc_lkr_ins.g_locker_type_owner_id_i;
238: hxc_lkr_ins.g_locker_type_owner_id_i := null;
239: p_rec.locker_type_requestor_id :=
240: hxc_lkr_ins.g_locker_type_requestor_id_i;
241: hxc_lkr_ins.g_locker_type_requestor_id_i := null;
242: Else

Line 240: hxc_lkr_ins.g_locker_type_requestor_id_i;

236: p_rec.locker_type_owner_id :=
237: hxc_lkr_ins.g_locker_type_owner_id_i;
238: hxc_lkr_ins.g_locker_type_owner_id_i := null;
239: p_rec.locker_type_requestor_id :=
240: hxc_lkr_ins.g_locker_type_requestor_id_i;
241: hxc_lkr_ins.g_locker_type_requestor_id_i := null;
242: Else
243: --
244: -- No registerd key values, so select the next sequence number

Line 241: hxc_lkr_ins.g_locker_type_requestor_id_i := null;

237: hxc_lkr_ins.g_locker_type_owner_id_i;
238: hxc_lkr_ins.g_locker_type_owner_id_i := null;
239: p_rec.locker_type_requestor_id :=
240: hxc_lkr_ins.g_locker_type_requestor_id_i;
241: hxc_lkr_ins.g_locker_type_requestor_id_i := null;
242: Else
243: --
244: -- No registerd key values, so select the next sequence number
245: --

Line 362: hxc_lkr_ins.pre_insert(p_rec);

358: hr_multi_message.end_validation_set;
359: --
360: -- Call the supporting pre-insert operation
361: --
362: hxc_lkr_ins.pre_insert(p_rec);
363: --
364: -- Insert the row
365: --
366: hxc_lkr_ins.insert_dml(p_rec);

Line 366: hxc_lkr_ins.insert_dml(p_rec);

362: hxc_lkr_ins.pre_insert(p_rec);
363: --
364: -- Insert the row
365: --
366: hxc_lkr_ins.insert_dml(p_rec);
367: --
368: -- Call the supporting post-insert operation
369: --
370: hxc_lkr_ins.post_insert

Line 370: hxc_lkr_ins.post_insert

366: hxc_lkr_ins.insert_dml(p_rec);
367: --
368: -- Call the supporting post-insert operation
369: --
370: hxc_lkr_ins.post_insert
371: (p_rec
372: );
373: --
374: -- Call to raise any errors on multi-message list

Line 415: hxc_lkr_ins.ins

411: --
412: -- Having converted the arguments into the hxc_lkr_rec
413: -- plsql record structure we call the corresponding record business process.
414: --
415: hxc_lkr_ins.ins
416: (l_rec
417: );
418: --
419: -- As the primary key argument(s)

Line 431: end hxc_lkr_ins;

427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: end if;
429: End ins;
430: --
431: end hxc_lkr_ins;