34:
35: CURSOR msg_cursor is
36: SELECT *
37: FROM
38: IEU_MSG_MESSAGES message_table
39: WHERE
40: message_table.RESOURCE_TYPE = 'RS_INDIVIDUAL' AND
41: message_table.RESOURCE_ID = P_RESOURCE_ID AND
42: message_table.STATUS_ID <= P_STATUS_ID;
127:
128: --save the updated message
129: FOR i IN P_CTRL_MESSAGES_NST.FIRST..P_CTRL_MESSAGES_NST.LAST
130: LOOP
131: UPDATE IEU_MSG_MESSAGES SET
132: IEU_MSG_MESSAGES.STATUS_ID = P_CTRL_MESSAGES_NST(i).STATUS_ID,
133: IEU_MSG_MESSAGES.LAST_UPDATE_DATE = SYSDATE
134: WHERE P_CTRL_MESSAGES_NST(i).MESSAGE_ID =
135: IEU_MSG_MESSAGES.MESSAGE_ID;
128: --save the updated message
129: FOR i IN P_CTRL_MESSAGES_NST.FIRST..P_CTRL_MESSAGES_NST.LAST
130: LOOP
131: UPDATE IEU_MSG_MESSAGES SET
132: IEU_MSG_MESSAGES.STATUS_ID = P_CTRL_MESSAGES_NST(i).STATUS_ID,
133: IEU_MSG_MESSAGES.LAST_UPDATE_DATE = SYSDATE
134: WHERE P_CTRL_MESSAGES_NST(i).MESSAGE_ID =
135: IEU_MSG_MESSAGES.MESSAGE_ID;
136: END LOOP;
129: FOR i IN P_CTRL_MESSAGES_NST.FIRST..P_CTRL_MESSAGES_NST.LAST
130: LOOP
131: UPDATE IEU_MSG_MESSAGES SET
132: IEU_MSG_MESSAGES.STATUS_ID = P_CTRL_MESSAGES_NST(i).STATUS_ID,
133: IEU_MSG_MESSAGES.LAST_UPDATE_DATE = SYSDATE
134: WHERE P_CTRL_MESSAGES_NST(i).MESSAGE_ID =
135: IEU_MSG_MESSAGES.MESSAGE_ID;
136: END LOOP;
137:
131: UPDATE IEU_MSG_MESSAGES SET
132: IEU_MSG_MESSAGES.STATUS_ID = P_CTRL_MESSAGES_NST(i).STATUS_ID,
133: IEU_MSG_MESSAGES.LAST_UPDATE_DATE = SYSDATE
134: WHERE P_CTRL_MESSAGES_NST(i).MESSAGE_ID =
135: IEU_MSG_MESSAGES.MESSAGE_ID;
136: END LOOP;
137:
138: EXCEPTION
139: WHEN OTHERS THEN