The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_updated_by IN NUMBER,
p_last_update_date IN DATE,
p_last_update_login IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Create_Resp_Sec_Attr';
p_last_updated_by => p_last_updated_by ,
p_last_update_date => p_last_update_date ,
p_last_update_login => p_last_update_login
);
PROCEDURE Delete_Resp_Sec_Attr
( p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_simulate IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_return_status OUT VARCHAR2,
p_msg_count OUT NUMBER,
p_msg_data OUT VARCHAR2,
-- p_msg_entity OUT VARCHAR2,
-- p_msg_entity_index OUT NUMBER,
p_responsibility_id IN NUMBER,
p_application_id IN NUMBER,
p_attribute_code IN VARCHAR2,
p_attribute_appl_id IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_Resp_Sec_Attr';
SAVEPOINT Delete_Resp_Sec_Attr_PUB;
ICX_Resp_Sec_Attr_PVT.Delete_Resp_Sec_Attr
(
p_api_version_number => p_api_version_number ,
p_init_msg_list => p_init_msg_list ,
p_simulate => p_simulate ,
p_commit => p_commit ,
p_validation_level => p_validation_level ,
p_return_status => l_return_status ,
p_msg_count => p_msg_count ,
p_msg_data => p_msg_data ,
-- p_msg_entity => p_msg_entity ,
-- p_msg_entity_index => p_msg_entity_index ,
p_responsibility_id => p_responsibility_id ,
p_application_id => p_application_id ,
p_attribute_code => p_attribute_code ,
p_attribute_appl_id => p_attribute_appl_id
);
ROLLBACK to Delete_Resp_Sec_Attr_PUB;
Rollback to Delete_Resp_Sec_Attr_PUB;
Rollback to Delete_Resp_Sec_Attr_PUB;
Rollback to Delete_Resp_Sec_Attr_PUB;
end Delete_Resp_Sec_Attr;