The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Declare procedure update_adls.
REQ_LINE_ID IN NUMBER
ERR_CODE IN OUT VARCHAR2,
ERR_MSG IN OUT VARCHAR2
*/
PROCEDURE UPDATE_ADLS(p_req_line_id IN NUMBER,
err_code IN OUT NOCOPY VARCHAR2,
err_msg IN OUT NOCOPY VARCHAR2 ) is
BEGIN
IF gms_install.enabled THEN
gms_po_adl_pkg.update_adls(p_req_line_id => p_req_line_id,
err_code => err_code,
err_msg => err_msg);
END UPDATE_ADLS;