1 PACKAGE PA_CONTROL_ITEMS_PUB AS
2 --$Header: PACICIPS.pls 120.1 2007/02/08 11:17:36 sukhanna 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 ,px_ci_id IN OUT NOCOPY NUMBER
68 ,x_ci_number OUT NOCOPY VARCHAR2
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74
75 procedure UPDATE_CONTROL_ITEM (
76 p_api_version IN NUMBER := 1.0
77 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
78 ,p_commit IN VARCHAR2 := FND_API.g_false
79 ,p_validate_only IN VARCHAR2 := FND_API.g_true
80 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
81
82 ,p_ci_id IN NUMBER
83 ,p_ci_type_id IN NUMBER
84 ,p_summary IN VARCHAR2
85 ,p_status_code IN VARCHAR2 := NULL
86 ,p_owner_id IN NUMBER := NULL
87 ,p_owner_name IN VARCHAR2 := NULL
88 ,p_highlighted_flag IN VARCHAR2 := 'N'
89 ,p_progress_status_code IN VARCHAR2
90 ,p_progress_as_of_date IN DATE
91 ,p_classification_code IN NUMBER
92 ,p_reason_code IN NUMBER
93 ,p_record_version_number IN NUMBER
94 ,p_project_id IN NUMBER
95 ,p_object_type IN VARCHAR2 := NULL
96 ,p_object_id IN NUMBER := NULL
97 ,p_object_name IN VARCHAR2 := NULL
98
99 ,p_ci_number IN VARCHAR2 := NULL
100 ,p_date_required IN DATE := NULL
101 ,p_date_closed IN DATE := NULL
102 ,p_closed_by_id IN NUMBER := NULL
103
104 ,p_description IN VARCHAR2 := NULL
105 ,p_status_overview IN VARCHAR2 := NULL
106 ,p_resolution IN VARCHAR2 := NULL
107 ,p_resolution_code IN NUMBER := NULL
108 ,p_priority_code IN VARCHAR2 := NULL
109 ,p_effort_level_code IN VARCHAR2 := NULL
110 ,p_open_action_num IN NUMBER := NULL
111 ,p_price IN NUMBER := NULL
112 ,p_price_currency_code IN VARCHAR2 := NULL
113 ,p_source_type_code IN VARCHAR2 := NULL
114 ,p_source_comment IN VARCHAR2 := NULL
115 ,p_source_number IN VARCHAR2 := NULL
116 ,p_source_date_received IN DATE := NULL
117 ,p_source_organization IN VARCHAR2 := NULL
118 ,p_source_person IN VARCHAR2 := NULL
119
120 ,p_attribute_category IN VARCHAR2 := NULL
121
122 ,p_attribute1 IN VARCHAR2 := NULL
123 ,p_attribute2 IN VARCHAR2 := NULL
124 ,p_attribute3 IN VARCHAR2 := NULL
125 ,p_attribute4 IN VARCHAR2 := NULL
126 ,p_attribute5 IN VARCHAR2 := NULL
127 ,p_attribute6 IN VARCHAR2 := NULL
128 ,p_attribute7 IN VARCHAR2 := NULL
129 ,p_attribute8 IN VARCHAR2 := NULL
130 ,p_attribute9 IN VARCHAR2 := NULL
131 ,p_attribute10 IN VARCHAR2 := NULL
132 ,p_attribute11 IN VARCHAR2 := NULL
133 ,p_attribute12 IN VARCHAR2 := NULL
134 ,p_attribute13 IN VARCHAR2 := NULL
135 ,p_attribute14 IN VARCHAR2 := NULL
136 ,p_attribute15 IN VARCHAR2 := NULL
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140
141 );
142
143 procedure DELETE_CONTROL_ITEM (
144 p_api_version IN NUMBER := 1.0
145 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
146 ,p_commit IN VARCHAR2 := FND_API.g_false
147 ,p_validate_only IN VARCHAR2 := FND_API.g_true
148 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
149
150 ,p_ci_id IN NUMBER
151 ,p_record_version_number IN NUMBER
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2
155 );
156 procedure INCLUDE_CONTROL_ITEM(
157 p_api_version IN NUMBER := 1.0
158 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
159 ,p_commit IN VARCHAR2 := FND_API.g_false
160 ,p_validate_only IN VARCHAR2 := FND_API.g_true
161 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
162
163 ,p_from_ci_id IN NUMBER
164 ,p_to_ci_id IN NUMBER
165 ,p_record_version_number_to IN NUMBER
166 ,x_relationship_id OUT NOCOPY NUMBER
167 ,x_return_status OUT NOCOPY VARCHAR2
168 ,x_msg_count OUT NOCOPY NUMBER
169 ,x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172
173 procedure COPY_CONTROL_ITEM (
174 p_api_version IN NUMBER := 1.0
175 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
176 ,p_commit IN VARCHAR2 := FND_API.g_false
177 ,p_validate_only IN VARCHAR2 := FND_API.g_true
178 ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
179
180 ,p_project_id IN NUMBER
181 ,p_ci_id_from IN NUMBER
182 ,p_ci_type_id IN NUMBER
183 ,p_classification_code_id IN NUMBER
184 ,p_reason_code_id IN NUMBER
185 ,p_include IN VARCHAR2 := 'N'
186 ,p_record_version_number_from IN NUMBER
187 ,x_ci_id OUT NOCOPY NUMBER
188 ,x_ci_number OUT NOCOPY VARCHAR2
189 ,x_return_status OUT NOCOPY VARCHAR2
190 ,x_msg_count OUT NOCOPY NUMBER
191 ,x_msg_data OUT NOCOPY VARCHAR2
192
193 );
194
195 function GET_OBJECT_NAME(p_object_id IN NUMBER
196 ,p_object_type IN VARCHAR2
197 ) return VARCHAR2;
198
199
200 END PA_CONTROL_ITEMS_PUB;