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 124: l_wf_event_seq NUMBER;

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

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

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

Line 140: INTO l_wf_event_seq

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

Line 146: l_event_key := TO_CHAR(l_wf_event_seq);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

184: OR (p_eam_wo_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UPDATE --workorder updated
185: --and old status is not same as new status
186: 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' )
187: ))
188: AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
189: ) THEN
190: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
191: INTO l_wf_event_seq
192: FROM DUAL;

Line 191: INTO l_wf_event_seq

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

Line 197: l_event_key := TO_CHAR(l_wf_event_seq);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 254: INTO l_wf_event_seq

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

Line 260: l_event_key := TO_CHAR(l_wf_event_seq);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7333: --and old status is not same as new status
7334: AND (l_old_eam_wo_rec.status_type <>l_eam_wo_rec.status_type)
7335: )
7336: ) THEN
7337: IF(WF_EVENT.TEST(l_status_pending_event) <> 'NONE') THEN
7338: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Calling Wkflow required check API...') ; END IF;
7339: EAM_WORKFLOW_DETAILS_PUB.Eam_Wf_Is_Approval_Required(p_old_wo_rec => l_old_eam_wo_rec,
7340: p_new_wo_rec => l_eam_wo_rec,
7341: p_wip_entity_id => NULL,

Line 11046: l_wf_event_seq NUMBER;

11042: l_workflow_type NUMBER;
11043: l_event_name VARCHAR2(240);
11044: l_parameter_list wf_parameter_list_t;
11045: l_event_key VARCHAR2(200);
11046: l_wf_event_seq NUMBER;
11047: l_cost_estimate NUMBER;
11048: l_asset_instance_number VARCHAR2(30);
11049: l_instance_id NUMBER;
11050:

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

11261: END IF;
11262:
11263:
11264: IF(l_workflow_enabled='Y' AND l_eam_wo_comp_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE
11265: AND (WF_EVENT.TEST(l_status_pending_event) <> 'NONE') )THEN
11266: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking WF Approval mandatory . . . '); END IF;
11267: EAM_WORKFLOW_DETAILS_PUB.Eam_Wf_Is_Approval_Required(p_old_wo_rec => NULL,
11268: p_new_wo_rec => NULL,
11269: p_wip_entity_id => l_eam_wo_comp_rec.wip_entity_id,

Line 11303: INTO l_wf_event_seq

11299: END;
11300:
11301:
11302: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
11303: INTO l_wf_event_seq
11304: FROM DUAL;
11305:
11306: l_parameter_list := wf_parameter_list_t();
11307: l_event_name := l_status_pending_event;

Line 11309: l_event_key := TO_CHAR(l_wf_event_seq);

11305:
11306: l_parameter_list := wf_parameter_list_t();
11307: l_event_name := l_status_pending_event;
11308:
11309: l_event_key := TO_CHAR(l_wf_event_seq);
11310:
11311:
11312: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inserting into EAM_WO_WORKFLOWS ...'); END IF;
11313: INSERT INTO EAM_WO_WORKFLOWS

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

11320:
11321:
11322: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released change event','Building parameter list');
11323: -- Add Parameters
11324: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
11325: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
11326: p_parameterlist => l_parameter_list);
11327: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
11328: p_value =>l_wip_entity_name,

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

11323: -- Add Parameters
11324: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
11325: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
11326: p_parameterlist => l_parameter_list);
11327: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
11328: p_value =>l_wip_entity_name,
11329: p_parameterlist => l_parameter_list);
11330: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
11331: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),

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

11326: p_parameterlist => l_parameter_list);
11327: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
11328: p_value =>l_wip_entity_name,
11329: p_parameterlist => l_parameter_list);
11330: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
11331: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
11332: p_parameterlist => l_parameter_list);
11333: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
11334: p_value =>TO_CHAR(l_new_eam_status) ,

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

11329: p_parameterlist => l_parameter_list);
11330: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
11331: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
11332: p_parameterlist => l_parameter_list);
11333: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
11334: p_value =>TO_CHAR(l_new_eam_status) ,
11335: p_parameterlist => l_parameter_list);
11336: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
11337: p_value => TO_CHAR(l_old_system_status),

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

11332: p_parameterlist => l_parameter_list);
11333: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
11334: p_value =>TO_CHAR(l_new_eam_status) ,
11335: p_parameterlist => l_parameter_list);
11336: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
11337: p_value => TO_CHAR(l_old_system_status),
11338: p_parameterlist => l_parameter_list);
11339: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
11340: p_value => TO_CHAR(l_old_eam_status),

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

11335: p_parameterlist => l_parameter_list);
11336: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
11337: p_value => TO_CHAR(l_old_system_status),
11338: p_parameterlist => l_parameter_list);
11339: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
11340: p_value => TO_CHAR(l_old_eam_status),
11341: p_parameterlist => l_parameter_list);
11342: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
11343: p_value => TO_CHAR(l_new_system_status),

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

11338: p_parameterlist => l_parameter_list);
11339: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
11340: p_value => TO_CHAR(l_old_eam_status),
11341: p_parameterlist => l_parameter_list);
11342: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
11343: p_value => TO_CHAR(l_new_system_status),
11344: p_parameterlist => l_parameter_list);
11345: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11346: p_value => TO_CHAR(l_workflow_type),

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

11341: p_parameterlist => l_parameter_list);
11342: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
11343: p_value => TO_CHAR(l_new_system_status),
11344: p_parameterlist => l_parameter_list);
11345: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11346: p_value => TO_CHAR(l_workflow_type),
11347: p_parameterlist => l_parameter_list);
11348: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11349: p_value =>FND_GLOBAL.USER_NAME ,

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

11344: p_parameterlist => l_parameter_list);
11345: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
11346: p_value => TO_CHAR(l_workflow_type),
11347: p_parameterlist => l_parameter_list);
11348: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11349: p_value =>FND_GLOBAL.USER_NAME ,
11350: p_parameterlist => l_parameter_list);
11351: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11352: p_value => l_workflow_name,

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

11347: p_parameterlist => l_parameter_list);
11348: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
11349: p_value =>FND_GLOBAL.USER_NAME ,
11350: p_parameterlist => l_parameter_list);
11351: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11352: p_value => l_workflow_name,
11353: p_parameterlist => l_parameter_list);
11354: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
11355: p_value => l_workflow_process,

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

11350: p_parameterlist => l_parameter_list);
11351: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_NAME',
11352: p_value => l_workflow_name,
11353: p_parameterlist => l_parameter_list);
11354: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
11355: p_value => l_workflow_process,
11356: p_parameterlist => l_parameter_list);
11357: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
11358: p_value => TO_CHAR(l_cost_estimate),

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

11353: p_parameterlist => l_parameter_list);
11354: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_PROCESS',
11355: p_value => l_workflow_process,
11356: p_parameterlist => l_parameter_list);
11357: Wf_Event.AddParameterToList(p_name =>'ESTIMATED_COST',
11358: p_value => TO_CHAR(l_cost_estimate),
11359: p_parameterlist => l_parameter_list);
11360: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
11361:

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

11358: p_value => TO_CHAR(l_cost_estimate),
11359: p_parameterlist => l_parameter_list);
11360: Wf_Core.Context('Enterprise Asset Management...','Work Order Released Event','Raising event');
11361:
11362: Wf_Event.Raise( p_event_name => l_event_name,
11363: p_event_key => l_event_key,
11364: p_parameters => l_parameter_list);
11365: l_parameter_list.DELETE;
11366: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Released Event','After raising event');

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

12030: end;
12031: END IF;
12032: --Raise status changed event when a workorder is completed/uncompleted
12033:
12034: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
12035: ) THEN
12036:
12037: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12038: INTO l_wf_event_seq

Line 12038: INTO l_wf_event_seq

12034: IF(l_workflow_enabled='Y' AND (WF_EVENT.TEST(l_status_changed_event) <> 'NONE') --if status change event enabled
12035: ) THEN
12036:
12037: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12038: INTO l_wf_event_seq
12039: FROM DUAL;
12040:
12041: l_parameter_list := wf_parameter_list_t();
12042: l_event_name := l_status_changed_event;

Line 12044: l_event_key := TO_CHAR(l_wf_event_seq);

12040:
12041: l_parameter_list := wf_parameter_list_t();
12042: l_event_name := l_status_changed_event;
12043:
12044: l_event_key := TO_CHAR(l_wf_event_seq);
12045: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
12046: -- Add Parameters
12047: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12048: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),

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

12043:
12044: l_event_key := TO_CHAR(l_wf_event_seq);
12045: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status change event','Building parameter list');
12046: -- Add Parameters
12047: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12048: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
12049: p_parameterlist => l_parameter_list);
12050: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12051: p_value =>l_wip_entity_name,

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

12046: -- Add Parameters
12047: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12048: p_value => TO_CHAR(l_eam_wo_comp_rec.wip_entity_id),
12049: p_parameterlist => l_parameter_list);
12050: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12051: p_value =>l_wip_entity_name,
12052: p_parameterlist => l_parameter_list);
12053: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12054: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),

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

12049: p_parameterlist => l_parameter_list);
12050: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12051: p_value =>l_wip_entity_name,
12052: p_parameterlist => l_parameter_list);
12053: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12054: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
12055: p_parameterlist => l_parameter_list);
12056: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
12057: p_value => TO_CHAR(l_new_system_status),

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

12052: p_parameterlist => l_parameter_list);
12053: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12054: p_value => TO_CHAR(l_eam_wo_comp_rec.organization_id),
12055: p_parameterlist => l_parameter_list);
12056: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
12057: p_value => TO_CHAR(l_new_system_status),
12058: p_parameterlist => l_parameter_list);
12059: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
12060: p_value => TO_CHAR(l_new_eam_status),

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

12055: p_parameterlist => l_parameter_list);
12056: Wf_Event.AddParameterToList(p_name =>'NEW_SYSTEM_STATUS',
12057: p_value => TO_CHAR(l_new_system_status),
12058: p_parameterlist => l_parameter_list);
12059: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
12060: p_value => TO_CHAR(l_new_eam_status),
12061: p_parameterlist => l_parameter_list);
12062: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
12063: p_value => TO_CHAR(l_old_system_status),

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

12058: p_parameterlist => l_parameter_list);
12059: Wf_Event.AddParameterToList(p_name =>'NEW_WO_STATUS',
12060: p_value => TO_CHAR(l_new_eam_status),
12061: p_parameterlist => l_parameter_list);
12062: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
12063: p_value => TO_CHAR(l_old_system_status),
12064: p_parameterlist => l_parameter_list);
12065: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
12066: p_value => TO_CHAR(l_old_eam_status),

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

12061: p_parameterlist => l_parameter_list);
12062: Wf_Event.AddParameterToList(p_name =>'OLD_SYSTEM_STATUS',
12063: p_value => TO_CHAR(l_old_system_status),
12064: p_parameterlist => l_parameter_list);
12065: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
12066: p_value => TO_CHAR(l_old_eam_status),
12067: p_parameterlist => l_parameter_list);
12068: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12069: p_value => TO_CHAR(l_workflow_type),

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

12064: p_parameterlist => l_parameter_list);
12065: Wf_Event.AddParameterToList(p_name =>'OLD_WO_STATUS',
12066: p_value => TO_CHAR(l_old_eam_status),
12067: p_parameterlist => l_parameter_list);
12068: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12069: p_value => TO_CHAR(l_workflow_type),
12070: p_parameterlist => l_parameter_list);
12071: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12072: p_value =>FND_GLOBAL.USER_NAME ,

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

12067: p_parameterlist => l_parameter_list);
12068: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12069: p_value => TO_CHAR(l_workflow_type),
12070: p_parameterlist => l_parameter_list);
12071: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12072: p_value =>FND_GLOBAL.USER_NAME ,
12073: p_parameterlist => l_parameter_list);
12074: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
12075:

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

12072: p_value =>FND_GLOBAL.USER_NAME ,
12073: p_parameterlist => l_parameter_list);
12074: Wf_Core.Context('Enterprise Asset Management...','Work Order Staus Changed Event','Raising event');
12075:
12076: Wf_Event.Raise( p_event_name => l_event_name,
12077: p_event_key => l_event_key,
12078: p_parameters => l_parameter_list);
12079: l_parameter_list.DELETE;
12080: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Status Changed Event','After raising event');

Line 12286: l_wf_event_seq NUMBER;

12282: l_workflow_type NUMBER;
12283: l_is_last_operation VARCHAR2(1);
12284: l_parameter_list wf_parameter_list_t;
12285: l_event_key VARCHAR2(200);
12286: l_wf_event_seq NUMBER;
12287: l_op_sched_end_date DATE;
12288: l_asset_instance_number VARCHAR2(30);
12289:
12290: BEGIN

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

12622:
12623:
12624:
12625: IF(l_workflow_enabled='Y' AND (l_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE)
12626: AND (Wf_Event.TEST(l_op_completed_event)<>'NONE' ) ) THEN
12627:
12628: SELECT last_unit_completion_date
12629: INTO l_op_sched_end_date
12630: FROM WIP_OPERATIONS

Line 12642: INTO l_wf_event_seq

12638: where won.wip_entity_id = l_eam_op_comp_rec.wip_entity_id and
12639: won.prior_operation = l_eam_op_comp_rec.operation_seq_num;
12640:
12641: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
12642: INTO l_wf_event_seq
12643: FROM DUAL;
12644:
12645: l_parameter_list := wf_parameter_list_t();
12646:

Line 12647: l_event_key := TO_CHAR(l_wf_event_seq);

12643: FROM DUAL;
12644:
12645: l_parameter_list := wf_parameter_list_t();
12646:
12647: l_event_key := TO_CHAR(l_wf_event_seq);
12648: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Op Completed event','Building parameter list');
12649: -- Add Parameters
12650: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12651: p_value => TO_CHAR( l_eam_op_comp_rec.wip_entity_id),

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

12646:
12647: l_event_key := TO_CHAR(l_wf_event_seq);
12648: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Op Completed event','Building parameter list');
12649: -- Add Parameters
12650: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12651: p_value => TO_CHAR( l_eam_op_comp_rec.wip_entity_id),
12652: p_parameterlist => l_parameter_list);
12653: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12654: p_value =>l_wip_entity_name,

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

12649: -- Add Parameters
12650: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_ID',
12651: p_value => TO_CHAR( l_eam_op_comp_rec.wip_entity_id),
12652: p_parameterlist => l_parameter_list);
12653: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12654: p_value =>l_wip_entity_name,
12655: p_parameterlist => l_parameter_list);
12656: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12657: p_value => TO_CHAR(l_org_id),

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

12652: p_parameterlist => l_parameter_list);
12653: Wf_Event.AddParameterToList(p_name =>'WIP_ENTITY_NAME',
12654: p_value =>l_wip_entity_name,
12655: p_parameterlist => l_parameter_list);
12656: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12657: p_value => TO_CHAR(l_org_id),
12658: p_parameterlist => l_parameter_list);
12659: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
12660: p_value => TO_CHAR(l_eam_op_comp_rec.actual_end_date),

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

12655: p_parameterlist => l_parameter_list);
12656: Wf_Event.AddParameterToList(p_name =>'ORGANIZATION_ID',
12657: p_value => TO_CHAR(l_org_id),
12658: p_parameterlist => l_parameter_list);
12659: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
12660: p_value => TO_CHAR(l_eam_op_comp_rec.actual_end_date),
12661: p_parameterlist => l_parameter_list);
12662: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
12663: p_value => TO_CHAR(l_op_sched_end_date),

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

12658: p_parameterlist => l_parameter_list);
12659: Wf_Event.AddParameterToList(p_name =>'ACTUAL_COMPLETION_DATE',
12660: p_value => TO_CHAR(l_eam_op_comp_rec.actual_end_date),
12661: p_parameterlist => l_parameter_list);
12662: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
12663: p_value => TO_CHAR(l_op_sched_end_date),
12664: p_parameterlist => l_parameter_list);
12665: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
12666: p_value => l_is_last_operation,

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

12661: p_parameterlist => l_parameter_list);
12662: Wf_Event.AddParameterToList(p_name =>'SCHEDULED_COMPLETION_DATE',
12663: p_value => TO_CHAR(l_op_sched_end_date),
12664: p_parameterlist => l_parameter_list);
12665: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
12666: p_value => l_is_last_operation,
12667: p_parameterlist => l_parameter_list);
12668: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12669: p_value => TO_CHAR(l_workflow_type),

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

12664: p_parameterlist => l_parameter_list);
12665: Wf_Event.AddParameterToList(p_name =>'IS_LAST_OPERATION',
12666: p_value => l_is_last_operation,
12667: p_parameterlist => l_parameter_list);
12668: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12669: p_value => TO_CHAR(l_workflow_type),
12670: p_parameterlist => l_parameter_list);
12671: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12672: p_value =>FND_GLOBAL.USER_NAME ,

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

12667: p_parameterlist => l_parameter_list);
12668: Wf_Event.AddParameterToList(p_name =>'WORKFLOW_TYPE',
12669: p_value => TO_CHAR(l_workflow_type),
12670: p_parameterlist => l_parameter_list);
12671: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12672: p_value =>FND_GLOBAL.USER_NAME ,
12673: p_parameterlist => l_parameter_list);
12674:
12675: Wf_Event.Raise( p_event_name => l_op_completed_event,

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

12671: Wf_Event.AddParameterToList(p_name =>'REQUESTOR',
12672: p_value =>FND_GLOBAL.USER_NAME ,
12673: p_parameterlist => l_parameter_list);
12674:
12675: Wf_Event.Raise( p_event_name => l_op_completed_event,
12676: p_event_key => l_event_key,
12677: p_parameters => l_parameter_list);
12678: l_parameter_list.DELETE;
12679: WF_CORE.CONTEXT('Enterprise Asset Management...','Work Order Operation Completed Event','After raising event');