The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_pkg_name CONSTANT VARCHAR2(100) := 'PO_Mass_Update_Req_GRP';
PROCEDURE Update_Persons(p_update_person IN VARCHAR2,
p_old_personid IN NUMBER,
p_new_personid IN NUMBER,
p_document_type IN VARCHAR2,
p_document_no_from IN VARCHAR2,
p_document_no_to IN VARCHAR2,
p_date_from IN DATE,
p_date_to IN DATE,
p_commit_interval IN NUMBER,
p_msg_data OUT NOCOPY VARCHAR2,
p_msg_count OUT NOCOPY NUMBER,
p_return_status OUT NOCOPY VARCHAR2) IS
l_progress VARCHAR2(3);
l_log_head CONSTANT VARCHAR2(1000) := g_log_head||'Update_Persons';
PO_DEBUG.debug_var(l_log_head,l_progress,'p_update_person',p_update_person );
SAVEPOINT Update_Persons_SP;
PO_Mass_Update_Req_PVT.DO_Update(p_update_person,
p_old_personid,
p_new_personid,
p_document_type,
p_document_no_from,
p_document_no_to,
p_date_from,
p_date_to,
p_commit_interval,
p_msg_data,
p_msg_count,
p_return_status);
PO_DEBUG.debug_var(l_log_head,l_progress,'After Calling Do_Update', 'After Calling Do_Update');
ROLLBACK TO Update_Persons_SP;
END Update_Persons;