1 PACKAGE PA_CONTROL_ITEMS_PUB AUTHID CURRENT_USER AS
2 --$Header: PACICIPS.pls 120.8.12020000.2 2012/07/19 09:29:00 admarath ship $
3
4
5 procedure ADD_CONTROL_ITEM (
6 p_api_version IN NUMBER := 1.0
7 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
8 ,p_commit IN VARCHAR2 := FND_API.g_false
9 ,p_validate_only IN VARCHAR2 := FND_API.g_true
10 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
11
12 ,p_ci_type_id IN NUMBER
13 ,p_summary IN VARCHAR2
14 ,p_status_code IN VARCHAR2
15 ,p_owner_id IN NUMBER := NULL
16 ,p_owner_name IN VARCHAR2 := NULL
17 ,p_highlighted_flag IN VARCHAR2 := 'N'
18 ,p_progress_status_code IN VARCHAR2 := NULL
19 ,p_progress_as_of_date IN DATE := NULL
20 ,p_classification_code IN NUMBER
21 ,p_reason_code IN NUMBER
22 ,p_project_id IN NUMBER
23 ,p_object_type IN VARCHAR2 := NULL
24 ,p_object_id IN NUMBER := NULL
25 ,p_object_name IN VARCHAR2 := NULL
26
27 ,p_ci_number IN VARCHAR2 := NULL
28 ,p_date_required IN DATE := NULL
29 ,p_date_closed IN DATE := NULL
30 ,p_closed_by_id IN NUMBER := NULL
31
32 ,p_description IN VARCHAR2 := NULL
33 ,p_status_overview IN VARCHAR2 := NULL
34 ,p_resolution IN VARCHAR2 := NULL
35 ,p_resolution_code IN NUMBER := NULL
36 ,p_priority_code IN VARCHAR2 := NULL
37 ,p_effort_level_code IN VARCHAR2 := NULL
38 ,p_open_action_num IN NUMBER := NULL
39
40 ,p_price IN NUMBER := NULL
41 ,p_price_currency_code IN VARCHAR2 := NULL
42 ,p_source_type_code IN VARCHAR2 := NULL
43 ,p_source_comment IN VARCHAR2 := NULL
44 ,p_source_number IN VARCHAR2 := NULL
45 ,p_source_date_received IN DATE := NULL
46
47 ,p_source_organization IN VARCHAR2 := NULL
48 ,p_source_person IN VARCHAR2 := NULL
49
50 ,p_attribute_category IN VARCHAR2 := NULL
51 ,p_attribute1 IN VARCHAR2 := NULL
52
53 ,p_attribute2 IN VARCHAR2 := NULL
54 ,p_attribute3 IN VARCHAR2 := NULL
55 ,p_attribute4 IN VARCHAR2 := NULL
56 ,p_attribute5 IN VARCHAR2 := NULL
57 ,p_attribute6 IN VARCHAR2 := NULL
58 ,p_attribute7 IN VARCHAR2 := NULL
59 ,p_attribute8 IN VARCHAR2 := NULL
60 ,p_attribute9 IN VARCHAR2 := NULL
61 ,p_attribute10 IN VARCHAR2 := NULL
62 ,p_attribute11 IN VARCHAR2 := NULL
63 ,p_attribute12 IN VARCHAR2 := NULL
64 ,p_attribute13 IN VARCHAR2 := NULL
65 ,p_attribute14 IN VARCHAR2 := NULL
66 ,p_attribute15 IN VARCHAR2 := NULL
67
68 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
69 ,p_PCO_STATUS_CODE IN VARCHAR2 := NULL
70 ,p_APPROVAL_TYPE_CODE IN VARCHAR2 := NULL
71 ,p_LOCKED_FLAG IN VARCHAR2 := 'N'
72 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
73
74 ,p_Version_number IN number default null
75 ,p_Current_Version_flag IN varchar2 := 'Y'
76 ,p_Version_Comments IN varchar2 := NULL
77 ,p_Original_ci_id IN number := NULL
78 ,p_Source_ci_id IN number := NULL
79 ,px_ci_id IN OUT NOCOPY NUMBER
80 ,x_ci_number OUT NOCOPY VARCHAR2
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84 );
85
86
87 procedure UPDATE_CONTROL_ITEM (
88 p_api_version IN NUMBER := 1.0
89 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
90 ,p_commit IN VARCHAR2 := FND_API.g_false
91 ,p_validate_only IN VARCHAR2 := FND_API.g_true
92 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
93
94 ,p_ci_id IN NUMBER
95 ,p_ci_type_id IN NUMBER
96 ,p_summary IN VARCHAR2
97 ,p_status_code IN VARCHAR2 := NULL
98 ,p_owner_id IN NUMBER := NULL
99 ,p_owner_name IN VARCHAR2 := NULL
100 ,p_highlighted_flag IN VARCHAR2 := 'N'
101 ,p_progress_status_code IN VARCHAR2
102 ,p_progress_as_of_date IN DATE
103 ,p_classification_code IN NUMBER
104 ,p_reason_code IN NUMBER
105 ,p_record_version_number IN NUMBER
106 ,p_project_id IN NUMBER
107 ,p_object_type IN VARCHAR2 := NULL
108 ,p_object_id IN NUMBER := NULL
109 ,p_object_name IN VARCHAR2 := NULL
110
111 ,p_ci_number IN VARCHAR2 := NULL
112 ,p_date_required IN DATE := NULL
113 ,p_date_closed IN DATE := NULL
114 ,p_closed_by_id IN NUMBER := NULL
115
116 ,p_description IN VARCHAR2 := NULL
117 ,p_status_overview IN VARCHAR2 := NULL
118 ,p_resolution IN VARCHAR2 := NULL
119 ,p_resolution_code IN NUMBER := NULL
120 ,p_priority_code IN VARCHAR2 := NULL
121 ,p_effort_level_code IN VARCHAR2 := NULL
122 ,p_open_action_num IN NUMBER := NULL
123 ,p_price IN NUMBER := NULL
124 ,p_price_currency_code IN VARCHAR2 := NULL
125 ,p_source_type_code IN VARCHAR2 := NULL
126 ,p_source_comment IN VARCHAR2 := NULL
127 ,p_source_number IN VARCHAR2 := NULL
128 ,p_source_date_received IN DATE := NULL
129 ,p_source_organization IN VARCHAR2 := NULL
130 ,p_source_person IN VARCHAR2 := NULL
131
132 ,p_attribute_category IN VARCHAR2 := NULL
133
134 ,p_attribute1 IN VARCHAR2 := NULL
135 ,p_attribute2 IN VARCHAR2 := NULL
136 ,p_attribute3 IN VARCHAR2 := NULL
137 ,p_attribute4 IN VARCHAR2 := NULL
138 ,p_attribute5 IN VARCHAR2 := NULL
139 ,p_attribute6 IN VARCHAR2 := NULL
140 ,p_attribute7 IN VARCHAR2 := NULL
141 ,p_attribute8 IN VARCHAR2 := NULL
142 ,p_attribute9 IN VARCHAR2 := NULL
143 ,p_attribute10 IN VARCHAR2 := NULL
144 ,p_attribute11 IN VARCHAR2 := NULL
145 ,p_attribute12 IN VARCHAR2 := NULL
146 ,p_attribute13 IN VARCHAR2 := NULL
147 ,p_attribute14 IN VARCHAR2 := NULL
148 ,p_attribute15 IN VARCHAR2 := NULL
149
150 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
151 ,p_PCO_STATUS_CODE IN VARCHAR2 := NULL
152 ,p_APPROVAL_TYPE_CODE IN VARCHAR2 := NULL
153 ,p_LOCKED_FLAG IN VARCHAR2 := 'N'
154 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
155
156 ,p_Version_number IN number := null
157 ,p_Current_Version_flag IN varchar2 := 'Y'
158 ,p_Version_Comments IN varchar2 := NULL
159 ,p_Original_ci_id IN number := NULL
160 ,p_Source_ci_id IN number := NULL
161 ,p_change_approver IN varchar2 :=NULL
162 ,x_return_status OUT NOCOPY VARCHAR2
163 ,x_msg_count OUT NOCOPY NUMBER
164 ,x_msg_data OUT NOCOPY VARCHAR2
165
166 );
167
168 procedure DELETE_CONTROL_ITEM (
169 p_api_version IN NUMBER := 1.0
170 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
171 ,p_commit IN VARCHAR2 := FND_API.g_false
172 ,p_validate_only IN VARCHAR2 := FND_API.g_true
173 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
174
175 ,p_ci_id IN NUMBER
176 ,p_record_version_number IN NUMBER
177 ,x_return_status OUT NOCOPY VARCHAR2
178 ,x_msg_count OUT NOCOPY NUMBER
179 ,x_msg_data OUT NOCOPY VARCHAR2
180 );
181 procedure INCLUDE_CONTROL_ITEM(
182 p_api_version IN NUMBER := 1.0
183 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
184 ,p_commit IN VARCHAR2 := FND_API.g_false
185 ,p_validate_only IN VARCHAR2 := FND_API.g_true
186 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
187
188 ,p_from_ci_id IN NUMBER
189 ,p_to_ci_id IN NUMBER
190 ,p_record_version_number_to IN NUMBER
191 ,x_relationship_id OUT NOCOPY NUMBER
192 ,x_return_status OUT NOCOPY VARCHAR2
193 ,x_msg_count OUT NOCOPY NUMBER
194 ,x_msg_data OUT NOCOPY VARCHAR2
195 );
196
197
198 procedure COPY_CONTROL_ITEM (
199 p_api_version IN NUMBER := 1.0
200 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
201 ,p_commit IN VARCHAR2 := FND_API.g_false
202 ,p_validate_only IN VARCHAR2 := FND_API.g_true
203 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
204
205 ,p_project_id IN NUMBER
206 ,p_ci_id_from IN NUMBER
207 ,p_ci_type_id IN NUMBER
208 ,p_classification_code_id IN NUMBER
209 ,p_reason_code_id IN NUMBER
210 ,p_include IN VARCHAR2 := 'N'
211 ,p_record_version_number_from IN NUMBER
212 ,x_ci_id OUT NOCOPY NUMBER
213 ,p_ci_number IN OUT NOCOPY VARCHAR2
214 ,x_return_status OUT NOCOPY VARCHAR2
215 ,x_msg_count OUT NOCOPY NUMBER
216 ,x_msg_data OUT NOCOPY VARCHAR2
217
218 );
219
220 function GET_OBJECT_NAME(p_object_id IN NUMBER
221 ,p_object_type IN VARCHAR2
222 ) return VARCHAR2;
223
224 -- start: 26-Jun-2009 cklee Modified for the Bug# 8633676
225 procedure LOCK_CONTROL_ITEM (
226 p_api_version IN NUMBER := 1.0
227 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
228 ,p_commit IN VARCHAR2 := FND_API.g_false
229 ,p_validate_only IN VARCHAR2 := FND_API.g_true
230 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
231 ,p_ci_id IN NUMBER
232 ,x_return_status OUT NOCOPY VARCHAR2
233 ,x_msg_count OUT NOCOPY NUMBER
234 ,x_msg_data OUT NOCOPY VARCHAR2
235 );
236 -- end: 26-Jun-2009 cklee Modified for the Bug# 8633676
237
238
239 END PA_CONTROL_ITEMS_PUB;
[Home] [Help]