APPS.HXC_TKG_DEL dependencies on HXC_TKG_SHD

Line 51: (p_rec in hxc_tkg_shd.g_rec_type

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

Line 63: hxc_tkg_shd.g_api_dml := true; -- Set the api dml status

59: l_proc := g_package||'delete_dml';
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: end if;
62: --
63: hxc_tkg_shd.g_api_dml := true; -- Set the api dml status
64:
65: -- first of all delete any child rows
66:
67: delete from hxc_tk_group_query_criteria tkgqc

Line 81: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

77:
78: delete from hxc_tk_groups tkg
79: where tkg.tk_group_id = p_rec.tk_group_id;
80: --
81: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
82: --
83: if g_debug then
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: end if;

Line 90: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

86: --
87: Exception
88: When hr_api.child_integrity_violated then
89: -- Child integrity has been violated
90: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
91: hxc_tkg_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

Line 91: hxc_tkg_shd.constraint_error

87: Exception
88: When hr_api.child_integrity_violated then
89: -- Child integrity has been violated
90: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
91: hxc_tkg_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;

Line 94: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

90: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
91: hxc_tkg_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End delete_dml;
97: --
98: -- ----------------------------------------------------------------------------

Line 128: Procedure pre_delete(p_rec in hxc_tkg_shd.g_rec_type) is

124: -- Access Status:
125: -- Internal Row Handler Use Only.
126: --
127: -- ----------------------------------------------------------------------------
128: Procedure pre_delete(p_rec in hxc_tkg_shd.g_rec_type) is
129: --
130: l_proc varchar2(72) ;
131: --
132: Begin

Line 171: Procedure post_delete(p_rec in hxc_tkg_shd.g_rec_type) is

167: -- Access Status:
168: -- Internal Row Handler Use Only.
169: --
170: -- -----------------------------------------------------------------------------
171: Procedure post_delete(p_rec in hxc_tkg_shd.g_rec_type) is
172: --
173: l_proc varchar2(72) ;
174: --
175: Begin

Line 187: => hxc_tkg_shd.g_old_rec.tk_group_name

183: hxc_tkg_rkd.after_delete
184: (p_tk_group_id
185: => p_rec.tk_group_id
186: ,p_tk_group_name_o
187: => hxc_tkg_shd.g_old_rec.tk_group_name
188: ,p_tk_resource_id_o
189: => hxc_tkg_shd.g_old_rec.tk_resource_id
190: ,p_object_version_number_o
191: => hxc_tkg_shd.g_old_rec.object_version_number

Line 189: => hxc_tkg_shd.g_old_rec.tk_resource_id

185: => p_rec.tk_group_id
186: ,p_tk_group_name_o
187: => hxc_tkg_shd.g_old_rec.tk_group_name
188: ,p_tk_resource_id_o
189: => hxc_tkg_shd.g_old_rec.tk_resource_id
190: ,p_object_version_number_o
191: => hxc_tkg_shd.g_old_rec.object_version_number
192: );
193: --

Line 191: => hxc_tkg_shd.g_old_rec.object_version_number

187: => hxc_tkg_shd.g_old_rec.tk_group_name
188: ,p_tk_resource_id_o
189: => hxc_tkg_shd.g_old_rec.tk_resource_id
190: ,p_object_version_number_o
191: => hxc_tkg_shd.g_old_rec.object_version_number
192: );
193: --
194: exception
195: --

Line 213: (p_rec in hxc_tkg_shd.g_rec_type

209: -- ----------------------------------------------------------------------------
210: -- |---------------------------------< del >----------------------------------|
211: -- ----------------------------------------------------------------------------
212: Procedure del
213: (p_rec in hxc_tkg_shd.g_rec_type
214: ) is
215: --
216: l_proc varchar2(72) ;
217: --

Line 227: hxc_tkg_shd.lck

223: end if;
224: --
225: -- We must lock the row which we need to delete.
226: --
227: hxc_tkg_shd.lck
228: (p_rec.tk_group_id
229: ,p_rec.object_version_number
230: );
231: --

Line 258: l_rec hxc_tkg_shd.g_rec_type;

254: (p_tk_group_id in number
255: ,p_object_version_number in number
256: ) is
257: --
258: l_rec hxc_tkg_shd.g_rec_type;
259: l_proc varchar2(72) ;
260: --
261: Begin
262: g_debug :=hr_utility.debug_enabled;