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.

APPS.INV_OPSM_LOT_BE_PKG dependencies on WF_EVENT

Line 39: FROM WF_EVENTS A

35: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
36: L_RAISE_EVENT := FALSE;
37: SELECT COUNT(*)
38: INTO L_NO_ENABLED_SUB
39: FROM WF_EVENTS A
40: ,WF_EVENT_SUBSCRIPTIONS B
41: WHERE A.GUID = B.EVENT_FILTER_GUID
42: AND A.NAME = P_EVENT
43: AND B.JAVA_RULE_FUNC ='oracle.apps.inv.opsm.lot.util.InvOpsmLotRule'

Line 40: ,WF_EVENT_SUBSCRIPTIONS B

36: L_RAISE_EVENT := FALSE;
37: SELECT COUNT(*)
38: INTO L_NO_ENABLED_SUB
39: FROM WF_EVENTS A
40: ,WF_EVENT_SUBSCRIPTIONS B
41: WHERE A.GUID = B.EVENT_FILTER_GUID
42: AND A.NAME = P_EVENT
43: AND B.JAVA_RULE_FUNC ='oracle.apps.inv.opsm.lot.util.InvOpsmLotRule'
44: AND B.STATUS = 'ENABLED'

Line 51: WF_EVENT.RAISE(

47: IF L_NO_ENABLED_SUB > 0 THEN
48: L_RAISE_EVENT := TRUE;
49: END IF;
50: IF (L_RAISE_EVENT) THEN
51: WF_EVENT.RAISE(
52: P_EVENT_NAME => P_EVENT
53: ,P_EVENT_KEY => P_GEN_OBJECT_ID
54: ,P_PARAMETERS => P_PARAMETERS
55: ,P_SEND_DATE => P_SEND_DATE);

Line 117: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_ID',

113: IF L_DEBUG_ON THEN
114: print_debug(L_MODULE_NAME||','||'ADDING PARAMETERS TO WF_PARAMETER_LIST');
115: END IF;
116: --ITEM
117: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_ID',
118: P_VALUE => P_INVENTORY_ITEM_ID,
119: P_PARAMETERLIST => L_PARAMETERS);
120: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM',
121: P_VALUE => replace(P_CONCATENATED_SEGMENTS,'^^^^','&'),

Line 120: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM',

116: --ITEM
117: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_ID',
118: P_VALUE => P_INVENTORY_ITEM_ID,
119: P_PARAMETERLIST => L_PARAMETERS);
120: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM',
121: P_VALUE => replace(P_CONCATENATED_SEGMENTS,'^^^^','&'),
122: P_PARAMETERLIST => L_PARAMETERS);
123: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_DESCRIPTION',
124: P_VALUE => replace(P_ITEM_DESCRIPTION,'^^^^','&'),

Line 123: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_DESCRIPTION',

119: P_PARAMETERLIST => L_PARAMETERS);
120: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM',
121: P_VALUE => replace(P_CONCATENATED_SEGMENTS,'^^^^','&'),
122: P_PARAMETERLIST => L_PARAMETERS);
123: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_DESCRIPTION',
124: P_VALUE => replace(P_ITEM_DESCRIPTION,'^^^^','&'),
125: P_PARAMETERLIST => L_PARAMETERS);
126: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PRIMARY_UOM_CODE',
127: P_VALUE => P_PRIMARY_UOM_CODE,

Line 126: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PRIMARY_UOM_CODE',

122: P_PARAMETERLIST => L_PARAMETERS);
123: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ITEM_DESCRIPTION',
124: P_VALUE => replace(P_ITEM_DESCRIPTION,'^^^^','&'),
125: P_PARAMETERLIST => L_PARAMETERS);
126: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PRIMARY_UOM_CODE',
127: P_VALUE => P_PRIMARY_UOM_CODE,
128: P_PARAMETERLIST => L_PARAMETERS);
129: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_CONTROL_CODE',
130: P_VALUE => P_LOT_CONTROL_CODE,

Line 129: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_CONTROL_CODE',

125: P_PARAMETERLIST => L_PARAMETERS);
126: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PRIMARY_UOM_CODE',
127: P_VALUE => P_PRIMARY_UOM_CODE,
128: P_PARAMETERLIST => L_PARAMETERS);
129: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_CONTROL_CODE',
130: P_VALUE => P_LOT_CONTROL_CODE,
131: P_PARAMETERLIST => L_PARAMETERS);
132: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'SERIAL_CONTROL_CODE',
133: P_VALUE => P_SERIAL_NUMBER_CONTROL_CODE,

Line 132: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'SERIAL_CONTROL_CODE',

128: P_PARAMETERLIST => L_PARAMETERS);
129: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_CONTROL_CODE',
130: P_VALUE => P_LOT_CONTROL_CODE,
131: P_PARAMETERLIST => L_PARAMETERS);
132: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'SERIAL_CONTROL_CODE',
133: P_VALUE => P_SERIAL_NUMBER_CONTROL_CODE,
134: P_PARAMETERLIST => L_PARAMETERS);
135: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'OPSM_INTEGRATED_FLAG',
136: P_VALUE => P_OPSM_INTEGRATED_FLAG,

Line 135: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'OPSM_INTEGRATED_FLAG',

131: P_PARAMETERLIST => L_PARAMETERS);
132: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'SERIAL_CONTROL_CODE',
133: P_VALUE => P_SERIAL_NUMBER_CONTROL_CODE,
134: P_PARAMETERLIST => L_PARAMETERS);
135: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'OPSM_INTEGRATED_FLAG',
136: P_VALUE => P_OPSM_INTEGRATED_FLAG,
137: P_PARAMETERLIST => L_PARAMETERS);
138: --ITEM
139: --org

Line 140: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORGANIZATION_ID',

136: P_VALUE => P_OPSM_INTEGRATED_FLAG,
137: P_PARAMETERLIST => L_PARAMETERS);
138: --ITEM
139: --org
140: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORGANIZATION_ID',
141: P_VALUE => P_ORGANIZATION_ID,
142: P_PARAMETERLIST => L_PARAMETERS);
143: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORGANIZATION_CODE',
144: P_VALUE => P_ORGANIZATION_CODE,

Line 143: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORGANIZATION_CODE',

139: --org
140: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORGANIZATION_ID',
141: P_VALUE => P_ORGANIZATION_ID,
142: P_PARAMETERLIST => L_PARAMETERS);
143: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORGANIZATION_CODE',
144: P_VALUE => P_ORGANIZATION_CODE,
145: P_PARAMETERLIST => L_PARAMETERS);
146: --org
147: --lot

Line 148: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'AGE',

144: P_VALUE => P_ORGANIZATION_CODE,
145: P_PARAMETERLIST => L_PARAMETERS);
146: --org
147: --lot
148: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'AGE',
149: P_VALUE => P_AGE,
150: P_PARAMETERLIST => L_PARAMETERS);
151: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'BEST_BY_DATE',
152: P_VALUE => to_char(P_BEST_BY_DATE,'YYYY-MM-DD HH24:MI:SS'),

Line 151: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'BEST_BY_DATE',

147: --lot
148: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'AGE',
149: P_VALUE => P_AGE,
150: P_PARAMETERLIST => L_PARAMETERS);
151: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'BEST_BY_DATE',
152: P_VALUE => to_char(P_BEST_BY_DATE,'YYYY-MM-DD HH24:MI:SS'),
153: P_PARAMETERLIST => L_PARAMETERS);
154: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'CHANGE_DATE',
155: P_VALUE => to_char(P_CHANGE_DATE,'YYYY-MM-DD HH24:MI:SS'),

Line 154: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'CHANGE_DATE',

150: P_PARAMETERLIST => L_PARAMETERS);
151: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'BEST_BY_DATE',
152: P_VALUE => to_char(P_BEST_BY_DATE,'YYYY-MM-DD HH24:MI:SS'),
153: P_PARAMETERLIST => L_PARAMETERS);
154: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'CHANGE_DATE',
155: P_VALUE => to_char(P_CHANGE_DATE,'YYYY-MM-DD HH24:MI:SS'),
156: P_PARAMETERLIST => L_PARAMETERS);
157: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATION_DATE',
158: P_VALUE => to_char(P_EXPIRATION_DATE,'YYYY-MM-DD HH24:MI:SS'),

Line 157: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATION_DATE',

153: P_PARAMETERLIST => L_PARAMETERS);
154: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'CHANGE_DATE',
155: P_VALUE => to_char(P_CHANGE_DATE,'YYYY-MM-DD HH24:MI:SS'),
156: P_PARAMETERLIST => L_PARAMETERS);
157: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATION_DATE',
158: P_VALUE => to_char(P_EXPIRATION_DATE,'YYYY-MM-DD HH24:MI:SS'),
159: P_PARAMETERLIST => L_PARAMETERS);
160: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'GRADE_CODE',
161: P_VALUE => replace(P_GRADE_CODE,'^^^^','&'),

Line 160: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'GRADE_CODE',

156: P_PARAMETERLIST => L_PARAMETERS);
157: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATION_DATE',
158: P_VALUE => to_char(P_EXPIRATION_DATE,'YYYY-MM-DD HH24:MI:SS'),
159: P_PARAMETERLIST => L_PARAMETERS);
160: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'GRADE_CODE',
161: P_VALUE => replace(P_GRADE_CODE,'^^^^','&'),
162: P_PARAMETERLIST => L_PARAMETERS);
163: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH',
164: P_VALUE => P_LENGTH,

Line 163: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH',

159: P_PARAMETERLIST => L_PARAMETERS);
160: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'GRADE_CODE',
161: P_VALUE => replace(P_GRADE_CODE,'^^^^','&'),
162: P_PARAMETERLIST => L_PARAMETERS);
163: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH',
164: P_VALUE => P_LENGTH,
165: P_PARAMETERLIST => L_PARAMETERS);
166: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH_UOM',
167: P_VALUE => P_LENGTH_UOM,

Line 166: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH_UOM',

162: P_PARAMETERLIST => L_PARAMETERS);
163: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH',
164: P_VALUE => P_LENGTH,
165: P_PARAMETERLIST => L_PARAMETERS);
166: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH_UOM',
167: P_VALUE => P_LENGTH_UOM,
168: P_PARAMETERLIST => L_PARAMETERS);
169: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_DESCRIPTION',
170: P_VALUE => replace(P_LOT_DESCRIPTION,'^^^^','&'),

Line 169: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_DESCRIPTION',

165: P_PARAMETERLIST => L_PARAMETERS);
166: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LENGTH_UOM',
167: P_VALUE => P_LENGTH_UOM,
168: P_PARAMETERLIST => L_PARAMETERS);
169: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_DESCRIPTION',
170: P_VALUE => replace(P_LOT_DESCRIPTION,'^^^^','&'),
171: P_PARAMETERLIST => L_PARAMETERS);
172: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_NUMBER',
173: P_VALUE => replace(P_LOT_NUMBER,'^^^^','&'),

Line 172: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_NUMBER',

168: P_PARAMETERLIST => L_PARAMETERS);
169: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_DESCRIPTION',
170: P_VALUE => replace(P_LOT_DESCRIPTION,'^^^^','&'),
171: P_PARAMETERLIST => L_PARAMETERS);
172: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_NUMBER',
173: P_VALUE => replace(P_LOT_NUMBER,'^^^^','&'),
174: P_PARAMETERLIST => L_PARAMETERS);
175: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'MATURITY_DATE',
176: P_VALUE => to_char(P_MATURITY_DATE,'YYYY-MM-DD HH24:MI:SS'),

Line 175: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'MATURITY_DATE',

171: P_PARAMETERLIST => L_PARAMETERS);
172: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'LOT_NUMBER',
173: P_VALUE => replace(P_LOT_NUMBER,'^^^^','&'),
174: P_PARAMETERLIST => L_PARAMETERS);
175: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'MATURITY_DATE',
176: P_VALUE => to_char(P_MATURITY_DATE,'YYYY-MM-DD HH24:MI:SS'),
177: P_PARAMETERLIST => L_PARAMETERS);
178: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_DATE',
179: P_VALUE => to_char(P_ORIGINATION_DATE,'YYYY-MM-DD HH24:MI:SS'),

Line 178: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_DATE',

174: P_PARAMETERLIST => L_PARAMETERS);
175: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'MATURITY_DATE',
176: P_VALUE => to_char(P_MATURITY_DATE,'YYYY-MM-DD HH24:MI:SS'),
177: P_PARAMETERLIST => L_PARAMETERS);
178: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_DATE',
179: P_VALUE => to_char(P_ORIGINATION_DATE,'YYYY-MM-DD HH24:MI:SS'),
180: P_PARAMETERLIST => L_PARAMETERS);
181: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PLACE_OF_ORIGIN',
182: P_VALUE => replace(P_PLACE_OF_ORIGIN,'^^^^','&'),

Line 181: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PLACE_OF_ORIGIN',

177: P_PARAMETERLIST => L_PARAMETERS);
178: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_DATE',
179: P_VALUE => to_char(P_ORIGINATION_DATE,'YYYY-MM-DD HH24:MI:SS'),
180: P_PARAMETERLIST => L_PARAMETERS);
181: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PLACE_OF_ORIGIN',
182: P_VALUE => replace(P_PLACE_OF_ORIGIN,'^^^^','&'),
183: P_PARAMETERLIST => L_PARAMETERS);
184: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RECYCLED_CONTENT',
185: P_VALUE => P_RECYCLED_CONTENT,

Line 184: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RECYCLED_CONTENT',

180: P_PARAMETERLIST => L_PARAMETERS);
181: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PLACE_OF_ORIGIN',
182: P_VALUE => replace(P_PLACE_OF_ORIGIN,'^^^^','&'),
183: P_PARAMETERLIST => L_PARAMETERS);
184: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RECYCLED_CONTENT',
185: P_VALUE => P_RECYCLED_CONTENT,
186: P_PARAMETERLIST => L_PARAMETERS);
187: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RETEST_DATE',
188: P_VALUE => to_char(P_RETEST_DATE,'YYYY-MM-DD HH24:MI:SS'),

Line 187: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RETEST_DATE',

183: P_PARAMETERLIST => L_PARAMETERS);
184: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RECYCLED_CONTENT',
185: P_VALUE => P_RECYCLED_CONTENT,
186: P_PARAMETERLIST => L_PARAMETERS);
187: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RETEST_DATE',
188: P_VALUE => to_char(P_RETEST_DATE,'YYYY-MM-DD HH24:MI:SS'),
189: P_PARAMETERLIST => L_PARAMETERS);
190: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS',
191: P_VALUE => P_THICKNESS,

Line 190: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS',

186: P_PARAMETERLIST => L_PARAMETERS);
187: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RETEST_DATE',
188: P_VALUE => to_char(P_RETEST_DATE,'YYYY-MM-DD HH24:MI:SS'),
189: P_PARAMETERLIST => L_PARAMETERS);
190: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS',
191: P_VALUE => P_THICKNESS,
192: P_PARAMETERLIST => L_PARAMETERS);
193: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS_UOM',
194: P_VALUE => P_THICKNESS_UOM,

Line 193: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS_UOM',

189: P_PARAMETERLIST => L_PARAMETERS);
190: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS',
191: P_VALUE => P_THICKNESS,
192: P_PARAMETERLIST => L_PARAMETERS);
193: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS_UOM',
194: P_VALUE => P_THICKNESS_UOM,
195: P_PARAMETERLIST => L_PARAMETERS);
196: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME',
197: P_VALUE => P_VOLUME,

Line 196: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME',

192: P_PARAMETERLIST => L_PARAMETERS);
193: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'THICKNESS_UOM',
194: P_VALUE => P_THICKNESS_UOM,
195: P_PARAMETERLIST => L_PARAMETERS);
196: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME',
197: P_VALUE => P_VOLUME,
198: P_PARAMETERLIST => L_PARAMETERS);
199: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME_UOM',
200: P_VALUE => P_VOLUME_UOM,

Line 199: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME_UOM',

195: P_PARAMETERLIST => L_PARAMETERS);
196: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME',
197: P_VALUE => P_VOLUME,
198: P_PARAMETERLIST => L_PARAMETERS);
199: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME_UOM',
200: P_VALUE => P_VOLUME_UOM,
201: P_PARAMETERLIST => L_PARAMETERS);
202: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH',
203: P_VALUE => P_WIDTH,

Line 202: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH',

198: P_PARAMETERLIST => L_PARAMETERS);
199: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'VOLUME_UOM',
200: P_VALUE => P_VOLUME_UOM,
201: P_PARAMETERLIST => L_PARAMETERS);
202: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH',
203: P_VALUE => P_WIDTH,
204: P_PARAMETERLIST => L_PARAMETERS);
205: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH_UOM',
206: P_VALUE => P_WIDTH_UOM,

Line 205: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH_UOM',

201: P_PARAMETERLIST => L_PARAMETERS);
202: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH',
203: P_VALUE => P_WIDTH,
204: P_PARAMETERLIST => L_PARAMETERS);
205: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH_UOM',
206: P_VALUE => P_WIDTH_UOM,
207: P_PARAMETERLIST => L_PARAMETERS);
208: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONCODE',
209: P_VALUE => replace(P_EXPIRATIONACTIONCODE,'^^^^','&'),

Line 208: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONCODE',

204: P_PARAMETERLIST => L_PARAMETERS);
205: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'WIDTH_UOM',
206: P_VALUE => P_WIDTH_UOM,
207: P_PARAMETERLIST => L_PARAMETERS);
208: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONCODE',
209: P_VALUE => replace(P_EXPIRATIONACTIONCODE,'^^^^','&'),
210: P_PARAMETERLIST => L_PARAMETERS);
211: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONDATE',
212: P_VALUE => to_char(P_EXPIRATIONACTIONDATE,'YYYY-MM-DD HH24:MI:SS'),

Line 211: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONDATE',

207: P_PARAMETERLIST => L_PARAMETERS);
208: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONCODE',
209: P_VALUE => replace(P_EXPIRATIONACTIONCODE,'^^^^','&'),
210: P_PARAMETERLIST => L_PARAMETERS);
211: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONDATE',
212: P_VALUE => to_char(P_EXPIRATIONACTIONDATE,'YYYY-MM-DD HH24:MI:SS'),
213: P_PARAMETERLIST => L_PARAMETERS);
214: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PARENT_LOT_NUMBER',
215: P_VALUE => replace(P_PARENT_LOT_NUMBER,'^^^^','&'),

Line 214: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PARENT_LOT_NUMBER',

210: P_PARAMETERLIST => L_PARAMETERS);
211: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'EXPIRATIONACTIONDATE',
212: P_VALUE => to_char(P_EXPIRATIONACTIONDATE,'YYYY-MM-DD HH24:MI:SS'),
213: P_PARAMETERLIST => L_PARAMETERS);
214: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PARENT_LOT_NUMBER',
215: P_VALUE => replace(P_PARENT_LOT_NUMBER,'^^^^','&'),
216: P_PARAMETERLIST => L_PARAMETERS);
217: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RESERVABLE_TYPE',
218: P_VALUE => P_RESERVABLE_TYPE,

Line 217: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RESERVABLE_TYPE',

213: P_PARAMETERLIST => L_PARAMETERS);
214: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'PARENT_LOT_NUMBER',
215: P_VALUE => replace(P_PARENT_LOT_NUMBER,'^^^^','&'),
216: P_PARAMETERLIST => L_PARAMETERS);
217: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RESERVABLE_TYPE',
218: P_VALUE => P_RESERVABLE_TYPE,
219: P_PARAMETERLIST => L_PARAMETERS);
220: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_TYPE',
221: P_VALUE => P_ORIGINATION_TYPE,

Line 220: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_TYPE',

216: P_PARAMETERLIST => L_PARAMETERS);
217: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'RESERVABLE_TYPE',
218: P_VALUE => P_RESERVABLE_TYPE,
219: P_PARAMETERLIST => L_PARAMETERS);
220: WF_EVENT.ADDPARAMETERTOLIST (P_NAME => 'ORIGINATION_TYPE',
221: P_VALUE => P_ORIGINATION_TYPE,
222: P_PARAMETERLIST => L_PARAMETERS);
223: --lot
224: IF L_DEBUG_ON THEN