APPS.EAM_ASSIGN_WORK_PVT dependencies on EAM_WO_SERVICE_ASSOCIATION

Line 89: from eam_wo_service_association

85:
86: If (p_req_type=2) then -- service request
87: select count(1)
88: into l_servicereq_count
89: from eam_wo_service_association
90: where maintenance_organization_id = l_organization_id
91: and wip_entity_id = p_wip_entity_id
92: and (enable_flag IS NULL OR enable_flag = 'Y'); -- Fix for 3773450
93:

Line 99: insert into eam_wo_service_association

95: raise eam_mng_req_assgn_error ;
96: end if ;
97:
98: if (p_req_id is not null) then
99: insert into eam_wo_service_association
100: (wo_service_entity_assoc_id,
101: maintenance_organization_id,
102: wip_entity_id,
103: service_request_id,

Line 128: (eam_wo_service_association_s.nextval,

124: last_updated_by,
125: last_update_date,
126: enable_flag) -- Fix for 3773450
127: values
128: (eam_wo_service_association_s.nextval,
129: l_organization_id,
130: p_wip_entity_id,
131: p_req_id,
132: sysdate,

Line 279: update eam_wo_service_association -- Fix for 3773450

275: if(p_req_type=2) then
276:
277: Begin
278: if (p_req_id is not null) then
279: update eam_wo_service_association -- Fix for 3773450
280: set enable_flag = 'N',
281: last_update_date = sysdate,
282: last_updated_by = FND_GLOBAL.user_id,
283: last_update_login = FND_GLOBAL.login_id