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_WORKORDERS_JSP dependencies on EAM_WO_SERVICE_ASSOCIATION

Line 1992: -- if service request is specified then insert into eam_wo_service_association

1988: BEGIN
1989: --if service request
1990: if(p_request_type=2) then
1991:
1992: -- if service request is specified then insert into eam_wo_service_association
1993: if (l_service_request_id is not null) then
1994: select eam_wo_service_association_s.nextval
1995: into l_service_association_id
1996: from dual;

Line 1994: select eam_wo_service_association_s.nextval

1990: if(p_request_type=2) then
1991:
1992: -- if service request is specified then insert into eam_wo_service_association
1993: if (l_service_request_id is not null) then
1994: select eam_wo_service_association_s.nextval
1995: into l_service_association_id
1996: from dual;
1997:
1998: --Assign only one service request to a work order

Line 2002: from eam_wo_service_association

1998: --Assign only one service request to a work order
1999:
2000: select count(*)
2001: into l_row_count
2002: from eam_wo_service_association
2003: where wip_entity_id = l_wip_entity_updt
2004: and (enable_flag IS NULL OR enable_flag = 'Y'); -- Fix for 3773450
2005:
2006: if(l_row_count=0) then

Line 2008: insert into eam_wo_service_association

2004: and (enable_flag IS NULL OR enable_flag = 'Y'); -- Fix for 3773450
2005:
2006: if(l_row_count=0) then
2007:
2008: insert into eam_wo_service_association
2009: (
2010: wo_service_entity_assoc_id
2011: ,maintenance_organization_id
2012: ,wip_entity_id

Line 2040: from eam_wo_service_association

2036: else
2037: if(l_row_count=1) then
2038: select service_request_id
2039: into l_orig_service_request_id
2040: from eam_wo_service_association
2041: where maintenance_organization_id=p_organization_id
2042: and wip_entity_id=l_wip_entity_updt
2043: and (enable_flag IS NULL OR enable_flag='Y'); -- Fix for Bug 3773450
2044:

Line 2321: -- if service request is specified then insert into eam_wo_service_association

2317:
2318: BEGIN
2319: if(p_request_type=2) then
2320:
2321: -- if service request is specified then insert into eam_wo_service_association
2322: if (l_service_request_id is not null) then
2323: select eam_wo_service_association_s.nextval
2324: into l_service_association_id
2325: from dual;

Line 2323: select eam_wo_service_association_s.nextval

2319: if(p_request_type=2) then
2320:
2321: -- if service request is specified then insert into eam_wo_service_association
2322: if (l_service_request_id is not null) then
2323: select eam_wo_service_association_s.nextval
2324: into l_service_association_id
2325: from dual;
2326:
2327: insert into eam_wo_service_association

Line 2327: insert into eam_wo_service_association

2323: select eam_wo_service_association_s.nextval
2324: into l_service_association_id
2325: from dual;
2326:
2327: insert into eam_wo_service_association
2328: (
2329: wo_service_entity_assoc_id
2330: ,maintenance_organization_id
2331: ,wip_entity_id