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.PER_OSE_DEL dependencies on PER_OSE_SHD

Line 104: (p_rec in per_ose_shd.g_rec_type

100: --
101: -- {End Of Comments}
102: -- ----------------------------------------------------------------------------
103: Procedure delete_dml
104: (p_rec in per_ose_shd.g_rec_type
105: ) is
106: --
107: l_proc varchar2(72) := g_package||'delete_dml';
108: --

Line 112: per_ose_shd.g_api_dml := true; -- Set the api dml status

108: --
109: Begin
110: hr_utility.set_location('Entering:'||l_proc, 5);
111: --
112: per_ose_shd.g_api_dml := true; -- Set the api dml status
113: --
114: -- Delete the per_org_structure_elements row.
115: --
116: delete from per_org_structure_elements

Line 119: per_ose_shd.g_api_dml := false; -- Unset the api dml status

115: --
116: delete from per_org_structure_elements
117: where org_structure_element_id = p_rec.org_structure_element_id;
118: --
119: per_ose_shd.g_api_dml := false; -- Unset the api dml status
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: Exception

Line 126: per_ose_shd.g_api_dml := false; -- Unset the api dml status

122: --
123: Exception
124: When hr_api.child_integrity_violated then
125: -- Child integrity has been violated
126: per_ose_shd.g_api_dml := false; -- Unset the api dml status
127: per_ose_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: per_ose_shd.g_api_dml := false; -- Unset the api dml status

Line 127: per_ose_shd.constraint_error

123: Exception
124: When hr_api.child_integrity_violated then
125: -- Child integrity has been violated
126: per_ose_shd.g_api_dml := false; -- Unset the api dml status
127: per_ose_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: per_ose_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;

Line 130: per_ose_shd.g_api_dml := false; -- Unset the api dml status

126: per_ose_shd.g_api_dml := false; -- Unset the api dml status
127: per_ose_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: per_ose_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;
132: End delete_dml;
133: --
134: -- ----------------------------------------------------------------------------

Line 166: Procedure pre_delete(p_rec in per_ose_shd.g_rec_type) is

162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_delete(p_rec in per_ose_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) := g_package||'pre_delete';
169: --
170: Begin

Line 209: Procedure post_delete(p_rec in per_ose_shd.g_rec_type

205: -- Internal Row Handler Use Only.
206: --
207: -- {End Of Comments}
208: -- -----------------------------------------------------------------------------
209: Procedure post_delete(p_rec in per_ose_shd.g_rec_type
210: -- ,p_exists_in_hierarchy in out nocopy varchar2 --bug 3205553
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_delete';

Line 227: => per_ose_shd.g_old_rec.business_group_id

223: per_ose_rkd.after_delete
224: (p_org_structure_element_id
225: => p_rec.org_structure_element_id
226: ,p_business_group_id_o
227: => per_ose_shd.g_old_rec.business_group_id
228: ,p_organization_id_parent_o
229: => per_ose_shd.g_old_rec.organization_id_parent
230: ,p_org_structure_version_id_o
231: => per_ose_shd.g_old_rec.org_structure_version_id

Line 229: => per_ose_shd.g_old_rec.organization_id_parent

225: => p_rec.org_structure_element_id
226: ,p_business_group_id_o
227: => per_ose_shd.g_old_rec.business_group_id
228: ,p_organization_id_parent_o
229: => per_ose_shd.g_old_rec.organization_id_parent
230: ,p_org_structure_version_id_o
231: => per_ose_shd.g_old_rec.org_structure_version_id
232: ,p_organization_id_child_o
233: => per_ose_shd.g_old_rec.organization_id_child

Line 231: => per_ose_shd.g_old_rec.org_structure_version_id

227: => per_ose_shd.g_old_rec.business_group_id
228: ,p_organization_id_parent_o
229: => per_ose_shd.g_old_rec.organization_id_parent
230: ,p_org_structure_version_id_o
231: => per_ose_shd.g_old_rec.org_structure_version_id
232: ,p_organization_id_child_o
233: => per_ose_shd.g_old_rec.organization_id_child
234: ,p_request_id_o
235: => per_ose_shd.g_old_rec.request_id

Line 233: => per_ose_shd.g_old_rec.organization_id_child

229: => per_ose_shd.g_old_rec.organization_id_parent
230: ,p_org_structure_version_id_o
231: => per_ose_shd.g_old_rec.org_structure_version_id
232: ,p_organization_id_child_o
233: => per_ose_shd.g_old_rec.organization_id_child
234: ,p_request_id_o
235: => per_ose_shd.g_old_rec.request_id
236: ,p_program_application_id_o
237: => per_ose_shd.g_old_rec.program_application_id

Line 235: => per_ose_shd.g_old_rec.request_id

231: => per_ose_shd.g_old_rec.org_structure_version_id
232: ,p_organization_id_child_o
233: => per_ose_shd.g_old_rec.organization_id_child
234: ,p_request_id_o
235: => per_ose_shd.g_old_rec.request_id
236: ,p_program_application_id_o
237: => per_ose_shd.g_old_rec.program_application_id
238: ,p_program_id_o
239: => per_ose_shd.g_old_rec.program_id

Line 237: => per_ose_shd.g_old_rec.program_application_id

233: => per_ose_shd.g_old_rec.organization_id_child
234: ,p_request_id_o
235: => per_ose_shd.g_old_rec.request_id
236: ,p_program_application_id_o
237: => per_ose_shd.g_old_rec.program_application_id
238: ,p_program_id_o
239: => per_ose_shd.g_old_rec.program_id
240: ,p_program_update_date_o
241: => per_ose_shd.g_old_rec.program_update_date

Line 239: => per_ose_shd.g_old_rec.program_id

235: => per_ose_shd.g_old_rec.request_id
236: ,p_program_application_id_o
237: => per_ose_shd.g_old_rec.program_application_id
238: ,p_program_id_o
239: => per_ose_shd.g_old_rec.program_id
240: ,p_program_update_date_o
241: => per_ose_shd.g_old_rec.program_update_date
242: ,p_object_version_number_o
243: => per_ose_shd.g_old_rec.object_version_number

Line 241: => per_ose_shd.g_old_rec.program_update_date

237: => per_ose_shd.g_old_rec.program_application_id
238: ,p_program_id_o
239: => per_ose_shd.g_old_rec.program_id
240: ,p_program_update_date_o
241: => per_ose_shd.g_old_rec.program_update_date
242: ,p_object_version_number_o
243: => per_ose_shd.g_old_rec.object_version_number
244: ,p_pos_control_enabled_flag_o
245: => per_ose_shd.g_old_rec.position_control_enabled_flag

Line 243: => per_ose_shd.g_old_rec.object_version_number

239: => per_ose_shd.g_old_rec.program_id
240: ,p_program_update_date_o
241: => per_ose_shd.g_old_rec.program_update_date
242: ,p_object_version_number_o
243: => per_ose_shd.g_old_rec.object_version_number
244: ,p_pos_control_enabled_flag_o
245: => per_ose_shd.g_old_rec.position_control_enabled_flag
246: );
247: --

Line 245: => per_ose_shd.g_old_rec.position_control_enabled_flag

241: => per_ose_shd.g_old_rec.program_update_date
242: ,p_object_version_number_o
243: => per_ose_shd.g_old_rec.object_version_number
244: ,p_pos_control_enabled_flag_o
245: => per_ose_shd.g_old_rec.position_control_enabled_flag
246: );
247: --
248: exception
249: --

Line 267: (p_rec in per_ose_shd.g_rec_type

263: -- ----------------------------------------------------------------------------
264: -- The parameter p_exists_in_hierarchy has been removed (bug fix 3205553)
265: --
266: Procedure del
267: (p_rec in per_ose_shd.g_rec_type
268: ,p_hr_installed in VARCHAR2
269: ,p_pa_installed in VARCHAR2
270: ,p_chk_children_exist in VARCHAR2
271: --,p_exists_in_hierarchy in out nocopy VARCHAR2 --bug 3205553

Line 281: per_ose_shd.lck

277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- We must lock the row which we need to delete.
280: --
281: per_ose_shd.lck
282: (p_rec.org_structure_element_id
283: ,p_rec.object_version_number
284: );
285: --

Line 289: (p_rec => per_ose_shd.g_old_rec

285: --
286: -- Call the supporting delete validate operation
287: --
288: per_ose_bus.delete_validate
289: (p_rec => per_ose_shd.g_old_rec
290: ,p_hr_installed => p_hr_installed
291: ,p_pa_installed => p_pa_installed
292: ,p_chk_children_exist => p_chk_children_exist
293: );

Line 306: (per_ose_shd.g_old_rec

302: --
303: -- Call the supporting post-delete operation
304: --
305: per_ose_del.post_delete
306: (per_ose_shd.g_old_rec
307: -- ,p_exists_in_hierarchy => p_exists_in_hierarchy --Bug 3205553
308: );
309: --
310: End del;

Line 326: l_rec per_ose_shd.g_rec_type;

322: ,p_chk_children_exist in VARCHAR2
323: --,p_exists_in_hierarchy in out nocopy VARCHAR2 --bug 3205553
324: ) is
325: --
326: l_rec per_ose_shd.g_rec_type;
327: l_proc varchar2(72) := g_package||'del';
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);