1 PACKAGE PA_PROJECT_FUNDINGS_PKG AUTHID CURRENT_USER as
2 /* $Header: PAINPFDS.pls 120.1.12020000.2 2012/07/19 09:40:22 admarath ship $ */
3
4
5 PROCEDURE Insert_Row(
6 X_Rowid IN OUT NOCOPY VARCHAR2,/*File.sql.39*/
7 X_Project_Funding_Id IN OUT NOCOPY NUMBER,/*File.sql.39*/
8 X_Last_Update_Date IN DATE,
9 X_Last_Updated_By IN NUMBER,
10 X_Creation_Date IN DATE,
11 X_Created_By IN NUMBER,
12 X_Last_Update_Login IN NUMBER,
13 X_Agreement_Id IN NUMBER,
14 X_Project_Id IN NUMBER,
15 X_Task_Id IN NUMBER,
16 X_Budget_Type_Code IN VARCHAR2,
17 X_Allocated_Amount IN NUMBER,
18 X_Date_Allocated IN DATE,
19 X_Attribute_Category IN VARCHAR2,
20 X_Control_Item_ID IN NUMBER DEFAULT NULL, /* Added for FP_M changes */
21 X_Attribute1 IN VARCHAR2,
22 X_Attribute2 IN VARCHAR2,
23 X_Attribute3 IN VARCHAR2,
24 X_Attribute4 IN VARCHAR2,
25 X_Attribute5 IN VARCHAR2,
26 X_Attribute6 IN VARCHAR2,
27 X_Attribute7 IN VARCHAR2,
28 X_Attribute8 IN VARCHAR2,
29 X_Attribute9 IN VARCHAR2,
30 X_Attribute10 IN VARCHAR2,
31 X_pm_funding_reference IN VARCHAR2,
32 X_pm_product_code IN VARCHAR2,
33 x_funding_currency_code IN VARCHAR2,
34 x_project_currency_code IN VARCHAR2,
35 x_project_rate_type IN VARCHAR2,
36 x_project_rate_date IN DATE,
37 x_project_exchange_rate IN NUMBER,
38 x_project_allocated_amount IN NUMBER,
39 x_projfunc_currency_code IN VARCHAR2,
40 x_projfunc_rate_type IN VARCHAR2,
41 x_projfunc_rate_date IN DATE,
42 x_projfunc_exchange_rate IN NUMBER,
43 x_projfunc_allocated_amount IN NUMBER,
44 x_invproc_currency_code IN VARCHAR2,
45 x_invproc_rate_type IN VARCHAR2,
46 x_invproc_rate_date IN DATE,
47 x_invproc_exchange_rate IN NUMBER,
48 x_invproc_allocated_amount IN NUMBER,
49 x_revproc_currency_code IN VARCHAR2,
50 x_revproc_rate_type IN VARCHAR2,
51 x_revproc_rate_date IN DATE,
52 x_revproc_exchange_rate IN NUMBER,
53 x_revproc_allocated_amount IN NUMBER,
54 x_funding_category IN VARCHAR2, /* For Bug 2244796 */
55 x_revaluation_through_date IN DATE DEFAULT NULL,
56 x_revaluation_rate_date IN DATE DEFAULT NULL,
57 x_reval_projfunc_rate_type IN VARCHAR2 DEFAULT NULL,
58 x_reval_invproc_rate_type IN VARCHAR2 DEFAULT NULL,
59 x_revaluation_projfunc_rate IN NUMBER DEFAULT NULL,
60 x_revaluation_invproc_rate IN NUMBER DEFAULT NULL,
61 x_funding_inv_applied_amount IN NUMBER DEFAULT NULL,
62 x_funding_inv_due_amount IN NUMBER DEFAULT NULL,
63 x_funding_backlog_amount IN NUMBER DEFAULT NULL,
64 x_projfunc_realized_gains_amt IN NUMBER DEFAULT NULL,
65 x_projfunc_realized_losses_amt IN NUMBER DEFAULT NULL,
66 x_projfunc_inv_applied_amount IN NUMBER DEFAULT NULL,
67 x_projfunc_inv_due_amount IN NUMBER DEFAULT NULL,
68 x_projfunc_backlog_amount IN NUMBER DEFAULT NULL,
69 x_non_updateable_flag IN VARCHAR2 DEFAULT NULL,
70 x_invproc_backlog_amount IN NUMBER DEFAULT NULL,
71 x_funding_reval_amount IN NUMBER DEFAULT NULL,
72 x_projfunc_reval_amount IN NUMBER DEFAULT NULL,
73 x_projfunc_revalued_amount IN NUMBER DEFAULT NULL,
74 x_invproc_reval_amount IN NUMBER DEFAULT NULL,
75 x_invproc_revalued_amount IN NUMBER DEFAULT NULL,
76 x_funding_revaluation_factor IN NUMBER DEFAULT NULL,
77 x_request_id IN NUMBER DEFAULT NULL,
78 x_program_application_id IN NUMBER DEFAULT NULL,
79 x_program_id IN NUMBER DEFAULT NULL,
80 x_program_update_date IN DATE DEFAULT NULL
81 );
82
83 PROCEDURE Lock_Row(
84 X_Rowid IN VARCHAR2,
85 X_Project_Funding_Id IN NUMBER,
86 X_Agreement_Id IN NUMBER,
87 X_Project_Id IN NUMBER,
88 X_Task_Id IN NUMBER,
89 X_Budget_Type_Code IN VARCHAR2,
90 X_Allocated_Amount IN NUMBER,
91 X_Date_Allocated IN DATE,
92 X_Attribute_Category IN VARCHAR2,
93 X_Attribute1 IN VARCHAR2,
94 X_Attribute2 IN VARCHAR2,
95 X_Attribute3 IN VARCHAR2,
96 X_Attribute4 IN VARCHAR2,
97 X_Attribute5 IN VARCHAR2,
98 X_Attribute6 IN VARCHAR2,
99 X_Attribute7 IN VARCHAR2,
100 X_Attribute8 IN VARCHAR2,
101 X_Attribute9 IN VARCHAR2,
102 X_Attribute10 IN VARCHAR2,
103 X_pm_funding_reference IN VARCHAR2,
104 X_pm_product_code IN VARCHAR2,
105 x_funding_currency_code IN VARCHAR2,
106 x_project_currency_code IN VARCHAR2,
107 x_project_rate_type IN VARCHAR2,
108 x_project_rate_date IN DATE,
109 x_project_exchange_rate IN NUMBER,
110 x_project_allocated_amount IN NUMBER,
111 x_projfunc_currency_code IN VARCHAR2,
112 x_projfunc_rate_type IN VARCHAR2,
113 x_projfunc_rate_date IN DATE,
114 x_projfunc_exchange_rate IN NUMBER,
115 x_projfunc_allocated_amount IN NUMBER,
116 X_funding_category IN VARCHAR2 /* For Bug 2244796 */
117 );
118
119
120
121 PROCEDURE Update_Row(
122 X_Rowid IN VARCHAR2,
123 X_Project_Funding_Id IN NUMBER,
124 X_Last_Update_Date IN DATE,
125 X_Last_Updated_By IN NUMBER,
126 X_Last_Update_Login IN NUMBER,
127 X_Agreement_Id IN NUMBER,
128 X_Project_Id IN NUMBER,
129 X_Task_Id IN NUMBER,
130 X_Budget_Type_Code IN VARCHAR2,
131 X_Allocated_Amount IN NUMBER,
132 X_Date_Allocated IN DATE,
133 X_Attribute_Category IN VARCHAR2,
134 X_Attribute1 IN VARCHAR2,
135 X_Attribute2 IN VARCHAR2,
136 X_Attribute3 IN VARCHAR2,
137 X_Attribute4 IN VARCHAR2,
138 X_Attribute5 IN VARCHAR2,
139 X_Attribute6 IN VARCHAR2,
140 X_Attribute7 IN VARCHAR2,
141 X_Attribute8 IN VARCHAR2,
142 X_Attribute9 IN VARCHAR2,
143 X_Attribute10 IN VARCHAR2,
144 X_pm_funding_reference IN VARCHAR2,
145 X_pm_product_code IN VARCHAR2,
146 x_funding_currency_code IN VARCHAR2,
147 x_project_currency_code IN VARCHAR2,
148 x_project_rate_type IN VARCHAR2,
149 x_project_rate_date IN DATE,
150 x_project_exchange_rate IN NUMBER,
151 x_project_allocated_amount IN NUMBER,
152 x_projfunc_currency_code IN VARCHAR2,
153 x_projfunc_rate_type IN VARCHAR2,
154 x_projfunc_rate_date IN DATE,
155 x_projfunc_exchange_rate IN NUMBER,
156 x_projfunc_allocated_amount IN NUMBER,
157 x_invproc_currency_code IN VARCHAR2,
158 x_invproc_rate_type IN VARCHAR2,
159 x_invproc_rate_date IN DATE,
160 x_invproc_exchange_rate IN NUMBER,
161 x_invproc_allocated_amount IN NUMBER,
162 x_revproc_currency_code IN VARCHAR2,
163 x_revproc_rate_type IN VARCHAR2,
164 x_revproc_rate_date IN DATE,
165 x_revproc_exchange_rate IN NUMBER,
166 x_revproc_allocated_amount IN NUMBER,
167 X_funding_category IN VARCHAR2 /* For Bug 2244796 */
168 );
169
170 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
171 /* Bug 13680810 FP for 13585292 */
172 PROCEDURE Lock_Row_SPF(
173 X_Rowid IN VARCHAR2,
174 X_Agreement_Id IN NUMBER,
175 X_Project_Id IN NUMBER,
176 X_Task_Id IN NUMBER,
177 X_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
178 X_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
179 X_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
180 X_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
181 X_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
182 X_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
183 X_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
184 X_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
185 X_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
186 X_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
187 X_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
188 X_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
189 X_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
190 X_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
191 X_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
192 X_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
193 X_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
194 X_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
195 X_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
196 X_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
197 X_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
198 X_GLOBAL_ATTRIBUTE21 IN VARCHAR2,
199 X_GLOBAL_ATTRIBUTE22 IN VARCHAR2,
200 X_GLOBAL_ATTRIBUTE23 IN VARCHAR2,
201 X_GLOBAL_ATTRIBUTE24 IN VARCHAR2,
202 X_GLOBAL_ATTRIBUTE25 IN VARCHAR2,
203 X_GLOBAL_ATTRIBUTE26 IN VARCHAR2,
204 X_GLOBAL_ATTRIBUTE27 IN VARCHAR2,
205 X_GLOBAL_ATTRIBUTE28 IN VARCHAR2,
206 X_GLOBAL_ATTRIBUTE29 IN VARCHAR2,
207 X_GLOBAL_ATTRIBUTE30 IN VARCHAR2
208 );
209
210 PROCEDURE Update_Row_SPF(
211 X_Rowid IN VARCHAR2,
212 X_Last_Update_Date IN DATE,
213 X_Last_Updated_By IN NUMBER,
214 X_Last_Update_Login IN NUMBER,
215 X_Agreement_Id IN NUMBER,
216 X_Project_Id IN NUMBER,
217 X_Task_Id IN NUMBER,
218 X_Global_Attribute_Category IN VARCHAR2,
219 X_Global_Attribute1 IN VARCHAR2,
220 X_Global_Attribute2 IN VARCHAR2,
221 X_Global_Attribute3 IN VARCHAR2,
222 X_Global_Attribute4 IN VARCHAR2,
223 X_Global_Attribute5 IN VARCHAR2,
224 X_Global_Attribute6 IN VARCHAR2,
225 X_Global_Attribute7 IN VARCHAR2,
226 X_Global_Attribute8 IN VARCHAR2,
227 X_Global_Attribute9 IN VARCHAR2,
228 X_Global_Attribute10 IN VARCHAR2,
229 X_Global_Attribute11 IN VARCHAR2,
230 X_Global_Attribute12 IN VARCHAR2,
231 X_Global_Attribute13 IN VARCHAR2,
232 X_Global_Attribute14 IN VARCHAR2,
233 X_Global_Attribute15 IN VARCHAR2,
234 X_Global_Attribute16 IN VARCHAR2,
235 X_Global_Attribute17 IN VARCHAR2,
236 X_Global_Attribute18 IN VARCHAR2,
237 X_Global_Attribute19 IN VARCHAR2,
238 X_Global_Attribute20 IN VARCHAR2,
239 X_Global_Attribute21 IN VARCHAR2,
240 X_Global_Attribute22 IN VARCHAR2,
241 X_Global_Attribute23 IN VARCHAR2,
242 X_Global_Attribute24 IN VARCHAR2,
243 X_Global_Attribute25 IN VARCHAR2,
244 X_Global_Attribute26 IN VARCHAR2,
245 X_Global_Attribute27 IN VARCHAR2,
246 X_Global_Attribute28 IN VARCHAR2,
247 X_Global_Attribute29 IN VARCHAR2,
248 X_Global_Attribute30 IN VARCHAR2
252
249 );
250
251 /* End Here Bug 13680810 FP for 13585292 */
253 END PA_PROJECT_FUNDINGS_PKG;