eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.GMS_AWARDS_PKG

Source


1 package  GMS_AWARDS_PKG AUTHID CURRENT_USER as
2 /* $Header: gmsawaws.pls 120.2.12010000.2 2008/10/30 09:05:37 rrambati ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_AWARD_ID in NUMBER,
7   X_AWARD_NUMBER in VARCHAR2,
8   X_AWARD_SHORT_NAME in VARCHAR2,
9   X_AWARD_FULL_NAME in VARCHAR2,
10   X_FUNDING_SOURCE_ID in NUMBER,
11   X_START_DATE_ACTIVE in DATE,
12   X_END_DATE_ACTIVE in DATE,
13   X_CLOSE_DATE in DATE,
14   X_FUNDING_SOURCE_AWARD_NUMBER in VARCHAR2,
15   X_AWARD_PURPOSE_CODE in VARCHAR2,
16   X_STATUS in VARCHAR2,
17   X_ALLOWABLE_SCHEDULE_ID in NUMBER,
18   X_IDC_SCHEDULE_ID in NUMBER,
19   X_REVENUE_DISTRIBUTION_RULE in VARCHAR2,
20   X_BILLING_FREQUENCY in VARCHAR2,
21   X_BILLING_CYCLE_ID  IN NUMBER,
22   X_BILLING_OFFSET    IN NUMBER,
23   X_BILLING_DISTRIBUTION_RULE in VARCHAR2,
24   X_BILLING_FORMAT in VARCHAR2,
25   X_BILLING_TERM in NUMBER,
26   X_AWARD_PROJECT_ID in NUMBER,
27   X_AGREEMENT_ID in NUMBER,
28   X_AWARD_TEMPLATE_FLAG in VARCHAR2,
29   X_PREAWARD_DATE in DATE,
30   X_AGENCY_SPECIFIC_FORM in VARCHAR2,
31   X_BILL_TO_CUSTOMER_ID in NUMBER,
32   X_TRANSACTION_NUMBER in VARCHAR2,
33   X_AMOUNT_TYPE in VARCHAR2,
34   X_BOUNDARY_CODE in VARCHAR2,
35   X_FUND_CONTROL_LEVEL_AWARD in VARCHAR2,
36   X_FUND_CONTROL_LEVEL_TASK in VARCHAR2,
37   X_FUND_CONTROL_LEVEL_RES_GRP in VARCHAR2,
38   X_FUND_CONTROL_LEVEL_RES in VARCHAR2,
39   X_ATTRIBUTE_CATEGORY in VARCHAR2,
40   X_ATTRIBUTE1 in VARCHAR2,
41   X_ATTRIBUTE2 in VARCHAR2,
42   X_ATTRIBUTE3 in VARCHAR2,
43   X_ATTRIBUTE4 in VARCHAR2,
44   X_ATTRIBUTE5 in VARCHAR2,
45   X_ATTRIBUTE6 in VARCHAR2,
46   X_ATTRIBUTE7 in VARCHAR2,
47   X_ATTRIBUTE8 in VARCHAR2,
48   X_ATTRIBUTE9 in VARCHAR2,
49   X_ATTRIBUTE10 in VARCHAR2,
50   X_ATTRIBUTE11 in VARCHAR2,
51   X_ATTRIBUTE12 in VARCHAR2,
52   X_ATTRIBUTE13 in VARCHAR2,
53   X_ATTRIBUTE14 in VARCHAR2,
54   X_ATTRIBUTE15 in VARCHAR2,
55   X_ATTRIBUTE16 in VARCHAR2,
56   X_ATTRIBUTE17 in VARCHAR2,
57   X_ATTRIBUTE18 in VARCHAR2,
58   X_ATTRIBUTE19 in VARCHAR2,
59   X_ATTRIBUTE20 in VARCHAR2,
60   X_ATTRIBUTE21 in VARCHAR2,
61   X_ATTRIBUTE22 in VARCHAR2,
62   X_ATTRIBUTE23 in VARCHAR2,
63   X_ATTRIBUTE24 in VARCHAR2,
64   X_ATTRIBUTE25 in VARCHAR2,
65   X_TEMPLATE_START_DATE_ACTIVE in DATE,
66   X_TEMPLATE_END_DATE_ACTIVE in DATE,
67   X_ORG_ID in NUMBER, /* created a new parameter */
68   X_TYPE in VARCHAR2,
69   X_COST_IND_SCH_FIXED_DATE in DATE,
70   X_LABOR_INVOICE_FORMAT_ID in NUMBER,
71   X_NON_LABOR_INVOICE_FORMAT_ID in NUMBER,
72   X_MODE in VARCHAR2 default 'R',
73   X_BILL_TO_ADDRESS_ID in NUMBER,
74   X_SHIP_TO_ADDRESS_ID in NUMBER,
75   X_LOC_BILL_TO_ADDRESS_ID in NUMBER,
76   X_LOC_SHIP_TO_ADDRESS_ID in NUMBER,
77   X_AWARD_ORGANIZATION_ID in NUMBER,
78   X_HARD_LIMIT_FLAG in VARCHAR2 ,
79   X_INVOICE_LIMIT_FLAG in VARCHAR2 ,
80   X_PROPOSAL_ID IN NUMBER DEFAULT NULL,
81   X_BUDGET_WF_ENABLED_FLAG in VARCHAR2
82   );
83 procedure LOCK_ROW (
84   X_AWARD_ID in NUMBER,
85   X_AWARD_NUMBER in VARCHAR2,
86   X_AWARD_SHORT_NAME in VARCHAR2,
87   X_AWARD_FULL_NAME in VARCHAR2,
88   X_FUNDING_SOURCE_ID in NUMBER,
89   X_START_DATE_ACTIVE in DATE,
90   X_END_DATE_ACTIVE in DATE,
91   X_CLOSE_DATE in DATE,
92   X_FUNDING_SOURCE_AWARD_NUMBER in VARCHAR2,
93   X_AWARD_PURPOSE_CODE in VARCHAR2,
94   X_STATUS in VARCHAR2,
95   X_ALLOWABLE_SCHEDULE_ID in NUMBER,
96   X_IDC_SCHEDULE_ID in NUMBER,
97   X_REVENUE_DISTRIBUTION_RULE in VARCHAR2,
98   X_BILLING_FREQUENCY in VARCHAR2,
99   X_BILLING_CYCLE_ID  IN NUMBER,
100   X_BILLING_OFFSET    IN NUMBER,
101   X_BILLING_DISTRIBUTION_RULE in VARCHAR2,
102   X_BILLING_FORMAT in VARCHAR2,
103   X_BILLING_TERM in NUMBER,
104   X_AWARD_PROJECT_ID in NUMBER,
105   X_AGREEMENT_ID in NUMBER,
106   X_AWARD_TEMPLATE_FLAG in VARCHAR2,
107   X_PREAWARD_DATE in DATE,
108   X_AGENCY_SPECIFIC_FORM in VARCHAR2,
109   X_BILL_TO_CUSTOMER_ID in NUMBER,
110   X_TRANSACTION_NUMBER in VARCHAR2,
111   X_AMOUNT_TYPE in VARCHAR2,
112   X_BOUNDARY_CODE in VARCHAR2,
113   X_FUND_CONTROL_LEVEL_AWARD in VARCHAR2,
114   X_FUND_CONTROL_LEVEL_TASK in VARCHAR2,
115   X_FUND_CONTROL_LEVEL_RES_GRP in VARCHAR2,
116   X_FUND_CONTROL_LEVEL_RES in VARCHAR2,
117   X_ATTRIBUTE_CATEGORY in VARCHAR2,
118   X_ATTRIBUTE1 in VARCHAR2,
119   X_ATTRIBUTE2 in VARCHAR2,
120   X_ATTRIBUTE3 in VARCHAR2,
121   X_ATTRIBUTE4 in VARCHAR2,
122   X_ATTRIBUTE5 in VARCHAR2,
123   X_ATTRIBUTE6 in VARCHAR2,
124   X_ATTRIBUTE7 in VARCHAR2,
125   X_ATTRIBUTE8 in VARCHAR2,
126   X_ATTRIBUTE9 in VARCHAR2,
127   X_ATTRIBUTE10 in VARCHAR2,
128   X_ATTRIBUTE11 in VARCHAR2,
129   X_ATTRIBUTE12 in VARCHAR2,
130   X_ATTRIBUTE13 in VARCHAR2,
131   X_ATTRIBUTE14 in VARCHAR2,
132   X_ATTRIBUTE15 in VARCHAR2,
133   X_ATTRIBUTE16 in VARCHAR2,
134   X_ATTRIBUTE17 in VARCHAR2,
135   X_ATTRIBUTE18 in VARCHAR2,
136   X_ATTRIBUTE19 in VARCHAR2,
137   X_ATTRIBUTE20 in VARCHAR2,
138   X_ATTRIBUTE21 in VARCHAR2,
139   X_ATTRIBUTE22 in VARCHAR2,
140   X_ATTRIBUTE23 in VARCHAR2,
141   X_ATTRIBUTE24 in VARCHAR2,
142   X_ATTRIBUTE25 in VARCHAR2,
143   X_TEMPLATE_START_DATE_ACTIVE in DATE,
144   X_TEMPLATE_END_DATE_ACTIVE in DATE,
145   X_ORG_ID in NUMBER,
146   X_TYPE in VARCHAR2,
147   X_COST_IND_SCH_FIXED_DATE in DATE,
148   X_LABOR_INVOICE_FORMAT_ID in NUMBER,
149   X_NON_LABOR_INVOICE_FORMAT_ID in NUMBER,
150   X_BILL_TO_ADDRESS_ID in NUMBER,
151   X_SHIP_TO_ADDRESS_ID in NUMBER,
152   X_LOC_BILL_TO_ADDRESS_ID in NUMBER,
153   X_LOC_SHIP_TO_ADDRESS_ID in NUMBER,
154   X_AWARD_ORGANIZATION_ID in NUMBER,
155   X_HARD_LIMIT_FLAG in VARCHAR2,
156   X_INVOICE_LIMIT_FLAG in VARCHAR2
157 );
158 procedure UPDATE_ROW (
159   X_AWARD_ID in NUMBER,
160   X_AWARD_NUMBER in VARCHAR2,
161   X_AWARD_SHORT_NAME in VARCHAR2,
162   X_AWARD_FULL_NAME in VARCHAR2,
163   X_FUNDING_SOURCE_ID in NUMBER,
164   X_START_DATE_ACTIVE in DATE,
165   X_END_DATE_ACTIVE in DATE,
166   X_CLOSE_DATE in DATE,
167   X_FUNDING_SOURCE_AWARD_NUMBER in VARCHAR2,
168   X_AWARD_PURPOSE_CODE in VARCHAR2,
169   X_STATUS in VARCHAR2,
170   X_ALLOWABLE_SCHEDULE_ID in NUMBER,
171   X_IDC_SCHEDULE_ID in NUMBER,
172   X_REVENUE_DISTRIBUTION_RULE in VARCHAR2,
173   X_BILLING_FREQUENCY in VARCHAR2,
174   X_BILLING_CYCLE_ID  IN NUMBER,
175   X_BILLING_OFFSET    IN NUMBER,
176   X_BILLING_DISTRIBUTION_RULE in VARCHAR2,
177   X_BILLING_FORMAT in VARCHAR2,
178   X_BILLING_TERM in NUMBER,
179   X_AWARD_PROJECT_ID in NUMBER,
180   X_AGREEMENT_ID in NUMBER,
181   X_AWARD_TEMPLATE_FLAG in VARCHAR2,
182   X_PREAWARD_DATE in DATE,
183   X_AGENCY_SPECIFIC_FORM in VARCHAR2,
184   X_BILL_TO_CUSTOMER_ID in NUMBER,
185   X_TRANSACTION_NUMBER in VARCHAR2,
186   X_AMOUNT_TYPE in VARCHAR2,
187   X_BOUNDARY_CODE in VARCHAR2,
188   X_FUND_CONTROL_LEVEL_AWARD in VARCHAR2,
189   X_FUND_CONTROL_LEVEL_TASK in VARCHAR2,
190   X_FUND_CONTROL_LEVEL_RES_GRP in VARCHAR2,
191   X_FUND_CONTROL_LEVEL_RES in VARCHAR2,
192   X_ATTRIBUTE_CATEGORY in VARCHAR2,
193   X_ATTRIBUTE1 in VARCHAR2,
194   X_ATTRIBUTE2 in VARCHAR2,
195   X_ATTRIBUTE3 in VARCHAR2,
196   X_ATTRIBUTE4 in VARCHAR2,
197   X_ATTRIBUTE5 in VARCHAR2,
198   X_ATTRIBUTE6 in VARCHAR2,
199   X_ATTRIBUTE7 in VARCHAR2,
200   X_ATTRIBUTE8 in VARCHAR2,
201   X_ATTRIBUTE9 in VARCHAR2,
202   X_ATTRIBUTE10 in VARCHAR2,
203   X_ATTRIBUTE11 in VARCHAR2,
204   X_ATTRIBUTE12 in VARCHAR2,
205   X_ATTRIBUTE13 in VARCHAR2,
206   X_ATTRIBUTE14 in VARCHAR2,
207   X_ATTRIBUTE15 in VARCHAR2,
208   X_ATTRIBUTE16 in VARCHAR2,
209   X_ATTRIBUTE17 in VARCHAR2,
210   X_ATTRIBUTE18 in VARCHAR2,
211   X_ATTRIBUTE19 in VARCHAR2,
212   X_ATTRIBUTE20 in VARCHAR2,
213   X_ATTRIBUTE21 in VARCHAR2,
214   X_ATTRIBUTE22 in VARCHAR2,
215   X_ATTRIBUTE23 in VARCHAR2,
216   X_ATTRIBUTE24 in VARCHAR2,
217   X_ATTRIBUTE25 in VARCHAR2,
218   X_TEMPLATE_START_DATE_ACTIVE in DATE,
219   X_TEMPLATE_END_DATE_ACTIVE in DATE,
220  -- X_ORG_ID in NUMBER,
221   X_TYPE in VARCHAR2,
222   X_COST_IND_SCH_FIXED_DATE in DATE,
223   X_LABOR_INVOICE_FORMAT_ID in NUMBER,
224   X_NON_LABOR_INVOICE_FORMAT_ID in NUMBER,
225   X_MODE in VARCHAR2 default 'R',
226   X_BILL_TO_ADDRESS_ID in NUMBER,
227   X_SHIP_TO_ADDRESS_ID in NUMBER,
228   X_LOC_BILL_TO_ADDRESS_ID in NUMBER,
229   X_LOC_SHIP_TO_ADDRESS_ID in NUMBER,
230   X_AWARD_ORGANIZATION_ID in NUMBER ,
231   X_HARD_LIMIT_FLAG in VARCHAR2,
232   X_INVOICE_LIMIT_FLAG in VARCHAR2 ,
233   X_BUDGET_WF_ENABLED_FLAG in VARCHAR2
234   );
235 
236 /* added parameters for bug 2355648 */
237 procedure DELETE_ROW (
238   X_AWARD_ID            IN  NUMBER,
239   x_award_project_id    IN  NUMBER,--bug 2355648
240   x_agreement_id        IN  NUMBER, --bug 2355648
241   x_Award_Template_flag IN  VARCHAR2,--bug 2355648
242   x_msg_count           OUT NOCOPY NUMBER , --bug 2355648
243   RETCODE		OUT NOCOPY VARCHAR2, --bug 2355648
244   ERRBUFF		OUT NOCOPY VARCHAR2 --bug 2355648
245 );
246 
247 Procedure UPDATE_AWARD_PROJECT_STATUS(
248   X_award_project_id IN NUMBER,
249   X_Status IN VARCHAR2
250 );
251 
252 end GMS_AWARDS_PKG;