[Home] [Help]
PACKAGE: APPS.PER_ORG_STRUCTURE_ELEMENTS_PKG
Source
1 PACKAGE PER_ORG_STRUCTURE_ELEMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: peose01t.pkh 120.1.12010000.2 2009/02/25 08:30:37 sidsaxen ship $ */
3 ------------------------------------------------------------------------------
4 FUNCTION get_subordinates(p_view_all_orgs VARCHAR2
5 ,p_org_id_parent NUMBER
6 ,p_org_structure_version_id NUMBER
7 ,p_security_profile_id NUMBER) return NUMBER;
8 ------------------------------------------------------------------------------
9 PROCEDURE maintain_org_lists(p_business_group_id NUMBER
10 ,p_security_profile_id NUMBER
11 ,p_organization_id NUMBER);
12 ------------------------------------------------------------------------------
13 PROCEDURE delete_validation(p_org_structure_version_id NUMBER
14 ,p_org_structure_element_id NUMBER
15 ,p_org_id_child NUMBER
16 ,p_org_id_parent NUMBER
17 ,p_hr_installed VARCHAR2
18 ,p_pa_installed VARCHAR2);
19 ------------------------------------------------------------------------------
20 PROCEDURE perwsdor_delete_check(p_org_structure_version_id NUMBER
21 ,p_org_structure_element_id NUMBER
22 ,p_org_id_child NUMBER
23 ,p_org_id_parent NUMBER
24 ,p_business_group_id NUMBER
25 ,p_hr_installed VARCHAR2
26 ,p_pa_installed VARCHAR2);
27 ------------------------------------------------------------------------------
28 PROCEDURE check_duplicate_entry (p_org_structure_version_id NUMBER
29 ,p_org_structure_element_id NUMBER);
30 ------------------------------------------------------------------------------
31 PROCEDURE check_org_active(p_Org_Id_Parent NUMBER
32 ,p_date_from DATE
33 ,p_end_of_time DATE
34 ,p_warning_raised IN OUT NOCOPY VARCHAR2);
35 -------------------------------------------------------------------------------
36 PROCEDURE check_position_flag (
37 p_org_structure_version_id NUMBER
38 ,p_pos_control_enabled_flag VARCHAR2);
39 ------------------------------------------------------------------------------
40 FUNCTION post_delete_check(p_org_structure_version_id NUMBER
41 ,p_organization_id NUMBER) return BOOLEAN;
42 ------------------------------------------------------------------------------
43 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
44 p_Org_Structure_Element_Id IN OUT NOCOPY NUMBER,
45 p_Business_Group_Id NUMBER,
46 p_Organization_Id_Parent NUMBER,
47 p_Org_Structure_Version_Id NUMBER,
48 p_Organization_Id_Child NUMBER,
49 p_date_from DATE,
50 p_security_profile_id NUMBER,
51 p_view_all_orgs VARCHAR2,
52 p_end_of_time DATE,
53 p_pos_control_enabled_flag VARCHAR2
54 );
55 ------------------------------------------------------------------------------
56 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
57 p_Org_Structure_Element_Id IN OUT NOCOPY NUMBER,
58 p_Business_Group_Id NUMBER,
59 p_Organization_Id_Parent NUMBER,
60 p_Org_Structure_Version_Id NUMBER,
61 p_Organization_Id_Child NUMBER,
62 p_date_from DATE,
63 p_security_profile_id NUMBER,
64 p_view_all_orgs VARCHAR2,
65 p_end_of_time DATE,
66 p_pos_control_enabled_flag VARCHAR2,
67 p_warning_raised IN OUT NOCOPY VARCHAR2
68 );
69 ------------------------------------------------------------------------------
70 -- added for bug 8200692
71 PROCEDURE Insert_Row(p_Rowid IN OUT NOCOPY VARCHAR2,
72 p_Org_Structure_Element_Id IN OUT NOCOPY NUMBER,
73 p_Business_Group_Id NUMBER,
74 p_Organization_Id_Parent NUMBER,
75 p_Org_Structure_Version_Id NUMBER,
76 p_Organization_Id_Child NUMBER,
77 p_date_from DATE,
78 p_security_profile_id NUMBER,
79 p_view_all_orgs VARCHAR2,
80 p_end_of_time DATE,
81 p_pos_control_enabled_flag VARCHAR2,
82 p_warning_raised IN OUT NOCOPY VARCHAR2,
83 p_pa_installed VARCHAR2
84 );
85 ------------------------------------------------------------------------------
86 PROCEDURE Lock_Row(p_Rowid VARCHAR2,
87 p_Org_Structure_Element_Id NUMBER,
88 p_Business_Group_Id NUMBER,
89 p_Organization_Id_Parent NUMBER,
90 p_Org_Structure_Version_Id NUMBER,
91 p_Organization_Id_Child NUMBER,
92 p_pos_control_enabled_flag VARCHAR2
93 );
94 ------------------------------------------------------------------------------
95 PROCEDURE Update_Row(p_Rowid VARCHAR2,
96 p_Org_Structure_Element_Id NUMBER,
97 p_Business_Group_Id NUMBER,
98 p_Organization_Id_Parent NUMBER,
99 p_Org_Structure_Version_Id NUMBER,
100 p_Organization_Id_Child NUMBER,
101 p_pos_control_enabled_flag VARCHAR2
102 );
103 ------------------------------------------------------------------------------
104 --bug no 5912009 starts here
105 PROCEDURE Update_Row(p_Rowid VARCHAR2,
106 p_Org_Structure_Element_Id NUMBER,
107 p_Business_Group_Id NUMBER,
108 p_Organization_Id_Parent NUMBER,
109 p_Org_Structure_Version_Id NUMBER,
110 p_Organization_Id_Child NUMBER,
111 p_pos_control_enabled_flag VARCHAR2
112 ,p_pa_installed VARCHAR2
113 );
114 --bug no 5912009 ends here
115 ------------------------------------------------------------------------------
116 PROCEDURE Delete_Row(p_Rowid VARCHAR2
117 ,p_org_structure_version_id NUMBER
118 ,p_org_structure_element_id NUMBER
119 ,p_Organization_Id_Child NUMBER
120 ,p_Organization_Id_Parent NUMBER
121 ,p_hr_installed VARCHAR2
122 ,p_exists_in_hierarchy IN OUT NOCOPY VARCHAR2
123 ,p_pa_installed VARCHAR2);
124 ------------------------------------------------------------------------------
125 END PER_ORG_STRUCTURE_ELEMENTS_PKG;