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

Source


1 PACKAGE CSP_ITEM_SUB_INVENTORIES_PKG AUTHID CURRENT_USER as
2 /* $Header: csptpaus.pls 115.5 2002/11/26 07:14:29 hhaugeru ship $ */
3 -- Start of Comments
4 -- Package name     : CSP_ITEM_SUB_INVENTORIES_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_INVENTORY_ITEM_ID   IN OUT NOCOPY NUMBER,
12           p_ORGANIZATION_ID    NUMBER,
13           p_SECONDARY_INVENTORY    VARCHAR2,
14           p_LAST_UPDATE_DATE    DATE,
15           p_LAST_UPDATED_BY    NUMBER,
16           p_CREATION_DATE    DATE,
17           p_CREATED_BY    NUMBER,
18           p_LAST_UPDATE_LOGIN    NUMBER,
19           p_PRIMARY_SUBINVENTORY_FLAG    NUMBER,
20           p_PICKING_ORDER    NUMBER,
21           p_MIN_MINMAX_QUANTITY    NUMBER,
22           p_MAX_MINMAX_QUANTITY    NUMBER,
23           p_INVENTORY_PLANNING_CODE    NUMBER,
24           p_FIXED_LOT_MULTIPLE    NUMBER,
25           p_MINIMUM_ORDER_QUANTITY    NUMBER,
26           p_MAXIMUM_ORDER_QUANTITY    NUMBER,
27           p_SOURCE_TYPE    NUMBER,
28           p_SOURCE_ORGANIZATION_ID    NUMBER,
29           p_SOURCE_SUBINVENTORY    VARCHAR2,
30           p_ATTRIBUTE_CATEGORY    VARCHAR2,
31           p_ATTRIBUTE1    VARCHAR2,
32           p_ATTRIBUTE2    VARCHAR2,
33           p_ATTRIBUTE3    VARCHAR2,
34           p_ATTRIBUTE4    VARCHAR2,
35           p_ATTRIBUTE5    VARCHAR2,
36           p_ATTRIBUTE6    VARCHAR2,
37           p_ATTRIBUTE7    VARCHAR2,
38           p_ATTRIBUTE8    VARCHAR2,
39           p_ATTRIBUTE9    VARCHAR2,
40           p_ATTRIBUTE10    VARCHAR2,
41           p_ATTRIBUTE11    VARCHAR2,
42           p_ATTRIBUTE12    VARCHAR2,
43           p_ATTRIBUTE13    VARCHAR2,
44           p_ATTRIBUTE14    VARCHAR2,
45           p_ATTRIBUTE15    VARCHAR2,
46           p_ENCUMBRANCE_ACCOUNT    NUMBER,
47           p_PREPROCESSING_LEAD_TIME    NUMBER,
48           p_PROCESSING_LEAD_TIME    NUMBER,
49           p_POSTPROCESSING_LEAD_TIME    NUMBER);
50 
51 PROCEDURE Update_Row(
52           p_ROW_ID  VARCHAR2,
53           p_INVENTORY_ITEM_ID    NUMBER,
54           p_ORGANIZATION_ID    NUMBER,
55           p_SECONDARY_INVENTORY    VARCHAR2,
56           p_LAST_UPDATE_DATE    DATE,
57           p_LAST_UPDATED_BY    NUMBER,
58           p_CREATION_DATE    DATE,
59           p_CREATED_BY    NUMBER,
60           p_LAST_UPDATE_LOGIN    NUMBER,
61           p_PRIMARY_SUBINVENTORY_FLAG    NUMBER,
62           p_PICKING_ORDER    NUMBER,
63           p_MIN_MINMAX_QUANTITY    NUMBER,
64           p_MAX_MINMAX_QUANTITY    NUMBER,
65           p_INVENTORY_PLANNING_CODE    NUMBER,
66           p_FIXED_LOT_MULTIPLE    NUMBER,
67           p_MINIMUM_ORDER_QUANTITY    NUMBER,
68           p_MAXIMUM_ORDER_QUANTITY    NUMBER,
69           p_SOURCE_TYPE    NUMBER,
70           p_SOURCE_ORGANIZATION_ID    NUMBER,
71           p_SOURCE_SUBINVENTORY    VARCHAR2,
72           p_ATTRIBUTE_CATEGORY    VARCHAR2,
73           p_ATTRIBUTE1    VARCHAR2,
74           p_ATTRIBUTE2    VARCHAR2,
75           p_ATTRIBUTE3    VARCHAR2,
76           p_ATTRIBUTE4    VARCHAR2,
77           p_ATTRIBUTE5    VARCHAR2,
78           p_ATTRIBUTE6    VARCHAR2,
79           p_ATTRIBUTE7    VARCHAR2,
80           p_ATTRIBUTE8    VARCHAR2,
81           p_ATTRIBUTE9    VARCHAR2,
82           p_ATTRIBUTE10    VARCHAR2,
83           p_ATTRIBUTE11    VARCHAR2,
84           p_ATTRIBUTE12    VARCHAR2,
85           p_ATTRIBUTE13    VARCHAR2,
86           p_ATTRIBUTE14    VARCHAR2,
87           p_ATTRIBUTE15    VARCHAR2,
88           p_ENCUMBRANCE_ACCOUNT    NUMBER,
89           p_PREPROCESSING_LEAD_TIME    NUMBER,
90           p_PROCESSING_LEAD_TIME    NUMBER,
91           p_POSTPROCESSING_LEAD_TIME    NUMBER);
92 
93 PROCEDURE Lock_Row(
94           p_ROW_ID  VARCHAR2,
95           p_INVENTORY_ITEM_ID    NUMBER,
96           p_ORGANIZATION_ID    NUMBER,
97           p_SECONDARY_INVENTORY    VARCHAR2,
98           p_LAST_UPDATE_DATE    DATE,
99           p_LAST_UPDATED_BY    NUMBER,
100           p_CREATION_DATE    DATE,
101           p_CREATED_BY    NUMBER,
102           p_LAST_UPDATE_LOGIN    NUMBER,
103           p_PRIMARY_SUBINVENTORY_FLAG    NUMBER,
104           p_PICKING_ORDER    NUMBER,
105           p_MIN_MINMAX_QUANTITY    NUMBER,
106           p_MAX_MINMAX_QUANTITY    NUMBER,
107           p_INVENTORY_PLANNING_CODE    NUMBER,
108           p_FIXED_LOT_MULTIPLE    NUMBER,
109           p_MINIMUM_ORDER_QUANTITY    NUMBER,
110           p_MAXIMUM_ORDER_QUANTITY    NUMBER,
111           p_SOURCE_TYPE    NUMBER,
112           p_SOURCE_ORGANIZATION_ID    NUMBER,
113           p_SOURCE_SUBINVENTORY    VARCHAR2,
114           p_ATTRIBUTE_CATEGORY    VARCHAR2,
115           p_ATTRIBUTE1    VARCHAR2,
116           p_ATTRIBUTE2    VARCHAR2,
117           p_ATTRIBUTE3    VARCHAR2,
118           p_ATTRIBUTE4    VARCHAR2,
119           p_ATTRIBUTE5    VARCHAR2,
120           p_ATTRIBUTE6    VARCHAR2,
121           p_ATTRIBUTE7    VARCHAR2,
122           p_ATTRIBUTE8    VARCHAR2,
123           p_ATTRIBUTE9    VARCHAR2,
124           p_ATTRIBUTE10    VARCHAR2,
125           p_ATTRIBUTE11    VARCHAR2,
126           p_ATTRIBUTE12    VARCHAR2,
127           p_ATTRIBUTE13    VARCHAR2,
128           p_ATTRIBUTE14    VARCHAR2,
129           p_ATTRIBUTE15    VARCHAR2,
130           p_ENCUMBRANCE_ACCOUNT    NUMBER,
131           p_PREPROCESSING_LEAD_TIME    NUMBER,
132           p_PROCESSING_LEAD_TIME    NUMBER,
133           p_POSTPROCESSING_LEAD_TIME    NUMBER);
134 
135 PROCEDURE Delete_Row(
136           p_INVENTORY_ITEM_ID    NUMBER,
137           p_ORGANIZATION_ID    NUMBER,
138           p_SECONDARY_INVENTORY    VARCHAR2);
139 End CSP_ITEM_SUB_INVENTORIES_PKG;