[Home] [Help]
PACKAGE: APPS.HR_ORGANIZATION_UNITS_PKG
Source
1 PACKAGE HR_ORGANIZATION_UNITS_PKG AUTHID CURRENT_USER as
2 /* $Header: peoru01t.pkh 115.8 2002/12/06 15:52:51 pkakar ship $ */
3 --
4 --
5 -- Package Variables
6 --
7 g_package varchar2(33) := 'HR_ORGANIZATION_UNITS_PKG.';
8 --
9 PROCEDURE chk_repbody_seat_numbers
10 (p_organization_id IN hr_organization_units.organization_id%TYPE
11 ,p_org_information_context IN hr_organization_information.org_information_context%TYPE
12 ,p_org_information6 IN hr_organization_information.org_information6%TYPE
13 ,p_org_information2 IN hr_organization_information.org_information2%TYPE
14 ,p_rowid IN VARCHAR2);
15 --
16 FUNCTION Is_Org_A_Node
17 (p_search_org_id IN hr_organization_units.organization_id%TYPE
18 ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)
19 RETURN CHAR;
20 --
21 function exists_in_hierarchy(p_org_structure_version_id NUMBER
22 ,p_organization_id NUMBER) return varchar2;
23 function get_parent(p_organization_id NUMBER
24 ,p_org_structure_version_id NUMBER) return NUMBER;
25 procedure form_post_query(p_exists_in_hierarchy in out nocopy VARCHAR2
26 ,p_view_all_orgs VARCHAR2
27 ,p_organization_id NUMBER
28 ,p_org_structure_version_id NUMBER
29 ,p_security_profile_id NUMBER
30 ,p_number_of_subordinates in out nocopy NUMBER);
31 --
32 procedure check_gre(p_org_id NUMBER);
33 --
34 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
35
36 X_Organization_Id IN OUT NOCOPY NUMBER,
37 X_Business_Group_Id NUMBER,
38 X_Cost_Allocation_Keyflex_Id NUMBER,
39 X_Location_Id NUMBER,
40 X_Soft_Coding_Keyflex_Id NUMBER,
41 X_Date_From DATE,
42 X_Name VARCHAR2,
43 X_Comments VARCHAR2,
44 X_Date_To DATE,
45 X_Internal_External_Flag VARCHAR2,
46 X_Internal_Address_Line VARCHAR2,
47 X_Type VARCHAR2,
48 X_Security_Profile_Id NUMBER,
49 X_View_All_Orgs VARCHAR2,
50 X_Attribute_Category VARCHAR2,
51 X_Attribute1 VARCHAR2,
52 X_Attribute2 VARCHAR2,
53 X_Attribute3 VARCHAR2,
54 X_Attribute4 VARCHAR2,
55 X_Attribute5 VARCHAR2,
56 X_Attribute6 VARCHAR2,
57 X_Attribute7 VARCHAR2,
58 X_Attribute8 VARCHAR2,
59 X_Attribute9 VARCHAR2,
60 X_Attribute10 VARCHAR2,
61 X_Attribute11 VARCHAR2,
62 X_Attribute12 VARCHAR2,
63 X_Attribute13 VARCHAR2,
67 X_Attribute17 VARCHAR2,
64 X_Attribute14 VARCHAR2,
65 X_Attribute15 VARCHAR2,
66 X_Attribute16 VARCHAR2,
68 X_Attribute18 VARCHAR2,
69 X_Attribute19 VARCHAR2,
70 X_Attribute20 VARCHAR2
71 );
72
73 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
74 X_Organization_Id NUMBER,
75 X_Business_Group_Id NUMBER,
76 X_Cost_Allocation_Keyflex_Id NUMBER,
77 X_Location_Id NUMBER,
78 X_Soft_Coding_Keyflex_Id NUMBER,
79 X_Date_From DATE,
80 X_Name VARCHAR2,
81 X_Comments VARCHAR2,
82 X_Date_To DATE,
83 X_Internal_External_Flag VARCHAR2,
84 X_Internal_Address_Line VARCHAR2,
85 X_Type VARCHAR2,
86 X_Attribute_Category VARCHAR2,
87 X_Attribute1 VARCHAR2,
88 X_Attribute2 VARCHAR2,
89 X_Attribute3 VARCHAR2,
90 X_Attribute4 VARCHAR2,
91 X_Attribute5 VARCHAR2,
92 X_Attribute6 VARCHAR2,
93 X_Attribute7 VARCHAR2,
94 X_Attribute8 VARCHAR2,
95 X_Attribute9 VARCHAR2,
96 X_Attribute10 VARCHAR2,
97 X_Attribute11 VARCHAR2,
98 X_Attribute12 VARCHAR2,
99 X_Attribute13 VARCHAR2,
100 X_Attribute14 VARCHAR2,
101 X_Attribute15 VARCHAR2,
102 X_Attribute16 VARCHAR2,
103 X_Attribute17 VARCHAR2,
104 X_Attribute18 VARCHAR2,
105 X_Attribute19 VARCHAR2,
106 X_Attribute20 VARCHAR2
107 );
108
109 PROCEDURE Update_Row(X_Rowid VARCHAR2,
110 X_Organization_Id NUMBER,
111 X_Business_Group_Id NUMBER,
112 X_Cost_Allocation_Keyflex_Id NUMBER,
113 X_Location_Id NUMBER,
114 X_Soft_Coding_Keyflex_Id NUMBER,
115 X_Date_From DATE,
116 X_Name VARCHAR2,
117 X_Comments VARCHAR2,
118 X_Date_To DATE,
119 X_Internal_External_Flag VARCHAR2,
120 X_Internal_Address_Line VARCHAR2,
121 X_Type VARCHAR2,
122 X_Attribute_Category VARCHAR2,
123 X_Attribute1 VARCHAR2,
124 X_Attribute2 VARCHAR2,
125 X_Attribute3 VARCHAR2,
126 X_Attribute4 VARCHAR2,
127 X_Attribute5 VARCHAR2,
128 X_Attribute6 VARCHAR2,
129 X_Attribute7 VARCHAR2,
130 X_Attribute8 VARCHAR2,
131 X_Attribute9 VARCHAR2,
132 X_Attribute10 VARCHAR2,
133 X_Attribute11 VARCHAR2,
134 X_Attribute12 VARCHAR2,
135 X_Attribute13 VARCHAR2,
136 X_Attribute14 VARCHAR2,
137 X_Attribute15 VARCHAR2,
138 X_Attribute16 VARCHAR2,
139 X_Attribute17 VARCHAR2,
140 X_Attribute18 VARCHAR2,
141 X_Attribute19 VARCHAR2,
142 X_Attribute20 VARCHAR2
143 );
144
145 PROCEDURE Delete_Row(X_Rowid VARCHAR2,
146 X_Business_Group_Id NUMBER,
147 X_Organization_Id NUMBER,
148 X_View_All_Orgs VARCHAR2);
149 --
150 PROCEDURE zoom_forms(X_destination IN VARCHAR2
151 ,X_ORGANIZATION_ID IN NUMBER
152 ,X_SOB_ID IN OUT NOCOPY NUMBER
153 ,X_ORG_CODE IN OUT NOCOPY VARCHAR2
154 ,X_CHART_OF_ACCOUNTS IN OUT NOCOPY NUMBER);
155 --
156 PROCEDURE ADD_LANGUAGE;
157 --
158 --------------------------------------------------------------------------------
159 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
160 p_legislation_code IN VARCHAR2);
161 --------------------------------------------------------------------------------
162 --------------------------------------------------------------------------------
163 procedure validate_TRANSLATION (organization_id IN number,
164 language IN varchar2,
165 name IN varchar2,
166 p_business_group_id IN NUMBER DEFAULT NULL);
167 --------------------------------------------------------------------------------
168 function get_org_class (X_Organization_Id NUMBER, X_Organization_Class VARCHAR2)
169 return boolean;
170 --
171 END HR_ORGANIZATION_UNITS_PKG;