[Home] [Help]
PACKAGE: APPS.FPA_INVESTMENT_CRITERIA_PVT
Source
1 package FPA_Investment_Criteria_PVT as
2 /* $Header: FPAVINVS.pls 120.6 2008/01/30 13:24:06 rthumma ship $ */
3
4 TYPE Investment_rec_type is RECORD
5 (
6 project_shortname varchar2(30) -- Project shortname
7 ,project_type_shortname varchar2(30) -- Project Type shortname
8 ,scenario_shortname varchar2(30) -- Project shortname
9 ,strategic_obj_shortname number(15,0) -- strategic objective shortname
10 ,strategic_obj_name varchar2(105) -- strategic objective name
11 ,strategic_obj_desc varchar2(240) -- strategic objective description
12 ,strategic_obj_parent varchar2(30) -- shortname for the strategic objective parent.
13 ,strategic_obj_status varchar2(30) -- shortname for the strategic objective parent.
14 ,strategic_obj_level varchar2(30) -- level for the strategic objective.
15 ,strategic_obj_id number -- ID for strategic Objective, used for BSC.
16 ,strategic_obj_weight varchar2(10) -- Value for Strategic Weight
17 ,strategic_obj_score varchar2(10) -- Value for Strategic Score
18 ,strategic_obj_wscore varchar2(10) -- Value for Strategic Weighted Score
19 ,strategic_scores_string varchar2(5000) -- String containing objectives and their scores.
20 );
21
22 TYPE Investment_tbl_type IS TABLE OF Investment_rec_type
23 INDEX BY BINARY_INTEGER;
24
25 /*
26 procedure Create_StrategicObj_Objects_AW(
27 p_commit IN varchar2 := FND_API.G_FALSE
28 ,p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type
29 ,x_return_status OUT NOCOPY varchar2
30 ,x_msg_count OUT NOCOPY number
31 ,x_msg_data OUT NOCOPY varchar2
32 );
33 */
34
35 PROCEDURE create_strategicobj_aw
36 (
37 p_commit IN VARCHAR2 := FND_API.G_FALSE,
38 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
39 p_seeding IN VARCHAR2,
40 x_strategic_obj_id OUT NOCOPY VARCHAR2,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 PROCEDURE delete_strategicobj_aw
47 (
48 p_api_version IN NUMBER,
49 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE update_strategicobj
56 (
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE update_strategicobj_status_aw
65 (
66 p_commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE update_strategicobj_level_aw
74 (
75 p_commit IN VARCHAR2 := FND_API.G_FALSE,
76 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE update_strategicobj_weight_aw
83 (
84 p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
85 x_return_status OUT NOCOPY VARCHAR2,
86 x_msg_count OUT NOCOPY NUMBER,
87 x_msg_data OUT NOCOPY VARCHAR2
88 );
89 /*
90 PROCEDURE update_strategicobj_score_aw
91 (
92 p_api_version IN NUMBER,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2
98 );
99 */
100
101 PROCEDURE update_projecttypeobjscore_aw
102 (
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2
108 );
109 /*
110 PROCEDURE update_strategicobj_wscore_aw
111 (
112 p_api_version IN NUMBER,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2
118 );
119 */
120 /*
121 PROCEDURE update_projecttypeobjwscore_aw
122 (
123 p_api_version IN NUMBER,
124 p_commit IN VARCHAR2 := FND_API.G_FALSE,
125 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2
129 );
130 */
131 /*
132 PROCEDURE update_strategicobj_ascore_aw
133 (
134 p_api_version IN NUMBER,
135 p_commit IN VARCHAR2 := FND_API.G_FALSE,
136 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2
140 );
141 */
142 /*
143 procedure Update_ProjectTypeObjAScore_AW(
144 p_commit IN varchar2 := FND_API.G_FALSE
145 ,p_Investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type
146 ,x_return_status OUT NOCOPY varchar2
147 ,x_msg_count OUT NOCOPY number
148 ,x_msg_data OUT NOCOPY varchar2
149 );
150 */
151 /*
152 PROCEDURE rollup_strategicobj_wscore_aw
153 (
154 p_api_version IN NUMBER,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156 p_investment_rec_type IN FPA_Investment_Criteria_PVT.Investment_rec_type,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2
160 );
161 */
162
163 -------------------------------------------------------------------------------
164 -- API create_strategicobj_aw , Overloaded API which does not take
165 -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter
166 --
167 -- Params
168 -- p_commit IN VARCHAR2
169 -- p_seeding IN VARCHAR2
170 -- x_strategic_obj_id OUT NOCOPY VARCHAR2
171 -- x_return_status OUT NOCOPY VARCHAR2
172 -- x_msg_count OUT NOCOPY NUMBER
173 -- x_msg_data OUT NOCOPY VARCHAR2
174 -- p_strategic_obj_shortname IN NUMBER
175 -- p_strategic_obj_desc IN VARCHAR2
176 -- p_strategic_obj_name IN VARCHAR2
177 -- p_strategic_obj_level IN VARCHAR2
178 -- p_strategic_obj_parent IN VARCHAR2
179 -------------------------------------------------------------------------------
180 PROCEDURE create_strategicobj_aw
181 (
182 p_commit IN VARCHAR2 := FND_API.G_FALSE,
183 p_seeding IN VARCHAR2,
184 p_strategic_obj_shortname IN NUMBER,
185 p_strategic_obj_desc IN VARCHAR2,
186 p_strategic_obj_name IN VARCHAR2,
187 p_strategic_obj_level IN VARCHAR2,
188 p_strategic_obj_parent IN VARCHAR2,
189 x_strategic_obj_id OUT NOCOPY VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2
193 );
194
195 -------------------------------------------------------------------------------
196 -- API update_strategicobj_status_aw , Overloaded API which does not take
197 -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter
198 --
199 -- Params
200 -- p_commit IN VARCHAR2
201 -- x_return_status OUT NOCOPY VARCHAR2
202 -- x_msg_count OUT NOCOPY NUMBER
203 -- x_msg_data OUT NOCOPY VARCHAR2
204 -- p_strategic_obj_shortname IN NUMBER
205 -- p_strategic_obj_desc IN VARCHAR2
206 -- p_strategic_obj_name IN VARCHAR2
207 -- p_strategic_obj_level IN VARCHAR2
208 -- p_strategic_obj_parent IN VARCAHR2
209 -- p_strategic_obj_status IN VARCHAR2
210 -------------------------------------------------------------------------------
211 PROCEDURE update_strategicobj_status_aw
212 (
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_strategic_obj_shortname IN NUMBER,
215 p_strategic_obj_desc IN VARCHAR2,
216 p_strategic_obj_name IN VARCHAR2,
217 p_strategic_obj_level IN VARCHAR2,
218 p_strategic_obj_parent IN VARCHAR2,
219 p_strategic_obj_status IN VARCHAR2,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2
223 );
224
225 -------------------------------------------------------------------------------
226 -- API update_strategicobj_level_aw , Overloaded API which does not take
227 -- FPA_Investment_Criteria_PVT.Investment_rec_type as a parameter
228 --
229 -- Params
233 -- x_msg_data OUT NOCOPY VARCHAR2
230 -- p_commit IN VARCHAR2
231 -- x_return_status OUT NOCOPY VARCHAR2
232 -- x_msg_count OUT NOCOPY NUMBER
234 -- p_strategic_obj_shortname IN NUMBER
235 -- p_strategic_obj_desc IN VARCHAR2
236 -- p_strategic_obj_name IN VARCHAR2
237 -- p_strategic_obj_level IN VARCHAR2
238 -- p_strategic_obj_parent IN VARCHAR2
239 -------------------------------------------------------------------------------
240
241 PROCEDURE update_strategicobj_level_aw
242 (
243 p_commit IN VARCHAR2 := FND_API.G_FALSE,
244 p_strategic_obj_shortname IN NUMBER,
245 p_strategic_obj_desc IN VARCHAR2,
246 p_strategic_obj_name IN VARCHAR2,
247 p_strategic_obj_level IN VARCHAR2,
248 p_strategic_obj_parent IN VARCHAR2,
249 x_return_status OUT NOCOPY VARCHAR2,
250 x_msg_count OUT NOCOPY NUMBER,
251 x_msg_data OUT NOCOPY VARCHAR2
252 );
253
254 END fpa_investment_criteria_pvt;