APPS.HXC_HAT_INS dependencies on HXC_HAT_INS

Line 1: Package Body hxc_hat_ins as

1: Package Body hxc_hat_ins as
2: /* $Header: hxchatrhi.pkb 120.2 2005/09/23 10:41:13 sechandr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hat_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_hat_ins.g_alias_type_id_i := p_alias_type_id;

27: l_proc := g_package||'set_base_key_value';
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: end if;
30: --
31: hxc_hat_ins.g_alias_type_id_i := p_alias_type_id;
32: --
33: if g_debug then
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: end if;

Line 195: hxc_hat_ins.g_alias_type_id_i;

191: Cursor C_Sel2 is
192: Select null
193: from hxc_alias_types
194: where alias_type_id =
195: hxc_hat_ins.g_alias_type_id_i;
196: --
197: l_proc varchar2(72);
198: l_exists varchar2(1);
199: --

Line 206: /* If (hxc_hat_ins.g_alias_type_id_i is not null) Then

202: l_proc:= g_package||'pre_insert';
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: end if;
205: --
206: /* If (hxc_hat_ins.g_alias_type_id_i is not null) Then
207: --
208: -- Verify registered primary key values not already in use
209: --
210: Open C_Sel2;

Line 226: hxc_hat_ins.g_alias_type_id_i;

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

Line 227: hxc_hat_ins.g_alias_type_id_i := null;

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

Line 343: hxc_hat_ins.pre_insert(p_rec);

339: hr_multi_message.end_validation_set;
340: --
341: -- Call the supporting pre-insert operation
342: --
343: hxc_hat_ins.pre_insert(p_rec);
344: --
345: -- Insert the row
346: --
347: hxc_hat_ins.insert_dml(p_rec);

Line 347: hxc_hat_ins.insert_dml(p_rec);

343: hxc_hat_ins.pre_insert(p_rec);
344: --
345: -- Insert the row
346: --
347: hxc_hat_ins.insert_dml(p_rec);
348: --
349: -- Call the supporting post-insert operation
350: --
351: hxc_hat_ins.post_insert

Line 351: hxc_hat_ins.post_insert

347: hxc_hat_ins.insert_dml(p_rec);
348: --
349: -- Call the supporting post-insert operation
350: --
351: hxc_hat_ins.post_insert
352: (p_rec
353: );
354: --
355: -- Call to raise any errors on multi-message list

Line 397: hxc_hat_ins.ins

393: --
394: -- Having converted the arguments into the hxc_hat_rec
395: -- plsql record structure we call the corresponding record business process.
396: --
397: hxc_hat_ins.ins
398: (l_rec
399: );
400: --
401: -- As the primary key argument(s)

Line 412: end hxc_hat_ins;

408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: end if;
410: End ins;
411: --
412: end hxc_hat_ins;