[Home] [Help]
Skip to content
PACKAGE: APPS.PA_WORKPLAN_ATTR_PVT
Source
1 PACKAGE PA_WORKPLAN_ATTR_PVT AUTHID CURRENT_USER AS
2 /* $Header: PAPRWPVS.pls 120.1.12010000.2 2009/07/22 12:27:59 gboomina ship $ */
3
4
5
6 -- API name : Create_Proj_Workplan_Attrs
7 -- Type : Private
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
11 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
12 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
14 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
15 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
16 -- p_project_id IN NUMBER Required
17 -- p_proj_element_id IN NUMBER Required
18 -- p_approval_reqd_flag IN VARCHAR2 Required
19 -- p_auto_publish_flag IN VARCHAR2 Required
20 -- p_approver_source_id IN NUMBER Required
21 -- p_approver_source_type IN NUMBER Required
22 -- p_default_display_lvl IN NUMBER Required
23 -- p_enable_wp_version_flag IN VARCHAR2 Required
24 -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required
25 -- p_auto_sync_txn_date_flag IN VARCHAR2 Required
26 -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
27 -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
28 -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
29 -- p_use_task_schedule_flag IN VARCHAR2 Optional
30 -- x_return_status OUT VARCHAR2 Required
31 -- x_msg_count OUT NUMBER Required
32 -- x_msg_data OUT VARCHAR2 Optional
33
34 PROCEDURE CREATE_PROJ_WORKPLAN_ATTRS
35 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
36 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
37 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
38 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
39 ,p_debug_mode IN VARCHAR2 := 'N'
40 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
41 ,p_project_id IN NUMBER
42 ,p_proj_element_id IN NUMBER
43 ,p_approval_reqd_flag IN VARCHAR2
44 ,p_auto_publish_flag IN VARCHAR2
45 ,p_approver_source_id IN NUMBER
46 ,p_approver_source_type IN NUMBER
47 ,p_default_display_lvl IN NUMBER
48 ,p_enable_wp_version_flag IN VARCHAR2
49 ,p_auto_pub_upon_creation_flag IN VARCHAR2
50 ,p_auto_sync_txn_date_flag IN VARCHAR2
51 ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
52 ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
53 ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
54 --bug 3325803: FP M
55 ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
56 ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
57 ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
58 ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
59 -- gboomina bug 8586393 - start
60 ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
61 -- gboomina bug 8586393 - end
62 --bug 3325803: FP M
63 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 );
67
68
69 -- API name : Update_Proj_Workplan_Attrs
70 -- Type : Private
71 -- Pre-reqs : None.
72 -- Parameters :
73 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
74 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
75 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
77 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
78 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
79 -- p_project_id IN NUMBER Required Default = FND_API.G_MISS_NUM
80 -- p_proj_element_id IN NUMBER Required Default = FND_API.G_MISS_NUM
81 -- p_approval_reqd_flag IN VARCHAR2 Required Default = FND_API.G_MISS_NUM
82 -- p_auto_publish_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
83 -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
84 -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
85 -- p_default_display_lvl IN NUMBER Required Default = FND_API.G_MISS_NUM
86 -- p_enable_wp_version_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
87 -- p_auto_pub_upon_creation_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
88 -- p_auto_sync_txn_date_flag IN VARCHAR2 Required Default = FND_API.G_MISS_CHAR
89 -- p_txn_date_sync_buf_days IN NUMBER Optional Default = FND_API.G_MISS_NUM
90 -- p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
91 -- p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
92 -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
93 -- p_use_task_schedule_flag IN NUMBER Optional
94 -- x_return_status OUT VARCHAR2 Required
95 -- x_msg_count OUT NUMBER Required
96 -- x_msg_data OUT VARCHAR2 Optional
97
98 PROCEDURE UPDATE_PROJ_WORKPLAN_ATTRS
99 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
100 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
101 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
102 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
103 ,p_debug_mode IN VARCHAR2 := 'N'
104 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
105 ,p_project_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
106 ,p_proj_element_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
107 ,p_approval_reqd_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
108 ,p_auto_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
109 ,p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
110 ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
111 ,p_default_display_lvl IN NUMBER := FND_API.G_MISS_NUM /* Added for Progress impact bug 3420093 */
112 ,p_enable_wp_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
113 ,p_auto_pub_upon_creation_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
114 ,p_auto_sync_txn_date_flag IN VARCHAR2 := FND_API.G_MISS_CHAR /* Added for Progress impact bug 3420093 */
115 ,p_txn_date_sync_buf_days IN NUMBER := FND_API.G_MISS_NUM
116 ,p_lifecycle_version_id IN NUMBER := FND_API.G_MISS_NUM
117 ,p_current_phase_version_id IN NUMBER := FND_API.G_MISS_NUM
118 --bug 3325803: FP M
119 ,p_allow_lowest_tsk_dep_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
120 ,p_schedule_third_party_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
121 ,p_third_party_schedule_code IN VARCHAR2 := FND_API.G_MISS_CHAR
122 ,p_auto_rollup_subproj_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
123 --bug 3325803: FP M
124 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
125 -- gboomina bug 8586393 - start
126 ,p_use_task_schedule_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
127 -- gboomina bug 8586393 - end
128 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131 );
132
133
134 -- API name : Update_Structure_Name
135 -- Type : Private
136 -- Pre-reqs : None.
137 -- Parameters :
138 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
139 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
140 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
141 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
142 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
143 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
144 -- p_proj_element_id IN NUMBER Required
145 -- p_structure_name IN VARCHAR2 Required
146 -- p_record_version_number IN NUMBER Optional Default = FND_API.G_MISS_NUM
147 -- x_return_status OUT VARCHAR2 Required
148 -- x_msg_count OUT NUMBER Required
149 -- x_msg_data OUT VARCHAR2 Optional
150
151 PROCEDURE UPDATE_STRUCTURE_NAME
152 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
153 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
154 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
155 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
156 ,p_debug_mode IN VARCHAR2 := 'N'
157 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
158 ,p_proj_element_id IN NUMBER
159 ,p_structure_name IN VARCHAR2
160 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
161 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
163 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
164 );
165
166
167 -- API name : Delete_Proj_Workplan_Attrs
168 -- Type : Private
169 -- Pre-reqs : None.
170 -- Parameters :
171 -- p_commit IN VARCHAR2 Required Default = FND_API.G_FALSE
172 -- p_validate_only IN VARCHAR2 Required Default = FND_API.G_TRUE
173 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
174 -- p_calling_module IN VARCHAR2 Optional Default = 'SELF_SERVICE'
175 -- p_debug_mode IN VARCHAR2 Optional Default = 'N'
176 -- p_max_msg_count IN NUMBER Optional Default = FND_API.G_MISS_NUM
177 -- p_project_id IN NUMBER Required
178 -- p_proj_element_id IN NUMBER Required
179 -- p_record_version_number IN NUMBER Required Default = FND_API.G_MISS_NUM
180 -- x_return_status OUT VARCHAR2 Required
181 -- x_msg_count OUT NUMBER Required
182 -- x_msg_data OUT VARCHAR2 Optional
183
184 PROCEDURE DELETE_PROJ_WORKPLAN_ATTRS
185 ( p_commit IN VARCHAR2 := FND_API.G_FALSE
186 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
187 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
188 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
189 ,p_debug_mode IN VARCHAR2 := 'N'
190 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
191 ,p_project_id IN NUMBER
192 ,p_proj_element_id IN NUMBER
193 ,p_record_version_number IN NUMBER := FND_API.G_MISS_NUM
194 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
195 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
196 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
197 );
198
199
200 END PA_WORKPLAN_ATTR_PVT;