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