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
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