[Home] [Help]
PACKAGE: APPS.PA_ACTIONS_PUB
Source
1 PACKAGE PA_ACTIONS_PUB AUTHID DEFINER as
2 /* $Header: PAACTNPS.pls 120.1 2005/08/19 16:14:41 mwasowic noship $ */
3
4 l_event_in_tbl PA_EVENT_PUB.event_in_tbl_type;
5 l_event_out_tbl PA_EVENT_PUB.event_out_tbl_type;
6
7 l_dlv_ship_action_rec oke_amg_grp.dlv_ship_action_rec_type;
8 l_dlv_req_action_rec oke_amg_grp.dlv_req_action_rec_type;
9 l_dlv_ship_action_rec_b oke_amg_grp.dlv_ship_action_rec_type;
10 l_dlv_req_action_rec_b oke_amg_grp.dlv_req_action_rec_type;
11
12 TYPE dlv_ship_action_tbl_type IS TABLE OF oke_amg_grp.dlv_ship_action_rec_type INDEX BY BINARY_INTEGER;
13 TYPE dlv_req_action_tbl_type IS TABLE OF oke_amg_grp.dlv_req_action_rec_type INDEX BY BINARY_INTEGER;
14
15 --Package constant used for package version validation
16
17 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
18 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_ACTIONS_PUB';
19
20 PROCEDURE Create_Dlvr_Actions_Wrapper
21 ( p_api_version IN NUMBER :=1.0
22 , p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
23 , p_commit IN VARCHAR2 :=FND_API.G_FALSE
24 , p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
25 , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
26 , p_calling_module IN VARCHAR2 :='AMG'
27 , p_debug_mode IN VARCHAR2 :='N'
28 , p_insert_or_update IN VARCHAR2 := 'INSERT'
29 , p_action_in_tbl IN PA_PROJECT_PUB.action_in_tbl_type
30 , x_action_out_tbl OUT NOCOPY PA_PROJECT_PUB.action_out_tbl_type --File.Sql.39 bug 4440895
31 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33 , x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
34
35
36 PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
37 (p_api_version IN NUMBER :=1.0
38 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
39 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
40 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
41 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
42 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
43 ,p_debug_mode IN VARCHAR2 :='N'
44 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45 ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
46 ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
47 ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
48 ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
49 ,p_completed_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
50 ,p_completion_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
51 ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
52 ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
53 ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
54 ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
55 ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
56 ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
57 ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
58 ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
59 ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
60 ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
61 ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
62 ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
63 ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
64 ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
65 ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
66 ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
67 ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
68 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
69 ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
70 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
71 ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
72 ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
73 ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
74 ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
75 ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
76 ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
77 ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
78 ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
79 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
80 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
81 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82 ) ;
83
84 PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
85 (p_api_version IN NUMBER :=1.0
86 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
87 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
88 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
89 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
90 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
91 ,p_debug_mode IN VARCHAR2 :='N'
92 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
93 ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
94 ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
95 ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
96 ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
97 ,p_completed_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
98 ,p_completion_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
99 ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
100 ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
101 ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
102 ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
103 ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
104 ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
105 ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
106 ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
107 ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
108 ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
109 ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
110 ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
111 ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
112 ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
113 ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
114 ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
115 ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
116 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
117 ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
118 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
119 ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
120 ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694, added default value
121 ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
122 ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
123 ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
124 ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
125 ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
126 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
128 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129 );
130
131 PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
132 (p_api_version IN NUMBER :=1.0
133 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
134 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
135 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
136 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
137 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
138 ,p_debug_mode IN VARCHAR2 :='N'
139 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140 ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
141 ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
142 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
143 ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
144 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
145 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
146 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
147 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
148 );
149
150 PROCEDURE VALIDATE_ACTIONS
151 (p_api_version IN NUMBER :=1.0
152 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
153 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
154 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
155 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
156 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
157 ,p_debug_mode IN VARCHAR2 :='N'
158 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
159 ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
160 ,p_completed_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
161 ,p_completion_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
162 ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
163 ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
164 ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
165 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
166 ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
167 ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
168 ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
169 ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
170 ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
171 ,p_action_owner_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
172 ,p_carrying_out_org_id IN NUMBER := null
173 ,p_action_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
174 ,p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := null
175 ,p_insert_or_update IN VARCHAR2 := 'INSERT'
176 ,p_project_id IN pa_projects_all.project_id%TYPE --Included by avaithia for Bug 3512346
177 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
178 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
179 ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
180
181 PROCEDURE CR_UP_DLV_ACTIONS_IN_BULK
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_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
187 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
188 ,p_debug_mode IN VARCHAR2 :='N'
189 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
190 ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
191 ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
192 ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
193 ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
194 ,p_completed_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
195 ,p_completion_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
196 ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
197 ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
198 ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
199 ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
200 ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
201 ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
202 ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
203 ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
204 ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
205 ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
206 ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
207 ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
208 ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
209 ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
210 ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
211 ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
212 ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
213 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
214 ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
215 ,p_user_action_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
216 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
217 ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
218 ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
219 ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
220 ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
221 ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
222 ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
223 ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
224 ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
225 ,p_insert_or_update IN VARCHAR2 := 'INSERT'
226 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
228 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
229 );
230
231 PROCEDURE DELETE_DLV_ACTION
232 (p_api_version IN NUMBER :=1.0
233 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
234 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
235 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
236 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
237 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
238 ,p_debug_mode IN VARCHAR2 :='N'
239 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
240 ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
241 ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
242 ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
243 ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
244 ,p_function_code IN pa_proj_elements.function_code%TYPE
245 ,p_project_id IN pa_projects_all.project_id%TYPE
246 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
248 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
249 ) ;
250
251
252 PROCEDURE COPY_ACTIONS
253 (p_api_version IN NUMBER :=1.0
254 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
255 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
256 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
257 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
258 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
259 ,p_debug_mode IN VARCHAR2 :='N'
260 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
261 ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
262 ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
263 ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
264 ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
265 ,p_source_project_id IN pa_projects_all.project_id%TYPE
266 ,p_target_project_id IN pa_projects_all.project_id%TYPE
267 ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
268 ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
269 ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
270 ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
271 ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
272 ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
273 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
275 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
276 ) ;
277
278 PROCEDURE RUN_ACTION_CONC_PROCESS
279 (
280 errbuf OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
281 ,retcode OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
282 ,p_function IN pa_lookups.lookup_code%TYPE
283 ,p_project_number_from IN pa_projects_all.segment1%TYPE :=NULL
284 ,p_project_number_to IN pa_projects_all.segment1%TYPE :=NULL
285 );
286
287 -- 3578694 added
288 PROCEDURE UPD_DLV_ACTIONS_IN_BULK_TM
289 (p_api_version IN NUMBER :=1.0
290 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
291 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
292 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
293 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
294 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
295 ,p_debug_mode IN VARCHAR2 :='N'
296 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
297 ,p_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
298 ,p_manager_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
299 ,p_function_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
300 ,p_due_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
301 ,p_completed_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
302 ,p_completion_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
303 ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
304 ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
305 ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
306 ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
307 ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
308 ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
309 ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
310 ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
311 ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
312 ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
313 ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
314 ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
315 ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
316 ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
317 ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
318 ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
319 ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
320 ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
321 ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
322 ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
323 ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
324 ,p_object_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
325 ,p_object_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
326 ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
327 ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
328 ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
329 ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
330 ,p_insert_or_update IN VARCHAR2 := 'UPDATE'
331 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
332 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
336 PROCEDURE RUN_ACTION_CONC_PROCESS_WRP
333 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
334 );
335
337 (
338 p_api_version IN NUMBER :=1.0
339 ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
340 ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
341 ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
342 ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
343 ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
344 ,p_debug_mode IN VARCHAR2 :='N'
345 ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
346 ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
347 ,p_project_number IN PA_PROJECTS_ALL.SEGMENT1%TYPE -- 3671408 added IN parameter
348 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
349 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
350 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
351 );
352
353 PROCEDURE RUN_ACTION_CONC_FRM_WRP
354 (
355 p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
356 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
357 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
358 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
359 );
360
361 END PA_ACTIONS_PUB;