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_UPD dependencies on PER_OSE_SHD

Line 55: (p_rec in out nocopy per_ose_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_ose_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

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

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_ose_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_org_structure_elements Row
69: --
70: update per_org_structure_elements

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

79: ,object_version_number = p_rec.object_version_number
80: ,position_control_enabled_flag = p_rec.position_control_enabled_flag
81: where org_structure_element_id = p_rec.org_structure_element_id;
82: --
83: per_ose_shd.g_api_dml := false; -- Unset the api dml status
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception

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

86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: per_ose_shd.g_api_dml := false; -- Unset the api dml status
91: per_ose_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated

Line 91: per_ose_shd.constraint_error

87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: per_ose_shd.g_api_dml := false; -- Unset the api dml status
91: per_ose_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: per_ose_shd.g_api_dml := false; -- Unset the api dml status

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

91: per_ose_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: per_ose_shd.g_api_dml := false; -- Unset the api dml status
96: per_ose_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated

Line 96: per_ose_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.parent_integrity_violated Then
94: -- Parent integrity has been violated
95: per_ose_shd.g_api_dml := false; -- Unset the api dml status
96: per_ose_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: per_ose_shd.g_api_dml := false; -- Unset the api dml status

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

96: per_ose_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: per_ose_shd.g_api_dml := false; -- Unset the api dml status
101: per_ose_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: per_ose_shd.g_api_dml := false; -- Unset the api dml status

Line 101: per_ose_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: per_ose_shd.g_api_dml := false; -- Unset the api dml status
101: per_ose_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: per_ose_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;

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

100: per_ose_shd.g_api_dml := false; -- Unset the api dml status
101: per_ose_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When Others Then
104: per_ose_shd.g_api_dml := false; -- Unset the api dml status
105: Raise;
106: End update_dml;
107: --
108: -- ----------------------------------------------------------------------------

Line 141: (p_rec in per_ose_shd.g_rec_type

137: --
138: -- {End Of Comments}
139: -- ----------------------------------------------------------------------------
140: Procedure pre_update
141: (p_rec in per_ose_shd.g_rec_type
142: ) is
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --

Line 185: (p_rec in per_ose_shd.g_rec_type

181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure post_update
185: (p_rec in per_ose_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --

Line 214: => per_ose_shd.g_old_rec.business_group_id

210: => p_rec.object_version_number
211: ,p_pos_control_enabled_flag
212: => p_rec.position_control_enabled_flag
213: ,p_business_group_id_o
214: => per_ose_shd.g_old_rec.business_group_id
215: ,p_organization_id_parent_o
216: => per_ose_shd.g_old_rec.organization_id_parent
217: ,p_org_structure_version_id_o
218: => per_ose_shd.g_old_rec.org_structure_version_id

Line 216: => per_ose_shd.g_old_rec.organization_id_parent

212: => p_rec.position_control_enabled_flag
213: ,p_business_group_id_o
214: => per_ose_shd.g_old_rec.business_group_id
215: ,p_organization_id_parent_o
216: => per_ose_shd.g_old_rec.organization_id_parent
217: ,p_org_structure_version_id_o
218: => per_ose_shd.g_old_rec.org_structure_version_id
219: ,p_organization_id_child_o
220: => per_ose_shd.g_old_rec.organization_id_child

Line 218: => per_ose_shd.g_old_rec.org_structure_version_id

214: => per_ose_shd.g_old_rec.business_group_id
215: ,p_organization_id_parent_o
216: => per_ose_shd.g_old_rec.organization_id_parent
217: ,p_org_structure_version_id_o
218: => per_ose_shd.g_old_rec.org_structure_version_id
219: ,p_organization_id_child_o
220: => per_ose_shd.g_old_rec.organization_id_child
221: ,p_request_id_o
222: => per_ose_shd.g_old_rec.request_id

Line 220: => per_ose_shd.g_old_rec.organization_id_child

216: => per_ose_shd.g_old_rec.organization_id_parent
217: ,p_org_structure_version_id_o
218: => per_ose_shd.g_old_rec.org_structure_version_id
219: ,p_organization_id_child_o
220: => per_ose_shd.g_old_rec.organization_id_child
221: ,p_request_id_o
222: => per_ose_shd.g_old_rec.request_id
223: ,p_program_application_id_o
224: => per_ose_shd.g_old_rec.program_application_id

Line 222: => per_ose_shd.g_old_rec.request_id

218: => per_ose_shd.g_old_rec.org_structure_version_id
219: ,p_organization_id_child_o
220: => per_ose_shd.g_old_rec.organization_id_child
221: ,p_request_id_o
222: => per_ose_shd.g_old_rec.request_id
223: ,p_program_application_id_o
224: => per_ose_shd.g_old_rec.program_application_id
225: ,p_program_id_o
226: => per_ose_shd.g_old_rec.program_id

Line 224: => per_ose_shd.g_old_rec.program_application_id

220: => per_ose_shd.g_old_rec.organization_id_child
221: ,p_request_id_o
222: => per_ose_shd.g_old_rec.request_id
223: ,p_program_application_id_o
224: => per_ose_shd.g_old_rec.program_application_id
225: ,p_program_id_o
226: => per_ose_shd.g_old_rec.program_id
227: ,p_program_update_date_o
228: => per_ose_shd.g_old_rec.program_update_date

Line 226: => per_ose_shd.g_old_rec.program_id

222: => per_ose_shd.g_old_rec.request_id
223: ,p_program_application_id_o
224: => per_ose_shd.g_old_rec.program_application_id
225: ,p_program_id_o
226: => per_ose_shd.g_old_rec.program_id
227: ,p_program_update_date_o
228: => per_ose_shd.g_old_rec.program_update_date
229: ,p_object_version_number_o
230: => per_ose_shd.g_old_rec.object_version_number

Line 228: => per_ose_shd.g_old_rec.program_update_date

224: => per_ose_shd.g_old_rec.program_application_id
225: ,p_program_id_o
226: => per_ose_shd.g_old_rec.program_id
227: ,p_program_update_date_o
228: => per_ose_shd.g_old_rec.program_update_date
229: ,p_object_version_number_o
230: => per_ose_shd.g_old_rec.object_version_number
231: ,p_pos_control_enabled_flag_o
232: => per_ose_shd.g_old_rec.position_control_enabled_flag

Line 230: => per_ose_shd.g_old_rec.object_version_number

226: => per_ose_shd.g_old_rec.program_id
227: ,p_program_update_date_o
228: => per_ose_shd.g_old_rec.program_update_date
229: ,p_object_version_number_o
230: => per_ose_shd.g_old_rec.object_version_number
231: ,p_pos_control_enabled_flag_o
232: => per_ose_shd.g_old_rec.position_control_enabled_flag
233: );
234: --

Line 232: => per_ose_shd.g_old_rec.position_control_enabled_flag

228: => per_ose_shd.g_old_rec.program_update_date
229: ,p_object_version_number_o
230: => per_ose_shd.g_old_rec.object_version_number
231: ,p_pos_control_enabled_flag_o
232: => per_ose_shd.g_old_rec.position_control_enabled_flag
233: );
234: --
235: exception
236: --

Line 292: (p_rec in out nocopy per_ose_shd.g_rec_type

288: --
289: -- {End Of Comments}
290: -- ----------------------------------------------------------------------------
291: Procedure convert_defs
292: (p_rec in out nocopy per_ose_shd.g_rec_type
293: ) is
294: --
295: Begin
296: --

Line 304: per_ose_shd.g_old_rec.business_group_id;

300: -- is being used then we must set to the 'current' argument value.
301: --
302: If (p_rec.business_group_id = hr_api.g_number) then
303: p_rec.business_group_id :=
304: per_ose_shd.g_old_rec.business_group_id;
305: End If;
306: If (p_rec.organization_id_parent = hr_api.g_number) then
307: p_rec.organization_id_parent :=
308: per_ose_shd.g_old_rec.organization_id_parent;

Line 308: per_ose_shd.g_old_rec.organization_id_parent;

304: per_ose_shd.g_old_rec.business_group_id;
305: End If;
306: If (p_rec.organization_id_parent = hr_api.g_number) then
307: p_rec.organization_id_parent :=
308: per_ose_shd.g_old_rec.organization_id_parent;
309: End If;
310: If (p_rec.org_structure_version_id = hr_api.g_number) then
311: p_rec.org_structure_version_id :=
312: per_ose_shd.g_old_rec.org_structure_version_id;

Line 312: per_ose_shd.g_old_rec.org_structure_version_id;

308: per_ose_shd.g_old_rec.organization_id_parent;
309: End If;
310: If (p_rec.org_structure_version_id = hr_api.g_number) then
311: p_rec.org_structure_version_id :=
312: per_ose_shd.g_old_rec.org_structure_version_id;
313: End If;
314: If (p_rec.organization_id_child = hr_api.g_number) then
315: p_rec.organization_id_child :=
316: per_ose_shd.g_old_rec.organization_id_child;

Line 316: per_ose_shd.g_old_rec.organization_id_child;

312: per_ose_shd.g_old_rec.org_structure_version_id;
313: End If;
314: If (p_rec.organization_id_child = hr_api.g_number) then
315: p_rec.organization_id_child :=
316: per_ose_shd.g_old_rec.organization_id_child;
317: End If;
318: If (p_rec.position_control_enabled_flag = hr_api.g_varchar2) then
319: p_rec.position_control_enabled_flag :=
320: per_ose_shd.g_old_rec.position_control_enabled_flag;

Line 320: per_ose_shd.g_old_rec.position_control_enabled_flag;

316: per_ose_shd.g_old_rec.organization_id_child;
317: End If;
318: If (p_rec.position_control_enabled_flag = hr_api.g_varchar2) then
319: p_rec.position_control_enabled_flag :=
320: per_ose_shd.g_old_rec.position_control_enabled_flag;
321: End If;
322: If (p_rec.request_id = hr_api.g_number) then
323: p_rec.request_id :=
324: per_ose_shd.g_old_rec.request_id;

Line 324: per_ose_shd.g_old_rec.request_id;

320: per_ose_shd.g_old_rec.position_control_enabled_flag;
321: End If;
322: If (p_rec.request_id = hr_api.g_number) then
323: p_rec.request_id :=
324: per_ose_shd.g_old_rec.request_id;
325: End If;
326: If (p_rec.program_application_id = hr_api.g_number) then
327: p_rec.program_application_id :=
328: per_ose_shd.g_old_rec.program_application_id;

Line 328: per_ose_shd.g_old_rec.program_application_id;

324: per_ose_shd.g_old_rec.request_id;
325: End If;
326: If (p_rec.program_application_id = hr_api.g_number) then
327: p_rec.program_application_id :=
328: per_ose_shd.g_old_rec.program_application_id;
329: End If;
330: If (p_rec.program_id = hr_api.g_number) then
331: p_rec.program_id :=
332: per_ose_shd.g_old_rec.program_id;

Line 332: per_ose_shd.g_old_rec.program_id;

328: per_ose_shd.g_old_rec.program_application_id;
329: End If;
330: If (p_rec.program_id = hr_api.g_number) then
331: p_rec.program_id :=
332: per_ose_shd.g_old_rec.program_id;
333: End If;
334: If (p_rec.program_update_date = hr_api.g_date) then
335: p_rec.program_update_date :=
336: per_ose_shd.g_old_rec.program_update_date;

Line 336: per_ose_shd.g_old_rec.program_update_date;

332: per_ose_shd.g_old_rec.program_id;
333: End If;
334: If (p_rec.program_update_date = hr_api.g_date) then
335: p_rec.program_update_date :=
336: per_ose_shd.g_old_rec.program_update_date;
337: End If;
338: --
339: End convert_defs;
340: --

Line 345: (p_rec in out nocopy per_ose_shd.g_rec_type

341: -- ----------------------------------------------------------------------------
342: -- |---------------------------------< upd >----------------------------------|
343: -- ----------------------------------------------------------------------------
344: Procedure upd
345: (p_rec in out nocopy per_ose_shd.g_rec_type
346: ,p_effective_date in date
347: ) is
348: --
349: l_proc varchar2(72) := g_package||'upd';

Line 361: per_ose_shd.lck

357: hr_utility.set_location('Entering:'||l_proc, 5);
358: --
359: -- We must lock the row which we need to update.
360: --
361: per_ose_shd.lck
362: (p_rec.org_structure_element_id
363: ,p_rec.object_version_number
364: );
365: --

Line 434: l_rec per_ose_shd.g_rec_type;

430: ,p_program_id in number default hr_api.g_number
431: ,p_program_update_date in date default hr_api.g_date
432: ) is
433: --
434: l_rec per_ose_shd.g_rec_type;
435: l_proc varchar2(72) := g_package||'upd';
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);

Line 444: per_ose_shd.convert_args

440: -- Call conversion function to turn arguments into the
441: -- l_rec structure.
442: --
443: l_rec :=
444: per_ose_shd.convert_args
445: (p_org_structure_element_id
446: ,hr_api.g_number
447: ,p_organization_id_parent
448: ,hr_api.g_number