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_DELIVERABLES_ALL_PKG

Source


1 package AMS_DELIVERABLES_ALL_PKG AUTHID CURRENT_USER as
2 /* $Header: amsldels.pls 115.2 2000/02/16 00:53:30 pkm ship   $ */
3 procedure INSERT_ROW (
4   X_ROWID in out VARCHAR2,
5   X_DELIVERABLE_ID in NUMBER,
6   X_NON_INV_CTRL_CODE in VARCHAR2,
7   X_NON_INV_QUANTITY_ON_HAND in NUMBER,
8   X_NON_INV_QUANTITY_ON_ORDER in NUMBER,
9   X_NON_INV_QUANTITY_ON_RESERVE in NUMBER,
10   X_REPLACED_BY_DELIVERABLE_ID in NUMBER,
11   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
12   X_CAN_FULFILL_PHYSICAL_FLAG in VARCHAR2,
13   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
14   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
15   X_BUDGET_AMOUNT_TC in NUMBER,
16   X_BUDGET_AMOUNT_FC in NUMBER,
17   X_ACTUAL_AVAIL_FROM_DATE in DATE,
18   X_ACTUAL_AVAIL_TO_DATE in DATE,
19   X_CHARGEBACK_AMOUNT in NUMBER,
20   X_CHARGEBACK_UOM in VARCHAR2,
21   X_CHARGEBACK_AMOUNT_CURR_CODE in VARCHAR2,
22   X_DELIVERABLE_CODE in VARCHAR2,
23   X_DELIVERABLE_PICK_FLAG in VARCHAR2,
24   X_CURRENCY_CODE in VARCHAR2,
25   X_FORECASTED_COST in NUMBER,
26   X_ACTUAL_COST in NUMBER,
27   X_FORECASTED_RESPONSES in NUMBER,
28   X_ACTUAL_RESPONSES in NUMBER,
29   X_COUNTRY in VARCHAR2,
30   X_DEFAULT_APPROVER_ID in NUMBER,
31   X_ATTRIBUTE_CATEGORY in VARCHAR2,
32   X_ATTRIBUTE1 in VARCHAR2,
33   X_ATTRIBUTE2 in VARCHAR2,
34   X_ATTRIBUTE3 in VARCHAR2,
35   X_ATTRIBUTE4 in VARCHAR2,
36   X_ATTRIBUTE5 in VARCHAR2,
37   X_ATTRIBUTE6 in VARCHAR2,
38   X_ATTRIBUTE7 in VARCHAR2,
39   X_ATTRIBUTE8 in VARCHAR2,
40   X_ATTRIBUTE9 in VARCHAR2,
41   X_ATTRIBUTE10 in VARCHAR2,
42   X_ATTRIBUTE11 in VARCHAR2,
43   X_ATTRIBUTE12 in VARCHAR2,
44   X_ATTRIBUTE13 in VARCHAR2,
45   X_ATTRIBUTE14 in VARCHAR2,
46   X_ATTRIBUTE15 in VARCHAR2,
47   X_OBJECT_VERSION_NUMBER in NUMBER,
48   X_LANGUAGE_CODE in VARCHAR2,
49   X_VERSION in VARCHAR2,
50   X_APPLICATION_ID in NUMBER,
51   X_USER_STATUS_ID in NUMBER,
52   X_STATUS_CODE in VARCHAR2,
53   X_STATUS_DATE in DATE,
54   X_PRIVATE_FLAG in VARCHAR2,
55   X_ACTIVE_FLAG in VARCHAR2,
56   X_OWNER_USER_ID in NUMBER,
57   X_FUND_SOURCE_ID in NUMBER,
58   X_FUND_SOURCE_TYPE in VARCHAR2,
59   X_CATEGORY_TYPE_ID in NUMBER,
60   X_CATEGORY_SUB_TYPE_ID in NUMBER,
61   X_KIT_FLAG in VARCHAR2,
62   X_INVENTORY_FLAG in VARCHAR2,
63   X_INVENTORY_ITEM_ID in NUMBER,
64   X_INVENTORY_ITEM_ORG_ID in NUMBER,
65   X_DELIVERABLE_NAME in VARCHAR2,
66   X_DESCRIPTION in VARCHAR2,
67   X_CREATION_DATE in DATE,
68   X_CREATED_BY in NUMBER,
69   X_LAST_UPDATE_DATE in DATE,
70   X_LAST_UPDATED_BY in NUMBER,
71   X_LAST_UPDATE_LOGIN in NUMBER);
72 
73 procedure LOCK_ROW (
74   X_DELIVERABLE_ID in NUMBER,
75   X_NON_INV_CTRL_CODE in VARCHAR2,
76   X_NON_INV_QUANTITY_ON_HAND in NUMBER,
77   X_NON_INV_QUANTITY_ON_ORDER in NUMBER,
78   X_NON_INV_QUANTITY_ON_RESERVE in NUMBER,
79   X_REPLACED_BY_DELIVERABLE_ID in NUMBER,
80   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
81   X_CAN_FULFILL_PHYSICAL_FLAG in VARCHAR2,
82   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
83   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
84   X_BUDGET_AMOUNT_TC in NUMBER,
85   X_BUDGET_AMOUNT_FC in NUMBER,
86   X_ACTUAL_AVAIL_FROM_DATE in DATE,
87   X_ACTUAL_AVAIL_TO_DATE in DATE,
88   X_CHARGEBACK_AMOUNT in NUMBER,
89   X_CHARGEBACK_UOM in VARCHAR2,
90   X_CHARGEBACK_AMOUNT_CURR_CODE in VARCHAR2,
91   X_DELIVERABLE_CODE in VARCHAR2,
92   X_DELIVERABLE_PICK_FLAG in VARCHAR2,
93   X_CURRENCY_CODE in VARCHAR2,
94   X_FORECASTED_COST in NUMBER,
95   X_ACTUAL_COST in NUMBER,
96   X_FORECASTED_RESPONSES in NUMBER,
97   X_ACTUAL_RESPONSES in NUMBER,
98   X_COUNTRY in VARCHAR2,
99   X_DEFAULT_APPROVER_ID in NUMBER,
100   X_ATTRIBUTE_CATEGORY in VARCHAR2,
101   X_ATTRIBUTE1 in VARCHAR2,
102   X_ATTRIBUTE2 in VARCHAR2,
103   X_ATTRIBUTE3 in VARCHAR2,
104   X_ATTRIBUTE4 in VARCHAR2,
105   X_ATTRIBUTE5 in VARCHAR2,
106   X_ATTRIBUTE6 in VARCHAR2,
107   X_ATTRIBUTE7 in VARCHAR2,
108   X_ATTRIBUTE8 in VARCHAR2,
109   X_ATTRIBUTE9 in VARCHAR2,
110   X_ATTRIBUTE10 in VARCHAR2,
111   X_ATTRIBUTE11 in VARCHAR2,
112   X_ATTRIBUTE12 in VARCHAR2,
113   X_ATTRIBUTE13 in VARCHAR2,
114   X_ATTRIBUTE14 in VARCHAR2,
115   X_ATTRIBUTE15 in VARCHAR2,
116   X_OBJECT_VERSION_NUMBER in NUMBER,
117   X_LANGUAGE_CODE in VARCHAR2,
118   X_VERSION in VARCHAR2,
119   X_APPLICATION_ID in NUMBER,
120   X_USER_STATUS_ID in NUMBER,
121   X_STATUS_CODE in VARCHAR2,
122   X_STATUS_DATE in DATE,
123   X_PRIVATE_FLAG in VARCHAR2,
124   X_ACTIVE_FLAG in VARCHAR2,
125   X_OWNER_USER_ID in NUMBER,
126   X_FUND_SOURCE_ID in NUMBER,
127   X_FUND_SOURCE_TYPE in VARCHAR2,
128   X_CATEGORY_TYPE_ID in NUMBER,
129   X_CATEGORY_SUB_TYPE_ID in NUMBER,
130   X_KIT_FLAG in VARCHAR2,
131   X_INVENTORY_FLAG in VARCHAR2,
132   X_INVENTORY_ITEM_ID in NUMBER,
133   X_INVENTORY_ITEM_ORG_ID in NUMBER,
134   X_DELIVERABLE_NAME in VARCHAR2,
135   X_DESCRIPTION in VARCHAR2
136 );
137 procedure UPDATE_ROW (
138   X_DELIVERABLE_ID in NUMBER,
139   X_NON_INV_CTRL_CODE in VARCHAR2,
140   X_NON_INV_QUANTITY_ON_HAND in NUMBER,
141   X_NON_INV_QUANTITY_ON_ORDER in NUMBER,
142   X_NON_INV_QUANTITY_ON_RESERVE in NUMBER,
143   X_REPLACED_BY_DELIVERABLE_ID in NUMBER,
144   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
145   X_CAN_FULFILL_PHYSICAL_FLAG in VARCHAR2,
146   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
147   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
148   X_BUDGET_AMOUNT_TC in NUMBER,
149   X_BUDGET_AMOUNT_FC in NUMBER,
150   X_ACTUAL_AVAIL_FROM_DATE in DATE,
151   X_ACTUAL_AVAIL_TO_DATE in DATE,
152   X_CHARGEBACK_AMOUNT in NUMBER,
153   X_CHARGEBACK_UOM in VARCHAR2,
154   X_CHARGEBACK_AMOUNT_CURR_CODE in VARCHAR2,
155   X_DELIVERABLE_CODE in VARCHAR2,
156   X_DELIVERABLE_PICK_FLAG in VARCHAR2,
157   X_CURRENCY_CODE in VARCHAR2,
158   X_FORECASTED_COST in NUMBER,
159   X_ACTUAL_COST in NUMBER,
160   X_FORECASTED_RESPONSES in NUMBER,
161   X_ACTUAL_RESPONSES in NUMBER,
162   X_COUNTRY in VARCHAR2,
163   X_DEFAULT_APPROVER_ID in NUMBER,
164   X_ATTRIBUTE_CATEGORY in VARCHAR2,
165   X_ATTRIBUTE1 in VARCHAR2,
166   X_ATTRIBUTE2 in VARCHAR2,
167   X_ATTRIBUTE3 in VARCHAR2,
168   X_ATTRIBUTE4 in VARCHAR2,
169   X_ATTRIBUTE5 in VARCHAR2,
170   X_ATTRIBUTE6 in VARCHAR2,
171   X_ATTRIBUTE7 in VARCHAR2,
172   X_ATTRIBUTE8 in VARCHAR2,
173   X_ATTRIBUTE9 in VARCHAR2,
174   X_ATTRIBUTE10 in VARCHAR2,
175   X_ATTRIBUTE11 in VARCHAR2,
176   X_ATTRIBUTE12 in VARCHAR2,
177   X_ATTRIBUTE13 in VARCHAR2,
178   X_ATTRIBUTE14 in VARCHAR2,
179   X_ATTRIBUTE15 in VARCHAR2,
180   X_OBJECT_VERSION_NUMBER in NUMBER,
181   X_LANGUAGE_CODE in VARCHAR2,
182   X_VERSION in VARCHAR2,
183   X_APPLICATION_ID in NUMBER,
184   X_USER_STATUS_ID in NUMBER,
185   X_STATUS_CODE in VARCHAR2,
186   X_STATUS_DATE in DATE,
187   X_PRIVATE_FLAG in VARCHAR2,
188   X_ACTIVE_FLAG in VARCHAR2,
189   X_OWNER_USER_ID in NUMBER,
190   X_FUND_SOURCE_ID in NUMBER,
191   X_FUND_SOURCE_TYPE in VARCHAR2,
192   X_CATEGORY_TYPE_ID in NUMBER,
193   X_CATEGORY_SUB_TYPE_ID in NUMBER,
194   X_KIT_FLAG in VARCHAR2,
195   X_INVENTORY_FLAG in VARCHAR2,
196   X_INVENTORY_ITEM_ID in NUMBER,
197   X_INVENTORY_ITEM_ORG_ID in NUMBER,
198   X_DELIVERABLE_NAME in VARCHAR2,
199   X_DESCRIPTION in VARCHAR2,
200   X_LAST_UPDATE_DATE in DATE,
201   X_LAST_UPDATED_BY in NUMBER,
202   X_LAST_UPDATE_LOGIN in NUMBER
203 );
204 
205 procedure DELETE_ROW (
206   X_DELIVERABLE_ID in NUMBER
207 );
208 
209 procedure ADD_LANGUAGE;
210 
211 procedure TRANSLATE_ROW(
212        x_deliverable_id    in NUMBER
213      , x_deliverable_name  in VARCHAR2
214      , x_description    in VARCHAR2
215      , x_owner   in VARCHAR2
216  ) ;
217 
218 procedure  LOAD_ROW(
219   X_DELIVERABLE_ID in NUMBER,
220   X_NON_INV_CTRL_CODE in VARCHAR2,
221   X_NON_INV_QUANTITY_ON_HAND in NUMBER,
222   X_NON_INV_QUANTITY_ON_ORDER in NUMBER,
223   X_NON_INV_QUANTITY_ON_RESERVE in NUMBER,
224   X_REPLACED_BY_DELIVERABLE_ID in NUMBER,
225   X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
226   X_CAN_FULFILL_PHYSICAL_FLAG in VARCHAR2,
227   X_TRANSACTION_CURRENCY_CODE in VARCHAR2,
228   X_FUNCTIONAL_CURRENCY_CODE in VARCHAR2,
229   X_BUDGET_AMOUNT_TC in NUMBER,
230   X_BUDGET_AMOUNT_FC in NUMBER,
231   X_ACTUAL_AVAIL_FROM_DATE in DATE,
232   X_ACTUAL_AVAIL_TO_DATE in DATE,
233   X_CHARGEBACK_AMOUNT in NUMBER,
234   X_CHARGEBACK_UOM in VARCHAR2,
235   X_CHARGEBACK_AMOUNT_CURR_CODE in VARCHAR2,
236   X_DELIVERABLE_CODE in VARCHAR2,
237   X_DELIVERABLE_PICK_FLAG in VARCHAR2,
238   X_CURRENCY_CODE in VARCHAR2,
242   X_ACTUAL_RESPONSES in NUMBER,
239   X_FORECASTED_COST in NUMBER,
240   X_ACTUAL_COST in NUMBER,
241   X_FORECASTED_RESPONSES in NUMBER,
243   X_COUNTRY in VARCHAR2,
244   X_DEFAULT_APPROVER_ID in NUMBER,
245   X_ATTRIBUTE_CATEGORY in VARCHAR2,
246   X_ATTRIBUTE1 in VARCHAR2,
247   X_ATTRIBUTE2 in VARCHAR2,
248   X_ATTRIBUTE3 in VARCHAR2,
249   X_ATTRIBUTE4 in VARCHAR2,
250   X_ATTRIBUTE5 in VARCHAR2,
251   X_ATTRIBUTE6 in VARCHAR2,
252   X_ATTRIBUTE7 in VARCHAR2,
253   X_ATTRIBUTE8 in VARCHAR2,
254   X_ATTRIBUTE9 in VARCHAR2,
255   X_ATTRIBUTE10 in VARCHAR2,
256   X_ATTRIBUTE11 in VARCHAR2,
257   X_ATTRIBUTE12 in VARCHAR2,
258   X_ATTRIBUTE13 in VARCHAR2,
259   X_ATTRIBUTE14 in VARCHAR2,
260   X_ATTRIBUTE15 in VARCHAR2,
261   X_LANGUAGE_CODE in VARCHAR2,
262   X_VERSION in VARCHAR2,
263   X_APPLICATION_ID in NUMBER,
264   X_USER_STATUS_ID in NUMBER,
265   X_STATUS_CODE in VARCHAR2,
266   X_STATUS_DATE in DATE,
267   X_PRIVATE_FLAG in VARCHAR2,
268   X_ACTIVE_FLAG in VARCHAR2,
269   X_OWNER_USER_ID in NUMBER,
270   X_FUND_SOURCE_ID in NUMBER,
271   X_FUND_SOURCE_TYPE in VARCHAR2,
272   X_CATEGORY_TYPE_ID in NUMBER,
273   X_CATEGORY_SUB_TYPE_ID in NUMBER,
274   X_KIT_FLAG in VARCHAR2,
275   X_INVENTORY_FLAG in VARCHAR2,
276   X_INVENTORY_ITEM_ID in NUMBER,
277   X_INVENTORY_ITEM_ORG_ID in NUMBER,
278   X_DELIVERABLE_NAME in VARCHAR2,
279   X_DESCRIPTION in VARCHAR2,
280   X_Owner in VARCHAR2
281 );
282 
283 end AMS_DELIVERABLES_ALL_PKG;