APPS.HXC_TKGQC_DEL dependencies on HXC_TKGQC_SHD

Line 51: (p_rec in hxc_tkgqc_shd.g_rec_type

47: -- Internal Row Handler Use Only.
48: --
49: -- ----------------------------------------------------------------------------
50: Procedure delete_dml
51: (p_rec in hxc_tkgqc_shd.g_rec_type
52: ) is
53: --
54: l_proc varchar2(72) ;
55: --

Line 64: hxc_tkgqc_shd.g_api_dml := true; -- Set the api dml status

60:
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: end if;
63: --
64: hxc_tkgqc_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Delete the hxc_tk_group_query_criteria row.
67: --
68: delete from hxc_tk_group_query_criteria

Line 71: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

67: --
68: delete from hxc_tk_group_query_criteria
69: where tk_group_query_criteria_id = p_rec.tk_group_query_criteria_id;
70: --
71: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
72: --
73: if g_debug then
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;

Line 80: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

76: --
77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_tkgqc_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

Line 81: hxc_tkgqc_shd.constraint_error

77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_tkgqc_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;

Line 84: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status

80: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
81: hxc_tkgqc_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: hxc_tkgqc_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;
86: End delete_dml;
87: --
88: -- ----------------------------------------------------------------------------

Line 118: Procedure pre_delete(p_rec in hxc_tkgqc_shd.g_rec_type) is

114: -- Access Status:
115: -- Internal Row Handler Use Only.
116: --
117: -- ----------------------------------------------------------------------------
118: Procedure pre_delete(p_rec in hxc_tkgqc_shd.g_rec_type) is
119: --
120: l_proc varchar2(72) ;
121: --
122: Begin

Line 162: Procedure post_delete(p_rec in hxc_tkgqc_shd.g_rec_type) is

158: -- Access Status:
159: -- Internal Row Handler Use Only.
160: --
161: -- -----------------------------------------------------------------------------
162: Procedure post_delete(p_rec in hxc_tkgqc_shd.g_rec_type) is
163: --
164: l_proc varchar2(72) ;
165: --
166: Begin

Line 179: => hxc_tkgqc_shd.g_old_rec.tk_group_query_id

175: hxc_tkgqc_rkd.after_delete
176: (p_tk_group_query_criteria_id
177: => p_rec.tk_group_query_criteria_id
178: ,p_tk_group_query_id_o
179: => hxc_tkgqc_shd.g_old_rec.tk_group_query_id
180: ,p_criteria_type_o
181: => hxc_tkgqc_shd.g_old_rec.criteria_type
182: ,p_criteria_id_o
183: => hxc_tkgqc_shd.g_old_rec.criteria_id

Line 181: => hxc_tkgqc_shd.g_old_rec.criteria_type

177: => p_rec.tk_group_query_criteria_id
178: ,p_tk_group_query_id_o
179: => hxc_tkgqc_shd.g_old_rec.tk_group_query_id
180: ,p_criteria_type_o
181: => hxc_tkgqc_shd.g_old_rec.criteria_type
182: ,p_criteria_id_o
183: => hxc_tkgqc_shd.g_old_rec.criteria_id
184: ,p_object_version_number_o
185: => hxc_tkgqc_shd.g_old_rec.object_version_number

Line 183: => hxc_tkgqc_shd.g_old_rec.criteria_id

179: => hxc_tkgqc_shd.g_old_rec.tk_group_query_id
180: ,p_criteria_type_o
181: => hxc_tkgqc_shd.g_old_rec.criteria_type
182: ,p_criteria_id_o
183: => hxc_tkgqc_shd.g_old_rec.criteria_id
184: ,p_object_version_number_o
185: => hxc_tkgqc_shd.g_old_rec.object_version_number
186: );
187: --

Line 185: => hxc_tkgqc_shd.g_old_rec.object_version_number

181: => hxc_tkgqc_shd.g_old_rec.criteria_type
182: ,p_criteria_id_o
183: => hxc_tkgqc_shd.g_old_rec.criteria_id
184: ,p_object_version_number_o
185: => hxc_tkgqc_shd.g_old_rec.object_version_number
186: );
187: --
188: exception
189: --

Line 207: (p_rec in hxc_tkgqc_shd.g_rec_type

203: -- ----------------------------------------------------------------------------
204: -- |---------------------------------< del >----------------------------------|
205: -- ----------------------------------------------------------------------------
206: Procedure del
207: (p_rec in hxc_tkgqc_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) ;
211: --

Line 222: hxc_tkgqc_shd.lck

218: end if;
219: --
220: -- We must lock the row which we need to delete.
221: --
222: hxc_tkgqc_shd.lck
223: (p_rec.tk_group_query_criteria_id
224: ,p_rec.object_version_number
225: );
226: --

Line 253: l_rec hxc_tkgqc_shd.g_rec_type;

249: (p_tk_group_query_criteria_id in number
250: ,p_object_version_number in number
251: ) is
252: --
253: l_rec hxc_tkgqc_shd.g_rec_type;
254: l_proc varchar2(72) ;
255: --
256: Begin
257: g_debug :=hr_utility.debug_enabled;