APPS.EAM_WORKORDERS_JSP dependencies on EAM_WO_SERVICE_ASSOCIATION

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

2019: BEGIN
2020: --if service request
2021: if(p_request_type=2) then
2022:
2023: -- if service request is specified then insert into eam_wo_service_association
2024: if (l_service_request_id is not null) then
2025: select eam_wo_service_association_s.nextval
2026: into l_service_association_id
2027: from dual;

Line 2025: select eam_wo_service_association_s.nextval

2021: if(p_request_type=2) then
2022:
2023: -- if service request is specified then insert into eam_wo_service_association
2024: if (l_service_request_id is not null) then
2025: select eam_wo_service_association_s.nextval
2026: into l_service_association_id
2027: from dual;
2028:
2029: --Assign only one service request to a work order

Line 2033: from eam_wo_service_association

2029: --Assign only one service request to a work order
2030:
2031: select count(*)
2032: into l_row_count
2033: from eam_wo_service_association
2034: where wip_entity_id = l_wip_entity_updt
2035: and (enable_flag IS NULL OR enable_flag = 'Y'); -- Fix for 3773450
2036:
2037: if(l_row_count=0) then

Line 2039: insert into eam_wo_service_association

2035: and (enable_flag IS NULL OR enable_flag = 'Y'); -- Fix for 3773450
2036:
2037: if(l_row_count=0) then
2038:
2039: insert into eam_wo_service_association
2040: (
2041: wo_service_entity_assoc_id
2042: ,maintenance_organization_id
2043: ,wip_entity_id

Line 2071: from eam_wo_service_association

2067: else
2068: if(l_row_count=1) then
2069: select service_request_id
2070: into l_orig_service_request_id
2071: from eam_wo_service_association
2072: where maintenance_organization_id=p_organization_id
2073: and wip_entity_id=l_wip_entity_updt
2074: and (enable_flag IS NULL OR enable_flag='Y'); -- Fix for Bug 3773450
2075:

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

2348:
2349: BEGIN
2350: if(p_request_type=2) then
2351:
2352: -- if service request is specified then insert into eam_wo_service_association
2353: if (l_service_request_id is not null) then
2354: select eam_wo_service_association_s.nextval
2355: into l_service_association_id
2356: from dual;

Line 2354: select eam_wo_service_association_s.nextval

2350: if(p_request_type=2) then
2351:
2352: -- if service request is specified then insert into eam_wo_service_association
2353: if (l_service_request_id is not null) then
2354: select eam_wo_service_association_s.nextval
2355: into l_service_association_id
2356: from dual;
2357:
2358: insert into eam_wo_service_association

Line 2358: insert into eam_wo_service_association

2354: select eam_wo_service_association_s.nextval
2355: into l_service_association_id
2356: from dual;
2357:
2358: insert into eam_wo_service_association
2359: (
2360: wo_service_entity_assoc_id
2361: ,maintenance_organization_id
2362: ,wip_entity_id