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_SRAPPROVAL_PVT dependencies on WF_EVENT

Line 6: p_event in out NOCOPY wf_event_t

2: /*$Header: EAMVSRAB.pls 120.5 2005/10/11 17:31:27 sraval ship $ */
3:
4: function service_request_created(
5: p_subscription_guid in raw,
6: p_event in out NOCOPY wf_event_t
7: ) return varchar2
8: is
9: L_EVENT_NAME varchar2(240);
10: L_EVENT_KEY varchar2(240);

Line 66: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);

62: l_workflow_process := 'EAMSRAPR_PROCESS';
63:
64:
65: -- get the service request number from the event message
66: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
67: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
68: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
69: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
70:

Line 67: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);

63:
64:
65: -- get the service request number from the event message
66: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
67: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
68: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
69: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
70:
71: -- get the service request id and service request type

Line 68: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);

64:
65: -- get the service request number from the event message
66: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
67: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
68: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
69: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
70:
71: -- get the service request id and service request type
72:

Line 69: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);

65: -- get the service request number from the event message
66: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
67: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
68: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
69: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
70:
71: -- get the service request id and service request type
72:
73: begin

Line 269: wf_event.setErrorInfo(p_event,'WARNING');

265: exception
266: when others then
267: wf_core.context('EAM_SRAPPROVAL_PVT','service_request_created',
268: p_event.getEventName(),p_subscription_guid);
269: wf_event.setErrorInfo(p_event,'WARNING');
270: return 'WARNING';
271:
272: end;
273:

Line 279: p_event in out NOCOPY wf_event_t

275:
276: --
277: function Service_Request_Updated(
278: p_subscription_guid in raw,
279: p_event in out NOCOPY wf_event_t
280: ) return varchar2
281: is
282: L_EVENT_NAME varchar2(240);
283: L_EVENT_KEY varchar2(240);

Line 345: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);

341: itemtype := 'EAMSRAPR';
342: l_sr_api_version := 3.0;
343:
344: -- get the service request number from the event message
345: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
346: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*

Line 346: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);

342: l_sr_api_version := 3.0;
343:
344: -- get the service request number from the event message
345: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
346: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);

Line 347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);

343:
344: -- get the service request number from the event message
345: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
346: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);

Line 348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);

344: -- get the service request number from the event message
345: l_incident_number := wf_event.getValueForParameter('REQUEST_NUMBER',p_event.Parameter_List);
346: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);

Line 350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);

346: l_sr_user_id := wf_event.getValueForParameter('USER_ID',p_event.Parameter_List);
347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);

Line 351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);

347: l_sr_resp_id := wf_event.getValueForParameter('RESP_ID',p_event.Parameter_List);
348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);
355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);

Line 352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);

348: l_sr_resp_appl_id := wf_event.getValueForParameter('RESP_APPL_ID',p_event.Parameter_List);
349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);
355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);
356: l_prev_owner_id := wf_event.getValueForParameter('PREV_OWNER_ID',p_event.Parameter_List);

Line 353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);

349: /*
350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);
355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);
356: l_prev_owner_id := wf_event.getValueForParameter('PREV_OWNER_ID',p_event.Parameter_List);
357: */

Line 354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);

350: l_prev_type_id := wf_event.getValueForParameter('PREV_TYPE_ID',p_event.Parameter_List);
351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);
355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);
356: l_prev_owner_id := wf_event.getValueForParameter('PREV_OWNER_ID',p_event.Parameter_List);
357: */
358: -- get the service request id and service request type

Line 355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);

351: l_prev_severity_id := wf_event.getValueForParameter('PREV_SEVERITY_ID',p_event.Parameter_List);
352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);
355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);
356: l_prev_owner_id := wf_event.getValueForParameter('PREV_OWNER_ID',p_event.Parameter_List);
357: */
358: -- get the service request id and service request type
359: select

Line 356: l_prev_owner_id := wf_event.getValueForParameter('PREV_OWNER_ID',p_event.Parameter_List);

352: l_prev_status_id := wf_event.getValueForParameter('PREV_STATUS_ID',p_event.Parameter_List);
353: l_prev_urgency_id := wf_event.getValueForParameter('PREV_URGENCY_ID',p_event.Parameter_List);
354: l_prev_summary := wf_event.getValueForParameter('PREV_SUMMARY',p_event.Parameter_List);
355: l_request_status_old := wf_event.getValueForParameter('REQUEST_STATUS_OLD',p_event.Parameter_List);
356: l_prev_owner_id := wf_event.getValueForParameter('PREV_OWNER_ID',p_event.Parameter_List);
357: */
358: -- get the service request id and service request type
359: select
360: cia.incident_id,cia.owning_department_id,cia.inventory_item_id,cia.maint_organization_id,

Line 437: wf_event.setErrorInfo(p_event,'WARNING');

433: exception
434: when others then
435: wf_core.context('EAM_SRAPPROVAL_PVT','service_request_updated',
436: p_event.getEventName(),p_subscription_guid);
437: wf_event.setErrorInfo(p_event,'WARNING');
438: return 'ERROR';
439: end;
440:
441: