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.IGW_PROPOSALS_ALL_PKG

Source


1 package IGW_PROPOSALS_ALL_PKG AUTHID CURRENT_USER as
2  /* $Header: igwpr10s.pls 115.17 2002/03/28 19:13:24 pkm ship    $ */
3 procedure INSERT_ROW (
4   X_ROWID in out VARCHAR2,
5   X_PROPOSAL_ID in NUMBER,
6   X_SPONSOR_ACTION_CODE in VARCHAR2,
7   X_SPONSOR_ACTION_DATE in DATE,
8   X_SPONSOR_ACTION_COMMENTS in VARCHAR2,
9   X_AWARD_AMOUNT in NUMBER,
10   X_PROPOSAL_NUMBER in VARCHAR2,
11   X_LEAD_ORGANIZATION_ID in NUMBER,
12   X_PROPOSAL_STATUS in VARCHAR2,
13   X_PROPOSAL_START_DATE in DATE,
14   X_PROPOSAL_END_DATE in DATE,
15   X_PROPOSAL_TITLE in VARCHAR2,
16   X_PROPOSAL_TYPE_CODE in VARCHAR2,
17   X_AWARD_NUMBER in VARCHAR2,
18   X_ORIGINAL_PROPOSAL_NUMBER in VARCHAR2,
19   X_ORIGINAL_AWARD_NUMBER in VARCHAR2,
20   X_ORIGINAL_PROPOSAL_START_DATE in DATE,
21   X_ORIGINAL_PROPOSAL_END_DATE in DATE,
22   X_ACTIVITY_TYPE_CODE in VARCHAR2,
23   X_SPONSOR_ID in NUMBER,
24   X_FUNDING_SPONSOR_UNIT in VARCHAR2,
25   X_ORIGINAL_SPONSOR_ID in NUMBER,
26   X_SPONSOR_PROPOSAL_NUMBER in VARCHAR2,
27   X_NOTICE_OF_OPPORTUNITY_CODE in VARCHAR2,
28   X_PROGRAM_NUMBER in VARCHAR2,
29   X_PROGRAM_TITLE in VARCHAR2,
30   X_PROGRAM_URL in VARCHAR2,
31   X_SUBMITTING_ORGANIZATION_ID in NUMBER,
32   X_SIGNING_OFFICIAL_ID in NUMBER,
33   X_ADMIN_OFFICIAL_ID in NUMBER,
34   X_DEADLINE_DATE in DATE,
35   X_DEADLINE_TYPE in VARCHAR2,
36   X_LETTER_OF_INTENT_DUE_DATE in DATE,
37   X_ATTRIBUTE_CATEGORY in VARCHAR2,
38   X_ATTRIBUTE1 in VARCHAR2,
39   X_ATTRIBUTE2 in VARCHAR2,
40   X_ATTRIBUTE3 in VARCHAR2,
41   X_ATTRIBUTE4 in VARCHAR2,
42   X_ATTRIBUTE5 in VARCHAR2,
43   X_ATTRIBUTE6 in VARCHAR2,
44   X_ATTRIBUTE7 in VARCHAR2,
45   X_ATTRIBUTE8 in VARCHAR2,
46   X_ATTRIBUTE9 in VARCHAR2,
47   X_ATTRIBUTE10 in VARCHAR2,
48   X_ATTRIBUTE11 in VARCHAR2,
49   X_ATTRIBUTE12 in VARCHAR2,
50   X_ATTRIBUTE13 in VARCHAR2,
51   X_ATTRIBUTE14 in VARCHAR2,
52   X_ATTRIBUTE15 in VARCHAR2,
53   X_MODE in VARCHAR2 default 'R'
54   );
55 procedure LOCK_ROW (
56   X_ROWID in VARCHAR2,
57   X_PROPOSAL_ID in NUMBER,
58   X_SPONSOR_ACTION_CODE in VARCHAR2,
59   X_SPONSOR_ACTION_DATE in DATE,
60   X_SPONSOR_ACTION_COMMENTS in VARCHAR2,
61   X_AWARD_AMOUNT in NUMBER,
62   X_PROPOSAL_NUMBER in VARCHAR2,
63   X_LEAD_ORGANIZATION_ID in NUMBER,
64   X_PROPOSAL_STATUS in VARCHAR2,
65   X_PROPOSAL_START_DATE in DATE,
66   X_PROPOSAL_END_DATE in DATE,
67   X_PROPOSAL_TITLE in VARCHAR2,
68   X_PROPOSAL_TYPE_CODE in VARCHAR2,
69   X_AWARD_NUMBER in VARCHAR2,
70   X_ORIGINAL_PROPOSAL_NUMBER in VARCHAR2,
71   X_ORIGINAL_AWARD_NUMBER in VARCHAR2,
72   X_ORIGINAL_PROPOSAL_START_DATE in DATE,
73   X_ORIGINAL_PROPOSAL_END_DATE in DATE,
74   X_ACTIVITY_TYPE_CODE in VARCHAR2,
75   X_SPONSOR_ID in NUMBER,
76   X_FUNDING_SPONSOR_UNIT in VARCHAR2,
77   X_ORIGINAL_SPONSOR_ID in NUMBER,
78   X_SPONSOR_PROPOSAL_NUMBER in VARCHAR2,
79   X_NOTICE_OF_OPPORTUNITY_CODE in VARCHAR2,
80   X_PROGRAM_NUMBER in VARCHAR2,
81   X_PROGRAM_TITLE in VARCHAR2,
82   X_PROGRAM_URL in VARCHAR2,
83   X_SUBMITTING_ORGANIZATION_ID in NUMBER,
84   X_SIGNING_OFFICIAL_ID in NUMBER,
85   X_ADMIN_OFFICIAL_ID in NUMBER,
86   X_DEADLINE_DATE in DATE,
87   X_DEADLINE_TYPE in VARCHAR2,
88   X_LETTER_OF_INTENT_DUE_DATE in DATE,
89   X_ATTRIBUTE_CATEGORY in VARCHAR2,
90   X_ATTRIBUTE1 in VARCHAR2,
91   X_ATTRIBUTE2 in VARCHAR2,
92   X_ATTRIBUTE3 in VARCHAR2,
93   X_ATTRIBUTE4 in VARCHAR2,
94   X_ATTRIBUTE5 in VARCHAR2,
95   X_ATTRIBUTE6 in VARCHAR2,
96   X_ATTRIBUTE7 in VARCHAR2,
97   X_ATTRIBUTE8 in VARCHAR2,
98   X_ATTRIBUTE9 in VARCHAR2,
99   X_ATTRIBUTE10 in VARCHAR2,
100   X_ATTRIBUTE11 in VARCHAR2,
101   X_ATTRIBUTE12 in VARCHAR2,
102   X_ATTRIBUTE13 in VARCHAR2,
103   X_ATTRIBUTE14 in VARCHAR2,
104   X_ATTRIBUTE15 in VARCHAR2
105 );
106 procedure UPDATE_ROW (
107   X_ROWID in VARCHAR2,
108   X_PROPOSAL_ID in NUMBER,
109   X_SPONSOR_ACTION_CODE in VARCHAR2,
110   X_SPONSOR_ACTION_DATE in DATE,
111   X_SPONSOR_ACTION_COMMENTS in VARCHAR2,
112   X_AWARD_AMOUNT in NUMBER,
113   X_PROPOSAL_NUMBER in VARCHAR2,
114   X_LEAD_ORGANIZATION_ID in NUMBER,
115   X_PROPOSAL_STATUS in VARCHAR2,
116   X_PROPOSAL_START_DATE in DATE,
117   X_PROPOSAL_END_DATE in DATE,
118   X_PROPOSAL_TITLE in VARCHAR2,
119   X_PROPOSAL_TYPE_CODE in VARCHAR2,
120   X_AWARD_NUMBER in VARCHAR2,
121   X_ORIGINAL_PROPOSAL_NUMBER in VARCHAR2,
122   X_ORIGINAL_AWARD_NUMBER in VARCHAR2,
123   X_ORIGINAL_PROPOSAL_START_DATE in DATE,
124   X_ORIGINAL_PROPOSAL_END_DATE in DATE,
125   X_ACTIVITY_TYPE_CODE in VARCHAR2,
126   X_SPONSOR_ID in NUMBER,
127   X_FUNDING_SPONSOR_UNIT in VARCHAR2,
128   X_ORIGINAL_SPONSOR_ID in NUMBER,
129   X_SPONSOR_PROPOSAL_NUMBER in VARCHAR2,
130   X_NOTICE_OF_OPPORTUNITY_CODE in VARCHAR2,
131   X_PROGRAM_NUMBER in VARCHAR2,
132   X_PROGRAM_TITLE in VARCHAR2,
133   X_PROGRAM_URL in VARCHAR2,
134   X_SUBMITTING_ORGANIZATION_ID in NUMBER,
135   X_SIGNING_OFFICIAL_ID in NUMBER,
136   X_ADMIN_OFFICIAL_ID in NUMBER,
137   X_DEADLINE_DATE in DATE,
138   X_DEADLINE_TYPE in VARCHAR2,
139   X_LETTER_OF_INTENT_DUE_DATE in DATE,
140   X_ATTRIBUTE_CATEGORY in VARCHAR2,
141   X_ATTRIBUTE1 in VARCHAR2,
142   X_ATTRIBUTE2 in VARCHAR2,
143   X_ATTRIBUTE3 in VARCHAR2,
144   X_ATTRIBUTE4 in VARCHAR2,
145   X_ATTRIBUTE5 in VARCHAR2,
146   X_ATTRIBUTE6 in VARCHAR2,
147   X_ATTRIBUTE7 in VARCHAR2,
148   X_ATTRIBUTE8 in VARCHAR2,
149   X_ATTRIBUTE9 in VARCHAR2,
150   X_ATTRIBUTE10 in VARCHAR2,
151   X_ATTRIBUTE11 in VARCHAR2,
152   X_ATTRIBUTE12 in VARCHAR2,
153   X_ATTRIBUTE13 in VARCHAR2,
154   X_ATTRIBUTE14 in VARCHAR2,
155   X_ATTRIBUTE15 in VARCHAR2,
156   X_MODE in VARCHAR2 default 'R'
157   );
158 procedure ADD_ROW (
159   X_ROWID in out VARCHAR2,
160   X_PROPOSAL_ID in NUMBER,
161   X_SPONSOR_ACTION_CODE in VARCHAR2,
162   X_SPONSOR_ACTION_DATE in DATE,
163   X_SPONSOR_ACTION_COMMENTS in VARCHAR2,
164   X_AWARD_AMOUNT in NUMBER,
165   X_PROPOSAL_NUMBER in VARCHAR2,
166   X_LEAD_ORGANIZATION_ID in NUMBER,
167   X_PROPOSAL_STATUS in VARCHAR2,
168   X_PROPOSAL_START_DATE in DATE,
169   X_PROPOSAL_END_DATE in DATE,
170   X_PROPOSAL_TITLE in VARCHAR2,
171   X_PROPOSAL_TYPE_CODE in VARCHAR2,
172   X_AWARD_NUMBER in VARCHAR2,
173   X_ORIGINAL_PROPOSAL_NUMBER in VARCHAR2,
174   X_ORIGINAL_AWARD_NUMBER in VARCHAR2,
175   X_ORIGINAL_PROPOSAL_START_DATE in DATE,
176   X_ORIGINAL_PROPOSAL_END_DATE in DATE,
177   X_ACTIVITY_TYPE_CODE in VARCHAR2,
178   X_SPONSOR_ID in NUMBER,
179   X_FUNDING_SPONSOR_UNIT in VARCHAR2,
180   X_ORIGINAL_SPONSOR_ID in NUMBER,
181   X_SPONSOR_PROPOSAL_NUMBER in VARCHAR2,
182   X_NOTICE_OF_OPPORTUNITY_CODE in VARCHAR2,
183   X_PROGRAM_NUMBER in VARCHAR2,
184   X_PROGRAM_TITLE in VARCHAR2,
185   X_PROGRAM_URL in VARCHAR2,
186   X_SUBMITTING_ORGANIZATION_ID in NUMBER,
187   X_SIGNING_OFFICIAL_ID in NUMBER,
188   X_ADMIN_OFFICIAL_ID in NUMBER,
189   X_DEADLINE_DATE in DATE,
190   X_DEADLINE_TYPE in VARCHAR2,
191   X_LETTER_OF_INTENT_DUE_DATE in DATE,
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_MODE in VARCHAR2 default 'R'
209   );
210 procedure DELETE_ROW (
211   X_ROWID in VARCHAR2
212 );
213 end IGW_PROPOSALS_ALL_PKG;