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_ORG_STRUCTURE_ELEMENTS

Line 68: -- Update the per_org_structure_elements Row

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
71: set
72: org_structure_element_id = p_rec.org_structure_element_id

Line 70: update per_org_structure_elements

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
71: set
72: org_structure_element_id = p_rec.org_structure_element_id
73: ,organization_id_parent = p_rec.organization_id_parent
74: ,organization_id_child = p_rec.organization_id_child

Line 240: (p_module_name => 'PER_ORG_STRUCTURE_ELEMENTS'

236: --
237: when hr_api.cannot_find_prog_unit then
238: --
239: hr_api.cannot_find_prog_unit_error
240: (p_module_name => 'PER_ORG_STRUCTURE_ELEMENTS'
241: ,p_hook_type => 'AU');
242: --
243: end;
244: --

Line 351: l_old_parent_org_id per_org_structure_elements.ORGANIZATION_ID_PARENT%type;

347: ) is
348: --
349: l_proc varchar2(72) := g_package||'upd';
350: --Bug no 2720039 starts here
351: l_old_parent_org_id per_org_structure_elements.ORGANIZATION_ID_PARENT%type;
352: l_new_parent_org_id per_org_structure_elements.ORGANIZATION_ID_PARENT%type;
353: l_myexception Exception;
354: --Bug no 2720039 ends here
355: --

Line 352: l_new_parent_org_id per_org_structure_elements.ORGANIZATION_ID_PARENT%type;

348: --
349: l_proc varchar2(72) := g_package||'upd';
350: --Bug no 2720039 starts here
351: l_old_parent_org_id per_org_structure_elements.ORGANIZATION_ID_PARENT%type;
352: l_new_parent_org_id per_org_structure_elements.ORGANIZATION_ID_PARENT%type;
353: l_myexception Exception;
354: --Bug no 2720039 ends here
355: --
356: Begin

Line 379: select ORGANIZATION_ID_PARENT into l_old_parent_org_id from per_org_structure_elements x

375: ,p_effective_date
376: );
377:
378: --Bug no 2720039 starts here
379: select ORGANIZATION_ID_PARENT into l_old_parent_org_id from per_org_structure_elements x
380: where ORG_STRUCTURE_VERSION_ID = p_rec.org_structure_version_id
381: and not exists (select null from per_org_structure_elements
382: where ORGANIZATION_ID_CHILD = x.ORGANIZATION_ID_PARENT)
383: and rownum=1;

Line 381: and not exists (select null from per_org_structure_elements

377:
378: --Bug no 2720039 starts here
379: select ORGANIZATION_ID_PARENT into l_old_parent_org_id from per_org_structure_elements x
380: where ORG_STRUCTURE_VERSION_ID = p_rec.org_structure_version_id
381: and not exists (select null from per_org_structure_elements
382: where ORGANIZATION_ID_CHILD = x.ORGANIZATION_ID_PARENT)
383: and rownum=1;
384: --Bug no 2720039 ends here
385: --

Line 401: select ORGANIZATION_ID_PARENT into l_new_parent_org_id from per_org_structure_elements x

397: Bug no 2720039 starts here
398:
399: Putting extra check on Top Node in the organization hierarchy so that it can not be updated.*/
400:
401: select ORGANIZATION_ID_PARENT into l_new_parent_org_id from per_org_structure_elements x
402: where ORG_STRUCTURE_VERSION_ID = p_rec.org_structure_version_id
403: and not exists (select null from per_org_structure_elements
404: where ORGANIZATION_ID_CHILD = x.ORGANIZATION_ID_PARENT)
405: and rownum=1;

Line 403: and not exists (select null from per_org_structure_elements

399: Putting extra check on Top Node in the organization hierarchy so that it can not be updated.*/
400:
401: select ORGANIZATION_ID_PARENT into l_new_parent_org_id from per_org_structure_elements x
402: where ORG_STRUCTURE_VERSION_ID = p_rec.org_structure_version_id
403: and not exists (select null from per_org_structure_elements
404: where ORGANIZATION_ID_CHILD = x.ORGANIZATION_ID_PARENT)
405: and rownum=1;
406: hr_utility.set_location('old_parent_id '||l_old_parent_org_id||'new_parent_id '||l_new_parent_org_id,10);
407: if (l_old_parent_org_id<>l_new_parent_org_id) then