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_ORG_STRUCTURE_ELEMENTS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1: PACKAGE BODY PER_ORG_STRUCTURE_ELEMENTS_PKG as

1: PACKAGE BODY PER_ORG_STRUCTURE_ELEMENTS_PKG as
2: /* $Header: peose01t.pkb 120.1.12010000.2 2009/02/25 08:33:18 sidsaxen ship $ */
3: ------------------------------------------------------------------------------
4: FUNCTION get_subordinates(p_view_all_orgs VARCHAR2
5: ,p_org_id_parent NUMBER

Line 22: from per_org_structure_elements ose

18: --
19: --fix for bug 4389340 starts here
20: select nvl( count(ose.org_structure_element_id), 0)
21: into l_count
22: from per_org_structure_elements ose
23: where ((nvl(p_view_all_orgs,'Y') <> 'Y'
24: and EXISTS
25: (select '1'
26: from hr_organization_units hru

Line 91: from per_org_structure_elements a

87: where exists (select null
88: from sys.dual
89: where p_organization_id in
90: (select a.organization_id_child
91: from per_org_structure_elements a
92: where ( a.business_group_id + 0 = p_business_group_id
93: or ( a.business_group_id is null
94: and p_business_group_id is null))
95: and a.org_structure_version_id in

Line 208: from per_org_structure_elements ose

204: select null
205: into l_temp
206: from sys.dual
207: where exists (select null
208: from per_org_structure_elements ose
209: where ose.org_structure_version_id =
210: p_org_structure_version_id
211: and ose.organization_id_parent =
212: p_org_id_child);

Line 250: from per_org_structure_elements ose

246: and ((psp.organization_id = p_org_id_child)
247: or(psp.organization_id = p_org_id_parent
248: and not exists (
249: select null
250: from per_org_structure_elements ose
251: where ose.org_structure_version_id =
252: p_org_structure_version_id
253: and ose.organization_id_child =
254: p_org_id_parent

Line 258: from per_org_structure_elements ose

254: p_org_id_parent
255: )
256: and not exists (
257: select null
258: from per_org_structure_elements ose
259: where ose.org_structure_version_id =
260: p_org_structure_version_id
261: and ose.org_structure_element_id <>
262: p_org_structure_element_id

Line 297: from per_org_structure_elements pos

293: ,p_business_group_id NUMBER
294: ,p_hr_installed VARCHAR2
295: ,p_pa_installed VARCHAR2) is
296: cursor c1 is select 'Y'
297: from per_org_structure_elements pos
298: where pos.org_structure_version_id = p_org_structure_version_id
299: and (not exists
300: (select null
301: from per_org_structure_elements pos2

Line 301: from per_org_structure_elements pos2

297: from per_org_structure_elements pos
298: where pos.org_structure_version_id = p_org_structure_version_id
299: and (not exists
300: (select null
301: from per_org_structure_elements pos2
302: where pos2.org_structure_version_id
303: = p_org_structure_version_id
304: and pos2.organization_id_child =
305: p_org_id_parent

Line 308: from per_org_structure_elements pos3

304: and pos2.organization_id_child =
305: p_org_id_parent
306: )
307: and 1 =(select count(pos3.ORG_STRUCTURE_VERSION_ID)
308: from per_org_structure_elements pos3
309: where pos3.org_structure_version_id
310: = p_org_structure_version_id
311: and pos3.organization_id_parent =
312: p_org_id_parent

Line 316: from per_org_structure_elements pos3

312: p_org_id_parent
313: )
314: OR (not exists
315: (select null
316: from per_org_structure_elements pos3
317: where pos3.org_structure_version_id =
318: p_org_structure_version_id
319: and pos3.organization_id_parent = p_org_id_child)
320: )

Line 377: from per_org_structure_elements ose

373: select null
374: into l_temp
375: from sys.dual
376: where exists( select null
377: from per_org_structure_elements ose
378: where ose.org_structure_version_id =
379: p_org_structure_version_id
380: and ose.organization_id_child =
381: p_org_structure_element_id);

Line 476: from per_org_structure_elements ose

472: select null
473: into l_temp
474: from sys.dual
475: where exists( select null
476: from per_org_structure_elements ose
477: where ose.org_structure_version_id =
478: p_org_structure_version_id
479: and (ose.organization_id_parent = p_organization_id
480: or ose.organization_id_child = p_organization_id)

Line 569: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS

565: p_warning_raised IN OUT NOCOPY VARCHAR2,
566: p_pa_installed VARCHAR2 --added for bug 8200692
567: ) IS
568: --
569: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS
570: WHERE org_structure_element_id = p_Org_Structure_Element_Id;
571: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;
572: --
573: cursor get_details is select rowid,org_structure_element_id,

Line 571: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;

567: ) IS
568: --
569: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS
570: WHERE org_structure_element_id = p_Org_Structure_Element_Id;
571: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;
572: --
573: cursor get_details is select rowid,org_structure_element_id,
574: business_group_id,organization_id_parent,org_structure_version_id,
575: organization_id_child, position_control_enabled_flag

Line 576: from per_org_structure_elements

572: --
573: cursor get_details is select rowid,org_structure_element_id,
574: business_group_id,organization_id_parent,org_structure_version_id,
575: organization_id_child, position_control_enabled_flag
576: from per_org_structure_elements
577: where organization_id_child = p_Organization_Id_Child
578: and org_structure_version_id = p_org_structure_version_id;
579: --
580: Recinfo get_details%ROWTYPE;

Line 606: PER_ORG_STRUCTURE_ELEMENTS_PKG.Lock_Row(p_Rowid => Recinfo.ROWID,

602: if get_details%found then
603: --
604: -- Lock the row
605: --
606: PER_ORG_STRUCTURE_ELEMENTS_PKG.Lock_Row(p_Rowid => Recinfo.ROWID,
607: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
608: p_Business_Group_Id =>Recinfo.Business_Group_Id,
609: p_Organization_Id_Parent =>Recinfo.Organization_Id_Parent,
610: p_Org_Structure_Version_Id=>Recinfo.Org_Structure_Version_Id,

Line 616: PER_ORG_STRUCTURE_ELEMENTS_PKG.Update_Row(p_Rowid=> Recinfo.ROWID,

612: p_pos_control_enabled_flag => Recinfo.position_control_enabled_flag);
613: --
614: -- Update the row
615: --
616: PER_ORG_STRUCTURE_ELEMENTS_PKG.Update_Row(p_Rowid=> Recinfo.ROWID,
617: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
618: p_Business_Group_Id => Recinfo.Business_Group_Id,
619: p_Organization_Id_Parent =>p_Organization_Id_Parent,
620: p_Org_Structure_Version_Id =>Recinfo.Org_Structure_Version_Id,

Line 641: INSERT INTO PER_ORG_STRUCTURE_ELEMENTS(

637: FETCH C2 INTO p_Org_Structure_Element_Id;
638: CLOSE C2;
639: end if;
640: --
641: INSERT INTO PER_ORG_STRUCTURE_ELEMENTS(
642: org_structure_element_id,
643: business_group_id,
644: organization_id_parent,
645: org_structure_version_id,

Line 669: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id

665: -- Post-insert code
666: -- Maintains org_list security profiles
667: --
668: if p_view_all_orgs = 'N' then
669: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id
670: ,p_security_profile_id
671: ,p_Organization_Id_Parent
672: );
673: end if;

Line 688: FROM PER_ORG_STRUCTURE_ELEMENTS

684: ) IS
685: --
686: CURSOR C IS
687: SELECT *
688: FROM PER_ORG_STRUCTURE_ELEMENTS
689: WHERE rowid = p_Rowid
690: FOR UPDATE of Org_Structure_Element_Id NOWAIT;
691: Recinfo C%ROWTYPE;
692: BEGIN

Line 767: UPDATE PER_ORG_STRUCTURE_ELEMENTS

763: pa_org.pa_ose_predel_validation(p_org_structure_element_id);
764: end if;
765: --changes for bug 5912009 ends here
766:
767: UPDATE PER_ORG_STRUCTURE_ELEMENTS
768: SET
769: org_structure_element_id = p_Org_Structure_Element_Id,
770: business_group_id = p_Business_Group_Id,
771: organization_id_parent = p_Organization_Id_Parent,

Line 795: per_org_structure_elements_pkg.delete_validation(

791: BEGIN
792: --
793: -- Do pre-delete validation
794: --
795: per_org_structure_elements_pkg.delete_validation(
796: p_org_structure_version_id =>p_org_structure_version_id
797: ,p_org_structure_element_id => p_org_structure_element_id
798: ,p_org_id_child => p_organization_id_child
799: ,p_org_id_parent => p_organization_id_parent

Line 804: DELETE FROM PER_ORG_STRUCTURE_ELEMENTS

800: ,p_hr_installed => p_hr_installed
801: ,p_pa_installed => p_pa_installed);
802: -- Perform the delete
803: --
804: DELETE FROM PER_ORG_STRUCTURE_ELEMENTS
805: WHERE rowid = p_Rowid;
806: --
807: if (SQL%NOTFOUND) then
808: RAISE NO_DATA_FOUND;

Line 813: if per_org_structure_elements_pkg.post_delete_check(

809: end if;
810: --
811: -- Post-delete checking
812: --
813: if per_org_structure_elements_pkg.post_delete_check(
814: p_org_structure_version_id => p_org_structure_version_id
815: ,p_organization_id => p_organization_id_parent) then
816: p_exists_in_hierarchy :='Y';
817: else

Line 822: END PER_ORG_STRUCTURE_ELEMENTS_PKG;

818: p_exists_in_hierarchy :='N';
819: end if;
820: END Delete_Row;
821: -------------------------------------------------------------------------------
822: END PER_ORG_STRUCTURE_ELEMENTS_PKG;