APPS.HXC_TKGQ_INS dependencies on HXC_TKGQ_SHD

Line 48: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type

44: -- Internal Row Handler Use Only.
45: --
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml
48: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type
49: ) is
50: --
51: l_proc varchar2(72) ;
52: --

Line 61: hxc_tkgq_shd.g_api_dml := true; -- Set the api dml status

57: hr_utility.set_location('Entering:'||l_proc, 5);
58: end if;
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: hxc_tkgq_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: hxc_tk_group_queries
64: --
65: insert into hxc_tk_group_queries

Line 92: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

88: ,sysdate
89: ,fnd_global.login_id
90: );
91: --
92: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
93: --
94: if g_debug then
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: end if;

Line 100: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

96: end if;
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_tkgq_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated

Line 101: hxc_tkgq_shd.constraint_error

97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_tkgq_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

Line 105: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

101: hxc_tkgq_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_tkgq_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated

Line 106: hxc_tkgq_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_tkgq_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

Line 110: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

106: hxc_tkgq_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_tkgq_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

Line 111: hxc_tkgq_shd.constraint_error

107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.unique_integrity_violated Then
109: -- Unique integrity has been violated
110: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_tkgq_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;

Line 114: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

110: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_tkgq_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;
116: End insert_dml;
117: --
118: -- ----------------------------------------------------------------------------

Line 154: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type

150: -- Internal Row Handler Use Only.
151: --
152: -- ----------------------------------------------------------------------------
153: Procedure pre_insert
154: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type
155: ) is
156: --
157: l_proc varchar2(72) ;
158: --

Line 211: (p_rec in hxc_tkgq_shd.g_rec_type

207: -- Internal Row Handler Use Only.
208: --
209: -- ----------------------------------------------------------------------------
210: Procedure post_insert
211: (p_rec in hxc_tkgq_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) ;
215: --

Line 296: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type

292: -- Internal Development Use Only.
293: --
294: -- ----------------------------------------------------------------------------
295: Procedure ins
296: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72) ;
300: --

Line 377: l_rec hxc_tkgq_shd.g_rec_type;

373: ,p_tk_group_id in number
374: ,p_object_version_number out nocopy number
375: ) is
376: --
377: l_rec hxc_tkgq_shd.g_rec_type;
378: l_proc varchar2(72) ;
379: --
380: Begin
381: g_debug :=hr_utility.debug_enabled;

Line 391: hxc_tkgq_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- p_rec structure.
389: --
390: l_rec :=
391: hxc_tkgq_shd.convert_args
392: (null
393: ,p_tk_group_id
394: ,p_group_query_name
395: ,p_include_exclude