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.0.12000000.2 2007/03/07 10:58:33 asgugupt 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 535: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS

531: p_pos_control_enabled_flag VARCHAR2,
532: p_warning_raised IN OUT NOCOPY VARCHAR2
533: ) IS
534: --
535: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS
536: WHERE org_structure_element_id = p_Org_Structure_Element_Id;
537: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;
538: --
539: cursor get_details is select rowid,org_structure_element_id,

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

533: ) IS
534: --
535: CURSOR C IS SELECT rowid FROM PER_ORG_STRUCTURE_ELEMENTS
536: WHERE org_structure_element_id = p_Org_Structure_Element_Id;
537: CURSOR C2 IS SELECT per_org_structure_elements_s.nextval FROM sys.dual;
538: --
539: cursor get_details is select rowid,org_structure_element_id,
540: business_group_id,organization_id_parent,org_structure_version_id,
541: organization_id_child, position_control_enabled_flag

Line 542: from per_org_structure_elements

538: --
539: cursor get_details is select rowid,org_structure_element_id,
540: business_group_id,organization_id_parent,org_structure_version_id,
541: organization_id_child, position_control_enabled_flag
542: from per_org_structure_elements
543: where organization_id_child = p_Organization_Id_Child
544: and org_structure_version_id = p_org_structure_version_id;
545: --
546: Recinfo get_details%ROWTYPE;

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

568: if get_details%found then
569: --
570: -- Lock the row
571: --
572: PER_ORG_STRUCTURE_ELEMENTS_PKG.Lock_Row(p_Rowid => Recinfo.ROWID,
573: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
574: p_Business_Group_Id =>Recinfo.Business_Group_Id,
575: p_Organization_Id_Parent =>Recinfo.Organization_Id_Parent,
576: p_Org_Structure_Version_Id=>Recinfo.Org_Structure_Version_Id,

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

578: p_pos_control_enabled_flag => Recinfo.position_control_enabled_flag);
579: --
580: -- Update the row
581: --
582: PER_ORG_STRUCTURE_ELEMENTS_PKG.Update_Row(p_Rowid=> Recinfo.ROWID,
583: p_Org_Structure_Element_Id =>Recinfo.Org_Structure_Element_Id,
584: p_Business_Group_Id => Recinfo.Business_Group_Id,
585: p_Organization_Id_Parent =>p_Organization_Id_Parent,
586: p_Org_Structure_Version_Id =>Recinfo.Org_Structure_Version_Id,

Line 606: INSERT INTO PER_ORG_STRUCTURE_ELEMENTS(

602: FETCH C2 INTO p_Org_Structure_Element_Id;
603: CLOSE C2;
604: end if;
605: --
606: INSERT INTO PER_ORG_STRUCTURE_ELEMENTS(
607: org_structure_element_id,
608: business_group_id,
609: organization_id_parent,
610: org_structure_version_id,

Line 634: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id

630: -- Post-insert code
631: -- Maintains org_list security profiles
632: --
633: if p_view_all_orgs = 'N' then
634: per_org_structure_elements_pkg.maintain_org_lists(p_Business_Group_Id
635: ,p_security_profile_id
636: ,p_Organization_Id_Parent
637: );
638: end if;

Line 653: FROM PER_ORG_STRUCTURE_ELEMENTS

649: ) IS
650: --
651: CURSOR C IS
652: SELECT *
653: FROM PER_ORG_STRUCTURE_ELEMENTS
654: WHERE rowid = p_Rowid
655: FOR UPDATE of Org_Structure_Element_Id NOWAIT;
656: Recinfo C%ROWTYPE;
657: BEGIN

Line 732: UPDATE PER_ORG_STRUCTURE_ELEMENTS

728: pa_org.pa_ose_predel_validation(p_org_structure_element_id);
729: end if;
730: --changes for bug 5912009 ends here
731:
732: UPDATE PER_ORG_STRUCTURE_ELEMENTS
733: SET
734: org_structure_element_id = p_Org_Structure_Element_Id,
735: business_group_id = p_Business_Group_Id,
736: organization_id_parent = p_Organization_Id_Parent,

Line 760: per_org_structure_elements_pkg.delete_validation(

756: BEGIN
757: --
758: -- Do pre-delete validation
759: --
760: per_org_structure_elements_pkg.delete_validation(
761: p_org_structure_version_id =>p_org_structure_version_id
762: ,p_org_structure_element_id => p_org_structure_element_id
763: ,p_org_id_child => p_organization_id_child
764: ,p_org_id_parent => p_organization_id_parent

Line 769: DELETE FROM PER_ORG_STRUCTURE_ELEMENTS

765: ,p_hr_installed => p_hr_installed
766: ,p_pa_installed => p_pa_installed);
767: -- Perform the delete
768: --
769: DELETE FROM PER_ORG_STRUCTURE_ELEMENTS
770: WHERE rowid = p_Rowid;
771: --
772: if (SQL%NOTFOUND) then
773: RAISE NO_DATA_FOUND;

Line 778: if per_org_structure_elements_pkg.post_delete_check(

774: end if;
775: --
776: -- Post-delete checking
777: --
778: if per_org_structure_elements_pkg.post_delete_check(
779: p_org_structure_version_id => p_org_structure_version_id
780: ,p_organization_id => p_organization_id_parent) then
781: p_exists_in_hierarchy :='Y';
782: else

Line 787: END PER_ORG_STRUCTURE_ELEMENTS_PKG;

783: p_exists_in_hierarchy :='N';
784: end if;
785: END Delete_Row;
786: -------------------------------------------------------------------------------
787: END PER_ORG_STRUCTURE_ELEMENTS_PKG;