for example:
PROCEDURE PopulateMsgStatusStart(p_nFeedId NUMBER,
p_nBatchId NUMBER,p_nCategoryId NUMBER,
p_nSessionId NUMBER,
p_sUserName IN NIFM_MSG.USER_NAME%TYPE) IS
PRAGMA AUTONOMOUS_TRANSACTION;
v_nFailedCnt NUMBER;
v_nAllCnt NUMBER;
v_nSuccCnt NUMBER;
v_sMsgStatus NIFM_MSG.STATUS%TYPE;
v_nLogID NUMBER;
BEGIN
......................
END PopulateMsgStatusStart;