1 Package hr_organization_bk4 as
2 /* $Header: hrorgapi.pkh 120.13.12010000.3 2008/09/30 09:34:01 ktithy ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< update_organization >-----------------------|
6 -- ----------------------------------------------------------------------------
7 --
8
9 PROCEDURE update_organization_a
10 (p_effective_date IN DATE
11 ,p_language_code IN VARCHAR2
12 ,p_name IN VARCHAR2
13 ,p_organization_id IN NUMBER
14 ,p_cost_allocation_keyflex_id IN NUMBER
15 ,p_location_id IN NUMBER
16 -- Bug 3040119
17 --,p_soft_coding_keyflex_id IN NUMBER
18 ,p_date_from IN DATE
19 ,p_date_to IN DATE
20 ,p_internal_external_flag IN VARCHAR2
21 ,p_internal_address_line IN VARCHAR2
22 ,p_type IN VARCHAR2
23 ,p_attribute_category IN VARCHAR2
24 ,p_attribute1 IN VARCHAR2
25 ,p_attribute2 IN VARCHAR2
26 ,p_attribute3 IN VARCHAR2
27 ,p_attribute4 IN VARCHAR2
28 ,p_attribute5 IN VARCHAR2
29 ,p_attribute6 IN VARCHAR2
30 ,p_attribute7 IN VARCHAR2
31 ,p_attribute8 IN VARCHAR2
32 ,p_attribute9 IN VARCHAR2
33 ,p_attribute10 IN VARCHAR2
34 ,p_attribute11 IN VARCHAR2
35 ,p_attribute12 IN VARCHAR2
36 ,p_attribute13 IN VARCHAR2
37 ,p_attribute14 IN VARCHAR2
38 ,p_attribute15 IN VARCHAR2
39 ,p_attribute16 IN VARCHAR2
40 ,p_attribute17 IN VARCHAR2
41 ,p_attribute18 IN VARCHAR2
42 ,p_attribute19 IN VARCHAR2
43 ,p_attribute20 IN VARCHAR2
44 -- Enhancement 4040086
45 ,p_attribute21 IN VARCHAR2
46 ,p_attribute22 IN VARCHAR2
47 ,p_attribute23 IN VARCHAR2
48 ,p_attribute24 IN VARCHAR2
49 ,p_attribute25 IN VARCHAR2
50 ,p_attribute26 IN VARCHAR2
51 ,p_attribute27 IN VARCHAR2
52 ,p_attribute28 IN VARCHAR2
53 ,p_attribute29 IN VARCHAR2
54 ,p_attribute30 IN VARCHAR2
55 --End Enhancement 4040086
56 -- Bug 3039046
57 ,p_segment1 IN VARCHAR2
58 ,p_segment2 IN VARCHAR2
59 ,p_segment3 IN VARCHAR2
60 ,p_segment4 IN VARCHAR2
61 ,p_segment5 IN VARCHAR2
62 ,p_segment6 IN VARCHAR2
63 ,p_segment7 IN VARCHAR2
64 ,p_segment8 IN VARCHAR2
65 ,p_segment9 IN VARCHAR2
66 ,p_segment10 IN VARCHAR2
67 ,p_segment11 IN VARCHAR2
68 ,p_segment12 IN VARCHAR2
69 ,p_segment13 IN VARCHAR2
70 ,p_segment14 IN VARCHAR2
71 ,p_segment15 IN VARCHAR2
72 ,p_segment16 IN VARCHAR2
73 ,p_segment17 IN VARCHAR2
74 ,p_segment18 IN VARCHAR2
75 ,p_segment19 IN VARCHAR2
76 ,p_segment20 IN VARCHAR2
77 ,p_segment21 IN VARCHAR2
78 ,p_segment22 IN VARCHAR2
79 ,p_segment23 IN VARCHAR2
80 ,p_segment24 IN VARCHAR2
81 ,p_segment25 IN VARCHAR2
82 ,p_segment26 IN VARCHAR2
83 ,p_segment27 IN VARCHAR2
84 ,p_segment28 IN VARCHAR2
85 ,p_segment29 IN VARCHAR2
86 ,p_segment30 IN VARCHAR2
87 ,p_concat_segments IN VARCHAR2
88 ,p_cost_name IN VARCHAR2
89 --
90 ,p_object_version_number IN NUMBER
91 ,p_duplicate_org_warning in boolean
92 );
93
94 PROCEDURE update_organization_b
95 (p_effective_date IN DATE
96 ,p_language_code IN VARCHAR2
97 ,p_name IN VARCHAR2
98 ,p_organization_id IN NUMBER
99 ,p_cost_allocation_keyflex_id IN NUMBER
100 ,p_location_id IN NUMBER
101 -- Bug 3040119
102 --,p_soft_coding_keyflex_id IN NUMBER
103 ,p_date_from IN DATE
104 ,p_date_to IN DATE
105 ,p_internal_external_flag IN VARCHAR2
106 ,p_internal_address_line IN VARCHAR2
107 ,p_type IN VARCHAR2
108 ,p_attribute_category IN VARCHAR2
109 ,p_attribute1 IN VARCHAR2
110 ,p_attribute2 IN VARCHAR2
111 ,p_attribute3 IN VARCHAR2
112 ,p_attribute4 IN VARCHAR2
113 ,p_attribute5 IN VARCHAR2
114 ,p_attribute6 IN VARCHAR2
115 ,p_attribute7 IN VARCHAR2
116 ,p_attribute8 IN VARCHAR2
117 ,p_attribute9 IN VARCHAR2
118 ,p_attribute10 IN VARCHAR2
119 ,p_attribute11 IN VARCHAR2
120 ,p_attribute12 IN VARCHAR2
121 ,p_attribute13 IN VARCHAR2
122 ,p_attribute14 IN VARCHAR2
123 ,p_attribute15 IN VARCHAR2
124 ,p_attribute16 IN VARCHAR2
125 ,p_attribute17 IN VARCHAR2
126 ,p_attribute18 IN VARCHAR2
127 ,p_attribute19 IN VARCHAR2
128 ,p_attribute20 IN VARCHAR2
129 -- Enhancement 4040086
130 ,p_attribute21 IN VARCHAR2
131 ,p_attribute22 IN VARCHAR2
132 ,p_attribute23 IN VARCHAR2
133 ,p_attribute24 IN VARCHAR2
134 ,p_attribute25 IN VARCHAR2
135 ,p_attribute26 IN VARCHAR2
136 ,p_attribute27 IN VARCHAR2
137 ,p_attribute28 IN VARCHAR2
138 ,p_attribute29 IN VARCHAR2
139 ,p_attribute30 IN VARCHAR2
140 --End Enhancement 4040086
141 -- Bug 3039046
142 ,p_segment1 IN VARCHAR2
143 ,p_segment2 IN VARCHAR2
144 ,p_segment3 IN VARCHAR2
145 ,p_segment4 IN VARCHAR2
146 ,p_segment5 IN VARCHAR2
147 ,p_segment6 IN VARCHAR2
148 ,p_segment7 IN VARCHAR2
149 ,p_segment8 IN VARCHAR2
150 ,p_segment9 IN VARCHAR2
151 ,p_segment10 IN VARCHAR2
152 ,p_segment11 IN VARCHAR2
153 ,p_segment12 IN VARCHAR2
154 ,p_segment13 IN VARCHAR2
155 ,p_segment14 IN VARCHAR2
156 ,p_segment15 IN VARCHAR2
157 ,p_segment16 IN VARCHAR2
158 ,p_segment17 IN VARCHAR2
159 ,p_segment18 IN VARCHAR2
160 ,p_segment19 IN VARCHAR2
161 ,p_segment20 IN VARCHAR2
162 ,p_segment21 IN VARCHAR2
163 ,p_segment22 IN VARCHAR2
164 ,p_segment23 IN VARCHAR2
165 ,p_segment24 IN VARCHAR2
166 ,p_segment25 IN VARCHAR2
167 ,p_segment26 IN VARCHAR2
168 ,p_segment27 IN VARCHAR2
169 ,p_segment28 IN VARCHAR2
170 ,p_segment29 IN VARCHAR2
171 ,p_segment30 IN VARCHAR2
172 ,p_concat_segments IN VARCHAR2
173 --
174 ,p_object_version_number IN NUMBER
175 );
176 end hr_organization_bk4;