APPS.HXC_HTC_DEL dependencies on HXC_HTC_SHD

Line 54: (p_rec in hxc_htc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure delete_dml
54: (p_rec in hxc_htc_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72);
58: --

Line 67: hxc_htc_shd.g_api_dml := true; -- Set the api dml status

63: l_proc := g_package||'delete_dml';
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: end if;
66: --
67: hxc_htc_shd.g_api_dml := true; -- Set the api dml status
68:
69: -- First of all delete any child rows
70:
71: delete from hxc_time_category_comps

Line 79: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

75:
76: delete from hxc_time_categories
77: where time_category_id = p_rec.time_category_id;
78:
79: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
80:
81: if g_debug then
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: end if;

Line 88: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 89: hxc_htc_shd.constraint_error

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

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

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

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

124: -- Internal Row Handler Use Only.
125: --
126: -- {End Of Comments}
127: -- ----------------------------------------------------------------------------
128: Procedure pre_delete(p_rec in hxc_htc_shd.g_rec_type) is
129: --
130: l_proc varchar2(72);
131: --
132: Begin

Line 175: Procedure post_delete(p_rec in hxc_htc_shd.g_rec_type) is

171: -- Internal Row Handler Use Only.
172: --
173: -- {End Of Comments}
174: -- -----------------------------------------------------------------------------
175: Procedure post_delete(p_rec in hxc_htc_shd.g_rec_type) is
176: --
177: l_proc varchar2(72);
178: --
179: Begin

Line 192: => hxc_htc_shd.g_old_rec.time_category_name

188: hxc_htc_rkd.after_delete
189: (p_time_category_id
190: => p_rec.time_category_id
191: ,p_time_category_name_o
192: => hxc_htc_shd.g_old_rec.time_category_name
193: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
194: ,p_description_o => hxc_htc_shd.g_old_rec.description
195: ,p_display_o => hxc_htc_shd.g_old_rec.display
196: ,p_object_version_number_o

Line 193: ,p_operator_o => hxc_htc_shd.g_old_rec.operator

189: (p_time_category_id
190: => p_rec.time_category_id
191: ,p_time_category_name_o
192: => hxc_htc_shd.g_old_rec.time_category_name
193: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
194: ,p_description_o => hxc_htc_shd.g_old_rec.description
195: ,p_display_o => hxc_htc_shd.g_old_rec.display
196: ,p_object_version_number_o
197: => hxc_htc_shd.g_old_rec.object_version_number

Line 194: ,p_description_o => hxc_htc_shd.g_old_rec.description

190: => p_rec.time_category_id
191: ,p_time_category_name_o
192: => hxc_htc_shd.g_old_rec.time_category_name
193: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
194: ,p_description_o => hxc_htc_shd.g_old_rec.description
195: ,p_display_o => hxc_htc_shd.g_old_rec.display
196: ,p_object_version_number_o
197: => hxc_htc_shd.g_old_rec.object_version_number
198: );

Line 195: ,p_display_o => hxc_htc_shd.g_old_rec.display

191: ,p_time_category_name_o
192: => hxc_htc_shd.g_old_rec.time_category_name
193: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
194: ,p_description_o => hxc_htc_shd.g_old_rec.description
195: ,p_display_o => hxc_htc_shd.g_old_rec.display
196: ,p_object_version_number_o
197: => hxc_htc_shd.g_old_rec.object_version_number
198: );
199:

Line 197: => hxc_htc_shd.g_old_rec.object_version_number

193: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
194: ,p_description_o => hxc_htc_shd.g_old_rec.description
195: ,p_display_o => hxc_htc_shd.g_old_rec.display
196: ,p_object_version_number_o
197: => hxc_htc_shd.g_old_rec.object_version_number
198: );
199:
200: exception
201: --

Line 219: (p_rec in hxc_htc_shd.g_rec_type

215: -- ----------------------------------------------------------------------------
216: -- |---------------------------------< del >----------------------------------|
217: -- ----------------------------------------------------------------------------
218: Procedure del
219: (p_rec in hxc_htc_shd.g_rec_type
220: ) is
221: --
222: l_proc varchar2(72);
223: --

Line 234: hxc_htc_shd.lck

230: end if;
231: --
232: -- We must lock the row which we need to delete.
233: --
234: hxc_htc_shd.lck
235: (p_rec.time_category_id
236: ,p_rec.object_version_number
237: );
238: --

Line 266: l_rec hxc_htc_shd.g_rec_type;

262: ,p_time_category_name in varchar2
263: ,p_object_version_number in number
264: ) is
265: --
266: l_rec hxc_htc_shd.g_rec_type;
267: l_proc varchar2(72);
268: --
269: Begin
270: g_debug := hr_utility.debug_enabled;