eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_HAS_DEL dependencies on HXC_HAS_SHD

Line 53: (p_rec in hxc_has_shd.g_rec_type

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

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

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

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

75: --
76: delete from hxc_approval_styles
77: where approval_style_id = p_rec.approval_style_id;
78: --
79: hxc_has_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_has_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_has_shd.g_api_dml := false; -- Unset the api dml status
89: hxc_has_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

Line 89: hxc_has_shd.constraint_error

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

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

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

Line 173: Procedure post_delete(p_rec in hxc_has_shd.g_rec_type) is

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

Line 188: => hxc_has_shd.g_old_rec.object_version_number

184: hxc_has_rkd.after_delete
185: (p_approval_style_id
186: => p_rec.approval_style_id
187: ,p_object_version_number_o
188: => hxc_has_shd.g_old_rec.object_version_number
189: ,p_name_o
190: => hxc_has_shd.g_old_rec.name
191: ,p_business_group_id_o
192: => hxc_has_shd.g_old_rec.business_group_id

Line 190: => hxc_has_shd.g_old_rec.name

186: => p_rec.approval_style_id
187: ,p_object_version_number_o
188: => hxc_has_shd.g_old_rec.object_version_number
189: ,p_name_o
190: => hxc_has_shd.g_old_rec.name
191: ,p_business_group_id_o
192: => hxc_has_shd.g_old_rec.business_group_id
193: ,p_legislation_code_o
194: => hxc_has_shd.g_old_rec.legislation_code

Line 192: => hxc_has_shd.g_old_rec.business_group_id

188: => hxc_has_shd.g_old_rec.object_version_number
189: ,p_name_o
190: => hxc_has_shd.g_old_rec.name
191: ,p_business_group_id_o
192: => hxc_has_shd.g_old_rec.business_group_id
193: ,p_legislation_code_o
194: => hxc_has_shd.g_old_rec.legislation_code
195: ,p_description_o
196: => hxc_has_shd.g_old_rec.description

Line 194: => hxc_has_shd.g_old_rec.legislation_code

190: => hxc_has_shd.g_old_rec.name
191: ,p_business_group_id_o
192: => hxc_has_shd.g_old_rec.business_group_id
193: ,p_legislation_code_o
194: => hxc_has_shd.g_old_rec.legislation_code
195: ,p_description_o
196: => hxc_has_shd.g_old_rec.description
197: ,p_run_recipient_extensions_o
198: => hxc_has_shd.g_old_rec.run_recipient_extensions

Line 196: => hxc_has_shd.g_old_rec.description

192: => hxc_has_shd.g_old_rec.business_group_id
193: ,p_legislation_code_o
194: => hxc_has_shd.g_old_rec.legislation_code
195: ,p_description_o
196: => hxc_has_shd.g_old_rec.description
197: ,p_run_recipient_extensions_o
198: => hxc_has_shd.g_old_rec.run_recipient_extensions
199: ,p_admin_role_o
200: => hxc_has_shd.g_old_rec.admin_role

Line 198: => hxc_has_shd.g_old_rec.run_recipient_extensions

194: => hxc_has_shd.g_old_rec.legislation_code
195: ,p_description_o
196: => hxc_has_shd.g_old_rec.description
197: ,p_run_recipient_extensions_o
198: => hxc_has_shd.g_old_rec.run_recipient_extensions
199: ,p_admin_role_o
200: => hxc_has_shd.g_old_rec.admin_role
201: ,p_error_admin_role_o
202: => hxc_has_shd.g_old_rec.error_admin_role

Line 200: => hxc_has_shd.g_old_rec.admin_role

196: => hxc_has_shd.g_old_rec.description
197: ,p_run_recipient_extensions_o
198: => hxc_has_shd.g_old_rec.run_recipient_extensions
199: ,p_admin_role_o
200: => hxc_has_shd.g_old_rec.admin_role
201: ,p_error_admin_role_o
202: => hxc_has_shd.g_old_rec.error_admin_role
203: );
204: --

Line 202: => hxc_has_shd.g_old_rec.error_admin_role

198: => hxc_has_shd.g_old_rec.run_recipient_extensions
199: ,p_admin_role_o
200: => hxc_has_shd.g_old_rec.admin_role
201: ,p_error_admin_role_o
202: => hxc_has_shd.g_old_rec.error_admin_role
203: );
204: --
205: exception
206: --

Line 224: (p_rec in hxc_has_shd.g_rec_type

220: -- ----------------------------------------------------------------------------
221: -- |---------------------------------< del >----------------------------------|
222: -- ----------------------------------------------------------------------------
223: Procedure del
224: (p_rec in hxc_has_shd.g_rec_type
225: ) is
226: --
227: l_proc varchar2(72);
228: --

Line 238: hxc_has_shd.lck

234: end if;
235: --
236: -- We must lock the row which we need to delete.
237: --
238: hxc_has_shd.lck
239: (p_rec.approval_style_id
240: ,p_rec.object_version_number
241: );
242: --

Line 269: l_rec hxc_has_shd.g_rec_type;

265: (p_approval_style_id in number
266: ,p_object_version_number in number
267: ) is
268: --
269: l_rec hxc_has_shd.g_rec_type;
270: l_proc varchar2(72);
271: --
272: Begin
273: g_debug:=hr_utility.debug_enabled;