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_PSE_UPD dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 68: -- Update the per_pos_structure_elements Row

64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_pse_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_pos_structure_elements Row
69: --
70: update per_pos_structure_elements
71: set
72: pos_structure_element_id = p_rec.pos_structure_element_id

Line 70: update per_pos_structure_elements

66: per_pse_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_pos_structure_elements Row
69: --
70: update per_pos_structure_elements
71: set
72: pos_structure_element_id = p_rec.pos_structure_element_id
73: ,business_group_id = p_rec.business_group_id
74: ,pos_structure_version_id = p_rec.pos_structure_version_id

Line 241: (p_module_name => 'PER_POS_STRUCTURE_ELEMENTS'

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

Line 349: l_old_parent_pos_id per_pos_structure_elements.PARENT_POSITION_ID%type;

345: --
346: l_proc varchar2(72) := g_package||'upd';
347:
348: --Bug no 3888749 starts here
349: l_old_parent_pos_id per_pos_structure_elements.PARENT_POSITION_ID%type;
350: l_new_parent_pos_id per_pos_structure_elements.PARENT_POSITION_ID%type;
351: l_myexception Exception;
352: --Bug no 3888749 ends here
353: --

Line 350: l_new_parent_pos_id per_pos_structure_elements.PARENT_POSITION_ID%type;

346: l_proc varchar2(72) := g_package||'upd';
347:
348: --Bug no 3888749 starts here
349: l_old_parent_pos_id per_pos_structure_elements.PARENT_POSITION_ID%type;
350: l_new_parent_pos_id per_pos_structure_elements.PARENT_POSITION_ID%type;
351: l_myexception Exception;
352: --Bug no 3888749 ends here
353: --
354: Begin

Line 377: select PARENT_POSITION_ID into l_old_parent_pos_id from per_pos_structure_elements x

373: ,p_effective_date
374: );
375:
376: --Bug no 3888749 starts here
377: select PARENT_POSITION_ID into l_old_parent_pos_id from per_pos_structure_elements x
378: where POS_STRUCTURE_VERSION_ID = p_rec.pos_structure_version_id
379: and not exists (select null from per_pos_structure_elements
380: where SUBORDINATE_POSITION_ID = x.PARENT_POSITION_ID)
381: and rownum=1;

Line 379: and not exists (select null from per_pos_structure_elements

375:
376: --Bug no 3888749 starts here
377: select PARENT_POSITION_ID into l_old_parent_pos_id from per_pos_structure_elements x
378: where POS_STRUCTURE_VERSION_ID = p_rec.pos_structure_version_id
379: and not exists (select null from per_pos_structure_elements
380: where SUBORDINATE_POSITION_ID = x.PARENT_POSITION_ID)
381: and rownum=1;
382: --Bug no 3888749 ends here
383:

Line 397: select PARENT_POSITION_ID into l_new_parent_pos_id from per_pos_structure_elements x

393: /* Bug no 3888749 starts here
394:
395: Putting extra check on Top Node in the Position hierarchy so that it can not be updated.*/
396:
397: select PARENT_POSITION_ID into l_new_parent_pos_id from per_pos_structure_elements x
398: where POS_STRUCTURE_VERSION_ID = p_rec.pos_structure_version_id
399: and not exists (select null from per_pos_structure_elements
400: where SUBORDINATE_POSITION_ID = x.PARENT_POSITION_ID)
401: and rownum=1;

Line 399: and not exists (select null from per_pos_structure_elements

395: Putting extra check on Top Node in the Position hierarchy so that it can not be updated.*/
396:
397: select PARENT_POSITION_ID into l_new_parent_pos_id from per_pos_structure_elements x
398: where POS_STRUCTURE_VERSION_ID = p_rec.pos_structure_version_id
399: and not exists (select null from per_pos_structure_elements
400: where SUBORDINATE_POSITION_ID = x.PARENT_POSITION_ID)
401: and rownum=1;
402:
403: hr_utility.set_location('old_parent_id '||l_old_parent_pos_id||'new_parent_id '||l_new_parent_pos_id,10);