Broadridge interview question

Explain Stored Procedure in plsql