1 PACKAGE GMS_AWARD_PUB AUTHID CURRENT_USER AS
2 -- $Header: gmsawpbs.pls 120.2.12020000.2 2012/07/17 05:38:07 navemish ship $
3
4 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
5
6
7 -- ===============================================================================
8 -- CREATE_AWARD :
9 -- Create award has all the parameters that we have in gms_awards_all table.
10 -- The ID's in the table are replaced by corresponding value. Users must
11 -- provide decode values instead of code values.
12 -- P_return_status : S- Success,
13 -- E- Business Rule Validation error
14 -- U- Unexpected Error
15 -- P_API_VERSION_NUMBER : 1.0
16 -- ===============================================================================
17 PROCEDURE CREATE_AWARD(
18 X_MSG_COUNT OUT NOCOPY NUMBER,
19 X_MSG_DATA OUT NOCOPY VARCHAR2,
20 X_return_status OUT NOCOPY VARCHAR2,
21 X_AWARD_ID OUT NOCOPY NUMBER,
22 P_CALLING_MODULE IN VARCHAR2,
23 P_API_VERSION_NUMBER IN NUMBER,
24 P_LAST_UPDATE_DATE IN DATE,
25 P_LAST_UPDATED_BY IN NUMBER,
26 P_CREATED_BY IN NUMBER,
27 P_CREATION_DATE IN DATE,
28 P_LAST_UPDATE_LOGIN IN NUMBER,
29 P_AWARD_NUMBER IN VARCHAR2,
30 P_AWARD_SHORT_NAME IN VARCHAR2,
31 P_AWARD_FULL_NAME IN VARCHAR2,
32 P_AWARD_START_DATE IN DATE,
33 P_AWARD_END_DATE IN DATE,
34 P_AWARD_CLOSE_DATE IN DATE,
35 P_PREAWARD_DATE IN DATE,
36 P_AWARD_PURPOSE_CODE IN VARCHAR2,
37 P_AWARD_STATUS_CODE IN VARCHAR2,
38 P_AWARD_MANAGER_ID IN NUMBER,
39 P_AWARD_ORGANIZATION_ID IN NUMBER,
40 P_FUNDING_SOURCE_ID IN NUMBER,
41 P_FUNDING_SOURCE_AWARD_NUM IN VARCHAR2,
42 P_ALLOWABLE_SCHEDULE IN VARCHAR2,
43 P_INDIRECT_SCHEDULE IN VARCHAR2,
44 P_COST_IND_SCH_FIXED_DATE IN DATE,
45 P_REVENUE_DISTRIBUTION_RULE IN VARCHAR2,
46 P_BILLING_DISTRIBUTION_RULE IN VARCHAR2,
47 P_BILLING_FORMAT IN VARCHAR2,
48 P_BILLING_TERM_ID IN NUMBER,
49 P_AGENCY_FORM IN VARCHAR2,
50 P_BILL_TO_CUSTOMER_ID IN VARCHAR2,
51 P_LABOR_INVOICE_FORMAT_ID IN VARCHAR2,
52 P_NON_LABOR_INVOICE_FORMAT_ID IN VARCHAR2,
53 P_BILL_TO_ADDRESS_ID IN NUMBER,
54 P_SHIP_TO_ADDRESS_ID IN NUMBER,
55 P_LOC_BILL_TO_ADDRESS_ID IN NUMBER,
56 P_LOC_SHIP_TO_ADDRESS_ID IN NUMBER,
57 P_HARD_LIMIT_FLAG IN VARCHAR2,
58 P_INVOICE_LIMIT_FLAG IN VARCHAR2, /*Bug 6642901*/
59 P_BILLING_OFFSET IN NUMBER,
60 P_BILLING_CYCLE IN VARCHAR2,
61 P_TRANSACTION_NUM IN VARCHAR2,
62 P_AMOUNT_TYPE_CODE IN VARCHAR2,
63 P_BOUNDARY_CODE IN VARCHAR2,
64 P_FUNDS_CONTROL_AT_AWARD IN VARCHAR2,
65 P_FUNDS_CONTROL_AT_TASK IN VARCHAR2,
66 P_FUNDS_CONTROL_AT_RES_GROUP IN VARCHAR2,
67 P_FUNDS_CONTROL_AT_RES IN VARCHAR2,
68 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
69 P_ATTRIBUTE1 IN VARCHAR2,
70 P_ATTRIBUTE2 IN VARCHAR2,
71 P_ATTRIBUTE3 IN VARCHAR2,
72 P_ATTRIBUTE4 IN VARCHAR2,
73 P_ATTRIBUTE5 IN VARCHAR2,
74 P_ATTRIBUTE6 IN VARCHAR2,
75 P_ATTRIBUTE7 IN VARCHAR2,
76 P_ATTRIBUTE8 IN VARCHAR2,
77 P_ATTRIBUTE9 IN VARCHAR2,
78 P_ATTRIBUTE10 IN VARCHAR2,
79 P_ATTRIBUTE11 IN VARCHAR2,
80 P_ATTRIBUTE12 IN VARCHAR2,
81 P_ATTRIBUTE13 IN VARCHAR2,
82 P_ATTRIBUTE14 IN VARCHAR2,
83 P_ATTRIBUTE15 IN VARCHAR2,
84 P_AGREEMENT_TYPE IN VARCHAR2,
85 P_ORG_ID IN NUMBER,
86 P_WF_ENABLED_FLAG IN VARCHAR2,
87 P_PROPOSAL_ID IN NUMBER ) ;
88
89
90 -- ===============================================================================
91 -- COPY_AWARD :
92 -- Copy award has all the parameters that we have in quick entry for award.
93 -- The ID's in the table are replaced by corresponding value. Users must
94 -- provide decode values instead of code values.
95 -- P_return_status : S- Success,
96 -- E- Business Rule Validation error
97 -- U- Unexpected Error
98 -- P_API_VERSION_NUMBER : 1.0
99 -- ===============================================================================
100 PROCEDURE COPY_AWARD(
101 X_MSG_COUNT OUT NOCOPY NUMBER,
102 X_MSG_DATA OUT NOCOPY VARCHAR2,
103 X_return_status OUT NOCOPY VARCHAR2,
104 X_AWARD_ID OUT NOCOPY NUMBER,
105 P_CALLING_MODULE IN VARCHAR2,
106 P_API_VERSION_NUMBER IN NUMBER,
107 P_AWARD_BASE_ID IN NUMBER,
108 P_AWARD_NUMBER IN VARCHAR2,
109 P_AWARD_SHORT_NAME IN VARCHAR2,
110 P_AWARD_FULL_NAME IN VARCHAR2,
111 P_AWARD_START_DATE IN DATE,
112 P_AWARD_END_DATE IN DATE,
113 P_AWARD_CLOSE_DATE IN DATE,
114 P_PREAWARD_DATE IN DATE,
115 P_AWARD_PURPOSE_CODE IN VARCHAR2,
116 P_AWARD_STATUS_CODE IN VARCHAR2,
117 P_AWARD_MANAGER_ID IN NUMBER,
118 P_AWARD_ORGANIZATION_ID IN NUMBER,
119 P_FUNDING_SOURCE_ID IN NUMBER,
120 P_FUNDING_SOURCE_AWARD_NUM IN VARCHAR2,
121 P_ALLOWABLE_SCHEDULE IN VARCHAR2,
122 P_INDIRECT_SCHEDULE IN VARCHAR2,
123 P_COST_IND_SCH_FIXED_DATE IN DATE,
124 P_REVENUE_DISTRIBUTION_RULE IN VARCHAR2,
125 P_BILLING_DISTRIBUTION_RULE IN VARCHAR2,
126 P_BILLING_TERM_ID IN NUMBER,
127 P_LABOR_INVOICE_FORMAT_ID IN VARCHAR2,
128 P_NON_LABOR_INVOICE_FORMAT_ID IN VARCHAR2,
129 P_BILLING_CYCLE IN VARCHAR2,
130 P_AMOUNT_TYPE_CODE IN VARCHAR2,
131 P_BOUNDARY_CODE IN VARCHAR2,
132 P_AGREEMENT_TYPE IN VARCHAR2,
133 P_PROPOSAL_ID IN NUMBER ) ;
134
135
136
137 -- ===============================================================================
138 -- CREATE_AWARD_INSTALLMENT :
139 -- Create award installment has all the parameters that we have in gms_awards_installment table.
140 -- The ID's in the table are replaced by corresponding value. Users must
141 -- provide decode values instead of code values.
142 -- P_return_status : S- Success,
143 -- E- Business Rule Validation error
144 -- U- Unexpected Error
145 -- P_API_VERSION_NUMBER : 1.0
146 -- ===============================================================================
147 PROCEDURE CREATE_INSTALLMENT
148 (X_MSG_COUNT OUT NOCOPY NUMBER ,
149 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
150 X_return_status OUT NOCOPY VARCHAR2 ,
151 X_INSTALLMENT_ID OUT NOCOPY NUMBER ,
152 P_CALLING_MODULE IN VARCHAR2 ,
153 P_API_VERSION_NUMBER IN NUMBER,
154 P_LAST_UPDATE_DATE IN DATE ,
155 P_LAST_UPDATED_BY IN NUMBER ,
156 P_CREATED_BY IN NUMBER ,
157 P_CREATION_DATE IN DATE ,
158 P_LAST_UPDATE_LOGIN IN NUMBER ,
159 P_AWARD_NUMBER IN VARCHAR2 ,
160 --P_INSTALLMENT_NUMBER IN NUMBER ,
161 P_INSTALLMENT_NUMBER IN VARCHAR2 , --Added for bug 14319593
162 P_INSTALLMENT_TYPE_CODE IN VARCHAR2 ,
163 P_DESCRIPTION IN VARCHAR2 ,
164 P_ISSUE_DATE IN DATE ,
165 P_INSTALLMENT_START_DATE IN DATE ,
166 P_INSTALLMENT_END_DATE IN DATE ,
167 P_INSTALLMENT_CLOSE_DATE IN DATE ,
168 P_ACTIVE_FLAG IN VARCHAR2 ,
169 P_BILLABLE_FLAG IN VARCHAR2 ,
170 P_DIRECT_COST IN NUMBER ,
171 P_INDIRECT_COST IN NUMBER ,
172 P_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
173 P_ATTRIBUTE1 IN VARCHAR2 ,
174 P_ATTRIBUTE2 IN VARCHAR2 ,
175 P_ATTRIBUTE3 IN VARCHAR2 ,
176 P_ATTRIBUTE4 IN VARCHAR2 ,
177 P_ATTRIBUTE5 IN VARCHAR2 ,
178 P_ATTRIBUTE6 IN VARCHAR2 ,
179 P_ATTRIBUTE7 IN VARCHAR2 ,
180 P_ATTRIBUTE8 IN VARCHAR2 ,
181 P_ATTRIBUTE9 IN VARCHAR2 ,
182 P_ATTRIBUTE10 IN VARCHAR2 ,
183 P_ATTRIBUTE11 IN VARCHAR2 ,
184 P_ATTRIBUTE12 IN VARCHAR2 ,
185 P_ATTRIBUTE13 IN VARCHAR2 ,
186 P_ATTRIBUTE14 IN VARCHAR2 ,
187 P_ATTRIBUTE15 IN VARCHAR2 ,
188 P_PROPOSAL_ID IN NUMBER
189 ) ;
190
191 -- ==========================================================================================
192 -- Personal or Award Roles are user defined positions or functions that people perform in
193 -- activities funded by an award. Each Personnel or Award Role is linked to an individual
194 -- Award .
195 -- ==========================================================================================
196 PROCEDURE CREATE_PERSONNEL
197 (X_MSG_COUNT OUT NOCOPY NUMBER ,
198 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
199 X_return_status OUT NOCOPY VARCHAR2 ,
200 X_PERSONNEL_ID OUT NOCOPY NUMBER ,
201 P_CALLING_MODULE IN VARCHAR2 ,
202 P_API_VERSION_NUMBER IN NUMBER ,
203 P_LAST_UPDATE_DATE IN DATE ,
204 P_LAST_UPDATED_BY IN NUMBER ,
205 P_CREATED_BY IN NUMBER ,
206 P_CREATION_DATE IN DATE ,
207 P_LAST_UPDATE_LOGIN IN NUMBER,
208 P_AWARD_NUMBER IN VARCHAR2 ,
209 P_AWARD_ROLE_CODE IN VARCHAR2 ,
210 P_PERSON_ID IN VARCHAR2 ,
211 P_START_DATE_ACTIVE IN DATE ,
212 P_END_DATE_ACTIVE IN DATE ,
213 P_REQUIRED_FLAG IN VARCHAR2
214 );
215
216 -- ===========================================================================
217 -- Award terms and conditions are stipulated by the Grantor that are indicated
218 -- in an agreement or contract.
219 -- ===========================================================================
220 PROCEDURE CREATE_TERM_CONDITION
221 (X_MSG_COUNT OUT NOCOPY NUMBER ,
222 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
223 X_return_status OUT NOCOPY VARCHAR2 ,
224 P_CALLING_MODULE IN VARCHAR2 ,
225 P_API_VERSION_NUMBER IN NUMBER ,
226 P_LAST_UPDATE_DATE IN DATE ,
227 P_LAST_UPDATED_BY IN NUMBER ,
228 P_CREATED_BY IN NUMBER ,
229 P_CREATION_DATE IN DATE ,
230 P_LAST_UPDATE_LOGIN IN NUMBER ,
231 P_AWARD_NUMBER IN VARCHAR2 ,
232 P_CATEGORY_NAME IN VARCHAR2 ,
233 P_TERM_ID IN NUMBER ,
234 P_OPERAND IN VARCHAR2 ,
235 P_VALUE IN NUMBER
236 ) ;
237
238 -- =============================================================================
239 -- Reference Numbers are user defined values or characters assigned to an award
240 -- for identification purposes.
241 -- =============================================================================
242 PROCEDURE CREATE_REFERENCE_NUMBER
243 (X_MSG_COUNT OUT NOCOPY NUMBER ,
244 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
245 X_return_status OUT NOCOPY VARCHAR2 ,
246 P_CALLING_MODULE IN VARCHAR2 ,
247 P_API_VERSION_NUMBER IN NUMBER ,
248 P_LAST_UPDATE_DATE IN DATE,
249 P_LAST_UPDATED_BY IN NUMBER ,
250 P_CREATED_BY IN NUMBER ,
251 P_CREATION_DATE IN DATE ,
252 P_LAST_UPDATE_LOGIN IN NUMBER ,
253 P_AWARD_NUMBER IN VARCHAR2 ,
254 P_REFERENCE_TYPE IN VARCHAR2 ,
255 P_REFERENCE_VALUE IN VARCHAR2 ,
256 P_REQUIRED_FLAG IN VARCHAR2
257 ) ;
258
259 -- ==========================================================
260 -- Create Contacts
261 -- ==========================================================
262
263 PROCEDURE CREATE_CONTACT
264 (X_MSG_COUNT OUT NOCOPY NUMBER ,
265 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
266 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
267 P_CALLING_MODULE IN VARCHAR2 ,
268 P_API_VERSION_NUMBER IN NUMBER ,
269 P_LAST_UPDATE_DATE IN DATE,
270 P_LAST_UPDATED_BY IN NUMBER ,
271 P_CREATED_BY IN NUMBER ,
272 P_CREATION_DATE IN DATE ,
273 P_LAST_UPDATE_LOGIN IN NUMBER ,
274 P_AWARD_NUMBER IN VARCHAR2 ,
275 P_CONTACT_ID IN NUMBER ,
276 P_PRIMARY_FLAG IN VARCHAR2 ,
277 P_USAGE_CODE IN VARCHAR2
278 ) ;
279
280 -- ==========================================================
281 -- Create Reports
282 -- ==========================================================
283 PROCEDURE CREATE_REPORT
284 (X_MSG_COUNT OUT NOCOPY NUMBER ,
285 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
286 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
287 X_DEFAULT_REPORT_ID OUT NOCOPY NUMBER ,
288 P_CALLING_MODULE IN VARCHAR2 ,
289 P_API_VERSION_NUMBER IN NUMBER ,
290 P_LAST_UPDATE_DATE IN DATE,
291 P_LAST_UPDATED_BY IN NUMBER ,
292 P_CREATED_BY IN NUMBER ,
293 P_CREATION_DATE IN DATE ,
294 P_LAST_UPDATE_LOGIN IN NUMBER ,
295 P_AWARD_NUMBER IN VARCHAR2 ,
296 P_REPORT_NAME IN VARCHAR2 ,
297 P_FREQUENCY_CODE IN VARCHAR2 ,
298 P_DUE_WITHIN_DAYS IN NUMBER ,
299 P_SITE_USE_ID IN NUMBER ,
300 P_NUMBER_OF_COPIES IN NUMBER
301 ) ;
302
303 -- ==========================================================
304 -- Add Funding
305 -- ==========================================================
306 PROCEDURE ADD_FUNDING
307 (X_MSG_COUNT IN OUT NOCOPY NUMBER ,
308 X_MSG_DATA IN OUT NOCOPY VARCHAR2 ,
309 X_RETURN_STATUS IN OUT NOCOPY VARCHAR2 ,
310 X_GMS_PROJECT_FUNDING_ID IN OUT NOCOPY NUMBER ,
311 X_ROW_ID OUT NOCOPY VARCHAR2 ,
312 P_CALLING_MODULE IN VARCHAR2 ,
313 P_API_VERSION_NUMBER IN NUMBER ,
314 P_AWARD_ID IN NUMBER,
315 P_INSTALLMENT_ID IN NUMBER,
316 P_PROJECT_ID IN NUMBER,
317 P_TASK_ID IN NUMBER,
318 P_AMOUNT IN NUMBER,
319 P_FUNDING_DATE IN DATE
320 ) ;
321
322 END GMS_AWARD_PUB ;