APPS.HXC_TKGQC_INS dependencies on HXC_TKGQC_INS

Line 1: Package Body hxc_tkgqc_ins as

1: Package Body hxc_tkgqc_ins as
2: /* $Header: hxctkgqcrhi.pkb 120.2 2005/09/23 05:26:07 rchennur noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_tkgqc_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 32: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i := p_tk_group_query_criteria_id;

28:
29: hr_utility.set_location('Entering:'||l_proc, 10);
30: end if;
31: --
32: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i := p_tk_group_query_criteria_id;
33: --
34: if g_debug then
35: hr_utility.set_location(' Leaving:'||l_proc, 20);
36: end if;

Line 196: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i;

192: Cursor C_Sel2 is
193: Select null
194: from hxc_tk_group_query_criteria
195: where tk_group_query_criteria_id =
196: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i;
197: --
198: l_proc varchar2(72) ;
199: l_exists varchar2(1);
200: --

Line 209: If (hxc_tkgqc_ins.g_tk_group_query_criteria_id_i is not null) Then

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

Line 229: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i;

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

Line 230: hxc_tkgqc_ins.g_tk_group_query_criteria_id_i := null;

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

Line 347: hxc_tkgqc_ins.pre_insert(p_rec);

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

Line 351: hxc_tkgqc_ins.insert_dml(p_rec);

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

Line 355: hxc_tkgqc_ins.post_insert

351: hxc_tkgqc_ins.insert_dml(p_rec);
352: --
353: -- Call the supporting post-insert operation
354: --
355: hxc_tkgqc_ins.post_insert
356: (p_rec
357: );
358: --
359: if g_debug then

Line 401: hxc_tkgqc_ins.ins

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

Line 416: end hxc_tkgqc_ins;

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