APPS.HXC_RTR_DEL dependencies on HXC_RTR_SHD

Line 54: (p_rec in hxc_rtr_shd.g_rec_type

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

Line 67: hxc_rtr_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_rtr_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- First of all delete any child rows
70: --
71: delete from hxc_retrieval_rule_comps

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

75: --
76: delete from hxc_retrieval_rules
77: where retrieval_rule_id = p_rec.retrieval_rule_id;
78: --
79: hxc_rtr_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_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status
89: hxc_rtr_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status

Line 89: hxc_rtr_shd.constraint_error

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

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

88: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status
89: hxc_rtr_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: hxc_rtr_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_rtr_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_rtr_shd.g_rec_type) is
129: --
130: l_proc varchar2(72);
131: --
132: Begin

Line 175: Procedure post_delete(p_rec in hxc_rtr_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_rtr_shd.g_rec_type) is
176: --
177: l_proc varchar2(72);
178: --
179: Begin

Line 192: => hxc_rtr_shd.g_old_rec.retrieval_process_id

188: hxc_rtr_rkd.after_delete
189: (p_retrieval_rule_id
190: => p_rec.retrieval_rule_id
191: ,p_retrieval_process_id_o
192: => hxc_rtr_shd.g_old_rec.retrieval_process_id
193: ,p_object_version_number_o
194: => hxc_rtr_shd.g_old_rec.object_version_number
195: ,p_name_o
196: => hxc_rtr_shd.g_old_rec.name

Line 194: => hxc_rtr_shd.g_old_rec.object_version_number

190: => p_rec.retrieval_rule_id
191: ,p_retrieval_process_id_o
192: => hxc_rtr_shd.g_old_rec.retrieval_process_id
193: ,p_object_version_number_o
194: => hxc_rtr_shd.g_old_rec.object_version_number
195: ,p_name_o
196: => hxc_rtr_shd.g_old_rec.name
197: );
198: --

Line 196: => hxc_rtr_shd.g_old_rec.name

192: => hxc_rtr_shd.g_old_rec.retrieval_process_id
193: ,p_object_version_number_o
194: => hxc_rtr_shd.g_old_rec.object_version_number
195: ,p_name_o
196: => hxc_rtr_shd.g_old_rec.name
197: );
198: --
199: exception
200: --

Line 218: (p_rec in hxc_rtr_shd.g_rec_type

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

Line 233: hxc_rtr_shd.lck

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

Line 264: l_rec hxc_rtr_shd.g_rec_type;

260: (p_retrieval_rule_id in number
261: ,p_object_version_number in number
262: ) is
263: --
264: l_rec hxc_rtr_shd.g_rec_type;
265: l_proc varchar2(72);
266: --
267: Begin
268: g_debug := hr_utility.debug_enabled;