[Home] [Help]
PACKAGE: APPS.FPA_PROCESS_PVT
Source
1 PACKAGE fpa_process_pvt as
2 /* $Header: FPAVPRCS.pls 120.2 2005/11/22 13:51:04 appldev noship $ */
3
4 /************************************************************************************/
5 -- PC procedures
6
7 PROCEDURE Create_Pc
8 ( p_api_version IN NUMBER,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_pc_all_obj IN fpa_pc_all_obj,
11 x_planning_cycle_id OUT NOCOPY NUMBER,
12 x_return_status OUT NOCOPY VARCHAR2,
13 x_msg_data OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER );
15
16 PROCEDURE Update_Pc
17 ( p_api_version IN NUMBER,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_pc_all_obj IN fpa_pc_all_obj,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER );
23
24 PROCEDURE Set_Pc_Initiate
25 ( p_api_version IN NUMBER,
26 p_commit IN VARCHAR2 := FND_API.G_FALSE,
27 p_pc_id IN NUMBER,
28 p_pc_name IN VARCHAR2,
29 p_pc_desc IN VARCHAR2,
30 p_sub_due_date IN DATE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_msg_count OUT NOCOPY NUMBER );
34
35 PROCEDURE Pa_Dist_List_Items_Delete_Row (
36 p_api_version IN NUMBER,
37 p_commit IN VARCHAR2 := FND_API.G_FALSE,
38 P_LIST_ITEM_ID IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER );
42
43
44 /************************************************************************************/
45 -- Portfolio procedure
46 PROCEDURE Create_Portfolio
47 (
48 p_api_version IN NUMBER,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_portfolio_obj IN FPA_PORTFO_ALL_OBJ,
51 x_portfolio_id OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER
55 );
56
57
58 portfolio_rec FPA_Portfolio_PVT.portfolio_rec_type;
59
60 PROCEDURE Update_Portfolio
61 (
62 p_api_version IN NUMBER,
63 p_commit IN VARCHAR2 := FND_API.G_FALSE,
64 p_portfolio_obj IN FPA_PORTFO_ALL_OBJ,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER
68 );
69
70 PROCEDURE delete_Portfolio_user
71 (
72 p_api_version IN NUMBER,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_project_party_id IN NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER
78 );
79
80 PROCEDURE Delete_Portfolio
81 (
82 p_api_version IN NUMBER,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_portfolio_id IN NUMBER,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_data OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER
88 ) ;
89
90 /************************************************************************************/
91 -- Collect projects procedures
92
93
94 PROCEDURE Collect_Projects
95 ( p_api_version IN NUMBER,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_pc_id IN NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER
101 );
102
103
104 PROCEDURE Add_Projects
105 ( p_api_version IN NUMBER,
106 p_commit IN VARCHAR2,
107 p_scenario_id IN NUMBER,
108 p_proj_id_str IN varchar2,
109 p_project_source IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER
113 );
114
115 PROCEDURE Refresh_Projects
116 ( p_api_version IN NUMBER,
117 p_commit IN VARCHAR2,
118 p_scenario_id IN NUMBER,
119 p_proj_id_str IN varchar2,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER
123 );
124
125 PROCEDURE Remove_Projects
126 ( p_api_version IN NUMBER,
127 p_commit IN VARCHAR2,
128 p_scenario_id IN NUMBER,
129 p_proj_id IN NUMBER,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER
133 );
134
135
136 PROCEDURE update_strategicobj_weight
137 ( p_api_version IN NUMBER
138 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
139 ,p_strategic_weights_string IN varchar2
140 ,x_return_status OUT NOCOPY varchar2
141 ,x_msg_count OUT NOCOPY number
142 ,x_msg_data OUT NOCOPY varchar2
143 );
144
145 PROCEDURE update_strategicobj
146 ( p_api_version IN NUMBER,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE,
148 p_strategic_obj_id IN NUMBER,
149 p_strategic_obj_name IN VARCHAR2,
150 p_strategic_obj_desc IN VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2
154 );
155
156 PROCEDURE create_strategicobj
157 ( p_api_version IN NUMBER,
158 p_commit IN VARCHAR2 := FND_API.G_FALSE,
159 p_strategic_obj_name IN VARCHAR2,
160 p_strategic_obj_desc IN VARCHAR2,
161 p_strategic_obj_parent IN number,
162 p_strategic_obj_level IN varchar2,
163 x_return_status OUT NOCOPY varchar2,
164 x_msg_count OUT NOCOPY number,
165 x_msg_data OUT NOCOPY varchar2
166 );
167
168 PROCEDURE delete_strategicobj
169 ( p_api_version IN NUMBER,
170 p_commit IN VARCHAR2 := FND_API.G_FALSE,
171 p_strategic_obj_shortname IN VARCHAR2,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2
175 );
176
177 PROCEDURE create_scenario
178 (
179 p_commit IN VARCHAR2 := FND_API.G_FALSE,
180 p_api_version IN NUMBER,
181 p_scenario_id_source IN NUMBER,
182 p_pc_id IN NUMBER,
183 p_scenario_name IN VARCHAR2,
184 p_scenario_desc IN VARCHAR2,
185 p_copy_proposed_proj IN VARCHAR2,
186 p_sce_disc_rate IN VARCHAR2,
187 p_sce_funds_avail IN VARCHAR2,
188 x_scenario_id 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 procedure set_scenario_action_flag
195 (
196 p_commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_api_version IN NUMBER,
198 p_scenario_id IN NUMBER,
199 p_scenario_action IN VARCHAR2,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2
203 );
204
205 procedure update_scenario_reccom_status
206 (
207 p_commit IN VARCHAR2 := FND_API.G_FALSE,
208 p_api_version IN NUMBER,
209 p_scenario_id IN NUMBER,
210 p_project_id IN VARCHAR2,
211 p_scenario_reccom_value IN VARCHAR2,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2
215 );
216
217 PROCEDURE Submit_Project_Aw
218 ( p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
221 p_project_id IN NUMBER,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2);
225
226 PROCEDURE Load_Project_Details_Aw
227 (
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
230 p_commit IN VARCHAR2,
231 p_type IN VARCHAR2,
232 p_scenario_id IN NUMBER,
233 p_projects IN VARCHAR2,
234 x_return_status OUT NOCOPY VARCHAR2,
235 x_msg_count OUT NOCOPY NUMBER,
236 x_msg_data OUT NOCOPY VARCHAR2);
237
238
239 PROCEDURE Close_Pc
240 ( p_api_version IN NUMBER,
241 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242 p_pc_id IN NUMBER,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2);
246
247 PROCEDURE Update_Scen_Proj_User_Ranks
248 ( p_api_version IN NUMBER,
249 p_commit IN VARCHAR2 := FND_API.G_FALSE,
250 p_projs IN fpa_scen_proj_userrank_all_obj,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER );
254
255
256 PROCEDURE update_pjt_proj_funding_status
257 ( p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2,
259 p_commit IN VARCHAR2,
260 p_scenario_id IN NUMBER,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2);
264
265 FUNCTION proj_scorecard_link_enabled
266 ( p_function_name IN VARCHAR2,
267 p_project_id IN NUMBER)
268 RETURN VARCHAR2;
269
270 END FPA_PROCESS_PVT; -- Package spec