793: ELSE
794: SELECT COUNT(*) INTO l_temp FROM XNP_MSGS
795: WHERE order_id = p_order_id
796: AND msg_code IN
797: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B
798: WHERE PROTECTED_FLAG='Y');
799: END IF;
800:
801: RECORDS_PURGED_MSGS(l_temp,'XNP_MSGS WHERE ORDER_ID = '||p_order_id
832: ELSE
833: DELETE FROM XNP_MSGS
834: WHERE order_id = p_order_id
835: AND msg_code IN
836: (SELECT MSG_CODE FROM XNP_MSG_TYPES_B
837: WHERE PROTECTED_FLAG='Y');
838: END IF;
839:
840: DELETE FROM XNP_CALLBACK_EVENTS