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_HAN_INS dependencies on HXC_HAN_INS

Line 1: Package Body hxc_han_ins as

1: Package Body hxc_han_ins as
2: /* $Header: hxchanrhi.pkb 120.2 2006/07/10 10:09:56 gsirigin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 31: hxc_han_ins.g_comp_notification_id_i := p_comp_notification_id;

27: if g_debug then
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
30: --
31: hxc_han_ins.g_comp_notification_id_i := p_comp_notification_id;
32: hxc_han_ins.g_object_version_number_i := p_object_version_number;
33: --
34: if g_debug then
35: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 32: hxc_han_ins.g_object_version_number_i := p_object_version_number;

28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
30: --
31: hxc_han_ins.g_comp_notification_id_i := p_comp_notification_id;
32: hxc_han_ins.g_object_version_number_i := p_object_version_number;
33: --
34: if g_debug then
35: hr_utility.set_location(' Leaving:'||l_proc, 20);
36: end if;

Line 199: hxc_han_ins.g_comp_notification_id_i

195: Cursor C_Sel2 is
196: Select null
197: from hxc_app_comp_notifications
198: where comp_notification_id =
199: hxc_han_ins.g_comp_notification_id_i
200: or object_version_number =
201: hxc_han_ins.g_object_version_number_i;
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';

Line 201: hxc_han_ins.g_object_version_number_i;

197: from hxc_app_comp_notifications
198: where comp_notification_id =
199: hxc_han_ins.g_comp_notification_id_i
200: or object_version_number =
201: hxc_han_ins.g_object_version_number_i;
202: --
203: l_proc varchar2(72) := g_package||'pre_insert';
204: l_exists varchar2(1);
205: --

Line 211: If (hxc_han_ins.g_comp_notification_id_i is not null or

207: if g_debug then
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: end if;
210: --
211: If (hxc_han_ins.g_comp_notification_id_i is not null or
212: hxc_han_ins.g_object_version_number_i is not null) Then
213: --
214: -- Verify registered primary key values not already in use
215: --

Line 212: hxc_han_ins.g_object_version_number_i is not null) Then

208: hr_utility.set_location('Entering:'||l_proc, 5);
209: end if;
210: --
211: If (hxc_han_ins.g_comp_notification_id_i is not null or
212: hxc_han_ins.g_object_version_number_i is not null) Then
213: --
214: -- Verify registered primary key values not already in use
215: --
216: Open C_Sel2;

Line 232: hxc_han_ins.g_comp_notification_id_i;

228: --
229: -- Use registered key values and clear globals
230: --
231: p_rec.comp_notification_id :=
232: hxc_han_ins.g_comp_notification_id_i;
233: hxc_han_ins.g_comp_notification_id_i := null;
234: p_rec.object_version_number :=
235: hxc_han_ins.g_object_version_number_i;
236: hxc_han_ins.g_object_version_number_i := null;

Line 233: hxc_han_ins.g_comp_notification_id_i := null;

229: -- Use registered key values and clear globals
230: --
231: p_rec.comp_notification_id :=
232: hxc_han_ins.g_comp_notification_id_i;
233: hxc_han_ins.g_comp_notification_id_i := null;
234: p_rec.object_version_number :=
235: hxc_han_ins.g_object_version_number_i;
236: hxc_han_ins.g_object_version_number_i := null;
237: Else

Line 235: hxc_han_ins.g_object_version_number_i;

231: p_rec.comp_notification_id :=
232: hxc_han_ins.g_comp_notification_id_i;
233: hxc_han_ins.g_comp_notification_id_i := null;
234: p_rec.object_version_number :=
235: hxc_han_ins.g_object_version_number_i;
236: hxc_han_ins.g_object_version_number_i := null;
237: Else
238: --
239: -- No registerd key values, so select the next sequence number

Line 236: hxc_han_ins.g_object_version_number_i := null;

232: hxc_han_ins.g_comp_notification_id_i;
233: hxc_han_ins.g_comp_notification_id_i := null;
234: p_rec.object_version_number :=
235: hxc_han_ins.g_object_version_number_i;
236: hxc_han_ins.g_object_version_number_i := null;
237: Else
238: --
239: -- No registerd key values, so select the next sequence number
240: --

Line 353: hxc_han_ins.pre_insert(p_rec);

349: hr_multi_message.end_validation_set;
350: --
351: -- Call the supporting pre-insert operation
352: --
353: hxc_han_ins.pre_insert(p_rec);
354: --
355: -- Insert the row
356: --
357: hxc_han_ins.insert_dml(p_rec);

Line 357: hxc_han_ins.insert_dml(p_rec);

353: hxc_han_ins.pre_insert(p_rec);
354: --
355: -- Insert the row
356: --
357: hxc_han_ins.insert_dml(p_rec);
358: --
359: -- Call the supporting post-insert operation
360: --
361: hxc_han_ins.post_insert

Line 361: hxc_han_ins.post_insert

357: hxc_han_ins.insert_dml(p_rec);
358: --
359: -- Call the supporting post-insert operation
360: --
361: hxc_han_ins.post_insert
362: (p_rec
363: );
364: --
365: -- Call to raise any errors on multi-message list

Line 409: hxc_han_ins.ins

405: --
406: -- Having converted the arguments into the hxc_han_rec
407: -- plsql record structure we call the corresponding record business process.
408: --
409: hxc_han_ins.ins
410: (l_rec
411: );
412: --
413: -- As the primary key argument(s)

Line 425: end hxc_han_ins;

421: hr_utility.set_location(' Leaving:'||l_proc, 10);
422: end if;
423: End ins;
424: --
425: end hxc_han_ins;