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.EAM_PROCESS_WO_PVT dependencies on WF_EVENT

Line 127: l_wf_event_seq NUMBER;

123: l_status_pending_event VARCHAR2(240);
124: l_event_name VARCHAR2(240);
125: l_parameter_list wf_parameter_list_t;
126: l_event_key VARCHAR2(200);
127: l_wf_event_seq NUMBER;
128: l_estimation_status NUMBER;
129: l_cost_estimate NUMBER;
130: l_return_status VARCHAR2(1);
131: l_err_text VARCHAR2(2000);

Line 141: IF(p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE AND (WF_EVENT.TEST(l_create_event) <> 'NONE')) THEN

137: l_status_changed_event := 'oracle.apps.eam.workorder.status.changed';
138:
139:
140: --if workorder created and create event enabled
141: IF(p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE AND (WF_EVENT.TEST(l_create_event) <> 'NONE')) THEN
142: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
143: INTO l_wf_event_seq
144: FROM DUAL;
145:

Line 143: INTO l_wf_event_seq

139:
140: --if workorder created and create event enabled
141: IF(p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE AND (WF_EVENT.TEST(l_create_event) <> 'NONE')) THEN
142: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
143: INTO l_wf_event_seq
144: FROM DUAL;
145:
146: l_parameter_list := wf_parameter_list_t();
147: l_event_name := l_create_event;

Line 149: l_event_key := TO_CHAR(l_wf_event_seq);

145:
146: l_parameter_list := wf_parameter_list_t();
147: l_event_name := l_create_event;
148:
149: l_event_key := TO_CHAR(l_wf_event_seq);
150: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Creation event','Building parameter list');
151: -- Add Parameters
152: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
153: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),

Line 152: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

148:
149: l_event_key := TO_CHAR(l_wf_event_seq);
150: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Creation event','Building parameter list');
151: -- Add Parameters
152: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
153: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),
154: p_parameterlist => l_parameter_list);
155: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
156: p_value =>p_eam_wo_rec.wip_entity_name,

Line 155: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

151: -- Add Parameters
152: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
153: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),
154: p_parameterlist => l_parameter_list);
155: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
156: p_value =>p_eam_wo_rec.wip_entity_name,
157: p_parameterlist => l_parameter_list);
158: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
159: p_value => TO_CHAR(p_eam_wo_rec.organization_id),

Line 158: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

154: p_parameterlist => l_parameter_list);
155: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
156: p_value =>p_eam_wo_rec.wip_entity_name,
157: p_parameterlist => l_parameter_list);
158: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
159: p_value => TO_CHAR(p_eam_wo_rec.organization_id),
160: p_parameterlist => l_parameter_list);
161: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
162: p_value => TO_CHAR(p_eam_wo_rec.status_type),

Line 161: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

157: p_parameterlist => l_parameter_list);
158: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
159: p_value => TO_CHAR(p_eam_wo_rec.organization_id),
160: p_parameterlist => l_parameter_list);
161: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
162: p_value => TO_CHAR(p_eam_wo_rec.status_type),
163: p_parameterlist => l_parameter_list);
164: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
165: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),

Line 164: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

160: p_parameterlist => l_parameter_list);
161: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
162: p_value => TO_CHAR(p_eam_wo_rec.status_type),
163: p_parameterlist => l_parameter_list);
164: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
165: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),
166: p_parameterlist => l_parameter_list);
167: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
168: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),

Line 167: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

163: p_parameterlist => l_parameter_list);
164: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
165: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),
166: p_parameterlist => l_parameter_list);
167: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
168: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
169: p_parameterlist => l_parameter_list);
170: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
171: p_value =>FND_GLOBAL.USER_NAME ,

Line 170: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

166: p_parameterlist => l_parameter_list);
167: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
168: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
169: p_parameterlist => l_parameter_list);
170: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
171: p_value =>FND_GLOBAL.USER_NAME ,
172: p_parameterlist => l_parameter_list);
173: Wf_Core.Context('Enterprise Asset Management...','Work Order Creation Event','Raising event');
174:

Line 175: Wf_Event.Raise( p_event_name => l_event_name,

171: p_value =>FND_GLOBAL.USER_NAME ,
172: p_parameterlist => l_parameter_list);
173: Wf_Core.Context('Enterprise Asset Management...','Work Order Creation Event','Raising event');
174:
175: Wf_Event.Raise( p_event_name => l_event_name,
176: p_event_key => l_event_key,
177: p_parameters => l_parameter_list);
178: l_parameter_list.DELETE;
179: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Creation Event','After raising event');

Line 191: AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled

187: OR (p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UPDATE --workorder updated
188: --and old status is not same as new status
189: AND (p_old_eam_wo_rec.user_defined_status_id <>p_eam_wo_rec.user_defined_status_id OR NVL(p_old_eam_wo_rec.pending_flag,'N')='Y' )
190: ))
191: AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
192: ) THEN
193: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
194: INTO l_wf_event_seq
195: FROM DUAL;

Line 194: INTO l_wf_event_seq

190: ))
191: AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
192: ) THEN
193: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
194: INTO l_wf_event_seq
195: FROM DUAL;
196:
197: l_parameter_list := wf_parameter_list_t();
198: l_event_name := l_status_changed_event;

Line 200: l_event_key := TO_CHAR(l_wf_event_seq);

196:
197: l_parameter_list := wf_parameter_list_t();
198: l_event_name := l_status_changed_event;
199:
200: l_event_key := TO_CHAR(l_wf_event_seq);
201: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
202: -- Add Parameters
203: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
204: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),

Line 203: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

199:
200: l_event_key := TO_CHAR(l_wf_event_seq);
201: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
202: -- Add Parameters
203: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
204: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),
205: p_parameterlist => l_parameter_list);
206: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
207: p_value =>p_eam_wo_rec.wip_entity_name,

Line 206: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

202: -- Add Parameters
203: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
204: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),
205: p_parameterlist => l_parameter_list);
206: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
207: p_value =>p_eam_wo_rec.wip_entity_name,
208: p_parameterlist => l_parameter_list);
209: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
210: p_value => TO_CHAR(p_eam_wo_rec.organization_id),

Line 209: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

205: p_parameterlist => l_parameter_list);
206: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
207: p_value =>p_eam_wo_rec.wip_entity_name,
208: p_parameterlist => l_parameter_list);
209: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
210: p_value => TO_CHAR(p_eam_wo_rec.organization_id),
211: p_parameterlist => l_parameter_list);
212: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
213: p_value => TO_CHAR(p_eam_wo_rec.status_type),

Line 212: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

208: p_parameterlist => l_parameter_list);
209: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
210: p_value => TO_CHAR(p_eam_wo_rec.organization_id),
211: p_parameterlist => l_parameter_list);
212: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
213: p_value => TO_CHAR(p_eam_wo_rec.status_type),
214: p_parameterlist => l_parameter_list);
215: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
216: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),

Line 215: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

211: p_parameterlist => l_parameter_list);
212: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
213: p_value => TO_CHAR(p_eam_wo_rec.status_type),
214: p_parameterlist => l_parameter_list);
215: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
216: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),
217: p_parameterlist => l_parameter_list);
218: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
219: p_value => TO_CHAR(p_old_eam_wo_rec.status_type),

Line 218: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

214: p_parameterlist => l_parameter_list);
215: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
216: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),
217: p_parameterlist => l_parameter_list);
218: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
219: p_value => TO_CHAR(p_old_eam_wo_rec.status_type),
220: p_parameterlist => l_parameter_list);
221: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
222: p_value => TO_CHAR(p_old_eam_wo_rec.user_defined_status_id),

Line 221: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',

217: p_parameterlist => l_parameter_list);
218: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
219: p_value => TO_CHAR(p_old_eam_wo_rec.status_type),
220: p_parameterlist => l_parameter_list);
221: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
222: p_value => TO_CHAR(p_old_eam_wo_rec.user_defined_status_id),
223: p_parameterlist => l_parameter_list);
224: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
225: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),

Line 224: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

220: p_parameterlist => l_parameter_list);
221: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
222: p_value => TO_CHAR(p_old_eam_wo_rec.user_defined_status_id),
223: p_parameterlist => l_parameter_list);
224: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
225: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
226: p_parameterlist => l_parameter_list);
227: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
228: p_value =>FND_GLOBAL.USER_NAME ,

Line 227: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

223: p_parameterlist => l_parameter_list);
224: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
225: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
226: p_parameterlist => l_parameter_list);
227: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
228: p_value =>FND_GLOBAL.USER_NAME ,
229: p_parameterlist => l_parameter_list);
230: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
231:

Line 232: Wf_Event.Raise( p_event_name => l_event_name,

228: p_value =>FND_GLOBAL.USER_NAME ,
229: p_parameterlist => l_parameter_list);
230: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
231:
232: Wf_Event.Raise( p_event_name => l_event_name,
233: p_event_key => l_event_key,
234: p_parameters => l_parameter_list);
235: l_parameter_list.DELETE;
236: WF_CORE.CONTEXT('Enterprise Asset Management..','Work Order Status Changed Event','After raising event');

Line 241: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') --event is enabled

237: END IF; --end of check for status change event
238:
239: --if status change needs approval
240: IF( p_approval_required
241: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') --event is enabled
242: ) THEN
243:
244: --Find the total estimated cost of workorder
245: BEGIN

Line 257: INTO l_wf_event_seq

253: END;
254:
255:
256: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
257: INTO l_wf_event_seq
258: FROM DUAL;
259:
260: l_parameter_list := wf_parameter_list_t();
261: l_event_name := l_status_pending_event;

Line 263: l_event_key := TO_CHAR(l_wf_event_seq);

259:
260: l_parameter_list := wf_parameter_list_t();
261: l_event_name := l_status_pending_event;
262:
263: l_event_key := TO_CHAR(l_wf_event_seq);
264:
265:
266: INSERT INTO EAM_WO_WORKFLOWS
267: (WIP_ENTITY_ID,WF_ITEM_TYPE,WF_ITEM_KEY,LAST_UPDATE_DATE,LAST_UPDATED_BY,

Line 277: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

273:
274:
275: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');
276: -- Add Parameters
277: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
278: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),
279: p_parameterlist => l_parameter_list);
280: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
281: p_value =>p_eam_wo_rec.wip_entity_name,

Line 280: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

276: -- Add Parameters
277: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
278: p_value => TO_CHAR(p_eam_wo_rec.wip_entity_id),
279: p_parameterlist => l_parameter_list);
280: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
281: p_value =>p_eam_wo_rec.wip_entity_name,
282: p_parameterlist => l_parameter_list);
283: Wf_Event.AddParameterToList(p_name =>'DESCRIPTION',
284: p_value =>p_eam_wo_rec.description,

Line 283: Wf_Event.AddParameterToList(p_name =>'DESCRIPTION',

279: p_parameterlist => l_parameter_list);
280: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
281: p_value =>p_eam_wo_rec.wip_entity_name,
282: p_parameterlist => l_parameter_list);
283: Wf_Event.AddParameterToList(p_name =>'DESCRIPTION',
284: p_value =>p_eam_wo_rec.description,
285: p_parameterlist => l_parameter_list);
286: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
287: p_value => TO_CHAR(p_eam_wo_rec.organization_id),

Line 286: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

282: p_parameterlist => l_parameter_list);
283: Wf_Event.AddParameterToList(p_name =>'DESCRIPTION',
284: p_value =>p_eam_wo_rec.description,
285: p_parameterlist => l_parameter_list);
286: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
287: p_value => TO_CHAR(p_eam_wo_rec.organization_id),
288: p_parameterlist => l_parameter_list);
289: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
290: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),

Line 289: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

285: p_parameterlist => l_parameter_list);
286: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
287: p_value => TO_CHAR(p_eam_wo_rec.organization_id),
288: p_parameterlist => l_parameter_list);
289: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
290: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),
291: p_parameterlist => l_parameter_list);
292: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
293: p_value => TO_CHAR(p_old_eam_wo_rec.status_type),

Line 292: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

288: p_parameterlist => l_parameter_list);
289: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
290: p_value => TO_CHAR(p_eam_wo_rec.user_defined_status_id),
291: p_parameterlist => l_parameter_list);
292: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
293: p_value => TO_CHAR(p_old_eam_wo_rec.status_type),
294: p_parameterlist => l_parameter_list);
295: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
296: p_value => TO_CHAR(p_old_eam_wo_rec.user_defined_status_id),

Line 295: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',

291: p_parameterlist => l_parameter_list);
292: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
293: p_value => TO_CHAR(p_old_eam_wo_rec.status_type),
294: p_parameterlist => l_parameter_list);
295: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
296: p_value => TO_CHAR(p_old_eam_wo_rec.user_defined_status_id),
297: p_parameterlist => l_parameter_list);
298: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
299: p_value => TO_CHAR(p_new_system_status),

Line 298: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

294: p_parameterlist => l_parameter_list);
295: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
296: p_value => TO_CHAR(p_old_eam_wo_rec.user_defined_status_id),
297: p_parameterlist => l_parameter_list);
298: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
299: p_value => TO_CHAR(p_new_system_status),
300: p_parameterlist => l_parameter_list);
301: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
302: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),

Line 301: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

297: p_parameterlist => l_parameter_list);
298: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
299: p_value => TO_CHAR(p_new_system_status),
300: p_parameterlist => l_parameter_list);
301: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
302: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
303: p_parameterlist => l_parameter_list);
304: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
305: p_value =>FND_GLOBAL.USER_NAME ,

Line 304: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

300: p_parameterlist => l_parameter_list);
301: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
302: p_value => TO_CHAR(p_eam_wo_rec.workflow_type),
303: p_parameterlist => l_parameter_list);
304: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
305: p_value =>FND_GLOBAL.USER_NAME ,
306: p_parameterlist => l_parameter_list);
307: Wf_Event.AddParameterToList(p_name =>'WARRANTY_STATUS',
308: p_value => TO_CHAR(p_eam_wo_rec.warranty_claim_status),

Line 307: Wf_Event.AddParameterToList(p_name =>'WARRANTY_STATUS',

303: p_parameterlist => l_parameter_list);
304: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
305: p_value =>FND_GLOBAL.USER_NAME ,
306: p_parameterlist => l_parameter_list);
307: Wf_Event.AddParameterToList(p_name =>'WARRANTY_STATUS',
308: p_value => TO_CHAR(p_eam_wo_rec.warranty_claim_status),
309: p_parameterlist => l_parameter_list);
310: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
311: p_value => p_workflow_name,

Line 310: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',

306: p_parameterlist => l_parameter_list);
307: Wf_Event.AddParameterToList(p_name =>'WARRANTY_STATUS',
308: p_value => TO_CHAR(p_eam_wo_rec.warranty_claim_status),
309: p_parameterlist => l_parameter_list);
310: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
311: p_value => p_workflow_name,
312: p_parameterlist => l_parameter_list);
313: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
314: p_value => p_workflow_process,

Line 313: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',

309: p_parameterlist => l_parameter_list);
310: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
311: p_value => p_workflow_name,
312: p_parameterlist => l_parameter_list);
313: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
314: p_value => p_workflow_process,
315: p_parameterlist => l_parameter_list);
316: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
317: p_value => TO_CHAR(l_cost_estimate),

Line 316: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',

312: p_parameterlist => l_parameter_list);
313: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
314: p_value => p_workflow_process,
315: p_parameterlist => l_parameter_list);
316: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
317: p_value => TO_CHAR(l_cost_estimate),
318: p_parameterlist => l_parameter_list);
319: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
320:

Line 321: Wf_Event.Raise( p_event_name => l_event_name,

317: p_value => TO_CHAR(l_cost_estimate),
318: p_parameterlist => l_parameter_list);
319: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
320:
321: Wf_Event.Raise( p_event_name => l_event_name,
322: p_event_key => l_event_key,
323: p_parameters => l_parameter_list);
324: l_parameter_list.DELETE;
325: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released Event','After raising event');

Line 7763: IF(WF_EVENT.TEST(l_status_pending_event) <> 'NONE') THEN

7759: --and old status is not same as new status
7760: AND (l_old_eam_wo_rec.status_type <>l_eam_wo_rec.status_type)
7761: )
7762: ) THEN
7763: IF(WF_EVENT.TEST(l_status_pending_event) <> 'NONE') THEN
7764: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Calling Wkflow required check API...') ; END IF;
7765: EAM_WORKFLOW_DETAILS_PUB.Eam_Wf_Is_Approval_Required(p_old_wo_rec => l_old_eam_wo_rec,
7766: p_new_wo_rec => l_eam_wo_rec,
7767: p_wip_entity_id => NULL,

Line 11654: l_wf_event_seq NUMBER;

11650: l_workflow_type NUMBER;
11651: l_event_name VARCHAR2(240);
11652: l_parameter_list wf_parameter_list_t;
11653: l_event_key VARCHAR2(200);
11654: l_wf_event_seq NUMBER;
11655: l_cost_estimate NUMBER;
11656: l_asset_instance_number VARCHAR2(30);
11657: l_instance_id NUMBER;
11658:

Line 11886: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') )THEN

11882: END IF;
11883:
11884:
11885: IF(l_workflow_enabled='Y' AND l_eam_wo_comp_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
11886: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') )THEN
11887: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking WF Approval mandatory . . . '); END IF;
11888: EAM_WORKFLOW_DETAILS_PUB.Eam_Wf_Is_Approval_Required(p_old_wo_rec => NULL,
11889: p_new_wo_rec => NULL,
11890: p_wip_entity_id => l_eam_wo_comp_rec.wip_entity_id,

Line 11924: INTO l_wf_event_seq

11920: END;
11921:
11922:
11923: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
11924: INTO l_wf_event_seq
11925: FROM DUAL;
11926:
11927: l_parameter_list := wf_parameter_list_t();
11928: l_event_name := l_status_pending_event;

Line 11930: l_event_key := TO_CHAR(l_wf_event_seq);

11926:
11927: l_parameter_list := wf_parameter_list_t();
11928: l_event_name := l_status_pending_event;
11929:
11930: l_event_key := TO_CHAR(l_wf_event_seq);
11931:
11932:
11933: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inserting into EAM_WO_WORKFLOWS ...'); END IF;
11934: INSERT INTO EAM_WO_WORKFLOWS

Line 11945: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

11941:
11942:
11943: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');
11944: -- Add Parameters
11945: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
11946: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
11947: p_parameterlist => l_parameter_list);
11948: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
11949: p_value =>l_wip_entity_name,

Line 11948: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

11944: -- Add Parameters
11945: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
11946: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
11947: p_parameterlist => l_parameter_list);
11948: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
11949: p_value =>l_wip_entity_name,
11950: p_parameterlist => l_parameter_list);
11951: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
11952: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),

Line 11951: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

11947: p_parameterlist => l_parameter_list);
11948: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
11949: p_value =>l_wip_entity_name,
11950: p_parameterlist => l_parameter_list);
11951: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
11952: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
11953: p_parameterlist => l_parameter_list);
11954: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
11955: p_value =>TO_CHAR(l_new_eam_status) ,

Line 11954: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

11950: p_parameterlist => l_parameter_list);
11951: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
11952: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
11953: p_parameterlist => l_parameter_list);
11954: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
11955: p_value =>TO_CHAR(l_new_eam_status) ,
11956: p_parameterlist => l_parameter_list);
11957: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
11958: p_value => TO_CHAR(l_old_system_status),

Line 11957: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

11953: p_parameterlist => l_parameter_list);
11954: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
11955: p_value =>TO_CHAR(l_new_eam_status) ,
11956: p_parameterlist => l_parameter_list);
11957: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
11958: p_value => TO_CHAR(l_old_system_status),
11959: p_parameterlist => l_parameter_list);
11960: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
11961: p_value => TO_CHAR(l_old_eam_status),

Line 11960: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',

11956: p_parameterlist => l_parameter_list);
11957: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
11958: p_value => TO_CHAR(l_old_system_status),
11959: p_parameterlist => l_parameter_list);
11960: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
11961: p_value => TO_CHAR(l_old_eam_status),
11962: p_parameterlist => l_parameter_list);
11963: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
11964: p_value => TO_CHAR(l_new_system_status),

Line 11963: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

11959: p_parameterlist => l_parameter_list);
11960: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
11961: p_value => TO_CHAR(l_old_eam_status),
11962: p_parameterlist => l_parameter_list);
11963: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
11964: p_value => TO_CHAR(l_new_system_status),
11965: p_parameterlist => l_parameter_list);
11966: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11967: p_value => TO_CHAR(l_workflow_type),

Line 11966: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

11962: p_parameterlist => l_parameter_list);
11963: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
11964: p_value => TO_CHAR(l_new_system_status),
11965: p_parameterlist => l_parameter_list);
11966: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11967: p_value => TO_CHAR(l_workflow_type),
11968: p_parameterlist => l_parameter_list);
11969: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11970: p_value =>FND_GLOBAL.USER_NAME ,

Line 11969: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

11965: p_parameterlist => l_parameter_list);
11966: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11967: p_value => TO_CHAR(l_workflow_type),
11968: p_parameterlist => l_parameter_list);
11969: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11970: p_value =>FND_GLOBAL.USER_NAME ,
11971: p_parameterlist => l_parameter_list);
11972: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11973: p_value => l_workflow_name,

Line 11972: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',

11968: p_parameterlist => l_parameter_list);
11969: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11970: p_value =>FND_GLOBAL.USER_NAME ,
11971: p_parameterlist => l_parameter_list);
11972: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11973: p_value => l_workflow_name,
11974: p_parameterlist => l_parameter_list);
11975: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
11976: p_value => l_workflow_process,

Line 11975: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',

11971: p_parameterlist => l_parameter_list);
11972: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11973: p_value => l_workflow_name,
11974: p_parameterlist => l_parameter_list);
11975: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
11976: p_value => l_workflow_process,
11977: p_parameterlist => l_parameter_list);
11978: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
11979: p_value => TO_CHAR(l_cost_estimate),

Line 11978: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',

11974: p_parameterlist => l_parameter_list);
11975: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
11976: p_value => l_workflow_process,
11977: p_parameterlist => l_parameter_list);
11978: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
11979: p_value => TO_CHAR(l_cost_estimate),
11980: p_parameterlist => l_parameter_list);
11981: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
11982:

Line 11983: Wf_Event.Raise( p_event_name => l_event_name,

11979: p_value => TO_CHAR(l_cost_estimate),
11980: p_parameterlist => l_parameter_list);
11981: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
11982:
11983: Wf_Event.Raise( p_event_name => l_event_name,
11984: p_event_key => l_event_key,
11985: p_parameters => l_parameter_list);
11986: l_parameter_list.DELETE;
11987: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released Event','After raising event');

Line 12686: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled

12682: end;
12683: END IF;
12684: --Raise status changed event when a workorder is completed/uncompleted
12685:
12686: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
12687: ) THEN
12688:
12689: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12690: INTO l_wf_event_seq

Line 12690: INTO l_wf_event_seq

12686: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
12687: ) THEN
12688:
12689: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12690: INTO l_wf_event_seq
12691: FROM DUAL;
12692:
12693: l_parameter_list := wf_parameter_list_t();
12694: l_event_name := l_status_changed_event;

Line 12696: l_event_key := TO_CHAR(l_wf_event_seq);

12692:
12693: l_parameter_list := wf_parameter_list_t();
12694: l_event_name := l_status_changed_event;
12695:
12696: l_event_key := TO_CHAR(l_wf_event_seq);
12697: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
12698: -- Add Parameters
12699: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12700: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),

Line 12699: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

12695:
12696: l_event_key := TO_CHAR(l_wf_event_seq);
12697: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
12698: -- Add Parameters
12699: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12700: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
12701: p_parameterlist => l_parameter_list);
12702: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12703: p_value =>l_wip_entity_name,

Line 12702: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

12698: -- Add Parameters
12699: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12700: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
12701: p_parameterlist => l_parameter_list);
12702: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12703: p_value =>l_wip_entity_name,
12704: p_parameterlist => l_parameter_list);
12705: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12706: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),

Line 12705: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

12701: p_parameterlist => l_parameter_list);
12702: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12703: p_value =>l_wip_entity_name,
12704: p_parameterlist => l_parameter_list);
12705: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12706: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
12707: p_parameterlist => l_parameter_list);
12708: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
12709: p_value => TO_CHAR(l_new_system_status),

Line 12708: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',

12704: p_parameterlist => l_parameter_list);
12705: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12706: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
12707: p_parameterlist => l_parameter_list);
12708: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
12709: p_value => TO_CHAR(l_new_system_status),
12710: p_parameterlist => l_parameter_list);
12711: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
12712: p_value => TO_CHAR(l_new_eam_status),

Line 12711: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',

12707: p_parameterlist => l_parameter_list);
12708: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
12709: p_value => TO_CHAR(l_new_system_status),
12710: p_parameterlist => l_parameter_list);
12711: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
12712: p_value => TO_CHAR(l_new_eam_status),
12713: p_parameterlist => l_parameter_list);
12714: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
12715: p_value => TO_CHAR(l_old_system_status),

Line 12714: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',

12710: p_parameterlist => l_parameter_list);
12711: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
12712: p_value => TO_CHAR(l_new_eam_status),
12713: p_parameterlist => l_parameter_list);
12714: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
12715: p_value => TO_CHAR(l_old_system_status),
12716: p_parameterlist => l_parameter_list);
12717: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
12718: p_value => TO_CHAR(l_old_eam_status),

Line 12717: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',

12713: p_parameterlist => l_parameter_list);
12714: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
12715: p_value => TO_CHAR(l_old_system_status),
12716: p_parameterlist => l_parameter_list);
12717: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
12718: p_value => TO_CHAR(l_old_eam_status),
12719: p_parameterlist => l_parameter_list);
12720: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12721: p_value => TO_CHAR(l_workflow_type),

Line 12720: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

12716: p_parameterlist => l_parameter_list);
12717: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
12718: p_value => TO_CHAR(l_old_eam_status),
12719: p_parameterlist => l_parameter_list);
12720: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12721: p_value => TO_CHAR(l_workflow_type),
12722: p_parameterlist => l_parameter_list);
12723: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12724: p_value =>FND_GLOBAL.USER_NAME ,

Line 12723: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

12719: p_parameterlist => l_parameter_list);
12720: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12721: p_value => TO_CHAR(l_workflow_type),
12722: p_parameterlist => l_parameter_list);
12723: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12724: p_value =>FND_GLOBAL.USER_NAME ,
12725: p_parameterlist => l_parameter_list);
12726: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
12727:

Line 12728: Wf_Event.Raise( p_event_name => l_event_name,

12724: p_value =>FND_GLOBAL.USER_NAME ,
12725: p_parameterlist => l_parameter_list);
12726: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
12727:
12728: Wf_Event.Raise( p_event_name => l_event_name,
12729: p_event_key => l_event_key,
12730: p_parameters => l_parameter_list);
12731: l_parameter_list.DELETE;
12732: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status Changed Event','After raising event');

Line 12956: l_wf_event_seq NUMBER;

12952: l_workflow_type NUMBER;
12953: l_is_last_operation VARCHAR2(1);
12954: l_parameter_list wf_parameter_list_t;
12955: l_event_key VARCHAR2(200);
12956: l_wf_event_seq NUMBER;
12957: l_op_sched_end_date DATE;
12958: l_asset_instance_number VARCHAR2(30);
12959:
12960: BEGIN

Line 13296: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN

13292:
13293:
13294:
13295: IF(l_workflow_enabled='Y' AND (l_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE)
13296: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN
13297:
13298: SELECT last_unit_completion_date
13299: INTO l_op_sched_end_date
13300: FROM WIP_OPERATIONS

Line 13312: INTO l_wf_event_seq

13308: where won.wip_entity_id = l_eam_op_comp_rec.wip_entity_id and
13309: won.prior_operation = l_eam_op_comp_rec.operation_seq_num;
13310:
13311: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
13312: INTO l_wf_event_seq
13313: FROM DUAL;
13314:
13315: l_parameter_list := wf_parameter_list_t();
13316:

Line 13317: l_event_key := TO_CHAR(l_wf_event_seq);

13313: FROM DUAL;
13314:
13315: l_parameter_list := wf_parameter_list_t();
13316:
13317: l_event_key := TO_CHAR(l_wf_event_seq);
13318: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Op Completed event','Building parameter list');
13319: -- Add Parameters
13320: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
13321: p_value => TO_CHAR( l_eam_op_comp_rec.wip_entity_id),

Line 13320: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',

13316:
13317: l_event_key := TO_CHAR(l_wf_event_seq);
13318: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Op Completed event','Building parameter list');
13319: -- Add Parameters
13320: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
13321: p_value => TO_CHAR( l_eam_op_comp_rec.wip_entity_id),
13322: p_parameterlist => l_parameter_list);
13323: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
13324: p_value =>l_wip_entity_name,

Line 13323: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',

13319: -- Add Parameters
13320: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
13321: p_value => TO_CHAR( l_eam_op_comp_rec.wip_entity_id),
13322: p_parameterlist => l_parameter_list);
13323: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
13324: p_value =>l_wip_entity_name,
13325: p_parameterlist => l_parameter_list);
13326: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
13327: p_value => TO_CHAR(l_org_id),

Line 13326: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',

13322: p_parameterlist => l_parameter_list);
13323: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
13324: p_value =>l_wip_entity_name,
13325: p_parameterlist => l_parameter_list);
13326: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
13327: p_value => TO_CHAR(l_org_id),
13328: p_parameterlist => l_parameter_list);
13329: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
13330: p_value => TO_CHAR(l_eam_op_comp_rec.actual_end_date),

Line 13329: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',

13325: p_parameterlist => l_parameter_list);
13326: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
13327: p_value => TO_CHAR(l_org_id),
13328: p_parameterlist => l_parameter_list);
13329: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
13330: p_value => TO_CHAR(l_eam_op_comp_rec.actual_end_date),
13331: p_parameterlist => l_parameter_list);
13332: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
13333: p_value => TO_CHAR(l_op_sched_end_date),

Line 13332: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',

13328: p_parameterlist => l_parameter_list);
13329: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
13330: p_value => TO_CHAR(l_eam_op_comp_rec.actual_end_date),
13331: p_parameterlist => l_parameter_list);
13332: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
13333: p_value => TO_CHAR(l_op_sched_end_date),
13334: p_parameterlist => l_parameter_list);
13335: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
13336: p_value => l_is_last_operation,

Line 13335: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',

13331: p_parameterlist => l_parameter_list);
13332: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
13333: p_value => TO_CHAR(l_op_sched_end_date),
13334: p_parameterlist => l_parameter_list);
13335: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
13336: p_value => l_is_last_operation,
13337: p_parameterlist => l_parameter_list);
13338: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
13339: p_value => TO_CHAR(l_workflow_type),

Line 13338: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',

13334: p_parameterlist => l_parameter_list);
13335: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
13336: p_value => l_is_last_operation,
13337: p_parameterlist => l_parameter_list);
13338: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
13339: p_value => TO_CHAR(l_workflow_type),
13340: p_parameterlist => l_parameter_list);
13341: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
13342: p_value =>FND_GLOBAL.USER_NAME ,

Line 13341: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',

13337: p_parameterlist => l_parameter_list);
13338: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
13339: p_value => TO_CHAR(l_workflow_type),
13340: p_parameterlist => l_parameter_list);
13341: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
13342: p_value =>FND_GLOBAL.USER_NAME ,
13343: p_parameterlist => l_parameter_list);
13344:
13345: Wf_Event.Raise( p_event_name => l_op_completed_event,

Line 13345: Wf_Event.Raise( p_event_name => l_op_completed_event,

13341: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
13342: p_value =>FND_GLOBAL.USER_NAME ,
13343: p_parameterlist => l_parameter_list);
13344:
13345: Wf_Event.Raise( p_event_name => l_op_completed_event,
13346: p_event_key => l_event_key,
13347: p_parameters => l_parameter_list);
13348: l_parameter_list.DELETE;
13349: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Operation Completed Event','After raising event');