The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW
( p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_request_rec_type
, x_return_status OUT NOCOPY VARCHAR2
, x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
)
IS
BEGIN
IF p_eam_request_rec.request_type = 1 THEN
UPDATE WIP_EAM_WORK_REQUESTS
SET
wip_entity_id = p_eam_request_rec.wip_entity_id,
work_request_status_id = 4,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = fnd_global.login_id
WHERE work_request_id = p_eam_request_rec.request_id
AND organization_id = p_eam_request_rec.organization_id;
INSERT INTO EAM_WO_SERVICE_ASSOCIATION
( wo_service_entity_assoc_id,
maintenance_organization_id,
wip_entity_id,
service_request_id,
creation_date,
created_by,
last_update_login,
program_id,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category,
last_updated_by,
last_update_date,
enable_flag) -- Fix for 3773450
VALUES
( p_eam_request_rec.SERVICE_ASSOC_ID,
p_eam_request_rec.organization_id,
p_eam_request_rec.wip_entity_id,
p_eam_request_rec.request_id,
sysdate,
FND_GLOBAL.USER_ID,
FND_GLOBAL.LOGIN_ID,
null,--fnd_global.conc_program_id,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
fnd_global.user_id,
sysdate,
'Y'); -- Fix for 3773450
END INSERT_ROW;
PROCEDURE DELETE_ROW
( p_eam_request_rec IN EAM_PROCESS_WO_PUB.eam_request_rec_type
, x_return_status OUT NOCOPY VARCHAR2
, x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
)
IS
BEGIN
IF p_eam_request_rec.request_type = 1 THEN
UPDATE WIP_EAM_WORK_REQUESTS
SET wip_entity_id = null,
work_request_status_id = 3,
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.user_id
WHERE work_request_id = p_eam_request_rec.request_id
AND organization_id = p_eam_request_rec.organization_id;
UPDATE EAM_WO_SERVICE_ASSOCIATION -- Fix for 3773450
SET enable_flag = 'N',
last_update_date = sysdate,
last_updated_by = FND_GLOBAL.user_id,
last_update_login = FND_GLOBAL.login_id
WHERE service_request_id = p_eam_request_rec.request_id
AND wip_entity_id = p_eam_request_rec.wip_entity_id
AND maintenance_organization_id = p_eam_request_rec.organization_id
AND (enable_flag IS NULL or enable_flag = 'Y');
END DELETE_ROW;
select
'Y'
INTO
l_attachment_exists
from
fnd_attached_documents fad
where
fad.entity_name = 'EAM_WORK_REQUESTS' and
fad.pk1_value = to_char(p_eam_request_rec.request_id) and
rownum<2;
X_last_update_login => '',
X_program_application_id=> '',
X_program_id => '',
X_request_id => ''
);