eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PA_ACTIONS_PVT

Source


1 PACKAGE PA_ACTIONS_PVT as
2 /* $Header: PAACTNVS.pls 120.1 2005/08/19 16:14:50 mwasowic noship $ */
3 
4 PROCEDURE CREATE_DLV_ACTIONS_IN_BULK
5      (p_api_version               IN NUMBER    :=1.0
6      ,p_init_msg_list             IN VARCHAR2  :=FND_API.G_TRUE
7      ,p_commit                    IN VARCHAR2  :=FND_API.G_FALSE
8      ,p_validate_only             IN VARCHAR2  :=FND_API.G_TRUE
9      ,p_validation_level          IN NUMBER    :=FND_API.G_VALID_LEVEL_FULL
10      ,p_calling_module            IN VARCHAR2  :='SELF_SERVICE'
11      ,p_debug_mode                IN VARCHAR2  :='N'
12      ,p_max_msg_count             IN NUMBER    :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13      ,p_name_tbl                  IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
14      ,p_manager_person_id_tbl     IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
15      ,p_function_code_tbl         IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
16      ,p_due_date_tbl              IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
17      ,p_completed_flag_tbl        IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
18      ,p_completion_date_tbl       IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
19      ,p_description_tbl           IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE  := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
20      ,p_attribute_category_tbl    IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE  := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
21      ,p_attribute1_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
22      ,p_attribute2_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
23      ,p_attribute3_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
24      ,p_attribute4_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
25      ,p_attribute5_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
26      ,p_attribute6_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
27      ,p_attribute7_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
28      ,p_attribute8_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
29      ,p_attribute9_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
30      ,p_attribute10_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
31      ,p_attribute11_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
32      ,p_attribute12_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
33      ,p_attribute13_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
34      ,p_attribute14_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
35      ,p_attribute15_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
36      ,p_element_version_id_tbl    IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
37      ,p_proj_element_id_tbl       IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
38      ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
39      ,p_project_id                IN PA_PROJECTS_ALL.PROJECT_ID%TYPE  := null
40      ,p_object_id                 IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
41      ,p_object_version_id         IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
42      ,p_object_type               IN PA_LOOKUPS.LOOKUP_CODE%TYPE
43      ,p_pm_source_code            IN pa_proj_elements.pm_source_code%TYPE := null
44      ,p_pm_source_reference       IN pa_proj_elements.pm_source_reference%TYPE := null
45      ,p_pm_source_reference_tbl   IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
46      ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
47      ,x_return_status             OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48      ,x_msg_count                 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49      ,x_msg_data                  OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50      ) ;
51 
52 PROCEDURE UPDATE_DLV_ACTIONS_IN_BULK
53      (p_api_version               IN NUMBER    :=1.0
54      ,p_init_msg_list             IN VARCHAR2  :=FND_API.G_TRUE
55      ,p_commit                    IN VARCHAR2  :=FND_API.G_FALSE
56      ,p_validate_only             IN VARCHAR2  :=FND_API.G_TRUE
57      ,p_validation_level          IN NUMBER    :=FND_API.G_VALID_LEVEL_FULL
58      ,p_calling_module            IN VARCHAR2  :='SELF_SERVICE'
59      ,p_debug_mode                IN VARCHAR2  :='N'
60      ,p_max_msg_count             IN NUMBER    :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
61      ,p_name_tbl                  IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
62      ,p_manager_person_id_tbl     IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
63      ,p_function_code_tbl         IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
64      ,p_due_date_tbl              IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
65      ,p_completed_flag_tbl        IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM. PA_VARCHAR2_1_TBL_TYPE()
66      ,p_completion_date_tbl       IN SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE()
67      ,p_description_tbl           IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE  := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()
68      ,p_attribute_category_tbl    IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE  := SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
69      ,p_attribute1_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
70      ,p_attribute2_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
71      ,p_attribute3_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
72      ,p_attribute4_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
73      ,p_attribute5_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
74      ,p_attribute6_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
75      ,p_attribute7_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
76      ,p_attribute8_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
77      ,p_attribute9_tbl            IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
78      ,p_attribute10_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
79      ,p_attribute11_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
80      ,p_attribute12_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
81      ,p_attribute13_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
82      ,p_attribute14_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
83      ,p_attribute15_tbl           IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
84      ,p_element_version_id_tbl    IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
85      ,p_proj_element_id_tbl       IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
86      ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
87      ,p_project_id                IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
88      ,p_object_id                 IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
89      ,p_object_version_id         IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
90      ,p_object_type               IN PA_LOOKUPS.LOOKUP_CODE%TYPE
91      ,p_pm_source_code            IN pa_proj_elements.pm_source_code%TYPE := null
92      ,p_pm_source_reference       IN pa_proj_elements.pm_source_reference%TYPE := null
93      ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
94      ,x_return_status             OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95      ,x_msg_count                 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
96      ,x_msg_data                  OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97      );
98 
99 PROCEDURE DELETE_DLV_ACTIONS_IN_BULK
100      (p_api_version               IN NUMBER    :=1.0
101      ,p_init_msg_list             IN VARCHAR2  :=FND_API.G_TRUE
102      ,p_commit                    IN VARCHAR2  :=FND_API.G_FALSE
103      ,p_validate_only             IN VARCHAR2  :=FND_API.G_TRUE
104      ,p_validation_level          IN NUMBER    :=FND_API.G_VALID_LEVEL_FULL
105      ,p_calling_module            IN VARCHAR2  :='SELF_SERVICE'
106      ,p_debug_mode                IN VARCHAR2  :='N'
107      ,p_max_msg_count             IN NUMBER  :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
108      ,p_object_type               IN PA_LOOKUPS.LOOKUP_CODE%TYPE
109      ,p_object_id                 IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
110      ,p_element_version_id_tbl    IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
111      ,p_proj_element_id_tbl       IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
112      ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
113      ,x_return_status             OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114      ,x_msg_count                 OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115      ,x_msg_data                  OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116      );
117 
118 PROCEDURE DELETE_DLV_ACTION
119      (p_api_version      IN NUMBER   :=1.0
120      ,p_init_msg_list    IN VARCHAR2 :=FND_API.G_TRUE
121      ,p_commit           IN VARCHAR2 :=FND_API.G_FALSE
122      ,p_validate_only    IN VARCHAR2 :=FND_API.G_TRUE
123      ,p_validation_level IN NUMBER   :=FND_API.G_VALID_LEVEL_FULL
124      ,p_calling_module   IN VARCHAR2 :='SELF_SERVICE'
125      ,p_debug_mode       IN VARCHAR2 :='N'
126      ,p_max_msg_count    IN NUMBER   :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
127      ,p_action_id        IN pa_proj_elements.proj_element_id%TYPE
128      ,p_action_ver_id    IN pa_proj_element_versions.element_version_id%TYPE
129      ,p_dlv_element_id   IN pa_proj_elements.proj_element_id%TYPE
130      ,p_dlv_version_id   IN pa_proj_element_versions.element_version_id%TYPE
131      ,p_function_code    IN pa_proj_elements.function_code%TYPE
132      ,p_project_id       IN pa_projects_all.project_id%TYPE
133      ,x_return_status    OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134      ,x_msg_count        OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135      ,x_msg_data         OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136      ) ;
137 
138 PROCEDURE COPY_ACTIONS
139      (p_api_version         IN NUMBER   :=1.0
140      ,p_init_msg_list       IN VARCHAR2 :=FND_API.G_TRUE
141      ,p_commit              IN VARCHAR2 :=FND_API.G_FALSE
142      ,p_validate_only       IN VARCHAR2 :=FND_API.G_TRUE
143      ,p_validation_level    IN NUMBER   :=FND_API.G_VALID_LEVEL_FULL
144      ,p_calling_module      IN VARCHAR2 :='SELF_SERVICE'
145      ,p_debug_mode          IN VARCHAR2 :='N'
146      ,p_max_msg_count       IN NUMBER   :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147      ,p_source_object_id    IN pa_object_relationships.object_id_from2%TYPE
148      ,p_source_object_type  IN pa_object_relationships.object_type_from%TYPE
149      ,p_target_object_id    IN pa_object_relationships.object_id_from2%TYPE
150      ,p_target_object_type  IN pa_object_relationships.object_type_from%TYPE
151      ,p_source_project_id   IN pa_projects_all.project_id%TYPE
152      ,p_target_project_id   IN pa_projects_all.project_id%TYPE
153      ,p_task_id             IN pa_proj_elements.proj_element_id%TYPE := null
154      ,p_task_ver_id         IN pa_proj_element_versions.element_version_id%TYPE := null
155      ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
156      ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
157      ,p_pm_source_code      IN pa_proj_elements.pm_source_code%TYPE := null
158      ,p_calling_mode        IN VARCHAR2 := NULL     -- added for bug# 3911050
159      ,x_return_status       OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
160      ,x_msg_count           OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
161      ,x_msg_data            OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162      )  ;
163 
164 PROCEDURE IS_DELETE_ACTION_ALLOWED
165      (p_api_version      IN NUMBER   :=1.0
166      ,p_init_msg_list    IN VARCHAR2 :=FND_API.G_TRUE
167      ,p_commit           IN VARCHAR2 :=FND_API.G_FALSE
168      ,p_validate_only    IN VARCHAR2 :=FND_API.G_TRUE
169      ,p_validation_level IN NUMBER   :=FND_API.G_VALID_LEVEL_FULL
170      ,p_calling_module   IN VARCHAR2 :='SELF_SERVICE'
171      ,p_debug_mode       IN VARCHAR2 :='N'
172      ,p_max_msg_count    IN NUMBER   :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
173      ,p_action_id        IN pa_proj_elements.proj_element_id%TYPE
174      ,p_action_ver_id    IN pa_proj_element_versions.element_version_id%TYPE
175      ,p_dlv_element_id   IN pa_proj_elements.proj_element_id%TYPE
179      ,x_action_del_allowed IN VARCHAR2
176      ,p_dlv_version_id   IN pa_proj_element_versions.element_version_id%TYPE
177      ,p_function_code    IN pa_proj_elements.function_code%TYPE
178      ,p_project_id       IN pa_projects_all.project_id%TYPE
180      ,x_return_status   OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181      ,x_msg_count       OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
182      ,x_msg_data        OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
183      ) ;
184 
185 END PA_ACTIONS_PVT;