The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_Wip_Entities_rec.last_updated_by := p_old_Wip_Entities_rec.last_updated_by;
IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_Wip_Entities_rec.last_update_date := p_old_Wip_Entities_rec.last_update_date;
IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_Wip_Entities_rec.last_update_login := p_old_Wip_Entities_rec.last_update_login;
IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_Wip_Entities_rec.program_update_date := p_old_Wip_Entities_rec.program_update_date;
IF l_Wip_Entities_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_Wip_Entities_rec.last_updated_by := NULL;
IF l_Wip_Entities_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_Wip_Entities_rec.last_update_date := NULL;
IF l_Wip_Entities_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_Wip_Entities_rec.last_update_login := NULL;
IF l_Wip_Entities_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_Wip_Entities_rec.program_update_date := NULL;
PROCEDURE Update_Row
( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
)
IS
BEGIN
UPDATE WIP_ENTITIES
SET CREATED_BY = p_Wip_Entities_rec.created_by
, CREATION_DATE = p_Wip_Entities_rec.creation_date
, DESCRIPTION = p_Wip_Entities_rec.description
, ENTITY_TYPE = p_Wip_Entities_rec.entity_type
, LAST_UPDATED_BY = p_Wip_Entities_rec.last_updated_by
, LAST_UPDATE_DATE = p_Wip_Entities_rec.last_update_date
, LAST_UPDATE_LOGIN = p_Wip_Entities_rec.last_update_login
, ORGANIZATION_ID = p_Wip_Entities_rec.organization_id
, PRIMARY_ITEM_ID = p_Wip_Entities_rec.primary_item_id
, PROGRAM_APPLICATION_ID = p_Wip_Entities_rec.program_application_id
, PROGRAM_ID = p_Wip_Entities_rec.program_id
, PROGRAM_UPDATE_DATE = p_Wip_Entities_rec.program_update_date
, REQUEST_ID = p_Wip_Entities_rec.request_id
, WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
, WIP_ENTITY_NAME = p_Wip_Entities_rec.wip_entity_name
WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_Wip_Entities_rec IN WIP_Work_Order_PUB.Wip_Entities_Rec_Type
)
IS
BEGIN
INSERT INTO WIP_ENTITIES
( CREATED_BY
, CREATION_DATE
, DESCRIPTION
, ENTITY_TYPE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PRIMARY_ITEM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
)
VALUES
( p_Wip_Entities_rec.created_by
, p_Wip_Entities_rec.creation_date
, p_Wip_Entities_rec.description
, p_Wip_Entities_rec.entity_type
, p_Wip_Entities_rec.last_updated_by
, p_Wip_Entities_rec.last_update_date
, p_Wip_Entities_rec.last_update_login
, p_Wip_Entities_rec.organization_id
, p_Wip_Entities_rec.primary_item_id
, p_Wip_Entities_rec.program_application_id
, p_Wip_Entities_rec.program_id
, p_Wip_Entities_rec.program_update_date
, p_Wip_Entities_rec.request_id
, p_Wip_Entities_rec.wip_entity_id
, p_Wip_Entities_rec.wip_entity_name
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_wip_entity_id IN NUMBER
)
IS
BEGIN
DELETE FROM WIP_ENTITIES
WHERE WIP_ENTITY_ID = p_wip_entity_id
;
, 'Delete_Row'
);
END Delete_Row;
SELECT CREATED_BY
, CREATION_DATE
, DESCRIPTION
, ENTITY_TYPE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PRIMARY_ITEM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
INTO l_Wip_Entities_rec.created_by
, l_Wip_Entities_rec.creation_date
, l_Wip_Entities_rec.description
, l_Wip_Entities_rec.entity_type
, l_Wip_Entities_rec.last_updated_by
, l_Wip_Entities_rec.last_update_date
, l_Wip_Entities_rec.last_update_login
, l_Wip_Entities_rec.organization_id
, l_Wip_Entities_rec.primary_item_id
, l_Wip_Entities_rec.program_application_id
, l_Wip_Entities_rec.program_id
, l_Wip_Entities_rec.program_update_date
, l_Wip_Entities_rec.request_id
, l_Wip_Entities_rec.wip_entity_id
, l_Wip_Entities_rec.wip_entity_name
FROM WIP_ENTITIES
WHERE WIP_ENTITY_ID = p_wip_entity_id
;
SELECT CREATED_BY
, CREATION_DATE
, DESCRIPTION
, ENTITY_TYPE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PRIMARY_ITEM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
INTO l_Wip_Entities_rec.created_by
, l_Wip_Entities_rec.creation_date
, l_Wip_Entities_rec.description
, l_Wip_Entities_rec.entity_type
, l_Wip_Entities_rec.last_updated_by
, l_Wip_Entities_rec.last_update_date
, l_Wip_Entities_rec.last_update_login
, l_Wip_Entities_rec.organization_id
, l_Wip_Entities_rec.primary_item_id
, l_Wip_Entities_rec.program_application_id
, l_Wip_Entities_rec.program_id
, l_Wip_Entities_rec.program_update_date
, l_Wip_Entities_rec.request_id
, l_Wip_Entities_rec.wip_entity_id
, l_Wip_Entities_rec.wip_entity_name
FROM WIP_ENTITIES
WHERE WIP_ENTITY_ID = p_Wip_Entities_rec.wip_entity_id
FOR UPDATE NOWAIT;
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_updated_by,
l_Wip_Entities_rec.last_updated_by)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_date,
l_Wip_Entities_rec.last_update_date)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.last_update_login,
l_Wip_Entities_rec.last_update_login)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.organization_id,
l_Wip_Entities_rec.organization_id)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.primary_item_id,
l_Wip_Entities_rec.primary_item_id)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_application_id,
l_Wip_Entities_rec.program_application_id)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_id,
l_Wip_Entities_rec.program_id)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.program_update_date,
l_Wip_Entities_rec.program_update_date)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.request_id,
l_Wip_Entities_rec.request_id)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_id,
l_Wip_Entities_rec.wip_entity_id)
AND WIP_GLOBALS.Equal(p_Wip_Entities_rec.wip_entity_name,
l_Wip_Entities_rec.wip_entity_name)
THEN
-- Row has not changed. Set out parameter.
x_Wip_Entities_rec := l_Wip_Entities_rec;
FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');