APPS.HXC_LCK_INS dependencies on HXC_LCK_INS

Line 1: Package Body hxc_lck_ins as

1: Package Body hxc_lck_ins as
2: /* $Header: hxclocktypesrhi.pkb 120.2 2005/09/23 08:08:21 nissharm noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_lck_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 33: hxc_lck_ins.g_locker_type_id_i := p_locker_type_id;

29: l_proc := g_package||'set_base_key_value';
30: hr_utility.set_location('Entering:'||l_proc, 10);
31: end if;
32: --
33: hxc_lck_ins.g_locker_type_id_i := p_locker_type_id;
34: --
35: if g_debug then
36: hr_utility.set_location(' Leaving:'||l_proc, 20);
37: end if;

Line 197: hxc_lck_ins.g_locker_type_id_i;

193: Cursor C_Sel2 is
194: Select null
195: from hxc_locker_types
196: where locker_type_id =
197: hxc_lck_ins.g_locker_type_id_i;
198: --
199: l_proc varchar2(72);
200: l_exists varchar2(1);
201: --

Line 210: If (hxc_lck_ins.g_locker_type_id_i is not null) Then

206: l_proc := g_package||'pre_insert';
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: end if;
209: --
210: If (hxc_lck_ins.g_locker_type_id_i is not null) Then
211: --
212: -- Verify registered primary key values not already in use
213: --
214: Open C_Sel2;

Line 230: hxc_lck_ins.g_locker_type_id_i;

226: --
227: -- Use registered key values and clear globals
228: --
229: p_rec.locker_type_id :=
230: hxc_lck_ins.g_locker_type_id_i;
231: hxc_lck_ins.g_locker_type_id_i := null;
232: Else
233: --
234: -- No registerd key values, so select the next sequence number

Line 231: hxc_lck_ins.g_locker_type_id_i := null;

227: -- Use registered key values and clear globals
228: --
229: p_rec.locker_type_id :=
230: hxc_lck_ins.g_locker_type_id_i;
231: hxc_lck_ins.g_locker_type_id_i := null;
232: Else
233: --
234: -- No registerd key values, so select the next sequence number
235: --

Line 348: hxc_lck_ins.pre_insert(p_rec);

344: hr_multi_message.end_validation_set;
345: --
346: -- Call the supporting pre-insert operation
347: --
348: hxc_lck_ins.pre_insert(p_rec);
349: --
350: -- Insert the row
351: --
352: hxc_lck_ins.insert_dml(p_rec);

Line 352: hxc_lck_ins.insert_dml(p_rec);

348: hxc_lck_ins.pre_insert(p_rec);
349: --
350: -- Insert the row
351: --
352: hxc_lck_ins.insert_dml(p_rec);
353: --
354: -- Call the supporting post-insert operation
355: --
356: hxc_lck_ins.post_insert

Line 356: hxc_lck_ins.post_insert

352: hxc_lck_ins.insert_dml(p_rec);
353: --
354: -- Call the supporting post-insert operation
355: --
356: hxc_lck_ins.post_insert
357: (p_rec
358: );
359: --
360: -- Call to raise any errors on multi-message list

Line 401: hxc_lck_ins.ins

397: --
398: -- Having converted the arguments into the hxc_lck_rec
399: -- plsql record structure we call the corresponding record business process.
400: --
401: hxc_lck_ins.ins
402: (l_rec
403: );
404: --
405: -- As the primary key argument(s)

Line 416: end hxc_lck_ins;

412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: end if;
414: End ins;
415: --
416: end hxc_lck_ins;