[Home] [Help]
1198: -- adabholk 03/2001
1199: -- performance changes
1200: -- Use of RETURNING
1201:
1202: INSERT INTO XNP_MSG_ELEMENTS(
1203: MSG_ELEMENT_ID
1204: ,MSG_CODE
1205: ,NAME
1206: ,ELEMENT_DATATYPE
1211: ,LAST_UPDATED_BY
1212: ,LAST_UPDATE_DATE
1213: ,LAST_UPDATE_LOGIN)
1214: VALUES(
1215: XNP_MSG_ELEMENTS_S.NEXTVAL
1216: ,P_MSG_CODE
1217: ,'MESSAGE' -- Always insert type to be 'Message' - even though it can be an event or a timer
1218: ,'VARCHAR2'
1219: ,'Y'
1230: -- adabholk 03/2001
1231: -- performance changes
1232: -- Use of RETURNING
1233:
1234: INSERT INTO XNP_MSG_ELEMENTS(
1235: MSG_ELEMENT_ID
1236: ,MSG_CODE
1237: ,NAME
1238: ,ELEMENT_DATATYPE
1244: ,LAST_UPDATE_DATE
1245: ,LAST_UPDATE_LOGIN
1246: )
1247: VALUES(
1248: XNP_MSG_ELEMENTS_S.NEXTVAL
1249: ,P_MSG_CODE
1250: ,P_MSG_CODE
1251: ,'VARCHAR2'
1252: ,'Y'
1296: -- adabholk 03/2001
1297: -- performance changes
1298: -- Use of RETURNING
1299:
1300: INSERT INTO XNP_MSG_ELEMENTS(
1301: MSG_ELEMENT_ID
1302: ,MSG_CODE
1303: ,NAME
1304: ,ELEMENT_DATATYPE
1311: ,LAST_UPDATE_DATE
1312: ,LAST_UPDATE_LOGIN
1313: )
1314: VALUES(
1315: XNP_MSG_ELEMENTS_S.NEXTVAL
1316: ,P_MSG_CODE
1317: ,'DELAY'
1318: ,'NUMBER'
1319: ,'0'
1361: -- adabholk 03/2001
1362: -- performance changes
1363: -- Use of RETURNING
1364:
1365: INSERT INTO XNP_MSG_ELEMENTS(
1366: MSG_ELEMENT_ID
1367: ,MSG_CODE
1368: ,NAME
1369: ,ELEMENT_DATATYPE
1376: ,LAST_UPDATE_DATE
1377: ,LAST_UPDATE_LOGIN
1378: )
1379: VALUES(
1380: XNP_MSG_ELEMENTS_S.NEXTVAL
1381: ,P_MSG_CODE
1382: ,'INTERVAL'
1383: ,'NUMBER'
1384: ,'0'
1792:
1793: DELETE FROM xnp_msg_structures
1794: WHERE msg_code = p_msg_code;
1795:
1796: DELETE FROM xnp_msg_elements
1797: WHERE MSG_CODE = p_msg_code;
1798:
1799: DELETE FROM xnp_msg_acks
1800: WHERE source_msg_code = p_msg_code