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

Source


1 package WMS_ELS_INDIVIDUAL_TASKS_PKG as
2 /* $Header: WMSLMITS.pls 120.0 2005/10/27 03:40:47 rvedulla noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out nocopy VARCHAR2,
6   X_ELS_DATA_ID in NUMBER,
7   X_ATTRIBUTE_CATEGORY in VARCHAR2,
8   X_ATTRIBUTE1 in VARCHAR2,
9   X_ATTRIBUTE2 in VARCHAR2,
10   X_ATTRIBUTE3 in VARCHAR2,
11   X_ATTRIBUTE4 in VARCHAR2,
12   X_ATTRIBUTE5 in VARCHAR2,
13   X_ATTRIBUTE6 in VARCHAR2,
14   X_ATTRIBUTE7 in VARCHAR2,
15   X_ATTRIBUTE8 in VARCHAR2,
16   X_ATTRIBUTE9 in VARCHAR2,
17   X_ATTRIBUTE10 in VARCHAR2,
18   X_ATTRIBUTE11 in VARCHAR2,
19   X_ATTRIBUTE12 in VARCHAR2,
20   X_ATTRIBUTE13 in VARCHAR2,
21   X_ATTRIBUTE14 in VARCHAR2,
22   X_ATTRIBUTE15 in VARCHAR2,
23   X_ORGANIZATION_ID in NUMBER,
24   X_SEQUENCE_NUMBER in NUMBER,
25   X_ANALYSIS_ID in NUMBER,
26   X_ACTIVITY_ID in NUMBER,
27   X_ACTIVITY_DETAIL_ID in NUMBER,
28   X_OPERATION_ID in NUMBER,
29   X_EQUIPMENT_ID in NUMBER,
30   X_SOURCE_ZONE_ID in NUMBER,
31   X_SOURCE_SUBINVENTORY in VARCHAR2,
32   X_DESTINATION_ZONE_ID in NUMBER,
33   X_DESTINATION_SUBINVENTORY in VARCHAR2,
34   X_LABOR_TXN_SOURCE_ID in NUMBER,
35   X_TRANSACTION_UOM in VARCHAR2,
36   X_FROM_QUANTITY in NUMBER,
37   X_TO_QUANTITY in NUMBER,
38   X_ITEM_CATEGORY_ID in NUMBER,
39   X_OPERATION_PLAN_ID in NUMBER,
40   X_GROUP_ID in NUMBER,
41   X_TASK_TYPE_ID in NUMBER,
42   X_TASK_METHOD_ID in NUMBER,
43   X_EXPECTED_TRAVEL_TIME in NUMBER,
44   X_EXPECTED_TXN_TIME in NUMBER,
45   X_EXPECTED_IDLE_TIME in NUMBER,
46   X_ACTUAL_TRAVEL_TIME in NUMBER,
47   X_ACTUAL_TXN_TIME in NUMBER,
48   X_ACTUAL_IDLE_TIME in NUMBER,
49   X_TRAVEL_TIME_THRESHOLD in NUMBER,
50   X_HISTORY_FLAG in NUMBER,
51   X_ARCHIVE_DATE in DATE,
52   X_NUM_TRX_MATCHED in NUMBER,
53   X_DESCRIPTION in VARCHAR2,
54   X_CREATION_DATE in DATE,
55   X_CREATED_BY in NUMBER,
56   X_LAST_UPDATE_DATE in DATE,
57   X_LAST_UPDATED_BY in NUMBER,
58   X_LAST_UPDATE_LOGIN in NUMBER);
59 
60 procedure LOCK_ROW (
61   X_ELS_DATA_ID in NUMBER,
62   X_ATTRIBUTE_CATEGORY in VARCHAR2,
63   X_ATTRIBUTE1 in VARCHAR2,
64   X_ATTRIBUTE2 in VARCHAR2,
65   X_ATTRIBUTE3 in VARCHAR2,
66   X_ATTRIBUTE4 in VARCHAR2,
67   X_ATTRIBUTE5 in VARCHAR2,
68   X_ATTRIBUTE6 in VARCHAR2,
69   X_ATTRIBUTE7 in VARCHAR2,
70   X_ATTRIBUTE8 in VARCHAR2,
71   X_ATTRIBUTE9 in VARCHAR2,
72   X_ATTRIBUTE10 in VARCHAR2,
73   X_ATTRIBUTE11 in VARCHAR2,
74   X_ATTRIBUTE12 in VARCHAR2,
75   X_ATTRIBUTE13 in VARCHAR2,
76   X_ATTRIBUTE14 in VARCHAR2,
77   X_ATTRIBUTE15 in VARCHAR2,
78   X_ORGANIZATION_ID in NUMBER,
79   X_SEQUENCE_NUMBER in NUMBER,
80   X_ANALYSIS_ID in NUMBER,
81   X_ACTIVITY_ID in NUMBER,
82   X_ACTIVITY_DETAIL_ID in NUMBER,
83   X_OPERATION_ID in NUMBER,
84   X_EQUIPMENT_ID in NUMBER,
85   X_SOURCE_ZONE_ID in NUMBER,
86   X_SOURCE_SUBINVENTORY in VARCHAR2,
87   X_DESTINATION_ZONE_ID in NUMBER,
88   X_DESTINATION_SUBINVENTORY in VARCHAR2,
89   X_LABOR_TXN_SOURCE_ID in NUMBER,
90   X_TRANSACTION_UOM in VARCHAR2,
91   X_FROM_QUANTITY in NUMBER,
92   X_TO_QUANTITY in NUMBER,
93   X_ITEM_CATEGORY_ID in NUMBER,
94   X_OPERATION_PLAN_ID in NUMBER,
95   X_GROUP_ID in NUMBER,
96   X_TASK_TYPE_ID in NUMBER,
97   X_TASK_METHOD_ID in NUMBER,
98   X_EXPECTED_TRAVEL_TIME in NUMBER,
99   X_EXPECTED_TXN_TIME in NUMBER,
100   X_EXPECTED_IDLE_TIME in NUMBER,
101   X_ACTUAL_TRAVEL_TIME in NUMBER,
102   X_ACTUAL_TXN_TIME in NUMBER,
103   X_ACTUAL_IDLE_TIME in NUMBER,
104   X_TRAVEL_TIME_THRESHOLD in NUMBER,
105   X_HISTORY_FLAG in NUMBER,
106   X_ARCHIVE_DATE in DATE,
107   X_NUM_TRX_MATCHED in NUMBER,
108   X_DESCRIPTION in VARCHAR2
109 );
110 
111 procedure UPDATE_ROW (
112   X_ELS_DATA_ID in NUMBER,
113   X_ATTRIBUTE_CATEGORY in VARCHAR2,
114   X_ATTRIBUTE1 in VARCHAR2,
115   X_ATTRIBUTE2 in VARCHAR2,
116   X_ATTRIBUTE3 in VARCHAR2,
117   X_ATTRIBUTE4 in VARCHAR2,
118   X_ATTRIBUTE5 in VARCHAR2,
119   X_ATTRIBUTE6 in VARCHAR2,
120   X_ATTRIBUTE7 in VARCHAR2,
121   X_ATTRIBUTE8 in VARCHAR2,
122   X_ATTRIBUTE9 in VARCHAR2,
123   X_ATTRIBUTE10 in VARCHAR2,
124   X_ATTRIBUTE11 in VARCHAR2,
125   X_ATTRIBUTE12 in VARCHAR2,
126   X_ATTRIBUTE13 in VARCHAR2,
127   X_ATTRIBUTE14 in VARCHAR2,
128   X_ATTRIBUTE15 in VARCHAR2,
129   X_ORGANIZATION_ID in NUMBER,
130   X_SEQUENCE_NUMBER in NUMBER,
131   X_ANALYSIS_ID in NUMBER,
132   X_ACTIVITY_ID in NUMBER,
133   X_ACTIVITY_DETAIL_ID in NUMBER,
134   X_OPERATION_ID in NUMBER,
135   X_EQUIPMENT_ID in NUMBER,
136   X_SOURCE_ZONE_ID in NUMBER,
137   X_SOURCE_SUBINVENTORY in VARCHAR2,
138   X_DESTINATION_ZONE_ID in NUMBER,
139   X_DESTINATION_SUBINVENTORY in VARCHAR2,
140   X_LABOR_TXN_SOURCE_ID in NUMBER,
141   X_TRANSACTION_UOM in VARCHAR2,
142   X_FROM_QUANTITY in NUMBER,
143   X_TO_QUANTITY in NUMBER,
144   X_ITEM_CATEGORY_ID in NUMBER,
145   X_OPERATION_PLAN_ID in NUMBER,
146   X_GROUP_ID in NUMBER,
147   X_TASK_TYPE_ID in NUMBER,
148   X_TASK_METHOD_ID in NUMBER,
149   X_EXPECTED_TRAVEL_TIME in NUMBER,
150   X_EXPECTED_TXN_TIME in NUMBER,
151   X_EXPECTED_IDLE_TIME in NUMBER,
152   X_ACTUAL_TRAVEL_TIME in NUMBER,
153   X_ACTUAL_TXN_TIME in NUMBER,
154   X_ACTUAL_IDLE_TIME in NUMBER,
155   X_TRAVEL_TIME_THRESHOLD in NUMBER,
156   X_HISTORY_FLAG in NUMBER,
157   X_ARCHIVE_DATE in DATE,
158   X_NUM_TRX_MATCHED in NUMBER,
159   X_DESCRIPTION in VARCHAR2,
160   X_LAST_UPDATE_DATE in DATE,
161   X_LAST_UPDATED_BY in NUMBER,
162   X_LAST_UPDATE_LOGIN in NUMBER
163 );
164 
165 procedure DELETE_ROW (
166   X_ELS_DATA_ID in NUMBER
167 );
168 
169 procedure ADD_LANGUAGE;
170 end WMS_ELS_INDIVIDUAL_TASKS_PKG;