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

Source


1 package AMS_FUNDS_ALL_PKG AUTHID CURRENT_USER as
2 /* $Header: amslfuns.pls 115.1 2002/07/15 22:11:38 mpande noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out VARCHAR2,
5   X_FUND_ID in NUMBER,
6   X_CREATED_FROM in VARCHAR2,
7   X_REQUEST_ID in NUMBER,
8   X_FUND_NUMBER in VARCHAR2,
9   X_PARENT_FUND_ID in NUMBER,
10   X_CATEGORY_ID in NUMBER,
11   X_FUND_TYPE in VARCHAR2,
12   X_FUND_USAGE in VARCHAR2,
13   X_STATUS_CODE in VARCHAR2,
14   X_STATUS_DATE in DATE,
15   X_ACCRUED_LIABLE_ACCOUNT in NUMBER,
16   X_DED_ADJUSTMENT_ACCOUNT in NUMBER,
17   X_LIABILITY_FLAG in VARCHAR2,
18   X_SET_OF_BOOKS_ID in NUMBER,
19   X_START_PERIOD_ID in NUMBER,
20   X_END_PERIOD_ID in NUMBER,
21   X_START_DATE_ACTIVE in DATE,
22   X_END_DATE_ACTIVE in DATE,
23   X_BUDGET_AMOUNT_TC in NUMBER,
24   X_BUDGET_AMOUNT_FC in NUMBER,
25   X_AVAILABLE_AMOUNT in NUMBER,
26   X_DISTRIBUTED_AMOUNT in NUMBER,
27   X_CURRENCY_CODE_TC in VARCHAR2,
28   X_CURRENCY_CODE_FC in VARCHAR2,
29   X_EXCHANGE_RATE_TYPE in VARCHAR2,
30   X_EXCHANGE_RATE_DATE in DATE,
31   X_EXCHANGE_RATE in NUMBER,
32   X_DEPARTMENT_ID in NUMBER,
33   X_COSTCENTRE_ID in NUMBER,
34   X_OWNER in NUMBER,
35   X_ACCRUAL_METHOD in VARCHAR2,
36   X_ACCRUAL_OPERAND in VARCHAR2,
37   X_ACCRUAL_RATE in NUMBER,
38   X_ACCRUAL_BASIS in VARCHAR2,
39   X_HIERARCHY in VARCHAR2,
40   X_HIERARCHY_LEVEL in VARCHAR2,
41   X_BUDGET_FLAG in VARCHAR2,
42   X_EARNED_FLAG in VARCHAR2,
43   X_APPLY_ACCRUAL_ON in VARCHAR2,
44   X_ACCRUAL_PHASE in VARCHAR2,
45   X_ACCRUAL_CAP in NUMBER,
46   X_ACCRUAL_UOM in VARCHAR2,
47   X_OBJECT_VERSION_NUMBER in NUMBER,
48   X_ATTRIBUTE_CATEGORY in VARCHAR2,
49   X_ATTRIBUTE1 in VARCHAR2,
50   X_ATTRIBUTE2 in VARCHAR2,
51   X_ATTRIBUTE3 in VARCHAR2,
52   X_ATTRIBUTE4 in VARCHAR2,
53   X_ATTRIBUTE5 in VARCHAR2,
54   X_ATTRIBUTE6 in VARCHAR2,
55   X_ATTRIBUTE7 in VARCHAR2,
56   X_ATTRIBUTE8 in VARCHAR2,
57   X_ATTRIBUTE9 in VARCHAR2,
58   X_ATTRIBUTE10 in VARCHAR2,
59   X_ATTRIBUTE11 in VARCHAR2,
60   X_ATTRIBUTE12 in VARCHAR2,
61   X_ATTRIBUTE13 in VARCHAR2,
62   X_ATTRIBUTE14 in VARCHAR2,
63   X_ATTRIBUTE15 in VARCHAR2,
64   X_SHORT_NAME in VARCHAR2,
65   X_DESCRIPTION in VARCHAR2,
66   X_CREATION_DATE in DATE,
67   X_CREATED_BY in NUMBER,
68   X_LAST_UPDATE_DATE in DATE,
69   X_LAST_UPDATED_BY in NUMBER,
70   X_LAST_UPDATE_LOGIN in NUMBER,
71   X_HIERARCHY_ID in NUMBER,
72   X_PARENT_NODE_ID in NUMBER,
73   X_NODE_ID in NUMBER,
74   X_ORIGINAL_BUDGET in NUMBER,
75   X_TRANSFERED_IN_AMT in NUMBER,
76   X_TRANSFERED_OUT_AMT in NUMBER,
77   X_HOLDBACK_AMT in NUMBER,
78   X_PLANNED_AMT in NUMBER,
79   X_COMMITTED_AMT in NUMBER,
80   X_EARNED_AMT in NUMBER,
81   X_PAID_AMT in NUMBER,
82   X_PLAN_TYPE in VARCHAR2,
83   X_PLAN_ID in NUMBER,
84   X_LIABLE_ACCNT_SEGMENTS in VARCHAR2,
85   X_ADJUSTMENT_ACCNT_SEGMENTS in VARCHAR2
86   );
87 procedure LOCK_ROW (
88   X_FUND_ID in NUMBER,
89   X_CREATED_FROM in VARCHAR2,
90   X_REQUEST_ID in NUMBER,
91   X_FUND_NUMBER in VARCHAR2,
92   X_PARENT_FUND_ID in NUMBER,
93   X_CATEGORY_ID in NUMBER,
94   X_FUND_TYPE in VARCHAR2,
95   X_FUND_USAGE in VARCHAR2,
96   X_STATUS_CODE in VARCHAR2,
97   X_STATUS_DATE in DATE,
98   X_ACCRUED_LIABLE_ACCOUNT in NUMBER,
99   X_DED_ADJUSTMENT_ACCOUNT in NUMBER,
100   X_LIABILITY_FLAG in VARCHAR2,
101   X_SET_OF_BOOKS_ID in NUMBER,
102   X_START_PERIOD_ID in NUMBER,
103   X_END_PERIOD_ID in NUMBER,
104   X_START_DATE_ACTIVE in DATE,
105   X_END_DATE_ACTIVE in DATE,
106   X_BUDGET_AMOUNT_TC in NUMBER,
107   X_BUDGET_AMOUNT_FC in NUMBER,
108   X_AVAILABLE_AMOUNT in NUMBER,
109   X_DISTRIBUTED_AMOUNT in NUMBER,
110   X_CURRENCY_CODE_TC in VARCHAR2,
111   X_CURRENCY_CODE_FC in VARCHAR2,
112   X_EXCHANGE_RATE_TYPE in VARCHAR2,
113   X_EXCHANGE_RATE_DATE in DATE,
114   X_EXCHANGE_RATE in NUMBER,
115   X_DEPARTMENT_ID in NUMBER,
116   X_COSTCENTRE_ID in NUMBER,
117   X_OWNER in NUMBER,
118   X_ACCRUAL_METHOD in VARCHAR2,
119   X_ACCRUAL_OPERAND in VARCHAR2,
120   X_ACCRUAL_RATE in NUMBER,
121   X_ACCRUAL_BASIS in VARCHAR2,
122   X_HIERARCHY in VARCHAR2,
123   X_HIERARCHY_LEVEL in VARCHAR2,
124   X_BUDGET_FLAG in VARCHAR2,
125   X_EARNED_FLAG in VARCHAR2,
126   X_APPLY_ACCRUAL_ON in VARCHAR2,
127   X_ACCRUAL_PHASE in VARCHAR2,
128   X_ACCRUAL_CAP in NUMBER,
129   X_ACCRUAL_UOM in VARCHAR2,
130   X_OBJECT_VERSION_NUMBER in NUMBER,
131   X_ATTRIBUTE_CATEGORY in VARCHAR2,
132   X_ATTRIBUTE1 in VARCHAR2,
133   X_ATTRIBUTE2 in VARCHAR2,
134   X_ATTRIBUTE3 in VARCHAR2,
135   X_ATTRIBUTE4 in VARCHAR2,
136   X_ATTRIBUTE5 in VARCHAR2,
137   X_ATTRIBUTE6 in VARCHAR2,
138   X_ATTRIBUTE7 in VARCHAR2,
139   X_ATTRIBUTE8 in VARCHAR2,
140   X_ATTRIBUTE9 in VARCHAR2,
141   X_ATTRIBUTE10 in VARCHAR2,
142   X_ATTRIBUTE11 in VARCHAR2,
143   X_ATTRIBUTE12 in VARCHAR2,
144   X_ATTRIBUTE13 in VARCHAR2,
145   X_ATTRIBUTE14 in VARCHAR2,
146   X_ATTRIBUTE15 in VARCHAR2,
147   X_SHORT_NAME in VARCHAR2,
148   X_DESCRIPTION in VARCHAR2,
149   X_HIERARCHY_ID in NUMBER,
150   X_PARENT_NODE_ID in NUMBER,
151   X_NODE_ID in NUMBER,
152   X_ORIGINAL_BUDGET in NUMBER,
153   X_TRANSFERED_IN_AMT in NUMBER,
154   X_TRANSFERED_OUT_AMT in NUMBER,
155   X_HOLDBACK_AMT in NUMBER,
156   X_PLANNED_AMT in NUMBER,
157   X_COMMITTED_AMT in NUMBER,
158   X_EARNED_AMT in NUMBER,
159   X_PAID_AMT in NUMBER,
160   X_PLAN_TYPE in VARCHAR2,
161   X_PLAN_ID in NUMBER,
162   X_LIABLE_ACCNT_SEGMENTS in VARCHAR2,
163   X_ADJUSTMENT_ACCNT_SEGMENTS in VARCHAR2
164 );
165 procedure UPDATE_ROW (
166   X_FUND_ID in NUMBER,
167   X_CREATED_FROM in VARCHAR2,
168   X_REQUEST_ID in NUMBER,
169   X_FUND_NUMBER in VARCHAR2,
170   X_PARENT_FUND_ID in NUMBER,
171   X_CATEGORY_ID in NUMBER,
172   X_FUND_TYPE in VARCHAR2,
173   X_FUND_USAGE in VARCHAR2,
174   X_STATUS_CODE in VARCHAR2,
175   X_STATUS_DATE in DATE,
176   X_ACCRUED_LIABLE_ACCOUNT in NUMBER,
177   X_DED_ADJUSTMENT_ACCOUNT in NUMBER,
178   X_LIABILITY_FLAG in VARCHAR2,
179   X_SET_OF_BOOKS_ID in NUMBER,
180   X_START_PERIOD_ID in NUMBER,
181   X_END_PERIOD_ID in NUMBER,
182   X_START_DATE_ACTIVE in DATE,
183   X_END_DATE_ACTIVE in DATE,
184   X_BUDGET_AMOUNT_TC in NUMBER,
185   X_BUDGET_AMOUNT_FC in NUMBER,
186   X_AVAILABLE_AMOUNT in NUMBER,
187   X_DISTRIBUTED_AMOUNT in NUMBER,
188   X_CURRENCY_CODE_TC in VARCHAR2,
189   X_CURRENCY_CODE_FC in VARCHAR2,
190   X_EXCHANGE_RATE_TYPE in VARCHAR2,
191   X_EXCHANGE_RATE_DATE in DATE,
192   X_EXCHANGE_RATE in NUMBER,
193   X_DEPARTMENT_ID in NUMBER,
194   X_COSTCENTRE_ID in NUMBER,
195   X_OWNER in NUMBER,
196   X_ACCRUAL_METHOD in VARCHAR2,
197   X_ACCRUAL_OPERAND in VARCHAR2,
198   X_ACCRUAL_RATE in NUMBER,
199   X_ACCRUAL_BASIS in VARCHAR2,
200   X_HIERARCHY in VARCHAR2,
201   X_HIERARCHY_LEVEL in VARCHAR2,
202   X_BUDGET_FLAG in VARCHAR2,
203   X_EARNED_FLAG in VARCHAR2,
204   X_APPLY_ACCRUAL_ON in VARCHAR2,
205   X_ACCRUAL_PHASE in VARCHAR2,
206   X_ACCRUAL_CAP in NUMBER,
207   X_ACCRUAL_UOM in VARCHAR2,
208   X_OBJECT_VERSION_NUMBER in NUMBER,
209   X_ATTRIBUTE_CATEGORY in VARCHAR2,
210   X_ATTRIBUTE1 in VARCHAR2,
211   X_ATTRIBUTE2 in VARCHAR2,
212   X_ATTRIBUTE3 in VARCHAR2,
213   X_ATTRIBUTE4 in VARCHAR2,
214   X_ATTRIBUTE5 in VARCHAR2,
215   X_ATTRIBUTE6 in VARCHAR2,
216   X_ATTRIBUTE7 in VARCHAR2,
217   X_ATTRIBUTE8 in VARCHAR2,
218   X_ATTRIBUTE9 in VARCHAR2,
219   X_ATTRIBUTE10 in VARCHAR2,
220   X_ATTRIBUTE11 in VARCHAR2,
221   X_ATTRIBUTE12 in VARCHAR2,
222   X_ATTRIBUTE13 in VARCHAR2,
223   X_ATTRIBUTE14 in VARCHAR2,
224   X_ATTRIBUTE15 in VARCHAR2,
225   X_SHORT_NAME in VARCHAR2,
226   X_DESCRIPTION in VARCHAR2,
227   X_LAST_UPDATE_DATE in DATE,
228   X_LAST_UPDATED_BY in NUMBER,
229   X_LAST_UPDATE_LOGIN in NUMBER,
230   X_HIERARCHY_ID in NUMBER,
231   X_PARENT_NODE_ID in NUMBER,
232   X_NODE_ID in NUMBER,
233   X_ORIGINAL_BUDGET in NUMBER,
234   X_TRANSFERED_IN_AMT in NUMBER,
235   X_TRANSFERED_OUT_AMT in NUMBER,
236   X_HOLDBACK_AMT in NUMBER,
237   X_PLANNED_AMT in NUMBER,
238   X_COMMITTED_AMT in NUMBER,
239   X_EARNED_AMT in NUMBER,
240   X_PAID_AMT in NUMBER,
241   X_PLAN_TYPE in VARCHAR2,
242   X_PLAN_ID in NUMBER,
243   X_LIABLE_ACCNT_SEGMENTS in VARCHAR2,
244   X_ADJUSTMENT_ACCNT_SEGMENTS in VARCHAR2
245 );
246 procedure DELETE_ROW (
247   X_FUND_ID in NUMBER
248 );
249 procedure ADD_LANGUAGE;
250 
251 procedure TRANSLATE_ROW(
252   X_FUND_ID in NUMBER,
253   X_SHORT_NAME in VARCHAR2,
254   X_DESCRIPTION in VARCHAR2,
255   X_OWNERS in VARCHAR2
256 );
257 
258 procedure  LOAD_ROW(
259   X_FUND_ID in NUMBER,
260   X_CREATED_FROM in VARCHAR2,
261   X_REQUEST_ID in NUMBER,
262   X_FUND_NUMBER in VARCHAR2,
263   X_PARENT_FUND_ID in NUMBER,
264   X_CATEGORY_ID in NUMBER,
265   X_FUND_TYPE in VARCHAR2,
266   X_FUND_USAGE in VARCHAR2,
267   X_STATUS_CODE in VARCHAR2,
268   X_STATUS_DATE in DATE,
269   X_ACCRUED_LIABLE_ACCOUNT in NUMBER,
270   X_DED_ADJUSTMENT_ACCOUNT in NUMBER,
271   X_LIABILITY_FLAG in VARCHAR2,
272   X_SET_OF_BOOKS_ID in NUMBER,
273   X_START_PERIOD_ID in NUMBER,
274   X_END_PERIOD_ID in NUMBER,
275   X_START_DATE_ACTIVE in DATE,
276   X_END_DATE_ACTIVE in DATE,
277   X_BUDGET_AMOUNT_TC in NUMBER,
278   X_BUDGET_AMOUNT_FC in NUMBER,
279   X_AVAILABLE_AMOUNT in NUMBER,
280   X_DISTRIBUTED_AMOUNT in NUMBER,
281   X_CURRENCY_CODE_TC in VARCHAR2,
282   X_CURRENCY_CODE_FC in VARCHAR2,
283   X_EXCHANGE_RATE_TYPE in VARCHAR2,
284   X_EXCHANGE_RATE_DATE in DATE,
285   X_EXCHANGE_RATE in NUMBER,
286   X_DEPARTMENT_ID in NUMBER,
287   X_COSTCENTRE_ID in NUMBER,
288   X_OWNER in NUMBER,
289   X_ACCRUAL_METHOD in VARCHAR2,
290   X_ACCRUAL_OPERAND in VARCHAR2,
291   X_ACCRUAL_RATE in NUMBER,
292   X_ACCRUAL_BASIS in VARCHAR2,
293   X_HIERARCHY in VARCHAR2,
294   X_HIERARCHY_LEVEL in VARCHAR2,
295   X_BUDGET_FLAG in VARCHAR2,
296   X_EARNED_FLAG in VARCHAR2,
297   X_APPLY_ACCRUAL_ON in VARCHAR2,
298   X_ACCRUAL_PHASE in VARCHAR2,
299   X_ACCRUAL_CAP in NUMBER,
300   X_ACCRUAL_UOM in VARCHAR2,
301   X_OBJECT_VERSION_NUMBER in NUMBER,
302   X_ATTRIBUTE_CATEGORY in VARCHAR2,
303   X_ATTRIBUTE1 in VARCHAR2,
304   X_ATTRIBUTE2 in VARCHAR2,
305   X_ATTRIBUTE3 in VARCHAR2,
306   X_ATTRIBUTE4 in VARCHAR2,
307   X_ATTRIBUTE5 in VARCHAR2,
308   X_ATTRIBUTE6 in VARCHAR2,
309   X_ATTRIBUTE7 in VARCHAR2,
310   X_ATTRIBUTE8 in VARCHAR2,
311   X_ATTRIBUTE9 in VARCHAR2,
312   X_ATTRIBUTE10 in VARCHAR2,
313   X_ATTRIBUTE11 in VARCHAR2,
314   X_ATTRIBUTE12 in VARCHAR2,
315   X_ATTRIBUTE13 in VARCHAR2,
316   X_ATTRIBUTE14 in VARCHAR2,
317   X_ATTRIBUTE15 in VARCHAR2,
318   X_SHORT_NAME in VARCHAR2,
319   X_DESCRIPTION in VARCHAR2,
320   X_OWNERS in VARCHAR2,
321   X_HIERARCHY_ID in NUMBER,
322   X_PARENT_NODE_ID in NUMBER,
323   X_NODE_ID in NUMBER,
324   X_ORIGINAL_BUDGET in NUMBER,
325   X_TRANSFERED_IN_AMT in NUMBER,
326   X_TRANSFERED_OUT_AMT in NUMBER,
327   X_HOLDBACK_AMT in NUMBER,
328   X_PLANNED_AMT in NUMBER,
329   X_COMMITTED_AMT in NUMBER,
330   X_EARNED_AMT in NUMBER,
331   X_PAID_AMT in NUMBER,
332   X_PLAN_TYPE in VARCHAR2,
333   X_PLAN_ID in NUMBER,
334   X_LIABLE_ACCNT_SEGMENTS in VARCHAR2,
335   X_ADJUSTMENT_ACCNT_SEGMENTS in VARCHAR2
336 );
337 
338 
339 end AMS_FUNDS_ALL_PKG;